Stumped on user authentication

Dave_Parker · August 25, 2006, 7:47pm

Hi all.

Firstly, I just wanted to give a big thumbs up to the guys writing this software… excellent!

Okay… I’'ve installed the server, and done some initial tests, and all seems good. Now I need to move on to the next step.

Scenario:

I have a mySQL database called osdgndb which has a table in it containing the user details.

I have another mySQL database which holds the information for WildFire

How do I get WildFire using the wildfire.xml file to retrieve the user details in the osdgndb file so I can integrate/authenticate against that set of users rather than make them register twice, once for the website, and once for the messenger (i.e. they use their same site username and password). Tried following the instructions on the site to do this, but to no avail. Using the 3.0.1 release of WildFire.

Any help greatly appreciated.

Cheers

Dave

Aznidin · August 26, 2006, 6:57pm

Hi Dave,

waveyuk wrote:
Tried following the instructions on the site to do this, but to no avail. Using the 3.0.1 release of WildFire.

I’‘m just wondering at which stage you’'re stuck. Did you miss the Custom Database Integration Guide?

Dave_Parker · August 26, 2006, 8:30pm

Hi there…

Yup… tried that. Worked out in the end that I’'d left the comments in.

However… when I tried to log in, got a load of errors. So, have loaded the 3.1 beta.

I’‘m not getting the errors now, but likewise I can’‘t log in to the admin page, even though I’'ve added an admin entry that matches a usrname in the table. The passwords are stored as md5 hash.

So I am completely stumped. It’'s a shame because the wildfire platform is ideal for my site.

Dave_Parker · August 27, 2006, 12:20am

After a break of a few hours… looked at the error.log and getting this…

2006.08.27 01:12:31 org.jivesoftware.wildfire.auth.JDBCAuthProvider.getPasswordValue(JDBCAuthProvide r.java:208) Exception in JDBCAuthProvider

java.sql.SQLException: The url cannot be null

at java.sql.DriverManager.getConnection(Unknown Source)

at org.jivesoftware.wildfire.auth.JDBCAuthProvider.getPasswordValue(JDBCAuthProvid er.java:194)

at org.jivesoftware.wildfire.auth.JDBCAuthProvider.authenticate(JDBCAuthProvider.j ava:104)

at org.jivesoftware.wildfire.auth.AuthFactory.authenticate(AuthFactory.java:126)

…

Any ideas? Anyone

Aznidin · August 27, 2006, 11:38am

Did you specify jdbcProvider.connectionString property in wildfire.xml? It looks like the value is missing.

Dave_Parker · August 27, 2006, 3:21pm

As mentioned in my other post… I’'ve done a complete re-install of the WildFire server (v 3.1 beta).

I am still getting the JDBCAuthProvider error saying URL cannot be null.

I’'ve changed the wildfire.xml file to reflect the new format of the provider …

but still getting the error.

Would really appreciate some help because I want to integrate my existing userbase into the system as soon as possible.

Dave

LG1 · August 27, 2006, 4:34pm

Hi,

for 3.1.beta it is jdbcProvider.connectionString and not jdbcProvider.jdbcConnString.

Please try it with …

LG

Dave_Parker · August 27, 2006, 5:42pm

Thanks for the suggestion… I’‘ve tried it. I tried it as you suggested but just got the setup screen on the admin console. Remembering I’‘d seen something about replacing “&” with “&” I put that in and that then gave me back the login screen. But still cannot log in. Here’'s my XML file, maybe you can spot something blindingly obvious.

And the error I am seeing in the error.log file associated with trying to log in is…

2006.08.27 18:31:10 org.jivesoftware.wildfire.auth.JDBCAuthProvider.getPasswordValue(JDBCAuthProvide r.java:208) Exception in JDBCAuthProvider

java.sql.SQLException: The url cannot be null

at java.sql.DriverManager.getConnection(Unknown Source)

at org.jivesoftware.wildfire.auth.JDBCAuthProvider.getPasswordValue(JDBCAuthProvid er.java:194)

at org.jivesoftware.wildfire.auth.JDBCAuthProvider.authenticate(JDBCAuthProvider.j ava:104)

at org.jivesoftware.wildfire.auth.AuthFactory.authenticate(AuthFactory.java:126)

at org.jivesoftware.wildfire.net.SASLAuthentication.doPlainAuthentication(SASLAuth entication.java:339)

at org.jivesoftware.wildfire.net.SASLAuthentication.handle(SASLAuthentication.java :175)

at org.jivesoftware.wildfire.net.SocketReadingMode.authenticateClient(SocketReadin gMode.java:117)

at org.jivesoftware.wildfire.net.BlockingReadingMode.readStream(BlockingReadingMod e.java:136)

at org.jivesoftware.wildfire.net.BlockingReadingMode.run(BlockingReadingMode.java: 62)

at org.jivesoftware.wildfire.net.SocketReader.run(SocketReader.java:123)

at java.lang.Thread.run(Unknown Source)

2006.08.27 18:31:37 org.jivesoftware.wildfire.auth.JDBCAuthProvider.getPasswordValue(JDBCAuthProvide r.java:208) Exception in JDBCAuthProvider