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
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
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
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
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
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
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
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]
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
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
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
:)
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
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
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
Hello,
I have a small problem with accounting to mysql.
freeradius 2.1.8
mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2
The NAS is sending accounting data, which I can see in:
more /var/log/freeradius/radacct/192.168.1.10/detail-20100526
...
Wed May 26 23:43
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. ;)
detailed how-to on the internet (I guess my
google-foo is not as good as others) specifically on accounting in
mysql?
3.b) ... sepecifically on MAC authentication?
Thanks so much!
Tim
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
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
google-foo is not as good as others) specifically on accounting in
mysql?
Configure sql connection details in sql.conf. Uncomment sql in accounting
section of the default virtual server. That's it.
3.b) ... sepecifically on MAC authentication?
http://wiki.freeradius.org/Mac-Auth
Ivan Kalik
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
- 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
: 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
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
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
I actually have my Users DB in MySQL Server and my FreeRADIUS use the
radcheck and radreply tables to read (SELECT) records, in my
radiusd.conf I have...
authorize {
sql
}
accounting {
sql
}
But I don´t hace records in radacct Table. What is the problem?
Thanks in advance and
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
Hi,
there are several things I can imagine to prevent the below, but before
re-inventing the wheel,
I'm sure somebody of you has a simple solution for this or some good
posts to point to ?
Here it goes:
using freeradius-1.0-pre2 on two servers, setup as follows:
- server1 doing local mysql
]
[mailto:[EMAIL PROTECTED] On Behalf Of Nick
Berry
Sent: Martes, 27 de Abril de 2004 11:14
To: [EMAIL PROTECTED]
Subject: RE: how to do accounting with mysql?
The NAS has the fake response off, so it is sending the packages. How
do I check if it is sending them? I want to have another reference
I've set up sqlcounter and I'm on testing right now, the next step is
prepaid cards and still dont know how to do them
read the subscription list
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
. +507-6744093
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Milver
S. Nisay
Sent: Miércoles, 28 de Abril de 2004 14:34
To: [EMAIL PROTECTED]
Subject: Re: how to do accounting with mysql?
I've set up sqlcounter and I'm on testing right now, the next
you very much for your response.
- Original Message -
From: Milver S. Nisay [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 26, 2004 9:08 PM
Subject: Re: setting up accounting in mysql
Hello milver, what i mean is in noresetcounter configuration in
rlm_sqlcounter
will be the config of
another sql.conf which only use to update start and stop of accounting.
- Original Message -
From: Milver S. Nisay [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 27, 2004 9:05 PM
Subject: Re: setting up accounting in mysql
Hello milver, i already test what you
Actually im using dialup admin for user account management, thanks very
much
for reply, i really appreciate it. I have another idea what else if i have
2
database which update user accounting realtime, it is possible? i would
create 2 sql.conf in radius.conf. but i dont know what will be the
it on my lib?
I am doing accounting with MySQL without sqlcounter (since I'm not
limiting my user's connection time).
Have you been able to get this to work? Do you still need any help?
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
. A new start of his/her 10 hrs. Any comment or suggestion? I
want to keep this accounting of all users i have.
- Original Message -
From: Milver S. Nisay [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, April 24, 2004 4:03 PM
Subject: Re: setting up accounting in mysql
Hello milver, what i mean is in noresetcounter configuration in
rlm_sqlcounter. Where resetcounter add all accounting of the user and
compare to session timeout. My problem is i have a client with constant
username. example: user X have a connection of 10 hrs starting from date,
April 26
Do u have any idea how to update the user account?
example im setup prepaid internet access using freeradius. im include
rlm_sqlcounter in the config and it works perfectly. Now my problem is
because im configured rlm_sqlcounter for noresetcounter it works when the
user
Hello
Im using v.0.9.3 and
Im trying to do accounting. When
I see the debug I see that every sql sentence is run,
except the accounting sentences.
I dont know if it has
something to do with radacct. Maybe it could happen because I have the radacct empty.
Im sending you the radius.conf
]
Subject: Re: how to do accounting
with mysql?
doesn't work. you must use
postgresql. look in the src/billing directory and all will be revealed!
- Original Message -
From: Rogelio Alvarado Anchisi
To: [EMAIL PROTECTED]
Sent: Friday,
April 23, 2004 03:50 PM
Subject: RE: how to do accounting with
mysql?
All
the info it says is about Ciscos.
But
Im using a Nortel.
Is
there any way other than sql to do accounting? I cant leave my MySql database
because I have all users there and are several
thousands.
Can
I do a file
Hello,
Has anyone set up accounting using the radacct table in MySql?
I read the debug and the sql trace doesn't show that the sql is being
queried for accounting. Where in the radiusd.conf do I have to set it
up?
I got into the accounting { } but it seems that the sql trigger I put
doesn't do
Has anyone set up accounting using the radacct table in MySql?
I read the debug and the sql trace doesn't show that the sql is being
queried for accounting. Where in the radiusd.conf do I have to set it
up?
I got into the accounting { } but it seems that the sql trigger I put
doesn't do a
I can see that I have rlm_sqlcounter but I don't see the sqlcounter.conf
Where or how do I get it?
download the latest CVS pls. it should be something like this
sqlcounter noresetcounter {
driver = rlm_sqlcounter
counter-name = Max-All-Session-Time
Rogelio Alvarado Anchisi [EMAIL PROTECTED] wrote:
I'm using v.0.9.3 and I'm trying to do accounting. When I see the debug
I see that every sql sentence is run, except the accounting sentences.
I don't know if it has something to do with radacct. Maybe it could
happen because I have the
PROTECTED]
Subject: Re: how to do accounting with mysql?
Rogelio Alvarado Anchisi [EMAIL PROTECTED] wrote:
I'm using v.0.9.3 and I'm trying to do accounting. When I see the
debug
I see that every sql sentence is run, except the accounting sentences.
I don't know if it has something to do
Rogelio Alvarado Anchisi [EMAIL PROTECTED] wrote:
The NAS has the fake response off, so it is sending the packages. How
do I check if it is sending them? I want to have another reference.
tcpdump
Other thing. I put the sqlcounter stuff but I don't have any
sqlcounter.so or something like
...
- Original Message -
From: Milver S. Nisay [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 23, 2004 11:57 PM
Subject: Re: setting up accounting in mysql
I can see that I have rlm_sqlcounter but I don't see the sqlcounter.conf
Where or how do I get it?
download the latest
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
hello does anyone have example config of what Mr.
Allan Dekok Suggestion?
Have two accounting databases: One used by your RADIUS
server fordaily/weekly/monthly accounting for "live" sessions, and another
formulti-year backups. Alan DeKok.
Thanks very much
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.
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
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 other than the simplest of queries
Message -
From: Mike Sturdee [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 11, 2004 3:31 PM
Subject: accounting to mysql database
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
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
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
55 matches
Mail list logo
