dovecot - Jul 2005 - Need Help About My Problem ( Dovecot / Postfix / MySQL / Postfixadmin )

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 at 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... at 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 at 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... at pepocono.com 
+OK 
PASS 123456 
+OK Logged in. 
-ERR No INBOX for user. 
Connection closed by foreign host. 
[root at 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

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://dovecot.org/pipermail/dovecot/attachments/20050728/e0f307b4/attachment-0002.html>