search for: db_unix_socket

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

...-no-nuls mail_drop_priv_before_exec = no auth = default auth_mechanisms = plain auth_userdb = mysql /usr/local/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 t...

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

...however the password_query works. Instead the default user query in 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 use...

..._env = /var/spool/virtual/%u auth = default auth_mechanisms = plain 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'

Hi, I configured dovecot IMAP for MySQL authentification. --- 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 -- /v...

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

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)

Hi List. I've got a dovecot running with mysql. 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...

...led mailbox with the vmail user. Not sure what else I can check Dovecot error message lacks the reason it can not connect - unless the (13) means anything to anybody??? Anybody have any ideas??? dovecot.conf : . auth_assdb = mysql /etc/dovecot-mysql.conf dovecot-mysql.conf : db_host = localhost db_unix_socket = /var/lib/mysql/mysql.sock #db_port = 3306 db = vmail db_user = vmail db_passdb = temp password_query = SELECT 'test' as password from mailbox vmail.sql: create database vmail; use vmail; grant insert,select,update,delete on vmail.* to 'vmail'@'localhost' identified by ...

...plain auth_mechanisms = plain digest-md5 auth_userdb = mysql /usr/local/etc/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 W...

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