-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 timo thanks again (and again).
but ... :( i attach my logs with mail_debug=yes i also attach my dovecot-sql.conf and my table too. I am reading from http://wiki.dovecot.org/UserDatabase that variable mail is overriding the default mail_location so i tried to pass all my values at mail with delimiter : for INDEX and CONTROL. Timo Sirainen wrote: > On May 15, 2008, at 5:07 PM, Evaggelos Balaskas wrote: >> there is not index nor control folder nor user folder created under /var/mail Evaggelos Balaskas - http://ebalaskas.gr Unix System Engineer Informatics Engineer Technological Education -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFILX/PWIK+Pe9twhoRAhYcAJ0WT+7onaRO+R5jArhpzrqHUrHKkACcCxDw iiYRJQW2I9jFfSKhtUlK4us= =GsYd -----END PGP SIGNATURE-----
dovecot: May 16 15:25:59 Info: IMAP([EMAIL PROTECTED]): Connection closed bytes=0/0 dovecot: May 16 15:26:01 Info: auth(default): new auth connection: pid=6618 dovecot: May 16 15:26:06 Info: auth(default): client in: AUTH 1 PLAIN service=imap secured lip=127.0.0.1 rip=127.0.0.1 lport=1143 rport=36937 resp=AGViYWxAZWJhbGFza2FzLmdyAHRlc3Q= dovecot: May 16 15:26:06 Info: auth(default): client out: OK 1 [EMAIL PROTECTED] dovecot: May 16 15:26:06 Info: auth-worker(default): sql([EMAIL PROTECTED],127.0.0.1): query: SELECT concat(userid, '@', domain) AS user, password, nets AS allow_nets FROM users WHERE userid = 'ebal' AND domain = 'ebalaskas.gr' dovecot: May 16 15:26:06 Info: auth-worker(default): auth([EMAIL PROTECTED],127.0.0.1): allow_nets: Matching for network 127.0.0.1 dovecot: May 16 15:26:06 Info: auth(default): master in: REQUEST 3 6512 1 dovecot: May 16 15:26:06 Info: auth-worker(default): sql([EMAIL PROTECTED],127.0.0.1): SELECT concat(userid, '@', domain) AS user, home, username, uid, gid, concat( mail_type, ':', home, 'ebalaskas.gr/ebal:INDEX=', home, `index`, '/ebalaskas.gr/ebal:CONTROL=', home, control , '/ebalaskas.gr/ebal' ) AS mail FROM users WHERE userid = 'ebal' AND domain = 'ebalaskas.gr' dovecot: May 16 15:26:06 Info: auth(default): master out: USER 3 [EMAIL PROTECTED] home=/var/mail/ username=Evaggelos Balaskas uid=1108 gid=8 mail=maildir:/var/mail/ebalaskas.gr/ebal:INDEX=/var/mail/.index/ebalaskas.gr/ebal:CONTROL=/var/mail/.control/ebalaskas.gr/ebal dovecot: May 16 15:26:06 Info: imap-login: Login: user=<[EMAIL PROTECTED]>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured dovecot: May 16 15:26:06 Info: IMAP([EMAIL PROTECTED]): Effective uid=1108, gid=8, home=/var/mail/ dovecot: May 16 15:26:06 Info: IMAP([EMAIL PROTECTED]): maildir: data=/var/mail/ebalaskas.gr/ebal:INDEX=/var/mail/.index/ebalaskas.gr/ebal:CONTROL=/var/mail/.control/ebalaskas.gr/ebal dovecot: May 16 15:26:06 Info: IMAP([EMAIL PROTECTED]): maildir++: root=/var/mail/ebalaskas.gr/ebal, index=/var/mail/.index/ebalaskas.gr/ebal, control=/var/mail/.control/ebalaskas.gr/ebal, inbox=/var/mail/ebalaskas.gr/ebal
driver = mysql connect = host=localhost dbname=dovecot user=root password_query = SELECT concat(userid, '@', domain) AS user, \ password, nets AS allow_nets FROM users WHERE userid = '%n' AND domain = '%d' user_query = SELECT concat(userid, '@', domain) AS user, home, username, uid, gid, \ concat( mail_type, ':', home, '%d/%n:INDEX=', home, `index`, '/%d/%n:CONTROL=', home, control , '/%d/%n' ) AS mail \ FROM users WHERE userid = '%n' AND domain = '%d'
CREATE TABLE IF NOT EXISTS `users` ( `userid` varchar(128) NOT NULL, `domain` varchar(128) NOT NULL, `password` varchar(64) NOT NULL, `username` varchar(100) NOT NULL, `mail_type` varchar(10) NOT NULL, `home` varchar(255) NOT NULL, `sieve` varchar(255) NOT NULL, `index` varchar(100) NOT NULL, `control` varchar(100) NOT NULL, `nets` varchar(100) NOT NULL, `uid` int(11) NOT NULL, `gid` int(11) NOT NULL, PRIMARY KEY (`userid`,`domain`) ) ENGINE=MyISAM;