Good day to everyone.
I want to integrate my custom SQL Server database (named OpenFireDB) with the one provided by OpenFire.
I am following the tutorial described in:
#1 http://www.igniterealtime.org/builds/openfire/docs/latest/documentation/db-integ ration-guide.html
To start OpenFire, I have done the steps explained in:
#2 http://www.igniterealtime.org/builds/openfire/docs/latest/documentation/database .html#sqlserver
to see if OpenFire worked with my database with success.
Now, I begin the steps described in #1
I stop OpenFire and open my XML file (conf/openfire.xml)
I follow the steps and my file ends like this:
<?xml version="1.0" encoding="UTF-8"?>9090
9091
en
org.jivesoftware.database.DefaultConnectionProvider
net.sourceforge.jtds.jdbc.Driver
jdbc:jtds:sqlserver://christian/OpenFireDB;appName=jive
XX
XX
select 1
true
true
5
25
1.0
true
net.sourceforge.jtds.jdbc.Driver
jdbc:jtds:sqlserver://christian/OpenFireDB;appName=jive??user =XX&password=XX
org.jivesoftware.openfire.auth.JDBCAuthProvider
org.jivesoftware.openfire.user.JDBCUserProvider
SELECT password FROM users WHERE username=?
plain
SELECT name,email FROM users WHERE username=?
SELECT COUNT(*) FROM users
SELECT username FROM users
SELECT username FROM users WHERE
user_name
name
user_email
My database contains a table called “USERS” with these columns:
USER_NAME, NORMAL_PASSWORD, UBER_PASSWORD, NAME, USER_EMAIL
NORMAL_PASSWORD is a column to make tests with plain passwords
UBER_PASSWORD is a colum to make tests with encrypted passwords once I am able to connect my database with OpenFire
And that is the reason I have written it in a different from the tutorial in section
Instead of “user_account” which is written in the tutorial, I think that I should write there the table where my users are (USERS)
I have done the same for the sections where “myUsers” table is referred in that guide.
I have even tried not changing the “user_account” table in section to try if it worked; but it did not.
Then, following steps in #1, I start again OpenFire
I click on “Launch Admin”, I log with my admin account and check the Users/Groups section, in Users Summary.
1.- I do not see the user I have in my USERS table, that should be integrated dynamically in OpenFire.
2.- If I add a new user in that interface, it only updates the table “ofUser” of OpenFire, but does not generate that user in my table
What am I doing wrong?
Would you mind explaining me my flaws and telling me how to do this properly, please?
Thank you very much for your Time and have a nice day (^_^)