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@lists.freeradius.org [mailto:freeradius-users-bounces+droze=digiweb.ie@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@lists.freeradius.org [mailto:freeradius-users- bounces+john.williams=eurisp.co.uk@lists.freeradius.org] 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
- 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
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@lists.freeradius.org [mailto:freeradius-users- bounces+john.williams=eurisp.co.uk@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
-----Original Message----- From: freeradius-users-bounces+droze=digiweb.ie@lists.freeradius.org [mailto:freeradius-users-bounces+droze=digiweb.ie@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@lists.freeradius.org [mailto:freeradius-users- bounces+john.williams=eurisp.co.uk@lists.freeradius.org] 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
- 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
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@lists.freeradius.org [mailto:freeradius-users- bounces+john.williams=eurisp.co.uk@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@lists.freeradius.org [mailto:freeradius-users- bounces+john.williams=eurisp.co.uk@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
-----Original Message----- From: freeradius-users-bounces+droze=digiweb.ie@lists.freeradius.org [mailto:freeradius-users-bounces+droze=digiweb.ie@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@lists.freeradius.org [mailto:freeradius-users- bounces+john.williams=eurisp.co.uk@lists.freeradius.org] 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
- 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
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@lists.freeradius.org [mailto:freeradius-users- bounces+john.williams=eurisp.co.uk@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@lists.freeradius.org [mailto:freeradius-users- bounces+john.williams=eurisp.co.uk@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@lists.freeradius.org [mailto:freeradius-users- bounces+john.williams=eurisp.co.uk@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
-----Original Message----- From: freeradius-users-bounces+droze=digiweb.ie@lists.freeradius.org [mailto:freeradius-users- bounces+droze=digiweb.ie@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@lists.freeradius.org [mailto:freeradius-users- bounces+john.williams=eurisp.co.uk@lists.freeradius.org] 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
- 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
participants (2)
-
David Roze -
John Williams