Regarding Admin Console Authentication

Openfire Openfire Support
1

Hi All,

This is VaasDasari i am new to this Community , i am Working as (Java) Senior Software Engineer in IMI Mobiles Pvt Ltd Hyderabad. I visited the "iginite realtime "

recently last month. i have gone through the documentation , it’s pretty interesting. i download the entire source code as well as respected API’s.

and i started using this code in my project, it helped me a lot for connecting other IM Clients Simultaneously with available plugins ( Kraken ) using Openfire XMPP Server.

So my Question is :

I have a Database ( XYZ ) :

Eg: i have one Table Called OfUser in my database XYZ with respected columns like , username,password,firstname,email,date

and there after , i installed openfire sourcecode in my eclipse IDE, i deployed the project and i given the database like " openfire " after successfull installation , several tables are imported into the openfire database.

so now i have a database openfire with several tables. this database realted to openfire XMPP Server Application.

and i have a databse XYZ with several tables . this is my application.

and there after i created the VIEW in datbase openfire with name OfUser …so i am getting rows information from XYZ database.

Eg: create view ofuser as
(select username as username,password as plainPassword,password as encryptedPassword,first_name as name,email_address as email,date_of_registration as creationDate,date_of_registration as modificationDate from Database.TableName).

so now my intention i renamed the ofuser table as ofuser1 in openfire database and after that i created the view with the name ( ofuser ) in my XYZ database.

so now i have plenty of records in ofuser table which are getting from my application in Openfire Database.

so now i login to the application and i provided the credentials as admin ( username ) admin ( password) in admin console window and i clicked on submit button . so here i am unable to login into the application, but however it not even showing the errors in the application, simply it refreshing the

page. i don’t know what the problem.

so i tested the application in debug mode :

the controls are going like this…

  1. AuthFactory --> validating Authenticate() method.

2)AuthToken()

3)XMPP Callback Handler.java --> callbacks

4)Saslserverplainimpl.java

  1. saslauthentication …

hope u can understand my problem, i request you to please suggest me the same, did i went anything worng with that procedure .

if you find any communication mistakes , it would be very grateful for your feedback.

Anticipating your help

Regards

VaassDasari

2

Hi,

I don’t understand why you use a view to connect to a remote database. There is the JDBC auth provider.

Do you want to connect to another Openfire database? There’s a system property “passwordKey” which should be the same on both Openfire servers if you want to be able to use the passwords.

LG

3

Hi LG,

Thank your for ur reply,

Can u please tell me, how can i configure custom database integration.

i did the integration like this. but , when i login in to database i am getting invalid username and password in admin console,

I have a Database Mobyko with table name ACCOUNT having fields , username,password,first_name,email_address

do i need to do any changes in jdbcauthprovider.java and jdbcuserprovider.java class files,

more over i am little bit confusing, then what is the purpose of AuthFactory.java…here in this class we are configuring all the system properties…

Hope u can assist me,

Procedure :

Openfire.xml :

<?xml version="1.0" encoding="UTF-8"?> 9090 9091

en

dasari,vaass

    <auth>
         <className>org.jivesoftware.openfire.auth.JDBCAuthProvider</className>
    </auth>

    <user>
         <className>org.jivesoftware.openfire.user.JDBCUserProvider</className>
    </user>


   
</provider>

<connectionProvider>
        <className>org.jivesoftware.database.DefaultConnectionProvider</className>
</connectionProvider>
com.mysql.jdbc.Driver jdbc:mysql://localhost:3306/mobyko?user=root&password=adm in SELECT password FROM ACCOUNT WHERE username=? LIMIT 1 plain 
<jdbcUserProvider>
       
        <loadUserSQL>SELECT first_name, email_address FROM ACCOUNT WHERE username = ? LIMIT 1</loadUserSQL>
        <userCountSQL>SELECT COUNT(*) FROM ACCOUNT</userCountSQL>
        <allUsersSQL>SELECT username FROM ACCOUNT ORDER BY username ASC</allUsersSQL>
           <searchSQL>SELECT username FROM ACCOUNT WHERE</searchSQL>
           <usernameField>username</usernameField>
        <nameField>first_name</nameField>
        <emailField>email_address</emailField>

true

<log>
   
    <debug>
     <enabled>true</enabled>
    </debug>

</log>

your reply would be appreciable,

Anticipating your help,

Regards Dasari…