Re: [AMaViS-user] p0f & sql

Mark Martinec wrote the following on 17/10/2006 13:51:
> Alan,
>
>> Has anyone posted information on how to update the (my)sql tables to
>> support p0f?
>
> You mean how to store p0f fingerprint to SQL logging database?
>
> Try the following:
>
> - add a field 'p0f' to table msgs:
> ALTER TABLE msgs ADD p0f varchar(255) DEFAULT '';
>
> - and apply the following change to amavisd:
>
== deleted==

Well actually I wasn't. But I like the idea of saving the information and will add the patch.

I was checking if a field needs to be added to the policy table so that sql_select_policy would handle os_fingerprint_method as required.

thanks

Alan

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=...057&dat=121642
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/...fo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/