powered by Jive Software

Having problem with openfire Custom database integration with Mysql

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

admin@xyz.com

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

email

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’