Problem with sql-ledger after server update

gutiersa wrote on Thursday, April 09, 2009:

HELP!

I know I should have upgraded to openemr3 when I had the chance, but I didn’t. Now Im stuck.
Here is what I have:

freebsd 7.1 server
openemr 2.9.0
mysql5.1
apache 2.2
postgres 8.3
sql-ledger 2.8

All had been working fine till I updated my server. Did not really change openemr. Postgres is up and running. I can even access phppgadmin and manage the openemr database.

When I log into openemr and look up a pt, I get the usual

Fault: Code: 5 Reason ‘Didn’t receive 200 OK from remote server. (HTTP/1.1 500 Internal Server Error)’

on the pt demographic.  When I try to log in to sql-ledger, I get:

"The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmasteremail and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log."

My apache log says:

[Thu Apr 09 01:06:40 2009] [error] [client xxx.xxx.xxx.xxx] install_driver(Pg) failed: Can’t locate version.pm in @INC (@INC contains: /usr/local/lib/perl5/5.8.9/BSDPAN /usr/local/lib/perl5/site_perl/5.8.9/mach /usr/local/lib/perl5/site_perl/5.8.9 /usr/local/lib/perl5/5.8.9/mach /usr/local/lib/perl5/5.8.9 .) at /usr/local/lib/perl5/site_perl/5.8.9/mach/DBD/Pg.pm line 20., referer: https://xxx.xxx.xxx.xxx/sql-ledger/login.pl
[Thu Apr 09 01:06:40 2009] [error] [client xxx.xxx.xxx.xxx] BEGIN failed–compilation aborted at /usr/local/lib/perl5/site_perl/5.8.9/mach/DBD/Pg.pm line 20., referer: https://xxx.xxx.xxx.xxx/sql-ledger/login.pl
[Thu Apr 09 01:06:40 2009] [error] [client xxx.xxx.xxx.xxx] Compilation failed in require at (eval 12) line 3., referer: https://xxx.xxx.xxx.xxx/sql-ledger/login.pl
[Thu Apr 09 01:06:40 2009] [error] [client xxx.xxx.xxx.xxx] Perhaps a module that DBD::Pg requires hasn’t been fully installed, referer: https://xxx.xxx.xxx.xxx/sql-ledger/login.pl
[Thu Apr 09 01:06:40 2009] [error] [client xxx.xxx.xxx.xxx]  at SL/User.pm line 103, referer: https://xxx.xxx.xxx.xxx/sql-ledger/login.pl
[Thu Apr 09 01:06:40 2009] [error] [client xxx.xxx.xxx.xxx] Compilation failed in require at /usr/local/sql-ledger/login.pl line 85., referer: https://xxx.xxx.xxx.xxx/sql-ledger/login.pl
[Thu Apr 09 01:06:40 2009] [error] [client xxx.xxx.xxx.xxx] Premature end of script headers: login.pl, referer: https://xxx.xxx.xxx.xxx/sql-ledger/login.pl

don’t know where to go!!! Yes I will upgrade to openemr3, but can’t do it for a few days, it would help if I could fix this in the meantime.

Thanks!

tmccormi wrote on Thursday, April 09, 2009:

Looks like your update changed the perl installation (at least) which freeb and sql-ledger use,

What was the nature of the "update"?  Did you backup first? 

You may have two versions of perl now the binaries are pointing to the new and incomplete install.  Just a guess.

Not sure about the other, probably permissions somewhere.

-Tony

"where we sell a nice automatic, offsite backup appliance"  :slight_smile:

drbowen wrote on Thursday, April 09, 2009:

Dear Sandra,

Good to hear from you. 

The SQL-Ledger does not play nice when upgraded.  We have had plenty of trouble in the past having to substantial rework the code when SQL-Ledger "upgraded" to a new version.

Fault: Code: 5 Reason ‘Didn’t receive 200 OK from remote server. (HTTP/1.1 500 Internal Server Error)’

Previously i have seen this when FreeB was not connecting to SQL-Ledger.  I assume you are not running FreeB?

The trouble you are having with SQL-Ledger is likely the problem given your description.  Since you cannot log onto SQL-Ledger probably the FreeB server is not able connect to SQL-Ledger. 

Can you roll back to the previous edition of SQL-Ledger as a short term solution?

Sam Bowen, MD

gutiersa wrote on Tuesday, April 14, 2009:

I just forgot about sql-ledger, and upgraded to openemr 3.0.1
It went pretty smooth following the install file in the openemr directory.

bradymiller wrote on Tuesday, April 14, 2009:

Dr. G,
What was your php-gacl status (installed or not installed) before your upgrade?
Do you have the typical ‘admin’ user for administrator?
Php-gacl is now embedded since version 3.0, so requires some extra steps if uprading from a version below 3.0 .
-brady

gutiersa wrote on Monday, April 20, 2009:

thanks for the replies
yes, php-gacl was previously installed and working before the upgrade

We have now a working openemr3.0.1 (with a few bugs here and there).
I followed all the instructions for upgrading. It went smoothly.