Hello Igor, Found the problem, which is 100% my fault: you can't save a timestamp in a datetime field. Simply change unix_timestamp() to from_unixtime(unix_timestamp()) in mysql/dbmysql.c and it will fix this (patch attached, if you want it). When I tested that I didn't have that additional_conditions line, so the date was never actually used (we have it setup under postgres, not mysql, for our own uses).
Jesse ---- Original Message ---- From: Igor Olemskoi <dbmail@dbmail.org> To: dbmail@dbmail.org Subject: RE: [Dbmail] latest cvs & pbsp Sent: Thu, 20 Mar 2003 17:35:14 +0200 (EET) > Hi Jesse, > > > There was a recent change that reads the date from the database > > server (it uses unix_timestamp() for mysql, and current_timestamp > > for pgsql), but it should be in the same format as previously. > > You're using mysql, iirc. What sql query are you using to check the > > pbsp table (eg. from your mta)? > > below is a cut from pbsp.cf (postfix 2 series) > > dbname = dbmail > table = pbsp > hosts = unix:/tmp/mysql.sock > select_field = since > where_field = ipnumber > additional_conditions = and unix_timestamp() - unix_timestamp(since) <= 18000 > > _______________________________________________ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- End Original Message -- -- Jesse Norell jesse (at) kci.net
dbmail-20030320-mysql_pbsp_fix.patch
Description: Binary data
