Dear , Dovecot List ( Everyone )
I have some problem about dovecot/postfix/mysql
Would u like to tell me about the solution ? sir
Thank you very much for advance. Sir
Best Regards,
Pratchaya
==================================
==================================
==================================
This is my problem/error sir
ERROR = "" A NO "" and
ERROR = "" -ERR No INBOX for user. "
I run Dovecot + Postfix + Postfixadmin + MySQL
When i work with command line ..
i have problem like this ( When i 'm in command line ) ##############################*###### [root@server etc]# telnet localhost 143 Trying 127.0.0.1... Connected to localhost.localdomain (127.0.0.1). Escape character is '^]'.
- OK dovecot ready. A LOGIN test...@pepocono.com 123456 A OK Logged in. A SELECT inbox A NO A LOGOUT
- BYE Logging out A OK Logout completed. Connection closed by foreign host ##############################*###### [root@server etc]# telnet localhost 110 Trying 127.0.0.1... Connected to localhost.localdomain (127.0.0.1). Escape character is '^]'. +OK dovecot ready. USER test...@pepocono.com +OK PASS 123456 +OK Logged in. -ERR No INBOX for user. Connection closed by foreign host. [root@jenus etc]# ##############################*#######
My Config ==============================*======== dvecot.conf ==============================*======== default_mail_env = maildir:/var/mail/virtual/%1u/*%u/Maildir auth = plain auth_mechanisms = plain digest-md5 auth_userdb = mysql /usr/local/etc/dovecot-mysql.c*onf auth_passdb = mysql /usr/local/etc/dovecot-mysql.c*onf auth_user = mailusers ==============================*======== dvecot-mysql.conf ==============================*======== db_host = localhost db_unix_socket = /var/lib/mysql/mysql.sock db = postfix db_user = postfix db_passwd = postfix db_client_flags = 0 password_query = SELECT password FROM mailbox WHERE username = '%u' #user_query = SELECT concat('/var/mail/virtual/', maildir) as home, 10000 as uid, 10000 as gid FROM mailbox WHERE username = '%u' #user_query = SELECT '10000' AS uid, '10000' AS gid FROM mailbox WHERE username = '%u' AND active = '1' #user_query = SELECT home, uid, gid FROM users WHERE user = '%u' user_query = SELECT home, uid, gid FROM users WHERE user = '%u' AND active = '1'
( i use all case #comment but it'doesn't work )
==============================*======== main.cf ==============================*======== virtual_mailbox_base = /var/mail/virtual virtual_mailbox_domains = mysql:/etc/postfix/postfixmysq*l/mysql_virtual_domains_maps.c*f virtual_mailbox_limit = 51200000 virtual_mailbox_maps = mysql:/etc/postfix/postfixmysq*l/mysql_virtual_mailbox_maps.c*f virtual_alias_domains = $virtual_alias_maps virtual_minimum_uid = 10000 virtual_uid_maps = static:10000 virtual_gid_maps = static:10000 # Additional for quota support virtual_create_maildirsize = yes virtual_mailbox_extended = yes virtual_mailbox_limit_maps = mysql:/etc/postfix/postfixmysq*l/mysql_virtual_mailbox_limit_*maps.cf virtual_mailbox_limit_override = yes virtual_maildir_limit_message = Sorry, the user's maildir has overdrawn his diskspace quota, please try again later. virtual_overquota_bounce = yes
========================= Note ( more information ) ::
mailusers uid=10000 gid = 10000 home = /var/mail/virtual