powered by Jive Software

Inserting records into ofVcard


I’m new to Openfire so i might be overlooking something obvious. I’ve setup Openfire 4.1.5 and integrated it with converse.js on my site. Everything works great. I want to add avatar photos for users. I’m guessing I need to add a record in the ofVCard table.

I’ve tried:

update ofVCard set vcard = ‘{sn}{givenName}{mail}{displayName}{displayName}image/jpeg{jpegPhoto}{homePostalAddress}{postOfficeBox}{l}{st}{postalCode}{c}{homePhone}{telephoneNumber}{mobile}{pager}{facsimileTelephoneNumber}{title}{wWWHomePage}{company}{department}’ where username = ‘test’

With the image as a base 64 string. I’m not seeing an avatar in converse.js. This isn’t a ldap intergration. I’m using the following vcard settings


Has anyone had any luck doing this in the past? Or know if I’m approaching the problem from the correct angle?


Fyi, turns out i needed to disable the vcard caching in order to see the updated photos in the vcard table. I set cache.vcardCache.maxLifetime and cache.vcardCache.size to 0.