<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16587" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi List,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> ok next issue I have :P</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have attempted to configure freeradius to write
accounting data to MySQL, however currently its not working. No data is being
written</FONT></DIV>
<DIV><FONT face=Arial size=2>to MySQL and the Radius client is complaining its
not recieving a reply for accounting requests. I subsituted the "detail" setting
in</FONT></DIV>
<DIV><FONT face=Arial size=2>the "accounting" config section of radiusd.conf for
"sql" and modifyied the sql.conf as seemed necessary. As soon as I switch
this</FONT></DIV>
<DIV><FONT face=Arial size=2>back to "detail" my Radius client starts recieving
replies from freeradius once again :S</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I can see from the MySQL log that radiusd is
successfully establishing a connection to MySQL at startup:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>080120 19:14:49 61
Connect <A href="mailto:root@localhost">root@localhost</A> on
radius<BR>
62 Connect <A href="mailto:root@localhost">root@localhost</A> on
radius<BR>
63 Connect <A href="mailto:root@localhost">root@localhost</A> on
radius<BR>
64 Connect <A href="mailto:root@localhost">root@localhost</A> on
radius<BR>
65 Connect <A href="mailto:root@localhost">root@localhost</A> on
radius<BR>
65 Query SELECT * FROM nas<BR></FONT></DIV>
<DIV><FONT face=Arial size=2>But after that there is no activity in the MySQL
log :S And I have no errors logged from MySQL or radiusd, nor can I see any
errors</FONT></DIV>
<DIV><FONT face=Arial size=2>when running "radiusd -Xf"</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> anyone any ideas what more I can
do to identify the issue??</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> thanks
Andy.</DIV></FONT></BODY></HTML>