I’ve a problem w/ postfix
problem:
# tail -f /var/log/mail.err
Aug 20 17:57:50 myserver postfix/smtpd[8243]: error: unsupported dictionary type: mysql
Aug 20 17:57:50 myserver postfix/smtpd[8243]: error: unsupported dictionary type: mysql
Aug 20 17:58:05 myserver postfix/smtpd[8244]: error: unsupported dictionary type: mysql
Aug 20 17:58:05 myserver postfix/smtpd[8244]: error: unsupported dictionary type: mysql
Aug 20 18:00:38 myserver postfix/smtpd[8277]: error: unsupported dictionary type: mysql
Aug 20 18:00:38 myserver postfix/smtpd[8277]: error: unsupported dictionary type: mysql
Aug 20 18:03:32 myserver postfix/smtpd[8320]: error: unsupported dictionary type: mysql
Aug 20 18:03:32 myserver postfix/smtpd[8320]: error: unsupported dictionary type: mysql
Aug 20 18:03:33 myserver postfix/trivial-rewrite[8322]: error: unsupported dictionary type: mysql
Aug 20 18:03:33 myserver postfix/trivial-rewrite[8322]: error: unsupported dictionary type: mysql
idea?
asked Aug 20, 2014 at 16:09
1
[SOLVED] This fixed the issue for me in Ubuntu 14.04:
sudo apt-get install postfix-mysql
answered Aug 20, 2014 at 16:10
flavio.trojaflavio.troja
7462 gold badges6 silver badges11 bronze badges
1
-
Check output of
postconf -m
. It will look like this:root@ds94:/usr/local/etc/postfix # postconf -m btree cidr environ fail hash internal memcache mysql pcre proxy regexp socketmap static tcp texthash unix
-
If in output of postconf there isn’t
mysql
string, it means that postfix is built without mysql support. To resolve it installpostfix-mysql
package.
masegaloeh
18.1k10 gold badges56 silver badges105 bronze badges
answered Sep 2, 2015 at 22:26
George GaálGeorge Gaál
4903 silver badges8 bronze badges
Check if installed: dpkg -s postfix-mysql
if not install sudo apt-get -y install postfix-mysql
Problem solved.
answered Mar 15, 2015 at 2:10
3
I encountered this error when /etc/postfix/dynamicmaps.cf
had write permissions for group. Apparently, postfix then ignores the contents.
answered Dec 22, 2022 at 16:36
I just was installing new mail server on Ubuntu 16.04, starting my installing and configuring postfix and mysql,:
apt install postfix postfix-mysql mysql-server mysql-client
After configuring postfix (3.1) and create db base for the mail, i tried to test if postfix can reach the db and retrieve all domains / users:
postmap -q mydomain.com mysql:/etc/postfix/mysql-virtual_domains.cf
I got the error:
postmap: fatal: unsupported dictionary type: mysql
Seems my server doesn’t support mysql for some reason!
# postconf -m
btree
cidr
environ
fail
hash
inline
internal
memcache
nis
pipemap
proxy
randmap
regexp
socketmap
static
tcp
texthash
unionmap
unix
/etc/postfix# cat dynamicmaps.cf
# dict-type so-name (pathname) dict-function mkmap-function
cdb postfix-cdb.so.1.0.1 dict_cdb_open mkmap_cdb_open
ldap postfix-ldap.so.1.0.1 dict_ldap_open
mysql postfix-mysql.so.1.0.1 dict_mysql_open
pcre postfix-pcre.so.1.0.1 dict_pcre_open
pgsql postfix-pgsql.so.1.0.1 dict_pgsql_open
sqlite postfix-sqlite.so.1.0.1 dict_sqlite_open
Any help please?
asked Apr 24, 2017 at 11:13
MohammedSimbaMohammedSimba
8488 gold badges20 silver badges38 bronze badges
After installing postfix-mysql
try restarting postfix:
postfix reload
answered Oct 10, 2017 at 17:34
Philip KirkbridePhilip Kirkbride
1,5093 gold badges30 silver badges50 bronze badges
After many hours spending time on this issue, I found and resolved it:
change mysql
line in file /etc/postfix/dynamicmaps.cf
to:
mysql /usr/lib/postfix/postfix-mysql.so.1.0.1 dict_mysql_open
and then reload postfix postfix reload
.
answered Apr 24, 2018 at 12:29
Thanks for your case, I realized that forgot to install postfix-mysql. After do,
apt install postfix-mysql
the line,
mysql /usr/lib/postfix/postfix-mysql.so.1.0.1 dict_mysql_open
was automatically added on /etc/postfix/dynamicmaps.cf, but AFAIK not in your case. Is strange.
answered Jul 16, 2020 at 21:05
Describe the bug, try to make it reproducible
After upgrading to commit ae51201 I received an error in the postfix container about mysql not loading (see below). I checked the container, and the mysql module was not loaded and the mysql.so file was missing from the lib folder. The postfix-mysql package was installed. Removing the package and re-installing it solved the problem.
System information and quick debugging
| crit | fatal: too many errors — program terminated
| err | error: unsupported dictionary type: mysql
| warning | warning: unsupported dictionary type: mysql (/usr/lib/postfix/postfix-mysql.so: No such file or directory)
- Attaching the container and running
postconf -m
doesn’t list mysql - /usr/lib/postfix doesn’t contain postfix-mysql.so
- postfix-mysql package was installed
- re-installing the postfix-mysql package fixed the problem
Further information (where applicable):
- Your OS (is Apparmor or SELinux active?) Alpine 3.10_alpha20190228
- Docker and Docker Compose versions Docker version 18.09.1-ce, docker-compose version 1.23.2, build 1110ad0
- Output of
git diff origin/master
, any other changes to the code? anonymized headers in postfix
But why would it be missing? The images are the same for all of us, as long as you don’t change them. :-/
Cannot find a reason for it.
…
Am 02.03.2019 um 00:48 schrieb miclnl ***@***.***>:
Describe the bug, try to make it reproducible
After upgrading to commit
ae51201
I received an error in the postfix container about mysql not loading (see below). I checked the container, and the mysql module was not loaded and the mysql.so file was missing from the lib folder. The postfix-mysql package was installed. Removing the package and re-installing it solved the problem.
System information and quick debugging
| crit | fatal: too many errors — program terminated
| err | error: unsupported dictionary type: mysql
| warning | warning: unsupported dictionary type: mysql (/usr/lib/postfix/postfix-mysql.so: No such file or directory)
Attaching the container and running postconf -m doesn’t list mysql
/usr/lib/postfix doesn’t contain postfix-mysql.so
postfix-mysql package was installed
re-installing the postfix-mysql package fixed the problem
Further information (where applicable):
Your OS (is Apparmor or SELinux active?) Alpine 3.10_alpha20190228
Docker and Docker Compose versions Docker version 18.09.1-ce, docker-compose version 1.23.2, build 1110ad0
Output of git diff origin/master, any other changes to the code? anonymized headers in postfix
—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub, or mute the thread.
Copy link
Contributor
Author
Hi Andre,
This is actually the 2nd time this has happened after an update recently. I didn’t mention that in the report, but that was the reason I am reporting it. The only other thing running on the OS is a backup script. I’ll check tomorrow if that’s doing anything weird.
I didn’t change the containers prior to solving the missing file, so I have no idea.
«André Peters» <notifications@github.com> schreef op 2 maart 2019 00:51:38 CET:
…
But why would it be missing? The images are the same for all of us, as
long as you don’t change them. :-/>
>
Cannot find a reason for it. >
>
> Am 02.03.2019 um 00:48 schrieb miclnl ***@***.***>:>
> >
> Describe the bug, try to make it reproducible>
> After upgrading to commit
ae51201
I received an error in the postfix
container about mysql not loading (see below). I checked the container,
and the mysql module was not loaded and the mysql.so file was missing
from the lib folder. The postfix-mysql package was installed. Removing
the package and re-installing it solved the problem.>
> >
> System information and quick debugging>
> | crit | fatal: too many errors — program terminated>
> | err | error: unsupported dictionary type: mysql>
> | warning | warning: unsupported dictionary type: mysql
(/usr/lib/postfix/postfix-mysql.so: No such file or directory)>
> >
> Attaching the container and running postconf -m doesn’t list mysql>
> /usr/lib/postfix doesn’t contain postfix-mysql.so>
> postfix-mysql package was installed>
> re-installing the postfix-mysql package fixed the problem>
> Further information (where applicable):>
> >
> Your OS (is Apparmor or SELinux active?) Alpine 3.10_alpha20190228>
> Docker and Docker Compose versions Docker version 18.09.1-ce,
docker-compose version 1.23.2, build 1110ad0>
> Output of git diff origin/master, any other changes to the code?
anonymized headers in postfix>
> —>
> You are receiving this because you are subscribed to this thread.>
> Reply to this email directly, view it on GitHub, or mute the thread.>
>
>
— >
You are receiving this because you authored the thread.>
Reply to this email directly or view it on GitHub:>
#2383 (comment)
Ok, I’m sure something changes the container/the image itself. We all use the same base, so I cannot imagine why this file would be deleted after an update. It is not missing in the postfix-mailcow image.
Copy link
Contributor
Author
My backup script doesn’t touch the postfix container either.
It happens after every update, but manually bringing down & up the containers with docker-compose also fixes the missing files. I have no idea where to look for a possible cause, but as it appears to be something with my personal host I’ll close the issue for now.
Содержание
- [Postfix] error: unsupported dictionary type: mysql #2383
- Comments
- Error unsupported dictionary type mysql
[Postfix] error: unsupported dictionary type: mysql #2383
Describe the bug, try to make it reproducible
After upgrading to commit ae51201 I received an error in the postfix container about mysql not loading (see below). I checked the container, and the mysql module was not loaded and the mysql.so file was missing from the lib folder. The postfix-mysql package was installed. Removing the package and re-installing it solved the problem.
System information and quick debugging
| crit | fatal: too many errors — program terminated
| err | error: unsupported dictionary type: mysql
| warning | warning: unsupported dictionary type: mysql (/usr/lib/postfix/postfix-mysql.so: No such file or directory)
- Attaching the container and running postconf -m doesn’t list mysql
- /usr/lib/postfix doesn’t contain postfix-mysql.so
- postfix-mysql package was installed
- re-installing the postfix-mysql package fixed the problem
Further information (where applicable):
- Your OS (is Apparmor or SELinux active?) Alpine 3.10_alpha20190228
- Docker and Docker Compose versions Docker version 18.09.1-ce, docker-compose version 1.23.2, build 1110ad0
- Output of git diff origin/master , any other changes to the code? anonymized headers in postfix
The text was updated successfully, but these errors were encountered:
Источник
Error unsupported dictionary type mysql
Postfix из портов собирается без MySQL
Конфигурю — ставлю соответствующую галку:
Makefile:
OPTIONS_DEFINE= BDB CDB DOCS INST_BASE LDAP LDAP_SASL LMDB MYSQL
NIS PCRE PGSQL SASL SQLITE TEST TLS
MYSQL_USE= MYSQL=yes
Компилится без ошибок
Проверяю, вроде в порядке:
Запускаю, в maillog ругается:
Nov 21 00:45:43 leg2 postfix/smtpd[30829]: warning: unsupported dictionary type: mysql (no/postfix-mysql.so: No such file or directory)
В чём косяк?
Спасибо.
З.Ы.
Компилю из исходников той жк версии скачаной с postfix.org — взлетает без проблем.
Ответить | Правка | Cообщить модератору
- Postfix из портов собирается без MySQL, Assoll, 01:04 , 21-Ноя-17, (1)
- Postfix из портов собирается без MySQL, Assoll, 01:11 , 21-Ноя-17, (2)
- Postfix из портов собирается без MySQL, PavelR, 06:24 , 21-Ноя-17, (3)
- Postfix из портов собирается без MySQL, Assoll, 08:33 , 21-Ноя-17, (4)
- Postfix из портов собирается без MySQL, Assoll, 08:37 , 21-Ноя-17, (5)
- Postfix из портов собирается без MySQL, PavelR, 14:42 , 21-Ноя-17, (6)
- Postfix из портов собирается без MySQL, Assoll, 16:00 , 21-Ноя-17, (7)
- Postfix из портов собирается без MySQL, Assoll, 19:50 , 21-Ноя-17, ( 8 )
- Postfix из портов собирается без MySQL, Assoll, 20:53 , 21-Ноя-17, ( 9 )
- Postfix из портов собирается без MySQL, lavr, 21:14 , 21-Ноя-17, ( 10 )
- Postfix из портов собирается без MySQL, Assoll, 22:03 , 21-Ноя-17, ( 11 )
- Postfix из портов собирается без MySQL, lavr, 00:02 , 22-Ноя-17, ( 12 )
- Postfix из портов собирается без MySQL, Assoll, 08:44 , 22-Ноя-17, ( 13 )
- Postfix из портов собирается без MySQL, Аноним, 13:50 , 22-Ноя-17, ( 14 )
- Postfix из портов собирается без MySQL, lavr, 14:39 , 22-Ноя-17, ( 15 )
- Postfix из портов собирается без MySQL, Assoll, 15:36 , 23-Ноя-17, ( 16 )
- Postfix из портов собирается без MySQL, ALex_hha, 17:14 , 23-Ноя-17, ( 17 )
- Postfix из портов собирается без MySQL, Аноним, 13:50 , 22-Ноя-17, ( 14 )
- Postfix из портов собирается без MySQL, Assoll, 08:44 , 22-Ноя-17, ( 13 )
- Postfix из портов собирается без MySQL, lavr, 00:02 , 22-Ноя-17, ( 12 )
- Postfix из портов собирается без MySQL, Assoll, 22:03 , 21-Ноя-17, ( 11 )
- Postfix из портов собирается без MySQL, lavr, 21:14 , 21-Ноя-17, ( 10 )
- Postfix из портов собирается без MySQL, Assoll, 20:53 , 21-Ноя-17, ( 9 )
- Postfix из портов собирается без MySQL, Assoll, 19:50 , 21-Ноя-17, ( 8 )
- Postfix из портов собирается без MySQL, Assoll, 16:00 , 21-Ноя-17, (7)
- Postfix из портов собирается без MySQL, Assoll, 08:33 , 21-Ноя-17, (4)
Сообщения по теме | [Сортировка по времени | RSS] |
# ll /usr/lib/postfix/
total 720
-rwxr-xr-x 1 root wheel 28928 Nov 21 00:28 libpostfix-dns.so*
-rwxr-xr-x 1 root wheel 273424 Nov 21 00:28 libpostfix-global.so*
-rwxr-xr-x 1 root wheel 37672 Nov 21 00:28 libpostfix-master.so*
-rwxr-xr-x 1 root wheel 98176 Nov 21 00:28 libpostfix-tls.so*
-rwxr-xr-x 1 root wheel 254504 Nov 21 00:28 libpostfix-util.so*
-rwxr-xr-x 1 root wheel 16096 Nov 21 00:28 postfix-mysql.so* —ВОТ ОНА ЛЕЖИТ
-rwxr-xr-x 1 root wheel 15304 Nov 21 00:28 postfix-pcre.so*
1. «Postfix из портов собирается без MySQL» | + / – | |
Сообщение от Assoll on 21-Ноя-17, 01:04 | ||
Ответить | Правка | ^ к родителю #0 | Наверх | Cообщить модератору |
2. «Postfix из портов собирается без MySQL» | + / – | |
Сообщение от Assoll on 21-Ноя-17, 01:11 | ||
|
||
Ответить | Правка | ^ к родителю #1 | Наверх | Cообщить модератору |
3. «Postfix из портов собирается без MySQL» | + / – | |
Сообщение от PavelR (??) on 21-Ноя-17, 06:24 | ||
1) no-no-no. |
||
Ответить | Правка | ^ к родителю #0 | Наверх | Cообщить модератору |
4. «Postfix из портов собирается без MySQL» | + / – | |
Сообщение от Assoll on 21-Ноя-17, 08:33 | ||
1. При компиляции из исходников с postfix.org файла «postfix-mysql.so» вообще нет |
||
Ответить | Правка | ^ к родителю #3 | Наверх | Cообщить модератору |
5. «Postfix из портов собирается без MySQL» | + / – | |
Сообщение от Assoll on 21-Ноя-17, 08:37 | ||
|
||
Ответить | Правка | ^ к родителю #4 | Наверх | Cообщить модератору |
6. «Postfix из портов собирается без MySQL» | + / – | |
Сообщение от PavelR (??) on 21-Ноя-17, 14:42 | ||
ладно, еще раз пройдемся по пункту 1 в каком месте возникло *no*/postfix-mysql.so ? |
||
Ответить | Правка | ^ к родителю #4 | Наверх | Cообщить модератору |
7. «Postfix из портов собирается без MySQL» | + / – | |
Сообщение от Assoll on 21-Ноя-17, 16:00 | ||
В данный момент файла dynamicmaps.cf нету, но postfix (из исходников) пашет, как заведённый |
||
Ответить | Правка | ^ к родителю #6 | Наверх | Cообщить модератору |
8 . «Postfix из портов собирается без MySQL» | + / – | |
Сообщение от Assoll on 21-Ноя-17, 19:50 | ||
Снова скомпилился из портов и при старте та же ошибка: По-прежнему: # cat /etc/postfix/dynamicmaps.cf # ll /usr/lib/postfix/ А вот здесь почему-то нету: # ldd /usr/lib/postfix/postfix-mysql.so # ll /usr/local/lib/mysql/libmysqlclient.so.18 Такое ощущение, что игнорируется /etc/postfix/dynamicmaps.cf |
||
Ответить | Правка | ^ к родителю #7 | Наверх | Cообщить модератору |
9 . «Postfix из портов собирается без MySQL» | + / – | |
Сообщение от Assoll on 21-Ноя-17, 20:53 | ||
Ляха-муха! Исправляем на: Вот запрятали-то.. И вдобавок полный путь не прописали.. |
||
Ответить | Правка | ^ к родителю #8 | Наверх | Cообщить модератору |
10 . «Postfix из портов собирается без MySQL» | + / – |
Сообщение от lavr (ok) on 21-Ноя-17, 21:14 | |
вот кто-то не понимает что оставил ошметки от ручной сборки да нет, не закрыт. Вы такими телодвижениями систему изуродуете, уже изуродовали: Вот это и будет свистопляска, а верхнее, так семечки от нежеления |
|
Ответить | Правка | ^ к родителю #9 | Наверх | Cообщить модератору |
11 . «Postfix из портов собирается без MySQL» | + / – | |
Сообщение от Assoll on 21-Ноя-17, 22:03 | ||
Нет, Вы не правы. Вообще я компилил с опцией: |
||
Ответить | Правка | ^ к родителю #10 | Наверх | Cообщить модератору |
12 . «Postfix из портов собирается без MySQL» | + / – |
Сообщение от lavr (ok) on 22-Ноя-17, 00:02 | |
почему странные, именно то что Вы задали, это ж не было озвучено ранее, |
|
Ответить | Правка | ^ к родителю #11 | Наверх | Cообщить модератору |
13 . «Postfix из портов собирается без MySQL» | + / – | |
Сообщение от Assoll on 22-Ноя-17, 08:44 | ||
Postfix считаю заменой sendmail (который часть системы) и поэтому в /usr/ |
||
Ответить | Правка | ^ к родителю #12 | Наверх | Cообщить модератору |
14 . «Postfix из портов собирается без MySQL» | + / – | |
Сообщение от Аноним (??) on 22-Ноя-17, 13:50 | ||
да что это такое? да в конце-то концов, да с конца на конец! не важно что там вы себе считаете и какие у вас там замены |
||
Ответить | Правка | ^ к родителю #13 | Наверх | Cообщить модератору |
15 . «Postfix из портов собирается без MySQL» | + / – |
Сообщение от lavr (ok) on 22-Ноя-17, 14:39 | |
да можно и в /usr, одно НО — помнить про это и про возможные |
|
Ответить | Правка | ^ к родителю #14 | Наверх | Cообщить модератору |
16 . «Postfix из портов собирается без MySQL» | + / – | |
Сообщение от Assoll on 23-Ноя-17, 15:36 | ||
Пусть начнёт с себя мейнтейнер постфикса. Ибо, куда ни ставь его в /usr, в /usr/local ли, за aliases оно лезет в /etc/mail по дефолту. |
||
Ответить | Правка | ^ к родителю #14 | Наверх | Cообщить модератору |
17 . «Postfix из портов собирается без MySQL» | + / – |
Сообщение от ALex_hha (ok) on 23-Ноя-17, 17:14 | |
На то он и дефолт. Вам религия запрещает указать свой путь в alias_database/alias_maps? Источник Читайте также: Как запустить прошивку на ps3 Adblock |
- Forum
- The Ubuntu Forum Community
- Ubuntu Specialised Support
- Ubuntu Servers, Cloud and Juju
- Server Platforms
- Postfix: Unsupported dictionary type: mysql on ubuntu 16.04
-
Postfix: Unsupported dictionary type: mysql on ubuntu 16.04
Hi! After upgrade to ubuntu 15.10 to 16.04 in mail.err — postfix/proxymap[35158]: error: unsupported dictionary type: mysql
postconf -m | grep mysql
mysql exist
reinstall postfix-mysql and postfix not workpostconf -n
Code:
alias_database = hash:/etc/postfix/aliases alias_maps = hash:/etc/postfix/aliases allow_min_user = no allow_percent_hack = no biff = no body_checks = pcre:/etc/postfix/body_checks.pcre broken_sasl_auth_clients = yes command_directory = /usr/sbin content_filter = smtp-amavis:[127.0.0.1]:10024 daemon_directory = /usr/lib/postfix/sbin data_directory = /var/lib/postfix debug_peer_level = 2 debugger_command = PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin ddd $daemon_directory/$process_name $process_id & sleep 5 disable_vrfy_command = yes dovecot_destination_recipient_limit = 1 enable_original_recipient = no header_checks = pcre:/etc/postfix/header_checks home_mailbox = Maildir/ inet_interfaces = all inet_protocols = all lmtp_tls_mandatory_protocols = !SSLv2 !SSLv3 lmtp_tls_protocols = !SSLv2 !SSLv3 mail_owner = postfix mailbox_command = /usr/lib/dovecot/deliver mailq_path = /usr/bin/mailq message_size_limit = 15728640 mydestination = $myhostname, localhost, x-fil.es, localhost.localdomain mydomain =domain.com myhostname = domain.com mynetworks = 127.0.0.1, 192.168.1.0/24 myorigin = $mydomain newaliases_path = /usr/bin/newaliases postscreen_access_list = permit_mynetworks, cidr:/etc/postfix/postscreen_access.cidr postscreen_blacklist_action = enforce postscreen_dnsbl_action = enforce postscreen_dnsbl_reply_map = texthash:/etc/postfix/postscreen_dnsbl_reply postscreen_dnsbl_sites = zen.spamhaus.org*3 b.barracudacentral.org*2 bl.spameatingmonkey.net*2 bl.spamcop.net dnsbl.s orbs.net psbl.surriel.com bl.mailspike.net swl.spamhaus.org*-4 list.dnswl.org=127.[0..255].[0..255].0*-2 list.dnswl.o rg=127.[0..255].[0..255].1*-3 list.dnswl.org=127.[0..255].[0..255].[2..255]*-4 postscreen_dnsbl_threshold = 2 postscreen_dnsbl_whitelist_threshold = -2 postscreen_greet_action = enforce proxy_read_maps = $canonical_maps $lmtp_generic_maps $local_recipient_maps $mydestination $mynetworks $recipient_bcc_ maps $recipient_canonical_maps $relay_domains $relay_recipient_maps $relocated_maps $sender_bcc_maps $sender_canonica l_maps $smtp_generic_maps $smtpd_sender_login_maps $transport_maps $virtual_alias_domains $virtual_alias_maps $virtua l_mailbox_domains $virtual_mailbox_maps $smtpd_sender_restrictions queue_directory = /var/spool/postfix recipient_bcc_maps = proxy:mysql:/etc/postfix/mysql/recipient_bcc_maps_user.cf proxy:mysql:/etc/postfix/mysql/recipie nt_bcc_maps_domain.cf recipient_delimiter = + relay_domains = $mydestination proxy:mysql:/etc/postfix/mysql/relay_domains.cf relayhost = relay.lipetsk.ru:25 sender_bcc_maps = proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf proxy:mysql:/etc/postfix/mysql/sender_bcc_ma ps_domain.cf sendmail_path = /usr/sbin/sendmail setgid_group = postdrop shlib_directory = /usr/lib/postfix/lib smtp-amavis_destination_recipient_limit = 1 smtp_tls_CAfile = $smtpd_tls_CAfile smtp_tls_loglevel = 0 smtp_tls_mandatory_protocols = !SSLv2 !SSLv3 smtp_tls_note_starttls_offer = yes smtp_tls_protocols = !SSLv2 !SSLv3 smtp_tls_security_level = may smtpd_data_restrictions = reject_unauth_pipelining smtpd_end_of_data_restrictions = check_policy_service inet:127.0.0.1:7777 smtpd_helo_required = yes smtpd_helo_restrictions = permit_mynetworks permit_sasl_authenticated reject_non_fqdn_helo_hostname reject_invalid_he lo_hostname check_helo_access pcre:/etc/postfix/helo_access.pcre smtpd_recipient_restrictions = reject_unknown_recipient_domain reject_non_fqdn_recipient reject_unlisted_recipient ch eck_policy_service inet:127.0.0.1:7777 permit_mynetworks permit_sasl_authenticated reject_unauth_destination smtpd_reject_unlisted_recipient = yes smtpd_reject_unlisted_sender = yes smtpd_sasl_auth_enable = yes smtpd_sasl_local_domain = smtpd_sasl_path = private/dovecot-auth smtpd_sasl_security_options = noanonymous smtpd_sasl_type = dovecot smtpd_sender_login_maps = proxy:mysql:/etc/postfix/mysql/sender_login_maps.cf smtpd_sender_restrictions = reject_unknown_sender_domain reject_non_fqdn_sender reject_unlisted_sender permit_mynetwo rks reject_sender_login_mismatch permit_sasl_authenticated check_sender_access pcre:/etc/postfix/sender_access.pcre smtpd_tls_CAfile = /etc/ssl/certs/iRedMail.crt smtpd_tls_auth_only = yes smtpd_tls_cert_file = /etc/ssl/certs/iRedMail.crt smtpd_tls_dh1024_param_file = /etc/ssl/dhparams.pem smtpd_tls_exclude_ciphers = aNULL, eNULL, EXPORT, DES, RC4, MD5, PSK, aECDH, EDH-DSS-DES-CBC3-SHA, EDH-RSA-DES-CDC3-S HA, KRB5-DE5, CBC3-SHA smtpd_tls_key_file = /etc/ssl/private/iRedMail.key smtpd_tls_loglevel = 0 smtpd_tls_mandatory_protocols = !SSLv2 !SSLv3 smtpd_tls_protocols = !SSLv2 !SSLv3 smtpd_tls_security_level = may swap_bangpath = no tls_random_source = dev:/dev/urandom transport_maps = proxy:mysql:/etc/postfix/mysql/transport_maps_user.cf proxy:mysql:/etc/postfix/mysql/transport_maps_ domain.cf unknown_local_recipient_reject_code = 550 virtual_alias_domains = virtual_alias_maps = proxy:mysql:/etc/postfix/mysql/virtual_alias_maps.cf proxy:mysql:/etc/postfix/mysql/domain_alias _maps.cf proxy:mysql:/etc/postfix/mysql/catchall_maps.cf proxy:mysql:/etc/postfix/mysql/domain_alias_catchall_maps.cf virtual_gid_maps = static:2000 virtual_mailbox_base = /var/vmail virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql/virtual_mailbox_domains.cf virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql/virtual_mailbox_maps.cf virtual_minimum_uid = 2000 virtual_transport = dovecot virtual_uid_maps = static:2000
dpkg -l | grep -i mysql
Code:
ii dbconfig-mysql 2.0.4ubuntu1 all dbconfig-common MySQL/MariaDB support ii dovecot-mysql 1:2.2.22-1ubuntu2 amd64 secure POP3/IMAP server - MySQL support ii libdbd-mysql-perl 4.033-1build2 amd64 Perl5 database interface to the MySQL database ii libmysqlclient18:amd64 5.6.30-0ubuntu0.15.10.1 amd64 MySQL database client library ii libmysqlclient20:amd64 5.7.11-0ubuntu6 amd64 MySQL database client library ii mysql-apt-config 0.7.2-1 all Auto configuration for MySQL APT Repo. ii mysql-client 5.7.12-1ubuntu15.10 amd64 MySQL Client meta package depending on latest version ii mysql-common 5.7.12-1ubuntu15.10 amd64 MySQL configuration for client and server ii mysql-community-client 5.7.12-1ubuntu15.10 amd64 MySQL Client and client tools ii mysql-community-server 5.7.12-1ubuntu15.10 amd64 MySQL Server and server tools ii mysql-server 5.7.12-1ubuntu15.10 amd64 MySQL Server meta package depending on latest version ii mysqltuner 1.6.0-1 all high-performance MySQL tuning script ii mytop 1.9.1-2 all top like query monitor for MySQL ii php-mysql 1:7.0+35ubuntu6 all MySQL module for PHP [default] rc php5-mysql 5.6.20+dfsg-1+deb.sury.org~wily+1 amd64 MySQL module for php5 rc php5-mysqlnd 5.6.20+dfsg-1+deb.sury.org~wily+1 amd64 MySQL module for php5 (Native Driver) ii php7.0-mysql 7.0.4-7ubuntu2 amd64 MySQL module for PHP ii phpmyadmin 4:4.5.4.1-2ubuntu1 all MySQL web administration tool ii postfix-mysql 3.1.0-3 amd64 MySQL map support for Postfix ii python-mysql.connector 2.0.4-1 all pure Python implementation of MySQL Client/Server protocol ii python-mysqldb 1.3.7-1build2 amd64 Python interface to MySQL ii python-pymysql 0.7.2-1 all Pure-Python MySQL driver - Python 2.x
-
Re: Postfix: Unsupported dictionary type: mysql on ubuntu 16.04
Seems to be an error in the package. You need to symlink postfix-mysql.so.1.0.1 to dict_mysql.so:
Code:
cd /usr/lib/postfix ln -s postfix-mysql.so.1.0.1 dict_mysql.so
-
Re: Postfix: Unsupported dictionary type: mysql on ubuntu 16.04
I’m having a similar problem on 16.04. The mysql dictionary type is supported, but with alias_maps = mysql:/etc/postfix/aliases.cf postfix consistently generates a Temporary lookup failure for every email address, alias or not. When I do a postmap -q alias mysql:/etc/postfix/aliases.cf aliases are expanded properly.
-
Re: Postfix: Unsupported dictionary type: mysql on ubuntu 16.04
My problem turned out to be postfix being unable to connect to the unix socket for mysql no matter what permissions were used, but when I connect to 127.0.0.1:3306 everything works.
-
Re: Postfix: Unsupported dictionary type: mysql on ubuntu 16.04
Thanks for this thread. I had the same problem and followed your solution of creating the link to solve it. I also opened a bug here: https://bugs.launchpad.net/ubuntu/+s…x/+bug/1628258
It turns out this bug is caused by not updating the config files along with the postfix package, in particular my /etc/postfix/dynamicmaps.cf file. The proper fix for this would be:
cp /usr/share/postfix/dynamicmaps.cf /etc/postfix/
That brings in the proper dynamicmaps.cf file and solves the issues without creating a symlink that may break during updates. Hope this helps
Bookmarks
Bookmarks
Posting Permissions
После обновления с ubuntu 15.10 до 16.04 перестал работать postfix
postfix/proxymap[35158]: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf is unavailable. unsupported dictionary type: mysql
postfix/cleanup[35159]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for «user@domain.com»
postfix/cleanup[35159]: warning: D79B580DBC: sender_bcc_maps map lookup problem — message not accepted, try again later
в mail.err
postfix/cleanup[35159]: error: unsupported dictionary type: pcre postfix/proxymap[35158]: error: unsupported dictionary type: mysql
postconf -m
pcre и mysql есть.
Переустановка postfix-mysql и postfix не помогают.
postconf -n
alias_database = hash:/etc/postfix/aliases
alias_maps = hash:/etc/postfix/aliases
allow_min_user = no
allow_percent_hack = no
biff = no
body_checks = pcre:/etc/postfix/body_checks.pcre
broken_sasl_auth_clients = yes
command_directory = /usr/sbin
content_filter = smtp-amavis:[127.0.0.1]:10024
daemon_directory = /usr/lib/postfix/sbin
data_directory = /var/lib/postfix
debug_peer_level = 2
debugger_command = PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin ddd $daemon_directory/$process_name $process_id & sleep 5
disable_vrfy_command = yes
dovecot_destination_recipient_limit = 1
enable_original_recipient = no
header_checks = pcre:/etc/postfix/header_checks
home_mailbox = Maildir/
inet_interfaces = all
inet_protocols = all
lmtp_tls_mandatory_protocols = !SSLv2 !SSLv3
lmtp_tls_protocols = !SSLv2 !SSLv3
mail_owner = postfix
mailbox_command = /usr/lib/dovecot/deliver
mailq_path = /usr/bin/mailq
message_size_limit = 15728640
mydestination = $myhostname, localhost, x-fil.es, localhost.localdomain
mydomain =domain.com
myhostname = domain.com
mynetworks = 127.0.0.1, 192.168.1.0/24
myorigin = $mydomain
newaliases_path = /usr/bin/newaliases
postscreen_access_list = permit_mynetworks, cidr:/etc/postfix/postscreen_access.cidr
postscreen_blacklist_action = enforce
postscreen_dnsbl_action = enforce
postscreen_dnsbl_reply_map = texthash:/etc/postfix/postscreen_dnsbl_reply
postscreen_dnsbl_sites = zen.spamhaus.org*3 b.barracudacentral.org*2 bl.spameatingmonkey.net*2 bl.spamcop.net dnsbl.s orbs.net psbl.surriel.com bl.mailspike.net swl.spamhaus.org*-4 list.dnswl.org=127.[0..255].[0..255].0*-2 list.dnswl.o rg=127.[0..255].[0..255].1*-3 list.dnswl.org=127.[0..255].[0..255].[2..255]*-4
postscreen_dnsbl_threshold = 2
postscreen_dnsbl_whitelist_threshold = -2
postscreen_greet_action = enforce
proxy_read_maps = $canonical_maps $lmtp_generic_maps $local_recipient_maps $mydestination $mynetworks $recipient_bcc_ maps $recipient_canonical_maps $relay_domains $relay_recipient_maps $relocated_maps $sender_bcc_maps $sender_canonica l_maps $smtp_generic_maps $smtpd_sender_login_maps $transport_maps $virtual_alias_domains $virtual_alias_maps $virtua l_mailbox_domains $virtual_mailbox_maps $smtpd_sender_restrictions
queue_directory = /var/spool/postfix
recipient_bcc_maps = proxy:mysql:/etc/postfix/mysql/recipient_bcc_maps_user.cf proxy:mysql:/etc/postfix/mysql/recipie nt_bcc_maps_domain.cf
recipient_delimiter = +
relay_domains = $mydestination proxy:mysql:/etc/postfix/mysql/relay_domains.cf
relayhost = relay.lipetsk.ru:25
sender_bcc_maps = proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf proxy:mysql:/etc/postfix/mysql/sender_bcc_ma ps_domain.cf
sendmail_path = /usr/sbin/sendmail
setgid_group = postdrop
shlib_directory = /usr/lib/postfix/lib
smtp-amavis_destination_recipient_limit = 1
smtp_tls_CAfile = $smtpd_tls_CAfile
smtp_tls_loglevel = 0
smtp_tls_mandatory_protocols = !SSLv2 !SSLv3
smtp_tls_note_starttls_offer = yes
smtp_tls_protocols = !SSLv2 !SSLv3
smtp_tls_security_level = may
smtpd_data_restrictions = reject_unauth_pipelining
smtpd_end_of_data_restrictions = check_policy_service inet:127.0.0.1:7777
smtpd_helo_required = yes
smtpd_helo_restrictions = permit_mynetworks permit_sasl_authenticated reject_non_fqdn_helo_hostname reject_invalid_he lo_hostname check_helo_access pcre:/etc/postfix/helo_access.pcre
smtpd_recipient_restrictions = reject_unknown_recipient_domain reject_non_fqdn_recipient reject_unlisted_recipient ch eck_policy_service inet:127.0.0.1:7777 permit_mynetworks permit_sasl_authenticated reject_unauth_destination
smtpd_reject_unlisted_recipient = yes
smtpd_reject_unlisted_sender = yes
smtpd_sasl_auth_enable = yes
smtpd_sasl_local_domain =
smtpd_sasl_path = private/dovecot-auth
smtpd_sasl_security_options = noanonymous
smtpd_sasl_type = dovecot
smtpd_sender_login_maps = proxy:mysql:/etc/postfix/mysql/sender_login_maps.cf
smtpd_sender_restrictions = reject_unknown_sender_domain reject_non_fqdn_sender reject_unlisted_sender permit_mynetwo rks reject_sender_login_mismatch permit_sasl_authenticated check_sender_access pcre:/etc/postfix/sender_access.pcre
smtpd_tls_CAfile = /etc/ssl/certs/iRedMail.crt
smtpd_tls_auth_only = yes
smtpd_tls_cert_file = /etc/ssl/certs/iRedMail.crt
smtpd_tls_dh1024_param_file = /etc/ssl/dhparams.pem
smtpd_tls_exclude_ciphers = aNULL, eNULL, EXPORT, DES, RC4, MD5, PSK, aECDH, EDH-DSS-DES-CBC3-SHA, EDH-RSA-DES-CDC3-S HA, KRB5-DE5, CBC3-SHA
smtpd_tls_key_file = /etc/ssl/private/iRedMail.key
smtpd_tls_loglevel = 0
smtpd_tls_mandatory_protocols = !SSLv2 !SSLv3
smtpd_tls_protocols = !SSLv2 !SSLv3
smtpd_tls_security_level = may
swap_bangpath = no
tls_random_source = dev:/dev/urandom
transport_maps = proxy:mysql:/etc/postfix/mysql/transport_maps_user.cf proxy:mysql:/etc/postfix/mysql/transport_maps_ domain.cf
unknown_local_recipient_reject_code = 550
virtual_alias_domains =
virtual_alias_maps = proxy:mysql:/etc/postfix/mysql/virtual_alias_maps.cf proxy:mysql:/etc/postfix/mysql/domain_alias _maps.cf proxy:mysql:/etc/postfix/mysql/catchall_maps.cf proxy:mysql:/etc/postfix/mysql/domain_alias_catchall_maps.cf
virtual_gid_maps = static:2000
virtual_mailbox_base = /var/vmail
virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql/virtual_mailbox_domains.cf
virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql/virtual_mailbox_maps.cf
virtual_minimum_uid = 2000
virtual_transport = dovecot
virtual_uid_maps = static:2000