OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



A database error has occurred: No such file or directory

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.

A database error has occurred: No such file or directory

Postby azaenen » Fri Jan 03, 2014 4:42 pm

I get this error message when trying to install ojs. This is a first time installation. I know that this error message has come up before but the answer given to it does not solve my problem. I have no option to install this manually. The version of OJS I am using is 2.4.3.0; the version of MySQL is 5.6.15 for the Mac. On the MySQL side everything looks fine: the selected database is there, the user ID is recognized.
I have been fiddling around with this for three afternoons and am getting quite desperate. Is there at least a way to get a more informative error message?
azaenen
 
Posts: 2
Joined: Thu Jan 02, 2014 6:30 pm

Re: A database error has occurred: No such file or directory

Postby asmecher » Sat Jan 04, 2014 4:57 am

Hi azaenen,

That message is coming back from MySQL, and appears to be something similar to this issue. I'd suggest checking your MySQL error log to see if it's getting logged there; it's possible that you'll find more information there. In any case, it looks like that message is coming during the MySQL connect process; another option would be to test that out manually using a small script like in the above link.

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm

Re: A database error has occurred: No such file or directory

Postby azaenen » Sat Jan 04, 2014 7:04 pm

Thanks for your help. I found the solution following the link in your reply. When mysql server starts on MacOS X 10.9 (Mavericks) it creates a socket in /tmp/mysql.sock but the OJS installer expects to find it in /var/mysql. The solution to the problem was this:

sudo tcsh
mkdir /var/mysql
cd /var/mysql
ln -s /tmp/mysql.sock mysql.sock

With the soft link in place, the installation of OJS completed successfully.
azaenen
 
Posts: 2
Joined: Thu Jan 02, 2014 6:30 pm


Return to OJS Technical Support

Who is online

Users browsing this forum: No registered users and 1 guest