Hi i've got a problem and couldn't find a solution at this point.

I've got my openfire system configured with a custom mysql database.

this is my UserProvider openfire.xml config.  I'm using a postfix database schema (it's a mail server with mysql backend)

  select name,username from mailbox where username = concat_ws('@',?,'maildomain.com') select count(*) from mailbox SELECT SUBSTRING_INDEX(username, '@', 1) FROM mailbox select substring_index(username,'@',1) from mailbox where username = concat_ws('@',?,'maildomain.com') username name username ]]>

so according what i've found the nameField mapping tells to openfire that the complete name is at the name field.

If i check at the console i can get the list of users with their login and their name as desired  (  jperez  -  juan perez)

The problem i've got is that from spark or pidgin the contact's name is displayed as username (jperez) instead of name (juan perez)

What am i doing wrong, any ideas?