search for: db_passwd

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: +-------------------+--------------+----------...

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) A...

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

...n db-mysql.c 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'

...auth_userdb = mysql /etc/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'

...--- start dovecot.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...

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

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)

...l. All my users data are there. But I intend to use MD5 instead of clear passwords at MySQL. Someone can help-me? []s; Andrey Here's my dovecot-mysql.conf: # Dovecot queries db_host = localhost db_unix_socket = /var/lib/mysql/mysql.sock db_port = 3306 db = mail db_user = my_conn_user db_passwd = my_conn_passwd # # Pehapes i need to change this, but I tryied changing it do md5 with no success. # default_pass_scheme = PLAIN # # This I changed for own reasons, but works. # password_query = SELECT clear FROM postfix_users WHERE user=substring_index('%u', "@", 1) user_...

.../dovecot-mysql.c*onf 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 ui...

I use dovecot-0.99.11 from RHEL4. dovecot-mysql.conf: === db_host = dbhost db_port = 3306 db = db db_user = dovecot db_passwd = pass default_pass_scheme = PLAIN password_query = SELECT password FROM users WHERE username = '%u' user_query = select maildir AS home,u_id AS uid,g_id AS gid from users WHERE username = '%u' === When I try "telnet localhost 110" and enter test login, I get in errorlog...

...rotocol pop3 { mail_max_userip_connections = 10 pop3_client_workarounds = outlook-no-nuls oe-ns-eoh ssl_cert = </etc/postfix/ssl/pop_warenform_de.crt ssl_key = </etc/postfix/ssl/pop_warenform_de.key } ----- sql-dict.conf.ext: connect = host=/var/run/postgresql user=db_user password=db_passwd dbname=db_name # quota 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 } # expires map { pattern = shared/expire/$user/$mailbox...

...al/etc/dovecot-mysql.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 retu...

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