MySQL Error (URGENT)

Are you responsible for making OJS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, btbell, michael, bdgregg, barbarah, asmecher

Forum rules
The Public Knowledge Project Support Forum is moving to http://forum.pkp.sfu.ca

This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.
metricgravity
Posts: 26
Joined: Mon Mar 19, 2012 1:40 pm

MySQL Error (URGENT)

Postby metricgravity » Sat Jun 01, 2013 10:33 pm

Hi.

The website for the OJS journal I am managing had been working for years, but it suddenly went down. The home page for the website is up, but the parts of the website corresponding to the OJS system are not working. When a user tries to go to a page belonging to the OJS system, the following error message appears: "DB Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (146)"

I do not know whether this is an OJS problem, but I would appreciate it if anyone can give me any advice.

Thank you,
metricgravity

metricgravity
Posts: 26
Joined: Mon Mar 19, 2012 1:40 pm

Re: MySQL Error (URGENT)

Postby metricgravity » Sat Jun 01, 2013 10:46 pm

Here are some additional technical details.

I suspect that the problem is with MySQL. I found the mysql directory on the UNIX server. The directory contains a program for performing a test run of MySQL. The program is called mysql-test-run. I executed the program by typing, "./mysql-test-run". This resulted in a failure for something called grant2. The following error message appeared: ""grant2 [ fail ]". Additional details about this failure appeared below the message, and are as follows.

Errors are (from
/digipub/mysql/mysql-5.0.45/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 177: query 'connect
con8,127.0.0.1,root,,test,$MASTER_MYPORT,' failed: 2013: Lost connection
to MySQL server at 'reading initial communication packet', system error: 0
(the last lines may be the most important ones)
Result from queries before failure can be found in r/grant2.log

Aborting: grant2 failed in default mode. To continue, re-run with '--force'.
Stopping All Servers


I attempted to restart MySQL. I went to the directory containing mysql and typed, "mysql restart". That resulted in the error message, "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (146)".

Again, I do not know whether this is an OJS problem. However, I would appreciate any advice.

It is urgent that I get the website running again.

Thank you.

asmecher
Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm
Contact:

Re: MySQL Error (URGENT)

Postby asmecher » Sun Jun 02, 2013 9:11 am

Hi metricgravity,

This is indeed a MySQL problem. I'd suggest googling how to restart the MySQL service on your specific distribution; details may vary slightly. Your MySQL log may contain details on what happened.

Regards,
Alec Smecher
Public Knowledge Project Team


Return to “OJS Technical Support”

Who is online

Users browsing this forum: No registered users and 1 guest