Spamsnake - Problem with spamassassin, FuzzyOcr and MySQL

Discussion in 'HOWTO-Related Questions' started by debuguser, Sep 14, 2008.

  1. debuguser

    debuguser New Member

    Good morning,

    I have some problems when try to install Spamsnake. I have few issues with spamassassin, FuzzyOcr and maybe with sa_bayes from MySQL. Here I joint my Spamassin lint test. Any helps are very much appreciated.

    Thanks

    [5971] dbg: logger: adding facilities: all 0
    [5971] dbg: logger: logging level is DBG 0.00015
    [5971] dbg: generic: SpamAssassin version 3.2.4 7.0E-5
    [5971] dbg: config: score set 0 chosen. 0.00129
    [5971] dbg: util: running in taint mode? yes 0.00068
    [5971] dbg: util: taint mode: deleting unsafe environment variables, resetting PATH 0.00013
    [5971] dbg: util: PATH included '/usr/local/bin', keeping 0.00021
    [5971] dbg: util: PATH included '/usr/bin', keeping 0.00013
    [5971] dbg: util: PATH included '/bin', keeping 0.00012
    [5971] dbg: util: final PATH set to: /usr/local/bin:/usr/bin:/bin 0.00013
    [5971] dbg: dns: is Net::DNS::Resolver available? yes 0.00826
    [5971] dbg: dns: Net::DNS version: 0.63 0.00015
    [5971] dbg: diag: perl platform: 5.008008 linux 0.7243
    [5971] dbg: diag: module installed: Digest::SHA1, version 2.11 0.00014
    [5971] dbg: diag: module installed: HTML::parser, version 3.56 6.0E-5
    [5971] dbg: diag: module installed: Net::DNS, version 0.63 5.0E-5
    [5971] dbg: diag: module installed: MIME::Base64, version 3.07 6.0E-5
    [5971] dbg: diag: module installed: DB_File, version 1.814 6.0E-5
    [5971] dbg: diag: module installed: Net::SMTP, version 2.31 7.0E-5
    [5971] dbg: diag: module installed: Mail::SPF, version v2.005 6.0E-5
    [5971] dbg: diag: module installed: Mail::SPF::Query, version 1.999001 6.0E-5
    [5971] dbg: diag: module installed: IP::Country::Fast, version 604.001 6.0E-5
    [5971] dbg: diag: module installed: Razor2::Client::Agent, version 2.84 7.0E-5
    [5971] dbg: diag: module installed: Net::Ident, version 1.20 0.00032
    [5971] dbg: diag: module installed: IO::Socket::INET6, version 2.54 0.00013
    [5971] dbg: diag: module installed: IO::Socket::SSL, version 1.15 7.0E-5
    [5971] dbg: diag: module installed: Compress::Zlib, version 2.008 6.0E-5
    [5971] dbg: diag: module installed: Time::HiRes, version 1.86 6.0E-5
    [5971] dbg: diag: module installed: Mail::DomainKeys, version 1.0 5.0E-5
    [5971] dbg: diag: module installed: Mail::DKIM, version 0.32 6.0E-5
    [5971] dbg: diag: module installed: DBI, version 1.607 6.0E-5
    [5971] dbg: diag: module installed: Getopt::Long, version 2.35 6.0E-5
    [5971] dbg: diag: module installed: LWP::UserAgent, version 2.036 7.0E-5
    [5971] dbg: diag: module installed: HTTP::Date, version 1.47 6.0E-5
    [5971] dbg: diag: module installed: Archive::Tar, version 1.36 7.0E-5
    [5971] dbg: diag: module installed: IO::Zlib, version 1.04 5.0E-5
    [5971] dbg: diag: module installed: Encode::Detect, version 1.01 6.0E-5
    [5971] dbg: ignore: using a test message to lint rules 6.0E-5
    [5971] dbg: config: using "/etc/spamassassin" for site rules pre files 6.0E-5
    [5971] dbg: config: read file /etc/spamassassin/init.pre 0.0001
    [5971] dbg: config: read file /etc/spamassassin/v310.pre 0.00041
    [5971] dbg: config: read file /etc/spamassassin/v312.pre 0.00028
    [5971] dbg: config: read file /etc/spamassassin/v320.pre 0.0003
    [5971] dbg: config: using "/usr/share/spamassassin" for sys rules pre files 0.00021
    [5971] dbg: config: using "/usr/share/spamassassin" for default rules dir 0.00038
    [5971] dbg: config: read file /usr/share/spamassassin/10_default_prefs.cf 0.0013
    [5971] dbg: config: read file /usr/share/spamassassin/20_advance_fee.cf 0.00049
    [5971] dbg: config: read file /usr/share/spamassassin/20_body_tests.cf 0.00052
    [5971] dbg: config: read file /usr/share/spamassassin/20_compensate.cf 0.00037
    [5971] dbg: config: read file /usr/share/spamassassin/20_dnsbl_tests.cf 0.00083
    [5971] dbg: config: read file /usr/share/spamassassin/20_drugs.cf 0.00089
    [5971] dbg: config: read file /usr/share/spamassassin/20_dynrdns.cf 0.00068
    [5971] dbg: config: read file /usr/share/spamassassin/20_fake_helo_tests.cf 0.00054
    [5971] dbg: config: read file /usr/share/spamassassin/20_head_tests.cf 0.00126
    [5971] dbg: config: read file /usr/share/spamassassin/20_html_tests.cf 0.001
    [5971] dbg: config: read file /usr/share/spamassassin/20_imageinfo.cf 0.00049
    [5971] dbg: config: read file /usr/share/spamassassin/20_meta_tests.cf 0.00036
    [5971] dbg: config: read file /usr/share/spamassassin/20_net_tests.cf 0.00032
    [5971] dbg: config: read file /usr/share/spamassassin/20_phrases.cf 0.00057
    [5971] dbg: config: read file /usr/share/spamassassin/20_porn.cf 0.00034
    [5971] dbg: config: read file /usr/share/spamassassin/20_ratware.cf 0.00078
    [5971] dbg: config: read file /usr/share/spamassassin/20_uri_tests.cf 0.00047
    [5971] dbg: config: read file /usr/share/spamassassin/20_vbounce.cf 0.00086
    [5971] dbg: config: read file /usr/share/spamassassin/23_bayes.cf 0.0004
    [5971] dbg: config: read file /usr/share/spamassassin/25_accessdb.cf 0.00027
    [5971] dbg: config: read file /usr/share/spamassassin/25_antivirus.cf 0.00037
    [5971] dbg: config: read file /usr/share/spamassassin/25_asn.cf 0.00027
    [5971] dbg: config: read file /usr/share/spamassassin/25_dcc.cf 0.00036
    [5971] dbg: config: read file /usr/share/spamassassin/25_dkim.cf 0.0003
    [5971] dbg: config: read file /usr/share/spamassassin/25_domainkeys.cf 0.00034
    [5971] dbg: config: read file /usr/share/spamassassin/25_hashcash.cf 0.00029
    [5971] dbg: config: read file /usr/share/spamassassin/25_pyzor.cf 0.00028
    [5971] dbg: config: read file /usr/share/spamassassin/25_razor2.cf 0.00033
    [5971] dbg: config: read file /usr/share/spamassassin/25_replace.cf 0.00056
    [5971] dbg: config: read file /usr/share/spamassassin/25_spf.cf 0.00039
    [5971] dbg: config: read file /usr/share/spamassassin/25_textcat.cf 0.00027
    [5971] dbg: config: read file /usr/share/spamassassin/25_uribl.cf 0.00046
    [5971] dbg: config: read file /usr/share/spamassassin/30_text_de.cf 0.00113
    [5971] dbg: config: read file /usr/share/spamassassin/30_text_fr.cf 0.00154
    [5971] dbg: config: read file /usr/share/spamassassin/30_text_it.cf 0.00046
    [5971] dbg: config: read file /usr/share/spamassassin/30_text_nl.cf 0.0009
    [5971] dbg: config: read file /usr/share/spamassassin/30_text_pl.cf 0.00093
    [5971] dbg: config: read file /usr/share/spamassassin/30_text_pt_br.cf 0.00047
    [5971] dbg: config: read file /usr/share/spamassassin/50_scores.cf 0.00245
    [5971] dbg: config: read file /usr/share/spamassassin/60_awl.cf 0.00072
    [5971] dbg: config: read file /usr/share/spamassassin/60_shortcircuit.cf 0.00032
    [5971] dbg: config: read file /usr/share/spamassassin/60_whitelist.cf 0.00043
    [5971] dbg: config: read file /usr/share/spamassassin/60_whitelist_dk.cf 0.00032
    [5971] dbg: config: read file /usr/share/spamassassin/60_whitelist_dkim.cf 0.00032
    [5971] dbg: config: read file /usr/share/spamassassin/60_whitelist_spf.cf 0.00036
    [5971] dbg: config: read file /usr/share/spamassassin/60_whitelist_subject.cf 0.0003
    [5971] dbg: config: read file /usr/share/spamassassin/72_active.cf 0.00673
    [5971] dbg: config: using "/etc/spamassassin" for site rules dir 0.00397
    [5971] dbg: config: read file /etc/spamassassin/65_debian.cf 0.00047
    [5971] dbg: config: read file /etc/spamassassin/FuzzyOcr.cf 0.00087
    [5971] dbg: config: mkdir /var/www/.spamassassin failed: mkdir /var/www/.spamassassin: Permission denied at /usr/share/perl5/Mail/SpamAssassin.pm line 1577 0.00332
    [5971] dbg: config: Permission denied 0.00015

    [5971] dbg: config: using "/etc/MailScanner/spam.assassin.prefs.conf" for user prefs file 8.0E-5
    [5971] dbg: config: read file /etc/MailScanner/spam.assassin.prefs.conf 0.00067
    [5971] dbg: plugin: loading Mail::SpamAssassin::plugin::URIDNSBL from @INC 0.02292
    [5971] dbg: plugin: loading Mail::SpamAssassin::plugin::Hashcash from @INC 0.008
    [5971] dbg: plugin: loading Mail::SpamAssassin::plugin::SPF from @INC 0.00353
    [5971] dbg: plugin: loading Mail::SpamAssassin::plugin::pyzor from @INC 0.00639
    [5971] dbg: pyzor: local tests only, disabling Pyzor 0.00325
    [5971] dbg: plugin: loading Mail::SpamAssassin::plugin::Razor2 from @INC 0.00043
    [5971] dbg: razor2: local tests only, skipping Razor 0.0035
    [5971] dbg: plugin: loading Mail::SpamAssassin::plugin::SpamCop from @INC 0.00051
    [5971] dbg: reporter: local tests only, disabling SpamCop 0.00434
    [5971] dbg: plugin: loading Mail::SpamAssassin::plugin::AWL from @INC 0.0004
    [5971] dbg: plugin: loading Mail::SpamAssassin::plugin::AutoLearnThreshold from @INC 0.00462
    [5971] dbg: plugin: loading Mail::SpamAssassin::plugin::WhiteListSubject from @INC 0.00192
    [5971] dbg: plugin: loading Mail::SpamAssassin::plugin::MIMEHeader from @INC 0.00188
    [5971] dbg: plugin: loading Mail::SpamAssassin::plugin::ReplaceTags from @INC 0.00216
    [5971] dbg: plugin: loading Mail::SpamAssassin::plugin::Check from @INC 0.00288
    [5971] dbg: plugin: loading Mail::SpamAssassin::plugin::HTTPSMismatch from @INC 0.00849
    [5971] dbg: plugin: loading Mail::SpamAssassin::plugin::URIDetail from @INC 0.00177
    [5971] dbg: plugin: loading Mail::SpamAssassin::plugin::Bayes from @INC 0.00275
    [5971] dbg: plugin: loading Mail::SpamAssassin::plugin::BodyEval from @INC 0.0013
    [5971] dbg: plugin: loading Mail::SpamAssassin::plugin::DNSEval from @INC 0.00311
    [5971] dbg: plugin: loading Mail::SpamAssassin::plugin::HTMLEval from @INC 0.00385
    [5971] dbg: plugin: loading Mail::SpamAssassin::plugin::HeaderEval from @INC 0.00339
    [5971] dbg: plugin: loading Mail::SpamAssassin::plugin::MIMEEval from @INC 0.01048
    [5971] dbg: plugin: loading Mail::SpamAssassin::plugin::RelayEval from @INC 0.00484
    [5971] dbg: plugin: loading Mail::SpamAssassin::plugin::URIEval from @INC 0.00454
    [5971] dbg: plugin: loading Mail::SpamAssassin::plugin::WLBLEval from @INC 0.00168
    [5971] dbg: plugin: loading Mail::SpamAssassin::plugin::VBounce from @INC 0.00318
    [5971] dbg: plugin: loading Mail::SpamAssassin::plugin::ImageInfo from @INC 0.00197
    [5971] dbg: config: fixed relative path: /etc/spamassassin/FuzzyOcr.pm 0.40283
    [5971] dbg: plugin: loading FuzzyOcr from /etc/spamassassin/FuzzyOcr.pm 0.00024
    Subroutine FuzzyOcr::O_NONBLOCK redefined at /usr/share/perl/5.8/Exporter.pm line 65. 0.01767
    at /usr/lib/perl/5.8/POSIX.pm line 19 0.00013
    [5971] warn: Bareword found where operator expected at /etc/spamassassin/FuzzyOcr.pm line 131, near "my $msgid = $pms->get('Message" 0.00089
    [5971] warn: (Might be a runaway multi-line '' string starting on line 20) 0.00016
    [5971] warn: (Do you need to predeclare my?) 7.0E-5
    [5971] warn: plugin: failed to parse plugin /etc/spamassassin/FuzzyOcr.pm: Bad name after Id' at /etc/spamassassin/FuzzyOcr.pm line 131. 8.0E-5
    [5971] warn: Compilation failed in require at /usr/share/perl5/Mail/SpamAssassin/PluginHandler.pm line 107. 6.0E-5
    [5971] warn: config: failed to parse line, skipping, in "/etc/spamassassin/FuzzyOcr.cf": focr_logfile /var/log/FuzzyOcr.log 0.00211
    [5971] warn: config: failed to parse line, skipping, in "/etc/spamassassin/FuzzyOcr.cf": focr_global_wordlist /etc/mail/spamassassin/FuzzyOcr.words 0.00029
    [5971] warn: config: failed to parse line, skipping, in "/etc/spamassassin/FuzzyOcr.cf": focr_bin_helper pnmnorm, pnminvert, convert, ppmtopgm, tesseract 0.00046
    [5971] warn: config: failed to parse line, skipping, in "/etc/spamassassin/FuzzyOcr.cf": focr_path_bin /usr/local/netpbm/bin:/usr/local/bin:/usr/bin 0.00026
    [5971] warn: config: failed to parse line, skipping, in "/etc/spamassassin/FuzzyOcr.cf": focr_preprocessor_file /etc/mail/spamassassin/FuzzyOcr.preps 0.00036
    [5971] warn: config: failed to parse line, skipping, in "/etc/spamassassin/FuzzyOcr.cf": focr_scanset_file /etc/mail/spamassassin/FuzzyOcr.scansets 0.00018
    [5971] warn: config: failed to parse line, skipping, in "/etc/spamassassin/FuzzyOcr.cf": focr_minimal_scanset 1 0.00025
    [5971] warn: config: failed to parse line, skipping, in "/etc/spamassassin/FuzzyOcr.cf": focr_autosort_scanset 1 0.00033
    [5971] warn: config: failed to parse line, skipping, in "/etc/spamassassin/FuzzyOcr.cf": focr_enable_image_hashing 3 0.00091
    [5971] warn: config: failed to parse line, skipping, in "/etc/spamassassin/FuzzyOcr.cf": focr_digest_db /etc/mail/spamassassin/FuzzyOcr.hashdb 0.0004
    [5971] warn: config: failed to parse line, skipping, in "/etc/spamassassin/FuzzyOcr.cf": focr_db_hash /etc/mail/spamassassin/FuzzyOcr.db 0.00026
    [5971] warn: config: failed to parse line, skipping, in "/etc/spamassassin/FuzzyOcr.cf": focr_db_safe /etc/mail/spamassassin/FuzzyOcr.safe.db 0.00023
    [5971] warn: config: failed to parse line, skipping, in "/etc/spamassassin/FuzzyOcr.cf": focr_mysql_db FuzzyOcr 0.00026
    [5971] warn: config: failed to parse line, skipping, in "/etc/spamassassin/FuzzyOcr.cf": focr_mysql_hash Hash 0.00018
    [5971] warn: config: failed to parse line, skipping, in "/etc/spamassassin/FuzzyOcr.cf": focr_mysql_safe Safe 0.00019
    [5971] warn: config: failed to parse line, skipping, in "/etc/spamassassin/FuzzyOcr.cf": focr_mysql_user fuzzyocr 0.00019
    [5971] warn: config: failed to parse line, skipping, in "/etc/spamassassin/FuzzyOcr.cf": focr_mysql_pass fuzzyocr 0.0002
    [5971] warn: config: failed to parse line, skipping, in "/etc/spamassassin/FuzzyOcr.cf": focr_mysql_host localhost 0.00019
    [5971] warn: config: failed to parse line, skipping, in "/etc/spamassassin/FuzzyOcr.cf": focr_mysql_port 3306 0.00022
    [5971] warn: config: failed to parse line, skipping, in "/etc/spamassassin/FuzzyOcr.cf": focr_mysql_socket /var/run/mysqld/mysql.sock 0.00019
    [5971] warn: config: failed to parse line, skipping, in "/etc/spamassassin/FuzzyOcr.cf": focr_end_config 0.00036
    [5971] warn: config: failed to parse line, skipping, in "/etc/MailScanner/spam.assassin.prefs.conf": bayes_sql_dns DBI:mysql:SPAM_bayes:localhost 0.00041
    [5971] dbg: rules: __MO_OL_9B90B merged duplicates: __MO_OL_C65FA 0.16735
    [5971] dbg: rules: __XM_OL_22B61 merged duplicates: __XM_OL_A842E 0.00015
    [5971] dbg: rules: __MO_OL_07794 merged duplicates: __MO_OL_8627E __MO_OL_F3B05 0.00014
    [5971] dbg: rules: __XM_OL_07794 merged duplicates: __XM_OL_25340 __XM_OL_3857F __XM_OL_4F240 __XM_OL_58CB5 __XM_OL_6554A __XM_OL_812FF __XM_OL_C65FA __XM_OL_CF0C0 __XM_OL_F475E __XM_OL_F6D01 0.00022
    [5971] dbg: rules: FH_MSGID_01C67 merged duplicates: __MSGID_VGA 0.00013
    [5971] dbg: rules: FS_NEW_SOFT_UPLOAD merged duplicates: HS_SUBJ_NEW_SOFTWARE 0.00014
    [5971] dbg: rules: __FH_HAS_XMSMAIL merged duplicates: __HAS_MSMAIL_PRI 0.00013
    [5971] dbg: rules: __MO_OL_015D5 merged duplicates: __MO_OL_6554A 0.00013
    [5971] dbg: rules: __XM_OL_015D5 merged duplicates: __XM_OL_4BF4C __XM_OL_4EEDB __XM_OL_5B79A __XM_OL_9B90B __XM_OL_ADFF7 __XM_OL_B30D1 __XM_OL_B4B40 __XM_OL_BC7E6 __XM_OL_F3B05 __XM_OL_FF5C8 0.0002
    [5971] dbg: rules: __MO_OL_91287 merged duplicates: __MO_OL_B30D1 __MO_OL_CF0C0 0.00014
    [5971] dbg: rules: KAM_STOCKOTC merged duplicates: KAM_STOCKTIP15 KAM_STOCKTIP20 KAM_STOCKTIP21 KAM_STOCKTIP4 KAM_STOCKTIP6 0.0002
    [5971] dbg: rules: __MO_OL_22B61 merged duplicates: __MO_OL_4F240 __MO_OL_ADFF7 0.00015
    [5971] dbg: rules: __MO_OL_812FF merged duplicates: __MO_OL_BC7E6 0.00014
    [5971] dbg: rules: __MO_OL_25340 merged duplicates: __MO_OL_4EEDB __MO_OL_7533E 0.00015
    [5971] dbg: rules: __MO_OL_58CB5 merged duplicates: __MO_OL_B4B40 0.00014
    [5971] dbg: rules: __DOS_HAS_ANY_URI merged duplicates: __HAS_ANY_URI 0.00015
    [5971] dbg: rules: __XM_OL_C9068 merged duplicates: __XM_OL_EF20B 0.00013
    [5971] dbg: rules: __MO_OL_72641 merged duplicates: __MO_OL_A842E 0.00013
    [5971] dbg: rules: FUZZY_OCR_CORRUPT_IMG merged duplicates: :mad:FUZZY_OCR_KNOWN_HASH FUZZY_OCR_WRONG_CTYPE :mad:FUZZY_OCR_WRONG_EXTENSION 0.00017
    [5971] dbg: rules: __MO_OL_F475E merged duplicates: __MO_OL_FF5C8 0.00015
    [5971] dbg: rules: __MO_OL_4BF4C merged duplicates: __MO_OL_F6D01 0.00021
    [5971] dbg: conf: finish parsing 0.00105
    [5971] dbg: plugin: Mail::SpamAssassin::plugin::ReplaceTags=HASH(0x970d4f8) implements 'finish_parsing_end', priority 0 0.02245
    [5971] dbg: replacetags: replacing tags 0.00033
    [5971] dbg: replacetags: done replacing tags 0.01952
    [5971] dbg: bayes: invalid config, must set bayes_sql_dsn config variable 0.03016
    Can't call method "tie_db_readonly" on an undefined value at /usr/share/perl5/Mail/SpamAssassin/Bayes.pm line 1123.
     
  2. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    What's the output of
    Code:
    ls -la /var/www
    ?

    As what user did you run this command?
     
  3. debuguser

    debuguser New Member

    Please see belo
    1.
    drwxr-xr-x 4 root root 4096 2008-09-13 04:10 .
    drwxr-xr-x 16 root root 4096 2008-09-12 23:20 ..
    drwxr-xr-x 2 root root 4096 2008-06-25 09:59 apache2-default
    -rw-r--r-- 1 root root 45 2008-09-12 23:17 index.html
    drwxr-xr-x 9 root root 4096 2008-09-14 00:39 mailscanner

    2. I run as root to do these commands

    Thank Falko,
     
  4. Rocky

    Rocky New Member

    Hey,

    Please recheck the FuzzyOcr section to make sure that you completed each and every step.
     
  5. debuguser

    debuguser New Member

    This error is popup on the terminal every half hour if no activity

    Commit ineffective with AutoComit enabled at /etc/MailScanner/CustomFunctions/MailWatch.pm line 93

    I am able to log and use MailWatch but don't why I have this error. Please help.

    Thanks
     
  6. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

  7. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

Share This Page