installed okay, but now shows login when you go to site (and wont let you log in!)

Permalink
I have maybe 20 copies of C5 running on my server, all running really well. Accept for this one. The 1st time you visit the site from a browser, on a given day, you just see it sitting there and waiting. After an age, you get an error message (which I cannot share right now, because today I am getting the other error)
The other error is that I see the login page. Even though you do not have to log in to access the site. Mt admin user/pass does not get me in.
So I request a new password - it mails me the reset link, I go there, type in a 'new' password, and get the error. I believe this is the same error as I get on the front page somtimes, buut there may be subtle differences:

Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [2006: MySQL server has gone away] in EXECUTE("SHOW TABLES") ' in /home/bbpam/dev/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /home/bbpam/dev/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 2006, 'MySQL server ha...', 'SHOW TABLES', false, Object(ADODB_mysql)) #1 /home/bbpam/dev/concrete/libraries/3rdparty/adodb/adodb.inc.php(1012): ADOConnection->_Execute('SHOW TABLES', false) #2 /home/bbpam/dev/concrete/libraries/3rdparty/adodb/adodb.inc.php(2273): ADOConnection->Execute('SHOW TABLES') #3 /home/bbpam/dev/concrete/libraries/3rdparty/adodb/drivers/adodb-mysql.inc.php(72): ADOConnection->MetaTables(false, false) #4 /home/bbpam/dev/concrete/startup/exceptions.php(7): ADODB_mysql->MetaTables() #5 [internal function]: Concrete5_Exception_Handler(Object(ADODB_Exception)) #6 {main} thrown in /home/bbpam/dev/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78


All I have installed is the rigidlight package (which I use a lot, its stable) There are no other packages themes or blocks, I have not modified any of the code.

I am thinking the best thing to do is to delete it all and start afresh - only I have added a *lot* of pages and I do not want to ad them again. I am worried about a reinstall and copying the database over the new one, incase the issue is on the db side.
The error_log states:
[29-Apr-2013 15:00:44 America/Los_Angeles] PHP Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [2006: MySQL server has gone away] in EXECUTE("SHOW TABLES")
' in /home/bbpam/dev/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78
Stack trace:
#0 /home/bbpam/dev/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 2006, 'MySQL server ha...', 'SHOW TABLES', false, Object(ADODB_mysql))
#1 /home/bbpam/dev/concrete/libraries/3rdparty/adodb/adodb.inc.php(1012): ADOConnection->_Execute('SHOW TABLES', false)
#2 /home/bbpam/dev/concrete/libraries/3rdparty/adodb/adodb.inc.php(2273): ADOConnection->Execute('SHOW TABLES')
#3 /home/bbpam/dev/concrete/libraries/3rdparty/adodb/drivers/adodb-mysql.inc.php(72): ADOConnection->MetaTables(false, false)
#4 /home/bbpam/dev/concrete/startup/exceptions.php(7): ADODB_mysql->MetaTables()
#5 [internal function]: Concrete5_Exception_Handler(Object(ADODB_Exception))
#6 {main}
thrown in /home/bbpam/dev/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78

I am sure I am not providing enough information, please excuse me, and tell me what else I can tell you. I truly appreciate any help that can be given. I have tried all I can to resolve, with no joy,

johnsmart
 
ronyDdeveloper replied on at Permalink Reply
ronyDdeveloper
This might be a MySQL connection timeout problem. Here you can get the details of that error.http://dev.mysql.com/doc/refman/5.0/en/gone-away.html...

Solution: Try to put the below code to your roots index.php file.

ini_set('mysql.connect_timeout', 300);
ini_set('default_socket_timeout', 300);


Rony
johnsmart replied on at Permalink Reply
johnsmart
Thank you, I have been googleing a loot, and found similar soloutions. As this is a dev server, I am applying them all, so will not know which worked, but
I am also changing (whm/cpanel box) /etc/my.cnf upgrading the following lines:
query_cache_limit=16M
query_cache_size=256M
...
max_connections=5000

Thank you for your help, I will post back if I learn more, and will confirm if this resolves it.