hello, i have most of it working. i only have this one small problem. ill paste it from the email i sent the amavisd list...
-- hello, there is a new problem. running amavisd-new20020630 with the sql lookups, it gets most of the way through and i get this error message..... amavisd[2117]: (02117-03) creating_partsdir FAILED, retry: DBD::mysql::st execute failed: Table 'spamassassin.users' doesn't exist at /usr/sbin/amavisd line 945, <GEN3> line 43. the mysql db is spamassassin. the table is userpref. with postfix i get this error when i have the sql lookup on with amavisd-new.... postfix/smtp[2200]: 06C6B9E5EA: to=<[EMAIL PROTECTED]>, relay=127.0.0.1[127.0.0.1], delay=1270, status=deferred (host 127.0.0.1[127.0.0.1] said: 450 Temporary failure, retry, id=02185-01, creating_partsdir FAILED) if you need any other information please ask. i will try to supply it to you. i am sooooo close. this is going to kick ass when it is done!!!! TIA eric ----- Original Message ----- From: "Ted Cabeen" <[EMAIL PROTECTED]> Cc: "dogface" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, October 28, 2002 1:35 PM Subject: Re: [SAtalk] Re: amavisd-new && SA w/mysql -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Content-Type: text/plain; charset=us-ascii In message <[EMAIL PROTECTED]>, Ted Cabeen writes: >In message <007e01c27e9e$67ae6490$[EMAIL PROTECTED]>, "dogface" writes: >>im using the php-sa-mysql as an interface >>for the users to set their prefrences. so, i need >>the amavisd-new to either not send the mail to >>SA so i can set the SA to use the sql lookup or >>have the amavisd-new to send the mail to SA >>With the sql lookups enabled. >> >>i just need amaisd-new to not call SA or to >>have amavisd-new call SA with the sql lookup enabled. >> >>ok. i reread your reply. >>amavisd-new-20020630 can call SA with the sql lookup. >>are there docs on how to configure this? i think that is the >>route i need to take. > >If you're going to do this, you may have problems with the SA SQL preferences. >As a postfix content_filter, amavisd-new is run by the smtpd daemon when the >mail is received. This means that you can only set SA SQL preferences on the >addresses that the mail is sent to, not the addresses that it's delivered to. >If you want to do SQL preferences based on the delivery address(es), you need >to do SA filtering somewhere in the local transport (or the alternate local >transport that you have set). Depending on how you do local mail delivery, >either procmail or the spamcheck.py script may be more appropriate for your >needs. > >Unfortunately, this seems to be a side effect of how postfix implements >content_filter, and will be a problem with amavisd-new regardless of how it >does per-user SA preferences. You know what, I may be wrong here. I'm still looking for details, but from some of the comments on postfix-users, it looks like cleanup is done before content_filter, so this may not actually be a real problem. - -- Ted Cabeen http://www.pobox.com/~secabeen [EMAIL PROTECTED] Check Website or Keyserver for PGP/GPG Key BA0349D2 [EMAIL PROTECTED] "I have taken all knowledge to be my province." -F. Bacon [EMAIL PROTECTED] "Human kind cannot bear very much reality."-T.S.Eliot [EMAIL PROTECTED] -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (FreeBSD) Comment: Exmh version 2.5 07/13/2001 iD8DBQE9vZGAoayJfLoDSdIRAsLZAJ9Psn5g7HBV2f2LGPrPOz3kOwBOewCgo27a 0LJsUU5JTK0ONrD0p1TS6Uk= =U90A -----END PGP SIGNATURE----- ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Spamassassin-talk mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/spamassassin-talk ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Spamassassin-talk mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/spamassassin-talk
