Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 17th May 2010, 11:24
gigizmo gigizmo is offline
Junior Member
 
Join Date: May 2010
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default spamassassin use the same sql prefs database

Hallo,

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;
Username: user@mydomain.com 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.

My question:
- 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 ?

My target:
- 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,

gigizmo
Reply With Quote
Sponsored Links
  #2  
Old 18th May 2010, 13:32
gigizmo gigizmo is offline
Junior Member
 
Join Date: May 2010
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default Solution

Ok, i have find why is not possible to do what i want.

thx.
Reply With Quote
  #3  
Old 18th May 2010, 13:43
damir damir is offline
Senior Member
 
Join Date: Jun 2006
Posts: 375
Thanks: 11
Thanked 51 Times in 42 Posts
Default

It's always nice to write how you have solved the problem so other people can learn from it
Reply With Quote
  #4  
Old 18th May 2010, 13:50
gigizmo gigizmo is offline
Junior Member
 
Join Date: May 2010
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default Solution

Hallo Damir,

Sorry, but for me, There is no solution is this case. Im in search to a method to use spamassassin for users preferencies, but amavis-new is not able to function in this mode with a db used for spamassassin in my old configuration.

I have read documentation for amavis and it is not compatible with sql spamassassin preferencies.

thx,

gigizmo
Reply With Quote
  #5  
Old 18th May 2010, 14:23
damir damir is offline
Senior Member
 
Join Date: Jun 2006
Posts: 375
Thanks: 11
Thanked 51 Times in 42 Posts
 
Default

Quote:
Originally Posted by gigizmo View Post
Hallo Damir,

Sorry, but for me, There is no solution is this case. Im in search to a method to use spamassassin for users preferencies, but amavis-new is not able to function in this mode with a db used for spamassassin in my old configuration.

I have read documentation for amavis and it is not compatible with sql spamassassin preferencies.

thx,

gigizmo
Sorry, i thought you found a solution To much coffee for me today.
Reply With Quote
Reply

Bookmarks

Tags
preferencies, spam, spamassassin, sql, standard

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Chilispot on dd-wrt + freeradius / phpmyprepaid on Centos 5 wrong user password treeman HOWTO-Related Questions 0 31st May 2009 06:49
ISP Config hesitation when opening web pages frankb Installation/Configuration 7 15th December 2008 13:06
ISPconfig 2.2.21 Load Averange Very High mmiyamoto General 3 6th March 2008 13:13
Question on Clamscan and SpamAssassin AZMel Installation/Configuration 3 11th January 2007 19:56
ISPConfig and adding an SQL Database Texaskilt General 1 7th December 2006 09:52


All times are GMT +2. The time now is 12:06.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.