Hi everyone, i used postfix, dovecot and mysql. I have virtual users and domains. I have this configuration in dovecot-mysql.conf: db_host = localhost db_port = 3306 db_unix_socket = /var/run/mysqld/mysqld.sock db = postfix db_user = postfix db_passwd = bscidth46 db_client_flags = 0 default_pass_scheme = CRYPT password_query = SELECT password FROM mailbox WHERE username = '%u' user_query = SELECT maildir, 105 AS uid, 106 AS gid FROM mailbox WHERE username = '%u' The table mailbox: +-------------------+--------------+------------------+-----------+------------+ | username | home | maildir | quota | domain | +-------------------+--------------+------------------+-----------+------------+ | test at domain.com | /home/vmail/ | domain.com/test/ | 10240000 | domain.com | | test2 at domain.com | /home/vmail/ | domain.com/test2/ | 10240000 | domain.com | | test3 at domain.com | /home/vmail/ | domain.com/test3/ | 10240000 | domain.com | +-------------------+--------------+-------------------+----------+------------+ I have this configuration in smtpd.conf: pwcheck_method: auxprop mech_list: LOGIN CRAM-MD5 DIGEST-MD5 GSSAPI auxprop_plugin: sql sql_verbose: yes sql_engine: mysql sql_hostnames: localhost sql_database: postfix sql_user: postfix sql_passwd: bscidth46 sql_select: select password from mailbox where username = '%u@%r' What can i do to log in with only user part of user at domain.com? Thanks in advance
On Wed, 14 Mar 2007 20:25:18 +0000 (UTC) juan carlos <juanca2711 at hotmail.com> wrote:> Hi everyone, i used postfix, dovecot and mysql. I have virtual users > and domains. I have this configuration in dovecot-mysql.conf: > db_host = localhost > db_port = 3306 > db_unix_socket = /var/run/mysqld/mysqld.sock > db = postfix > db_user = postfix > db_passwd = bscidth46 > db_client_flags = 0 > default_pass_scheme = CRYPT > password_query = SELECT password FROM mailbox WHERE username = '%u' > user_query = SELECT maildir, 105 AS uid, 106 AS gid FROM mailbox > WHERE username = '%u'[snip] I sincerely hope that the db_user and db_password are fictitious. You listed them twice in this post. -- Gerard Never be afraid to try something new. Remember, amateurs built the ark. Professionals built the Titanic. -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 187 bytes Desc: not available URL: <http://dovecot.org/pipermail/dovecot/attachments/20070314/c6941516/attachment.bin>
On Wed, 2007-03-14 at 20:25 +0000, juan carlos wrote:> What can i do to log in with only user part of user at domain.com?Do you mean that your domain.com is always the same? Then add to dovecot.conf: auth_default_realm = domain.com -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 189 bytes Desc: This is a digitally signed message part URL: <http://dovecot.org/pipermail/dovecot/attachments/20070315/2888610d/attachment.bin>