dovecot - Apr 2006 - 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://dovecot.org/pipermail/dovecot/attachments/20060412/27b6a730/attachment-0002.html>

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?