search for: postfix_database_password

...that > line with substitution so no prompting is involved. I saw this, and at first did not like it, as how to manage the mysql root password, so I found how to use here doc: mysql -u root -p <<EOF || exit 1 CREATE DATABASE postfix; CREATE USER postfix at localhost IDENTIFIED BY "$Postfix_Database_Password"; GRANT ALL PRIVILEGES ON postfix.* TO postfix at localhost; EOF next refinement is: mysql -u root -p$mysql_root_Password <<EOF || exit 1 CREATE DATABASE postfix; CREATE USER postfix at localhost IDENTIFIED BY "$Postfix_Database_Password"; GRANT ALL PRIVILEGES ON postfix.* TO...

...lugins/QuotaClone how does: mail_plugins = $mail_plugins quota quota_clone plugin { ? quota_clone_dict = redis:host=127.0.0.1:port=6379 } get replaced with something for mysql? dovecot-sql.conf.ext: driver = mysql connect = host=/var/lib/mysql/mysql.sock dbname=postfix user=postfix password=$Postfix_Database_Password default_pass_scheme = $cryptsha-CRYPT # following should all be on one line. password_query = SELECT username as user, password, concat('/home/vmail/', maildir) as userdb_home, concat('maildir:/home/vmail/', maildir) as userdb_mail, 101 as userdb_uid, 12 as userdb_gid FROM mailbo...

...mailserver builders. Also I am using Postfixadmin which provides quotas per user in mysql database. To access those quotas for dovecot, I have the following script: cat <<EOF>/etc/dovecot/dovecot-dict-quota.conf || exit 1 connect = host=localhost dbname=postfix user=postfix password=$Postfix_Database_Password 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 } EOF Where $Postfix_Database_Password is an env variable in my install howt...

...dates for the user?? Or only an incremental change? I ask because I am looking at migrating all the user mail from the old server to the new and building a new sql database.? All I see is: dovecot-dict-sql.conf.ext: connect = host=/var/lib/mysql/mysql.sock dbname=postfix user=postfix password=$Postfix_Database_Password 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 } what is actually done with this table? thanks -------------- next part -------------- An...

...quota = dict:user::proxy::sqlquota } EOF Appends to the end of 90-quota.conf (tried to do with with a single SED, but it was getting messy) finally: cat <<EOF>/etc/dovecot/dovecot-dict-sql.conf.ext || exit 1 connect = host=localhost dbname=postfix user=postfix password=$Postfix_Database_Password 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 } EOF Please let me know if I missed something here. Thanks On 03/17/2017...

...e? >> >> I ask because I am looking at migrating all the user mail from the old >> server to the new and building a new sql database.? All I see is: >> >> dovecot-dict-sql.conf.ext: connect = host=/var/lib/mysql/mysql.sock >> dbname=postfix user=postfix password=$Postfix_Database_Password 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 } >> >> >> what is actually done with this table? >&g...

...>> quota_clone_dict = redis:host=127.0.0.1:port=6379 >> } >> >> get replaced with something for mysql? >> >> dovecot-sql.conf.ext: >> >> driver = mysql >> connect = host=/var/lib/mysql/mysql.sock dbname=postfix user=postfix >> password=$Postfix_Database_Password >> default_pass_scheme = $cryptsha-CRYPT >> # following should all be on one line. >> password_query = SELECT username as user, password, >> concat('/home/vmail/', maildir) as userdb_home, >> concat('maildir:/home/vmail/', maildir) as userdb_mail, 101...

I want to script a rather simple create database operation. Thing is, I have to provide the password for that database. I would like to do this with an environment variable, but the simple approach dose not work: mailpswd=charlie mysql -u root -p CREATE DATABASE mailfix; CREATE USER 'mailfix'@'localhost' IDENTIFIED BY $mailpswd; GRANT ALL PRIVILEGES ON `mailfix` . * TO

...rver, but to share with you what I have done for Dovecot customization and maybe to get some recommendations on improvements. For the most part, I have used SED to modify the conf files. I use a few env variables: your_domain_tld= your_host_only= your_host_tld=$your_host_only.$your_domain_tld Postfix_Database_Password= What follows are the pieces of my customization, all comments welcomed (this is NOT adequately tested! That is later in the week!): sed -i -e "/^#protocols/s/$/ sieve/w /dev/stdout" /etc/dovecot/dovecot.conf sed -i -e "s/^#protocols/protocols/w /dev/stdout" /etc/dovecot/dov...

I reread my sql.conf.ext files and realized they were actually connecting to localhost. So I did some googling, and found how to connect to the socket: connect = host=/var/lib/mysql/mysql.sock dbname=postfix user=postfix password=Postfix_Database_Password And all fixed. No more failures. Plus probably securer. On 04/07/2017 10:57 AM, Robert Moskowitz wrote: > The strange thing is that dovecot auth has no problem connecting to > mysql, but the quota query is what is failing. > > On 04/07/2017 10:43 AM, Robert Moskowitz wrote: >&gt...

I have trying to find how to set the dovecot-sql.conf for using SHA256/512.? I am going to start clean with the stronger format, not migrate from the old MD5.? It seems all I need is: driver = mysql connect = host=/var/lib/mysql/mysql.sock dbname=postfix user=postfix password=$Postfix_Database_Password default_pass_scheme = SHAxxx-CRYPT # following should all be on one line. password_query = SELECT username as user, password, concat('/home/vmail/', maildir) as userdb_home, concat('maildir:/home/vmail/', maildir) as userdb_mail, 101 as userdb_uid, 12 as userdb_gid FROM mailbox...

...se I am looking at migrating all the user mail from the old >>>> server to the new and building a new sql database.? All I see is: >>>> >>>> dovecot-dict-sql.conf.ext: connect = host=/var/lib/mysql/mysql.sock >>>> dbname=postfix user=postfix password=$Postfix_Database_Password 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 } >>>> >>>> >>>&g...

Hello, I'm running dovecot 2.29 on a freebsd 10.3 system. I'm trying to cut down queries to my database and tried to do a userdb static and prefetch. I modified the password query to pull in userdb_quota and got an error that that was not valid. Is this behavior normal? Apr 13 17:22:15 hostname dovecot: master: Dovecot v2.2.29 (13ebc01) starting up for imap, sieve Apr 13 17:22:24

...have trying to find how to set the dovecot-sql.conf for using > SHA256/512.? I am going to start clean with the stronger format, not > migrate from the old MD5.? It seems all I need is: > driver = mysql connect = host=/var/lib/mysql/mysql.sock dbname=postfix > user=postfix password=$Postfix_Database_Password default_pass_scheme = > SHAxxx-CRYPT # following should all be on one line. password_query = > SELECT username as user, password, concat('/home/vmail/', maildir) as > userdb_home, concat('maildir:/home/vmail/', maildir) as userdb_mail, > 101 as userdb_uid, 12 as user...

...an incremental change? > > I ask because I am looking at migrating all the user mail from the old > server to the new and building a new sql database.? All I see is: > > dovecot-dict-sql.conf.ext: connect = host=/var/lib/mysql/mysql.sock > dbname=postfix user=postfix password=$Postfix_Database_Password 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 } > > > what is actually done with this table? > > thanks > &...

...I ask because I am looking at migrating all the user mail from the old > >> server to the new and building a new sql database.? All I see is: > >> > >> dovecot-dict-sql.conf.ext: connect = host=/var/lib/mysql/mysql.sock > >> dbname=postfix user=postfix password=$Postfix_Database_Password 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 } > >> > >> > >> what is actuall...

...ng a new sql database. All I see is: </div> <div> >>>> </div> <div> >>>> dovecot-dict-sql.conf.ext: connect = host=/var/lib/mysql/mysql.sock </div> <div> >>>> dbname=postfix user=postfix password=$Postfix_Database_Password map { </div> <div> >>>> pattern = priv/quota/storage table = quota2 username_field = username </div> <div> >>>> value_field = bytes } map { pattern = priv/quota/messages table = quota2 </div> <div> >>&gt...

As I have noted in previous messages, I been getting the following on my new mailserver: Apr 7 10:17:27 z9m9z dovecot: dict: Error: mysql(localhost): Connect failed to database (postfix): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) - waiting for 25 seconds before retry They go away when I setenforce 0. It is not a timing issue as I

I have been getting the following on my new mailserver: Apr 7 10:17:27 z9m9z dovecot: dict: Error: mysql(localhost): Connect failed to database (postfix): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) - waiting for 25 seconds before retry They go away when I setenforce 0. So I googled dovecot mysql selinux and the only worthwhile hit was: