Hi List, ok next issue I have :P I have attempted to configure freeradius to write accounting data to MySQL, however currently its not working. No data is being written to MySQL and the Radius client is complaining its not recieving a reply for accounting requests. I subsituted the "detail" setting in the "accounting" config section of radiusd.conf for "sql" and modifyied the sql.conf as seemed necessary. As soon as I switch this back to "detail" my Radius client starts recieving replies from freeradius once again :S I can see from the MySQL log that radiusd is successfully establishing a connection to MySQL at startup: 080120 19:14:49 61 Connect root@localhost on radius 62 Connect root@localhost on radius 63 Connect root@localhost on radius 64 Connect root@localhost on radius 65 Connect root@localhost on radius 65 Query SELECT * FROM nas 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 when running "radiusd -Xf" anyone any ideas what more I can do to identify the issue?? thanks Andy.
Andy Smith wrote:
I have attempted to configure freeradius to write accounting data to MySQL, however currently its not working. No data is being written to MySQL and the Radius client is complaining its not recieving a reply for accounting requests. I subsituted the "detail" setting in the "accounting" config section of radiusd.conf for "sql" and modifyied the sql.conf as seemed necessary. As soon as I switch this back to "detail" my Radius client starts recieving replies from freeradius once again :S
So the sql module isn't logging anything.
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 when running "radiusd -Xf"
anyone any ideas what more I can do to identify the issue??
Post the output of radiusd -X here, as suggested in the FAQ, README, INSTALL, and (almost) daily. Alan DeKok.
participants (2)
-
Alan DeKok -
Andy Smith