Baruwa a web 2.0 MailScanner front-end. ()

Stephen Cox | 2 Jul 2012 08:27

Re: Baruwa: Backup DB insert Fail

On Fri, Jun 29, 2012 at 8:33 AM, <gavin.au-TrDhO2r350BQHnaVEQCagbpzq4S04n8Q@public.gmane.org> wrote:

Hi,

I always see the message 'Baruwa: Backup DB insert Fail' in the mail log after some time the MailScanner is restarted. If I restart MailScanner, that message will be gone, but after some time it will come back again. What is wrong?

http://lists.baruwa.org/pipermail/baruwa/2011-August/001437.html

Just delete the baruwa2.db file and restart MailScanner.

Below is what the log looks like:

Jun 28 18:05:49 extmail1 MailScanner[26212]: Baruwa: Logging message 61A20C01E.A8922 to SQL
Jun 28 18:05:49 extmail1 MailScanner[26212]: "Always Looked Up Last" took 0.00 seconds
Jun 28 18:05:49 extmail1 MailScanner[26212]: Config: calling custom end function BaruwaSQL
Jun 28 18:05:49 extmail1 MailScanner[26212]: Baruwa: Shutting down SQL logger
Jun 28 18:05:49 extmail1 MailScanner[26212]: MailScanner child dying of old age

...

Jun 28 18:05:49 extmail1 MailScanner[25578]: Config: calling custom init function BaruwaSQL
Jun 28 18:05:50 extmail1 MailScanner[25579]: Baruwa: Starting SQL logger
Jun 28 18:05:50 extmail1 MailScanner[25580]: Baruwa: DB conn alive, starting recovery
Jun 28 18:05:50 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:05:50 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:05:50 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:05:50 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:05:50 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:05:50 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:05:50 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:05:50 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:05:50 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:05:50 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:05:50 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:05:50 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:05:50 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:05:50 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:05:50 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:05:50 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:05:50 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:05:50 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail

...

Jun 28 18:06:33 extmail1 MailScanner[26353]: Baruwa: Logging message 5866AC01E.ACADE to SQL
Jun 28 18:06:33 extmail1 MailScanner[26353]: "Always Looked Up Last" took 0.00 seconds
Jun 28 18:06:33 extmail1 MailScanner[26353]: Config: calling custom end function BaruwaSQL
Jun 28 18:06:33 extmail1 MailScanner[26353]: Baruwa: Shutting down SQL logger
Jun 28 18:06:33 extmail1 MailScanner[26353]: MailScanner child dying of old age
Jun 28 18:06:33 extmail1 MailScanner[25580]: Baruwa: 5866AC01E.ACADE: Logged to SQL
Jun 28 18:06:33 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:06:33 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:06:33 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:06:33 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:06:33 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:06:33 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:06:33 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:06:33 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:06:33 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:06:33 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:06:33 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:06:33 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:06:33 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:06:33 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:06:33 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:06:33 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:06:33 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:06:33 extmail1 MailScanner[25580]: Baruwa: Backup DB insert Fail
Jun 28 18:06:33 extmail1 MailScanner[25580]: Baruwa: SQL shutting down

Regards,
Gavin Au
*********************************************************************************************
Only an individual or entity who is intended to be a recipient of this e-mail may access or use the information contained in this e-mail or any of its attachments. Opinions contained in this e-mail or any of its attachments do not necessarily reflect the opinions of Queensland Treasury.

The contents of this e-mail and any attachments are confidential and may be legally privileged and the subject of copyright. If you have received this e-mail in error, please notify Queensland Treasury immediately and erase all copies of the e-mail and the attachments. Queensland Treasury uses virus scanning software. However, it is not liable for viruses present in this e-mail or in any attachment.
***************************************************************************************************

_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056

--
Stephen Cox

_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056

headers

Anis Jendoubi | 2 Jul 2012 17:08

emails being stuck in oubound queue

Hi,

I've installed Baruwa through puppet, I must admit from the beginning that I'm a beginner in EXIM mta (my preferred is Postfix), however I'm trying to learn it the hard way ;)

I have baruwa setup as an outbound relay server that filters emails, it does accept emails from few specific network ranges and should relay them clean to the outside recipients.

it's all well until the point to relay them outside where I have to manually run the command given in an early post I have searched and found: "exim -C /etc/exim/exim_out.conf -v -qff", without this command the mails get stuck somewhere and it does not show them on the outbound queue of Baruwa UI.

Anyone had this before? and how to fix this without creating a dedicated cron job for this command?

Thanks for any helpful advice.

Cheers,

Anis

_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056

headers

Anis Jendoubi | 2 Jul 2012 17:18

filename.rules.conf not being applied

Hi,

As my earlier post I've installed Baruwa through puppet on Centos 6.2 (64bit), everything went smooth, emails are being received (but not going out, see my post http://baruwa-users-list.963389.n3.nabble.com/emails-being-stuck-in-oubound-queue-td4025077.html ), however I wanted to allow .doc, .docx, .pdf, .xls and .xlsx files as attachments, so I edited the /etc/MailScanner/filename.rules.conf and added the lines below:

allow \.doc$ - -

allow \.docx$ - -

allow \.xls$ - -

allow \.xlsx$ - -

allow \.ppt$ - -

allow \.pdf$ - -

and then I restarted mailscanner service (I've even rebooted the whole server at some stage) to apply the configuration, unfortunately the mails with such attachments were still tagged as "infected".

Anyone know the solution trick to accept such file extentions atachments in the mails?

Thanks for any useful help.

Anis

_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056

headers

Anis Jendoubi | 2 Jul 2012 17:38

Baruwa's SQL queries

Hi,

Quick question (propably Andrew is the best to answer it), where can I find the scripts/files that are fired to create the users accounts and domains, I mean the SQL queries to create/delete/edit accounts and domains..

Thanks,

Anis

_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056

headers

Martin Hepworth | 2 Jul 2012 20:15

Re: emails being stuck in oubound queue

Sounds like your not running the outbound exim mta as a daemon at startup

Have a look in the mailscanner wiki for how to setup two exim instances so one accepts incoming email for mailscanner and the other takes the mailscanner output from the holding queue and relays it onward

Martin

On Monday, 2 July 2012, Anis Jendoubi wrote:

Hi,
I've installed Baruwa through puppet, I must admit from the beginning that I'm a beginner in EXIM mta (my preferred is Postfix), however I'm trying to learn it the hard way ;)

I have baruwa setup as an outbound relay server that filters emails, it does accept emails from few specific network ranges and should relay them clean to the outside recipients.

it's all well until the point to relay them outside where I have to manually run the command given in an early post I have searched and found: "exim -C /etc/exim/exim_out.conf -v -qff", without this command the mails get stuck somewhere and it does not show them on the outbound queue of Baruwa UI.

Anyone had this before? and how to fix this without creating a dedicated cron job for this command?

Thanks for any helpful advice.

Cheers,

Anis

--
--
Martin Hepworth, CISSP
Oxford, UK

_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056

headers

Anis Jendoubi | 3 Jul 2012 16:37

Re: emails being stuck in oubound queue

Hi Martin,

Thanks for the hint, I've checked the mailscanner wiki and I did even a quick check on the exim processes running (below is the result) and it looks like the exim and mailscanner configuration are set to work successfully:

Here what I get from a process side of it (both exim instances are running as per mailscanner-exim document):

----------------------------------------------------------

[root <at> smtp ~]# ps -aux | grep exim

Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.8/FAQ

exim 2963 0.0 2.4 315456 95528 ? S 12:01 0:04 MailScanner: waiting for messages

exim 4331 0.0 0.0 96660 1744 ? Ss Jun28 0:00 /usr/sbin/exim -C /etc/exim/exim.conf -bd

exim 4333 0.0 0.0 96664 1636 ? Ss Jun28 0:00 /usr/sbin/exim -C /etc/exim/exim_out.conf -q15m

exim 4355 0.0 0.8 203216 33020 ? Ss Jun28 0:01 MailScanner: starting child

exim 6642 0.0 2.4 314960 95104 ? S 13:01 0:03 MailScanner: waiting for messages

exim 14077 0.2 2.4 315020 95104 ? S 15:01 0:02 MailScanner: waiting for messages

exim 14079 0.0 0.9 241920 38976 ? S 15:01 0:00 Baruwa SQL

root 15699 0.0 0.0 103224 860 pts/0 S+ 15:24 0:00 grep exim

exim 24323 0.0 2.4 315072 95120 ? S 09:01 0:04 MailScanner: waiting for messages

exim 27936 0.0 2.4 314960 95104 ? S 10:01 0:04 MailScanner: waiting for messages

----------------------------------------------------------

Before I pushed the emails through my baruwa server, I have added the ": /etc/exim/accepted_relay_network.txt" in the /etc/exim/exim.conf file as "relay_from_hosts" option to accept the network ranges included in the manually created file "/etc/exim/accepted_relay_network.txt" (each network range is on a separate line as per documentation), I didn't add any domain in baruwa UI yet... could this be the cause of the issue then?

Thanks again for any hint.

Cheers,

Anis

On 2 July 2012 20:15, Martin Hepworth <maxsec-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:

Sounds like your not running the outbound exim mta as a daemon at startup

Have a look in the mailscanner wiki for how to setup two exim instances so one accepts incoming email for mailscanner and the other takes the mailscanner output from the holding queue and relays it onward

Martin

On Monday, 2 July 2012, Anis Jendoubi wrote:
Hi,
I've installed Baruwa through puppet, I must admit from the beginning that I'm a beginner in EXIM mta (my preferred is Postfix), however I'm trying to learn it the hard way ;)

I have baruwa setup as an outbound relay server that filters emails, it does accept emails from few specific network ranges and should relay them clean to the outside recipients.

it's all well until the point to relay them outside where I have to manually run the command given in an early post I have searched and found: "exim -C /etc/exim/exim_out.conf -v -qff", without this command the mails get stuck somewhere and it does not show them on the outbound queue of Baruwa UI.

Anyone had this before? and how to fix this without creating a dedicated cron job for this command?

Thanks for any helpful advice.

Cheers,

Anis

--
--
Martin Hepworth, CISSP
Oxford, UK

_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056

_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056

headers

Johan Hendriks | 4 Jul 2012 09:49

Quarantine requeue

Hello all.

Maybe not 100% baruwa related!
We had an malfunction yesterday with one of the mail relay servers.

It started to put all the mail to the quarantine folder! spam or no spam 
and they all marked as infected.
I needed to shutdown the server.

Now i have the quarantine dir full with mail.

Can i somehow give these messages back to the MTA (postfix)  so that it 
will requeue them!

thanks a lot.

-- 
_______________________
*Johan Hendriks*
*Schavemaker Transport*

Tel:+31 (0)251 229098
Fax:+31 (0)251 212016
email:j.hendriks@... <mailto:j.hendriks@...>
web:http://www.schavemaker.com
_______________________
/Confidentiality Notice: The information in this document may be
confidential. It is intended only for the use of the named recipient.
If you are not the intended recipient, please notify me immediately
and then delete this document. Do not disclose the contents of this document
to any other person, nor take any copies. Violation of this notice may 
be unlawful. /
_______________________

_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056

headers

Stephen Cox | 4 Jul 2012 13:05

Re: Quarantine requeue

On Wed, Jul 4, 2012 at 9:49 AM, Johan Hendriks
<j.hendriks@...> wrote:
> Hello all.
>
> Maybe not 100% baruwa related!
> We had an malfunction yesterday with one of the mail relay servers.
>
> It started to put all the mail to the quarantine folder! spam or no spam and
> they all marked as infected.
> I needed to shutdown the server.
>
> Now i have the quarantine dir full with mail.
>
> Can i somehow give these messages back to the MTA (postfix)  so that it will
> requeue them!

If you are in a hurry to get the mail re-queued, look at
http://wiki.mailscanner.info/doku.php?id=documentation:configuration:mta:postfix:how_to:release_quarantined_mail

>
> thanks a lot.
>
>
>
> --
> _______________________
> *Johan Hendriks*
> *Schavemaker Transport*
>
> Tel:+31 (0)251 229098
> Fax:+31 (0)251 212016
> email:j.hendriks@... <mailto:j.hendriks@...>
> web:http://www.schavemaker.com
> _______________________
> /Confidentiality Notice: The information in this document may be
> confidential. It is intended only for the use of the named recipient.
> If you are not the intended recipient, please notify me immediately
> and then delete this document. Do not disclose the contents of this document
> to any other person, nor take any copies. Violation of this notice may be
> unlawful. /
> _______________________
>
> _______________________________________________
> Keep Baruwa FREE - http://pledgie.com/campaigns/12056

--

-- 
Stephen Cox

_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056

headers

Johan Hendriks | 4 Jul 2012 16:55

Re: Quarantine requeue

Op woensdag 4 juli 2012 13:05:48, Stephen Cox schreef:
> On Wed, Jul 4, 2012 at 9:49 AM, Johan Hendriks
> <j.hendriks@...> wrote:
>> Hello all.
>>
>> Maybe not 100% baruwa related!
>> We had an malfunction yesterday with one of the mail relay servers.
>>
>> It started to put all the mail to the quarantine folder! spam or no spam and
>> they all marked as infected.
>> I needed to shutdown the server.
>>
>> Now i have the quarantine dir full with mail.
>>
>> Can i somehow give these messages back to the MTA (postfix)  so that it will
>> requeue them!
>
> If you are in a hurry to get the mail re-queued, look at
> http://wiki.mailscanner.info/doku.php?id=documentation:configuration:mta:postfix:how_to:release_quarantined_mail
>
>>
>> thanks a lot.
>>
>>
>>
>> --
>> _______________________
>> *Johan Hendriks*
>> *Schavemaker Transport*
>>
>> Tel:+31 (0)251 229098
>> Fax:+31 (0)251 212016
>> email:j.hendriks@... <mailto:j.hendriks@...>
>> web:http://www.schavemaker.com
>> _______________________
>> /Confidentiality Notice: The information in this document may be
>> confidential. It is intended only for the use of the named recipient.
>> If you are not the intended recipient, please notify me immediately
>> and then delete this document. Do not disclose the contents of this document
>> to any other person, nor take any copies. Violation of this notice may be
>> unlawful. /
>> _______________________
>>
>> _______________________________________________
>> Keep Baruwa FREE - http://pledgie.com/campaigns/12056
>

Thank you so much just what i needed.
Google did not come up with that one.
My google techniques needs some attention i guess

Thanks again
regards
Johan

_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056

headers

Stephen Cox | 4 Jul 2012 16:58

Re: Quarantine requeue

On Wed, Jul 4, 2012 at 4:55 PM, Johan Hendriks
<j.hendriks@...> wrote:
> Op woensdag 4 juli 2012 13:05:48, Stephen Cox schreef:
>
>> On Wed, Jul 4, 2012 at 9:49 AM, Johan Hendriks
>> <j.hendriks@...> wrote:
>>>
>>> Hello all.
>>>
>>> Maybe not 100% baruwa related!
>>> We had an malfunction yesterday with one of the mail relay servers.
>>>
>>> It started to put all the mail to the quarantine folder! spam or no spam
>>> and
>>> they all marked as infected.
>>> I needed to shutdown the server.
>>>
>>> Now i have the quarantine dir full with mail.
>>>
>>> Can i somehow give these messages back to the MTA (postfix)  so that it
>>> will
>>> requeue them!
>>
>>
>> If you are in a hurry to get the mail re-queued, look at
>>
>> http://wiki.mailscanner.info/doku.php?id=documentation:configuration:mta:postfix:how_to:release_quarantined_mail
>>
>>>
>>> thanks a lot.
>>>
>>>
>>>
>>> --
>>> _______________________
>>> *Johan Hendriks*
>>> *Schavemaker Transport*
>>>
>>> Tel:+31 (0)251 229098
>>> Fax:+31 (0)251 212016
>>> email:j.hendriks@... <mailto:j.hendriks@...>
>>> web:http://www.schavemaker.com
>>> _______________________
>>> /Confidentiality Notice: The information in this document may be
>>> confidential. It is intended only for the use of the named recipient.
>>> If you are not the intended recipient, please notify me immediately
>>> and then delete this document. Do not disclose the contents of this
>>> document
>>> to any other person, nor take any copies. Violation of this notice may be
>>> unlawful. /
>>> _______________________
>>>
>>> _______________________________________________
>>> Keep Baruwa FREE - http://pledgie.com/campaigns/12056
>>
>>
>
> Thank you so much just what i needed.
> Google did not come up with that one.
> My google techniques needs some attention i guess
>



I am glad it helped.

> Thanks again
> regards
> Johan
>
>
>
>
> _______________________________________________
> Keep Baruwa FREE - http://pledgie.com/campaigns/12056

--

-- 
Stephen Cox

_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056

109	May 2013
198	April 2013
236	March 2013
269	February 2013
485	January 2013
139	December 2012
72	November 2012
71	October 2012
19	September 2012
33	August 2012
17	July 2012
65	June 2012
46	May 2012
52	April 2012
68	March 2012
123	February 2012
46	January 2012
74	December 2011
145	November 2011
151	October 2011
155	September 2011
170	August 2011
201	July 2011
110	June 2011
65	May 2011
266	April 2011
87	March 2011
136	February 2011
101	January 2011
93	December 2010
104	November 2010
12	October 2010
8	September 2010
7	August 2010

Mon	Tue	Wed	Thu	Fri	Sat	Sun

						1
2	3	4	5	6	7	8
9	10	11	12	13	14	15
16	17	18	19	20	21	22
23	24	25	26	27	28	29
30	31