Dizkus

Okay... read everyones previous posts and have a bunch of ideas, tried them all and they haven't helped.

Here's the situation:

Had a new install of Phoenix Release (0.7.2.6) that was up and running with no problems. Then all of a sudden... now the site only displays:

Problem in Database Connection

So reading the forums I check my config.php file. Unfortunately I didn't download the site to my PC after I did all the config on it so I don't know what is suppose to be in this file. Here is what is online currently:

$pnconfig['dbtype'] = 'mysql';
$pnconfig['dbtabletype'] = 'MyISAM';
$pnconfig['dbhost'] = '66.36.161.247';
$pnconfig['dbuname'] = '';
$pnconfig['dbpass'] = '';
$pnconfig['dbname'] = 'leadership10_com3';
$pnconfig['system'] = '0';
$pnconfig['prefix'] = 'nuke';
$pnconfig['encoded'] = '1';

I was suspect of the username and password being blank (although it would be reasonible that these would not be accessible via this file), but even when I put those in it still doesn't connect.

Should my config.php look different?

My server is running MySQL 3.23.56 and the site address is:

http://www.leadership10.com/

Any input?

Thanks,
-Zap

Umm, your problem is that the DB username and password should *not* be blank.

Get the PN Swiss Army Knife and use the DB username and password reset util in there to fix your co0nfig file.


You can downloas the pnsak here: http://download.postnuke.com/pafiledb.php?action=viewall


Hope this helps.


Dave...

--
Dave...
__________________________________________________

you need to change to encoded=0 when you enter plain text values as username and password....

--
Regards,
Simon

itbegins.co.uk - Zikula Consulting

Please read the Support Guide

Ah... I almost had the forethought to try that!

Darn... I should have... of course then it wouldn't be up here so someone else could learn from my mistake! :)

I'll give it a shot tonight.

Thanks, Hammerhead and DNSGuru!

-Zap

Glad to have been a help.


Dave...

--
Dave...
__________________________________________________

same :)

--
Regards,
Simon

itbegins.co.uk - Zikula Consulting

Please read the Support Guide

Okay... I tried first to unencode the login and that didn't work.

So then I tried this WONDERFUL tool and this is what I get back:

Warning: mysql_connect() [function.mysql-connect]: Host '66.36.161.247' is not allowed to connect to this MySQL server in /var/www/domains/leadership10.com/pnadodb/drivers/adodb-mysql.inc.php on line 237


I am assuming this means that my ISP has done something to prevent this data connection. Any ideas what?

I'm going to call them this morning, but they swear it isn't them. Hopefully this is the smoking gun I need to get them to wise up.

-Zap

I sent the error message to the ISP and they SWEAR they didn't change anything. So regardless here was the fix:

1- Had to put the username and password back in (encoded is better) to the config.php file.

2- Since I can no longer use the IP for connection to the database the config.php had to change from the IP of the server to localhost.

Everything is up and running finally.

Thanks again for all the help.

-Zap