MySQL DB and /n in Cisco-AVPair problem

[Alan DeKok]

On Jul 19, 2017, at 11:11 AM, Andy Smith <a.smith at ldex.co.uk> wrote:
> With both the 1.x and 3.x systems we get "response: Access-Accept" and a
> load of details such as Service-Type, Tunnel-Password etc. However I see
> differences for non printing characters such as "/n". So for the
> Cisco-AVPair in the output in NTRadPing I see on 1.x: 
> 
> lcp:interface-config=ip unnumbered loopback 2003\n 
> 
> But on 3.x I see: 
> 
> lcp:interface-config=ip unnumbered loopback 2003\0x0a 

  Where do you see this?  The debug output?

  If so, that only matters for the debug output.  If you want to see what's in the packet, use wireshark.

> The output from 1.x is exactly how the data is entered and displays
> direct in MySQL. I've tried double escaping the "\" but it doesn't make
> any difference. I see that 0x0a is the ASCII encoding for \n, has
> something changed in FreeRadius WRT this? Or perhaps its an issue at the
> MySQL level?

  Since you don't say where you see this, I can't offer any advice.

> I also note the output for the Tunnel-Password displays differently
> between 1.x and 3.x. 

  And that difference is.... what?

  Alan DeKok.