forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 upgrading => Topic started by: whoosh on December 08, 2008, 08:58:26 am

Title: [Solved]: Update problem
Post by: whoosh on December 08, 2008, 08:58:26 am
Hi,
I upgraded to the latest version, uploaded all the files, but when I ran update.php, I got the following message:

"Coppermine critical error:
Unable to connect to database !

MySQL said: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)"

I checked my include/config.inc.php file and the mysql username and password are correct. Tried uploading this file again. It didn't work - same error message.

What should I do now? Pse help.
Title: Re: Update problem
Post by: phill104 on December 10, 2008, 09:19:53 am
Is this the same config.inc.php file from your working install. Is the dbase name correct. Is the prefix correct?
Title: Re: Update problem
Post by: whoosh on December 10, 2008, 10:14:30 am
Hi,

it is the same config.inc.php file that I've been using all along.
I've checked the dbase username and password of this file - they are correct.

Similarly, the prefix is correct.
Title: Re: Update problem
Post by: whoosh on December 13, 2008, 01:34:15 pm
Hi,

I'm hoping somebody can help with my problem - I have no idea at all what I should do to correct it.
Title: Re: Update problem
Post by: Fabricio Ferrero on December 13, 2008, 02:18:21 pm
The thing is that the error is very clear. Even though you are sure that the values are ok, just check them again.
Title: Re: Update problem
Post by: whoosh on December 13, 2008, 02:55:14 pm
Hi Farbricio,

Thank you for your advice. Appreciate it.

I've been checking the include/config.inc.php file - there are only 4 lines in the MYSQL configuration section, namely, database server, mysql username, mysql password and mysql database password.

Of course, there is the mysql table prefix.

They are all correct. 

In fact, the upgrade package do not have this include/config.inc.php file. So this file in the server is the same all the time.  Also, I've not changed anything in the database. The only thing I did was to do a backup of the database before I upgraded.   I cannot understand why I'm having this problem - no connection to the database unless there is some other explanation.
Title: Re: Update problem
Post by: phill104 on December 13, 2008, 04:28:13 pm
Post a link to your site for starters.
Title: Re: Update problem
Post by: whoosh on December 14, 2008, 06:33:56 am

Hi,

here's the link:   http://www.photograffs.com.

you can click on the big picture and you get to http://www.photograffs.com/index.php to see the error message.

Also, the same error message in http://www.photograffs.com/update.php.
Title: Re: Update problem
Post by: phill104 on December 14, 2008, 10:23:31 am
If you can see your database through phpmyadmin ok and your config.inc.php file is correct then you should speak to your host.
Title: Re: Update problem
Post by: whoosh on December 15, 2008, 01:52:54 am
Thank you  Phill.
I contacted my webhost. For some reason, the database server name was changed.
I got it corrected and my website is OK now.

I want to thank all of you who tried to help !!
Title: Re: [Solved]: Update problem
Post by: Joachim Müller on December 22, 2008, 08:36:36 pm
Who's the owner of http://www.photograffs.com/ ?