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

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




Thanks for looking.

Postgres has a user Ledger-SMB_Owner, it was created prior to the createdb and the load of the old SL database.


prodlsmb=> \du
                                  List of roles
   Role name     | Superuser | Create role | Create DB | Connections |Member of
-----------------+-----------+-------------+-----------+-------------+----------
Ledger-SMB_Owner | no        | no          | yes       | no limit    |
SQL-Ledger_Owner | no        | no          | yes       | no limit    |

.
.
.

I'm beginning to suspect that having a '-' in the name causes some difficulties so I'll try a different username tomorrow. Don't know if it will affect import_users script, but it will at least remove some need for quoting.

Louis



On Sat, 25 Nov 2006, Seneca Cunningham wrote:

On Sat, Nov 25, 2006 at 07:59:19PM -0700, ..hidden.. wrote:
$ ./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.

Did you create the database user 'Ledger-SMB_Owner' before starting?  I
noticed in your long form you used sed to change the database user in
the various statements, but pg_dump does not create roles.

--
Seneca
..hidden..

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