Hi, i've got an enviroment using custom mysql database  as auth backend.   This mysql db is from postifx and the fields in it are name, email, password.  The relevant part from openfire.xml is:

<jdbcAuthProvider>

    <passwordSQL>select password from mailbox where username = concat_ws('@',?,'domain')</passwordSQL>

    <passwordType>plain</passwordType>

  </jdbcAuthProvider>

  <jdbcUserProvider>

    <loadUserSQL>select name,username from mailbox where username = concat_ws('@',?,'domain')</loadUserSQL>

    <userCountSQL>select count(*) from mailbox</userCountSQL>

    <allUsersSQL>SELECT SUBSTRING_INDEX(username, '@', 1) FROM mailbox</allUsersSQL>

    <searchSQL>select substring_index(username,'@',1) from mailbox where username = concat_ws('@',?,'domain')</searchSQL>

    <usernameField>username</usernameField>

    <nameField>name</nameField>

    <emailField>username</emailField>

  </jdbcUserProvider>

In the name fied i've got the complete name, i.e.  pedro perez

in the username field i've got the username  like pperez

My problems are

1.  from spark i cannot add contacts and get their nicknames, i'm getting their usernames instead, as described in this thread http://www.igniterealtime.org/community/message/165101#165101

2. when a customer goes to the fastpath webchat, the customer sees the username agent instead of their nickname or complete name.

These are very troublesome for us because the customer doesn't have the chance to really now to whom he's talking at the time.

Any workaround or solution for this issue?

Thanks for your help

desc mailbox

    -> ;

----

----

----

select * from mailbox where username = "pperez@domain";

----

+

----

+

----

+

1 row in set (0.00 sec)