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 ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 _______________________________________________ Ledger-smb-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
