Roundcube Community Forum

Third Party Contributions => Old Style Plug-Ins => Topic started by: mike413 on August 21, 2006, 07:13:25 PM

Title: Plug-in for SpamAssassin MYSQL Settings
Post by: mike413 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.
Title: Re: Plug-in for SpamAssassin MYSQL Settings
Post by: xoqez on August 22, 2006, 04:35:36 AM
What exactly will users be able to change?
Title: Re: Plug-in for SpamAssassin MYSQL Settings
Post by: mike413 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
Title: Re: Plug-in for SpamAssassin MYSQL Settings
Post by: mike413 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
Title: Re: Plug-in for SpamAssassin MYSQL Settings
Post by: oskare100 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
Title: Re: Plug-in for SpamAssassin MYSQL Settings
Post by: xoqez 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
Title: Re: Plug-in for SpamAssassin MYSQL Settings
Post by: xoqez 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
Title: Re: Plug-in for SpamAssassin MYSQL Settings
Post by: Pete 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? :-\
Title: Re: Plug-in for SpamAssassin MYSQL Settings
Post by: mike413 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? :-\
Title: Re: Plug-in for SpamAssassin MYSQL Settings
Post by: gmcrist 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.

Title: Re: Plug-in for SpamAssassin MYSQL Settings
Post by: KingOfN00bz on October 23, 2006, 09:30:37 AM
I'd also like this plugin. When will it become public?
Title: Re: Plug-in for SpamAssassin MYSQL Settings
Post by: matt2minger on October 25, 2006, 03:23:38 PM
can anyone help me with my config of files. pm me

Cheers
Title: Re: Plug-in for SpamAssassin MYSQL Settings
Post by: tomekp 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.
Title: Re: Plug-in for SpamAssassin MYSQL Settings
Post by: mike413 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.
Title: Re: Plug-in for SpamAssassin MYSQL Settings
Post by: helga on December 25, 2006, 02:27:44 PM
hello,

is this plugin only for root ?
Title: Re: Plug-in for SpamAssassin MYSQL Settings
Post by: seansan on December 27, 2006, 09:01:55 AM
Trying out your package .. would be nice though if we could add this to "any" version of roundcube. It is a whole new install - without the help/etc (for instance, I dont know the tables for spamassasin).

funny thing. When I click on the spam tab in settings I have to log on (dont know to what) and am redirected to your winflash server https://mail.winflash.ch/imp/login.php. update: I uncommented the AUTH setting and used imap.php that gave me a login popup

Dont know what is happening. Do you have a list of altered files? and added files? maybe we can try and make this a more generic plugin

---- 2 hours later. I think this script still needs some updating to become generic for all. I tried capturing a user_id to give the userprefs file a user specific name. I did not succeed. Does anyone know where to fetch a userspecific string - include ... ?
Title: Re: Plug-in for SpamAssassin MYSQL Settings
Post by: mike413 on January 16, 2007, 11:34:16 AM
Quote
redirected to your winflash server https://mail.winflash.ch/imp/login.php.

Hi,

Sorry about that :-[

I don't know what's happened.

I will try to re-check the package and upload when it's finish.



Quote from: seansan
Trying out your package .. would be nice though if we could add this to "any" version of roundcube. It is a whole new install - without the help/etc (for instance, I dont know the tables for spamassasin).

funny thing. When I click on the spam tab in settings I have to log on (dont know to what) and am redirected to your winflash server https://mail.winflash.ch/imp/login.php. update: I uncommented the AUTH setting and used imap.php that gave me a login popup

Dont know what is happening. Do you have a list of altered files? and added files? maybe we can try and make this a more generic plugin

---- 2 hours later. I think this script still needs some updating to become generic for all. I tried capturing a user_id to give the userprefs file a user specific name. I did not succeed. Does anyone know where to fetch a userspecific string - include ... ?
Title: Re: Plug-in for SpamAssassin MYSQL Settings
Post by: mrjaguar on February 05, 2007, 04:28:45 PM
Hello,
 any idea of a timeframe for this? and will this be a patch/mod or a completely separate version of the program?

thanks,
 pat
Title: Re: Plug-in for SpamAssassin MYSQL Settings
Post by: miron on May 30, 2007, 06:22:25 AM
I solved the problem with the redirection. Its in auth/imap.php ... change it there and ... It wil NOT work.
Title: Re: Plug-in for SpamAssassin MYSQL Settings
Post by: tshadwick on August 30, 2007, 07:16:38 PM
Hrm....if this isn't coming along, I'll need to pay someone to finish it. I need the SpamAssasin LDAP prefs to be accessible. If the MySQL one were done, adding LDAP user_prefs support is simple enough.

Anyone interested let me know.
Title: Re: Plug-in for SpamAssassin MYSQL Settings
Post by: neo123 on October 05, 2007, 02:18:52 PM
hi there,

i installed the file but spamass. isn't showing up in mu roundcube?
Title: Re: Plug-in for SpamAssassin MYSQL Settings
Post by: liesmich.txt on October 11, 2007, 03:25:46 PM
Hi there...

Did i need a local imap or or the spamassassin to use this plugin? Or is it included?
which files i need to edit?

Sry for my bad english :)

Greatings.. 8)
Title: Re: Plug-in for SpamAssassin MYSQL Settings
Post by: neo123 on October 12, 2007, 01:32:27 PM
i am using imap and directadmin ! where do i extract the ./roundCubeWebmail_vpopmail_spamassassin.tar.bz2 file cause i am not using vpopmail

thanks