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

[Seneca Cunningham <..hidden..>]

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