<div class="gmail_quote"> Hello, I'm Maykel and I'm spanish. I follow the manual <a href="http://workaround.org/ispmail/lenny" target="_blank">http://workaround.org/ispmail/lenny</a> , it's works perfectly with <a href="mailto:john@example.com" target="_blank">john@example.com</a>. But I want also to authenticate users with an alternate user name without @<a href="http://example.com" target="_blank">example.com</a>, for example with called user zjv009. I added the column to the table virtual_users user, being as follows: <input value="Continuar" type="submit"> <input name="db" value="mailserver" type="hidden"> <input name="table" value="virtual_users" type="hidden"> <input name="token" value="191aeaa9769004c63f1a42b7e1eb26c6" type="hidden"> <input name="goto" value="sql.php" type="hidden"> <table><thead><tr> <th colspan="3"> <a href="http://192.168.1.107/phpmyadmin/sql.php?db=mailserver&table=virtual_users&sql_query=SELECT+%2A+FROM+%60virtual_users%60&goto=tbl_structure.php&dontlimitchars=1&token=191aeaa9769004c63f1a42b7e1eb26c6" target="_blank"> </a> </th> <th> <a href="http://192.168.1.107/phpmyadmin/sql.php?db=mailserver&table=virtual_users&token=191aeaa9769004c63f1a42b7e1eb26c6&sql_query=SELECT+%2A+FROM+%60virtual_users%60+ORDER+BY+%60virtual_users%60.%60id%60+ASC" title="Ordenar" target="_blank">id</a> </th><th> <a href="http://192.168.1.107/phpmyadmin/sql.php?db=mailserver&table=virtual_users&token=191aeaa9769004c63f1a42b7e1eb26c6&sql_query=SELECT+%2A+FROM+%60virtual_users%60+ORDER+BY+%60virtual_users%60.%60domain_id%60+ASC" title="Ordenar" target="_blank">domain_id</a> </th><th> <a href="http://192.168.1.107/phpmyadmin/sql.php?db=mailserver&table=virtual_users&token=191aeaa9769004c63f1a42b7e1eb26c6&sql_query=SELECT+%2A+FROM+%60virtual_users%60+ORDER+BY+%60virtual_users%60.%60password%60+ASC" title="Ordenar" target="_blank">password</a> </th><th> <a href="http://192.168.1.107/phpmyadmin/sql.php?db=mailserver&table=virtual_users&token=191aeaa9769004c63f1a42b7e1eb26c6&sql_query=SELECT+%2A+FROM+%60virtual_users%60+ORDER+BY+%60virtual_users%60.%60email%60+ASC" title="Ordenar" target="_blank">email</a> </th><th> <a href="http://192.168.1.107/phpmyadmin/sql.php?db=mailserver&table=virtual_users&token=191aeaa9769004c63f1a42b7e1eb26c6&sql_query=SELECT+%2A+FROM+%60virtual_users%60+ORDER+BY+%60virtual_users%60.%60user%60+ASC" title="Ordenar" target="_blank">user</a> </th></tr> </thead> <tbody> <tr> <td align="center"> </td> <td align="center"> </td> <td align="center"> <a href="http://192.168.1.107/phpmyadmin/sql.php?db=mailserver&table=virtual_users&token=191aeaa9769004c63f1a42b7e1eb26c6&sql_query=DELETE+FROM+%60virtual_users%60+WHERE+%60virtual_users%60.%60id%60+%3D+1+LIMIT+1&zero_rows=La+fila+se+ha+borrado&goto=sql.php%3Fdb%3Dmailserver%26table%3Dvirtual_users%26token%3D191aeaa9769004c63f1a42b7e1eb26c6%26sql_query%3DSELECT%2B%252A%2BFROM%2B%2560virtual_users%2560%26zero_rows%3DLa%2Bfila%2Bse%2Bha%2Bborrado%26goto%3Dtbl_structure.php" target="_blank"> </a> </td> <td align="right">1</td> <td align="right"> 1</td> <td>a28a0e4dbfb199418104216a1134e7b9</td> <td> <a href="mailto:john@example.com" target="_blank">john@example.com</a></td> <td> zjv009</td></tr></tbody></table> So I changed the files: <a href="http://mysql-email2email.cf" target="_blank">mysql-email2email.cf</a>: query = SELECT email FROM virtual_users WHERE email = '% s' OR user = '% s' <a href="http://mysql-virtual-mailbox-maps.cf" target="_blank">mysql-virtual-mailbox-maps.cf</a>: query = SELECT 1 FROM virtual_users WHERE email = '% s OR' user = '% s' and dovecot file: dovecot-sql.conf: password_query = SELECT email, password FROM virtual_users WHERE email = '% u' OR user = '% u' To dovecot-sql.conf, I also tested: password_query = SELECT email, password FROM virtual_users WHERE email = '% u' OR user = '% n' I restarted the services: / Etc / init.d / postfix restart / Etc / init.d / dovecot restart When I zjv009 authenticates the user enters a different mailbox. Need to be so, because I want to migrate a mail server system. But I've failed. What am I doing wrong? anyone can help me? thanks in advance </div>