Re: Still cannot log in

[..hidden.. (Hugh Esco)]

Let me break that down for you.
I used sed to eliminate the portions of the log 
which are not relevant to the issue at hand.

As the postgres user (or another user privileged to create users 
and delegate privileges), you want to:

psql> \h CREATE ROLE

psql> CREATE ROLE rolename;

but using the guidance provided by the \h command above 
to set a password and delegate appropriate privileges.

psql> ALTER database_name OWNER TO rolename;

or something like that.

I do not have a postgresql prompt handy at the moment, 
but \h and tabbed command completion are your friends here.

Try:

psql> \l 

to get a list of your databases

psql> \du 

for a list of the existing roles or users
(I'm pretty sure it is)

psql> \h ALTER ROLE 

for advise on setting or updating a password

The advise previously posted here about pg_hba.conf 
is also relevant, but that does not seem to be your issue, 
nor do firewall issues.  

-- Hugh Esco

Message: 2
Date: Mon, 22 Oct 2012 08:21:37 -0400 (EDT)
From: ..hidden..
Subject: Re: [Ledger-smb-users] Still Cannot Log In
To: ..hidden..
Message-ID: <..hidden..>
Content-Type: text/plain; charset="us-ascii"

the postgres log is (for today)

2012-10-22 13:04:00 BST FATAL:  role "BeamendsLRS4x4" does not exist
2012-10-22 13:04:23 BST FATAL:  role "BeamendsLRS4x4" does not exist
2012-10-22 13:04:49 BST FATAL:  role "Beamends4x4LRS" does not exist
2012-10-22 13:05:17 BST FATAL:  role "ledsgersmb" does not exist

and Apache2 is (not sure how much is required, so here's all of todays!)

LedgerSMB/Auth/DB.pm:177: no such user: beamends,
LedgerSMB/Auth/DB.pm:177: no such user: beamends,
LedgerSMB/Auth/DB.pm:177: no such user: beamends,
LedgerSMB/Auth/DB.pm:177: no such user: richard,
LedgerSMB/Auth/DB.pm:177: no such user: beamends,
LedgerSMB/Auth/DB.pm:177: no such user: beamends,
LedgerSMB/Auth/DB.pm:177: no such user: beamends,
LedgerSMB/Auth/DB.pm:177: no such user: beamends,
LedgerSMB/Auth/DB.pm:177: no such user: Richard,
LedgerSMB/Auth/DB.pm:177: no such user: beamends,
LedgerSMB/Auth/DB.pm:177: no such user: richard,
LedgerSMB/Auth/DB.pm:177: no such user: beamends,
FATAL:  role "BeamendsLRS4x4" does not exist at LedgerSMB.pm line 981,
LedgerSMB/Auth/DB.pm:177: no such user: beamends,
FATAL:  role "BeamendsLRS4x4" does not exist at LedgerSMB.pm line 981,
FATAL:  role "Beamends4x4LRS" does not exist at LedgerSMB.pm line 981,
LedgerSMB/Auth/DB.pm:177: no such user: postgres,
FATAL:  role "ledsgersmb" does not exist at LedgerSMB.pm line 981,
LedgerSMB/Auth/DB.pm:177: no such user: Richard,
LedgerSMB/Auth/DB.pm:177: no such user: beamends,
LedgerSMB/Auth/DB.pm:177: no such user: beamends,

Thanks,
Richard