search for: db_client_flag

Hi everyone, i used postfix, dovecot and mysql. I have virtual users and domains. I have this configuration in dovecot-mysql.conf: db_host = localhost db_port = 3306 db_unix_socket = /var/run/mysqld/mysqld.sock db = postfix db_user = postfix db_passwd = bscidth46 db_client_flags = 0 default_pass_scheme = CRYPT password_query = SELECT password FROM mailbox WHERE username = '%u' user_query = SELECT maildir, 105 AS uid, 106 AS gid FROM mailbox WHERE username = '%u' The table mailbox: +-------------------+--------------+------------------+-----------+------...

...he error above). So, I know that I can change the <code class="literal"><i>wait_timeout</i> option in MySql but is there a way to specify an unlimited time connection only from Dovecot to MySql? And by the way, what's exactly the purpose of Dovecot's <i>db_client_flags</i> option? Would it be possible to specify the timeout via this option? Thanks for your help! Marc-Andr&eacute; </code></pre> </body> </html>

Hi list, i use dovecot-1.0-1.2.rc15.el5 installed from rpm centos 5.0 I cant get mysql authetication working: this is my /etc/dove-mysql.conf ######dove-mysql.conf should look like this########## #db_host = 127.0.0.1 #db_port = 3306 db = postfix db_user = postfix db_passwd = secret db_client_flags = 0 default_pass_scheme = PLAIN password_query = SELECT password FROM mailbox WHERE username = '%u' user_query = SELECT '/var/vmail/%d/%n' as home, 'maildir:/var/vmail/%d/%n' as mail, 150 AS uid, 12 AS gid, concat('dirsize:storage=',quota) AS quota FROM mailbox WH...

I get the following error on auth with mysql on pop3 what am i missing or doing wrong mysql config file db_host = localhost #db_port = 3306 db_unix_socket = /var/lib/mysql/mysql.sock db = ADMIN db_user = mailmaster db_passwd = ******** db_client_flags = 0 default_pass_scheme = PLAIN password_query = SELECT MAILBOX_PASSWORD AS password FROM MAIL WHERE MAILBOX_USERNAME = '%n' AND MAILBOX_DOMAIN = '%d' #user_query = SELECT MAILBOX_ROOT AS home,uid,gid FROM MAIL WHERE MAILBOX_USERNAME = '%n' and MAILBOX_DOMAIN='%d'...

...always takes effect. Might this be a bug or is something worng wit my setup below? (To keep on working i changed the default query in db-mysql.c..) Helmut dovecot-mysql.conf: db_host = localhost #db_port = 3306 db_unix_socket = /var/lib/mysql/mysql.sock db = mail db_user = mail db_passwd = db_client_flags = 0 default_pass_scheme = PLAIN password_query = SELECT password FROM users WHERE login = '%n' and domain='%d' user_query = SELECT '/var/mail/%d/%n' as home, 506 as uid, 100 as gid FROM users WHERE login = '%n' and domain='%d'

...c/dovecot/mysql.conf auth_passdb = mysql /etc/dovecot/mysql.conf auth_executable = /usr/local/libexec/dovecot/dovecot-auth auth_user = dovecot-auth /etc/dovecot/mysql.conf db_host = localhost db_port = 3306 db_unix_socket = /tmp/mysql.sock db = postfix db_user = postfixuser db_passwd = userpostfix db_client_flags = 0 password_query = SELECT password FROM mailbox WHERE username = '%u' user_query = SELECT maildir, 1000 AS uid, 1000 AS gid FROM mailbox WHERE username = '%u'

...cot.conf --- auth_userdb = mysql /etc/dovecot/dovecot-mysql.conf auth_passdb = mysql /etc/dovecot/dovecot-mysql.conf --- end dovecot.conf --- --- start dovecot-mysql.conf --- db_host = localhost db_port = 3306 db_unix_socket = /var/run/mysqld/mysqld.sock db = users db_user = users db_passwd = xxx db_client_flags = 0 password_query = SELECT password FROM users WHERE userid = '%n' AND active = 'Y' user_query = SELECT home, uid, gid FROM users WHERE userid = '%u' --- end dovecot-mysql.conf -- /var/log/mail.log looks fine: --- start mail.log --- Aug 29 14:40:43 vs6020 dovecot: Dove...

...perience 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...

Hello all.. I'm trying to configure dovecot do athenticate using mysql, but I?m having some troubles... After configuring the mysql athentication in dovecot-mysql.conf and in dovecot.conf, when I try to login I get this mesage in my logs: Dovecot-auth: MySQL: Can't connect to database dovecot: Can't connect to local MySQL server through socket '/var/tmp/mysql.sock' (2)

...auth_passdb = mysql /usr/local/etc/dovecot-mysql.c*onf auth_user = mailusers ==============================*======== dvecot-mysql.conf ==============================*======== db_host = localhost db_unix_socket = /var/lib/mysql/mysql.sock db = postfix db_user = postfix db_passwd = postfix db_client_flags = 0 password_query = SELECT password FROM mailbox WHERE username = '%u' #user_query = SELECT concat('/var/mail/virtual/', maildir) as home, 10000 as uid, 10000 as gid FROM mailbox WHERE username = '%u' #user_query = SELECT '10000' AS uid, '10000' AS gid...

...ql.conf auth_passdb = mysql /usr/local/etc/dovecot-mysql.conf auth_user = root auth_verbose = yes auth_debug = yes dovecot-mysql.conf db_host = localhost db_port = 3306 # db_unix_socket = /var/tmp/mysql.sock db_unix_socket = /var/run/mysqld/mysqld.sock db = vmail db_user = vmail db_passwd = xxxxx db_client_flags = 0 # Default password scheme. # # Currently supported schemes include PLAIN, PLAIN-MD5, DIGEST-MD5, and # CRYPT. # default_pass_scheme = PLAIN-MD5 # Query to retrieve the password. # # The query should return one row, one column. If more than one row or # column # is returned, authentication wi...

I've been playing around with Dovecot for the past few months for testing (on a Debian 3.0 system), and initially it was easy to setup and worked well. Recently I upgraded to 0.99.10.9, and when I rebuilt it I enabled MySQL and SSL. The first problem I ran into was upon startup it complained that there was no certificate, which makes sense, except that I hadn't enabled imaps in the