Stephen Cox | 2 Jul 08:27 2012
Picon

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?


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
Anis Jendoubi | 2 Jul 17:08 2012
Picon

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
Anis Jendoubi | 2 Jul 17:18 2012
Picon

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
Anis Jendoubi | 2 Jul 17:38 2012
Picon

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
Martin Hepworth | 2 Jul 20:15 2012
Picon

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
Anis Jendoubi | 3 Jul 16:37 2012
Picon

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
Johan Hendriks | 4 Jul 09:49 2012

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

Stephen Cox | 4 Jul 13:05 2012
Picon

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

Johan Hendriks | 4 Jul 16:55 2012

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

Stephen Cox | 4 Jul 16:58 2012
Picon

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


Gmane