Page 1 of 1

DB "remembers" wrong password

Posted: Mon Dec 21, 2009 12:49 pm
by yellowled
Okay, so apparently (I already had a brief IM discussion w/ Garvin about this) I have the oldest s9y installation known to man -- I initially started my blog w/ s9y v0.6 or 0.7, back in the day when grandma's performance pennies were still worth something :wink:

There's one single problem about that: apparently, the mysql connection is still stored in the db itself, which doesn't seem to be the case w/ newer versions. The effect of this is that I had to change the mysql password in the meantime, so every time I update s9y, it "remembers" the old password from the db, giving me error messages until I change it manually in serendipity_config_local.inc.php. This is kind of a hassle since I have to reset this file's permissions first, using a rather cumbersome interface by my web hoster, only to set them back to the PHP user after uploading the manually edited file.

So I was wondering if

a) there's anything I can do about this and

b) is there any other potential "baggage" from earlier versions I could or should get rid of?

YL

Re: DB "remembers" wrong password

Posted: Mon Dec 21, 2009 4:53 pm
by garvinhicking
Hi!

Simply remove the dbUser, dbName etc. values from the serendipity_config DB table. SOme s9y version already cleared that, but you might have re-imported it with a SQL dump or something like that happened.

HTH,
Garvin