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
