Max Query Length Exceeded and Field Truncated

[Alan DeKok]

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