mawalker33 wrote on Saturday, May 23, 2009:
when running the sl_convert.php script i get this error:
OpenEMR Conversion from SQL-Ledger
Warning: pg_pconnect() [function.pg-pconnect]: Unable to connect to PostgreSQL server: FATAL: database "sql-ledger" does not exist in /var/www/openemr/library/sql-ledger.inc on line 34
Failed to connect to SQL-Ledger database.
any ideas?
bradymiller wrote on Saturday, May 23, 2009:
hey,
First, I’m assuming you were using sql-ledger in your previous version.
Before you run this script, ensure you have the sql-ledger database settings installed correctly:
#edit file /var/www/html/openemr/interface/globals.php:
mcedit /var/www/html/openemr/interface/globals.php
#edit the following bolded variables :
$sl_dbname = ‘openemr’; // (put value from your previous version)
$sl_dbuser = ‘sql-ledger’; // (put value from your previous version)
$sl_dbpass = ‘sql-ledger-password’; // (put value from your previous version)
TEXT EDITOR SAVE AND EXIT
#edit file /var/www/html/openemr/includes/config.php:
mcedit /var/www/html/openemr/includes/config.php
#edit the following bolded variables :
$GLOBALS[‘oer_config’][‘ws_accounting’][‘enabled’] = 1;
$GLOBALS[‘oer_config’][‘ws_accounting’][‘username’] = “openemr”; (put value from your previous version)
$GLOBALS[‘oer_config’][‘ws_accounting’][‘password’] = “openemrSqlLedgerpassword”; (put value from your previous version)
TEXT EDITOR SAVE AND EXIT
THEN RUN THE sl_convert.php script in a browser
THEN WHEN SUCCESSFUL REMEMBER TO RE-EDIT BELOW FILE TO USE INTERNAL OPENEMR BILLING:
#edit file /var/www/html/openemr/includes/config.php:
mcedit /var/www/html/openemr/includes/config.php
#edit the following bolded variables :
$GLOBALS[‘oer_config’][‘ws_accounting’][‘enabled’] = 2;
TEXT EDITOR SAVE AND EXIT
-brady
BTW, above instructions were copied from appliance upgrade manual at:
http://bradymd.com/appliance/update3/
sunsetsystems wrote on Sunday, May 24, 2009:
sl_convert.php doesn’t care about config.php, but the sql-ledger settings in globals.php must be correct before it can run. Just make sure those match the same settings in the old globals.php.