Solved error: unsupported dictionary type: mysql and conflict

m_pahlevanzadeh

m_pahlevanzadeh

I have mysql, postfix and mysql. After upgrade, I get the following error in maillog:
Code: 
root@mail:~ # tail -f /var/log/maillog
Nov  2 12:19:53 mail postfix/pickup[1193]: 7E8EB181AA: uid=80 from=<www>
Nov  2 12:19:53 mail postfix/cleanup[1196]: 7E8EB181AA: message-id=<SMOmR7Js2ZHgf0ftY8rvmiEkOqEVo6LUtQk0gXf6M@pahlevanzadeh.net>
Nov  2 12:19:53 mail postfix/cleanup[1196]: warning: mysql:/usr/local/etc/postfix/mysql-virtual-alias-maps.cf is unavailable. unsupported dictionary type: mysql
Nov  2 12:19:53 mail postfix/cleanup[1196]: warning: mysql:/usr/local/etc/postfix/mysql-virtual-alias-maps.cf lookup error for "mohsen@pahlevanzadeh.net"
Nov  2 12:19:53 mail postfix/cleanup[1196]: warning: 7E8EB181AA: virtual_alias_maps map lookup problem for mohsen@pahlevanzadeh.net -- message not accepted, try again later
Nov  2 12:19:53 mail postfix/pickup[1193]: 7EF29181AB: uid=80 from=<www>
Nov  2 12:19:53 mail postfix/cleanup[1267]: 7EF29181AB: message-id=<Usi0E2xRFyTEFrDToq9A17Q82eLnuWKITUtzBtHEi0@pahlevanzadeh.net>
Nov  2 12:19:53 mail postfix/cleanup[1267]: warning: mysql:/usr/local/etc/postfix/mysql-virtual-alias-maps.cf is unavailable. unsupported dictionary type: mysql
Nov  2 12:19:53 mail postfix/cleanup[1267]: warning: mysqil:/usr/local/etc/postfix/mysql-virtual-alias-maps.cf lookup error for "mohsen@pahlevanzadeh.net"
Nov  2 12:19:53 mail postfix/cleanup[1267]: warning: 7EF29181AB: virtual_alias_maps map lookup problem for mohsen@pahlevanzadeh.net -- message not accepted, try again later

When I want to install postfix-mysql package, I get the such as messages:
Code: 
root@mail:~ # pkg install postfix-mysql
Updating FreeBSD repository catalogue...
FreeBSD repository is up to date.
All repositories are up to date.
Checking integrity... done (3 conflicting)
  - mysql80-client-8.0.39 conflicts with mariadb114-client-11.4.3 on /usr/local/bin/my_print_defaults
  - mysql80-client-8.0.39 conflicts with mariadb114-server-11.4.3 on /usr/local/bin/perror
  - postfix-mysql-3.9.0_1,1 conflicts with postfix-3.9.0_1,1 on /usr/local/bin/mailq
Checking integrity... done (0 conflicting)
The following 6 package(s) will be affected (of 0 checked):

Installed packages to be REMOVED:
    mariadb114-client: 11.4.3
    mariadb114-server: 11.4.3
    postfix: 3.9.0_1,1

New packages to be INSTALLED:
    mysql80-client: 8.0.39
    postfix-mysql: 3.9.0_1,1

Installed packages to be REINSTALLED:
    pkg-1.21.3

Number of packages to be removed: 3
Number of packages to be installed: 2
Number of packages to be reinstalled: 1

The operation will free 231 MiB.

Proceed with this action? [y/N]: n

It wants to delete some packages that I need them?
Unfortunately they have conflicts.

How can I solve this?
 
Do you actually have a MariaDB database, not a MySQL database?

If so, I think you need to use ports to build your own postfix-mysql (mail/postfix@mysql i.e. mysql flavor of the postfix port), but using e.g. DEFAULT_VERSIONS+=mysql=11.4m in /etc/make.conf to build for MariaDB, not MySQL.
 
After rebuilding postfix with changing make.conf my
Code: 
postconf -m
became:
Code: 
root@mail:/usr/ports/mail/postfix # postconf -m
btree
cidr
environ
fail
hash
inline
internal
ldap
memcache
mysql
pcre
pipemap
proxy
randmap
regexp
socketmap
static
tcp
texthash
unionmap
unix

And I get the following messages in maillog :
Code: 
Nov  3 09:58:38 mail postfix/smtpd[10534]: connect from mail-pg1-f175.google.com[209.85.215.175]
Nov  3 09:58:39 mail dovecot[10437]: auth: Fatal: Support not compiled in for passdb driver 'sql'
Nov  3 09:58:39 mail dovecot[10435]: master: Error: service(auth): command startup failed, throttling for 2.000 secs
Nov  3 09:58:39 mail postfix/smtpd[10534]: fatal: no SASL authentication mechanisms
Nov  3 09:58:40 mail postfix/master[10531]: warning: process /usr/local/libexec/postfix/smtpd pid 10534 exit status 1
Nov  3 09:58:40 mail postfix/master[10531]: warning: /usr/local/libexec/postfix/smtpd: bad command startup -- throttling
 
You need to also compile the dovecot port so it supports "mysql" (i.e. MariaDB) as well. Not sure about the SASL authentication for postfix. Which options did you choose when compiling?

You might want to have a quick look at this guide and see if that gives you any ideas:

www.purplehat.org

FreeBSD Mail Server – Page 1 – Initial Setup

This initial system setup is basically a bootstrap of FreeBSD. I’d recommend using freebsd-update to get to the latest RELEASE version. This will cover bootstrapping pkgng to utilize the late…
www.purplehat.org
 
You must log in or register to reply here.
Back
Top