I have made following changes to my openfire.xml and to property table(ofproperty). My problem is that every time I start my openfire server I see this message in warn.log (org.jivesoftware.util.JiveGlobals - Property ‘jdbcUserProvider.loadUserSQL’ as specified in openfire.xml differs from what is stored in the database. Please make property changes in the database instead of openfire.xml.) and all my settings in openfire.xml are erased.
<?xml version="1.0" encoding="UTF-8"?>9090
9091
en
true
org.jivesoftware.database.DefaultConnectionProvider
com.mysql.jdbc.Driver
jdbc:mysql://localhost:3306/openfire
root
ROOT
select 1
true
true
5
25
1.0
com.mysql.jdbc.Driver
jdbc:mysql://localhost/relationals?user=root&password=ROO T
org.jivesoftware.openfire.auth.JDBCAuthProvider
org.jivesoftware.openfire.user.JDBCUserProvider
select password from NETWORK_USER_DIRECTORY where username=?
sha1
select first_name,email from NETWORK_USER_DIRECTORY where username=?
select count(*) from NETWORK_USER_DIRECTORY
select username from NETWORK_USER_DIRECTORY
select username from NETWORK_USER_DIRECTORY where
username
first_name
ofproperty table looks like :-
‘admin.authorizedJIDs’, ‘admin@xyz.com’
‘jdbcAuthProvider.passwordSQL’, ‘select password from NETWORK_USER_DIRECTORY where username=?’
‘jdbcAuthProvider.passwordType’, ‘sha1’
‘jdbcProvider.connectionString’, ‘jdbc:mysql://localhost/relationals?user=root&password=ROOT’
‘jdbcProvider.driver’, ‘com.mysql.jdbc.Driver’
‘jdbcUserProvider.allUsersSQL’, ‘select username from NETWORK_USER_DIRECTORY’
‘jdbcUserProvider.emailField’, ‘email’
‘jdbcUserProvider.loadUserSQL’, ‘select first_name, email from NETWORK_USER_DIRECTORY where username=?’
‘jdbcUserProvider.nameField’, ‘first_name’
‘jdbcUserProvider.searchSQL’, ‘select username from NETWORK_USER_DIRECTORY where’
‘jdbcUserProvider.userCountSQL’, ‘select count(*) from NETWORK_USER_DIRECTORY’
‘jdbcUserProvider.usernameField’, ‘username’
‘passwordKey’, ‘PLAIN’
‘provider.admin.className’, ‘org.jivesoftware.openfire.admin.DefaultAdminProvider’
‘provider.auth.className’, ‘org.jivesoftware.openfire.auth.JDBCAuthProvider’
‘provider.group.className’, ‘org.jivesoftware.openfire.group.DefaultGroupProvider’
‘provider.lockout.className’, ‘org.jivesoftware.openfire.lockout.DefaultLockOutProvider’
‘provider.securityAudit.className’, ‘org.jivesoftware.openfire.security.DefaultSecurityAuditProvider’
‘provider.user.className’, ‘org.jivesoftware.openfire.user.JDBCUserProvider’
‘provider.vcard.className’, ‘org.jivesoftware.openfire.vcard.DefaultVCardProvider’
‘update.lastCheck’, ‘1331329935600’
‘xmpp.auth.anonymous’, ‘true’
‘xmpp.domain’, ‘gunjan-pc’
‘xmpp.session.conflict-limit’, ‘0’
‘xmpp.socket.ssl.active’, ‘true’