SQL Accounting oddness

[John Williams]

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-
> bounces+john.williams=eurisp.co.uk at lists.freeradius.org
> [mailto:freeradius-users-
> bounces+john.williams=eurisp.co.uk at lists.freeradius.org] 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: freeradius-users-bounces+droze=digiweb.ie at lists.freeradius.org
> [mailto:freeradius-users-bounces+droze=digiweb.ie at lists.freeradius.org]
> 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-
> > bounces+john.williams=eurisp.co.uk at lists.freeradius.org
> > [mailto:freeradius-users-
> > bounces+john.williams=eurisp.co.uk at lists.freeradius.org] On Behalf Of
> Sean
> > Sent: 11 October 2006 17:39
> > To: freeradius-users at 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