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:
> [EMAIL PROTECTED] 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
> [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
