search for: db_user

...p and I'm doing so, but I need to have some domains on different containers for specific reasons). In order to keep it all clean, I want to use different PostgreSQL databases for each container, and I'm running the container with an environment file containing database parameters, such as: DB_USER DB_HOST DB_NAME I've been trying to pass these parameters to dovecot's configuration, but they don't get parsed and I end up with messages like: dovecot: auth: Error: pgsql(%{env:DB_HOST}): Connect failed to database %{env:DB_NAME} I've tried to pass variables alone, using import_e...

i use openbsd/i386, dovecot-cvs(today), mysql-5.0.18 today, i change the mysql_dbuser_password form OLD_PASSWORD to PASSWORD then dovecot can't connect to mysql-server shell$> mysql -u root -p mysql$> SET PASSWORD FOR 'db_user'@'localhost' = PASSWORD('db_pw'); now, dovecot CAN NOT connect to mysql-server shell$> mysql -u root -p mysql$> SET PASSWORD FOR 'db_user'@'localhost' = OLD_PASSWORD('db_pw'); now, dovecot CAN connect to mysql-server and everything work fine i pat...

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

...remove all related entries from Puppet''s storeconfigs database. # Use when a host is removed from the Puppet network forcibly # Alternatives: run puppet on host to be removed with a blank manifest (node blah {}) # use DBI; my $dsn = ''DBI:mysql:database_server_here''; my $db_user = ''root''; my $db_pass = ''xxx''; my $dbh = DBI->connect($dsn, $db_user, $db_pass); my $query; if (($#ARGV + 1) ne 1) { print "Fail.\n"; print "Usage: $ARGV[0] host_name\n"; } else { my $result; print "Delete from hosts tabl...

...ed to have some domains on different >containers for specific reasons). > >In order to keep it all clean, I want to use different PostgreSQL >databases >for each container, and I'm running the container with an environment >file >containing database parameters, such as: >DB_USER >DB_HOST >DB_NAME >I've been trying to pass these parameters to dovecot's configuration, >but >they don't get parsed and I end up with messages like: dovecot: auth: >Error: pgsql(%{env:DB_HOST}): Connect failed to database %{env:DB_NAME} > >I've tried to pass...

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

...but the dont seems to undefined (see the second example (hsmith) Any suggestions on either fixing the empty groups issue ora better handling groups that are not part of this node would be greatly appreciated. Thanks my user class .... $default_groups = [ ''wheel'' ] # db_user will be "undef" and it need to be a empty string if defined(Class[''mysql'']) { $db_group = $mysql::params::group } else { $db_group = '''' } $all_groups = [ $default_groups, $db_group ] notice "All: <${all_groups}>" # T...

Does anyone have some examples of using this create_resources function, https://github.com/puppetlabs/puppetlabs-create_resources, ? Based on the README example I can''t figure out exactly how to change from using defines to using this function. Maybe I misunderstand the purpose of create_resources...is it to replace defines, or is it to allow ENCs (for example) to use a define? Below

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

...lt 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 users WHERE login = '%n' and domain='...

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

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

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

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)

...vecot 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 FROM postfix_users WHERE user=substring_index('%u',...

...ot 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 'temp'; CREATE TABLE mailbox ( user varchar(20) not nul...

...ysql /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 WHERE username = '%u' #user_query = SELECT...

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

...enform_de.key } protocol 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/exp...

...= 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 the password. # # The query should return one row, one column. If more than one row or...