Re: log loading of configuration files [was Re: Accounting to MySQL not working]

2010-06-07 Thread Alan DeKok
Josip Rodin wrote: Then again, there is no clear indication to users which part of the large debug output is important and which part is ignorable, so even if they don't ignore it, it may still actually be too complicated for them to handle. The alternative is to run a system that you don't

Re: log loading of configuration files [was Re: Accounting to MySQL not working]

2010-06-07 Thread Josip Rodin
On Mon, Jun 07, 2010 at 10:49:01AM +0200, Alan DeKok wrote: Josip Rodin wrote: Then again, there is no clear indication to users which part of the large debug output is important and which part is ignorable, so even if they don't ignore it, it may still actually be too complicated for them

Re: log loading of configuration files [was Re: Accounting to MySQL not working]

2010-06-06 Thread Josip Rodin
On Wed, Jun 02, 2010 at 01:46:02PM +0200, Alan DeKok wrote: When they run it with -X, they'll see the packets as they come in and that's good for the debugging of the per-request logic, but a lot of this initial text will scroll down the screen as if everything in it is all right, and they

log loading of configuration files [was Re: Accounting to MySQL not working]

2010-06-02 Thread Josip Rodin
On Tue, Jun 01, 2010 at 02:19:31PM +0200, joy wrote: On Sat, May 29, 2010 at 10:42:06AM +0200, Alan DeKok wrote: Even Apache reads the entire directory: ... # Include the virtual host configurations: Include /etc/apache2/sites-enabled/ ... So what's the solution? Why isn't

Re: log loading of configuration files [was Re: Accounting to MySQL not working]

2010-06-02 Thread Alan DeKok
Josip Rodin wrote: It occurs to me that it would be a good idea to add an option that would allow users to log the entire initial configuration parsing on startup to the main log file, IOW log that part even if the server did not run with -X. Hmm... OK. When they run it with -X, they'll

Re: Accounting to MySQL not working

2010-06-01 Thread Josip Rodin
On Sat, May 29, 2010 at 10:42:06AM +0200, Alan DeKok wrote: Even Apache reads the entire directory: ... # Include the virtual host configurations: Include /etc/apache2/sites-enabled/ ... So what's the solution? Why isn't this a problem for Apache, and is a problem here? It stands

Re: Accounting to MySQL not working

2010-05-29 Thread Alan DeKok
John Dennis wrote: Hmm... we just had a discussion about how loading every configuration file in a directory trips folks up. Yet another example :-) We need a solution that is (a) easy, and (b) doesn't involve a massive re-name of files in the middle of a stable release? Even Apache reads

Re: Accounting to MySQL not working

2010-05-28 Thread Christoph Schwabl
Hi Alan, thank you for your response. according to the debug: +- entering group accounting {...} [detail]expand: /var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d - +/var/log/freeradius/radacct/192.168.1.10/detail-20100527 [detail]

Re: Accounting to MySQL not working

2010-05-28 Thread Alan DeKok
Christoph Schwabl wrote: this part is (and was) enabled please find below the configuration of the files (which is the same configuration as for 2.0.4 - this configuration is working for 2.0.4) however, it seems the sql line is ignored by the radius server This happens in one of two

Re: Accounting to MySQL not working

2010-05-28 Thread Christoph Schwabl
however, it seems the sql line is ignored by the radius server This happens in one of two cases: 1) the server is reading a *different* file than the one you're editing this exactly was the problem I had 2 files in /etc/raddb/sites-enabled default.original default It seems the

Re: Accounting to MySQL not working

2010-05-28 Thread John Dennis
On 05/28/2010 04:33 PM, Christoph Schwabl wrote: however, it seems the sql line is ignored by the radius server This happens in one of two cases: 1) the server is reading a *different* file than the one you're editing this exactly was the problem I had 2 files in

Re: Accounting to MySQL not working

2010-05-28 Thread Marinko Tarlac
:) Sure, its good idea to create backups but do not store them in the sites-enabled dir :) John Dennis wrote: On 05/28/2010 04:33 PM, Christoph Schwabl wrote: however, it seems the sql line is ignored by the radius server This happens in one of two cases: 1) the server is reading a

Re: Accounting to MySQL not working

2010-05-28 Thread John McDonnell
Making a backup of the file in sites-available would make more sense since the files in sites-enabled are only links to the files in sites-enabled. It is documented. ;) Marinko Tarlac mangi...@gmail.com wrote: :) Sure, its good idea to create backups but do not store them in the

Re: Accounting to MySQL not working

2010-05-27 Thread Alan Buxey
hi, according to the debug: +- entering group accounting {...} [detail]expand: /var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d - +/var/log/freeradius/radacct/192.168.1.10/detail-20100527 [detail] /var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to

Re: Accounting into MySQL

2009-05-15 Thread Tim Dressel
Yes, both. 2009/5/14 EasyHorpak.com i...@easyhorpak.com: is it freeradius and freeradius-mysql ? I'm doing some more testing using the suggestions from Edvin and Ivan (almost like the two ivan's), and will follow up. I think its just my misunderstanding of what accounting actually does. ;)

RE: Accounting into MySQL

2009-05-14 Thread Edvin Seferovic
1. Using NTRadPING, should I get entries in my radacct table? Are you sending accounting packets? If not - why should freeradius pass any request to accounting parts. 2. I have uncommented the sql_log, and all the detail log sections, and in the accounting section, and uncommented the sql in

Re: Accounting into MySQL

2009-05-14 Thread Ivan Kalik
I have some basic questions to better understand accounting into SQL. 1. Using NTRadPING, should I get entries in my radacct table? No. Those are authentication, not accounting requests. 2. I have uncommented the sql_log, and all the detail log sections, and in the accounting section, and

Re: Accounting into MySQL

2009-05-14 Thread EasyHorpak.com
is it freeradius and freeradius-mysql ? - Original Message - From: Tim Dressel tjdres...@gmail.com To: freeradius-users@lists.freeradius.org Sent: Friday, May 15, 2009 3:53 AM Subject: Accounting into MySQL Hi folks, I have an Ubuntu server 8.04.2 LTS running (pretty bare bones).

RE: Accounting in MySQL

2007-01-24 Thread DESEtech - German P. Santillan
- Argentina Tel/Fax: +54 (291) 456-5642 [EMAIL PROTECTED] http://www.desetech.com.ar From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] .org] On Behalf Of satish patel Sent: Tuesday, January 23, 2007 4:56 AM To: FreeRadius users mailing list Subject: Re: Accounting in MySQL Dear

RE: Accounting in MySQL

2007-01-24 Thread satish patel
: Accounting in MySQL Dear First check your radiusd -X debug log and find mysql connectivity debug if there any problem regarding connection ??? then check radius.conf file there is accounting option and put sql key word in it and u can also find some document on my website

Re: Accounting in MySQL

2007-01-23 Thread satish patel
Dear Find freeradius + Mysql document on my website http://geocities.com/satish_patel_2000_2000/ Satish Patel Alan DeKok [EMAIL PROTECTED] wrote: DESEtech - German P. Santillan wrote: But I don´t hace records in radacct Table. What is the problem? See the FAQ. Is the server

Re: Accounting in MySQL

2007-01-23 Thread satish patel
Dear First check your radiusd -X debug log and find mysql connectivity debug if there any problem regarding connection ??? then check radius.conf file there is accounting option and put sql key word in it and u can also find some document on my website

Re: Accounting in MySQL

2007-01-22 Thread Alan DeKok
DESEtech - German P. Santillan wrote: But I don´t hace records in radacct Table. What is the problem? See the FAQ. Is the server receiving accounting packets? Alan DeKok. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog - List

RE: accounting to mysql database

2004-03-31 Thread Kirti S. Bajwa
I have no idea how this posting ending up on freeRADIUS!! Kirt -Original Message- From: Kirti S. Bajwa [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 10:46 AM To: '[EMAIL PROTECTED]' Subject: RE: accounting to mysql database Hello List: I have installed and tested

Re: accounting to mysql database

2004-03-12 Thread Guy Fraser
This is a good suggestion. The MySQL schema should be changed, so that raddb is by default InnoDB. This is exactly the reason I have been using PostgreSQL for the last 6 or so years. Rather than using a different database for archived records just put the archived data into different tables.

Re: accounting to mysql database

2004-03-12 Thread Jeff Warnica
How about this scenario: (say it is March 1, SQL and col names from memory...) The 'live' table keeps up to two months (and a few hours) of data (January, February, March 1) Some time on March 1 you rotate out January CREATE TABLE jan_04 LIKE. INSERT INTO jan_04 SELECT * FROM radacct WHERE

Re: accounting to mysql database

2004-03-11 Thread Michael McFadden
One solution may be to change your insert statements in sql.conf from Insert to Insert Delayed. you can read some here: http://www.mysql.com/doc/en/INSERT_DELAYED.html Post back to the list if it works. I'm no guru, so back up your sql.conf before making changes :) -Mike - Original

Re: accounting to mysql database

2004-03-11 Thread Jeff Warnica
Not really a FreeRADIUS question, but anyway: For complex queries and/or queries with large result sets MySQL, using MyISAM tables, will produce a temporary table to fulfill the request. To ensure that it gets a consistent (temporary) table, MySQL locks the entire (real) table during this

Re: accounting to mysql database

2004-03-11 Thread Alan DeKok
Mike Sturdee [EMAIL PROTECTED] wrote: I have radius set up to log accounting to a MySQL database. It currently holds a couple years worth of logging from several thousand users, so it's quite large.. Problem I'm having is if I do a select that will return a couple hundred entries, or anything