aperezcrespo wrote on Friday, February 20, 2009:
All the following reports come back with the same error "Failed to connect to SQL-Ledger database."
Financial
Sales
Cash Rec
Payment Method
Collectables
Insurance
Indigentes
Popup
Payment
Billing Screen
EOB
Reports
Fees
Checkout
I double checked the SL account info in Globals and Config and those are right.
These are in my Apache2 error log.
[Tue Feb 17 08:11:48 2009] [error] [client 192.168.1.199] PHP Notice: Undefined index: use_set_names_utf8 in /srv/www/htdocs/openemr/library/translation.inc.php on line 11, referer: https://192.168.1.75/openemr/interface/billing/billing_report.php
[Tue Feb 17 08:11:48 2009] [error] [client 192.168.1.199] PHP Notice: Undefined variable: sl_dbname in /srv/www/htdocs/openemr/interface/globals.php on line 308, referer: https://192.168.1.75/openemr/interface/billing/billing_report.php
[Tue Feb 17 08:11:48 2009] [error] [client 192.168.1.199] PHP Warning: pg_pconnect(): Unable to connect to PostgreSQL server: FATAL: password authentication failed for user "wwwrun" in /srv/www/htdocs/openemr/library/sql-ledger.inc on line 34, referer: https://192.168.1.75/openemr/interface/billing/billing_report.php
[Tue Feb 17 08:11:56 2009] [error] [client 192.168.1.199] PHP Notice: Undefined variable: ignoreAuth in /srv/www/htdocs/openemr/interface/globals.php on line 203, referer: https://192.168.1.75/openemr/interface/main/main_screen.php?auth=login
[Tue Feb 17 08:11:56 2009] [error] [client 192.168.1.199] PHP Notice: Undefined variable: sl_dbname in /srv/www/htdocs/openemr/interface/globals.php on line 308, referer: https://192.168.1.75/openemr/interface/main/main_screen.php?auth=login
Globals.php
$$sl_dbname = ‘openemr’; // sql-ledger database name
$sl_dbuser = ‘sql-ledger’; // sql-ledger database login name
$sl_dbpass = ‘YolandA’; // sql-ledger database login password
config.php
$GLOBALS[‘oer_config’][‘ws_accounting’][‘enabled’] = 1;
// If 1 is chosen above, then the following must be set correctly:
//
$GLOBALS[‘oer_config’][‘ws_accounting’][‘server’] = “localhost”;
$GLOBALS[‘oer_config’][‘ws_accounting’][‘port’] = “80”;
$GLOBALS[‘oer_config’][‘ws_accounting’][‘url’] = “/sql-ledger/ws_server.pl”;
$GLOBALS[‘oer_config’][‘ws_accounting’][‘username’] = “openemr”;
$GLOBALS[‘oer_config’][‘ws_accounting’][‘password’] = “MartiN”;
$GLOBALS[‘oer_config’][‘ws_accounting’][‘url_path’] = “https://” .
$_SERVER[“SERVER_NAME”] . “/sql-ledger/login.pl”;
$GLOBALS[‘oer_config’][‘ws_accounting’][‘income_acct’] = “4320”;
All worked just fine prior to CVS update. What do you think?
Alfonso