About mailserver ISPMAIL

[maykel franco]

Hello, I'm Maykel and I'm spanish. I follow the manual
http://workaround.org/ispmail/lenny , it's works perfectly with
john at example.com. But I want also to authenticate users with an alternate
user name without @example.com, for example with called user zjv009.
I added the column to the table virtual_users user, being as follows:


<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>
id<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>
domain_id<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>
password<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>
email<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>
user<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>


<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>
1    1 a28a0e4dbfb199418104216a1134e7b9        john at example.com      zjv009


So I changed the files:

mysql-email2email.cf:

query = SELECT email FROM virtual_users WHERE email = '% s' OR user = '% s'

mysql-virtual-mailbox-maps.cf:

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ubuntu.com/archives/ubuntu-users/attachments/20101123/57730ff8/attachment.html>