I am having authentication issues with a couple of my usernames. I created the following users with corresponding passwords:
I am able to login with tatiane.marshall, but not the other two. Using my admin ID, I go to the Admin Users section and edit both of the problem users by setting their password again. Unfortunately, this doesn't change anything. In my apache error_log I get the following errors:
[Mon Feb 06 14:34:58 2012] [error] [client 192.168.1.50] DBI connect('dbname=StallusBoutique','marisa.mendes',...) failed: FATAL: password authentication failed for user "marisa.mendes" at /usr/lib/perl5/site_perl/5.14.2/LedgerSMB.pm line 982, referer: http://192.168.1.10/ledgersmb/login.pl
[Mon Feb 06 14:37:41 2012] [error] [client 192.168.1.50] DBI connect('dbname=StallusBoutique','neidiane.pereira',...) failed: FATAL: password authentication failed for user "neidiane.pereira" at /usr/lib/perl5/site_perl/5.14.2/LedgerSMB.pm line 982, referer: http://192.168.1.10/ledgersmb/login.pl
At one point, I changed one of the user's password to the same as mine to make sure it wasn't bombing on the actual password for some reason. It still failed though. In case it is relevant, the working username (tatiane.marshall) was the last one created.
As an update, I am able to login to PostgreSQL via psql from the server using both of the problem user IDs. From the prompt I entered:
psql StallusBoutique -U neidiane.pereira -W
After being prompted, I enter this user's password and successfully connect.