Spamassassin 3.1.1 MySQL Zugriff bleibt aus

M

Montesuma

New Member
Nachdem im alten Thread (Spamassassin ignoriert local.cf) die Lösung bereits gefunden wurde, mach ich mal einen neuen Thread auf. Spamassassin kann bei mir scheinbar noch nicht auf den MySQL Server zugreifen , um die user_prefs zu lesen.

/etc/sysconfig/spamd sieht so aus:
Code: 
SPAMD_ARGS="-d -x -q -L"
das -q ist also drinnen, um MySQL überhaupt zu aktivieren.


Eine Auswertung von spamassassin -D --lint
sieht so aus:
Code: 
hotel672:~ # spamassassin -D --lint
[3703] dbg: logger: adding facilities: all
[3703] dbg: logger: logging level is DBG
[3703] dbg: generic: SpamAssassin version 3.1.1
[3703] dbg: config: score set 0 chosen.
[3703] dbg: util: running in taint mode? yes
[3703] dbg: util: taint mode: deleting unsafe environment variables, resetting PATH
[3703] dbg: util: PATH included '/sbin', keeping
[3703] dbg: util: PATH included '/usr/sbin', keeping
[3703] dbg: util: PATH included '/usr/local/sbin', keeping
[3703] dbg: util: PATH included '/opt/gnome/sbin', keeping
[3703] dbg: util: PATH included '/root/bin', keeping
[3703] dbg: util: PATH included '/usr/local/bin', keeping
[3703] dbg: util: PATH included '/usr/bin', keeping
[3703] dbg: util: PATH included '/usr/X11R6/bin', keeping
[3703] dbg: util: PATH included '/bin', keeping
[3703] dbg: util: PATH included '/usr/games', keeping
[3703] dbg: util: PATH included '/opt/gnome/bin', keeping
[3703] dbg: util: PATH included '/usr/lib/mit/bin', which doesn't exist, dropping
[3703] dbg: util: PATH included '/usr/lib/mit/sbin', which doesn't exist, dropping
[3703] dbg: util: PATH included '.', which is not absolute, dropping
[3703] dbg: util: final PATH set to: /sbin:/usr/sbin:/usr/local/sbin:/opt/gnome/sbin:/root/bin:/usr/local/bin:/usr/bin:/usr/X11R6/bin:/bin:/usr/games:/opt/gnome/bin
[3703] dbg: dns: is Net::DNS::Resolver available? yes
[3703] dbg: dns: Net::DNS version: 0.55
[3703] dbg: diag: perl platform: 5.008008 linux
[3703] dbg: diag: module installed: Digest::SHA1, version 2.10
[3703] dbg: diag: module installed: HTML::Parser, version 3.48
[3703] dbg: diag: module installed: MIME::Base64, version 3.07
[3703] dbg: diag: module installed: DB_File, version 1.814
[3703] dbg: diag: module installed: Net::DNS, version 0.55
[3703] dbg: diag: module installed: Net::SMTP, version 2.29
[3703] dbg: diag: module not installed: Mail::SPF::Query ('require' failed)
[3703] dbg: diag: module not installed: IP::Country::Fast ('require' failed)
[3703] dbg: diag: module installed: Razor2::Client::Agent, version 2.77
[3703] dbg: diag: module not installed: Net::Ident ('require' failed)
[3703] dbg: diag: module not installed: IO::Socket::INET6 ('require' failed)
[3703] dbg: diag: module installed: IO::Socket::SSL, version 0.97
[3703] dbg: diag: module installed: Time::HiRes, version 1.86
[3703] dbg: diag: module installed: DBI, version 1.50
[3703] dbg: diag: module installed: Getopt::Long, version 2.35
[3703] dbg: diag: module installed: LWP::UserAgent, version 2.033
[3703] dbg: diag: module installed: HTTP::Date, version 1.47
[3703] dbg: diag: module installed: Archive::Tar, version 1.24
[3703] dbg: diag: module not installed: IO::Zlib ('require' failed)
[3703] dbg: ignore: using a test message to lint rules
[3703] dbg: config: using "/etc/mail/spamassassin" for site rules pre files
[3703] dbg: config: read file /etc/mail/spamassassin/init.pre
[3703] dbg: config: read file /etc/mail/spamassassin/v310.pre
[3703] dbg: config: using "/usr/share/spamassassin" for sys rules pre files
[3703] dbg: config: using "/usr/share/spamassassin" for default rules dir
[3703] dbg: config: read file /usr/share/spamassassin/10_misc.cf
[3703] dbg: config: read file /usr/share/spamassassin/20_advance_fee.cf
[3703] dbg: config: read file /usr/share/spamassassin/20_anti_ratware.cf
[3703] dbg: config: read file /usr/share/spamassassin/20_body_tests.cf
[3703] dbg: config: read file /usr/share/spamassassin/20_compensate.cf
[3703] dbg: config: read file /usr/share/spamassassin/20_dnsbl_tests.cf
[3703] dbg: config: read file /usr/share/spamassassin/20_drugs.cf
[3703] dbg: config: read file /usr/share/spamassassin/20_fake_helo_tests.cf
[3703] dbg: config: read file /usr/share/spamassassin/20_head_tests.cf
[3703] dbg: config: read file /usr/share/spamassassin/20_html_tests.cf
[3703] dbg: config: read file /usr/share/spamassassin/20_meta_tests.cf
[3703] dbg: config: read file /usr/share/spamassassin/20_net_tests.cf
[3703] dbg: config: read file /usr/share/spamassassin/20_phrases.cf
[3703] dbg: config: read file /usr/share/spamassassin/20_porn.cf
[3703] dbg: config: read file /usr/share/spamassassin/20_ratware.cf
[3703] dbg: config: read file /usr/share/spamassassin/20_uri_tests.cf
[3703] dbg: config: read file /usr/share/spamassassin/23_bayes.cf
[3703] dbg: config: read file /usr/share/spamassassin/25_accessdb.cf
[3703] dbg: config: read file /usr/share/spamassassin/25_antivirus.cf
[3703] dbg: config: read file /usr/share/spamassassin/25_body_tests_es.cf
[3703] dbg: config: read file /usr/share/spamassassin/25_body_tests_pl.cf
[3703] dbg: config: read file /usr/share/spamassassin/25_dcc.cf
[3703] dbg: config: read file /usr/share/spamassassin/25_domainkeys.cf
[3703] dbg: config: read file /usr/share/spamassassin/25_hashcash.cf
[3703] dbg: config: read file /usr/share/spamassassin/25_pyzor.cf
[3703] dbg: config: read file /usr/share/spamassassin/25_razor2.cf
[3703] dbg: config: read file /usr/share/spamassassin/25_replace.cf
[3703] dbg: config: read file /usr/share/spamassassin/25_spf.cf
[3703] dbg: config: read file /usr/share/spamassassin/25_textcat.cf
[3703] dbg: config: read file /usr/share/spamassassin/25_uribl.cf
[3703] dbg: config: read file /usr/share/spamassassin/30_text_de.cf
[3703] dbg: config: read file /usr/share/spamassassin/30_text_fr.cf
[3703] dbg: config: read file /usr/share/spamassassin/30_text_it.cf
[3703] dbg: config: read file /usr/share/spamassassin/30_text_nl.cf
[3703] dbg: config: read file /usr/share/spamassassin/30_text_pl.cf
[3703] dbg: config: read file /usr/share/spamassassin/30_text_pt_br.cf
[3703] dbg: config: read file /usr/share/spamassassin/50_scores.cf
[3703] dbg: config: read file /usr/share/spamassassin/60_awl.cf
[3703] dbg: config: read file /usr/share/spamassassin/60_whitelist.cf
[3703] dbg: config: read file /usr/share/spamassassin/60_whitelist_spf.cf
[3703] dbg: config: read file /usr/share/spamassassin/60_whitelist_subject.cf
[3703] dbg: config: using "/etc/mail/spamassassin" for site rules dir
[3703] dbg: config: read file /etc/mail/spamassassin/local.cf
[3703] dbg: config: using "/root/.spamassassin" for user state dir
[3703] dbg: config: using "/root/.spamassassin" for user state dir
[3703] warn: config: created user preferences file: /root/.spamassassin/user_prefs
[3703] dbg: config: using "/root/.spamassassin/user_prefs" for user prefs file
[3703] dbg: config: read file /root/.spamassassin/user_prefs
[3703] dbg: plugin: loading Mail::SpamAssassin::Plugin::URIDNSBL from @INC
[3703] dbg: plugin: registered Mail::SpamAssassin::Plugin::URIDNSBL=HASH(0x83594c0)
[3703] dbg: plugin: loading Mail::SpamAssassin::Plugin::Hashcash from @INC
[3703] dbg: plugin: registered Mail::SpamAssassin::Plugin::Hashcash=HASH(0x930c5b4)
[3703] dbg: plugin: loading Mail::SpamAssassin::Plugin::SPF from @INC
[3703] dbg: plugin: registered Mail::SpamAssassin::Plugin::SPF=HASH(0x932f7d4)
[3703] dbg: plugin: loading Mail::SpamAssassin::Plugin::Pyzor from @INC
[3703] dbg: pyzor: network tests on, attempting Pyzor
[3703] dbg: plugin: registered Mail::SpamAssassin::Plugin::Pyzor=HASH(0x9345ec8)
[3703] dbg: plugin: loading Mail::SpamAssassin::Plugin::SpamCop from @INC
[3703] dbg: reporter: network tests on, attempting SpamCop
[3703] dbg: plugin: registered Mail::SpamAssassin::Plugin::SpamCop=HASH(0x9312e8c)
[3703] dbg: plugin: loading Mail::SpamAssassin::Plugin::AWL from @INC
[3703] dbg: plugin: registered Mail::SpamAssassin::Plugin::AWL=HASH(0x9315904)
[3703] dbg: plugin: loading Mail::SpamAssassin::Plugin::AutoLearnThreshold from @INC
[3703] dbg: plugin: registered Mail::SpamAssassin::Plugin::AutoLearnThreshold=HASH(0x9391750)
[3703] dbg: plugin: loading Mail::SpamAssassin::Plugin::WhiteListSubject from @INC
[3703] dbg: plugin: registered Mail::SpamAssassin::Plugin::WhiteListSubject=HASH(0x939f9f8)
[3703] dbg: plugin: loading Mail::SpamAssassin::Plugin::MIMEHeader from @INC
[3703] dbg: plugin: registered Mail::SpamAssassin::Plugin::MIMEHeader=HASH(0x93aedf8)
[3703] dbg: plugin: loading Mail::SpamAssassin::Plugin::ReplaceTags from @INC
[3703] dbg: plugin: registered Mail::SpamAssassin::Plugin::ReplaceTags=HASH(0x93ba788)
[3703] dbg: config: adding redirector regex: /^http:\/\/chkpt\.zdnet\.com\/chkpt\/\w+\/(.*)$/i
[3703] dbg: config: adding redirector regex: /^http:\/\/www(?:\d+)?\.nate\.com\/r\/\w+\/(.*)$/i
[3703] dbg: config: adding redirector regex: /^http:\/\/.+\.gov\/(?:.*\/)?externalLink\.jhtml\?.*url=(.*?)(?:&.*)?$/i
[3703] dbg: config: adding redirector regex: /^http:\/\/redir\.internet\.com\/.+?\/.+?\/(.*)$/i
[3703] dbg: config: adding redirector regex: /^http:\/\/(?:.*?\.)?adtech\.de\/.*(?:;|\|)link=(.*?)(?:;|$)/i
[3703] dbg: config: adding redirector regex: m'^http.*?/redirect\.php\?.*(?<=[?&])goto=(.*?)(?:$|[&\#])'i
[3703] dbg: config: adding redirector regex: m'^https?:/*(?:[^/]+\.)?emf\d\.com/r\.cfm.*?&r=(.*)'i
[3703] dbg: config: adding redirector regex: m'/(?:index.php)?\?.*(?<=[?&])URL=(.*?)(?:$|[&\#])'i
[3703] dbg: config: adding redirector regex: m'^http:/*(?:\w+\.)?google(?:\.\w{2,3}){1,2}/url\?.*?(?<=[?&])q=(.*?)(?:$|[&\#])'i
[3703] dbg: config: adding redirector regex: m'^http:/*(?:\w+\.)?google(?:\.\w{2,3}){1,2}/search\?.*?(?<=[?&])q=[^&]*?(?<=%20|..[=+\s])site:(.*?)(?:$|%20|[\s+&\#])'i
[3703] dbg: config: adding redirector regex: m'^http:/*(?:\w+\.)?google(?:\.\w{2,3}){1,2}/search\?.*?(?<=[?&])q=[^&]*?(?<=%20|..[=+\s])(?:"|%22)(.*?)(?:$|%22|["\s+&\#])'i
[3703] dbg: config: adding redirector regex: m'^http:/*(?:\w+\.)?google(?:\.\w{2,3}){1,2}/translate\?.*?(?<=[?&])u=(.*?)(?:$|[&\#])'i
[3703] warn: config: failed to parse line, skipping: use_razor2              1
[3703] warn: config: failed to parse line, skipping: use_dcc                 1
[3703] warn: config: failed to parse, now a plugin, skipping: ok_languages            all
[3703] dbg: config: allowing user rules!
[3703] dbg: plugin: Mail::SpamAssassin::Plugin::ReplaceTags=HASH(0x93ba788) implements 'finish_parsing_end'
[3703] dbg: replacetags: replacing tags
[3703] dbg: replacetags: done replacing tags
[3703] dbg: config: using "/root/.spamassassin" for user state dir
[3703] dbg: bayes: no dbs present, cannot tie DB R/O: /root/.spamassassin/bayes_toks
[3703] dbg: config: score set 1 chosen.
[3703] dbg: message: ---- MIME PARSER START ----
[3703] dbg: message: main message type: text/plain
[3703] dbg: message: parsing normal part
[3703] dbg: message: added part, type: text/plain
[3703] dbg: message: ---- MIME PARSER END ----
[3703] dbg: bayes: no dbs present, cannot tie DB R/O: /root/.spamassassin/bayes_toks
[3703] dbg: dns: name server: 85.25.128.10, family: 2, ipv6: 0
[3703] dbg: dns: testing resolver nameservers: 85.25.128.10, 85.25.255.10
[3703] dbg: dns: trying (3) intel.com...
[3703] dbg: dns: looking up NS for 'intel.com'
[3703] dbg: dns: NS lookup of intel.com using 85.25.128.10 succeeded => DNS available (set dns_available to override)
[3703] dbg: dns: is DNS available? 1
[3703] dbg: metadata: X-Spam-Relays-Trusted:
[3703] dbg: metadata: X-Spam-Relays-Untrusted:
[3703] dbg: message: no encoding detected
[3703] dbg: plugin: Mail::SpamAssassin::Plugin::URIDNSBL=HASH(0x83594c0) implements 'parsed_metadata'
[3703] dbg: uridnsbl: domains to query:
[3703] dbg: dns: checking RBL sbl-xbl.spamhaus.org., set sblxbl-lastexternal
[3703] dbg: dns: checking RBL sa-accredit.habeas.com., set habeas-firsttrusted
[3703] dbg: dns: checking RBL sbl-xbl.spamhaus.org., set sblxbl
[3703] dbg: dns: checking RBL sa-other.bondedsender.org., set bsp-untrusted
[3703] dbg: dns: checking RBL combined.njabl.org., set njabl-lastexternal
[3703] dbg: dns: checking RBL combined.njabl.org., set njabl
[3703] dbg: dns: checking RBL combined-HIB.dnsiplists.completewhois.com., set whois
[3703] dbg: dns: checking RBL list.dsbl.org., set dsbl-lastexternal
[3703] dbg: dns: checking RBL bl.spamcop.net., set spamcop
[3703] dbg: dns: checking RBL sa-trusted.bondedsender.org., set bsp-firsttrusted
[3703] dbg: dns: checking RBL combined-HIB.dnsiplists.completewhois.com., set whois-lastexternal
[3703] dbg: dns: checking RBL dnsbl.sorbs.net., set sorbs-lastexternal
[3703] dbg: dns: checking RBL dnsbl.sorbs.net., set sorbs
[3703] dbg: dns: checking RBL iadb.isipp.com., set iadb-firsttrusted
[3703] dbg: check: running tests for priority: 0
[3703] dbg: rules: running header regexp tests; score so far=0
[3703] dbg: rules: ran header rule __HAS_MSGID ======> got hit: "<"
[3703] dbg: rules: ran header rule __MSGID_OK_DIGITS ======> got hit: "1170758508"
[3703] dbg: rules: ran header rule __SANE_MSGID ======> got hit: "<1170758508@lint_rules>
[3703] dbg: rules: "
[3703] dbg: rules: ran header rule NO_REAL_NAME ======> got hit: "ignore@compiling.spamassassin.taint.org
[3703] dbg: rules: "
[3703] dbg: rules: ran header rule __MSGID_OK_HOST ======> got hit: "@lint_rules>"
[3703] dbg: plugin: registering glue method for check_hashcash_double_spend (Mail::SpamAssassin::Plugin::Hashcash=HASH(0x930c5b4))
[3703] dbg: plugin: registering glue method for check_for_spf_helo_pass (Mail::SpamAssassin::Plugin::SPF=HASH(0x932f7d4))
[3703] dbg: spf: no trusted relays found, using first (untrusted) relay (if present) for SPF checks
[3703] dbg: spf: no suitable relay for spf use found, skipping SPF-helo check
[3703] dbg: eval: all '*From' addrs: ignore@compiling.spamassassin.taint.org
[3703] dbg: plugin: registering glue method for check_subject_in_blacklist (Mail::SpamAssassin::Plugin::WhiteListSubject=HASH(0x939f9f8))
[3703] dbg: plugin: registering glue method for check_hashcash_value (Mail::SpamAssassin::Plugin::Hashcash=HASH(0x930c5b4))
[3703] dbg: eval: all '*To' addrs:
[3703] dbg: plugin: registering glue method for check_for_spf_neutral (Mail::SpamAssassin::Plugin::SPF=HASH(0x932f7d4))
[3703] dbg: spf: no suitable relay for spf use found, skipping SPF check
[3703] dbg: plugin: registering glue method for check_for_spf_softfail (Mail::SpamAssassin::Plugin::SPF=HASH(0x932f7d4))
[3703] dbg: rules: ran eval rule NO_RELAYS ======> got hit
[3703] dbg: plugin: registering glue method for check_for_spf_pass (Mail::SpamAssassin::Plugin::SPF=HASH(0x932f7d4))
[3703] dbg: plugin: registering glue method for check_for_spf_helo_softfail (Mail::SpamAssassin::Plugin::SPF=HASH(0x932f7d4))
[3703] dbg: plugin: registering glue method for check_for_def_spf_whitelist_from (Mail::SpamAssassin::Plugin::SPF=HASH(0x932f7d4))
[3703] dbg: spf: cannot get Envelope-From, cannot use SPF
[3703] dbg: spf: def_spf_whitelist_from: could not find useable envelope sender
[3703] dbg: plugin: registering glue method for check_for_spf_fail (Mail::SpamAssassin::Plugin::SPF=HASH(0x932f7d4))
[3703] dbg: rules: ran eval rule __UNUSABLE_MSGID ======> got hit
[3703] dbg: plugin: registering glue method for check_subject_in_whitelist (Mail::SpamAssassin::Plugin::WhiteListSubject=HASH(0x939f9f8))
[3703] dbg: rules: ran eval rule MISSING_HEADERS ======> got hit
[3703] dbg: plugin: registering glue method for check_for_spf_whitelist_from (Mail::SpamAssassin::Plugin::SPF=HASH(0x932f7d4))
[3703] dbg: spf: spf_whitelist_from: could not find useable envelope sender
[3703] dbg: rules: running body-text per-line regexp tests; score so far=0.738
[3703] dbg: rules: ran body rule __NONEMPTY_BODY ======> got hit: "I"
[3703] dbg: uri: running uri tests; score so far=0.738
[3703] dbg: bayes: no dbs present, cannot tie DB R/O: /root/.spamassassin/bayes_toks
[3703] dbg: bayes: not scoring message, returning undef
[3703] dbg: bayes: opportunistic call attempt failed, DB not readable
[3703] dbg: plugin: registering glue method for check_uridnsbl (Mail::SpamAssassin::Plugin::URIDNSBL=HASH(0x83594c0))
[3703] dbg: rules: running raw-body-text per-line regexp tests; score so far=0.738
[3703] dbg: rules: running full-text regexp tests; score so far=0.738
[3703] dbg: plugin: registering glue method for check_pyzor (Mail::SpamAssassin::Plugin::Pyzor=HASH(0x9345ec8))
[3703] dbg: util: current PATH is: /sbin:/usr/sbin:/usr/local/sbin:/opt/gnome/sbin:/root/bin:/usr/local/bin:/usr/bin:/usr/X11R6/bin:/bin:/usr/games:/opt/gnome/bin
[3703] dbg: pyzor: pyzor is not available: no pyzor executable found
[3703] dbg: pyzor: no pyzor found, disabling Pyzor
[3703] dbg: plugin: Mail::SpamAssassin::Plugin::URIDNSBL=HASH(0x83594c0) implements 'check_tick'
[3703] dbg: check: running tests for priority: 500
[3703] dbg: plugin: Mail::SpamAssassin::Plugin::URIDNSBL=HASH(0x83594c0) implements 'check_post_dnsbl'
[3703] dbg: rules: running meta tests; score so far=0.738
[3703] dbg: rules: running header regexp tests; score so far=2.216
[3703] dbg: rules: running body-text per-line regexp tests; score so far=2.216
[3703] dbg: uri: running uri tests; score so far=2.216
[3703] dbg: rules: running raw-body-text per-line regexp tests; score so far=2.216
[3703] dbg: rules: running full-text regexp tests; score so far=2.216
[3703] dbg: check: running tests for priority: 1000
[3703] dbg: rules: running meta tests; score so far=2.216
[3703] dbg: rules: running header regexp tests; score so far=2.216
[3703] dbg: plugin: registering glue method for check_from_in_auto_whitelist (Mail::SpamAssassin::Plugin::AWL=HASH(0x9315904))
[3703] dbg: config: using "/root/.spamassassin" for user state dir
[3703] dbg: locker: safe_lock: created /root/.spamassassin/auto-whitelist.lock.hotel672.server4you.de.3703
[3703] dbg: locker: safe_lock: trying to get lock on /root/.spamassassin/auto-whitelist with 0 retries
[3703] dbg: locker: safe_lock: link to /root/.spamassassin/auto-whitelist.lock: link ok
[3703] dbg: auto-whitelist: tie-ing to DB file of type DB_File R/W in /root/.spamassassin/auto-whitelist
[3703] dbg: auto-whitelist: db-based ignore@compiling.spamassassin.taint.org|ip=none scores 0/0
[3703] dbg: auto-whitelist: AWL active, pre-score: 2.216, autolearn score: 2.216, mean: undef, IP: undef
[3703] dbg: auto-whitelist: DB addr list: untie-ing and unlocking
[3703] dbg: auto-whitelist: DB addr list: file locked, breaking lock
[3703] dbg: locker: safe_unlock: unlink /root/.spamassassin/auto-whitelist.lock
[3703] dbg: auto-whitelist: post auto-whitelist score: 2.216
[3703] dbg: rules: running body-text per-line regexp tests; score so far=2.216
[3703] dbg: uri: running uri tests; score so far=2.216
[3703] dbg: rules: running raw-body-text per-line regexp tests; score so far=2.216
[3703] dbg: rules: running full-text regexp tests; score so far=2.216
[3703] dbg: check: is spam? score=2.216 required=5
[3703] dbg: check: tests=MISSING_HEADERS,MISSING_SUBJECT,NO_REAL_NAME,NO_RECEIVED,NO_RELAYS,TO_CC_NONE
[3703] dbg: check: subtests=__HAS_MSGID,__MSGID_OK_DIGITS,__MSGID_OK_HOST,__NONEMPTY_BODY,__SANE_MSGID,__UNUSABLE_MSGID
[3703] warn: lint: 2 issues detected, please rerun with debug enabled for more information
hotel672:~ #
Man erkennt keinen Zugriff auf MYSQL.

In der MySQL Datenbank ist ein Eintrag, daß der user @GLOBAL einen required_score von 6.4 hat. Die Test Email zeigt jedoch einen required score von 5 an. Wenn ich in der local.cf den requred score auf 5.5 ändere, dann ändert sich auch die Test Email, also wird die local.cf ganz sicher abgearbeitet. Trotzdem werden folgende Einträge in der local.cf nicht durchgeführt:
Code: 
# START CONFIXX GENERATED SECTION
###
allow_user_rules 1

user_scores_dsn                 DBI:mysql:confixx:localhost;mysql_socket=/var/lib/mysql/mysql.sock
user_scores_sql_username        confixx
user_scores_sql_password        xxxxxxxxx

user_scores_sql_custom_query SELECT preference, value FROM spampref WHERE username = _USERNAME_ OR username = '@GLOBAL' ORDER BY username ASC

Der user confixx und das passwort existieren jedoch, ich kann mich mit diesen Zugangsdaten über einen MYSQL Browser einloggen.

Eine Idee?
 
Last edited by a moderator:
Kenn sich wohl keiner aus.

Ich auch nicht, also habe ich mal einfach einen neuen Server geordert und siehe da - beim Strato VServer läufts, genau so, wie oben.

Anders als bei meinem alten Server ist, daß Mails nicht mehr über Postfix kommen, sondern von Qmail.

Jedoch wird bei diesem Server die Variable _USERNAME_ aus der local.cf mit falschem Inhalt an MySQL übergeben. Egal, an welchen User ich eine Email schicke, Spamd scheint in der Variable immer den Namen drinnen zu haben, mit dem er als Task gestartet wurde. Spamd fragt also immer nach user_prefs von "qmaild" nach.

Wie bekomme ich spamd dazu, mit dem dem Empfängernamen nach user_prefs zu suchen?
 
Montesuma said:
Spamd scheint in der Variable immer den Namen drinnen zu haben, mit dem er als Task gestartet wurde.
Click to expand...
Korrektur: mit dem spamc gestartet wurde.

Wie bekomme ich spamd dazu, mit dem dem Empfängernamen nach user_prefs zu suchen?
Click to expand...
Dazu mußt Du erstmal beschreiben, an welcher Stelle spamc in die Mailverarbeitung eingebunden ist.
Der empfangende User steht nämlich erst ab dem MDA zur Verfügung.

huschi.
 
Das war der richtige Weg, dake dafür.

Fehler gefunden:

Nachdem ich Postfix den Spamc starten liesse, haben zwei Tasks versucht die Email zu bearbeiten. Einmal Spamc, gestartet von Postfix und einmal Spamassissn, gestartet über die procmailrc.

Spamassassin nimmt keine SQL Anfragen wahr, es darf also nur über Spamc/Spamd gehen. Ich habe den Eintrag in der procmailrc von Spamassassain auf spamc geändert und schon sind alle Fehler weg.
 
You must log in or register to reply here.
Back
Top