Page 1 of 1

Cannot Upgrade to 1.9.4.1 Until ADODB Error Resolved

Posted: Tue Apr 05, 2011 6:24 pm
by rshepard
I want to upgrade from the existing 1.8.2 version and prepare the local development version of our site for deployment. However, I cannot access the current version because of an internal server error. Here's the current versions of relevant software:
Slackware-13.1
PostgreSQL-9.0.3
PHP-5.2.17
httpd-2.2.17
CMSMadeSimple-1.8.2
Firefox-3.6.16

/var/log/httpd/error_log shows:
[Tue Apr 05 10:29:43 2011] [error] [client 127.0.0.1] PHP Fatal error: Attempt to connect to database cms on rshepard@localhost failed in /var/www/htdocs/cmsms/lib/adodb.functions.php on line 85

And the php function in adodb.functions.php is:
if (FALSE == $connect_result)
{
$str = "Attempt to connect to database {$config['db_name']} on {$conf
trigger_error($str,E_USER_ERROR);
die($str);
}

Any and all help will be much appreciated.

Rich

Re: Cannot Upgrade to 1.9.4.1 Until ADODB Error Resolved

Posted: Tue Apr 05, 2011 8:21 pm
by Dr.CSS
That means it can't connect to the DB so it must be that you moved the site to a test server or ?, check the config.php for DB path and make sure it is correct, is not a CMSMS fault...

Re: Cannot Upgrade to 1.9.4.1 Until ADODB Error Resolved

Posted: Tue Apr 05, 2011 9:13 pm
by Wishbone
'localhost' and 'cms' sounds like the default settings.

Re: Cannot Upgrade to 1.9.4.1 Until ADODB Error Resolved

Posted: Tue Apr 05, 2011 11:47 pm
by rshepard
DrCSS/Wishbone:

Thanks for the pointer to config.php. It had the database as 'postgres7' and I just changed that to 'postgres'. Otherwise, everything is the same as before:
$config['dbms'] = 'postgres';
$config['db_hostname'] = 'localhost';
$config['db_username'] = 'rshepard';
$config['db_password'] = '<whatever>';
$config['db_name'] = 'cms';

However, I'm still getting the same error in error_log so there's still a problem connecting to the database. Is 'postgres' the proper name in config.php?

Thanks,

Rich