Robert Gabriel wrote:
Hello all,
Our network had some change somewhere and now all MySQL insert queries are failing with the last field been truncated and the character count is always 4097 from the CDRs
What does that mean? What's a "character count"?
been sent by our NAS (Acme Packet SBC).
Having looked at the source we see:
src/modules/rlm_sql/conf.h src/modules/rlm_sql/rlm_sql.c
/* SQL defines */ #define MAX_QUERY_LEN 4096 #define SQL_LOCK_LEN MAX_QUERY_LEN
I'm not sure here, can we just increase to 8192 etc. or is this being stupid? Can I edit the above and recompile?
Yes. But I fail to see why the SQL queries are huge. There's really no reason for this.
MySQL log (shortened for brevity's sake):
INSERT into accounting (AcctStatusType, AcctTerminateCause, CalledStationId, NASIdentifier, h323setuptime, h323connecttime, h323disconnecttime, h323disconnectcause) values ('0', '0', '0', '0', '0', '0', '0', 'sip:0738063114@h
Think a bit: that line looks truncated, but there is NO WAY it's 4K in size. Something else is going on. Find out what, and fix it. Alan DeKok.