I have done the setup as mentioned in the below link:
http://www.igniterealtime.org/builds/openfire/docs/latest/documentation/db-integ ration-guide.html
These are the properties set (‘ofproperty’ table):
‘admin.authorizedUsernames’ - ‘sirim’
‘emailField’ - ‘email’
‘jdbcAuthProvider.passwordSQL’ - ‘SELECT password FROM user_profiles WHERE user_id=?’
‘jdbcAuthProvider.passwordType’ - ‘plain’
‘jdbcGroupProvider.allGroupsSQL’ - ‘SELECT group_Name FROM user_groups’
‘jdbcGroupProvider.descriptionSQL’ - ‘SELECT group_Description FROM user_groups WHERE group_Name=?’
‘jdbcGroupProvider.groupCountSQL’ - ‘SELECT count(*) FROM user_groups’
‘jdbcGroupProvider.loadAdminsSQL’ - ‘SELECT user_id FROM user_groups WHERE group_Name=? AND isAdmin=’‘Y’’’
‘jdbcGroupProvider.loadMembersSQL’ - ‘SELECT user_id FROM user_groups WHERE group_Name=? AND isAdmin=’‘N’’’
‘jdbcGroupProvider.userGroupsSQL’ - ‘SELECT group_Name FROM group_users WHERE user_id=?’
‘jdbcProvider.connectionString’ - ‘jdbc:mysql://localhost/DojoProj?user=root&password=root’
‘jdbcProvider.driver’ - ‘com.mysql.jdbc.Driver’
‘jdbcUserProvider.allUsersSQL’ - ‘SELECT user_id FROM user_profiles’
‘jdbcUserProvider.loadUserSQL’ - ‘SELECT name,email FROM user_profiles WHERE user_id=?’
‘jdbcUserProvider.searchSQL’ - ‘SELECT user_id FROM user_profiles WHERE’
‘jdbcUserProvider.userCountSQL’ - ‘SELECT COUNT(*) FROM user_profiles’
‘nameField’ - ‘name’
‘passwordKey’ - ‘LG9okrU2A8PKpIS’
‘provider.admin.className’ - ‘org.jivesoftware.openfire.admin.DefaultAdminProvider’
‘provider.auth.className’ - ‘org.jivesoftware.openfire.auth.JDBCAuthProvider’
‘provider.group.className’ - ‘org.jivesoftware.openfire.group.JDBCGroupProvider’
‘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’ - ‘1357540683343’
‘usernameField’ - ‘user_id’
‘xmpp.auth.anonymous’ - ‘true’
‘xmpp.domain’ - ‘localhost’
‘xmpp.pubsub.service’ - ‘pubsub’
‘xmpp.session.conflict-limit’ - ‘0’
‘xmpp.socket.ssl.active’ - ‘true’
This is the content in ‘conf/openfire.xml’:
9090
9091
en
org.jivesoftware.database.DefaultConnectionProvider
com.mysql.jdbc.Driver
jdbc:mysql://localhost:3306/DojoProj?rewriteBatchedStatements=true</ serverURL>
root
root
select 1
false
false
1
2000
1
true
I tried logging in openfire admin console with username ‘sirim’ and password ‘siri’, but ended up with some error like ''Login failed: make sure your username and password are correct and that you’re an admin or moderator." Even with ‘admin’, ‘admin’, the issue is same.
I have checked even the logs, but ended up with no clue. Even error.log is not updated with any error message.
Can someome please help me out to resolve this. Please let me know if additional information is needed. Thanks.