Round 2: Need help with SL 2.6.19 --> LS 1.2.0b3 upgrade

[..hidden..]

Short version:

I made it past the DB permissions and now fail inside import_users.pl

edited ledger-smb.conf

DBConnect  = dbi:Pg:dbname=prodlsmb;host=localhost;port=5432
DBUserName   = 'Ledger-SMB_Owner'
#DBPassword   = set me to correct password

then

$ ./import_members.pl users/members

DBI 
connect('dbname=prodlsmb;host=localhost;port=5432',''Ledger-SMB_Owner'',...)
 failed: FATAL:  role "'Ledger-SMB_Owner'" does not exist
 at LedgerSMB/Sysconfig.pm line 99
Error: No GlobalDBH Configured or Could not Connect
Compilation failed in require at LedgerSMB/User.pm line 35.
BEGIN failed--compilation aborted at LedgerSMB/User.pm line 35.
Compilation failed in require at ./import_members.pl line 28.
BEGIN failed--compilation aborted at ./import_members.pl line 28.



Need help in the import_users script.

Thanks in advance,

Louis


**********************************************

Long version:

***********************************************

pass number 2....



(1) unpack ledger-smb-1.2.0b3.tar.gz in /tmp and read releasenotes and
UPGRADE, etc.



(2) do the Build.pl thing in /tmp and make sure all CPAN modules are present.





(3) make a clean copy

/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  jb.conf       members          sql-ledger.eps  test.conf
Hethcote-Logo.png  lbmoore.conf  root login.conf  sql-ledger.png
/usr/local/ledger-smb#


$ psql template1
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

template1=#  drop database prodlsmb;
DROP DATABASE
template1=> \q




(4) Use pg_dump insteat createdb -T to make the transistion database

$ pg_dump hethcote > sl-2-ls.sql

$  sed -i -e's/SQL-Ledger_Owner/Ledger-SMB_Owner/' sl-2-ls.sql

$ createdb -O Ledger-SMB_Owner  prodlsmb
CREATE DATABASE

$ psql prodlsmb
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

prodlsmb=#  \i sl-2-ls.sql
.
.
.

GRANT

Prodlsmb=# select version from defaults;
 version 
---------
 2.6.12
(1 row)


edit users/members, et al to change prodsqlg to prodlsmb and 
dbuser appropriately


unpack ledger-smb-1.2.0b3.tar.gz over /usr/local/ledger-smb and
correct ownership with chown -R

prodlsmb=> \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
prodlsmb=> select version from defaults;
 version 
---------
 2.6.17
(1 row)

prodlsmb=> \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
prodlsmb=>  select version from defaults;
 version 
---------
 2.6.18
(1 row)

prodlsmb=>  \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
prodlsmb=> update users_conf set password = md5('my_password');
UPDATE 1
prodlsmb=> \q

<<< Yay >>>


(5) run the import-users script

cp ledger-smb.conf.default ledger-smb.conf

set:

DBConnect  = dbi:Pg:dbname=prodlsmb;host=localhost;port=5432
DBUserName   = 'Ledger-SMB_Owner'
#DBPassword   = set me to correct password



$ ./import_members.pl users/members

DBI connect('dbname=prodlsmb;host=localhost;port=5432',''Ledger-SMB_Owner'',...) failed: FATAL:  role "'Ledger-SMB_Owner'" does not exist
 at LedgerSMB/Sysconfig.pm line 99
Error: No GlobalDBH Configured or Could not Connect
Compilation failed in require at LedgerSMB/User.pm line 35.
BEGIN failed--compilation aborted at LedgerSMB/User.pm line 35.
Compilation failed in require at ./import_members.pl line 28.
BEGIN failed--compilation aborted at ./import_members.pl line 28.