Serendipity Forums

Did an upgrade, all worked then went to blog....

Warning: mysql_connect(): Access denied for user: '-----_blog@localhost' (Using password: YES) in /home/------/public_html/serendipity/include/db/mysql.inc.php on line 149
DATABASE_ERROR

(------ is to mask the host I was working on)

Played with it, no luck. Did restore of old dir and no luck.

It turned out the locol config file had 600 permissions. Using ftp and cpanel I could not change the permissions.

In the end I deleted and uploaded one from backup, it asked to do backup again and just threw and sql error. Goto blog same error.

This time I deleted the file again and edited backup copy to say beta4 in version info. Uploaded and blog working fine!

Just thought I'd let you know, in case it might be issue with upgrade?

Usually this error can only come if the SQL userdata in serendipity_config_local.inc.php is wrong! Did you check if the hostname, username, password and DBName were the right ones?

Did you check if the SQL table serendipity_config contained the settings dbPrefix, dbUser, dbPass and dbHost and maybe wrong values?

Regards,
Garvin

After first upgrade the local.inc file had permissions 600 so was not access to read by cpanel or serendipity. Trying to change permissions via cpanel would not work and I don't have shell access. I forced a delete of file.

The database was fine and I checked the user settings. The backup version of local.inc had correct settings so I uploaded but it tried upgrade again due to backup file having the beta2 name in it. Again the permissions went to 600?

In the end I edited the backup copy to say beta4 and uploaded and blog worked. Is it possible the upgrade was changing the file?

Yes, every upgrade writes the file again. As it contains very sensitive information it is secured with 600 permissions, and we will not change this easily. However you could create a simple PHP script which tells you what information is in the file:
You can/need to also make sure that your dbName, dbPass and so on information is contained properly in the serendipity_config database table.

Regards,
Garvin