Tejas Jin wrote: > ---- Harley Peters <[EMAIL PROTECTED]> wrote: >> Tejas Jin wrote: >>> Tom >>> You were right about the tokenizer. Once I corrected that, the chain part >>> of the error message went away. But even if I follow Sydney's suggestion >>> and run >>> >>> /usr/local/bin/dspam --client --user root --class=spam --source=error >>> >>> instead of just dspam --user root --class=spam --source=error >>> >>> I still get the following errors. I check mysql database and I can find >>> the signature in dspam_signature_data. >>> >>> 29041: [06/04/2007 23:18:52] Signature retrieval for >>> '2,46641fad191982947017269' failed >>> 29041: [06/04/2007 23:18:52] Unable to find a valid signature. Aborting. >>> 29041: [06/04/2007 23:18:52] process_message returned error -5. dropping >>> message. >>> >>> My current compile switches are >>> --enable-daemon --with-storage-driver=mysql_drv >>> --with-mysql-libraries=/usr/lib/mysql >>> --with-mysql-includes=/usr/include/mysql >>> --enable-mysql4-initialization >>> --enable-preferences-extensions >>> --enable-virtual-users >>> --enable-debug >>> --with-dspam-owner=dspam >>> --with-dspam-group=dspam >>> >>> I am going it again without the --enable-mysql4-initialization and with the >>> --enable-verbose-debug and see if that points me in the correct direction. >>> >>> >>> >>> ---- Tom Bombadil <[EMAIL PROTECTED]> wrote: >>>> It seems like you are you are using 3.8.0 binary with 3.6.8 config file. >>>> >>>> From the UPGRADING file: >>>> 1. Add 'Tokenizer' setting to dspam.conf >>>> The 'Tokenizer' setting in 3.8.0 replaces tokenizer definitions in the >>>> "Feature" clause of previous version configurations. See src/dspam.conf >>>> (after make) for more information about this seting. >>>> >>>> You need: >>>> Tokenizer chain >>>> >>>> >>>> >>>> >>>> Tejas Jin wrote: >>>>> If I read your message correctly using >>>>> >>>>> /usr/local/bin/dspam --client --user root --class=spam --source=error >>>>> should fix it, but I'm getting the same error. >>>>> >>>>> I've actually backed up and installed 3.6.8 to try and figure out whether >>>>> it is a version problem. >>>>> For me it appears to be a configuration problem. I've loaded 3.8.0 now >>>>> and am getting another error on top of the old one. >>>>> >>>>> 28909: [06/04/2007 10:13:30] No such feature 'chained' >>>>> 28909: [06/04/2007 10:13:30] Signature retrieval for >>>>> '2,46641fb5191984127714242' failed >>>>> 28909: [06/04/2007 10:13:30] Unable to find a valid signature. Aborting. >>>>> 28909: [06/04/2007 10:13:30] process_message returned error -5. dropping >>>>> message. >>>>> >>>>> >>>>> My guess is that it running a query against mysql and not getting the >>>>> correct results. MySQL appears to be configured correctly, because when >>>>> I get mail it adds signatures. >>>>> >>>>> >>>>> ---- Stephen Carr <[EMAIL PROTECTED]> wrote: >>>>>> Dear Tejas >>>>>> >>>>>> I think I have a workaround instead of using dspamc use dspam with >>>>>> --client added to the command line. >>>>>> >>>>>> I had a similar messages as you had below adding the --client seemd to >>>>>> fix >>>>>> the problem. My dspam is built with --enable-daemon. >>>>>> >>>>>> I am now using traindspam with dspamc replaced with dspam --client >>>>>> >>>>>> Regards >>>>>> Stephen Carr >>>>>> >>>>>> Tejas Jin wrote: >>>>>>> When I go into mutt, I pipe a spam message to >>>>>>> /usr/local/bin/dspam --user root --class=spam --source=error >>>>>>> >>>>>>> 8349: [06/03/2007 05:14:06] Signature retrieval for >>>>>>> '2,46628bb6130139463419170' failed >>>>>>> 8349: [06/03/2007 05:14:06] Unable to find a valid signature. Aborting. >>>>>>> 8349: [06/03/2007 05:14:06] process_message returned error -5. dropping >>>>>>> message. >>>>>>> >>>>>>> if I go into mysql and manually search for this signature I have no >>>>>>> problem finding the signature or signatures >>>>>>> >>>>>>> Select * from dspam_signature_data where >>>>>>> signature='2,46628bb6130139463419170'; >>>>>>> >>>>>>> >>>>>> -- >>>>>> Stephen Carr >>>>>> Computing Officer >>>>>> School of Civil and Environmental Engineering >>>>>> The University of Adelaide >>>>>> Tel +618-8303-4313 >>>>>> Fax +618-8303-4359 >>>>>> Email [EMAIL PROTECTED] >>>>>> >>>>>> CRICOS Provider Number 00123M >>>>>> ----------------------------------------------------------- >>>>>> This email message is intended only for the addressee(s)and contains >>>>>> information that may be confidential and/or copyright. If you are not >>>>>> the >>>>>> intended recipient please notify the sender by reply email and >>>>>> immediately >>>>>> delete this email. Use, disclosure or reproduction of this email by >>>>>> anyone >>>>>> other than the intended recipient(s) is strictly prohibited. No >>>>>> representation is made that this email or any attachments are free of >>>>>> viruses. Virus scanning is recommended and is the responsibility of the >>>>>> recipient. >>>>>> >>>>>> >> Is the user root listed in your dspam_virtual_uids table ? >> You can use any user name as long as it's in the table but if it's not >> it will give an error like the one above. >> >> Harley >> > > Okay, this got me a little farther along. After adding root I then ran the > same command with the user corresponding to the email. I included my > dspam_virtual_uids table below. > > /usr/local/bin/dspam --client --user root --class=spam --source=error > > 11545: [06/05/2007 09:50:21] Signature retrieval for > '2,4664ea7c289227086315347' failed > 11545: [06/05/2007 09:50:21] Unable to find a valid signature. Aborting. > 11545: [06/05/2007 09:50:21] process_message returned error -5. dropping > message. > > > /usr/local/bin/dspam --client --user [EMAIL PROTECTED] --class=spam > --source=error > > 11549: [06/05/2007 09:52:40] query error: VERBOSE DEBUG (INFO ONLY - NOT AN > ERROR): see sql.errors for more details > 11549: [06/05/2007 09:52:40] Unable to open file for writing: > /usr/local/var/dspam/log/sql.errors: Permission denied > 11549: [06/05/2007 09:52:40] Unable to create directory: > /usr/local/var/dspam/data: Permission denied > 11549: [06/05/2007 09:52:40] Unable to open file for writing: > /usr/local/var/dspam/data/[EMAIL PROTECTED]/[EMAIL PROTECTED]: Permission > denied > 11549: [06/05/2007 09:52:40] Unable to create directory: > /usr/local/var/dspam/data: Permission denied > > So it appears I am stuck with another permission problem. dspam ls -l > listing follows. > > -r-sr-sr-x 1 dspam dspam 396724 Jun 4 23:41 dspam > > dspam_virtual_uids > > +-----+-------------------------------------+ > | uid | username | > +-----+-------------------------------------+ > | 1 | [EMAIL PROTECTED] | > | 2 | [EMAIL PROTECTED] | > | 3 | [EMAIL PROTECTED] | > | 4 | [EMAIL PROTECTED] | > | 5 | root | > +-----+-------------------------------------+ >
What are the permissions of /usr/local/var/dspam ? Harley
