Postfix or dbmail error?

If there isn't a separate postfix-mysql package (and I
don't think there 
is) the SRPM does support it.

download the SRPM for Postfix and rpm -i postfix.src.rpm
modify the spec file to enable mysql support (should be
located in 
/usr/src/redhat/SPECS or somethign like that and rebuild the
RPM from 
the SPEC file.  That is how I got PostgreSQL support into
Postfix on CentOS.

Matt



Jorge Bastos wrote:
> search for a postfix-mysql package or similar.
> I'm sure there is one
>
>
> ----- Original Message ----- From: "Jim
Douglas" <jdz99hotmail.com>
> To: <dbmaildbmail.org>
> Sent: Thursday, September 21, 2006 12:55 AM
> Subject: Re: [Dbmail] Postfix or dbmail error?
>
>
>> >From: "Jorge Bastos"
<mysql.jorgedecimal.pt>
>>> Reply-To: DBMail mailinglist <dbmaildbmail.org>
>>> To: "DBMail mailinglist"
<dbmaildbmail.org>
>>> Subject: Re: [Dbmail] Postfix or dbmail error?
>>> Date: Wed, 20 Sep 2006 23:01:13 +0100
>>>
>>> Jim,
>>>
>>> You don't have mysql support in your postfix.
>>> If you're on debian:
>>> apt-get install postfix-mysql
>>>
>>>
>>>
>>>
>>>
>>> ----- Original Message ----- From: "Jim
Douglas" <jdz99hotmail.com>
>>> To: <dbmaildbmail.org>
>>> Sent: Wednesday, September 20, 2006 10:38 PM
>>> Subject: [Dbmail] Postfix or dbmail error?
>>>
>>>
>>>> I can send and receive email but I get the
following in my Postfix 
>>>> log and I'm not sure if it's dbmail or
Postifix error,
>>>>
>>>> Sep 20 17:35:38 cpe-22-22-226-222
postfix/smtpd[6348]: fatal: 
>>>> unsupported dictionary type: mysql
>>>> Sep 20 17:35:39 cpe-22-22-226-222
postfix/master[4000]: warning: 
>>>> process /usr/libexec/postfix/smtpd pid 6348
exit status 1
>>>> Sep 20 17:35:39 cpe-22-22-226-222
postfix/master[4000]: warning: 
>>>> /usr/libexec/postfix/smtpd: bad command
startup -- throttling
>>>>
>>>>
>>>> thanks for the help,
>>>> Jim
>>>>
>>>>
>>>>
_______________________________________________
>>>> Dbmail mailing list
>>>> Dbmaildbmail.org
>>>> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>>>>
>>>
>>> _______________________________________________
>>> Dbmail mailing list
>>> Dbmaildbmail.org
>>> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>>
>>
>> I'm not on Debian, FC5.  I used Yum to
upgrade...any suggestions?
>>
>> Jim
>>
>>
>> _______________________________________________
>> Dbmail mailing list
>> Dbmaildbmail.org
>> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>>
>
> _______________________________________________
> Dbmail mailing list
> Dbmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>

_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Matthew T. O'Connor wrote:
> If there isn't a separate postfix-mysql package (and I
don't think there 
> is) the SRPM does support it.
> 
> download the SRPM for Postfix and rpm -i
postfix.src.rpm
> modify the spec file to enable mysql support (should be
located in 
> /usr/src/redhat/SPECS or somethign like that and
rebuild the RPM from 
> the SPEC file.

Exactly, just did that recently for FC5. Get the
postfix.src.rpm form 
ftp. Install it.

Now edit the file /usr/src/redhat/SPECS/postfix.spec

The second line should be:
%define MYSQL 0

Change that to:
%define MYSQL 1

You'd also want to change the release number, to something
way bigger. 
It's around line 50 in the spec file. For example:

Release: 2000

Now save and do rpmbuild -ba postfix.spec

rpmbuild will probably complain about missing dependencies,
install them 
with yum.

Now try again rpmbuild -ba postfix.spec

You'll get the binary rpm in the folder
/usr/src/redhat/RPMS/i386/

Install it and you'll be OK. Just beware, when there's a
new rpm with 
the same version but smaller release number, it won't be
installed with 
yum update. If there's a new version of postfix, it will
get installed 
with yum update. So you'll have to rebuild it again. I'd
suggest even 
rebuilding when there's a newer release.

HTH,
	Alex
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail