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
--
Tony Earnshaw
Email: tonni at hetnet dot nl
