Here is something else I found. I run radius in debug mode, radiusd -X, after altering the line in sql.conf to:
sqltrace = yes sqltracefile = ${logdir}/sqltrace.sql So that it would create the sql trace logfile as it does on my other radius server. But the logfile did not get created although in debug mode I could see attempts to log to the radacct table. I'm at a total loose as to where the problem is. I'm running: Centos 4.4 Final freeradius-1.0.1-3.RHEL4.3 freeradius-mysql-1.0.1-3.RHEL4.3 Exactly the same as my other radius server. Anyone got any ideas at all? John > -----Original Message----- > From: freeradius-users- > [EMAIL PROTECTED] > [mailto:freeradius-users- > [EMAIL PROTECTED] On Behalf Of John > Williams > Sent: 12 October 2006 13:10 > To: 'FreeRadius users mailing list' > Subject: RE: SQL Accounting oddness > > 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 > > -- > 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.3/473 - Release Date: 12/10/2006 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html