Openfire Custom Database Integration user can not login

Openfire Openfire Dev
1

I do as Custom Database Integration Guide step by step , I have new database openfire and student database ; only openfire database run good.

but I want to use users in student database , can not login

openfire.xml code:

<jdbcProvider>

<driver>oracle.jdbc.driver.OracleDriver</driver>

<connectionString>jdbc:oracle:thin:@yxb:1521:ora92?user=student&passw ord=a</connectionString>

</jdbcProvider>

<provider>

<auth>

<className>org.jivesoftware.openfire.auth.JDBCAuthProvider</className& gt;

</auth>

<user>

<className>org.jivesoftware.openfire.user.JDBCUserProvider</className& gt;

</user>

<group>

<className>org.jivesoftware.openfire.group.JDBCGroupProvider</classNam e>

</group>

</provider>

<jdbcAuthProvider>

<passwordSQL>SELECT password FROM myUser WHERE username=?</passwordSQL>

<passwordType>plain</passwordType>

</jdbcAuthProvider>

<jdbcUserProvider>

<loadUserSQL>SELECT name,email FROM myUser WHERE username=?</loadUserSQL>

<userCountSQL>SELECT COUNT(*) FROM myUser</userCountSQL>

<allUsersSQL>SELECT username FROM myUser</allUsersSQL>

<searchSQL>SELECT username FROM myUser WHERE</searchSQL>

<usernameField>username</usernameField>

<nameField>name</nameField>

<emailField>email</emailField>

</jdbcUserProvider>

<jdbcGroupProvider>

<groupCountSQL>SELECT count(*) FROM myGroups</groupCountSQL>

<allGroupsSQL>SELECT groupName FROM myGroups</allGroupsSQL>

<userGroupsSQL>SELECT groupName FORM myGroupUsers WHERE username=?</userGroupsSQL>

<descriptionSQL>SELECT groupDescription FROM myGroups WHERE groupName=?</descriptionSQL>

<loadMembersSQL>SELECT username FORM myGroupUsers WHERE groupName=? AND isAdmin=‘N’</loadMembersSQL>

<loadAdminsSQL>SELECT username FORM myGroupUsers WHERE groupName=? AND isAdmin=‘Y’</loadAdminsSQL>

</jdbcGroupProvider>

<connectionProvider>

<className>org.jivesoftware.database.DefaultConnectionProvider</classN ame>

</connectionProvider>

<database>

<defaultProvider>

<driver>oracle.jdbc.driver.OracleDriver</driver>

<serverURL>jdbc:oracle:thin:@yxb:1521:ora92</serverURL>

<username>openfire</username>

<password>a</password>

<minConnections>3</minConnections>

<maxConnections>15</maxConnections>

<connectionTimeout>1.0</connectionTimeout>

</defaultProvider>

</database>

<setup>true</setup>

Does anyone know where they are ?

Thanks…

2

How did you even get that far?

I’m following the current Openfire instructions, and at no point in the Linux install does it explain

  1. To edit the openfire.xml file

  2. What to put in it.

Out of the box, there is no jdbcProvider section in this file at all, and no reference to its existence or use anywhere in the installation instructions.

Is this an oversight, or am I expected to be psychic?

-Jason

Not having any fun with openfire so far.