I am using openfire XMPP Server 3.6.4,
Instant Messenger client ( Spark )
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.
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.
SELECT password FROM mobyko.ACCOUNT WHERE username=?
UPDATE mobyko.ACCOUNT SET password=? WHERE username=?
SELECT username FROM mobyko.ACCOUNT
SELECT CONCAT(first_name,’ ‘,last_name),email_address FROM mobyko.ACCOUNT WHERE username=?
SELECT username FROM mobyko.ACCOUNT WHERE
SELECT COUNT(*) FROM mobyko.ACCOUNT
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
openfire.xml (2132 Bytes)