[ejabberd] postgresql ssl connection

Toby Thain toby at telegraphics.com.au
Mon May 9 16:13:55 MSD 2011


On 08/05/11 10:25 PM, zhong ming wu wrote:
> Hello
> 
> I have managed to make ejabberd to use postgresql.
> 
> As a first experimental step I used postgres database on the same
> machine as ejabberd.
> 
> The next step is to use a postgresql database hosted on another
> machine.  But I want to use ssl connection.  Ideally I would like to
> make ejabberd to use client certificate.  But I could not even make it
> connect to the postgresql database using password authentication.
> 
> Here is ejaberd.log
> ---------------------
> I(<0.305.0>:ejabberd_odbc:216) : pgsql connection failed:
> ** Reason: {authentication,[{severity,'FATAL'},
>                             {code,"28000"},
>                             {message,"no pg_hba.conf entry for host
> \"10.10.10.10\", 

Did you deal with this error ^^ ?

--Toby


> user \"xmpp\", database \"xmpp\", SSL off"},
>                             {file,"auth.c"},
>                             {line,464},
>                             {routine,"ClientAuthentication"}]}
> 
> ------------------
> 
> If I do not enforce that client connects via ssl, then I don't get
> this error.  Which leads me to guess that erlang pgsql library can't
> use ssl.
> 
> Can someone tell me how I can make ejabberd use ssl to connect to
> postgres server?
> 
> Thanks
> 
> mr.wu
> _______________________________________________
> ejabberd mailing list
> ejabberd at jabber.ru
> http://lists.jabber.ru/mailman/listinfo/ejabberd
> 



More information about the ejabberd mailing list