Postfix:Mailsql:Unsupported dictionary type

Message

rsmereka · Post by **rsmereka** » Wed Apr 13, 2005 5:48 pm

Greetings,

I am attempting to build a mail server according to the instructions in the 'Virtual Mailhosting System With Postfix Guide' at:

Code: Select all

http://www.gentoo.org/doc/en/virt-mail-howto.xml

I am at the end of section 10 trying to test the mail server and the client machines will not connect to the smtp server. Upon looking /var/log/messages, I get:

Code: Select all

Apr 13 12:46:29 nereid postfix/smtpd[18955]: inet_addr_local: configured 2 IPv4 addresses
Apr 13 12:46:29 nereid postfix/smtpd[18955]: warning: inet_addr_local[procnet_ifinet6]: Couldn't open /proc/net/if_inet6 for reading: No such file or directory
Apr 13 12:46:29 nereid postfix/smtpd[18955]: inet_addr_local: configured 0 IPv6 addresses
Apr 13 12:46:29 nereid postfix/smtpd[18955]: match_string: mynetworks ~? debug_peer_list
Apr 13 12:46:29 nereid postfix/smtpd[18955]: match_string: mynetworks ~? fast_flush_domains
Apr 13 12:46:29 nereid postfix/smtpd[18955]: match_string: mynetworks ~? mynetworks
Apr 13 12:46:29 nereid postfix/smtpd[18955]: match_string: relay_domains ~? debug_peer_list
Apr 13 12:46:29 nereid postfix/smtpd[18955]: match_string: relay_domains ~? fast_flush_domains
Apr 13 12:46:29 nereid postfix/smtpd[18955]: match_string: relay_domains ~? mynetworks
Apr 13 12:46:29 nereid postfix/smtpd[18955]: match_string: relay_domains ~? permit_mx_backup_networks
Apr 13 12:46:29 nereid postfix/smtpd[18955]: match_string: relay_domains ~? qmqpd_authorized_clients
Apr 13 12:46:29 nereid postfix/smtpd[18955]: match_string: relay_domains ~? relay_domains
Apr 13 12:46:29 nereid postfix/smtpd[18955]: match_string: permit_mx_backup_networks ~? debug_peer_list
Apr 13 12:46:29 nereid postfix/smtpd[18955]: match_string: permit_mx_backup_networks ~? fast_flush_domains
Apr 13 12:46:29 nereid postfix/smtpd[18955]: match_string: permit_mx_backup_networks ~? mynetworks
Apr 13 12:46:29 nereid postfix/smtpd[18955]: match_string: permit_mx_backup_networks ~? permit_mx_backup_networks
Apr 13 12:46:29 nereid postfix/smtpd[18955]: fatal: unsupported dictionary type: mysql
Apr 13 12:46:30 nereid postfix/master[1709]: warning: process /usr/lib/postfix/smtpd pid 18955 exit status 1
Apr 13 12:46:30 nereid postfix/master[1709]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling

My postfix main.cf file looks like this (comments removed to shorten file):

Code: Select all

queue_directory = /var/spool/postfix
command_directory = /usr/sbin
daemon_directory = /usr/lib/postfix
mail_owner = postfix
myhostname = nereid.smthome.com
mydomain = smthome.com
inet_interfaces = all
unknown_local_recipient_reject_code = 550
mynetworks = 192.168.0/24, 127.0.0.0/8
home_mailbox = .maildir/
local_destination_concurrency_limit = 2
default_destination_concurrency_limit = 10
debug_peer_level = 2
debugger_command =
	 PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin
	 xxgdb $daemon_directory/$process_name $process_id & sleep 5
sendmail_path = /usr/sbin/sendmail
newaliases_path = /usr/bin/newaliases
mailq_path = /usr/bin/mailq
setgid_group = postdrop
html_directory = no
manpage_directory = /usr/share/man
sample_directory = /etc/postfix
readme_directory = /usr/share/doc/postfix-2.1.5-r2/readme
default_destination_concurrency_limit = 2
alias_database = hash:/etc/mail/aliases
local_destination_concurrency_limit = 2
alias_maps = mysql:/etc/postfix/mysql-aliases.cf
relocated_maps = mysql:/etc/postfix/mysql-relocated.cf
home_mailbox = .maildir/
smtpd_sasl_auth_enable = yes
smtpd_sasl2_auth_enable = yes
smtpd_sasl_security_options = noanonymous
broken_sasl_auth_clients = yes
smtpd_sasl_local_domain =
smtpd_recipient_restrictions = permit_sasl_authenticated, permit_mynetworks, reject_unauth_destination
smtpd_use_tls = yes
smtpd_tls_auth_only = yes
smtpd_tls_key_file = /etc/postfix/newreq.pem
smtpd_tls_cert_file = /etc/postfix/newcert.pem
smtpd_tls_CAfile = /etc/postfix/cacert.pem
smtpd_tls_loglevel = 3
smtpd_tls_received_header = yes
smtpd_tls_session_cache_timeout = 3600s
tls_random_source = dev:/dev/urandom
local_transport =  local
local_recipient_maps = $alias_maps $virtual_mailbox_maps unix:passwd.byname
virtual_transport = virtual
virtual_mailbox_domains = virt-bar.com, $other-virtual-domain.com
virtual_minimum_uid = 1000
virtual_gid_maps = static:$vmail-gid
virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual-maps.cf
virtual_alias_maps = mysql:/etc/postfix/mysql-virtual.cf
virtual_uid_maps = static:$vmail-uid
virtual_mailbox_base = /

Here is the output of:

Code: Select all

emerge -pv postfix

Code: Select all

These are the packages that I would merge, in order:

Calculating dependencies  ..done!
[ebuild   R   ] mail-mta/postfix-2.1.5-r2  +ipv6 -ldap -mailwrapper -mbox +mysql* +pam -postgres +sasl (-selinux) +ssl -vda 0 kB 

Total size of downloads: 0 kB

All components were functioning prior to implementing mysql and using mysql to authicate instead of pam. Mysql is functioning properly along with phpmyadmin. My questions are:

1. What is postfix complaining about and how do I correct the problem?
2. In the emerge output, there is an asterisk beside mysql, what does this mean?
3. The main.cf line virtual_mailbox_domains has the entries virt-bar.com and $other-virtual-domain.com. This seems to be incorrect for my installation. What do I put here? Just one or more domain names(fqdn?).
4. In this configuration, the mysql table 'users' has the 'tinytext' field 'quota'. Is this for disk space quaota? What do I put there? Is there anything else required to implement quota's?

I have other questions but I guess they can wait until I really need an answer. Thanks to this forum for the great support they have provided:D
Any and all help is appreciated.
Rick

kaidon · Post by **kaidon** » Wed Apr 13, 2005 9:23 pm

Apr 13 12:46:29 nereid postfix/smtpd[18955]: warning: inet_addr_local[procnet_ifinet6]: Couldn't open /proc/net/if_inet6 for reading: No such file or directory

Postfix is built with IPv6 support but your kernel is not.

2. In the emerge output, there is an asterisk beside mysql, what does this mean?

It means that the mysql use flag is now set, but it wasn't at the time when postfix was built.
That explains where the "fatal: unsupported dictionary type: mysql" message comes from.
Postfix doesn't now anything about mysql. You'll have to rebuild it.

Assuming your setting up (virtual) email for the domains foo.com and bar.com, your virtual_mailbox_domains should look like:

Code: Select all

virtual_mailbox_domains = foo.com bar.com

In this configuration, the mysql table 'users' has the 'tinytext' field 'quota'. Is this for disk space quaota? What do I put there? Is there anything else required to implement quota's?

You'll have to enable the 'vda' use flag and rebuild postfix for quota support.
Than add something like the following to your main.cf

Code: Select all

# A maximum limit of a mailbox
virtual_mailbox_limit = 100000000
virtual_mailbox_limit = 0
virtual_mailbox_limit_maps = mysql:/etc/postfix/mysql/virtual_mailbox_limit_maps.cf
# Limits only INBOX part (usefull when you have IMAP users)
virtual_mailbox_limit_inbox = yes
# Override the message_size_limit setting
virtual_mailbox_limit_override = yes
# Follow Maildir++ specs
virtual_maildir_extended = yes
# Create the maildirsize file (Vital for Courier-IMAP)
virtual_create_maildirsize = yes
# Bounce rather than defer when over quota
virtual_overquota_bounce = yes

Where virtual_mailbox_limit_maps.cf looks something like:

Code: Select all

hosts = 127.0.0.1
user = dbUserName
password = secret
dbname = nameOfTheDB
table = nameOfTheTable
select_field = quota
where_field = email

You'll also have to replace the $vmail-uid/$vmail-gid in

Code: Select all

virtual_gid_maps = static:$vmail-gid
virtual_uid_maps = static:$vmail-uid

with the uid/gid of your vmail user.
e.g.

Code: Select all

virtual_gid_maps = static:1500
virtual_uid_maps = static:1500

hth
cheers
Steven

rsmereka · Post by **rsmereka** » Wed Apr 13, 2005 11:37 pm

A very clear explaination Steven.

I have one question. In main.cf, you suggested adding something like:

Code: Select all

virtual_mailbox_limit = 100000000 
virtual_mailbox_limit = 0

Are these defaults if the 'quota' field in the mysql table is empty? Why are there two, one set to about 100mb and the other to zero?

Thanks for the prompt reply.
Rick

kaidon · Post by **kaidon** » Thu Apr 14, 2005 9:14 am

Ups, sorry about that.

One of them should have been commented.

From 'man 8 virtual'

virtual_mailbox_limit (51200000)
The maximal size in bytes of an individual mailbox or maildir file,
or zero (no limit).

I believe it can be used to set the defaults, as you asumed.
But I'm not entirely sure if it's needed at all. virtual_mailbox_limit comes from the standard postfix installation, where as the other quota related fields come from the vda patch. You'll have to play arround with different settings.

Altough I've prepared/configured the virtual mailbox quota stuff, at the end we decided not to use it on our server.
So I can't tell you from pratical experience.

cheers
Steven

rsmereka · Post by **rsmereka** » Thu Apr 14, 2005 6:22 pm

Ok and Thanks again Steven,

Time to put your suggestions to good use.