I’'m trying to setup wildfire (3.1.0) in cooperation with an existing database. What I would like to accomplish is to fetch users and passwords from that db. I encode passwords with md5 hash and keep them in the db. I tried to use instructions given in file documentation/docs/db-integration-guide.html from wildfire source distribution - specifically the point called “Authentication integration”. However this does not work. Is it known to not work or maybe I should post more details?
the post above should help you to solve the “url cannot be null” issue.
“If this way of using md5 hashes does not work and will no longer be available, than what is a recomended way to do this?” md5 hashes do still work as the auth provider is fine. Just the user provider has a problem.
I had some hard time posting to this forum lately, so my reply is quite late.
I’'ve tried the suggested solution and it still does not work. However it outcomes in a new error message, which is:
2006.11.02 09:59:40 org.jivesoftware.wildfire.auth.JDBCAuthProvider.getPasswordValue(JDBCAuthProvide r.java:208) Exception in JDBCAuthProvider
org.postgresql.util.PSQLException: FATAL: no PostgreSQL user name specified in startup packet
My config looks almost exactly the same way as I posted previously, but I’'ve added these lines:
but this gives nothing new. Is the tag wrong? How to specify that username?
By the way, it would be nice to have a xml file with all the configuration possibilities, because javadoc isn’'t of much help (at least in this particular situation).
You were right as for the connectionString. I had to add this.
But new errors follow:
2006.11.02 20:57:42 org.jivesoftware.wildfire.auth.JDBCAuthProvider.getPasswordValue(JDBCAuthProvide r.java:208) Exception in JDBCAuthProvider
org.postgresql.util.PSQLException: Index out of bound: 1, number of columns: 0.
The only thing added is the ?user=–&password=– part, nothing more. This seems to be an error on line 205 in JDBCAuthProvider.java However it seems unreasonable, because I’'ve passed password parameter.