[AMaViS-user] running with SA/SQL user prefs

Hello everyone.

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 4:
More than one INDEX key was created for column `preference`

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?

b) How do I confirm that SA is using these preferences?

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.

Thanks for any guidance in this matter.






__________________________________________________ ________
Find your next car at http://autos.yahoo.ca


-------------------------------------------------------
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
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/...fo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/