[ejabberd] Problem with native postgresql driver and web admin

Teemu Harju teemu.harju at gmail.com
Mon Oct 15 09:39:57 MSD 2007


Hi,

I switched to use ODBC and now it works, so problem is kind of solved. Any
comments about which method is better, the native PostgreSQL or the ODBC
one? Or is there really any difference?

Thanks,

Teemu

On 10/11/07, Teemu Harju <teemu.harju at gmail.com> wrote:
>
> Hi,
>
> I seem to have a strange problem with the postgresql and web admin. I'm
> using ejabberd 1.1.4 and the native postgresql driver from jungerl
> package. Then problem is that I cannot login to the web admin page. I always
> get "401 Unauthorized" when trying to login with correct username at domainand password combination. I tried with internal authentication using mnesia
> and it worked just fine. So it would seem that there is nothing wrong with
> my configuration. The database connection to postgresql seems to work since
> I'm able to add users using ejabberdctl when postgresql is configured.
>
> The config for postgres is like this...
>
> {auth_method, odbc}.
> {odbc_server, {pgsql, "localhost", "ejabberd", "ejabberd", "ejabberd"}}.
>
> If I comment that out and switch to...
>
> %{auth_method, internal}.
>
> ... then everything works.
>
> Logs don't seem to show anything special.
>
> Regards,
>
> - Teemu
>
> --
> Teemu Harju
>
> email/jabber: teemu.harju at gmail.com
> blog: http://www.teemuharju.net
>
> ~~ "A computer is like air conditioning: it becomes useless when you open
> windows." ~~




-- 
Teemu Harju

email/jabber: teemu.harju at gmail.com
blog: http://www.teemuharju.net

~~ "A computer is like air conditioning: it becomes useless when you open
windows." ~~
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jabber.ru/pipermail/ejabberd/attachments/20071015/fc565741/attachment.htm 


More information about the ejabberd mailing list