i have a consolidated and functioning system with the spam user preferencies saved in mysql server. i have used a modified query and i have a lot of preferencies saved, for username field I have:
Username: $GLOBAL intercept all email for all domains configured;
Username: %mydomain.com intercept all email for this domain;
intercept all email for this user;
I have followed this link: http://wiki.apache.org/spamassassin/UsingSQL
Now, i have installed ispconfig3 ( ubuntu 10.4 tls )with roundcube for webmail. i have find a plugin for sql database prefs and if i use it, it the correct preferencies for the single user going in the mysql database.
I have see, when i log in to ispconfig3, with a client login, insert withe anc blk lists preferencies for the entire domain.
- is possible and how, use a single database for spamassassin prefs in mysql utilizzable for ispconfig3 ? if is possible, there is a control panel similar webuserprefs,(http://webuserprefs.sourceforge.net
) for administer the spam preferencies utilizzable for customer client login ?
- use a single spamassassin only on the ispconfig3 machine, but with the spamassassin preferencies compatible with my current system.
- permit a client to insert is own spam preferencies for domain or domains that administer;
- permit a single user to insert is preferencies for spamassassin from webmail or from a control panel ( in this case with roundcube and sql pligin im ok, but spamassassin installed for ispconfig3 use it ? )
thx in adv,