Max Query Length Exceeded and Field Truncated

Alan DeKok aland at
Thu Mar 18 18:07:11 CET 2010

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
> 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 at h

  Think a bit: that line looks truncated, but there is NO WAY it's 4K in

  Something else is going on.  Find out what, and fix it.

  Alan DeKok.

More information about the Freeradius-Users mailing list