SQL Accounting oddness

[David Roze]

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