C
cpedv
Guest
Hallo nach dem einrichten des FuzzyOcr bekomme eine Fehlermeldung das er sich nicht in die Datenbank einklinken kann:
Zeile 177 ist:
Hier mal den ganzen Testlauf:
Zudem verwirt mich da was, ich habe mein spamassassin in etc/spamassassin und nicht in /etc/mail/spamassassin/ was die Installation oder Konfiguration immer voraus gibt, im der Anleitung hier:
HowtoForge Linux Tutorials Image Spam mit FuzzyOCR und SpamAssassin auf Debian/Ubuntu abwehren
wird auch immer von /etc/mail/spamassassin/ gesprochen.
Ich habe alles auf /etc/spamassassin/ angepasst.
Mein System ist Debian Lenny 5.0
Danke im Voraus.
gruss Gero
Code:
warn: DBI connect('database=FuzzyOcr;host=localhost','fuzzyocr',...) failed: Access denied for user 'fuzzyocr'@'localhost' (using password: YES) at /etc/spamassassin/FuzzyOcr/Config.pm line 177
Zeile 177 ist:
Code:
[B]my $ddb = DBI->connect($dsn,[/B] (Zeile 177)
$conf->{focr_mysql_user},
$conf->{focr_mysql_pass},
\%dopts);
return $ddb;
Hier mal den ganzen Testlauf:
Code:
[9437] dbg: FuzzyOcr: line: args = -color -truecolor
[9437] dbg: FuzzyOcr: line: }
[9437] info: FuzzyOcr: Starting scanset parser for file "/etc/spamassassin/FuzzyOcr.scansets"...
[9437] dbg: FuzzyOcr: line scanset ocrad {
[9437] dbg: FuzzyOcr: line command = $ocrad
[9437] dbg: FuzzyOcr: line args = -s5 $input
[9437] dbg: FuzzyOcr: line }
[9437] dbg: FuzzyOcr: line scanset ocrad-invert {
[9437] dbg: FuzzyOcr: line command = $ocrad
[9437] dbg: FuzzyOcr: line args = -s5 -i $input
[9437] dbg: FuzzyOcr: line }
[9437] dbg: FuzzyOcr: line scanset ocrad-decolorize-invert {
[9437] dbg: FuzzyOcr: line preprocessors = ppmtopgm, pamthreshold, pamtopnm
[9437] dbg: FuzzyOcr: line command = $ocrad
[9437] dbg: FuzzyOcr: line args = -s5 -i $input
[9437] dbg: FuzzyOcr: line }
[9437] dbg: FuzzyOcr: line scanset ocrad-decolorize {
[9437] dbg: FuzzyOcr: line preprocessors = ppmtopgm, pamthreshold, pamtopnm
[9437] dbg: FuzzyOcr: line command = $ocrad
[9437] dbg: FuzzyOcr: line args = -s5 $input
[9437] dbg: FuzzyOcr: line }
[9437] dbg: FuzzyOcr: line scanset gocr {
[9437] dbg: FuzzyOcr: line command = $gocr
[9437] dbg: FuzzyOcr: line args = -i $input
[9437] dbg: FuzzyOcr: line }
[9437] dbg: FuzzyOcr: line scanset gocr-180 {
[9437] dbg: FuzzyOcr: line command = $gocr
[9437] dbg: FuzzyOcr: line args = -l 180 -d 2 -i $input
[9437] dbg: FuzzyOcr: line }
[9437] info: config: failed to parse line, skipping, in "/etc/spamassassin/local.cf": use_dcc 1
[9437] info: config: failed to parse, now a plugin, skipping, in "/etc/spamassassin/local.cf": ok_languages all
[9437] info: FuzzyOcr: Searching in: /usr/local/netpbm/bin
[9437] info: FuzzyOcr: Searching in: /usr/local/bin
[9437] info: FuzzyOcr: Searching in: /usr/bin
[9437] info: FuzzyOcr: Using gifsicle => /usr/bin/gifsicle
[9437] info: FuzzyOcr: Using giffix => /usr/bin/giffix
[9437] info: FuzzyOcr: Using giftext => /usr/bin/giftext
[9437] info: FuzzyOcr: Using gifinter => /usr/bin/gifinter
[9437] info: FuzzyOcr: Using giftopnm => /usr/bin/giftopnm
[9437] info: FuzzyOcr: Using jpegtopnm => /usr/bin/jpegtopnm
[9437] info: FuzzyOcr: Using pngtopnm => /usr/bin/pngtopnm
[9437] info: FuzzyOcr: Using bmptopnm => /usr/bin/bmptopnm
[9437] info: FuzzyOcr: Using tifftopnm => /usr/bin/tifftopnm
[9437] info: FuzzyOcr: Using ppmhist => /usr/bin/ppmhist
[9437] info: FuzzyOcr: Using pamfile => /usr/bin/pamfile
[9437] info: FuzzyOcr: Using ocrad => /usr/bin/ocrad
[9437] info: FuzzyOcr: Using gocr => /usr/bin/gocr
[9437] info: FuzzyOcr: Using pnmnorm => /usr/bin/pnmnorm
[9437] info: FuzzyOcr: Using pnminvert => /usr/bin/pnminvert
[9437] info: FuzzyOcr: Using convert => /usr/bin/convert
[9437] info: FuzzyOcr: Using ppmtopgm => /usr/bin/ppmtopgm
[9437] info: FuzzyOcr: Using tesseract => /usr/bin/tesseract
[9437] dbg: FuzzyOcr: Threshold[max_hash] => 5
[9437] dbg: FuzzyOcr: Threshold[c] => 5
[9437] dbg: FuzzyOcr: Threshold[s] => 0.01
[9437] dbg: FuzzyOcr: Threshold[w] => 0.01
[9437] dbg: FuzzyOcr: Threshold[h] => 0.01
[9437] dbg: FuzzyOcr: Threshold[cn] => 0.01
[9437] dbg: FuzzyOcr: focr_add_score => 1
[9437] dbg: FuzzyOcr: focr_autodisable_negative_score => -5
[9437] dbg: FuzzyOcr: focr_autodisable_score => 1000
[9437] dbg: FuzzyOcr: focr_autosort_buffer => 10
[9437] dbg: FuzzyOcr: focr_autosort_scanset => 1
[9437] dbg: FuzzyOcr: focr_base_score => 5
[9437] dbg: FuzzyOcr: focr_corrupt_score => 2.5
[9437] dbg: FuzzyOcr: focr_corrupt_unfixable_score => 5
[9437] dbg: FuzzyOcr: focr_counts_required => 2
[9437] dbg: FuzzyOcr: focr_db_hash => /etc/spamassassin/FuzzyOcr.db
[9437] dbg: FuzzyOcr: focr_db_max_days => 35
[9437] dbg: FuzzyOcr: focr_db_safe => /etc/spamassassin/FuzzyOcr.safe.db
[9437] dbg: FuzzyOcr: focr_digest_db => /etc/spamassassin/FuzzyOcr.hashdb
[9437] dbg: FuzzyOcr: focr_enable_image_hashing => 3
[9437] dbg: FuzzyOcr: focr_global_timeout => 0
[9437] dbg: FuzzyOcr: focr_global_wordlist => /etc/spamassassin/FuzzyOcr.words
[9437] dbg: FuzzyOcr: focr_hashing_learn_scanned => 1
[9437] dbg: FuzzyOcr: focr_keep_bad_images => 0
[9437] dbg: FuzzyOcr: focr_log_pmsinfo => 1
[9437] dbg: FuzzyOcr: focr_log_stderr => 1
[9437] dbg: FuzzyOcr: focr_logfile => /var/log/FuzzyOcr.log
[9437] dbg: FuzzyOcr: focr_max_height => 800
[9437] dbg: FuzzyOcr: focr_max_width => 800
[9437] dbg: FuzzyOcr: focr_min_height => 4
[9437] dbg: FuzzyOcr: focr_min_width => 4
[9437] dbg: FuzzyOcr: focr_minimal_scanset => 1
[9437] dbg: FuzzyOcr: focr_mysql_db => FuzzyOcr
[9437] dbg: FuzzyOcr: focr_mysql_hash => Hash
[9437] dbg: FuzzyOcr: focr_mysql_host => localhost
[9437] dbg: FuzzyOcr: focr_mysql_port => 3306
[9437] dbg: FuzzyOcr: focr_mysql_safe => Safe
[9437] dbg: FuzzyOcr: focr_mysql_update_hash => 0
[9437] dbg: FuzzyOcr: focr_mysql_user => fuzzyocr
[9437] dbg: FuzzyOcr: focr_no_homedirs => 0
[9437] dbg: FuzzyOcr: focr_path_bin => /usr/local/netpbm/bin:/usr/local/bin:/usr/bin
[9437] dbg: FuzzyOcr: focr_personal_wordlist => __userstate__/FuzzyOcr.words
[9437] dbg: FuzzyOcr: focr_preprocessor_file => /etc/spamassassin/FuzzyOcr.preps
[9437] dbg: FuzzyOcr: focr_scanset_file => /etc/spamassassin/FuzzyOcr.scansets
[9437] dbg: FuzzyOcr: focr_score_ham => 0
[9437] dbg: FuzzyOcr: focr_skip_bmp => 0
[9437] dbg: FuzzyOcr: focr_skip_gif => 0
[9437] dbg: FuzzyOcr: focr_skip_jpeg => 0
[9437] dbg: FuzzyOcr: focr_skip_png => 0
[9437] dbg: FuzzyOcr: focr_skip_tiff => 0
[9437] dbg: FuzzyOcr: focr_skip_updates => 0
[9437] dbg: FuzzyOcr: focr_strip_numbers => 1
[9437] dbg: FuzzyOcr: focr_threshold => 0.25
[9437] dbg: FuzzyOcr: focr_timeout => 10
[9437] dbg: FuzzyOcr: focr_twopass_scoring_factor => 1.5
[9437] dbg: FuzzyOcr: focr_unique_matches => 0
[9437] dbg: FuzzyOcr: focr_verbose => 1
[9437] dbg: FuzzyOcr: focr_wrongctype_score => 1.5
[9437] dbg: FuzzyOcr: focr_wrongext_score => 1.5
[9437] info: FuzzyOcr: Loaded preprocessor normalize: /usr/bin/pnmnorm
[9437] info: FuzzyOcr: Loaded preprocessor invert: /usr/bin/pnminvert
[9437] info: FuzzyOcr: Loaded preprocessor ppmtopgm: /usr/bin/ppmtopgm
[9437] info: FuzzyOcr: Loaded preprocessor pamtopnm: pamtopnm
[9437] info: FuzzyOcr: Loaded preprocessor pamthreshold: pamthreshold -simple -threshold 0.5
[9437] info: FuzzyOcr: Loaded preprocessor maketiff: pnmtotiff -color -truecolor
[9437] info: FuzzyOcr: Using scan ocrad: /usr/bin/ocrad -s5 $input
[9437] info: FuzzyOcr: Using scan ocrad-invert: /usr/bin/ocrad -s5 -i $input
[9437] info: FuzzyOcr: Using scan ocrad-decolorize-invert: /usr/bin/ocrad -s5 -i $input
[9437] info: FuzzyOcr: Using scan ocrad-decolorize: /usr/bin/ocrad -s5 $input
[9437] info: FuzzyOcr: Using scan gocr: /usr/bin/gocr -i $input
[9437] info: FuzzyOcr: Using scan gocr-180: /usr/bin/gocr -l 180 -d 2 -i $input
[9437] info: FuzzyOcr: Importing for MLDBM databases not available (dependencies missing)
[9437] dbg: FuzzyOcr: Connecting to: dbi:mysql:database=FuzzyOcr;host=localhost
[9437] warn: DBI connect('database=FuzzyOcr;host=localhost','fuzzyocr',...) failed: Access denied for user 'fuzzyocr'@'localhost' (using password: YES) at /etc/spamassassin/FuzzyOcr/Config.pm line 177
[9437] info: FuzzyOcr: Added <43> words from "/etc/spamassassin/FuzzyOcr.words"
[9437] dbg: FuzzyOcr: Starting FuzzyOcr...
[9437] info: FuzzyOcr: Processing Message with ID "<[email protected]>" (Clifton Ballard <[email protected]> -> [email protected])
[9437] dbg: FuzzyOcr: fname: "sbillet" => "sbillet"
[9437] info: FuzzyOcr: GIF: [327x549] sbillet (7239)
[9437] dbg: FuzzyOcr: Saved: /tmp/.spamassassin9437hCRTrNtmp/sbillet
[9437] dbg: FuzzyOcr: Saved: /tmp/.spamassassin9437hCRTrNtmp/raw.eml
[9437] info: FuzzyOcr: Found: 1 images
[9437] dbg: FuzzyOcr: Connecting to: dbi:mysql:database=FuzzyOcr;host=localhost
[9437] warn: DBI connect('database=FuzzyOcr;host=localhost','fuzzyocr',...) failed: Access denied for user 'fuzzyocr'@'localhost' (using password: YES) at /etc/spamassassin/FuzzyOcr/Config.pm line 177
[9437] dbg: FuzzyOcr: pfile => /tmp/.spamassassin9437hCRTrNtmp/sbillet.pnm
[9437] dbg: FuzzyOcr: efile => /tmp/.spamassassin9437hCRTrNtmp/sbillet.err
[9437] dbg: FuzzyOcr: Errors to: /tmp/.spamassassin9437hCRTrNtmp/raw.err
[9437] dbg: FuzzyOcr: File has Content-Type "image/jpeg" and no File Extension
[9437] info: FuzzyOcr: Found GIF header name="sbillet"
[9437] info: FuzzyOcr: Image has format "GIF" but content-type is "image/jpeg"
[9437] dbg: FuzzyOcr: Saved pid: 9439
[9439] dbg: FuzzyOcr: Exec : /usr/bin/giftext /tmp/.spamassassin9437hCRTrNtmp/sbillet
[9439] dbg: FuzzyOcr: Stdout: >/tmp/.spamassassin9437hCRTrNtmp/giftext.info
[9439] dbg: FuzzyOcr: Stderr: >>/tmp/.spamassassin9437hCRTrNtmp/giftext.err
[9437] dbg: FuzzyOcr: Elapsed [9439]: 0.006118 sec. (/usr/bin/giftext: exit 1)
[9437] info: FuzzyOcr: Image is single non-interlaced...
[9437] dbg: FuzzyOcr: Saved pid: 9440
[9440] dbg: FuzzyOcr: Exec : /usr/bin/giffix /tmp/.spamassassin9437hCRTrNtmp/sbillet
[9440] dbg: FuzzyOcr: Stdout: >/tmp/.spamassassin9437hCRTrNtmp/sbillet-fixed.gif
[9440] dbg: FuzzyOcr: Stderr: >>/tmp/.spamassassin9437hCRTrNtmp/sbillet.err
[9437] dbg: FuzzyOcr: Elapsed [9440]: 0.010112 sec. (/usr/bin/giffix: exit 1)
[9437] info: FuzzyOcr: Image is corrupt, but seems fixable, continuing...
[9437] info: FuzzyOcr: Corrupt image: GIF-LIB error: Image is defective, decoding aborted.
[9437] dbg: FuzzyOcr: Saved pid: 9441
[9441] dbg: FuzzyOcr: Exec : /usr/bin/giftopnm /tmp/.spamassassin9437hCRTrNtmp/sbillet-fixed.gif
[9441] dbg: FuzzyOcr: Stdout: >/tmp/.spamassassin9437hCRTrNtmp/sbillet.pnm
[9441] dbg: FuzzyOcr: Stderr: >>/tmp/.spamassassin9437hCRTrNtmp/sbillet.err
[9437] dbg: FuzzyOcr: Elapsed [9441]: 0.013195 sec. (/usr/bin/giftopnm: exit 0)
[9437] info: FuzzyOcr: Calculating image hash for: /tmp/.spamassassin9437hCRTrNtmp/sbillet.pnm
[9437] dbg: FuzzyOcr: Saved pid: 9442
[9442] dbg: FuzzyOcr: Exec : /usr/bin/ppmhist -noheader /tmp/.spamassassin9437hCRTrNtmp/sbillet.pnm
[9442] dbg: FuzzyOcr: Stdout: >/tmp/.spamassassin9437hCRTrNtmp/ppmhist.info
[9442] dbg: FuzzyOcr: Stderr: >/dev/null
[9437] dbg: FuzzyOcr: Elapsed [9442]: 0.012307 sec. (/usr/bin/ppmhist: exit 0)
[9437] dbg: FuzzyOcr: Got: <538584:327:549:7::255:255:255:255:168580::0:0:0:0:9098::0:128:0:75:1086::0:0:128:15:395::128:0:128:53:213::0:0:255:29:115>
[9437] warn: FuzzyOcr: Connection to MySQL server unavailable
[9437] warn: FuzzyOcr: Connection to MySQL server unavailable
[9437] info: FuzzyOcr: Scanset Order: ocrad(0) ocrad-invert(0) ocrad-decolorize-invert(0) ocrad-decolorize(0) gocr(0) gocr-180(0)
[9437] dbg: FuzzyOcr: Saved pid: 9443
[9443] dbg: FuzzyOcr: Exec : /usr/bin/ocrad -s5 /tmp/.spamassassin9437hCRTrNtmp/sbillet.pnm
[9443] dbg: FuzzyOcr: Stdout: >/tmp/.spamassassin9437hCRTrNtmp/scanset.ocrad.out
[9443] dbg: FuzzyOcr: Stderr: >/tmp/.spamassassin9437hCRTrNtmp/scanset.ocrad.err
[9437] dbg: FuzzyOcr: Elapsed [9443]: 0.109418 sec. (/usr/bin/ocrad: exit 0)
[9437] dbg: FuzzyOcr: ocrdata=>>quantum Energy, Inc, Corporate Update (qEGY,oB)
[9437] dbg: FuzzyOcr: Hot Energy Stock!
[9437] dbg: FuzzyOcr: PRadyTo Run !!! BIG _NNER !!!
[9437] dbg: FuzzyOcr:
[9437] dbg: FuzzyOcr: Current Price_ _2.70
[9437] dbg: FuzzyOcr: Short Term Price Target_ _7.00
[9437] dbg: FuzzyOcr: Sboog Bup Recommendation
[9437] dbg: FuzzyOcr: "500+9b profk pdernial short term
[9437] dbg: FuzzyOcr:
[9437] dbg: FuzzyOcr: Friday Augurt 4, 4:01 pm ET
[9437] dbg: FuzzyOcr: LAS VEGAS, NEVADA--(MARKET WIRE)--Aug 4, 2006 -- auantum Energy, lnc. (OTC
[9437] dbg: FuzzyOcr: BB:aEGY.oB-_-
[9437] dbg: FuzzyOcr: auantum Energy, lnc. is pleased to announce that it has applied to have its shares listed for
[9437] dbg: FuzzyOcr: trading on the Frankfurt Stock Exchange. The company has retained the services ofBaltic
[9437] dbg: FuzzyOcr: lnvestment Group of Hamburg, Germany to assist with the application.
[9437] dbg: FuzzyOcr:
[9437] dbg: FuzzyOcr: _ qEGY,OB "
[9437] dbg: FuzzyOcr:
[9437] dbg: FuzzyOcr: <<=end
[9437] info: FuzzyOcr: Scanset "ocrad" found word "target" with fuzz of 0.0000
[9437] info: FuzzyOcr: line: "short term price target oo"
[9437] info: FuzzyOcr: Scanset "ocrad" found word "service" with fuzz of 0.0000
[9437] info: FuzzyOcr: line: "trading on the frankfurt stock exchange the company has retained the services ofbaltic"
[9437] info: FuzzyOcr: Scanset "ocrad" found word "stock" with fuzz of 0.0000
[9437] info: FuzzyOcr: line: "hot energy stocki"
[9437] info: FuzzyOcr: Scanset "ocrad" found word "stock" with fuzz of 0.0000
[9437] info: FuzzyOcr: line: "trading on the frankfurt stock exchange the company has retained the services ofbaltic"
[9437] info: FuzzyOcr: Scanset "ocrad" found word "price" with fuzz of 0.0000
[9437] info: FuzzyOcr: line: "current price o"
[9437] info: FuzzyOcr: Scanset "ocrad" found word "price" with fuzz of 0.0000
[9437] info: FuzzyOcr: line: "short term price target oo"
[9437] info: FuzzyOcr: Scanset "ocrad" found word "company" with fuzz of 0.0000
[9437] info: FuzzyOcr: line: "trading on the frankfurt stock exchange the company has retained the services ofbaltic"
[9437] info: FuzzyOcr: Scanset "ocrad" found word "recommendation" with fuzz of 0.0000
[9437] info: FuzzyOcr: line: "sboog bup recommendation"
[9437] dbg: FuzzyOcr: Enough OCR Hits without space stripping, skipping second matching pass...
[9437] info: FuzzyOcr: Scanset "ocrad" generates enough hits (8), skipping further scansets...
[9437] info: FuzzyOcr: Message is spam, score = 15.000
[9437] warn: FuzzyOcr: Connection to MySQL server unavailable
[9437] dbg: FuzzyOcr: Remove DIR: /tmp/.spamassassin9437hCRTrNtmp
[9437] dbg: FuzzyOcr: FuzzyOcr ending successfully...
[9437] dbg: FuzzyOcr: Processed in 0.194564 sec.
Zudem verwirt mich da was, ich habe mein spamassassin in etc/spamassassin und nicht in /etc/mail/spamassassin/ was die Installation oder Konfiguration immer voraus gibt, im der Anleitung hier:
HowtoForge Linux Tutorials Image Spam mit FuzzyOCR und SpamAssassin auf Debian/Ubuntu abwehren
wird auch immer von /etc/mail/spamassassin/ gesprochen.
Ich habe alles auf /etc/spamassassin/ angepasst.
Mein System ist Debian Lenny 5.0
Danke im Voraus.
gruss Gero
Last edited by a moderator: