coppermine-gallery.com/forum

Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: sherekhan on March 17, 2004, 04:16:43 PM

Title: [Solved]: MySQL error
Post by: sherekhan on March 17, 2004, 04:16:43 PM
I have downloaded Coppermine 1.2.1 standalone on my server, and now I try to install. I have installed MySQL and created a database and a user for Coppermine. However, when I try to enter these values into the Coppermine installation I get this error message:

QuoteCould not create a mySQL connection, please check the SQL values entered

MySQL error was : Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)

From the error I get the impression that Cmine is trying to look up the socket in the file /var/run/mysql/mysql.sock. But when I look it up I find a zero-length file, so trying to cat it gives me an error message. Is this file supposed to be empty? Or is there any other way I can tell Cmine which socket to use?

I have double checked that the user name, password and database name is correct, and that the user has access to the database locally.

Any help is appreciated.

System info: Coppermine 1.2.1 standalone, MySQL 11.18, OpenBSD 3.4 and Apache 1.3.28 chrooted to /var/www.
Title: Solved
Post by: sherekhan on March 17, 2004, 08:01:21 PM
I changed the host from localhost to 127.0.0.1, and the damnest thing, it worked. Weird shit.