Tony, Thanks for you reply. I have the following Dspam tables in my mail DB.
dspam_preferences dspam_signature_data dspam_stats dspam_token_data dspam_virtual_uids The structures of these table are exactly the same as provided with default Dspam 3.8.0 distribution in dspam-3.8.0/src/tools.mysql_drv in files: mysql_objects-speed.sql and virtual_users.sql Virtual users are enabled and dspam_virtual_uids table is being properly filled with data as well as dspam_stats and dspam_token_data tables. Only dspam_signature_data table remains empty with "Unknown column" error related to it. dspam.conf has the following relevant entries: TrainingMode teft TestConditionalTraining on Algorithm graham burton Tokenizer chain PValue bcr ParseToHeaders on ChangeModeOnParse on ChangeUserOnParse off ServerMode auto ProcessorBias on Thank you in advance for any hints or help, Ale On Friday 27 July 2007 23:49:22 Tony Earnshaw wrote: > Dspam User skrev, on 27-07-2007 20:32: > > Thanks for the reply. > > However, how did you get around "Unknown column" MySQL query error? > > I'm using MySQL 5.0.45 as a backend for my Postfix configuration with > > virtual users, domains without any problems. > > It's only Dspam which gives me a headache with that error and not > > entering data into dspam_signature_data table. > > Does it matter if I put Dspam default tables into my database which name > > is mail not dspam? > > It all depends ;) I don't know what your setup looks like, my crystal > ball fails dismally in this kind of situation, > .. > Do "grep '^[^#]' dspam.conf" and post the results. > How many tables do you have in your dspam DB? What are they called? > (mysql -> 'use dspamdb;' -> 'show tables;') > > Have you enabled virtual users? > > Enable debugging for one of the users that doesn't work (can be a group, > it doesn't matter) watch what happens in practice ... > > Is there anything in LOGDIR/sql.errors, as detailed in mysql_drv.txt? > > Using a utility such as phpMyAdmin to administer the DB can help a lot ... > > If you run Fedora or Red Hat I've dspam rpms and srpms available, where > the whole LHF . The srpms build on FC6/7, rhl4/5 and should build on > CentOS 4/5. > > Best, > > --Tonni
