1.3.0beta-1: debian packages to install

[Michael Richardson <..hidden..>]

(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@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@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@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@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@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[
] ..hidden.. http://www.sandelman.ottawa.on.ca/ |device driver[
   Kyoto Plus: watch the video <http://www.youtube.com/watch?v=kzx1ycLXQSE>
	               then sign the petition.