Thread: [Omail-ospam] ping / mysql 4.1?
Brought to you by:
swix
From: Olivier M. <om-...@om...> - 2005-07-13 08:13:13
|
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 |
From: Joe Z. <joe...@za...> - 2005-07-13 22:14:56
|
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... |
From: Olivier M. <om-...@om...> - 2005-07-13 23:25:19
|
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 |