I've just got Coppermine as I would like to set up a gallery on my free webspace. I've uploaded it to my server, enabled the MySQL database on the server, and run the installation script. I input what I think is the right info, but then when I click continue I get the following message:
Could not create a mySQL connection, please check the SQL values entered
MySQL error was : Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Now I know very little about php scripts, MySQL databases etc so have no idea what this is on about. Could someone please let me know what it is telling me, and how I can get around this problem. Many thanks in advance:)
Basically this message means: the mySQL data you entered in coppermine setup is wrong. Edit include/config.inc.php (on your webserver) and fill in the proper data. No other advice we could give you I'm afraid.
GauGau
Well thanks for that info. Will try a few things when I get back form work and see if I get any success.
Will report back later...
inside your "includes" directory, your "config.inc.php" file should read similar to:
<?php
// Coppermine configuration file
// MySQL configuration
$CONFIG['dbserver'] = "localhost"; // Your database server
$CONFIG['dbuser'] = "jeremy12"; // Your mysql username
$CONFIG['dbpass'] = "*****"; // Your mysql password
$CONFIG['dbname'] = "album"; // Your mysql database name
// MySQL TABLE NAMES PREFIX
$CONFIG['TABLE_PREFIX'] = "cpg11d_";
?>
'dbpass' removed for obvious reasons...
the 'db server should be localhost
the rest is whatever you set up in your MySql database.... on your server.
also, ensure that your server supports PHP in the correct build, some "free" webspace providers do not provite PHP.
I got it working!!! Had to change my db server address to the specific db server on my webspace (rather than localhost) but it's all working ok now:)
Thanks for the info offered - it was much appreciated.
Right - I've uploaded a fair few photos for your viewing. If you want to view them (and you're all more than welcome) then visit:
www.soldave.f2s.com/coppermine