postfix pickup folder

Good Morning

Centos 5.5 + postfix 2.3.3
Scenario : Send Mail from mysql
I am running a mysql database thar has to send email on certain events.
it is working via incrond folder monitoring and a sendmail wrapper.

basically, a stored procedure selects the email source text into a
folder and then incrod takes over. it works.

now, i want postfix to directly pickup and send the email.
i have written the file to /var/spool/postfix/pickup but there is no
pickup. the headers are terminated with /r/n and the file name is
email100. user mysql belongs to postfix group.

can anyone help me on this one ??
thank you and have a nice day.
PLeite

This is a transcript of the mysql generated file ::
(There are some trailing white spaces) could the be the reason ??

To: (E-Mail Removed)
From: (E-Mail Removed)
Subject: test email
Date: 2 Sep 2011 10:07:05 -0600
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_0000_01CA4B3F.8C263EE0"
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal


This is a multi-part message in MIME format.

------=_NextPart_000_0000_01CA4B3F.8C263EE0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit


email body - from mysql


------=_NextPart_000_0000_01CA4B3F.8C263EE0
Content-Type: text/html
Content-Transfer-Encoding: 7bit

email body - from mysql
------=_NextPart_000_0000_01CA4B3F.8C263EE0--

On Fri, 2011-09-02, Pedro M. Leite wrote:
> Good Morning
>
> Centos 5.5 + postfix 2.3.3
> Scenario : Send Mail from mysql
> I am running a mysql database thar has to send email on certain events.
> it is working via incrond folder monitoring and a sendmail wrapper.
>
> basically, a stored procedure selects the email source text into a
> folder and then incrod takes over. it works.
>
> now, i want postfix to directly pickup and send the email.
> i have written the file to /var/spool/postfix/pickup but there is no
> pickup. the headers are terminated with /r/n and the file name is
> email100. user mysql belongs to postfix group.

That will not work. The simple, correct way to send mail on any Unix
is to pipe it into the sendmail(1) utility.

/Jorgen

--
// Jorgen Grahn <grahn@ Oo o. . .
\X/ snipabacken.se> O o .

Em 02-09-2011 11:32, Jorgen Grahn escreveu:
> On Fri, 2011-09-02, Pedro M. Leite wrote:
>> Good Morning
>>
>> Centos 5.5 + postfix 2.3.3
>> Scenario : Send Mail from mysql
>> I am running a mysql database thar has to send email on certain events.
>> it is working via incrond folder monitoring and a sendmail wrapper.
>>
>> basically, a stored procedure selects the email source text into a
>> folder and then incrod takes over. it works.
>>
>> now, i want postfix to directly pickup and send the email.
>> i have written the file to /var/spool/postfix/pickup but there is no
>> pickup. the headers are terminated with /r/n and the file name is
>> email100. user mysql belongs to postfix group.
>
> That will not work. The simple, correct way to send mail on any Unix
> is to pipe it into the sendmail(1) utility.
>
> /Jorgen
>
Good Afternoon.
Thanks, thought so, did and its working, i just wanted to make it
simpler, if possible.

Have a nice day and a nice weekend.
PLeite

On Fri, 2011-09-02, Pedro M. Leite wrote:
> Em 02-09-2011 11:32, Jorgen Grahn escreveu:
>> On Fri, 2011-09-02, Pedro M. Leite wrote:
>>> Good Morning
>>>
>>> Centos 5.5 + postfix 2.3.3
>>> Scenario : Send Mail from mysql
>>> I am running a mysql database thar has to send email on certain events.
>>> it is working via incrond folder monitoring and a sendmail wrapper.
>>>
>>> basically, a stored procedure selects the email source text into a
>>> folder and then incrod takes over. it works.
>>>
>>> now, i want postfix to directly pickup and send the email.
>>> i have written the file to /var/spool/postfix/pickup but there is no
>>> pickup. the headers are terminated with /r/n and the file name is
>>> email100.

>>> user mysql belongs to postfix group.

You might want to remove it from there -- as far as I can tell only
postfix itself should be in the postfix group; its security might be
compromised otherwise.

>> That will not work. The simple, correct way to send mail on any Unix
>> is to pipe it into the sendmail(1) utility.
>>
>> /Jorgen
>>
> Good Afternoon.
> Thanks, thought so, did and its working, i just wanted to make it
> simpler, if possible.

I don't think it can be made any simpler, if you want it robust, safe
and portable. Performance-wise there's the cost of executing
sendmail(1) once per mail, but I believe that's a problem only under
extreme conditions.

/Jorgen

--
// Jorgen Grahn <grahn@ Oo o. . .
\X/ snipabacken.se> O o .

Em 05-09-2011 08:26, Jorgen Grahn escreveu:
> On Fri, 2011-09-02, Pedro M. Leite wrote:
>> Em 02-09-2011 11:32, Jorgen Grahn escreveu:
>>> On Fri, 2011-09-02, Pedro M. Leite wrote:
>>>> Good Morning
>>>>
>>>> Centos 5.5 + postfix 2.3.3
>>>> Scenario : Send Mail from mysql
>>>> I am running a mysql database thar has to send email on certain events.
>>>> it is working via incrond folder monitoring and a sendmail wrapper.
>>>>
>>>> basically, a stored procedure selects the email source text into a
>>>> folder and then incrod takes over. it works.
>>>>
>>>> now, i want postfix to directly pickup and send the email.
>>>> i have written the file to /var/spool/postfix/pickup but there is no
>>>> pickup. the headers are terminated with /r/n and the file name is
>>>> email100.
>
>>>> user mysql belongs to postfix group.
>
> You might want to remove it from there -- as far as I can tell only
> postfix itself should be in the postfix group; its security might be
> compromised otherwise.
>
>>> That will not work. The simple, correct way to send mail on any Unix
>>> is to pipe it into the sendmail(1) utility.
>>>
>>> /Jorgen
>>>
>> Good Afternoon.
>> Thanks, thought so, did and its working, i just wanted to make it
>> simpler, if possible.
>
> I don't think it can be made any simpler, if you want it robust, safe
> and portable. Performance-wise there's the cost of executing
> sendmail(1) once per mail, but I believe that's a problem only under
> extreme conditions.
>
> /Jorgen
>
Good morning
Thank you for the update
i had to add mysql to allow writing to the puckup folder, but its gone
now, since i am using the incrond and sendmail approach.
its simple, its working, the KISS approach is usually better !!!!!
the email traffic is low, so there is no problem performance and
bottleneck wise.

thank you and have a nice day
Best Regards
PLeite