-----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(ebal@ebalaskas.gr): 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 user=ebal@ebalaskas.gr
dovecot: May 16 15:26:06 Info: auth-worker(default): sql(ebal@ebalaskas.gr,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(ebal@ebalaskas.gr,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(ebal@ebalaskas.gr,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 ebal@ebalaskas.gr 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=<ebal@ebalaskas.gr>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
dovecot: May 16 15:26:06 Info: IMAP(ebal@ebalaskas.gr): Effective uid=1108, gid=8, home=/var/mail/
dovecot: May 16 15:26:06 Info: IMAP(ebal@ebalaskas.gr): 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(ebal@ebalaskas.gr): 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;