Last active
October 21, 2024 10:51
-
-
Save barryo/8918488 to your computer and use it in GitHub Desktop.
Configuration Files for ViMbAdmin on Ubuntu 13.10 with Dovecot and Postfix - referenced from https://github.com/opensolutions/ViMbAdmin3/wiki/Mail-System-Install-on-Ubuntu
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| auth_mechanisms = plain login | |
| !include auth-sql.conf.ext |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| mail_location = maildir:/srv/vmail/%d/%n | |
| namespace inbox { | |
| inbox = yes | |
| } | |
| mail_uid = 2000 | |
| mail_gid = 2000 | |
| mail_privileged_group = vmail | |
| first_valid_uid = 2000 | |
| last_valid_uid = 2000 | |
| maildir_copy_with_hardlinks = yes |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| service imap-login { | |
| inet_listener imap { | |
| port = 143 | |
| } | |
| inet_listener imaps { | |
| port = 993 | |
| ssl = yes | |
| } | |
| service_count = 0 | |
| } | |
| service pop3-login { | |
| inet_listener pop3 { | |
| port = 110 | |
| } | |
| inet_listener pop3s { | |
| port = 995 | |
| ssl = yes | |
| } | |
| } | |
| service lmtp { | |
| unix_listener /var/spool/postfix/private/dovecot-lmtp { | |
| group = postfix | |
| mode = 0666 | |
| user = postfix | |
| } | |
| } | |
| service imap { | |
| } | |
| service pop3 { | |
| } | |
| service auth { | |
| unix_listener auth-userdb { | |
| mode = 0666 | |
| user = vmail | |
| group = vmail | |
| } | |
| # Postfix smtp-auth | |
| unix_listener /var/spool/postfix/private/auth { | |
| mode = 0660 | |
| user = postfix | |
| group = postfix | |
| } | |
| } | |
| service auth-worker { | |
| } | |
| service dict { | |
| unix_listener dict { | |
| } | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ssl = yes | |
| ssl_cert = </etc/postfix/ssl/mail.example.com.pem | |
| ssl_key = </etc/postfix/ssl/mail.example.com.pem | |
| ssl_require_crl = no |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| postmaster_address = [email protected] | |
| hostname = mail.example.com | |
| quota_full_tempfail = yes | |
| recipient_delimiter = + | |
| lda_mailbox_autocreate = yes | |
| lda_mailbox_autosubscribe = yes | |
| protocol lda { | |
| mail_plugins = $mail_plugins sieve quota | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| protocol imap { | |
| mail_plugins = $mail_plugins quota imap_quota | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| protocol lmtp { | |
| postmaster_address = [email protected] | |
| mail_plugins = quota sieve | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| service managesieve-login { | |
| inet_listener sieve { | |
| port = 4190 | |
| } | |
| service_count = 1 | |
| } | |
| service managesieve { | |
| } | |
| protocol sieve { | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| protocol pop3 { | |
| mail_plugins = $mail_plugins quota | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| passdb { | |
| driver = sql | |
| args = /etc/dovecot/dovecot-sql.conf.ext | |
| } | |
| userdb { | |
| driver = prefetch | |
| } | |
| userdb { | |
| driver = sql | |
| args = /etc/dovecot/dovecot-sql.conf.ext | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| driver = mysql | |
| connect = host=localhost user=vimbadmin password=password dbname=vimbadmin | |
| default_pass_scheme = MD5 | |
| password_query = SELECT username as user, password as password, \ | |
| homedir AS userdb_home, maildir AS userdb_mail, \ | |
| concat('*:bytes=', quota) as userdb_quota_rule, uid AS userdb_uid, gid AS userdb_gid \ | |
| FROM mailbox \ | |
| WHERE username = '%Lu' AND active = '1' \ | |
| AND ( access_restriction = 'ALL' OR LOCATE( '%Us', access_restriction ) > 0 ) | |
| user_query = SELECT homedir AS home, maildir AS mail, \ | |
| concat('*:bytes=', quota) as quota_rule, uid, gid \ | |
| FROM mailbox WHERE username = '%u' |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| !include_try /usr/share/dovecot/protocols.d/*.protocol | |
| !include conf.d/*.conf | |
| !include_try local.conf |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Sample Postfix configuration for use with ViMbAdmin :: Virtual Mailbox Administration | |
| # | |
| # See: https://github.com/opensolutions/ViMbAdmin | |
| # | |
| # By Barry O'Donovan - 2014-02 - http://www.barryodonovan.com/ | |
| # See /usr/share/postfix/main.cf.dist for a commented, more complete version | |
| smtpd_banner = $myhostname ESMTP $mail_name (Ubuntu) | |
| biff = no | |
| # appending .domain is the MUA's job. | |
| append_dot_mydomain = no | |
| # Uncomment the next line to generate "delayed mail" warnings | |
| delay_warning_time = 4h | |
| readme_directory = no | |
| # TLS parameters | |
| smtpd_tls_cert_file = /etc/postfix/ssl/mail.example.com.pem | |
| smtpd_tls_key_file = /etc/postfix/ssl/mail.example.com.pem | |
| smtpd_use_tls = yes | |
| smtpd_tls_session_cache_database = btree:/var/lib/postfix/smtpd_scache | |
| smtp_tls_session_cache_database = btree:/var/lib/postfix/smtp_scache | |
| smtpd_tls_loglevel = 1 | |
| smtpd_tls_auth_only = yes | |
| smtpd_tls_dh1024_param_file = /etc/postfix/dh_1024.pem | |
| smtpd_tls_dh512_param_file = /etc/postfix/dh_512.pem | |
| smtpd_tls_eecdh_grade = strong | |
| myhostname = mail.example.com | |
| myorigin = mail.example.com | |
| mydestination = localhost localhost.$mydomain | |
| mynetworks = 127.0.0.0/8 [::ffff:127.0.0.0]/104 [::1]/128 | |
| mailbox_size_limit = 0 | |
| recipient_delimiter = + | |
| inet_protocols = all | |
| inet_interfaces = all | |
| notify_classes = resource, software | |
| error_notice_recipient = [email protected] | |
| # relay_domains = | |
| # transport_maps = hash:/etc/postfix/transport | |
| virtual_alias_maps = mysql:/etc/postfix/mysql/virtual_alias_maps.cf | |
| virtual_gid_maps = static:2000 | |
| virtual_mailbox_base = /srv/vmail | |
| virtual_mailbox_domains = mysql:/etc/postfix/mysql/virtual_domains_maps.cf | |
| virtual_mailbox_maps = mysql:/etc/postfix/mysql/virtual_mailbox_maps.cf | |
| virtual_minimum_uid = 2000 | |
| virtual_uid_maps = static:2000 | |
| #dovecot_destination_recipient_limit = 1 | |
| virtual_transport = lmtp:unix:private/dovecot-lmtp | |
| smtpd_sasl_auth_enable = yes | |
| smtpd_sasl_type = dovecot | |
| smtpd_sasl_path = private/auth | |
| broken_sasl_auth_clients = yes | |
| message_size_limit = 40000000 | |
| home_mailbox = Maildir/ | |
| smtpd_sasl_authenticated_header = yes | |
| smtpd_sasl_security_options = noanonymous | |
| smtpd_sasl_local_domain = $myhostname | |
| #mailbox_command = /usr/lib/dovecot/deliver -c /etc/dovecot/dovecot.conf -m "${EXTENSION}" | |
| smtp_use_tls = yes | |
| smtpd_tls_received_header = yes | |
| smtpd_tls_mandatory_protocols = SSLv3, TLSv1 | |
| smtpd_tls_mandatory_ciphers = medium | |
| tls_random_source = dev:/dev/urandom | |
| smtpd_recipient_restrictions = | |
| reject_unknown_sender_domain, | |
| reject_unknown_recipient_domain, | |
| reject_unauth_pipelining, | |
| permit_mynetworks, | |
| permit_sasl_authenticated, | |
| reject_unauth_destination | |
| # reject_non_fqdn_hostname, | |
| # reject_invalid_hostname | |
| #smtpd_helo_restrictions = | |
| # check_helo_access hash:/etc/postfix/ehlo_whitelist, | |
| # reject_non_fqdn_hostname, | |
| # reject_invalid_hostname | |
| # check_helo_access hash:/etc/postfix/ehlo_whitelist, | |
| # reject_unknown_helo_hostname | |
| smtpd_helo_required = yes | |
| smtpd_sender_restrictions = | |
| reject_unknown_sender_domain | |
| # check_sender_access hash:/etc/postfix/sender_access, | |
| smtpd_data_restrictions = | |
| reject_unauth_pipelining | |
| smtpd_client_restrictions = | |
| permit_sasl_authenticated | |
| # check_client_access hash:/etc/postfix/client_access, | |
| # reject_rbl_client zen.spamhaus.org |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| user = vimbadmin | |
| password = password | |
| hosts = 127.0.0.1 | |
| dbname = vimbadmin | |
| query = SELECT goto FROM alias WHERE address = '%s' AND active = '1' |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| user = vimbadmin | |
| password = password | |
| hosts = 127.0.0.1 | |
| dbname = vimbadmin | |
| query = SELECT domain FROM domain WHERE domain = '%s' AND backupmx = '0' AND active = '1' |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| user = vimbadmin | |
| password = password | |
| hosts = 127.0.0.1 | |
| dbname = vimbadmin | |
| table = mailbox | |
| select_field = maildir | |
| where_field = username |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| user = vimbadmin | |
| password = password | |
| hosts = 127.0.0.1 | |
| dbname = vimbadmin | |
| table = domain | |
| select_field = transport | |
| where_field = domain | |
| additional_conditions = and backupmx = '0' and active = '1' |
I keep getting this error:
May 24 10:37:41 powersmtp postfix/virtual[1953]: 2DCCCC20B0: to=teste@xxxxxx, relay=virtual, delay=4424, delays=4423/0.01/0/0.02, dsn=4.2.0, status=deferred (delivery failed to mailbox /home/vmail/maildir:/home/vmail/DOMAIN/test/mail:LAYOUT=fs: unable to create lock file /home/vmail/maildir:/home/vmail/DOMAIN/test/mail:LAYOUT=fs.lock: No such file or directory)
Did anybody ever get ready of this error?
Thanks
LOCATE function doesn't exist in postgresql, so use this query for password query:
password_query = SELECT username as user, password as password, homedir AS userdb_home, maildir AS userdb_mail, concat('*:bytes=', quota) AS userdb_quota_rule, uid AS userdb_uid, gid AS userdb_gid FROM mailbox WHERE username = '%Lu' AND active = '1' AND ( access_restriction = 'ALL' OR POSITION( '%Us' IN access_restriction ) > 0 );
These settings are out of date, it would be nice if someone explained how to update config files of both Postfix and Dovecot in order to work with ViMbAdmin. I spent hours yesterday and failed (it actually works with the ViMbAdmin, but it stopped working with Roundcube and RainLoop and I have no idea how to set things up). These Gits were written for Ubuntu 13.10 (or so it says), and I'm using Ubuntu 20.04. Go figure.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Also, I think it would be helpful for some people to know that any
<something>_maps.cftype file can be formatted 3 different ways:Postfix 2.2 or newer
hosts = 127.0.0.1user = vimbadminpassword =<gobbledygook>dbname = vimbadminquery = SELECT<fieldname to return to Postfix as data>FROM<desired tablename>WHERE<fieldname that Postfix filters on>= '%s' AND<more SQL to filter tablename>Postfix 2.1 and older
hosts = 127.0.0.1user = vimbadminpassword =<gobbledygook>dbname = vimbadmintable =<desired tablename>select_field =<fieldname to return to Postfix as data>where_field =<fieldname that Postfix filters on>additional_conditions = AND<more SQL to filter tablename>Universal Postfix
hosts = 127.0.0.1user = vimbadminpassword =<gobbledygook>dbname = vimbadminquery = SELECT<fieldname to return to Postfix as data>FROM<desired tablename>WHERE<fieldname that Postfix filters on>= '%s' AND<more SQL to filter tablename>table =<desired tablename>select_field =<fieldname to return to Postfix as data>where_field =<fieldname that Postfix filters on>additional_conditions = AND<more SQL to filter tablename>Note: both
additional_conditions =as well as the extendedANDportion of theWHEREclause in thequery =variables are optional.Find dates for major.minor versions at Postfix version announcements but I think the changeover was near Bush 43 / Obama 44.
My source for file formatting is http://www.postfix.org/MYSQL_README.html see the Example: local aliases section
Also, also handy is the MYSQL PARAMETERS -> query subsection of the http://www.postfix.org/mysql_table.5.html page. It has parsing tips related to
'%s'like'%u'substrings off just the ID of an email address and'%d'just takes the domain after the @ symbol.