Changing some Config settings causes "unable to connect

[dakotaroar]

I've installed Serendipity on my Powerbook running Apache, PHP and MySQL. Installation went fine (except that I don't have Imagemagick), and I began to modify a theme for use for my own site.

However, when I went in and changed some config settings (notably "Enable use of popup windows " and "Is serendipity embedded?") and the site shuts down with the "unable to connect to database" error.

I've re-run the install on this three times now (mostly because I wanted to continue working and wasn't near the internet), and if I put the old database name in every time, it picks right up where I left off. I've been doing this by unpacking the files into a new directory and running the install their, then moving over the template files I was working on.

Does anyone have any clue why this is occurring, or how to fix it? I'm thinking it might be something in my Apache settings.

[garvinhicking]

Hi!

This sounds as if you are changing the databsae user credentials inside the form. Make sure if you submit the configuration page in your browser that all settings inside "DB username", "DB password", "DB host" are right.

Some browsers, notably Firefox, sometimes put other values in this form if you'Re using a form manager that auto-inserts texts for you. Please have a look on that.

If that happens, you can check your serendipity_config_local.inc.php file and make sure the DB credentials in that file are alright.

HTH
Garvin

[dakotaroar]

Yes! That was exactly the problem -- when I looked inside my most-recently installed Config, I saw that it had filled in the username and password for the MySQL database with a different one (actually, the one I use for logging into Serendipity). I am using Camino, which seems to get confused when I run a few different web apps from my own Apache install.

I can't find serendipity_config_local.inc.php, and in serendipity_config.inc.php I couldn't find where thos values should go, but if I go with my most recent install and turn off autofill on the site, I should be golden.

EDIT: Just a note, that it seems the DB password does NOT need to be entered every time you change a Config setting (the field is left blank, but everything seems to work okay).

Thanks!

[carl_galloway]

I've found on my localhost that if I use the same username for each version of serendipity I get similar problems. I have multiple versions of s9y in my localhost, from 0.91, 1.0, 1.1, and 1.2 and each used to have the user 'admin'. Now I give each a unique username such as admin091, admin10, admin11, admin12 etc, which at least means that autofill doesn't screw things up for me.

Are you using MAMP or the version of Apache that came with your Mac, the reason I ask is that the default Apache is used to power the Mac help system and it uses keychain for storing passwords, so does Camino, and that might be why things get confused. Might be best to use Firefox for localhost, at least that way your localhost passwords are kept in a separate file and can't overwrite regular keychain passwords or vice versa.

[dakotaroar]

Ahh, I see. I am using the default Apache install. I have been using Firefox for the WebDev toolbar, but I think for now I'm going to just turn off the keychain for this install.