JpTiger

Hunh. As a matter of fact, my database does appear to be missing. I'm looking for jptiger_jrpwp, but all I see is information_schema. Something I can do on my end to fix that?

Sorry to ask for this again, not only is it the second time I've had this happen, but it looks from the forums like a ton of people are having the same issue. Catch is, what fixed it last time isn't working this time.

It's pretty simple. I have the domain joelrputnam.com pointed at my heliohost account. If you visit on Firefox you get an error establishing a database connection. So I followed the steps from last time:

1. Log into your cpanel, and change your cpanel password (you can even change it back immediately after if you like)

2. Log into the MyPHPAdmin (cpanel credentials) to make sure it's now working.

3. Go to your MySQL admin panel in cpanel, note down which users have privleges to which databasses. You're going to be deleting and recreating all of these users next, so get their passwords if you can easily do so.

3a. If you're using WordPress and don't know where to find the passwords to the MySQL users, check the root of your WP folder for something called wp-config.php-- it'll have the username and password for that installation.

4. Delete the users, and recreate them exactly using the same passwords and at least the same privileges.

But after all that, while I can now access phpMyAdmin again, I still get "error establishing database connection" when I go to the site, across multiple machines. Any ideas? This time it's my account under jptiger on Stevie instead of the one I have on Johnny referenced in the thread linked above, don't know if that makes a difference...

Just updating to say still solved, but the problem reoccurred on my regular account on Stevie this time. Same fix worked. I'll update my original post with the fix since from topic titles, it looks like this is affecting a lot of people.

Gah, Krydos was right and I didn't read his message properly, wasn't until I reread wolstech's reply that I realized my mistake--- I'd been trying to change passwords on my MySQL users, not my Cpanel login. Should've followed the link Krydos posted instead of using the window I already had open. After that, Tjoene was right, I needed to re-create my mysql users. All things now working, please mark as solved.

Thank you everyone!

No dice. "Although the system’s database map includes a MySQL user named “jptsndbx_root”, the MySQL server reported that no user with this name exists. Contact your system administrator."

Same error message for all other database users when I try to change their passwords.

It actually seems like myphpadmin doesn't even get to the login validation stage. I tried using garbage usernames and passwords and I still just get a blank screen.

Glad to hear the contents are still there, though, because here's what I'm seeing:

Thanks. Yeah, just tried on a different PC on a different operating system and using a different browser. Same errors on all counts.

If the database is gone, I'm okay just wiping everything and starting over. But if there's a reasonable chance to recover it, that would save me a lot of time and trouble. What do you guys think?

Thank you! I'm still having trouble though. I still can't access the database. Logging in through phpmyadmin yields a blank page.

More worryingly though, on the mysql databases panel in Cpanel, all the databases are now listed as 0.00MB in size. Did they get wiped out somehow? None of the data was valuable, but if it's gone and there's a way to recover it, I'd appreciate a way to try.

All databases starting with "jptsndbx"

Full list is:

jptsndbx_pjl

jptsndbx_wiki

jptsndbx_wp1

jptsndbx_wp2

jptsndbx_wp3

Thank you! I know this is an all-volunteer service and that you've got lives and other things on your plate, but any idea of a timeline for when I should expect this to be addressed?

Hey, I hope this doesn't seem pushy but it's been one month since I posted this and I still haven't gotten a response. Any ideas?

Hi there, my cpanel name is JpTiger, my (suspended) account is on Stevie, and my main domain is joelrputnam.com. I got an email saying I'd been suspended due to inactivity, but the renewal scripts don't see my account as suspended. I've tried accessing my main site from a couple different machines and it I'm seeing messages to the contrary. Let me know if there's anything I can do to make reactivation easier.

Thank you!

Hey there, I'm using the account jptsndbx on JOHNNY as a sandbox to test simple client sites before I make them on client servers. I've got a (thankfully very patient) client who wants to see the site I made for them ages ago, but I can't get the thing to load-- every time I try to load anything from the wordpress install I get "Error establishing a database connection."

At first I thought it was the SQL server going down for a bit and that it'd be okay again the next day, but it's now been almost a week. So I started tinkering a bit and realized it's not just that site, but also another small wp install in a different folder, and a mediawiki site that are all giving database errors. So I went in to phpMyAdmin to see what was going on under the hood and... well, I can log in, but once I do, I just get a blank screen. Nothing after that.

Any ideas how to fix my database (or whatever is causing this?)

------------------------

EDIT 9/16/15: The problem has been solved, for those who don't want to read the whole thread and are having similar symptoms, try the following:

1. Log into your cpanel, and change your cpanel password (you can even change it back immediately after if you like)

2. Log into the MyPHPAdmin (cpanel credentials) to make sure it's now working.

3. Go to your MySQL admin panel in cpanel, note down which users have privleges to which databasses. You're going to be deleting and recreating all of these users next, so get their passwords if you can easily do so.

3a. If you're using WordPress and don't know where to find the passwords to the MySQL users, check the root of your WP folder for something called wp-config.php-- it'll have the username and password for that installation.

4. Delete the users, and recreate them exactly using the same passwords and at least the same privileges.

Your site should now be working.

EDIT this has been resolved. Mods, feel free to remove this thread-- thank you!

HI there, I tried renewing my account after being suspended for inactivity and it worked, but my page still says my account has been suspended and when I try to renew, it says my account has already been renewed.

My heliohost.org username is jptsndbx, the account is on Johnny, and my main domian is jptigersandbox.heliohost.org.

Thank you!

If it's just the nameservers, is there any chance we can connect using an IP address or temporary domain? I'd really like to reactivate my account

Found and fixed the problem. Apparently Johnny has the same MySQL problems that Stevie has with InnoDB not being writeable. I followed the instructions from this thread: http://www.helionet.org/index/topic/18875-stevie-mysql-common-questions-and-problems/ to change the format, and then told my wp_config.php file to look for the database in the new format. All fixed!

Still having Internal Server Error issues on occasion while editing, but I'm assuming that just comes with using the less stable more experimental server with more features.

Now that cpanel is working again with Johnny, I can be a bit more specific.

I tried "uninstalling" one of the wordpress sites to clear up space. When I tried to drop the tables through phpmyadmin, I get the following:

#2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

The server is not responding (or the local server's socket is not correctly configured).

I'm having a problem with databases on Johnny that are used by a wordpress installation or three. I've made an account with the name jptsndbx to host a few small wordpress installations to play around with ideas for sites. Recently I've started upgrading them to wordpress 4.0, which involves an upgrade to the database. However, with two different wordpress installations now (each with their own databases), when I upgrade the site, I get an endless loop of "You must upgrade the database --&--#62; Thanks for upgrading the database, click here to continue --&--#62; You must upgrade the database" etc.

After some research online, disabling plugins via ftp, etc, I found that the problem was buried in an sql table that listed a value that wordpress reads as the current database version. For some reason it wasn't updating. When I tried to change it myself, I get an "unspecified error."

Anything I can be doing on my end to fix this?

...Oops.

Sorry, let me try again:

U/n: JpTiger

Server: Stevie

domain: www.joelrputnam.com

I was fairly certain I'd logged into cpanel sometime in December, but maybe I was wrong. I was having some serious trouble logging in last time-- some sort of mistake making it looked like my account had been queued when it in fact was totally set up.

Now my website is down and trying the cpanel login on heliohost.org yields "username not recognized" Is my account suspended or deleted? Thanks!

Same issue, that link isn't fixing it. This is only happening from one computer, I can access from others just fine. But my windows XP sp3 machine isn't loading the cpanel login page. I've tried adding exceptions to my firewall for port 2082, but it still times out. What should I be changing?

it works perfectly now. thanks.. use http//stevie.heliohost.org:2082/

Doesn't work for me. http//stevie.heliohost.org:2082/ times out when I try to connect to it with my browser (Chrome 15 on Windows XP sp3). My site is fine, I just don't want my account disabled. Thanks!

Can we add

apc.rfc1867 = 1

to php.ini? It's just a little something that lets users see file upload progress if that's something that your website needs. Drupal in particular seems to use it. As their server status panel says:

Your server is capable of displaying file upload progress through APC, but it is not enabled. Add apc.rfc1867 = 1 to your php.ini configuration. Alternatively, it is recommended to use PECL uploadprogress, which supports more than one simultaneous upload.

Thank you!

There was a weird problem in the database. I have fixed it now - your site is now showing up fine.

 

If you are still seeing the suspended page then please clear your cache.

Great! Thank you! Feel free to delete/close the thread if that's something you guys do to keep this forum clear.

What is your username?

jptiger, same as my u/n here.

Hey there. First of all, thanks for all the hard work, it's very much appreciated! Now I'm a bit confused-- I've logged into cpanel within the last 30 days. In fact, I'm logged into it right now. Yet I've been told my account has been suspended. I've had this site for about a year now and haven't made any recent changes to content, so I don't see how I could be violating ToC. Is there something else I could be doing wrong? www.joelrputnam.com is the site. Thank you!