powered by Jive Software

Openfire 3.9.3 plus search plugin will not correctly identify fields

Greetings,

I have Openfire 3.9.3.

I have successfully integrated JDBCauthProvider to authenticate to external database using the ofProperty table.

I am trying to enable the search mechanism.

I am using the latest download from the plugins page.

In my ofProperty table I have the following set:

jdbcUserProvider.usernameField
user_login

jdbcUserProvider.nameField
user_nicename

jdbcUserProvider.emailField
user_email

In spite of the fact that these values are set:

a search for an email results in this query (as checked by mysql logs):

SELECT user_login FROM hq_users WHERE email LIKE ‘%value%’ <— notice ‘email’ field; not ‘user_email’

the query should be

SELECT user_login FROM hq_users WHERE user_email LIKE ‘%value%’

is there somewhere I am missing another setting?

Thanks.