SQL Ledger Install Questions

mike-h30 wrote on Saturday, February 02, 2008:

I am getting ready to install SQLLedger and FreeB for my OpenEMR-2.8.3 installation and have a few questions.  I am following the install instructions from the OpenEMR site: http://www.bradymd.com/appliance/manual3/#Table%20of%20Contents2|region.

1.) Which version of SQL Ledger should I install?  I noticed the latest version is SQL Ledger 2.8.11, however from the Forum posts I also noticed that someone had to make changes recently in order to get 2.8.10 to work with OpenEMR-2.8.3.  Since I do not have access to CVS files, I wanted to make sure I install the right version to get me up and running with the August release of OpenEMR (2.8.3).

2.) Is it ok to install FreeB-0.13?

3.) I noticed that one of the components for postgreSQL is "php4-pg".  I am running PHP5 and this file is the closest "php5-pgsql". Is this the correct one to install?  I do not have a phpX-pg file.

Thanks,

-Mike

sunsetsystems wrote on Saturday, February 02, 2008:

(1) With OpenEMR I’d suggest SQL-Ledger 2.6.27 as it’s the last 2.6 release.  Or if you feel adventurous you can get OpenEMR from CVS (see https://sourceforge.net/cvs/?group_id=60081) and optionally try SL 2.8.11.

(2) Yes, FreeB 0.13 is required if you want to generate paper claims.

(3) You didn’t way which Linux distribution… package names will vary according to the distribution.  But with PHP5 I don’t think you want any PHP4-* packages.

Rod
www.sunsetsystems.com

fred0 wrote on Saturday, February 02, 2008:

Mike,

I did the update for the sql-ledger interface to work with 2.8.10 and Rod cleaned it up and added it to the cvs. I’ve had it working perfectly in production for a month now. I haven’t tested 2.8.11 yet but I don’t expect any major structural changes to that would break the interface.

What OS are you installing on?

As for the php library, yes, the php5-pgsql should do the trick.

mike-h30 wrote on Saturday, February 02, 2008:

Rod and Fred,

Thanks for your quick responses! 

I am running Suse Enterprise Server 10 SP1 with PHP5, Apache2, and MYSQL5.

Rod,

Per your suggestion "Or if you feel adventurous you can get OpenEMR from CVS (see https://sourceforge.net/cvs/?group_id=60081) and optionally try SL 2.8.11. "

1.) Is there an advantage for me to get OpenEMR from CVS? 

2.) I would like to go live in our office February 11th, will I be able to put the current CVS version into production right away?

Regards,

-Mike

sunsetsystems wrote on Saturday, February 02, 2008:

There are a lot of changes going into CVS right now, so you may do best to install 2.8.3, and upgrade later after things settle down.

Rod
www.sunsetsystems.com

mike-h30 wrote on Saturday, February 02, 2008:

Thanks for your input!

-Mike

fred0 wrote on Saturday, February 09, 2008:

Mike,

I am running 2.8.3 with my sql-ledger update. Just get the 2 files from CVS (ws_server.pl and sql-ledger.conf) and use them with the stable release.