[Dovecot] DOVECOT+SQLITE
Has somebody experience with DOVECOT+SQLITE?
Which will be the config variables?
auth_userdb = mysql /etc/dovecot/dovecot-mysql.conf
db_host = localhost db_port = 3306 db_unix_socket = /var/run/mysqld/mysqld.sock db = test db_user = test db_passwd = test db_client_flags = 0
default_pass_scheme = PLAIN
password_query = SELECT clear FROM users WHERE username = '%u' user_query = SELECT pop as home, uid, gid FROM users WHERE username = '%u'
Is possible use sqlrelay
Alexandre Busquets wrote:
Has somebody experience with DOVECOT+SQLITE?
yes.
Which will be the config variables?
passdb sql { args = /etc/dovecot/sqlite.conf }
in sqlite.conf:
driver = sqlite # chrooted to /etc/dovecot connect = /auth.sqlt
password_query = SELECT user, pass AS password FROM user WHERE user='%u'
auth_userdb = mysql /etc/dovecot/dovecot-mysql.conf
That's from 0.99, which does not support sqlite.
Is possible use sqlrelay
What's that?
SQL Relay is a persistent database connection pooling, proxying and load balancing system for Unix and Linux.
2006/4/12, Jakob Hirsch <jh@plonk.de>:
Alexandre Busquets wrote:
Has somebody experience with DOVECOT+SQLITE?
yes.
Which will be the config variables?
passdb sql { args = /etc/dovecot/sqlite.conf }
in sqlite.conf:
driver = sqlite # chrooted to /etc/dovecot connect = /auth.sqlt
password_query = SELECT user, pass AS password FROM user WHERE user='%u'
auth_userdb = mysql /etc/dovecot/dovecot-mysql.conf
That's from 0.99, which does not support sqlite.
Is possible use sqlrelay
What's that?
participants (2)
-
Alexandre Busquets
-
Jakob Hirsch