powered by Jive Software

Help with openfire.xml and SugarCRM


i’ve some troubles with openfire.xml and sugarcrm. i’ve changed jdbcUserProvider.loadUserSQL to SELECT CONCAT(first_name, ’ ', last_name), ‘test@test.com’ FROM contacts WHERE phone_mobile like ? cleared cache and restartet openfire. since then, only three user (I think they are from the ofUser table) are shown.

i’ve also added … to openfire.xml. will openfire now take the values from the ofProperty Table or from openfire.xml?

Many thanks