I tried to follow all the indicated steps to connect ejabberd and PostgresQL, using native driver.

At the moment I'm only able to create users but I can't login.

I always get a 401 error, either using a Jabber client or ejabberd's web admin tool.

The log looks like this:

=INFO REPORT==== 8-Dec-2007::15:37:18 ===
I(<0.221.0>:ejabberd_listener:90): (#Port<0.416>) Accepted connection {{192,168,1,71},51024} -> {{192,168,1,66},5222}
D(<0.599.0>:ejabberd_receiver:261) : Received XML on stream = "<stream:stream to=\"HOSTNAME\" xmlns=\"jabber:client\" xmlns:stream=\"http://etherx.jabber.org/streams\" xml:lang=\"pt_PT\" version=\"1.0\" >"
D(<0.598.0>:ejabberd_c2s:1236) : Send XML on stream = "<?xml version='1.0'?><stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='1344024846' from='HOSTNAME' version='1.0' xml:lang='en'>"
D(<0.598.0>:ejabberd_c2s:1236) : Send XML on stream = "<stream:features><starttls xmlns='urn:ietf:params:xml:ns:xmpp-tls'/><mechanisms xmlns='urn:ietf:params:xml:ns:xmpp-sasl'><mechanism>DIGEST-MD5</mechanism><mechanism>PLAIN</mechanism></mechanisms><register xmlns='http://jabber.org/features/iq-register'/></stream:features>"
D(<0.599.0>:ejabberd_receiver:261) : Received XML on stream = "<starttls xmlns=\"urn:ietf:params:xml:ns:xmpp-tls\"/>"
D(<0.599.0>:ejabberd_receiver:261) : Received XML on stream = []
D(<0.598.0>:ejabberd_c2s:1236) : Send XML on stream = "<proceed xmlns='urn:ietf:params:xml:ns:xmpp-tls'/>"
D(<0.599.0>:ejabberd_receiver:261) : Received XML on stream = []
D(<0.599.0>:ejabberd_receiver:261) : Received XML on stream = []
D(<0.599.0>:ejabberd_receiver:261) : Received XML on stream = "<stream:stream to=\"HOSTNAME\" xmlns=\"jabber:client\" xmlns:stream=\"http://etherx.jabber.org/streams\" version=\"1.0\" >"
D(<0.598.0>:ejabberd_c2s:1236) : Send XML on stream = "<?xml version='1.0'?><stream:stream xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' id='297966530' from='HOSTNAME' version='1.0' xml:lang='en'>"
D(<0.598.0>:ejabberd_c2s:1236) : Send XML on stream = "<stream:features><mechanisms xmlns='urn:ietf:params:xml:ns:xmpp-sasl'><mechanism>DIGEST-MD5</mechanism><mechanism>PLAIN</mechanism></mechanisms><register xmlns='http://jabber.org/features/iq-register'/></stream:features>"
D(<0.599.0>:ejabberd_receiver:261) : Received XML on stream = "<auth mechanism=\"DIGEST-MD5\" xmlns=\"urn:ietf:params:xml:ns:xmpp-sasl\"/>"
D(<0.598.0>:ejabberd_c2s:1236) : Send XML on stream = "<challenge xmlns='urn:ietf:params:xml:ns:xmpp-sasl'>bm9uY2U9IjExMDI4NzM4MDIiLHFvcD0iYXV0aCIsY2hhcnNldD11dGYtOCxhbGdvcml0aG09bWQ1LXNlc3M=</challenge>"
D(<0.599.0>:ejabberd_receiver:261) : Received XML on stream = "<response xmlns=\"urn:ietf:params:xml:ns:xmpp-sasl\">dXNlcm5hbWU9InNiYjIiLHJlYWxtPSIiLG5vbmNlPSIxMTAyODczODAyIixjbm9uY2U9ImU0YmVjMjEzMjAwMmEyNWVkYjk0Yjk3ODFkYTFlMGMyIixuYz0wMDAwMDAwMSxxb3A9YXV0aCxkaWdlc3QtdXJpPSJ4bXBwL21pbmdsZS1kZXYiLGNoYXJzZXQ9dXRmLTgscmVzcG9uc2U9YjcwZWU4ZDU5NTIzNjFlYmIzZjEyZmUyMThlYjljZDA=</response>"
D(<0.598.0>:ejabberd_c2s:1236) : Send XML on stream = "<failure xmlns='urn:ietf:params:xml:ns:xmpp-sasl'><not-authorized/></failure>"
D(<0.599.0>:ejabberd_receiver:261) : Received XML on stream = []

Any hint?

Thanks.

Sergio Bessa