i’ve some troubles with openfire.xml and sugarcrm. i’ve changed jdbcUserProvider.loadUserSQL to SELECT CONCAT(first_name, ’ ', last_name), ‘firstname.lastname@example.org’ 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?