Inserting records into ofVcard

Hello,

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

provider.vcard.className=org.jivesoftware.openfire.vcard.DefaultVCardProvider
vcard.enabled=true

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

Thanks

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.