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

[..hidden..]

Thanks for the information.

As it happens it fails differently without the ' character. I'm changing 
the DNUserName so that postgresql is happier:

template1=# ALTER USER Ledger-SMB_Owner RENAME TO ledgersmb;
ERROR:  syntax error at or near "-" at character 18
LINE 1: ALTER USER Ledger-SMB_Owner RENAME TO ledgersmb;
                         ^
template1=# ALTER USER 'Ledger-SMB_Owner' RENAME TO ledgersmb;
ERROR:  syntax error at or near "'Ledger-SMB_Owner'" at character 12
LINE 1: ALTER USER 'Ledger-SMB_Owner' RENAME TO ledgersmb;
                   ^
template1=# ALTER USER "Ledger-SMB_Owner" RENAME TO ledgersmb;
ALTER ROLE
template1=#

I'll try with a username that does not require quoting and report back.

Louis



On Sun, 26 Nov 2006, Mads Kiilerich wrote:

> ..hidden.. wrote, On 11/26/2006 03:59 AM:
> > edited ledger-smb.conf
> >
> > DBConnect  = dbi:Pg:dbname=prodlsmb;host=localhost;port=5432
> > DBUserName   = 'Ledger-SMB_Owner'
> > #DBPassword   = set me to correct password
> ...
> > 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
>
> Try to remove the ' around DBUsername. The config reader do not
> understand it and will include them in the username.
>
> /Mads
>
>
> -------------------------------------------------------------------------
> 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