[Dovecot] Cant Receive Email from dovecot pop -typos corrected....
Linux Advocate
linuxhousedn at yahoo.com
Sun Feb 22 10:39:32 EET 2009
It works !!!!!!!!!!!!!!!!!!!!!!!!!!!!! Thanx everybody. Got my sanity back... Thanx Timo.
----- Original Message ----
> From: Linux Advocate <linuxhousedn at yahoo.com>
> To: Dovecot Mailing List <dovecot at dovecot.org>
> Sent: Sunday, February 22, 2009 3:29:01 PM
> Subject: Re: [Dovecot] Cant Receive Email from dovecot pop -typos corrected....
>
>
> A. Timo, with mail debug=yes , the log is as below...
> ............................................................................
>
> Feb 22 13:21:53 fwgw dovecot: auth(default): client in: AUTH 1 PLAIN
> service=POP3 lip=::ffff:60.54.174.146 rip=::ffff:192.168.10.96
> resp=
> Feb 22 13:21:53 fwgw dovecot: auth-worker(default):
> sql(fizan at mesara.biz,::ffff:192.168.10.96): query: SELECT password FROM mailbox
> WHERE username = 'fizan at mesara.biz'
> Feb 22 13:21:53 fwgw dovecot: auth(default): client out: OK 1
> user=fizan at mesara.biz
> Feb 22 13:21:53 fwgw dovecot: auth(default): master in: REQUEST 1 20628
> 1
> Feb 22 13:21:53 fwgw dovecot: auth-worker(default):
> sql(fizan at mesara.biz,::ffff:192.168.10.96): SELECT maildir, 89 AS uid, 89 AS gid
> FROM mailbox WHERE username = 'fizan at mesara.biz'
> Feb 22 13:21:53 fwgw dovecot: auth(default): master out: USER 1
> fizan at mesara.biz maildir=fizan at mesara.biz/ uid=89 gid=89
> Feb 22 13:21:53 fwgw dovecot: pop3-login: Login: user=,
> method=PLAIN, rip=::ffff:192.168.10.96, lip=::ffff:60.54.174.146
> Feb 22 13:21:53 fwgw dovecot: POP3(fizan at mesara.biz): Effective uid=89, gid=89
> Feb 22 13:21:53 fwgw dovecot: POP3(fizan at mesara.biz): maildir:
> data=/home/vmail/mesara.biz/fizan
> Feb 22 13:21:53 fwgw dovecot: POP3(fizan at mesara.biz): maildir:
> root=/home/vmail/mesara.biz/fizan,
> index=/home/vmail/mesara.biz/haifizan,control=, inbox=
> Feb 22 13:21:53 fwgw dovecot: POP3(fizan at mesara.biz): Disconnected: Logged out
> top=0/0, retr=0/0, del=0/0, size=0
>
> B. The /etc/dovecot-mysql.conf file ; ( copied from
> http://www.campworld.net/thewiki/pmwiki.php/LinuxServersCentOS/Cent5VirtMailServer)
> ( similar syntax for the
> user_query shown in other sites as well, such as opensuse howto... )
> ( also in postfixadmin2.3's
> dovecot.txt file)
> .......................................................................................................................................................................................................
>
> driver = mysql
> connect = host=localhost dbname=postfix user=postfix password=kasdf
> default_pass_scheme = PLAIN
> password_query = SELECT password FROM mailbox WHERE username = '%u'
> user_query = SELECT maildir, 89 AS uid, 89 AS gid FROM mailbox WHERE username =
> '%u'
>
> In dovecot.conf, my default_mail_env = maildir:/home/vmail/%d/%n, So from the
> log , i can see that dovecot is accesing the right area ( yes? )
> .
> .
> .
> BUT
> .
> .
> When i go to /home/vmail, i can see that the test emails i sent are going to
> folder "fizan at mesara.biz" instead of "mesara.biz/fizan"
>
> [root at fwgw ]# cd /home/vmail
> [root at fwgw vmail]# ls -l
> total 16
> drwx------ 5 postfix postfix 4096 Feb 21 18:49 fizan at meswara.biz
> drwx------ 3 postfix postfix 4096 Feb 21 21:07 mesara.biz
>
> I guess the culprit is the settings in postfixadmin's config.inc.php
>
> // Mailboxes
> // If you want to store the mailboxes per domain set this to 'YES'.
> // Examples:
> // YES: /usr/local/virtual/domain.tld/username at domain.tld
> // NO: /usr/local/virtual/username at domain.tld
>
> $CONF['domain_path'] = 'NO';
>
> // If you don't want to have the domain in your mailbox set this to 'NO'.
> // Examples:
> // YES: /usr/local/virtual/domain.tld/username at domain.tld
> // NO: /usr/local/virtual/domain.tld/username
> // Note: If $CONF['domain_path'] is set to NO, this setting will be forced to
> YES.
>
> $CONF['domain_in_mailbox'] = 'YES';
>
> I am gonna try to set the first to YES and the second to NO and will report
> back to the list.
>
> Also, timo , i am hopeless at sql statements and i am not able to fully
> understand the sql statement that u have given. Sorry. I am hoping to either
>
> 1. make postfix/ LDA store emails at /home/vmail/mesara.biz/username
>
> OR
>
> 2. make imap read emails from /home/vmail/username at mesara.biz
>
> Comments/help most welcome.
>
>
>
>
> ----- Original Message ----
> > From: Timo Sirainen
> > Subject: Re: [Dovecot] Cant Receive Email from dovecot pop -typos
> corrected....
> >
> > On Sat, 2009-02-21 at 05:28 -0800, Linux Advocate wrote:
> > > A. Still can't retrieve mail..... the mailliog shows.....
> >
> > Set mail_debug=yes. It'll show where Dovecot is looking for the mail.
> >
> > > Feb 21 21:16:23 fwgw dovecot: auth-worker(default):
> > sql(fizan at mesara.biz,::ffff:60.50.250.8): SELECT maildir, 89 AS uid, 89 AS gid
>
> > FROM mailb ox WHERE username = 'fizan at mesara.biz'
> >
> > The "maildir" doesn't do anything. Dovecot doesn't look for "maildir"
> > field.
> >
> > > Feb 21 21:16:23 fwgw dovecot: auth(default): master out: USER 4
> > fizan at mesara.biz maildir=fizan at mesara.biz/ uid=89 gid=89
> >
> > Also the maildir is relative to some other directory apparently? That's
> > not going to work. Perhaps you want something like:
> >
> > user_query = SELECT concat('/var/vmail/', maildir) AS home, ...
> >
> > and in dovecot.conf set mail_location = maildir:~
> >
> >
> > > Feb 21 21:16:23 fwgw dovecot: POP3(fizan at mesara.biz): Disconnected:
> > > Logged out top=0/0, retr=0/0, del=0/0, size=0
> > > No idea what the above means though..... " Disconnected "
> >
> > "Logged out" means that the client had successfully logged in and then
> > used QUIT command to log out.
More information about the dovecot
mailing list