coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 install => Topic started by: helitown on September 23, 2006, 08:48:26 AM

Title: MySQL Install Problem
Post by: helitown on September 23, 2006, 08:48:26 AM
Hi Dear
I am trying to run install the frist time. I got an error message between here when clicked on the Let's Go. I use the phpbb database and does not seem to have anything wrong with my entries on the install window. 

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' (46)

Any hints as to what I should check?
Thank you so much

Title: Re: MySQL Install Problem
Post by: kegobeer on September 23, 2006, 01:16:35 PM
Are you self hosted?  Are you on a VPS?  Are you completely responsible for configuring MySQL?

This type of error points at an improperly configured MySQL server.  You should contact your host for support.
Title: Re: MySQL Install Problem
Post by: helitown on September 23, 2006, 05:56:24 PM
My webhost is Yahoo. For Yahoo they don't let people talk with their php or mySQL tech support team - we can only send e-mail and it takes a long time before they respond. I searched here and Google - all of the threads and info are dead ending - people don't come and share what they and/or their webhsot do to fix the problem. So I want to make sure that it is not me that caused the problem before I contact my webhost.

This is my info from my config.php except the user and password which I could not post. Should I use mysql instead of localhost for MySQL field. Also I see these are in the signle quotation mark - should I put these in the single quotation mark also in those fields on the Install Screen.

$dbms = 'mysql';

$dbhost = 'mysql';
$dbname = 'phpbb_3';

$table_prefix = 'phpbb_';

Title: Re: MySQL Install Problem
Post by: Tranz on September 23, 2006, 06:06:12 PM
If 'mysql' is used in your phpbb install and it works, you should use that. Don't include the quotes when filling out the form.
Title: Re: MySQL Install Problem
Post by: kegobeer on September 23, 2006, 06:59:16 PM
Also, don't use the same table prefix.
Title: Re: MySQL Install Problem
Post by: helitown on September 23, 2006, 08:10:31 PM
It works! At least I passed that error.
Thanks