Jump to content

wolstech

Chief Risk Officer
  • Posts

    16,333
  • Joined

  • Last visited

  • Days Won

    578

Everything posted by wolstech

  1. Your remote mysql may need to be set up again. Remove your host entries in cPanel and re-add them to see if it makes a difference. The inaccessible table (probably showing as "in use") likely used InnoDB, which is currently not supported. Until that support is restored, you won't be able to do much with that table (I think you can drop it, but odds are you're not trying to do that if you need access to it).
  2. Change your password here: http://stevie.heliohost.org:2082/frontend/x3/passwd/index.html Then log out, and clear your cache. After that, try PhpMyAdmin again. Very often the reason it won't work because the mysql and cpanel password got out of sync. The blank page can occur for this reason, or also if there is high load on Stevie. It's working fine for me right now.
  3. Delete your database user, then recreate it and reassign it to the database.
  4. It did get updated...sort of. cPanel went from 11.38 -> 11.42, MySQL went from 5.1.68 to 5.1.73. As a result, everyone's database users broke, their password needs to be changed to fix PhpMyAdmin, and InnoDB support was dropped entirely (whether intentional or not, I don't know).
  5. I'm not sure why this won't unsuspend. It is showing as active in the system. Escalating.
  6. You need to delete the user for your website's database in cpanel, recreate it, then reassociate it with the database. If you have issues accessing PHPMyAdmin, you will also need to change your password.
  7. Change your password through cPanel here: http://stevie.heliohost.org:2082/frontend/x3/passwd/index.html After that, log out then back in and try PhpMyAdmin again. For database users you created in cPanel, you may need to delete and recreate them before they work.
  8. Did you recently renew it for inactivity? I've been noticing that ever since the upgrade on Stevie, accounts can take a while to fully unsuspend. It shows as suspended for me as well. If it's still not working by tomorrow night, I'll escalate this for you.
  9. cPanel's restore tool can do that sometimes. I'm assuming you have a .sql file. Try this: Create an empty database in cPanel. After creation, open PHPMyAdmin, and navigate to that new database. Use the Import tab to restore the backup into the new database (might take some time after you select the file). Verify the contents of the database are correct.
  10. You cannot move just one email address except for forwarding as Ice IT suggested. To properly use the new service, you probably need to change your MX records to whatever Google wants. They should provide directions what you need your MX records to be set to, and there may be some TXT records as well. The exact values will need to come from Google. As for the 50/day limit we have, Krydos might increase that if you ask (and agree not to send bulk mail). I know people have asked before and gotten it raised. If you want, I can escalate this and see if that's possible instead.
  11. You don't mention a specific error, but I'll assume it's InnoDB related since most issues for backups failing to restore are. Make a copy of the backup, then open the copy in a text editor and do a find and replace in your backup, replace all ENGINE=InnoDB with ENGINE=MyISAM After that, save, and try to restore the edited version. Stevie currently does not support the InnoDB engine.
  12. Most that needed to use their sites converted to MyISAM in the 18 months it was broken. You should do the same. I don't know when or if InnoDB will be restored.
  13. You might be blocked, especially if you use FTP heavily. Also, you mention cron...just be aware that you can't run more than 2 crons a day. If you set a cron for every hour, you'll get suspended by the system. Moving to customer service.
  14. It didn't fix the problem. It's part of a fix that I don't think is fully implemented yet. On the upside, with it entirely disabled, MySQL shouldn't crash so much because you can't even do stuff like try to create innodb tables. It just errors saying unknown engine instead of crashing the server.
  15. wolstech

    Mysql Ip

    Delete the database user and recreate it. A lot of database users got lost in the recent update it seems.
  16. wolstech

    Mysql Ip

    For software running on Johnny, use localhost to access MySQL. For remote connections, enable the remote access in cPanel, then use johnny.heliohost.org as the host.
  17. The Access Denied errors seen on websites are fixable by deleting and recreating the database user. Be sure to reassign it to the database after deleting and recreating it. PhpMyAdmin and your cPanel MySQL account are still broken though (sometimes changing your password will fix these, but it did not when I tried it).
  18. The Access Denied is fixable by deleting and recreating the database user. Be sure to reassign it to the database after deleting and recreating it.
  19. These seem to be fixable by deleting and recreating the database user. Be sure to reassign it to the database after deleting and recreating it.
  20. It was indeed dead database users. I deleted mine and recreated them and they work. Still doesn't explain PHPMyAdmin though...
  21. Doesn't seem to be up. All my sites are still showing the access denied error and I can't even get into phpmyadmin. InnoDB was turned off a week or so ago, before this issue happened. InnoDB tables all show as "in use" now, and imports will fail with "unknown engine" as opposed to ghost tables.
  22. Give it 24 hours then clear your cache. If it's still suspended after that, please let us know.
  23. It appears to be a botched update, though at least one other user reported speaking to Krydos on IRC and who said he was unaware anything was updated (confused there, he's the only one who does this stuff). I've yet to hear anything official on this...nothing has been said to staff either. :-\
  24. There's a lot of users on Stevie with this issue. I'm affected too There's been no information on this issue, even internally to the mods. I'm hoping it gets fixed soon. Moving to customer service.
×
×
  • Create New...