SQL Accounting oddness - SOLVED

[John Williams]

Ok solved this one.
Bloody sys admin hadn't opened the firewall for UDP packets on port 1646.
But he had opened TCP on port 1646, fat lot of good.

Sorry for taking up everyone's time with something that was easily solved if
I hadn't taken someone's word about the firewall.

Thanks
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: 13 October 2006 11:45
> To: 'FreeRadius users mailing list'
> Subject: RE: SQL Accounting oddness
> 
> 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
> 
> 
> -
> 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.3/473 - Release Date: 12/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