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:0738063...@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.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
