On 04/02/2014 02:47 PM, Rob Tanner wrote:
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,
Can you show me what you ran to create the schema file?
-N
_______________________________________________
Users mailing list
[email protected]
http://lists.policyd.org/mailman/listinfo/users_lists.policyd.org
