Seredipity stopped working

Having trouble installing serendipity?
Post Reply
t34gal
Posts: 2
Joined: Tue Jul 13, 2010 9:27 pm

Seredipity stopped working

Post by t34gal »

Greetings all,
I installed Seredipity without any trouble. It was working fine until yesterday. Now when I try to access it, I get:

"Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'sysadmin'@'cgi0508.int.bizland.net' (using password: YES) in /hermes/web01/b2684/moo.mrherrera/serendipity/include/db/mysql.inc.php on line 270

Warning: mysql_select_db() [function.mysql-select-db]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /hermes/web01/b2684/moo.mrherrera/serendipity/include/db/mysql.inc.php on line 271

Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in /hermes/web01/b2684/moo.mrherrera/serendipity/include/db/mysql.inc.php on line 271

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /hermes/web01/b2684/moo.mrherrera/serendipity/include/db/mysql.inc.php on line 281

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /hermes/web01/b2684/moo.mrherrera/serendipity/include/db/mysql.inc.php on line 281
serendipity error: unable to connect to database - exiting."

I contacted tech support at fatcow, my hosting provider. This is their reply:

"Thank you for contacting technical support.

It appears that your connection strings are incorrect in your application.

array('var' => 'dbHost',
'title' => INSTALL_DBHOST,
'description' => INSTALL_DBHOST_DESC,
'type' => 'string',
'default' => 'localhost',
'permission' => 'siteConfiguration',
'flags' => array('nosave', 'simpleInstall')),


Please make sure that all files that make a connection to the database are setup
properly. Since this is a third party application, we can not trouble shoot any of
the code."

I know very little about MySQL and am at a loss as to how to resolve the error. Do I need to uninstall it and re-install Serendipity? Thanks in advance for your help.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Seredipity stopped working

Post by garvinhicking »

Hi!

This means, the password in your serendipity_config_local.inc.php file does not match the currently active mysql database user password.

You might have accidentally changed your password for mysql and did not specify the new password in serendipity...

You can enter the proper one by editing the mentioned file; if you cannot edit the file check the FAQ on s9y.org for "fixperm.php" to get permissions.

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
t34gal
Posts: 2
Joined: Tue Jul 13, 2010 9:27 pm

Re: Seredipity stopped working

Post by t34gal »

Garvin,
I opened the serendipity_config_local,inc,php and changed the password. I then uploaded the changed file via Filezilla. I am still receiving the same error.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Seredipity stopped working

Post by garvinhicking »

Hi!

You must be using an invalid password, or wrong database host then...the error message clearly indicates that the username/password/host connection is invalid...

Maybe you can show the config_local file to your provider so that he can tell you if those credentials are invalid.

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Post Reply