Re: openwebmail + postgresql configuration

[Oliver Elphick <olly@lfix.co.uk>]

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

> 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

-- 
Oliver Elphick                                          olly@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA  92C8 39E7 280E 3631 3F0E  1EC0 5664 7A2F A543 10EA
                 ========================================
     "Therefore being justified by faith, we have peace with
      God through our Lord Jesus Christ."       Romans 5:1