GNUCASH SQL DRIVER

Next you need to associate this dataset with a Chart of Accounts. The document will then guide you to the administration panel of SQL-Ledger, where you are asked to create a dataset for your company. Once the automated script has done its work, you need to refer to the included README to prepare your installation by adding a user and database to PostgreSQL. Although Apache 2 uses the new nf file, it maintains the old one for backward compatibility and to support third-party applications that look for it, including SQL-Ledger. In Ubuntu, Apache 2 is run by the file placed under /etc/apache2 and makes appropriate changes to Apache’s nf.

The setup script prompts for the user and group running the Web server.

GNUCASH SQL DRIVER

On an Ubuntu Dapper box, one of the authors runs it with Perl 5.8.7, along with the libSQL-Ledger also needs a Perl database interface library, libdbi-perl, and a database driver for PostgreSQL server, libdbd-pg-perl, which is available under the universe repository. The script doesn’t check for dependencies - you’ll need to do that beforehand. It automatically downloads and installs the latest version of SQL-Ledger and updates Apache’s configuration file. Installation is straightforward just download a tarball to /usr/local/sql-ledger and run the setup.perl script. It has a good list of supported languages (29, according to the Web site), and by virtue of its HTML interface is usable on practically any modern operating system - or indeed a whole range of different operating systems simultaneously. Unlike GnuCash, however, it appears to be squarely aimed at the small business community, boasting multiple user support, multiple company support, point-of-sale entry, accounts receivable and payable, and stock tracking. Like GnuCash, supports double-entry accounting.

It’s written in Perl and stores your accounting information in a PostgreSQL database, which makes deployment much easier when you have users who work on different machines. SQL-Ledger is a popular free accounting application with a rich set of features.

Gnucash sql