Page 1 of 1

Seredipity stopped working

Posted: Tue Jul 13, 2010 9:36 pm
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.

Re: Seredipity stopped working

Posted: Tue Jul 13, 2010 10:03 pm
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

Re: Seredipity stopped working

Posted: Tue Jul 13, 2010 10:39 pm
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.

Re: Seredipity stopped working

Posted: Tue Jul 13, 2010 11:14 pm
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