[AMaViS-user] Re: amavisd 2.3.0 sql lookups - INFO: unknown banned table name 1

[Charles X.M. <me...@ch...>]

thanks, i think this is the problem.

i had this in my amavisd.conf:

# new-style of banned lookup table
$banned_namepath_re = new_RE(
   # block these MIME types
   qr'(?#NO X-MSDOWNLOAD)   ^(.*\t)? M=application/x-msdownload   
(\t.*)? $'xmi,
   qr'(?#NO X-MSDOS-PROGRAM)^(.*\t)? 
M=application/x-msdos-program(\t.*)? $'xmi,
   qr'(?#NO HTA)            ^(.*\t)? M=application/hta            
(\t.*)? $'xmi,
   [ qr'(?#rule-4) ^ (.*\t)? T=(tar|rpm|cpio) (\t.*)? $'xmi => 0 ],  # 
allow
   qr'(?# BLOCK DOUBLE-EXTENSIONS )
      ^ (.*\t)? N= [^\t\n]* \. [^./\t\n]* [A-Za-z] [^./\t\n]* \.
                   (exe|vbs|pif|scr|bat|cmd|com|cpl|dll) \.? (\t.*)? 
$'xmi,
   qr'(?# BLOCK COMMON NAME EXENSIONS )
      ^ (.*\t)? N= [^\t\n]* \. (exe|vbs|pif|scr|bat|com|cpl) (\t.*)? 
$'xmi,
   [ qr'(?# BLOCK EMPTY MIME PART APPLICATION/OCTET-STREAM )
        ^ (.*\t)? M=application/octet-stream \t(.*\t)* T=empty (\t.*)? 
$'xmi
     => 'DISCARD' ],
   qr'(?# BLOCK Microsoft EXECUTABLES )
      ^ (.*\t)? T=exe-ms (\t.*)? $'xm,
);
$banned_filename_re = new_RE(
   
qr'\.[^./]*[A-Za-z][^./]*\.(exe|vbs|pif|scr|bat|cmd|com|cpl|dll)\.?$'i,
   qr'^application/x-msdownload$'i,
   qr'^application/x-msdos-program$'i,
   qr'^application/hta$'i,
   qr'.\.(exe|vbs|pif|scr|bat|cmd|com|cpl)$'i,
   qr'^\.(exe-ms)$',
);
@banned_filename_maps = (\$banned_filename_re);  # traditional


changing to:
@banned_filename_maps = ();   # to disable old-style

gives me this:
Apr 26 12:05:58 kingpin amavis[27833]: (27833-01) Checking for banned 
types and filenames
Apr 26 12:05:58 kingpin amavis[27833]: (27833-01) 
lookup_sql_field(bypass_banned_checks) "me...@ch..." result=0
Apr 26 12:05:58 kingpin amavis[27833]: (27833-01) lookup 
(bypass_banned_checks) => false, "me...@ch..." matches, 
result="0", matching_key="/cached/"
Apr 26 12:05:58 kingpin amavis[27833]: (27833-01) 
lookup_sql_field(banned_rulenames), no field, "me...@ch..." 
result=undef
Apr 26 12:05:58 kingpin amavis[27833]: (27833-01) lookup 
(banned_filename) => undef, "me...@ch..." does not match
Apr 26 12:05:58 kingpin amavis[27833]: (27833-01) starting banned 
checks - traversing message structure tree
Apr 26 12:05:58 kingpin amavis[27833]: (27833-01) check_for_banned 
(p001) text/plain,.asc
Apr 26 12:05:58 kingpin amavis[27833]: (27833-01) lookup 
(banned_namepath_re) => undef, "P=p001\tL=1\tM=text/plain\tT=asc" does 
not match
Apr 26 12:05:58 kingpin amavis[27833]: (27833-01) banned check: any=0, 
all=N (1)

getting rid of the INFO: unknown banned table name 1 entry.
does this seem right?

thanks again
-charles



On Apr 26, 2005, at 11:20 AM, ama...@li... 
wrote:

> Message: 10
> From: Mark Martinec <Mar...@ij...>
> Organization: J. Stefan Institute
> To: ama...@li...
> Subject: Re: [AMaViS-user] amavisd 2.3.0 sql lookups - INFO: unknown 
> banned table name 1
> Date: Tue, 26 Apr 2005 15:34:42 +0200
>
> Charles,
>
>> i updated to amavisd 2.3.0 on mac os x server 10.3.9
>> last night and everything seems fine, except for this
>> message: INFO: unknown banned table name 1
>
> Is your @banned_filename_maps left at its default,
> or are you assigning it in amavisd.conf ?
>
> Show lines containing string 'banned' from your level 5 log.
>
>   Mark
charles x. morrissey
me...@ch...