Hi All,
I am using openfire XMPP Server 3.6.4,
Instant Messenger client ( Spark )
Context:
Here my main outline is , i am using 2 databases like 1) openfire database is (openfire) 2) my custom database is (mobyko).
so here the first database , i.e., 1) openfire constis list of tables by default when we run the server application . ( like ofuser,ofproperty…etc…)
i have another database with name ( mobyko) having table called ( Account ) it’s consists of columns (username,password).
below is the attachment for my configuration setup for integrating the customize database ( openfire.xml ). plz check out the attachment below.
now, after configuring the customized tables in opefire.xml , i am able to connect to chat client Spark successfully.
for example , i have username : smith and password : allen , these are the credentials from my ( Mobyko ) database under table ( Account ).
i have provided these credentials in client chat , i was able to login successfully .
Till now it’s ok, but now the problem is
i am unable to connect to admin console authentication .
so however i have provided the admin information in openfire.xml file.
as :
dasari,vaass
i have given username as dasari and i don’t know which password should give to access admin console.
Note : have we look at openfire database under that we have table called ofUser, by default it consists for username as admin and plainpassword as admin.
Note : below is the list of data after configuring the customize data in openfire under table ofProperty.
admin.authorizedJIDs
dasari@127.0.0.1,vaass@127.0.0.1
jdbcAuthProvider.allowUpdate
true
jdbcAuthProvider.passwordSQL
SELECT password FROM mobyko.ACCOUNT WHERE username=?
jdbcAuthProvider.passwordType
plain
jdbcAuthProvider.setPasswordSQL
UPDATE mobyko.ACCOUNT SET password=? WHERE username=?
jdbcProvider.connectionString
jdbc:mysql://localhost/openfire?user=root&password=admin
jdbcProvider.driver
com.mysql.jdbc.Driver
jdbcUserProvider.allUsersSQL
SELECT username FROM mobyko.ACCOUNT
jdbcUserProvider.emailField
email_address
jdbcUserProvider.loadUserSQL
SELECT CONCAT(first_name,’ ‘,last_name),email_address FROM mobyko.ACCOUNT WHERE username=?
jdbcUserProvider.nameField
CONCAT(first_name,’ ',last_name)
jdbcUserProvider.searchSQL
SELECT username FROM mobyko.ACCOUNT WHERE
jdbcUserProvider.userCountSQL
SELECT COUNT(*) FROM mobyko.ACCOUNT
jdbcUserProvider.usernameField
username
provider.auth.className
org.jivesoftware.openfire.auth.JDBCAuthProvider
provider.user.className
org.jivesoftware.openfire.user.JDBCUserProvider
update.lastCheck
1283581611278
xmpp.session.conflict-limit
0
however i provided these credentials also, but i am unable to get login.
i think there is a problem with system privileges or could i need to change the code in my application unser adminprovider.java and adminmanager.java
so i request everyone whomever seen this post , hope they will provide me good solution.
eagerly waiting for reply,
Anticipating your help,
Thanks and Regards
Dasari Vaass
openfire.xml (2132 Bytes)