| 1 | package Mail::SpamAssassin::Plugin::DBSCORE; | ||
| 2 | # ABSTRACT: Spamassassin scores from database | ||
| 3 | $Mail::SpamAssassin::Plugin::DBSCORE::VERSION = '1.250650'; | ||
| 4 | use strict; | ||
| 5 | use warnings; | ||
| 6 | |||
| 7 | use Mail::SpamAssassin::Plugin; | ||
| 8 | use DBI; | ||
| 9 | |||
| 10 | our @ISA = qw(Mail::SpamAssassin::Plugin); | ||
| 11 | |||
| 12 | sub new { | ||
| 13 | my $class = shift; | ||
| 14 | my $mailsaobject = shift; | ||
| 15 | $class = ref($class) || $class; | ||
| 16 | my $self = $class->SUPER::new($mailsaobject); | ||
| 17 | bless ($self, $class); | ||
| 18 | $self->register_eval_rule("DBSCORE"); | ||
| 19 | |||
| 20 | $mailsaobject->{conf}->{parser}->register_commands( [ | ||
| 21 | { | ||
| 22 | setting => 'dbscore_dsn', | ||
| 23 | type => $Mail::SpamAssassin::Conf::CONF_TYPE_STRING, | ||
| 24 | default => 'DBI:MariaDB:database=dbscore;host=127.0.0.1;port=3306', | ||
| 25 | }, { | ||
| 26 | setting => 'dbscore_db_user', | ||
| 27 | type => $Mail::SpamAssassin::Conf::CONF_TYPE_STRING, | ||
| 28 | default => 'dbscore', | ||
| 29 | }, { | ||
| 30 | setting => 'dbscore_db_pass', | ||
| 31 | type => $Mail::SpamAssassin::Conf::CONF_TYPE_STRING, | ||
| 32 | default => 'dbscore', | ||
| 33 | } | ||
| 34 | ] ); | ||
| 35 | |||
| 36 | |||
| 37 | return $self; | ||
| 38 | } | ||
| 39 | |||
| 40 | |||
| 41 | sub DBSCORE{ | ||
| 42 | my ($self, $pms, $fulltext) = @_; | ||
| 43 | |||
| 44 | my $dbh = DBI->connect($pms->{conf}->{dbscore_dsn}, $pms->{conf}->{dbscore_db_user}, $pms->{conf}->{dbscore_db_pass}); | ||
| 45 | |||
| 46 | my $fromhost = $pms->get('From:addr:host'); | ||
| 47 | my $from = $pms->get('From:addr:first'); | ||
| 48 | |||
| 49 | my $score = 0; | ||
| 50 | my $domainscore = 0; | ||
| 51 | |||
| 52 | my $sth = $dbh->prepare('SELECT score FROM senders WHERE sender = ?'); | ||
| 53 | $sth->execute($from); | ||
| 54 | |||
| 55 | my $data = $sth->fetchrow_hashref; | ||
| 56 | |||
| 57 | if($data->{score}){ | ||
| 58 | $score = $data->{score}; | ||
| 59 | } | ||
| 60 | |||
| 61 | $sth = $dbh->prepare('SELECT score FROM domains WHERE domain = ?'); | ||
| 62 | $sth->execute($fromhost); | ||
| 63 | |||
| 64 | $data = $sth->fetchrow_hashref; | ||
| 65 | |||
| 66 | if($data->{score}){ | ||
| 67 | $domainscore = $data->{score}; | ||
| 68 | } | ||
| 69 | |||
| 70 | $score = $score + $domainscore; | ||
| 71 | |||
| 72 | if($score) { | ||
| 73 | $pms->got_hit("DBSCORE", "HEADER: ", score => $score); | ||
| 74 | for my $set (0..3) { | ||
| 75 | $pms->{conf}->{scoreset}->[$set]->{"DBSCORE"} = sprintf("%0.3f", $score); | ||
| 76 | } | ||
| 77 | } | ||
| 78 | |||
| 79 | $dbh->disconnect; | ||
| 80 | |||
| 81 | return 0; | ||
| 82 | } | ||
| 83 | |||
| 84 | __END__ |