[Pkg-sql-ledger-discussion] Fwd: [Ledger-smb-devel] 1.3.0beta-1: debian packages to install

Mon Dec 28 18:22:36 UTC 2009

Hi folks,

The last LedgerSMB package I released to Alioth was for the last
stable version that came out, 1.2.18. The LedgerSMB team is now
putting their effort into the 1.3 release, which is now in beta.

Unfortunately I no longer have time to contribute to this project and
for the 1.3 release cycle we need someone to take the lead where I'm
leaving off.

Below is an email from the ledgers-smb-devel list with some great
pointers that will be helpful for whoever takes over here.

Thanks everyone.

http://pkg-sql-ledger.alioth.debian.org/ledgersmb/

---------- Forwarded message ----------
From: Michael Richardson <mcr at sandelman.ca>
Date: Sun, Dec 27, 2009 at 9:49 PM
Subject: [Ledger-smb-devel] 1.3.0beta-1: debian packages to install
To: ledger-smb-devel at lists.sourceforge.net

(I'm a long sql-ledger user (since 2000-ish), somewhat recent convert to
ledgersmb (2008, I think).  I am setting up a new ledger for credil.org,
and I thought I'd give 1.3.0beta1 a trial, since I have nothing invested
yet.

I set a pw for postgres role because I thought I'd need it for the admin
interface, but I guess I do not.  Setting up sudoers to permit sudo -u
postgres is probably the best thing to do.

I think we can do a better job for the extract .tgz file and go crowd by
running a local instance of apache, and a local instance of postgresql.
I have scripts to do exactly this for unit testing another LAPP application.
I will attempt to contribute them.

For people who want a system installation, it may make sense to do
something similar.

I installed a new lenny VM today, and installed the various components
necessary to make it work.

There is a 4G / disk, and a 4G /home disk, and the postgresql data
directory has been moved to /home.  LedgerSMB is installed under ~mcr.
I provide this as a good platform on which to install something new.

marajade-[~] mcr 10224 %rsync -l rsync://junk.sandelman.ca/ledgersmb/
drwxr-xr-x        4096 2009/12/27 21:38:17 .
-rw-r--r--    20598480 2009/12/27 21:38:40 LedgerSmb13Data.dump.bz2
-rw-r--r--   575590327 2009/12/27 21:39:04 LedgerSmb13Root.dump.bz2
-rw-r--r--         463 2009/12/27 21:39:04 ledgersmb  <- XEN config file.
passwords are in /root/pw.txt, root pw is root.

====

README.debian refers to deb/* which was obsoleted.
Please update README.debian:

Installation Notes Appendix for Debian

1) sudo mv ledgersmb-httpd-13.conf /etc/apache2/sites-available
2) sudo ln -s ../sites-available/ledgersmb-httpd-13.conf
/etc/apache2/sites-enabled/ledgersmb
3) sudo a2encmod rewrite
4) sudo apt-get install postgresql-contrib
5) sudo apt-get install libmodule-install-perl libdatetime-perl \
  liblocale-maketext-lexicon-perl libdbd-pg-perl libhtml-parser-perl \
  libmime-lite-perl libconfig-std-perl liberror-perl \
  libtemplate-perl libnet-tclink-perl libparse-recdescent-perl \
  libxml-twig-perl texlive-latex3  ghostscript
6) sudo apt-get install libc6-dev
  (I dislike this part, because I'd rather not have a compiler installed)

7) perl Makefile.PL
8) sudo make
 (install the rest of the missing pieces, only two)

8) proceed upon the psql command from the INSTALL document.

Some notes:

$ psql -h localhost -W -U postgres -d template1 -f
/usr/share/postgresql/8.3/contrib/tsearch2.sql
$ createuser -h localhost -W -U postgres ledgersmb
$ createdb -h localhost -W -U postgres -O ledgersmb mycompany

====

Suggestion, rather than have LOADORDER, name the files
01-foo/02-bar/03-baz...

=== some errors I saw.

postgres at fortune:/home/mcr/ledgersmb$ psql -U postgres -d mycompany -t
-c "INSERT INTO entity (name, entity_class,created) VALUES ('myuser',
3, NOW()) RETURNING name, entity_class, created;"
ERROR:  null value in column "country_id" violates not-null constraint

postgres at fortune:/home/mcr/ledgersmb$ psql -U postgres -d mycompany -t
-c "INSERT INTO entity (name, entity_class, country_id, created)
VALUES ('myuser', 3, 1, NOW()) RETURNING name, entity_class, created;"

I don't know what country_id=1 is, but I just guessed... aha, maybe you
moved it?

postgres at fortune:/home/mcr/ledgersmb$ psql -U postgres -d mycompany -t
-c "INSERT INTO person (entity_id, first_name, last_name,
created,country_id) VALUES (2, 'Firstname', 'Lastname', NOW(),'232' )
RETURNING entity_id, first_name, last_name, created;"
ERROR:  column "country_id" of relation "person" does not exist
LINE 1: ...person (entity_id, first_name, last_name, created,country_id...
                                                            ^
postgres at fortune:/home/mcr/ledgersmb$ psql -U postgres -d mycompany -t
-c "INSERT INTO person (entity_id, first_name, last_name, created )
VALUES (2, 'Firstname', 'Lastname', NOW() ) RETURNING entity_id,
first_name, last_name, created;"
        2 | Firstname  | Lastname  | 2009-12-27

next:

postgres at fortune:/home/mcr/ledgersmb$ psql -U postgres -d mycompany -t
-c "INSERT INTO entity_employee (manager_id, entity_id, startdate,
role) VALUES (1, 2, NOW(), 'myuser') RETURNING person_id, entity_id,
startdate, role;"
ERROR:  column "person_id" does not exist
LINE 1: ...e, role) VALUES (1, 2, NOW(), 'myuser') RETURNING person_id,...

Should it be "manager_id" rather than person_id?

...

I login successfully, but error.log contains:

Unknown charname 'NULL' at /usr/share/perl/5.10/unicore/Name.pl line 161
Unknown charname 'NULL' at LedgerSMB/Form.pm line 161
DBI connect('dbname=mycompany','',...) failed: fe_sendauth: no
password supplied at LedgerSMB.pm line 739
Unknown charname 'NULL' at /usr/share/perl/5.10/unicore/Name.pl line 161
Unknown charname 'NULL' at LedgerSMB/Form.pm line 161
Unknown charname 'NULL' at /usr/share/perl/5.10/unicore/Name.pl line 161
Unknown charname 'NULL' at LedgerSMB/Form.pm line 161
Issuing rollback() for database handle being DESTROY'd without
explicit disconnect() at LedgerSMB/Template.pm line 288.
Issuing rollback() for database handle being DESTROY'd without
explicit disconnect() at LedgerSMB/Template.pm line 288.

--
]       He who is tired of Weird Al is tired of life!           |  firewalls  [
]   Michael Richardson, Sandelman Software Works, Ottawa, ON    |net architect[
] mcr at sandelman.ottawa.on.ca http://www.sandelman.ottawa.on.ca/ |device driver[
  Kyoto Plus: watch the video <http://www.youtube.com/watch?v=kzx1ycLXQSE>
                      then sign the petition.

------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

-- 
Elizabeth Krumbach // Lyz // pleia2
http://www.princessleia.com