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

[..hidden..]

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!