powered by Jive Software

Custom Authentication using MYSQL

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.

http://community.igniterealtime.org/message/190656#190656

I followed the soultion in the above link, which resolved my problem