[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

First upgrade attempt from 1.2.21 -> 1.3.0RC4 == Fail




Upgrading 1.2.21 on a Debian squeeze machine with PostgreSQL 8.4.8.

Summarizing the steps, which I script for ease of repeating:

dropdb lsmb13
rm -f ./LedgerUpg/lsmb-to-1.3.sql
dropuser ledgernew
pg_dump -C lsmbprod > ./LedgerUpg/lsmb-to-1.3.sql
sed -i -e's/lsmbprod/lsmb13/g' ./LedgerUpg/lsmb-to-1.3.sql
sed -i -e's/ledgersmb/ledgernew/g' ./LedgerUpg/lsmb-to-1.3.sql
createuser  --no-createdb --no-createrole --no-superuser ledgernew
psql -f ./LedgerUpg/lsmb-to-1.3.sql
psql -f ./LedgerUpg/fix-up-1.2.sql cd /usr/local
sudo rm -rf lsmb130/
sudo tar --transform='s/^ledgersmb/lsmb130/' -x -z -f /PATH/TO/projects/thirdparty/LedgerUpg/ledgersmb-1.3.0_rc4.tar.gz cd lsmb130
sudo perl Makefile.PL
sudo make
sudo cp /PATH/TO/projects/thirdparty/LedgerUpg/ledgersmb.conf lsmb130/



Then I browse to localhost/lsmb13/setup.pl

Fill in my info and it basically dropped all the tables from the lsmb13 database and complained about permissions for writing to /dblog_stdout.

[Wed Oct 05 20:45:18 2011] [error] [client 127.0.0.1] DBD::Pg::st execute failed: ERROR:  column "version" does not exist, referer: http://localhost/lsmb13/setup.pl
[Wed Oct 05 20:45:18 2011] [error] [client 127.0.0.1] LINE 1: SELECT version FROM defaults, referer: http://localhost/lsmb13/setup.pl
[Wed Oct 05 20:45:18 2011] [error] [client 127.0.0.1]                ^ at LedgerSMB/Database.pm line 208., referer: http://localhost/lsmb13/setup.pl
[Wed Oct 05 20:45:18 2011] [error] [client 127.0.0.1] DBD::Pg::st fetchrow_hashref failed: no statement executing at LedgerSMB/Database.pm line 209., referer: http://localhost/lsmb13/setup.pl
[Wed Oct 05 20:45:18 2011] [error] [client 127.0.0.1] Issuing rollback() due to DESTROY without explicit disconnect() of DBD::Pg::db handle dbname=lsmb13 at scripts/setup.pl line 58., referer: http://localhost/lsmb13/setup.pl
[Wed Oct 05 20:45:49 2011] [error] [client 127.0.0.1] sh: cannot create /dblog_stdout: Permission denied, referer: http://localhost/lsmb13/setup.pl
[Wed Oct 05 20:45:49 2011] [error] [client 127.0.0.1] sh: cannot create /dblog_stdout: Permission denied, referer: http://localhost/lsmb13/setup.pl
[Wed Oct 05 20:45:49 2011] [error] [client 127.0.0.1] sh: cannot create /dblog_stdout: Permission denied, referer: http://localhost/lsmb13/setup.pl
[Wed Oct 05 20:45:49 2011] [error] [client 127.0.0.1] sh: cannot create /dblog_stdout: Permission denied, referer: http://localhost/lsmb13/setup.pl
[Wed Oct 05 20:45:57 2011] [error] [client 127.0.0.1] Can't locate LedgerSMB/Template/text.pm in @INC (@INC contains: /etc/perl /usr/local/lib/perl/5.10.1 /usr/local/share/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl /usr/local/lib/perl/5.10.0 /usr/local/share/perl/5.10.0 .) at (eval 81) line 3., referer: http://localhost/lsmb13/setup.pl
[Wed Oct 05 20:45:57 2011] [error] [client 127.0.0.1] Compilation failed in require at /usr/local/lsmb130/setup.pl line 3., referer: http://localhost/lsmb13/setup.pl
[Wed Oct 05 20:45:57 2011] [error] [client 127.0.0.1] Premature end of script headers: setup.pl, referer: http://localhost/lsmb13/setup.pl


My next steps are:

to decide who should own the lsmb130 directories and files;

make sure that $ENV{TEMP} is set where I want it and that it is writable to ledgersmb;


My first questions are:

1) when prompted for contrib directory I assumed it should be ./contrib/ as a relative path to the root of lsmb130, is that correct?

2) are the default AP and AR accounts the account numbers from the 1.2.21 DB?



I'll report back as I get more data.

Louis