We are using Openfire (LDAP AD) with Spark. When a user adds a contact in the Spark client, the nickname field is automatically populated with the username part before the @ sign. If I clear the nickname box before adding the contact, it will use the contacts full name (pulled from AD).
I’ve been searching this forum for a way to have the nickname field automatically populated with the AD “cn” or “displayName”. So far I haven’t been successful.
So I thought I’d take another approach by directly changing the nickname in the SQL table “ofRoster”. However the changes I make there are not propagated to Openfire. It looks like Openfire is caching the database entries.
- Do I need to change the nickname in another table(s) or is it indeed a caching issue?
- If so is there another way to bulk change the nickname in the roster?