OpenFire custom database integration / searchSQL & multiple databases?

Openfire Openfire Support
1

Hi,

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.

Cheers,

Michael

2

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?

3

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…

4

Hello,

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?

Thanks,

Kyle M. Cummings

5

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