powered by Jive Software

Problem with custom authentication


I downloaded openfire 3.6.4 today and I’ve been struggling to get the configuration to work with custom authentication. My openfire.xml config file looks like this:

<?xml version="1.0" encoding="UTF-8"?>
    <passwordSQL>SELECT password FROM users WHERE username=?</passwordSQL>

I have also set ‘provider.auth.className’ to ‘org.jivesoftware.openfire.auth.JDBCAuthProvider’ in the server properties of the control panel. I don’t get any errors when starting up but it refuses to accept the password for ‘user1’ to login to the control panel. I have noticed also that the ‘authorizedUsernames’ key is always removed from openfire.xml after startup which I believe is the root of the problem, I can’t find anything in the logs to explain why it would be removing this value.

Can anyone help?