Re: upgrade problem

[Bob Miller <..hidden..>]

Hello again,

Something is wrong.... 

As per the upgrade instructions: 
1.untar over top of the existing install
2.run reload_modules.sh 

Seems simple enough (I use apache2-mpm-itk with documentroot
of /var/www/ledger.computerisms.ca/):

cd /usr/src/
wget
http://downloads.sourceforge.net/project/ledger-smb/ledgersmb/1.3.31/ledgersmb-1.3.31.tar.gz
tar zxf ledgersmb-1.3.31.tar.gz
cp -r ledgersmb/* /var/www/ledger.computerisms.ca/
chown -R ledgersmb:ledgersmb /var/www/ledger.computerisms.ca/
chmod -R o-rwx /var/www/ledger.computerisms.ca

su - postgres
sh /var/www/ledger.computerisms.ca/sql/modules/reload_modules.sh
computerisms

This script throws a number of errors (listed below).  I remember the
script thing never worked for me when I was installing, but the setup.pl
did, so I ran the upgrade from the setup.pl page too.  That appears to
have run without errors.

When I visit my page at http://ledger.computerisms.ca it shows me I am
still version 1.3.29.  When I log into it it says the same version.
But:

cat /var/www/ledger.computerisms.ca/VERSION 
1.3.31

And unfortunately the recurring transaction problem has not changed
behaviour.

Clearly I missed something along the way, was there some more
documentation I was supposed to read or something?




SCRIPT ERRORS (not including a good many "already exists" errors):

<snip></snip>
BEGIN
psql:Fixes.sql:66: ERROR:  constraint "entity_bank_account_pkey" of
relation "entity_bank_account" does not exist
psql:Fixes.sql:67: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:Fixes.sql:68: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:Fixes.sql:69: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
ROLLBACK
BEGIN
psql:Fixes.sql:87: ERROR:  schema "lsmb12" does not exist
LINE 3:                             FROM account JOIN lsmb12.chart U...
                                                      

<snip></snip>

BEGIN
psql:Fixes.sql:516: ERROR:  column reference "id" is ambiguous
LINE 5:                                  IN (select id 
                                                    ^
ROLLBACK
psql:Drafts.sql:7: ERROR:  type "draft_search_result" already exists
CREATE FUNCTION

<snip></snip>

psql:Reconciliation.sql:358: ERROR:  syntax error at or near "in_scn"
LINE 121:     in_scn NOT LIKE t_prefix || '%';
              ^
psql:Reconciliation.sql:373: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:Reconciliation.sql:441: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:Reconciliation.sql:445: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:Reconciliation.sql:462: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:Reconciliation.sql:465: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:Reconciliation.sql:478: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:Reconciliation.sql:498: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:Reconciliation.sql:501: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:Reconciliation.sql:530: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:Reconciliation.sql:540: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:Reconciliation.sql:542: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:Reconciliation.sql:548: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:Reconciliation.sql:557: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:Reconciliation.sql:561: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:Reconciliation.sql:588: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:Reconciliation.sql:594: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:Reconciliation.sql:612: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:Reconciliation.sql:626: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:Reconciliation.sql:629: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
ROLLBACK





-- 
Computerisms
Bob Miller      
867-334-7117 / 867-633-3760
http://computerisms.ca


On Mon, 2013-05-13 at 09:31 -0700, Bob Miller wrote:
> Hi Guys,
> 
> Thanks for taking a look.
> 
> I will make the upgrade, hopefully today, but if not then for sure this
> week...


------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users