gmane.mail.virus.mailscanner.baruwa.user

Calmav is handled by Exim - is this how it supposed to be?

Gil Beth — 2013-05-24T20:22:08

Hi,

I am testing a Virus Scan - using Baruwa 2 - (Installed with the script that was 
provided by Jeremy)
Exim is rejecting in the SMTP stage, so the mail is never getting to the Queue 
for Mailscanner to handle.

Is this how it is suppose to be?

here is the SMTP session using swaks:

l# swaks -f vir44-OOc6XSIMyuSqndwCJWfcng< at >public.gmane.org -t gil.beth-O5WfVfzUwx8< at >public.gmane.org -s 10.0.1.77 --attach 
eicar.com.txt
=== Trying 10.0.1.77:25...
=== Connected to 10.0.1.77.
<-  220 *********************************************
 -> EHLO dashboard01
<-  250-mx at your service
<-  250-SIZE 20971520
<-  250-8BITMIME
<-  250-STARTTLS
<-  250 HELP
 -> MAIL FROM:<vir44-O5WfVfzUwx8< at >public.gmane.org>
<-  250 OK
 -> RCPT TO:<gil.beth-O5WfVfzUwx8< at >public.gmane.org>
<-  250 Accepted
 -> DATA
<-  354 Enter message, ending with "." on a line by itself
 -> Date: Fri, 24 May 2013 20:12:57 +0000
 -> To: gil.beth-O5WfVfzUwx8< at >public.gmane.org
 -> From: vir44-O5WfVfzUwx8< at >public.gmane.org
 -> Subject: test Fri, 24 May 2013 20:12:

Re: Manage outbound queue

Manel Gimeno Zaragozá — 2013-05-23T09:30:17

thanks it has been very useful! also I've detected I cannot preview message in queue. I've open an issue https://github.com/fluxlabs/baruwa/issues/10

thanks!

Manel
CC: baruwa< at >lists.baruwa.org
From: yongli.dang< at >gmail.com
Date: Thu, 23 May 2013 06:49:25 +0800
To: baruwa< at >lists.baruwa.org
Subject: Re: [Baruwa] Manage outbound queue

and check this issue 
https://github.com/fluxlabs/baruwa/issues/4

在 2013-5-22，19:06，Manel Gimeno Zaragozá <magiza83< at >hotmail.com> 写道：

Hi,

Thanks for your response, I've correct my cron as the issue suggest, but I'm still not getting any information from outbound queue. 

Correct me if I'm wrong, but I thought I could manage the mail queue in the outbound intances, or at least, check which ones are stuck.

anyway thanks for your help.

Manel 

From: yongli.dang< at >gmail.com
Date: Wed, 22 May 2013 17:38:27 +0800
To: baruwa< at >lists.baruwa.org
Subject: Re: [Baruwa] Manage outbound queue

Check your cron file and this linkhttps://github.com/

Re: Manage outbound queue

yongli.dang — 2013-05-22T22:49:25

and check this issue 

https://github.com/fluxlabs/baruwa/issues/4


在 2013-5-22，19:06，Manel Gimeno Zaragozá <magiza83< at >hotmail.com> 写道：

_______________________________________________
http://pledgie.com/campaigns/12056

Moving bayes to SQL

Jeremy McSpadden — 2013-05-22T12:49:13

I was unable to find any docu on how to move bayes to postgresql. 

May 22 04:11:00 mx03 spamd[30616]: config: failed to parse line, skipping, in "/etc/mail/spamassassin/local.cf": auto_whitelist_distinguish_signed 1
May 22 04:11:00 mx03 spamd[30616]: config: failed to parse line, skipping, in "/etc/mail/spamassassin/local.cf": auto_whitelist_factory Mail::SpamAssassin::SQLBasedAddrList
May 22 04:11:00 mx03 spamd[30616]: config: failed to parse line, skipping, in "/etc/mail/spamassassin/local.cf": user_awl_dsn DBI:Pg:dbname=baruwa;host=127.0.0.1;port=6432
May 22 04:11:00 mx03 spamd[30616]: config: failed to parse line, skipping, in "/etc/mail/spamassassin/local.cf": user_awl_sql_username bayes
May 22 04:11:00 mx03 spamd[30616]: config: failed to parse line, skipping, in "/etc/mail/spamassassin/local.cf": user_awl_sql_password password123
May 22 04:11:00 mx03 spamd[30616]: config: failed to parse line, skipping, in "/etc/mail/spamassassin/local.cf": user_awl_sql_table awl

--
Jeremy McSpadden
Flux Labs, Inc |

Re: Problem with baruwa 2.0.1 clamav-daemon web config

Jeremy McSpadden — 2013-05-22T12:11:19

Please revert the changes you did from http://markmail.org/message/jm7axl44rv547izc

--
Jeremy McSpadden
Flux Labs, Inc | http://www.fluxlabs.net<http://www.fluxlabs.net/> | Endless Solutions
Office : 850-250-5590x101<tel:850-250-5590;101> | Cell : 850-890-2543<tel:850-890-2543> | Fax : 850-254-2955<tel:850-254-2955>

On May 22, 2013, at 3:06 AM, "Mark Adams" <mark< at >workshopit.co.uk<mailto:mark< at >workshopit.co.uk>> wrote:

It work's just fine before the changes suggested by Jeremy, apart from the AV scanning of course!


On 22 May 2013 05:07, yongli.dang <yongli.dang< at >gmail.com<mailto:yongli.dang< at >gmail.com>> wrote:
maybe baruwa have not populated the database,check db account and password , and try to to repopulate necceccery dbs.

发自我的 iPhone

在 2013-5-21，21:19，Mark Adams <mark< at >workshopit.co.uk<mailto:mark< at >workshopit.co.uk>> 写道：

Hi Jeremy, Thanks for your response. I've tried your suggestion however now I am getting the following error when trying to restart:

Restartin

Re: Manage outbound queue

Manel Gimeno Zaragozá — 2013-05-22T11:06:32

Hi,

Thanks for your response, I've correct my cron as the issue suggest, but I'm still not getting any information from outbound queue. 

Correct me if I'm wrong, but I thought I could manage the mail queue in the outbound intances, or at least, check which ones are stuck.

anyway thanks for your help.

Manel 

From: yongli.dang< at >gmail.com
Date: Wed, 22 May 2013 17:38:27 +0800
To: baruwa< at >lists.baruwa.org
Subject: Re: [Baruwa] Manage outbound queue

Check your cron file and this linkhttps://github.com/fluxlabs/baruwa/issues/9

发自我的 iPhone
在 2013-5-21，21:49，Manel Gimeno Zaragozá <magiza83< at >hotmail.com> 写道：




Hi,

I'm referring to all email managed by the exim_out instance and the corresponding queue(s).

Thanks

Manel 

From: jeremy< at >fluxlabs.net
To: baruwa< at >lists.baruwa.org
Date: Tue, 21 May 2013 13:25:26 +0000
Subject: Re: [Baruwa] Manage outbound queue






I think your referring to the defer'd queue. 



--

Jeremy McSpadden

Flux Labs, Inc | http:/

Re: Manage outbound queue

yongli.dang — 2013-05-22T09:38:27

Check your cron file and this link
https://github.com/fluxlabs/baruwa/issues/9


发自我的 iPhone

在 2013-5-21，21:49，Manel Gimeno Zaragozá <magiza83< at >hotmail.com> 写道：

_______________________________________________
http://pledgie.com/campaigns/12056

Re: Manage outbound queue

yongli.dang — 2013-05-22T09:29:37

When did you install baruwa with the install sh ,you need to check the issus list


在 2013-5-21，21:49，Manel Gimeno Zaragozá <magiza83< at >hotmail.com> 写道：

_______________________________________________
http://pledgie.com/campaigns/12056

Re: Problem with baruwa 2.0.1 clamav-daemon web config

Mark Adams — 2013-05-22T08:04:27

It work's just fine before the changes suggested by Jeremy, apart from the
AV scanning of course!


On 22 May 2013 05:07, yongli.dang <yongli.dang-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org> wrote:

_______________________________________________
http://pledgie.com/campaigns/12056

Re: Problem with baruwa 2.0.1 clamav-daemon web config

yongli.dang — 2013-05-22T04:07:41

maybe baruwa have not populated the database,check db account and password , and try to to repopulate necceccery dbs.

发自我的 iPhone

在 2013-5-21，21:19，Mark Adams <mark-BPierTLEbFPBHMYPpBSspA< at >public.gmane.org> 写道：

_______________________________________________
http://pledgie.com/campaigns/12056

Re: Manage outbound queue

Manel Gimeno Zaragozá — 2013-05-21T13:49:02

Hi,

I'm referring to all email managed by the exim_out instance and the corresponding queue(s).

Thanks

Manel 

From: jeremy-xipdOIrf0erk1uMJSBkQmQ< at >public.gmane.org
To: baruwa-nJFXYWEDAR/xThsfVBBi/g< at >public.gmane.org
Date: Tue, 21 May 2013 13:25:26 +0000
Subject: Re: [Baruwa] Manage outbound queue

I think your referring to the defer'd queue. 

--

Jeremy McSpadden

Flux Labs, Inc | http://www.fluxlabs.net | Endless Solutions

Office : 850-250-5590x101 | Cell : 850-890-2543 |
 Fax : 850-254-2955

On May 21, 2013, at 5:33 AM, "Manel Gimeno Zaragozá" <magiza83< at >hotmail.com> wrote:

Hello,

I've a fresh install using install.sh script found in this list. Anyway, my problem is that I cannot manage outbound queue from baruwa.

I'm able to see the inbound queue in the full message list tab, but if a mail is stuck in outbound queue (due to relay server is down), I'm not able to see it in the Status --> Mail queues tab nor in other tabs.

My config is the default config provided by install.sh

Re: Manage outbound queue

Jeremy McSpadden — 2013-05-21T13:25:26

I think your referring to the defer'd queue.

--
Jeremy McSpadden
Flux Labs, Inc | http://www.fluxlabs.net<http://www.fluxlabs.net/> | Endless Solutions
Office : 850-250-5590x101<tel:850-250-5590;101> | Cell : 850-890-2543<tel:850-890-2543> | Fax : 850-254-2955<tel:850-254-2955>

On May 21, 2013, at 5:33 AM, "Manel Gimeno Zaragozá" <magiza83-PkbjNfxxIASIwRZHo2/mJg< at >public.gmane.orgm<mailto:magiza83-PkbjNfxxIARBDgjK7y7TUQ< at >public.gmane.org>> wrote:

Hello,

I've a fresh install using install.sh script found in this list. Anyway, my problem is that I cannot manage outbound queue from baruwa.

I'm able to see the inbound queue in the full message list tab, but if a mail is stuck in outbound queue (due to relay server is down), I'm not able to see it in the Status --> Mail queues tab nor in other tabs.

My config is the default config provided by install.sh

should I do any extra config to manage outbound queue?

Thanks & Regards.

Manel
_______________________________________________
http://pledgie.com/campaigns

Re: Problem with baruwa 2.0.1 clamav-daemon web config

Mark Adams — 2013-05-21T13:19:01

Hi Jeremy, Thanks for your response. I've tried your suggestion however now
I am getting the following error when trying to restart:

Restarting mail spam/virus scanner: MailScannerDBD::Pg::st execute failed:
ERROR:  function dbvalue(character varying) does not exist
LINE 1: SELECT dbvalue(value) AS value FROM quickpeek WHERE external...
               ^
HINT:  No function matches the given name and argument types. You might
need to add explicit type casts. [for Statement "SELECT dbvalue(value) AS
value FROM quickpeek WHERE external = ? AND (hostname = ? OR
hostname='default') LIMIT 1" with ParamValues:
1='mailscannerversionnumber', 2='mail-gw-app-2'] at
/usr/share/MailScanner//MailScanner/ConfigSQL.pm line 134.
DBD::Pg::st execute failed: ERROR:  function dbvalue(character varying)
does not exist
LINE 1: SELECT dbvalue(value) AS value FROM quickpeek WHERE external...
               ^
HINT:  No function matches the given name and argument types. You might
need to add explicit type casts. [for Statement "SELE

Re: Problem with baruwa 2.0.1 clamav-daemon web config

Jeremy McSpadden — 2013-05-21T13:11:15

You need to change your MailScanner.conf to use this

SQL Quick Peek = SELECT dbvalue(value) AS value FROM quickpeek WHERE external = ? AND (hostname = ? OR hostname='default') LIMIT 1
SQL Config = SELECT internal, dbvalue(value) AS value, hostname FROM quickpeek WHERE hostname=? OR hostname='default'

--
Jeremy McSpadden
Flux Labs, Inc | http://www.fluxlabs.net<http://www.fluxlabs.net/> | Endless Solutions
Office : 850-250-5590x101<tel:850-250-5590;101> | Cell : 850-890-2543<tel:850-890-2543> | Fax : 850-254-2955<tel:850-254-2955>

On May 21, 2013, at 4:49 AM, "Mark Adams" <mark-BPierTLEbFPBHMYPpBSspA< at >public.gmane.org<mailto:mark< at >workshopit.co.uk>> wrote:

Can anyone help on this? Thanks!


On 15 May 2013 17:08, Mark Adams <mark-BPierTLEbFPBHMYPpBSspA< at >public.gmane.org<mailto:mark< at >workshopit.co.uk>> wrote:
Hi,

After I selected clamav-daemon in the web interface, my AV scanning stopped working, exactly as detailed in the thread here

http://markmail.org/message/jm7axl44rv547izc

I've made the changes (added

Manage outbound queue

Manel Gimeno Zaragozá — 2013-05-21T10:32:54

Hello,

I've a fresh install using install.sh script found in this list. Anyway, my problem is that I cannot manage outbound queue from baruwa. 

I'm able to see the inbound queue in the full message list tab, but if a mail is stuck in outbound queue (due to relay server is down), I'm not able to see it in the Status --> Mail queues tab nor in other tabs.

My config is the default config provided by install.sh

should I do any extra config to manage outbound queue?

Thanks & Regards.

Manel
       _______________________________________________
http://pledgie.com/campaigns/12056

Re: Problem with baruwa 2.0.1 clamav-daemon web config

Mark Adams — 2013-05-21T09:47:55

Can anyone help on this? Thanks!


On 15 May 2013 17:08, Mark Adams <mark-BPierTLEbFPBHMYPpBSspA< at >public.gmane.org> wrote:

_______________________________________________
http://pledgie.com/campaigns/12056

Re: What is paster?

Ritchie P. Fraser — 2013-05-20T12:03:02

Hi again,

I have now...

Created an organisation "MyCompanyName"
added an outboud relay host => 192.168.0.101 (Ip of the Exchange server)

Have added domains e.g. mycompanydomain.co.uk
added a delivery server on the domain 192.168.0.101:25 and tested -> "up and accepting email from us"

Set up an account rpf-D4qZEMI14/g7VdE/fOJbLw< at >public.gmane.org<mailto:rpf-D4qZEMI14/g7VdE/fOJbLw< at >public.gmane.org>

I can telnet into the server  (telnet 192.168.0.200 25)
and create a mail...


The /var/log/exim/main.log gets the following lines added to it...

2013-05-20 12:28:35 no host name found for IP address 192.168.0.109
2013-05-20 12:28:50 1UeOGc-0003Ej-9S <= it-D4qZEMI14/g7VdE/fOJbLw< at >public.gmane.org H=[192.168.0.109] P=smtp S=239
2013-05-20 12:28:50 1UeOGc-0003Ej-9S Format error in spool file 1UeOGc-0003Ej-9S-H: size=581

Is this something that I have done, or not configured?

Ritchie


From: baruwa-bounces-nJFXYWEDAR/xThsfVBBi/g< at >public.gmane.org [mailto:baruwa-bounces-nJFXYWEDAR+B5iBmupqZzA< at >public.gmane.orgrg] On

Re: have you meet such problems when using baruwa 2.01 and how do you resolve it?

yoke88 — 2013-05-20T10:03:31

Yes, my issues most related to the install script. 
You can reference the script and manual from baruwa site to check your steps .

Do not use the step on baruwa site to download the sphinx API ,or you will got nothing when using baruwa to search.

在 2013-5-20，17:39，"Mark Adams [via Baruwa users list]" <ml-node+s963389n4026719h69-fo6Dv61Ne+xl57MIdRCFDg< at >public.gmane.org> 写道：





--
View this message in context: http://baruwa-users-list.963389.n3.nabble.com/have-you-meet-such-problems-when-using-baruwa-2-01-and-how-do-you-resolve-it-tp4026709p4026720.html
Sent from the Baruwa users list mailing list archive at Nabble.com._______________________________________________
http://pledgie.com/campaigns/12056

Re: have you meet such problems when using baruwa 2.01 and how do you resolve it?

Mark Adams — 2013-05-20T09:38:28

Ah right, I see now your issues were related to the install script rather
than baruwa itself. I had some similar issues with debian specific changes
required. I'm still having probs with clamav-daemon scanning though as per
a different post to this list... And of course the AD auth not working as
you have also found!

Cheers


On 20 May 2013 10:30, yoke88 <yongli.dang-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org> wrote:

_______________________________________________
http://pledgie.com/campaigns/12056

Re: have you meet such problems when using baruwa 2.01 and how do you resolve it?

yoke88 — 2013-05-20T09:30:25

read the closed issue list, I have comment why and how to resole the issues in the issue list.


https://github.com/fluxlabs/baruwa/issues?page=1&state=closed


在 2013-5-20，16:55，"Mark Adams [via Baruwa users list]" <ml-node+s963389n4026717h7-fo6Dv61Ne+xl57MIdRCFDg< at >public.gmane.org> 写道：





--
View this message in context: http://baruwa-users-list.963389.n3.nabble.com/have-you-meet-such-problems-when-using-baruwa-2-01-and-how-do-you-resolve-it-tp4026709p4026718.html
Sent from the Baruwa users list mailing list archive at Nabble.com._______________________________________________
http://pledgie.com/campaigns/12056

Re: have you meet such problems when using baruwa 2.01 and how do you resolve it?

Mark Adams — 2013-05-20T08:53:34

Hi,

The issues list doesn't actually show how you corrected the problems, it
just shows "Resolved". Is there any chance you can reply to your original
email with exactly how you fixed the problem? I think this would be helpful
for all.

Cheers,
Mark


On 18 May 2013 05:18, yoke88 <yongli.dang-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org> wrote:

_______________________________________________
http://pledgie.com/campaigns/12056