Openfire Sql Database Integration

Question

I follow this guide (http://www.igniterealtime.org/builds/openfire/docs/latest/documentation/db-integration-guide.html) for integrating an Openfire server with a Sql Server database.

I configured the openfire.xml file as follows:

<jdbcProvider> <driver>net.sourceforge.jtds.jdbc.Driver</driver> <connectionString>jdbc:jtds:sqlserver://192.168.21.40:1433/XmppTests;user=myusername;password=mypass;instance=sqlserver2008ex;</connectionString> </jdbcProvider> <provider> <auth> <className>org.jivesoftware.openfire.auth.JDBCAuthProvider</className> </auth> </provider> <jdbcAuthProvider> <passwordSQL>SELECT password FROM dbo.Users WHERE username=?</passwordSQL> <passwordType>plain</passwordType> </jdbcAuthProvider> <admin> <authorizedUsernames>francisco</authorizedUsernames> </admin> 

When I turn on the server, it does not show me any errors, it returns the file to the default values. I check the logs and can't find anything.

Answer 1

From here .

Settings (settings) are saved in the database using 3.6.4. I also noticed this and saw only the database link in another discussion and after checking my install, yep, everything in the database, except for Connection options to DB.

And the confirmation is here :

In the previous thread, most of the SSO config is absorbed into the database at startup, so you do not see it in the XML file. This is normal.