Displaying 3 results from an estimated 3 matches for "mailsql".
2011 Jan 03
2
dovecot: auth: Fatal: sql_driver_register(mysql): Already registered
...s_limit = 1024
process_min_avail = 2
}
protocol sieve {
managesieve_max_line_length = 65536
}
plugin {
sieve = ~/.dovecot.sieve
sieve_dir = ~/sieve
}
[root at postfixjail /usr/local/etc/dovecot]# grep -hv '^ *\(#.*\)\?$'
dovecot-dict-sql.conf.ext
connect = host=127.0.0.3 dbname=mailsql user=mailsql password=somepassword
map {
pattern = priv/quota/storage
table = quota2
username_field = username
value_field = bytes
}
map {
pattern = priv/quota/messages
table = quota2
username_field = username
value_field = messages
}
[root at postfixjail /usr/local/etc/dovecot]# g...
2006 Oct 13
1
MySQL stored proc authorization
...l Authorize('%u', '%n', '%d')
Simply put dovecot is calling my mysql stored routine which handles
authorization. Until today, when I updated dovecot to dovecot-1.0_rc8 it
worked flawlessly. With this version executing stored proc dies with:
Password query failed: PROCEDURE mailsql.Authorize can't return a result set
in the given context
Replacing stored proc call with select .... statement does the thing, but
it's stored procedures are ... generally better to do things on DB imvho :-)
Downgrading to dovetot-1.0_rc7 fixes the problem immediately. Of course
/etc/dovec...
2008 Apr 15
1
Dovecot LDA / Deliver question
...path: /var/spool/postfix/private/auth
mode: 432
user: postfix
group: postfix
master:
path: /var/run/dovecot/auth-master
mode: 432
user: vmail
group: vmail
grep -v '^ *\(#.*\)\?$' dovecot-sql.conf
driver = mysql
connect = host=localhost dbname=mailsql user=mailquery password=m at 1l
default_pass_scheme = PLAIN-MD5
password_query = SELECT email as user, passwd AS password,
concat('/var/vmail',homeDir) as userdb_home, 1101 AS userdb_uid, 1101 AS
userdb_gid, concat('maildir:/var/vmail',mailDir) as userdb_mail FROM users
WHERE (usern...