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.