<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; "><BR><DIV><DIV>On 4 Jul 2006, at 12:05, Graeme Hinchliffe wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite">Hi,<DIV><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN>I have just (as of yesterday) upgraded FreeRADIUS from 1.0.3 to 1.1.2 keeping all the same config files. I am running it on a Debian Woody system and using Postgres 7.4.7 as the database. This particular box is solely for RADACCT and only uses RADIUS as a test to test the state of the service/db for health checks.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN>I have postgres configured to dump any SQL lines which throw up an error and I have seen a large number being logged failing to insert the Framed-IP-Address attribute, in the dumped SQL string the IP Address is a hex value instead of a dotted quad which fails the insert. The RADACCT packets causing this are not just coming from one NAS either, and accounting still seems to be happening on the most part.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>any ideas? or have i found a bug ?</DIV></BLOCKQUOTE><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Further to this, I have just noticed that this doesn't seem to just be restricted to the IP address, but also the Session ID field. Instead of displaying the session ID as say </DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>0202FFFF68001A6C-44A618FF</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>I am seeing:</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>0x303230324646464636383030314136432d3434413631384646</DIV><DIV><BR class="khtml-block-placeholder"></DIV></DIV><BR><DIV> <P style="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Helvetica" size="3" style="font: 12.0px Helvetica">-----</FONT></P> <P style="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Helvetica" size="3" style="font: 12.0px Helvetica">Graeme Hinchliffe (BSc)</FONT></P> <P style="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Helvetica" size="3" style="font: 12.0px Helvetica">Core Systems Designer</FONT></P> <P style="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Helvetica" size="3" style="font: 12.0px Helvetica">Zen Internet (<A href="http://www.zen.co.uk">http://www.zen.co.uk</A>/)</FONT></P> <P style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; min-height: 14.0px"><BR></P> <P style="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Helvetica" size="3" style="font: 12.0px Helvetica">Direct: 0845 058 9074</FONT></P> <P style="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Helvetica" size="3" style="font: 12.0px Helvetica">Main<SPAN class="Apple-converted-space"> </SPAN>: 0845 058 9000</FONT></P> <P style="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Helvetica" size="3" style="font: 12.0px Helvetica">Fax <SPAN class="Apple-converted-space"> </SPAN>: 0845 058 9005</FONT></P> </DIV><BR></BODY></HTML>