Ledger-SMB (www.ledgersmb.org) is recent fork of SQL-Ledger (www.sql-ledger.org). It is an accounting application for small businesses. It uses PERL, PostgreSQL, and Apache. I think this package is interesting and promising.
=============================================
Install of Ledger-SMB on Ubuntu Dapper 6.06.1
=============================================
1- Used Synaptic to install following and dependencies:
Apache2 2.0.55
PostgreSQL 8.1.4
postgresql-client 7.5.16.1
wwwconfig-common 0.0.44
Perl 5.8.7
libdbd-pq-perl 1.43
libdbi-perl 1.50
libmime-lite-perl 3.01
libmodule-build-perl 0.26
libhtml-parser-perl 3.48
libversion-perl 0.52
2- Download liblocale-maketext-lexicon-perl_0.62-1_all.deb from:
http://packages.ubuntulinux.org/edgy...t-lexicon-perl
move to /opt/ledgersmb
# mkdir /opt/ledger-smb
# mv liblocale-maketext-lexicon-perl_0.62-1_all.deb /opt/ledgersmb
3- Download ledgersmb-1.1.99b3-debs.tar.gz from:
http://sourceforge.net/project/showfiles.php? \
group_id=175965&package_id=208359&release_id=46589 1
move to /opt and extract:
# mv ledgersmb-1.1.99b3-debs.tar.gz /opt
# tar -zxvf ledgersmb-1.1.99b3-debs.tar.gz
# mv /opt/ledgersmb-1.1.99b3-debs/* /opt/ledgersmb
# rmdir /opt/ledgersmb-1.1.99b3-debs
4- Install packages with dselect:
# dselect
[1] Access
Mounted File System
Q1 - none
Q2 - /opt/ledgersmb
Q3 - scan
Answer none to final four questions
[2] Update
[3] Select
Use + to select package(s)
[4] Install
[5] Quit
5- edit /etc/ledger-smb/ledger-smb.conf
change made as follows:
set "latex :"
set "DBPassword = admin"
6- PostgreSQL setup:
[1] Set DB access:
/etc/postgresql/8.1/main/pg_hba.conf
local all all trust
[2] Create ledgersmb user
# su postgres
$ createuser -P ledgersmb
password = admin
superuser = y
[3] Create PostgrSQL database
# su postgres
$ createlang plpgsql template1
$ createdb -U ledgersmb ledgersmb
[4] Set up the users tables using provided file:
$ psql -U ledgersmb ledgersmb
ledgersmb=# \i /usr/share/ledgersmb/sql/Pg-central.sql
[5] Set the admin password:
$ psql -U ledgersmb ledgersmb
ledgersmb=# update users_conf set password = md5('admin');
7- Company and User setup:
Connect to: http://localhost/ledger-smb/admin.pl
[1] To set up a company:
Click "Pg Database Administration" link.
Host = localhost
Port = 5432
User = ledgersmb
Password = admin
Connect to = template1
Superuser = ledgersmb
Password = admin
Click "Create Dataset"
[2] Create Dataset = abc_company
Chart of Accounts = US_Manufacturing
Click "Continue"
If successful a success page will appear.
Click "Continue" to return to admin.pl
[3] Click "Add User"
Login = jsmith
Password = jsmith
Name = Joe Smith
Company = ABC Company
Driver = Pg
Host = localhost
Dataset = abc_company
Port = 5432
User = ledgersmb
Password = admin
Account type = Administrator
Click "Save"
8- Login access:
Local:
http://localhost/ledger-smb/login.pl
login with user "jsmith" created above
Local network:
http://<IP_or_hostname_where_installed>/ledger-smb/login.pl
login with user "jsmith" created above
9- Now go read /usr/share/doc/ledger-smb/LedgerSMB-manual.pdf.gz
Adv Reply
Bookmarks