Peter, > I'm using version amavisd-new 2.3.3 with Spamassassin 3.0.4. I am > attaching my amavisd.conf file. > My main beef presently is to have my SA user preferences stored in a > MySQL database (4.0.24) and have them user-configurable via web > browser. > > On the amavisd-new site documentation > (http://www.ijs.si/software/amavisd/README.sql.txt) provides a SQL > schema to do this. I used it and view my setup via phpMyAdmin. > > Now phpMyAdmin gives warnings of my schema in several tables: > table 1: > UNIQUE and INDEX keys should not both be set for column `email` > table 2: > More than one INDEX key was created for column `mail_id` > More than one INDEX key was created for column `rid` > table 3: > More than one INDEX key was created for column `sid` > table 5: > UNIQUE and INDEX keys should not both be set for column `email`
> Questions: > a) Why is the schema suggested if it has issues? How should it be > modified? Some SQL servers expect KEY... in CREATE TABLE, others want CREATE INDEX as a separate command, some tolerate both. For PostgreSQL and for SQLite the instructions in README.sql say: - leave out 'KEY ...' It appears the same applies to your version of MySQL. > table 4: > More than one INDEX key was created for column `preference` There is no column 'preference' in README.sql, must be specific to your setup. > b) How do I confirm that SA is using these preferences? It is not, tables described in README.sql are only observed by amavias-new, and control handling of mail based on spam score from SA and user preferences in these tables. > c) What is the accepted way for users to configure their accounts > via HTTP? I tried Maia but I couldn't get it to work. I set up the > webuserprefs php interface and I can alter an SQL table but, still, > I am not confident that SA is actually using the preferences. Like said, SA is not seeing these preferences, there is no need to. Take a look at http://www.mailzu.org/ Mark ------------------------------------------------------- This SF.Net email is sponsored by the JBoss Inc. Get Certified Today Register for a JBoss Training Course. Free Certification Exam for All Training Attendees Through End of 2005. For more info visit: http://ads.osdn.com/?ad_id=7628&alloc_id=16845&op=click _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
