Dave There aren't any errors in the mysql log at all. Not even the radius log show any errors. Like I said I run Radius in debug mode, radiusd -X, and see it trying to write to the accounting table but no errors. When I took the line it was trying to insert and replaced it with real values instead of variables it wrote to the table ok.
So I'm still at a loose. John > -----Original Message----- > From: freeradius-users- > [EMAIL PROTECTED] > [mailto:freeradius-users- > [EMAIL PROTECTED] On Behalf Of > David Roze > Sent: 12 October 2006 11:29 > To: FreeRadius users mailing list > Subject: RE: SQL Accounting oddness > > Hi John, > > I would try to run Mysql with error and warning logging like > --log-error=/var/log/mysql-errors --log-warnings > And check the logs > > Have you also tried to copy the query sent from Radius and execute it > manually? You might get your solution there > > David > > -- > http://www.netexpertise.eu > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > On Behalf Of John Williams > Sent: 12 October 2006 08:26 > To: 'FreeRadius users mailing list' > Subject: Spam:RE: SQL Accounting oddness > > All the ports are open. > The authentication packets and accounting packets are hitting the server > ok. > The authentication is being checked against the radcheck table in SQL > and > authenticates users. > But the accounting information isn't being written to the radacct table, > even though I can see freeradius sending it if I run radius in debug > mode. > > John > > > -----Original Message----- > > From: freeradius-users- > > [EMAIL PROTECTED] > > [mailto:freeradius-users- > > [EMAIL PROTECTED] On Behalf Of > Sean > > Sent: 11 October 2006 17:39 > > To: freeradius-users@lists.freeradius.org > > Subject: RE: SQL Accounting oddness > > > > Hi, > > > > Check that you have all the ports used by FreeRadius open. It looks as > > if the accounting traffic is not getting through to the server. > > > > Let me know if I'm right. > > > > > > Regards, > > > > Sean Bracken > > > > http://swarmhotspots.com > > > > > > - > > List info/subscribe/unsubscribe? See > > http://www.freeradius.org/list/users.html > > > > -- > > No virus found in this incoming message. > > Checked by AVG Free Edition. > > Version: 7.0.408 / Virus Database: 268.13.2/471 - Release Date: > 10/10/2006 > > > > -- > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.0.408 / Virus Database: 268.13.2/471 - Release Date: > 10/10/2006 > > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.0.408 / Virus Database: 268.13.2/471 - Release Date: 10/10/2006 > -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.0.408 / Virus Database: 268.13.2/471 - Release Date: 10/10/2006 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
