LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 08-24-2008, 02:27 PM   #1
sajumurali
LQ Newbie
 
Registered: Jul 2008
Posts: 11

Rep: Reputation: 0
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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM 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

Last edited by sajumurali; 08-24-2008 at 02:37 PM.
 
Old 08-24-2008, 05:35 PM   #2
Berhanie
Senior Member
 
Registered: Dec 2003
Location: phnom penh
Distribution: Fedora
Posts: 1,625

Rep: Reputation: 165Reputation: 165
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:
Code:
$ postconf -m
btree
cidr
environ
hash
pcre
pgsql
proxy
regexp
static
unix
 
Old 08-26-2008, 02:45 AM   #3
sajumurali
LQ Newbie
 
Registered: Jul 2008
Posts: 11

Original Poster
Rep: Reputation: 0
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.....

Last edited by sajumurali; 08-26-2008 at 10:29 AM.
 
Old 08-26-2008, 11:11 AM   #4
Berhanie
Senior Member
 
Registered: Dec 2003
Location: phnom penh
Distribution: Fedora
Posts: 1,625

Rep: Reputation: 165Reputation: 165
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.
 
Old 08-27-2008, 07:10 AM   #5
sajumurali
LQ Newbie
 
Registered: Jul 2008
Posts: 11

Original Poster
Rep: Reputation: 0
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.
 
Old 04-16-2010, 12:41 PM   #6
rustyguy
LQ Newbie
 
Registered: Apr 2010
Posts: 2

Rep: Reputation: 0
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!
 
Old 04-16-2010, 02:24 PM   #7
rustyguy
LQ Newbie
 
Registered: Apr 2010
Posts: 2

Rep: Reputation: 0
Nevermind. Fixed it by reinstalling postfix from centosplus repository.

Thanks


Quote:
Originally Posted by rustyguy View Post
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!
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Postfix: postfix: fatal: chdir(/usr/libexec/postfix) Micro420 Ubuntu 2 07-13-2008 01:21 PM
Custom ASpell dictionary from mySQL dlublink Linux - Software 0 12-30-2005 12:35 PM
Disk Cleanup type thing? IanPappas Mandriva 1 10-05-2005 07:01 PM
Problems With Kismet - Fatal:unknown capture type... metaphys Linux - Wireless Networking 3 08-01-2004 08:47 PM
Cleanup after messed up mysql install ilhbutshm Linux - Software 1 05-24-2004 02:56 PM


All times are GMT -5. The time now is 08:33 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration