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

Re: Round 3: SL 2.6.19 --> LS 1.2.0b3 upgrade, import_users script

Subject: Re: Round 3: SL 2.6.19 --> LS 1.2.0b3 upgrade, import_users script
From: ..hidden..
Date: Sun, 26 Nov 2006 17:28:03 -0700 (MST)


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 arepresent.



***********************************
(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 PRIMARYKEY 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 PRIMARYKEY 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


..hidden.. 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
..hidden..
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
..hidden..
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
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

References:
- Round 3: SL 2.6.19 --> LS 1.2.0b3 upgrade, import_users script
  - From: lbmlist
- Re: Round 3: SL 2.6.19 --> LS 1.2.0b3 upgrade, import_users script
  - From: Mads Kiilerich

Prev by Date: Re: Round 3: SL 2.6.19 --> LS 1.2.0b3 upgrade, import_users script
Next by Date: Re: ledger-smb.conf example
Previous by thread: Re: Round 3: SL 2.6.19 --> LS 1.2.0b3 upgrade, import_users script
Next by thread: Re: Unable to use admin functions -- Solved
Index(es):
- Date
- Thread