Hi, I’ve installed cluebringer-v2.0.14 and MySql 5.1 on a linux box for testing before I move it onto my production servers. I connected it into postfix and brought both policyd and postfix up. When I attempted to send an email through my test server, I got the following error:
[TRACKING] ERROR: Failed to select session tracking info: awitpt::db::dblayer::DBSelect(126): Error executing select: Unknown column 'UnixTimestamp' in 'field list’ This, of course, is a problem in the distro since the software is trying to access the session_tracking table and it expects the column UnixTimeStamp and it does not exists in the database. I went back to the database folder in the distro download, and none of the *.tsql files that are used to built the database on MySQL contained that column. So, I went int and manually changed the column name from Timestamp to UnixTimestamp, and that fixed the problem. The core.tsql file needs to be corrected in the download. So now I don’t get any error and since I was manually testing, I set up a default outbound policy with a limit of 5 messages per day before and expected rejections after I exceeded that number. But no, it did not happen. I looked in the session_tracking table and there were no entries. Any ideas about what’s going on on where I need to look to find the problem would be most appreciated. Thanks, Rob Tanner UNIX Services Manager Linfield College, McMinnville Oregon ITS will never ask you for your password. Please don’t share yours with anyone!
_______________________________________________ Users mailing list [email protected] http://lists.policyd.org/mailman/listinfo/users_lists.policyd.org
