hey,
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
Flo