<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Angsana New";
panose-1:2 2 6 3 5 4 5 2 3 4;}
@font-face
{font-family:"Cordia New";
panose-1:2 11 3 4 2 2 2 2 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:595.3pt 841.9pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=1 color=black face=Verdana><span
style='font-size:8.5pt;font-family:Verdana;color:black'>Dear , Dovecot List
( Everyone )<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=1 color=black face=Verdana><span
style='font-size:8.5pt;font-family:Verdana;color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=1 color=black face=Verdana><span
style='font-size:8.5pt;font-family:Verdana;color:black'>I have some problem
about dovecot/postfix/mysql<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=1 color=black face=Verdana><span
style='font-size:8.5pt;font-family:Verdana;color:black'>Would u like to tell me
about the solution ? sir<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=1 color=black face=Verdana><span
style='font-size:8.5pt;font-family:Verdana;color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=1 color=black face=Verdana><span
style='font-size:8.5pt;font-family:Verdana;color:black'>Thank you very much for
advance. Sir<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=1 color=black face=Verdana><span
style='font-size:8.5pt;font-family:Verdana;color:black'>Best Regards,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=1 color=black face=Verdana><span
style='font-size:8.5pt;font-family:Verdana;color:black'>Pratchaya<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=1 color=black face=Verdana><span
style='font-size:8.5pt;font-family:Verdana;color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=1 color=black face=Verdana><span
style='font-size:8.5pt;font-family:Verdana;color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=1 color=black face=Verdana><span
style='font-size:8.5pt;font-family:Verdana;color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=1 color=black face=Verdana><span
style='font-size:8.5pt;font-family:Verdana;color:black'>==================================<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=1 color=black face=Verdana><span
style='font-size:8.5pt;font-family:Verdana;color:black'>==================================<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=1 color=black face=Verdana><span
style='font-size:8.5pt;font-family:Verdana;color:black'>==================================<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=1 color=black face=Verdana><span
style='font-size:8.5pt;font-family:Verdana;color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=1 color=black face=Verdana><span
style='font-size:8.5pt;font-family:Verdana;color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=1 color=black face=Verdana><span
style='font-size:8.5pt;font-family:Verdana;color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=1 color=black face=Verdana><span
style='font-size:8.5pt;font-family:Verdana;color:black'>This is my problem/error
sir <br>
<br>
1. ERROR = "" A NO "" <br>
and<br>
<br>
2. ERROR = "" -ERR No INBOX for user. " <br>
<br>
<br>
I run Dovecot + Postfix + Postfixadmin + MySQL<br>
<br>
When i work with command line<br>
..<br>
<br>
i have problem <br>
like this <br>
( When i 'm in command line ) <br>
##############################*###### <br>
[root@server etc]# telnet localhost 143 <br>
Trying 127.0.0.1... <br>
Connected to localhost.localdomain (127.0.0.1). <br>
Escape character is '^]'. <br>
* OK dovecot ready. <br>
A LOGIN test...@pepocono.com 123456 <br>
A OK Logged in. <br>
A SELECT inbox <br>
A NO <br>
A LOGOUT <br>
* BYE Logging out <br>
A OK Logout completed. <br>
Connection closed by foreign host <br>
##############################*###### <br>
[root@server etc]# telnet localhost 110 <br>
Trying 127.0.0.1... <br>
Connected to localhost.localdomain (127.0.0.1). <br>
Escape character is '^]'. <br>
+OK dovecot ready. <br>
USER test...@pepocono.com <br>
+OK <br>
PASS 123456 <br>
+OK Logged in. <br>
-ERR No INBOX for user. <br>
Connection closed by foreign host. <br>
[root@jenus etc]# <br>
##############################*####### <br>
<br>
<br>
My Config <br>
==============================*======== <br>
dvecot.conf <br>
==============================*======== <br>
default_mail_env = maildir:/var/mail/virtual/%1u/*%u/Maildir <br>
auth = plain <br>
auth_mechanisms = plain digest-md5 <br>
auth_userdb = mysql /usr/local/etc/dovecot-mysql.c*onf <br>
auth_passdb = mysql /usr/local/etc/dovecot-mysql.c*onf <br>
auth_user = mailusers <br>
==============================*======== <br>
dvecot-mysql.conf <br>
==============================*======== <br>
db_host = localhost <br>
db_unix_socket = /var/lib/mysql/mysql.sock <br>
db = postfix <br>
db_user = postfix <br>
db_passwd = postfix <br>
db_client_flags = 0 <br>
password_query = SELECT password FROM mailbox WHERE username = '%u' <br>
#user_query = SELECT concat('/var/mail/virtual/', maildir) as home, <br>
10000 as uid, 10000 as gid FROM mailbox WHERE username = '%u' <br>
#user_query = SELECT '10000' AS uid, '10000' AS gid FROM mailbox WHERE <br>
username = '%u' AND active = '1' <br>
#user_query = SELECT home, uid, gid FROM users WHERE user = '%u' <br>
user_query = SELECT home, uid, gid FROM users WHERE user = '%u' AND <br>
active = '1' <br>
<br>
<br>
( i use all case #comment but it'doesn't work ) <br>
<br>
<br>
==============================*======== <br>
main.cf <br>
==============================*======== <br>
virtual_mailbox_base = /var/mail/virtual <br>
virtual_mailbox_domains = <br>
mysql:/etc/postfix/postfixmysq*l/mysql_virtual_domains_maps.c*f <br>
virtual_mailbox_limit = 51200000 <br>
virtual_mailbox_maps = <br>
mysql:/etc/postfix/postfixmysq*l/mysql_virtual_mailbox_maps.c*f <br>
virtual_alias_domains = $virtual_alias_maps <br>
virtual_minimum_uid = 10000 <br>
virtual_uid_maps = static:10000 <br>
virtual_gid_maps = static:10000 <br>
# Additional for quota support <br>
virtual_create_maildirsize = yes <br>
virtual_mailbox_extended = yes <br>
virtual_mailbox_limit_maps = <br>
mysql:/etc/postfix/postfixmysq*l/mysql_virtual_mailbox_limit_*maps.cf <br>
virtual_mailbox_limit_override = yes <br>
virtual_maildir_limit_message = Sorry, the user's maildir has overdrawn <br>
his diskspace quota, please try again later. <br>
virtual_overquota_bounce = yes <br>
<br>
=========================<br>
Note ( more information ) :: <br>
========================= <br>
mailusers uid=10000 gid = 10000 home = /var/mail/virtual<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
</div>
</body>
</html>