omail-ospam

[Omail-ospam] ping / mysql 4.1?

[Olivier M. <om-...@om...>]

Hello,

Just wondering if there is still anyone alive around,
and using the ospam scripts :-)

I still do on my own servers, but will need to make
some updates because of the mysql 4.1 timestamp issues
(new format): got to adapt the code... or maybe somebody
already did that? 

regards,
Olivier

-- 
_______________________________________________________
 Olivier Müller - PGP key ID: 0x0E84D2EA - Switzerland 
    E-Mail: http://omx.ch/mail/ - AIM/iChat: swix3k

Re: [Omail-ospam] ping / mysql 4.1?

[Joe Z. <joe...@za...>]

Olivier Mueller wrote:

>Hello,
>
>Just wondering if there is still anyone alive around,
>and using the ospam scripts :-)
>  
>
I'm pretty sure I'm still alive and I'm definitely still using 
oMail-admin 1.0-alpha on Redhat9 to manage about 178 virtual accounts. I 
use it because it has all the features I need: spamassassin, away 
messages, forwarding, lists, etc...

Re: [Omail-ospam] ping / mysql 4.1?

[Olivier M. <om-...@om...>]

On Wed, 2005-07-13 at 10:13 +0200, Olivier Mueller wrote:
> I still do on my own servers, but will need to make
> some updates because of the mysql 4.1 timestamp issues
> (new format): got to adapt the code... 

So, I guess it's working now. First I tried to change the
queries by replacing "SELECT ts" by "SELECT ts+0 as ts": works,
but not in WHERE clause -> can not be used :/

Current solution:

1) adapt table structure of 'dotqmail'  (bigint -> varchar):
	ALTER TABLE `dotqmail` CHANGE `lastprefchange` `lastprefchange`\
        VARCHAR( 30 ) NOT NULL DEFAULT '0'

2) relpace this at line 496:

	if ($lastprefchange == $spam_ts) { $ts_changed = 0; } 
           else { $ts_changed = 1; }
    by

        if ($lastprefchange eq $spam_ts) { $ts_changed = 0; } 
           else { $ts_changed = 1; }


And it should do the trick. Side effect: your users will get
a mail "ospam settings changed" after the code change, so 
you may want to stop the mail-info feature on the first run.

Tested on a 4.1 and a 4.0 server, and it looks fine so far. 

regards,
Olivier