Can't connect to database

[naienko]

I finally, gloriously, got hamsterjournal.com to work. I have begun to dig my fingers into the *swearword* BML, and now I've got a persistent error that has to go away to continue the process of making HamJournals HamJournals and not DW. It is as follows:

Use of uninitialized value in concatenation (.) or string at /home/[username]/dw/cgi-bin/DBI/Role.pm line 230.
Use of uninitialized value in concatenation (.) or string at /home/[username]/dw/cgi-bin/DBI/Role.pm line 230.
Can't connect to the database.

I have rebooted the apache. I have recreated and re-edited config.private.pl. I even went to the extent of placing the user|pass into Role.pm, which eliminated those lines but not 'Can't connect to the database.' Is this like the frustrating two hours I spend while the Hubbub source was down, and I just have to wait, or did I broked something?

Comments

[mark]

It's config-private.pl -- make sure that's the name of the file. Those errors sound like the database configuration isn't being loaded, so make sure the file has no syntax errors too. You can do that by doing,

$ perl -c etc/config-private.pl

That will tell you if there are any errors.

[naienko]

I checked the name of the file, and it's correct (damn typo daemons), and I ran the snippet you offered, and it said Syntax OK. Hateful error is still there, though. The last time I encountered it, I remade config-private.pl and that fixed it, but not this time.

[mark]

Would you be willing to either email me or post copies of your configuration files?

[mark]

So, just to make sure, you should be able to type this from your server:

$ mysql -hHOST -uUSER -p DBNAME
Password: PASS

That should work. Can you make sure that it does?

[naienko]

Yep, that works.

[naienko]

I think this must be about the 5th time I've done something like this -- it wasn't working because texttool.pl didn't have read permission of config-private.pl. chmod fixed the problem immediately.