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

1. ERROR = "" A NO ""
and

2. 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