postfix/cleanup[3573]: fatal: unsupported dictionary type: mysql
 

Hello all.....
I have some problem in postfix.
Can any one help me.. Its very urgent.
I am using postfixadmin also..
Is Courier imap necessary for postfixadmin?
Any books/documentation/links that shows the complete and helpful configuration of postfixadmin?

The error showing in /var/log/maillog
postfix/cleanup[3573]: fatal: unsupported dictionary type: mysql
postfix/master[2396]: warning: process /usr/libexec/postfix/cleanup pid 3605 exit status 1
warning: /usr/libexec/postfix/cleanup: bad command startup -- throttling

postconf -n

alias_database = hash:/etc/postfix/aliases
alias_maps = hash:/etc/postfix/aliases
command_directory = /usr/sbin
config_directory = /etc/postfix
daemon_directory = /usr/libexec/postfix
debug_peer_level = 2
header_checks = regexp:/etc/postfix/header_checks
home_mailbox = Mailbox
html_directory = no
inet_interfaces = all
mail_owner = postfix
mail_spool_directory = /var/spool/mail
mailq_path = /usr/bin/mailq.postfix
manpage_directory = /usr/share/man
mydestination = $myhostname, localhost.$mydomain, localhost, $mydomain
mydomain = <my domain name>
myhostname = <my hostname>
mynetworks = 192.168.0.0/24, 127.0.0.0/8
myorigin = $myhostname
newaliases_path = /usr/bin/newaliases.postfix
queue_directory = /var/spool/postfix
sample_directory = /usr/share/doc/postfix-2.4.5/samples
sendmail_path = /usr/sbin/sendmail.postfix
setgid_group = postdrop
unknown_local_recipient_reject_code = 550
virtual_alias_maps = mysql:/etc/postfix/mysql_virtual_alias_maps.cf
virtual_gid_maps = static:54321
virtual_mailbox_base = /var/spool/postfix/virtual
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 = 12345
virtual_transport = virtual
virtual_uid_maps = static:12345

DataBase

#
# Postfix Admin 2.1.0
# Date: Mon Aug 25 0:04:12 IST 2008
#
CREATE TABLE `admin` (
`username` varchar(255) NOT NULL default '',
`password` varchar(255) NOT NULL default '',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`active` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`username`),
KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Virtual Admins'

CREATE TABLE `alias` (
`address` varchar(255) NOT NULL default '',
`goto` text NOT NULL,
`domain` varchar(255) NOT NULL default '',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`active` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`address`),
KEY `address` (`address`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Virtual Aliases'

CREATE TABLE `domain` (
`domain` varchar(255) NOT NULL default '',
`description` varchar(255) NOT NULL default '',
`aliases` int(10) NOT NULL default '0',
`mailboxes` int(10) NOT NULL default '0',
`maxquota` int(10) NOT NULL default '0',
`transport` varchar(255) default NULL,
`backupmx` tinyint(1) NOT NULL default '0',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`active` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`domain`),
KEY `domain` (`domain`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Virtual Domains'

CREATE TABLE `domain_admins` (
`username` varchar(255) NOT NULL default '',
`domain` varchar(255) NOT NULL default '',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`active` tinyint(1) NOT NULL default '1',
KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Domain Admins'

CREATE TABLE `log` (
`timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`username` varchar(255) NOT NULL default '',
`domain` varchar(255) NOT NULL default '',
`action` varchar(255) NOT NULL default '',
`data` varchar(255) NOT NULL default '',
KEY `timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Log'

CREATE TABLE `mailbox` (
`username` varchar(255) NOT NULL default '',
`password` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`maildir` varchar(255) NOT NULL default '',
`quota` int(10) NOT NULL default '0',
`domain` varchar(255) NOT NULL default '',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`active` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`username`),
KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Virtual Mailboxes'

CREATE TABLE `vacation` (
`email` varchar(255) NOT NULL default '',
`subject` varchar(255) NOT NULL default '',
`body` text NOT NULL,
`cache` text NOT NULL,
`domain` varchar(255) NOT NULL default '',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`active` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`email`),
KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Virtual Vacation'

INSERT INTO admin (username,password,created,modified,active) VALUES ('posfix@<my domain>','password','2008-08-21 17:23:14','2008-08-21 19:28:04','1')
INSERT INTO admin (username,password,created,modified,active) VALUES ('sam@<mydomain>','password','2008-08-21 17:25:04','2008-08-21 17:25:04','1')
INSERT INTO domain_admins (username,domain,created,active) VALUES ('posfix@<my domain>','','2008-08-21 19:28:05','1')
mumbai.esoftech.com


Where is the problem?

Thanks

Saju Murali
Mumbai

Courier imap is not necessary for postfixadmin.
Your problem seems to be that postfix was not compiled with mysql support.
This is my system, showing that it was compiled with postgresql support:

Hai,
Thank you Berhanie...
How Postfix configured with the support of mysql?

The postconf -m command shows as follows:

btree
cidr
environ
hash
ldap
nis
pcre
proxy
regexp
static
unix

From where, I can find the postfix with mysql support? Can u give valuable suggestion? Its very urgent, pls.....

Ok, so the output of postconf -m proves that the postfix you're using wasn't compiled with mysql support. You're going to have to search your distro's repositories for a version of postfix that supports mysql. For example, if you use CentOs, you would get it from the centosplus repo.

I am using fedora(2.6.23.17-88.fc7), but can't find the postfix with mysql in the net, supporting this... Can any one help me for that? When i trying to install 'postfix-mysql-2.3.3-32.i586.rpm' showing the error libpostfix-global.so.1 is missing. And trying to install that another file is missing.... like that.

I'm having the same problem. On a live server I was updating clamav to correct another problem and postfix was updated as well. Postfix was fine until I ran an update. How can I reverse the postfix changes?

Yum.log
Apr 16 11:52:43 Updated: spamassassin.x86_64 3.3.1-3.el5.rf
Apr 16 11:52:43 Updated: clamav-devel.x86_64 0.96-1.el5.rf
Apr 16 11:52:46 Updated: amavisd-new.x86_64 2.6.4-2.el5.rf
Apr 16 11:52:47 Updated: postfix-pflogsumm.x86_64 2.3.3-2.1.el5_2
Apr 16 11:52:47 Updated: clamd.x86_64 0.96-1.el5.rf
Apr 16 11:52:50 Updated: postfix.x86_64 2.3.3-2.1.el5_2

This is a Centos 5 machine

Apr 16 12:26:20 mail postfix/postfix-script: stopping the Postfix mail system
Apr 16 12:26:20 mail postfix/master[4643]: terminating on signal 15
Apr 16 12:26:20 mail postfix/postfix-script: starting the Postfix mail system
Apr 16 12:26:20 mail postfix/master[4725]: daemon started -- version 2.3.3, configuration /etc/postfix
Apr 16 12:26:20 mail postfix/cleanup[4729]: fatal: unsupported dictionary type: mysql
Apr 16 12:26:21 mail postfix/master[4725]: warning: process /usr/libexec/postfix/cleanup pid 4729 exit status 1
Apr 16 12:26:21 mail postfix/master[4725]: warning: /usr/libexec/postfix/cleanup: bad command startup -- throttling

Thanks!

Nevermind. Fixed it by reinstalling postfix from centosplus repository.

Thanks