Re: [CentOS] Postfix and mysql

2007-07-06 Thread Brent DiNicola
> Date: Thu, 05 Jul 2007 16:48:55 +0200
> From: Jordi Espasa Clofent <[EMAIL PROTECTED]>
> Subject: Re: [CentOS] Postfix and mysql
>
>
>> centosplus contains postfix-mysql rpm, so just enable that repo and use
>> yum to install it.
>>
>
> Not provided int CentOS 5:
>

> Nothing to do
>
> [EMAIL PROTECTED] Desktop]# cat /etc/redhat-release
> CentOS release 5 (Final)
>
> I don't understand why a server-oriented distro like CentOS (RHEL)
> doesn't provide support to _most_ popular opensource database to the
> _most_ popular opensource SMTP server. I'm very stunned with it.
>
>

Just like the package in 4.5 CentOS, adding mysql is very simple and easy
to repackage as an rpm. Just install SRPM then patch the postfix.spec as
shown below and build the rpm. Will make the following rpms:

postfix-2.3.3-2.mysql.el5.i386.rpm
postfix-pflogsumm-2.3.3-2.mysql.el5.i386.rpm

Might not be named right but will work.

### CUT HERE ###
--- postfix.spec2007-07-06 10:07:08.0 -0500
+++ postfix.spec.orig   2007-07-06 10:05:00.0 -0500
@@ -1,5 +1,5 @@
 %define LDAP 2
-%define MYSQL 1
+%define MYSQL 0
 %define PCRE 1
 %define SASL 2
 %define TLS 1
@@ -43,7 +43,7 @@
 Name: postfix
 Summary: Postfix Mail Transport Agent
 Version: 2.3.3
-Release: 2.mysql.el5
+Release: 2
 Epoch: 2
 Group: System Environment/Daemons
 URL: http://www.postfix.org
 CUT HERE #


HTH,

Brent
-- 
Brent DiNicola



___
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos


Re: [CentOS] CentOSplus Postfix with mysql/pgsql

2007-06-22 Thread Brent DiNicola
For those curious, since the devs haven't given an answer yet to the
future of the Postfix with MySQL in CentOS Plus, here is the patch to add
the MySQL support back into Postfix that I used in case anyone needs it. I
might have messed up the naming but I tried to pick something relevant
that wouldn't be later confused with what they would do too much.

Cheers!

--- postfix.spec2007-01-25 01:44:52.0 -0600
+++ postfix.spec.mysql  2007-06-22 10:05:42.0 -0500
@@ -1,5 +1,5 @@
 %define LDAP 2
-%define MYSQL 0
+%define MYSQL 1
 %define PCRE 1
 %define SASL 2
 %define TLS 1
@@ -43,7 +43,7 @@
 Name: postfix
 Summary: Postfix Mail Transport Agent
 Version: 2.2.10
-Release: 1.1.el4
+Release: 1.1.mysql.el4
 Epoch: 2
 Group: System Environment/Daemons
 URL: http://www.postfix.org

On Tue, June 19, 2007 7:00 am, [EMAIL PROTECTED] wrote:
> Date: Mon, 18 Jun 2007 08:18:31 -0500 (CDT)
> From: "Brent DiNicola" <[EMAIL PROTECTED]>
> Subject: [CentOS] CentOSplus Postfix with mysql/pgsql
> To: centos@centos.org
> Message-ID: <[EMAIL PROTECTED]>
> Content-Type: text/plain;charset=iso-8859-1
>
> The lasted version of Postfix in the OS for 4.5 add a .1 to the rpm
> version which makes it newer than the CentOSPlus version and hence
> replaces it, any intent to update the 4.5 CentOSPlus package or should I
> roll my own with mysql included?
>
> 4.5 OS Version: postfix-2.2.10-1.1.el4.i386.rpm
> 4.4/5 CentOSPlus Version: postfix-2.2.10-1.RHEL4.2.mysql_pgsql.c4.i386.rpm
>
> Thanks
> Brent

-- 
Brent DiNicola/Whitewolf
The Whitewolf of Imrryr

http://www.elric.net
Disclaimer: Any opinions expressed here are
from my dog. Any liabilities fall to the dog.

___
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos


[CentOS] CentOSplus Postfix with mysql/pgsql

2007-06-18 Thread Brent DiNicola
The lasted version of Postfix in the OS for 4.5 add a .1 to the rpm
version which makes it newer than the CentOSPlus version and hence
replaces it, any intent to update the 4.5 CentOSPlus package or should I
roll my own with mysql included?

4.5 OS Version: postfix-2.2.10-1.1.el4.i386.rpm
4.4/5 CentOSPlus Version: postfix-2.2.10-1.RHEL4.2.mysql_pgsql.c4.i386.rpm

Thanks
Brent
-- 
Brent DiNicola/Whitewolf
The Whitewolf of Imrryr

http://www.elric.net
Disclaimer: Any opinions expressed here are
from my dog. Any liabilities fall to the dog.


___
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos


Re: [CentOS] Two Issues - Postfix and Gamin

2007-06-13 Thread Brent DiNicola

On Wed, June 13, 2007 10:01 am, Steve Huff wrote:
>
> On Jun 13, 2007, at 10:46 AM, Brent DiNicola wrote:
>
>> The second issue is also with 4.5 but with Gamin. I have about 20
>> Linux
>> CentOS workstations that have been running nicely for several months
>> (almost years) and after the 4.5 upgrade I have noticed that the
>> gam_server process with Gamin keeps sucking up all the CPU cycles
>> after a
>> short time of running. (Sometimes tied to screen saver use but not
>> always). I haven't changed anything in my environment that I can
>> see would
>> cause this problem after the 4.5 upgrade. (Same file server for NFS
>> mounts, same autofs entries etc). Has anyone else noticed this
>> issue and
>> found a work around, I did some digging but most entries on this
>> issue are
>> from the 2005 range which didn't fix my issue and/or were for an older
>> version. The /etc/gamin/gaminrc didn't fix it through various
>> mutations of
>> entries and short of removing the gam_server from libexec, I would
>> like to
>> find a solution or know if anyone else has experienced this issue.
>
> This is an active bug being tracked upstream:
>
> https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=240154
>
> Some workarounds are suggested there, but a fix has apparently not
> yet been found.
>
> -steve
>
> --
> If this were played upon a stage now, I could condemn it as an
> improbable fiction. - Fabian, Twelfth Night, III,v
>
>
>
> ___
> CentOS mailing list
> CentOS@centos.org
> http://lists.centos.org/mailman/listinfo/centos
>

oops.. I have never had to much luck finding upstream Bugzilla's for some
reason. Thanks much, I will watch this one.

Brent

-- 
Brent DiNicola/Whitewolf
The Whitewolf of Imrryr

http://www.elric.net
Disclaimer: Any opinions expressed here are
from my dog. Any liabilities fall to the dog.


___
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos


[CentOS] Two Issues - Postfix and Gamin

2007-06-13 Thread Brent DiNicola
Greetings,

I have done a bit of searching and I have found that the 4.5 version of
Postfix is the following rpm: postfix-2.2.10-1.1.el4.i386.rpm. I had
previously had the CentOSPlus version with mysql compiled in and just
recently upgraded to 4.5 from 4.4, upon doing this.. the above RPM was
installed, which is greater than the postfix with mysql from CentOSPlus,
which is the following rpm:
postfix-2.2.10-1.RHEL4.2.mysql_pgsql.c4.i386.rpm (note the 2.2.10-1
version without the extra .1 from above.)

I tried to manually install the postfix with mysql but of course the
versioning is greater on 4.5 rpm, is there a plan to fix this or should I
try to roll my own RPM with mysql included? This happened to restart
during a 5am auto yum update, causing my server to bounce this morning
until I found it, ooops my bad!

The second issue is also with 4.5 but with Gamin. I have about 20 Linux
CentOS workstations that have been running nicely for several months
(almost years) and after the 4.5 upgrade I have noticed that the
gam_server process with Gamin keeps sucking up all the CPU cycles after a
short time of running. (Sometimes tied to screen saver use but not
always). I haven't changed anything in my environment that I can see would
cause this problem after the 4.5 upgrade. (Same file server for NFS
mounts, same autofs entries etc). Has anyone else noticed this issue and
found a work around, I did some digging but most entries on this issue are
from the 2005 range which didn't fix my issue and/or were for an older
version. The /etc/gamin/gaminrc didn't fix it through various mutations of
entries and short of removing the gam_server from libexec, I would like to
find a solution or know if anyone else has experienced this issue.

Thanks

Brent

PS. Great work guys on the OS, I have lurked on the Mailing lists for a
number of years and you are doing outstanding work and support. Great JOB!

-- 
Brent DiNicola/Whitewolf
The Whitewolf of Imrryr

http://www.elric.net
Disclaimer: Any opinions expressed here are
from my dog. Any liabilities fall to the dog.


___
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos