The process followed was (and should be useful in the UPGRADE document):
***********************************
(1) unpack ledger-smb-1.2.0b3.tar.gz in /tmp and read release notes and
UPGRADE, etc.
***********************************
(2) do the Build.pl thing in /tmp and make sure all CPAN modules are
present.
***********************************
(3) make a clean copy of sql-ledger 2.6.19 in ledger-smb directory
/usr/local# rm -rf ledger-smb
/usr/local# mkdir ledger-smb
/usr/local# cd ledger-smb
/usr/local/ledger-smb# cp -a ../sql-ledger/* ./
/usr/local/ledger-smb# more VERSION
2.6.19
/usr/local/ledger-smb# ls users/
Hethcote-Logo.eps members root\ login.conf sql-ledger.png
Hethcote-Logo.png lbmoore.conf sql-ledger.eps
*************************************
(4) prepare a clean sql-ledger 2.6.19 database
$ psql template1
Welcome to psql 8.1.4, the PostgreSQL interactive terminal.
template1=# drop database prodlsmb;
DROP DATABASE
template1=> \q
$ pg_dump slprod > sl-2-ls.sql
$ sed -i -e's/SQL-Ledger_Owner/ledgersmb/' sl-2-ls.sql
$ createdb -O ledgersmb lsmbprod
CREATE DATABASE
*************************************
(5) Load the clean sql-ledger 2.6.19 database with data
$ psql lsmbprod ledgersmb
lsmbprod=> \i sl-2-ls.sql
.
.
.
GRANT
lsmbprod=> select version from defaults;
version
---------
2.6.12
(1 row)
*****************************************
(6) edit users/members, et al to change slprod to lsmbprod and
dbuser appropriately
*****************************************
(7) unpack ledger-smb-1.2.0b3.tar.gz over /usr/local/ledger-smb and
correct ownership with chown -R
*****************************************
(8) Apply the database upgrades
lsmbprod=> \i Pg-upgrade-2.6.12-2.6.17.sql
psql:Pg-upgrade-2.6.12-2.6.17.sql:1: ERROR: relation "session_session_id_seq"
already exists
psql:Pg-upgrade-2.6.12-2.6.17.sql:8: ERROR: relation "session" already exists
ALTER TABLE
ALTER TABLE
UPDATE 4939
ALTER TABLE
ALTER TABLE
UPDATE 1
lsmbprod=> select version from defaults;
version
---------
2.6.17
(1 row)
lsmbprod=> \i Pg-upgrade-2.6.17-2.6.18.sql
BEGIN
psql:Pg-upgrade-2.6.17-2.6.18.sql:2: NOTICE: ALTER TABLE / ADD PRIMARY
KEY will create implicit index "chart_pkey" for table "chart"
ALTER TABLE
LOCK TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
UPDATE 4939
.
.
.
CREATE FUNCTION
UPDATE 1
COMMIT
lsmbprod=> select version from defaults;
version
---------
2.6.18
(1 row)
lsmbprod=> \i Pg-upgrade-2.6.18-2.6.19.sql
BEGIN
psql:Pg-upgrade-2.6.18-2.6.19.sql:3: NOTICE: ALTER TABLE / ADD PRIMARY
KEY will
create implicit index "ap_pkey" for table "ap"
ALTER TABLE
.
.
.
COMMENT
INSERT 0 26
DROP TABLE
CREATE FUNCTION
CREATE FUNCTION
COMMIT
lsmbprod=> update users_conf set password = md5('my_password');
UPDATE 1
lsmbprod=> \q
*******************************************
(9) Edit ledger_smb.conf to have the correct postgresql values
*******************************************
(10) ./import_members.pl users/members
with the results indicated in the first email of this thread
I am confident that the upgrade steps 1-5 were completed.
Louis
On Sun, 26 Nov 2006, Mads Kiilerich wrote:
> It sounds to me like your database hasn't been upgraded.
> Are you following the description in UPGRADE and have you completed all
> steps until step 6?
>
> /Mads
>
>
> [EMAIL PROTECTED] wrote, On 11/26/2006 10:08 PM:
>> import_users script creates a user $1 ? and cannot login, details follow.
>>
>>
>> -------- ledger-smb.conf:
>> .
>> .
>> .
>>
>> [globaldb]
>> # These paramaters *must* be set correctly
>> # for LedgerSMB >= 1.2 to work
>> DBConnect = dbi:Pg:dbname=lsmbprod;host=localhost;port=5432;
>> DBUserName = ledgersmb
>> #DBPassword = set me to correct password
>>
>>
>>
>> -------- users/members
>>
>> # SQL-Ledger Accounting members
>>
>> [root login]
>> password=
>>
>> [lbmoore]
>> acs=
>> address=PMB 504
>> businessnumber=
>> company=Hethcote Antiquarian
>> countrycode=zz
>> currency=USD
>> dateformat=mm-dd-yy
>> dbconnect=dbi:Pg:dbname=lsmbprod;host=localhost;
>> dbdriver=Pg
>> dbhost=localhost
>> dbname=lsmbprod
>> dboptions=set DateStyle to 'POSTGRES, US'
>> dbpasswd=
>> dbport=5432
>> dbuser=ledgersmb
>> [EMAIL PROTECTED]
>> fax=
>> menuwidth=
>> name=Louis B. Moore
>> numberformat=1,000.00
>> password=xxxxxxxxxxx
>> printer=
>> role=user
>> sid=
>> signature=
>> stylesheet=lbmoore-sql-ledger.css
>> tel=
>> templates=templates/prod
>> timeout=3600
>> vclimit=200
>>
>>
>> *************************************************************
>>
>> the Results
>>
>> ************************************************************
>>
>> caritas$ ./import_members.pl users/members
>>
>>
>> Parsing members file completed. Now trying to import user data.
>>
>> Import of user 'lbmoore' seems to have succeeded.
>>
>> SUCCESS! It seems that every user in the members file was imported!
>>
>> caritas$ psql lsmbprod
>> Welcome to psql 8.1.4, the PostgreSQL interactive terminal.
>>
>> Type: \copyright for distribution terms
>> \h for help with SQL commands
>> \? for help with psql commands
>> \g or terminate with semicolon to execute query
>> \q to quit
>>
>>
>> lsmbprod=# select * from users;
>> id | username
>> ----+----------
>> 1 | admin
>> 2 | $1
>> (2 rows)
>>
>>
>> attempt to run admin.pl from browser:
>>
>> [Sun Nov 26 14:03:44 2006] [error] [client 192.168.0.101] DBD::Pg::st
>> execute failed: ERROR: column session.users_id does not exist, referer:
>> http://caritas/ledger-smb/admin.pl
>> [Sun Nov 26 14:03:44 2006] [error] [client 192.168.0.101] Can't locate
>> object method "dberror" via package "LedgerSMB::User" at
>> LedgerSMB/Session/DB.pm line 162., referer:
>> http://caritas/ledger-smb/admin.pl
>> [Sun Nov 26 14:03:44 2006] [error] [client 192.168.0.101] Compilation
>> failed in require at /usr/local/ledger-smb/admin.pl line 93., referer:
>> http://caritas/ledger-smb/admin.pl
>> [Sun Nov 26 14:03:45 2006] [error] [client 192.168.0.101] Premature end of
>> script headers: admin.pl, referer: http://caritas/ledger-smb/admin.pl
>>
>>
>>
>> attempt to run login.pl from browser:
>>
>> Error!
>>
>> bin/login.pl:313: Access Denied!
>>
>> -------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share your
>> opinions on IT & business topics through brief surveys - and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> Ledger-smb-users mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>>
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Ledger-smb-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
>
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Ledger-smb-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
