After setting up Moog, I started seeing:
MySQL generated an error. The current user is cxh: Christopher Brooks ( cxh@eecs.berkeley.edu) Apache environment: SCRIPT_URI = https://www.terraswarm.org/terraswarm/faq/1/ HTTP_REFERER = https://www.terraswarm.org/terraswarm/faq/1/ REMOTE_HOST = HTTP_GET_VARS: postpage = addchild The error message is: Cannot connect to MySQL server.Stacktrace: at sqli_error(/home/www/php/include/sqli.inc.php:203) at sqli_connection_error(/home/www/php/include/sqli.inc.php:64) at sqli_select_row(/home/www/php/include/sqli.inc.php:860) at user_get(/home/www/php/include/user.inc.php:844) at shared_faq_form(/home/www/php/subpages/shared.faq.php:14) at post_contents(/home/www/php/subpages/post.php:985) at eval(/home/www/php/www.terraswarm.org/layout/html.inc.php(697) : eval()'d code:1) at html_page(/home/www/php/www.terraswarm.org/layout/html.inc.php:697) at include(/home/www/php/www.terraswarm.org/get.php:252) at /home/www/php/get.php:40 ------------------------------------------ This error last occurred 0 times between 12:42:32 AM 10/30/12 and 12:42:32 AM 10/30/12 with no mail sent to avoid an unmanageable deluge of email. To delete the file keeping track of these repeated error messages, log onto andrews as root and rm -f /home/www/wwwdata/delugeMail/c95fa853cbe1aaadeee5bcbc97a0ca12
141.212.110.29 - - [30/Oct/2012:11:15:25 -0700] "GET /img/banr1.jpg HTTP/1.1" 404 4181 141.212.110.29 - - [30/Oct/2012:11:15:25 -0700] "GET /img/Logo3.png HTTP/1.1" 200 355511 50.0.252.135 - - [30/Oct/2012:11:15:44 -0700] "GET /terraswarm/faq/1/?postpage=addchild HTTP/1.1" 200 9366 50.0.252.135 - - [30/Oct/2012:11:15:45 -0700] "GET /favicon.ico HTTP/1.1" 200 198We are using sockets here, the port is not open to the network, though it is open to localhost and to moog from moog.
[root@moog moog.key]# telnet localhost 3306 Trying ::1... telnet: connect to address ::1: Connection refused Trying 127.0.0.1... Connected to localhost. ...
/export/home1/tmp/php.err
says:
30-Oct-2012 11:12:58] [client 50.0.252.135] [user cxh] Group record updated: terraswarm, remotePass [30-Oct-2012 11:15:44] PHP Warning: mysqli_connect(): (42000/1049): Unknown database 'auth_1' in /home/www/php/include/sqli.inc.php on line 856 [30-Oct-2012 11:15:44] [client 50.0.252.135] [user cxh] sqli.inc.php: sqli_prepared_select_row(): Failed to connect to database auth_1 on localhost as dbreader: Unknown database 'auth_1' [30-Oct-2012 11:15:45] PHP Warning: mysqli_connect(): (42000/1049): Unknown database 'auth_3' in /home/www/php/include/sqli.inc.php on line 856 [30-Oct-2012 11:15:45] [client 50.0.252.135] [user cxh] sqli.inc.php: sqli_prepared_select_row(): Failed to connect to database auth_3 on localhost as dbreader: Unknown database 'auth_3' [30-Oct-2012 11:15:45] PHP Warning: mysqli_connect(): (42000/1049): Unknown database 'auth_5' in /home/www/php/include/sqli.inc.php on line 856 [30-Oct-2012 11:15:45] [client 50.0.252.135] [user cxh] sqli.inc.php: sqli_prepared_select_row(): Failed to connect to database auth_5 on localhost as dbreader: Unknown database 'auth_5' [30-Oct-2012 11:26:36] PHP Warning: mysqli_connect(): (42000/1049): Unknown database 'shared' in /home/www/php/include/sqli.inc.php on line 856This will go away when the entire website is updated.