Jump to content
Sign in to follow this  
BillH

Can't access the admin because PW freezes

Recommended Posts

I have moved a site to a new server and can't access the admin.

Accessing the front end of the site seems to be working as normal. And I can get to the log-in page for the admin. But then when I enter username and password, everything freezes while waiting for the next page to load.

Then, after this has happened, I can no longer access any page on the site (including the front end).

If I restart the browser, however, we go back to square one - that is, I can access the site until I try to log in, when everything freezes again.

There seems to be some instability in this behaviour - occasionally I or others can log in, for example - but mostly it is as just described.

The error logs seem to indicate it's something to do with accessing MySQL (see below), but the fact that re-starting the browser seems to re-set things makes me think that perhaps it's primarily an issue with sessions or something like that.

From the PW errors log:

2019-10-09 15:59:13    ?    http://phpstack-273028-1014063.cloudwaysapps.com/    Error:     Exception: SQLSTATE[HY000] [2002] Connection refused (in /home/273028.cloudwaysapps.com/ebmtwcxxzm/public_html/wire/core/ProcessWire.php line 382)
2019-10-09 15:59:13    ?    http://phpstack-273028-1014063.cloudwaysapps.com/admin/    Error:     Exception: SQLSTATE[HY000] [2002] Connection refused (in /home/273028.cloudwaysapps.com/ebmtwcxxzm/public_html/wire/core/ProcessWire.php line 382)
2019-10-09 15:59:15    ?    http://phpstack-273028-1014063.cloudwaysapps.com/admin/    Error:     Exception: SQLSTATE[HY000] [2002] Connection refused (in /home/273028.cloudwaysapps.com/ebmtwcxxzm/public_html/wire/core/ProcessWire.php line 382)

And the entries from the corresponding time in the PW exceptions log:

2019-10-09 15:59:10    admin   http://phpstack-273028-1014063.cloudwaysapps.com/admin/  SQLSTATE[HY000]: General error: 2006 MySQL server has gone away (in /site/assets/cache/FileCompiler/site/modules/ProDrafts/ProDrafts.module line 423)
2019-10-09 15:59:10    admin   http://phpstack-273028-1014063.cloudwaysapps.com/admin/  SQLSTATE[HY000]: General error: 2006 MySQL server has gone away (in /site/assets/cache/FileCompiler/site/modules/ProDrafts/ProDrafts.module line 423)
2019-10-09 15:59:10    admin   http://phpstack-273028-1014063.cloudwaysapps.com/admin/?login=1  DB connect error 2002 - Connection refused (in /wire/core/Database.php line 79)
2019-10-09 15:59:10    admin   http://phpstack-273028-1014063.cloudwaysapps.com/admin/?login=1  DB connect error 2002 - Connection refused (in /wire/core/Database.php line 79)
2019-10-09 15:59:10    ?    ?    SQLSTATE[HY000]: General error: 2006 MySQL server has gone away (in /wire/core/WireDatabasePDO.php line 480)
2019-10-09 15:59:10    admin   http://phpstack-273028-1014063.cloudwaysapps.com/about/  SQLSTATE[HY000] [2002] Connection refused (in /wire/core/WireDatabasePDO.php line 217)
2019-10-09 15:59:10    admin   http://phpstack-273028-1014063.cloudwaysapps.com/admin/?login=1  SQLSTATE[HY000]: General error: 2006 MySQL server has gone away (in /site/assets/cache/FileCompiler/site/modules/ProDrafts/ProDrafts.module line 423)
2019-10-09 15:59:10    admin   http://phpstack-273028-1014063.cloudwaysapps.com/admin/?login=1  SQLSTATE[HY000]: General error: 2006 MySQL server has gone away (in /site/assets/cache/FileCompiler/site/modules/ProDrafts/ProDrafts.module line 423)
2019-10-09 15:59:10    ?    ?    SQLSTATE[HY000]: General error: 2006 MySQL server has gone away (in /wire/core/WireDatabasePDO.php line 480)
2019-10-09 15:59:10    admin   http://phpstack-273028-1014063.cloudwaysapps.com/  SQLSTATE[HY000] [2002] Connection refused (in /wire/core/WireDatabasePDO.php line 217)
2019-10-09 15:59:10    ?    ?    SQLSTATE[HY000]: General error: 2006 MySQL server has gone away (in /wire/core/WireDatabasePDO.php line 480)
2019-10-09 15:59:10    admin   http://phpstack-273028-1014063.cloudwaysapps.com/  SQLSTATE[HY000] [2002] Connection refused (in /wire/core/WireDatabasePDO.php line 217)
2019-10-09 15:59:10    admin   http://phpstack-273028-1014063.cloudwaysapps.com/about/  SQLSTATE[HY000] [2002] Connection refused (in /wire/core/WireDatabasePDO.php line 217)
2019-10-09 15:59:10    admin   http://phpstack-273028-1014063.cloudwaysapps.com/  SQLSTATE[HY000] [2002] Connection refused (in /wire/core/WireDatabasePDO.php line 217)
2019-10-09 15:59:10    admin   http://phpstack-273028-1014063.cloudwaysapps.com/  SQLSTATE[HY000] [2002] Connection refused (in /wire/core/WireDatabasePDO.php line 217)
2019-10-09 15:59:10    ?    ?    SQLSTATE[HY000]: General error: 2006 MySQL server has gone away (in /wire/core/WireDatabasePDO.php line 480)
2019-10-09 15:59:10    admin   http://phpstack-273028-1014063.cloudwaysapps.com/  SQLSTATE[HY000] [2002] Connection refused (in /wire/core/WireDatabasePDO.php line 217)
2019-10-09 15:59:10    admin   http://phpstack-273028-1014063.cloudwaysapps.com/  SQLSTATE[HY000] [2002] Connection refused (in /wire/core/WireDatabasePDO.php line 217)
2019-10-09 15:59:13    ?    ?    Unable to load WireDatabasePDO - SQLSTATE[HY000] [2002] Connection refused (in /wire/core/WireDatabasePDO.php line 217)
2019-10-09 15:59:13    ?    ?    SQLSTATE[HY000] [2002] Connection refused (in /wire/core/ProcessWire.php line 382)
2019-10-09 15:59:13    ?    ?    Unable to load WireDatabasePDO - SQLSTATE[HY000] [2002] Connection refused (in /wire/core/WireDatabasePDO.php line 217)
2019-10-09 15:59:13    ?    ?    SQLSTATE[HY000] [2002] Connection refused (in /wire/core/ProcessWire.php line 382)
2019-10-09 15:59:15    ?    ?    Unable to load WireDatabasePDO - SQLSTATE[HY000] [2002] Connection refused (in /wire/core/WireDatabasePDO.php line 217)
2019-10-09 15:59:15    ?    ?    SQLSTATE[HY000] [2002] Connection refused (in /wire/core/ProcessWire.php line 382)

It might also be worth noting that I have another PW installation running on the same cloud server (using a different MySQL database) in AFAIK the exactly the same environment with no problems at all.

I am entirely stumped on where to go next, and I haven't managed to find any post in the forums regarding exactly this issue.

Does anyone have any ideas?

 

 

 

Share this post


Link to post
Share on other sites
23 minutes ago, BillH said:

MySQL server has gone away

+

23 minutes ago, BillH said:

DB connect error 2002 - Connection refused

= shaky mySQL server / setup.

24 minutes ago, BillH said:

(using a different MySQL database)

There you have it. Maybe ask hosting support or switch to another DB if you can.

  • Like 3

Share this post


Link to post
Share on other sites

@BillH

Your issue is with MySQL connection.

Exception: SQLSTATE[HY000] [2002] Connection refused

Check your database user/credentials to make sure that you can connect.

Share this post


Link to post
Share on other sites

Many thanks for the replies.

@Rudy The credentials do very occasionally work, so I think they must be correct.

@dragan That seems like a good analysis. I was beginning to think it might be something to do with the server set up rather than on the PW end of things. I'll get on to hosting support and will report back if this fixes it.

Share this post


Link to post
Share on other sites

I finally found a solution.

I realised that, after a very long wait, apparently frozen browser windows were, at least sometimes, returning internal server errors.

So I looked at the suggestions for error 500 in the PW readme and in the .htaccess file.

The one that fixed it is in item 1 of .htaccess: uncomment Options +SymLinksifOwnerMatch and comment Options +FollowSymLinks.

There are various things I'm not clear about, such as why this issue seemed to caused problems with database connections on log in, why it hasn't affected two other PW sites on the same cloud server (presumably there is some difference, such as this site being the Apache default), and so on, but the solution might be useful to others.

  • Like 1

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...