powered by Jive Software

OpenFire custom database integration / searchSQL & multiple databases?


I want to use the custom database integration.

Can I add multiple fields to the nameField configuration? (our first and lastnames are splitted)

Thanks for the answer.



Another question:

http://www.igniterealtime.org/builds/openfire/docs/latest/documentation/db-integ ration-guide.html

is that still valid?

I added the jdbcAuthProvider etc. but then the setup appeared again…

Can I use a different database for openfire and the user auth?

Finally the different database handling works.

But please update the documentation and specifiy, that all values must be set in the Adminpanel and not via the openfire.xml:

http://www.igniterealtime.org/builds/openfire/docs/latest/documentation/db-integ ration-guide.html

The question about the nameField is still open…


I was wondering if you explain the solution you found a bit. I also found that link and have begun entering/changing values via the admin web pannel and not the openfire.xml. However, when I get to sections below , I am unsure exactly how to enter that into the pannel. I thought, by taking the provider section as an example, that it would something along the lines of:

Property name: jdbcAuthProvider.passwordSQL

Value: SELECT password FROM user_account WHERE username=?

but I was not sure if that is right. Is this line of thinking right? Or am I about to do some damage?


Kyle M. Cummings

I think it should be more or less correct what you propose. Just try it You won’t do any damage, you will just notice if it works or not