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: lrspare...@aol.com Subject: Re: [Ledger-smb-users] Still Cannot Log In To: ledger-smb-users@lists.sourceforge.net Message-ID: <8cf7e66ea982cf7-1dd4-16...@webmail-d177.sysops.aol.com> 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 ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_sfd2d_oct _______________________________________________ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
