SQL Accounting oddness

[John Williams]

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-
> 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 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-
> > 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
> 
> 
> -
> 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