Author Topic: Plug-in for SpamAssassin MYSQL Settings  (Read 21320 times)

Offline mike413

  • Jr. Member
  • **
  • Posts: 12
Plug-in for SpamAssassin MYSQL Settings
« on: August 21, 2006, 07:13:25 PM »
Hi all,

I will try to code in PHP a plugin for mysql user_pref spamassassin.

I think it's easy, but if anyone want to try to code this with me, let me know.

I would like to try to code an interface like this: http://wiki.apache.org/spamassassin/WebUserInterfaces
but include into RoundCube webmail

Enjoy, and see you for the first test.

Mike.

Offline xoqez

  • Jr. Member
  • **
  • Posts: 84
Re: Plug-in for SpamAssassin MYSQL Settings
« Reply #1 on: August 22, 2006, 04:35:36 AM »
What exactly will users be able to change?
--
Venond; using roundcube since June 2006
www.venond.com

Offline mike413

  • Jr. Member
  • **
  • Posts: 12
Re: Plug-in for SpamAssassin MYSQL Settings
« Reply #2 on: August 22, 2006, 04:52:54 AM »
Quote from: xoqez
What exactly will users be able to change?

With this, you can add some personnal rules and manage your settings. For example:  

You can set the spam level to 3.0
You can add a personnal blacklist_from
You can also add personnal whitelist_from, etc.
You can set the rewrite_subject like: *****SPAM***** or *****JUNK*****  
and it's only for one user.

Any user that have an imap or pop account can set personnal settings.

Of course, you need configure spamassassin for using MySQL user_pref, but i think it's good.
http://wiki.apache.org/spamassassin/UsingSQL


It's my personnal position.

Mike

Offline mike413

  • Jr. Member
  • **
  • Posts: 12
Re: Plug-in for SpamAssassin MYSQL Settings
« Reply #3 on: August 22, 2006, 03:36:54 PM »
Hi all,

That works!

This is my first step of SpamAssassin MYSQL Settings into RC.

is not very good at this time, but in the next i will try to make a better version.

So, you can see my scrennshot.

Actually it based on webuserprefs for spamassassin into an iFrame.
http://sourceforge.net/projects/webuserprefs/

But is juste the first version

Offline oskare100

  • Newbie
  • *
  • Posts: 3
Re: Plug-in for SpamAssassin MYSQL Settings
« Reply #4 on: August 28, 2006, 11:17:06 AM »
Hello,
If you plan to when do you think you will release a version to the public? I'd be very interested in this mod.

Best Regards

Offline xoqez

  • Jr. Member
  • **
  • Posts: 84
Re: Plug-in for SpamAssassin MYSQL Settings
« Reply #5 on: September 08, 2006, 09:31:31 PM »
This is really good I am going to look at doing this.

Are you going to release the mod to the public
--
Venond; using roundcube since June 2006
www.venond.com

Offline xoqez

  • Jr. Member
  • **
  • Posts: 84
Re: Plug-in for SpamAssassin MYSQL Settings
« Reply #6 on: September 09, 2006, 12:15:07 AM »
Hi,

One note if you can do it without the iframe it would be better as only IE supports Iframe.

Some other browsers may also but I know Camino and Safari do not
--
Venond; using roundcube since June 2006
www.venond.com

Offline Pete

  • Jr. Member
  • **
  • Posts: 15
Re: Plug-in for SpamAssassin MYSQL Settings
« Reply #7 on: September 09, 2006, 10:12:36 AM »
Firefox and Netscape support Iframes as does Opera.

So... Mac browsers don't have this basic functionality? :-\

Offline mike413

  • Jr. Member
  • **
  • Posts: 12
Re: Plug-in for SpamAssassin MYSQL Settings
« Reply #8 on: September 12, 2006, 01:48:31 PM »
Of course, Firefox, IE, Safari for OSX work fine with iframe (I'm working on a Mac). I don't know if opera work with this functionality, but i'm sure that work fine for many browser.

NB: As soon as possible, i would like to upload my config (RoundCube WebMail) on this forum. Also, i have stopped temporary my work on RC because many plug-in miss. I have installed Horde-IMP. Sorry everybody :'(

But i waiting for update of new RC.

Best regards.

Mikael.


Quote from: Pete
Firefox and Netscape support Iframes as does Opera.

So... Mac browsers don't have this basic functionality? :-\

Offline gmcrist

  • Newbie
  • *
  • Posts: 1
Re: Plug-in for SpamAssassin MYSQL Settings
« Reply #9 on: September 14, 2006, 03:02:20 PM »
mike413: How far along are you on your project? Are you still developing/planning to release?

I have been in the process of writing a patch to RC to manage SQL based SpamAssassin configuration.

I don't want to be redundant. If you have working code, I'll stop my development and possibly debug/test what you release.


Offline KingOfN00bz

  • Newbie
  • *
  • Posts: 7
Re: Plug-in for SpamAssassin MYSQL Settings
« Reply #10 on: October 23, 2006, 09:30:37 AM »
I'd also like this plugin. When will it become public?

Offline matt2minger

  • Newbie
  • *
  • Posts: 7
Re: Plug-in for SpamAssassin MYSQL Settings
« Reply #11 on: October 25, 2006, 03:23:38 PM »
can anyone help me with my config of files. pm me

Cheers

Offline tomekp

  • Jr. Member
  • **
  • Posts: 11
Re: Plug-in for SpamAssassin MYSQL Settings
« Reply #12 on: November 08, 2006, 08:45:54 AM »
I want to ask, how's work on this plugin?
If you started some work, could you pass it to me, I can help you to finish it.
escape from the execution is futile.

Offline mike413

  • Jr. Member
  • **
  • Posts: 12
Re: Plug-in for SpamAssassin MYSQL Settings
« Reply #13 on: December 11, 2006, 06:22:15 PM »
Hi there,

I never forgot you.

There is my package rc webmail.

Juste untar, and modify the config files in the conf dir. for vpopmail, go to ./ext/ directory and modify the config.

NOTE: I don't no why, but for some unknow reason, the .bz2 file's is not supported on this forum. So, juste rename the .bz to .bz2
Code: [Select]
computer@unix# cp ./roundCubeWebmail_vpopmail_spamassassin.tar.bz ./roundCubeWebmail_vpopmail_spamassassin.tar.bz2
Then:
Code: [Select]
computer@unix# tar -xjvpf ./roundCubeWebmail_vpopmail_spamassassin.tar.bz2

See you on the web.

Mike.

Offline helga

  • Jr. Member
  • **
  • Posts: 17
Re: Plug-in for SpamAssassin MYSQL Settings
« Reply #14 on: December 25, 2006, 02:27:44 PM »
hello,

is this plugin only for root ?