Custom Postgress db. User Authentication SHA1

Hello All,

I’m using django portal and openfire.

trying to use external authentication with openfire 3.7.1

Postgres query :

SELECT password FROM public.auth_user WHERE username = ‘test’;

result is = sha1$94db8$c1e29c1f21d797d281b2dfa8a653c2a6d2f197d9

Openfire config :

org.jivesoftware.openfire.auth.JDBCAuthProvider

SELECT password FROM public.auth_user WHERE username = ?

sha1

Keeps telling me :

2012.11.13 20:34:59 org.jivesoftware.openfire.net.SASLAuthentication - User Login Failed. PLAIN authentication failed for: test

Please advice.

Thanks,

Oliver