Oliver Elphick wrote:
On Mon, 2004-06-14 at 20:01, Tom Allison wrote:

I'm running my authentication through a pgsql database with passwords that are stored as md5 hashes of the password.
This authentication model is working for the dovecot imap server.


However, under openwebmail I am accessing the database through 'localhost' instead of sockets and I keep getting a postgres pg_hba.conf configuration error. The affecting line is:

host    all   all 127.0.0.1          md5

2004-06-14 21:58:22 [24670] LOG: connection received: host=127.0.0.1 port=33487
2004-06-14 21:58:22 [24670] LOG: invalid entry in pg_hba.conf file at line 89, token "md5"


You have left out the netmask field

Thank you for your reply. I missed that one address, 127.0.0.1, uses the netmask 255.255.255.255.



dovecot accesses the database for authenction through a line that says:
local    all         all             md5
(successfully).


Right now I have to figure this out, but my openwebmail part of the question is, can I set the host to a local socket?


If the hostname is blank, rather than "localhost", you will get a Unix
socket


I can get a connection through 127.0.0.1. (I could/should switch to sockets someday) and I can connect from other machines as well (more typos!) But I get clobbered with this now.

[Tue Jun 15 05:53:24 2004] openwebmail.pl: DBI connect('dbname=dbmail;host=127.0.0.1','',...) failed:
fe_sendauth: no password supplied at /usr/lib/cgi-bin/openwebmail/auth/auth_pgsql.pl line 48


Because of my user information on $HOME coming from /etc/passwd, I've left these blank. I don't see that they are causing any problems with the openwebmail script. So the following are blank.

field_realname
field_uid               
field_gid               
field_home              


If I use the openwebmail params to connect, I can do it successfully from psql and from a perl (DBI) script. auth_pgsql.pl (openwebmail) complains about the lack of a password.


The problem keeps cropping up that the sqlusr parm in the config file is not loaded. The username matches /\w+/

really stuck.


--
To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Reply via email to