CHAP-Password = 0xe2fb635de078f97ce128cbe469b79867a3
> modcall: entering group authorize for request 5
> modcall[authorize]: module "preprocess" returns ok for request 5
> radius_xlat: '/var/log/radius/radacct/192.168.1.75/detail'
> rlm_detail: %A/%{Client-IP-A
[authorize]: module "preprocess" returns ok for
request 5
radius_xlat: '/var/log/radius/radacct/192.168.1.75/detail'
rlm_detail:
%A/%{Client-IP-Address}/detail expands to
/var/log/radius/radacct/192.168.1.75/detail
rlm_detail:
Failed to create directory
/var/log/radius/radacct/1
Hi everybody
With freeradius 0.9.3 , each user session creates three
identical rows in mysql radacct table .
For each session, I receive five paquets :
1) Access-Request
2) Accounting-Request Start
which generates an INSERT request
3) Accounting-Request Start
which generates
Me too please, err is that six... ;)
I would like to see what you have, I have been considering some kind of
raduse replacement, my boss misses it. In FreeBSD it doesn't seem to work
for all shornames, the radwtmp or radutmp whichever it is truncates the
shortnames at 5 or 6 characters. :-(
Joe Ma
On Monday 01 December 2003 00:53, Joe Maimon wrote:
> Hello all,
>
> I have put togetother a couple scripts and a program that allows me to
> MRTG graph dialup users from the radius accounting sql table.
>
> Very unpolished. If anyone is interested in helping me develop/test,
> please drop me a lin
i am also intrested
John Hengstler wrote:
I second it...
Regards,
John
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Vector
Sent: Sunday, November 30, 2003 6:10 PM
To: [EMAIL PROTECTED]
Subject: Re: MRTG graphing from radacct sql data
I'm inter
Joe Maimon wrote:
Hello all,
I have put togetother a couple scripts and a program that allows me to
MRTG graph dialup users from the radius accounting sql table.
Very unpolished. If anyone is interested in helping me develop/test,
please drop me a line.
Thanks,
Joe
- List info/subscribe/u
I second it...
Regards,
John
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Vector
Sent: Sunday, November 30, 2003 6:10 PM
To: [EMAIL PROTECTED]
Subject: Re: MRTG graphing from radacct sql data
I'm interestedthanks,
vec
- Original Me
I'm interestedthanks,
vec
- Original Message -
From: "Joe Maimon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, November 30, 2003 3:53 PM
Subject: MRTG graphing from radacct sql data
> Hello all,
>
> I have put togetother a couple scr
Hello all,
I have put togetother a couple scripts and a program that allows me to
MRTG graph dialup users from the radius accounting sql table.
Very unpolished. If anyone is interested in helping me develop/test,
please drop me a line.
Thanks,
Joe
-
List info/subscribe/unsubscribe? See http
Hello,
I'm using freeradius (0.9.0-1, debian woody) over mysql to authenticate
ipsec users that connect to the cisco.
I need to log into radacct one or more cisco-specific attributes that
come into the acct-start packet. They look like:
Cisco-AVPair = "isakmp-initator-ip=10.0.0.1&
hello! I'm having problems with my radius server. It seems that my
acctstartime field logs date as dec 1 1969. I'm using the standard
postgresql.conf. Thanks in advance.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Dear all,
I am curious to find out, is there any sample script that can be used for
radacct.
I found inside /etc/raddb/acct_users like this:
DEFAULT Acct-Status-Type == Start
# Exec-Program = "/path/to/exec/acct/start"
#
#DEFAULT Acct-Status-Type == Stop
# Exec-Program =
apshot-20030830, everithing works fine, except i cant
figure out howto enable logging into the radacct mysql table.
It's enabled by default.
It's also a FAQ.
I saw in other example outputs of radius -X that the rlm_sql module
uses the accounting_start_query, but inn my output thi
Fastbyte <[EMAIL PROTECTED]> wrote:
> I am using FreeBSD 4.9-PRERELEASE with the
> freeradius-snapshot-20030830, everithing works fine, except i cant
> figure out howto enable logging into the radacct mysql table.
It's enabled by default.
It's also a FAQ.
I am using FreeBSD 4.9-PRERELEASE with the
freeradius-snapshot-20030830, everithing works fine, except i cant
figure out howto enable logging into the radacct mysql table. I saw in
other example outputs of radius -X that the rlm_sql module uses the
accounting_start_query, but inn my output
On Mon, 28 Jul 2003 11:37 pm, Oliver Graf wrote:
> On Mon, Jul 28, 2003 at 11:16:17PM +0300, Peter Nixon wrote:
> > On Mon July 28 2003 22:59, Oliver Graf wrote:
> > > On Mon, Jul 28, 2003 at 09:30:01PM +0300, Peter Nixon wrote:
> > > > On Thu July 24 2003 23:13, Daniel Destro do Carmo wrote:
> > >
On Mon, Jul 28, 2003 at 11:16:17PM +0300, Peter Nixon wrote:
> On Mon July 28 2003 22:59, Oliver Graf wrote:
> > On Mon, Jul 28, 2003 at 09:30:01PM +0300, Peter Nixon wrote:
> > > On Thu July 24 2003 23:13, Daniel Destro do Carmo wrote:
> > > > How can I select (using SQL) just the unique records t
On Mon July 28 2003 22:59, Oliver Graf wrote:
> On Mon, Jul 28, 2003 at 09:30:01PM +0300, Peter Nixon wrote:
> > On Thu July 24 2003 23:13, Daniel Destro do Carmo wrote:
> > > How can I select (using SQL) just the unique records to see
> > > how many calls and to calculate the total time each user
On Mon, Jul 28, 2003 at 09:30:01PM +0300, Peter Nixon wrote:
> On Thu July 24 2003 23:13, Daniel Destro do Carmo wrote:
> > How can I select (using SQL) just the unique records to see
> > how many calls and to calculate the total time each user has
> > used???
>
> Postgres has a UNIQUE keyword, no
uly 28, 2003 2:25 PM
> To: Daniel Destro do Carmo
> Cc: [EMAIL PROTECTED]
> Subject: Re: Duplicated records in MySQL Radacct table.
>
>
> Then the records are not identical.
>
> I suggest you figure out WHY you are getting duplicated records
> in the DB and
> fix that.
to read the logs recorded in MySQL DB
>
> and
>
> > > then make the billing for each customer's calls.
> > >
> > > I have faced a big problem that is: When I list the record
>
> s
>
> > > from the table radacct or even if I use two table (on
On Thu July 24 2003 23:13, Daniel Destro do Carmo wrote:
> Hello All,
>
> I a program in Java to read the logs recorded in MySQL DB and
> then make the billing for each customer's calls.
>
> I have faced a big problem that is: When I list the records
> from the table ra
Hello All,
I a program in Java to read the logs recorded in MySQL DB and
then make the billing for each customer's calls.
I have faced a big problem that is: When I list the records
from the table radacct or even if I use two table (one for
start and another for stop) I find a lot of dupli
e SQL
> accounting STOP record - ERROR: pg_atoi: error reading "2618979488":
> Numerical result out of range
>
> I suspect that it is trying to write the acctoutputoctets for a session into
> the radacct table but I am not positive. My postgresql radacct table was
&
(B"2618979488":Numerical result out of range
(B
(BI suspect that it is trying to write the
(Bacctoutputoctets for a session into the radacct table but I am not
(Bpositive. My postgresql radacct table was created with the following
(Bscript
(B
(B
(BCREATE TABLE radac
I am running redhat 9.0 with postgresql 7.3 and freeradius-0.8.1.
(BI use it for authentication for our fiber connections. Everything was
(Bworking well untill lately. I have noticed that I get an error like the
(Bfollowing in my radius.log and after that it looses the connection with
(Bpostg
Running freeradius-0.8.1/Mysql-3.23.56 and
authenticating dialup user's with radcheck we cannot log sessions in the
radacct database.
Did we miss a radius/sql config file
entry somewhere or file permission, IP table rule?
My errors are:
Thu Jul 3 08:46:06 2003 : Error: Invalid
operato
, 2003 5:35 PM
Subject: Re: radacct failed permission denied
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 02 July 2003 16:40, Andrew Mihalic wrote:
> Error: rlm_detail: Failed to create directory
> /var/log/radius/radacct/192.168.0.251: Permission denied
I would suggest
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 02 July 2003 16:40, Andrew Mihalic wrote:
> Error: rlm_detail: Failed to create directory
> /var/log/radius/radacct/192.168.0.251: Permission denied
I would suggest checking permissions for the parent directory
/var/log/radius/r
I have freeradius.0.8.1
authenticating users ( we just went live)with mysql radcheck is working OK but
now my errors are :
Wed Jul 2 17:01:43
2003 : Error: rlm_detail: Failed to create directory
/var/log/radius/radacct/192.168.0.251: Permission
denied
Do I look to the radius config
files
Hi
I have problem to report Framed-IP-address value in the mysql table
radacct.in fact as I can see any attributes passed except the client
assigned IP.
I configure radius using the Scott Bartlett Freeradius and MYSQL How To...
It works great but there no way to display the Attribute Framed-IP
I know that radacct was not written by the freeradius team... but I figure
the folks on the list have used it and can answer a quick question for me.
How reliable are the stats coming out of radacct? I have it looking at
detail files on a daily basis. IOW, I rotate the detail file at midnight
On Mon, Jan 06, 2003 at 10:51:48AM -0500, Alan DeKok wrote:
> Andrew Pilley <[EMAIL PROTECTED]> wrote:
> > Hey. Just a quick question. if a radius+mysql server is unexpectedly
> > shut down (power failure or otherwise) without being given a chance to
> > quit, and there are active sessions, will fr
Andrew Pilley <[EMAIL PROTECTED]> wrote:
> Hey. Just a quick question. if a radius+mysql server is unexpectedly
> shut down (power failure or otherwise) without being given a chance to
> quit, and there are active sessions, will freeradius clean out any
> leftover sessions in the raddacct table?
>
> ---
> Use phpMyadmin, its usefull... and do this operation :
I am using phpmyadmin. it's very handy :)
>
> SELECT DISTINCT UserName,AcctStartTime,FramedIPAddress,CallingStationId FROM radacct
>WHERE AcctStopTime = '0';
hmm. DISTINCT is a new one on me.
erName,AcctStartTime,FramedIPAddress,CallingStationId FROM radacct
WHERE AcctStopTime = '0';
So then you can clean them up good :). Brute force.
---
Hope it helped.
---
Best regards,
Bogdan
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hey. Just a quick question. if a radius+mysql server is unexpectedly
shut down (power failure or otherwise) without being given a chance to
quit, and there are active sessions, will freeradius clean out any
leftover sessions in the raddacct table? (for simplicity, we assume the
connections died at
From: Ruslan Balkin <[EMAIL PROTECTED]>
To: "David C. Troy" <[EMAIL PROTECTED]>
Subject: Re: Convert detail->MySQL radacct script
Date: Mon, 26 Aug 2002 12:52:59 +0400
Organization: OOO Dartel
X-Mailer: Sylpheed version 0.8.0 (GTK+ 1.2.10; i586-alt-linux)
Hello again.
S
On Thu, Aug 22, 2002 at 09:43:48AM -0400, David C. Troy wrote:
>
> All --
>
> I am looking for a quick and dirty script that will do a straight
> conversion of a detail file to the current MySQL radacct schema.
>
> I can write one, but would prefer not to reinvent the whe
All --
I am looking for a quick and dirty script that will do a straight
conversion of a detail file to the current MySQL radacct schema.
I can write one, but would prefer not to reinvent the wheel if I can...
any pointers (or scripts e-mailed here) would be appreciated.
Regards,
Dave
Regards,
Ronan
> - Original Message -
> From: "Ronan Lucio" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, June 05, 2002 1:06 AM
> Subject: Stop radacct logs
>
>
> > Hello,
> >
> > Is there a way free
- Original Message -
From: "Ronan Lucio" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 05, 2002 1:06 AM
Subject: Stop radacct logs
> Hello,
>
> Is there a way freeradius don't the accounting logs?
> I've storing accounting logs o
Hello,
Is there a way freeradius don't the accounting logs?
I've storing accounting logs on a Postgres database
via Exec-Program.
Thank's,
Ronan
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
[ FreeRadius Snapshot 20020128 on Redhat 7.1, MySQL
authentication/accounting. Cisco 3640 NAS. ]
Hmmm...
FR doesn't seem to be updating my radacct table correctly with
Framed-IP-Address properly in the accounting update packet.
A full FR debug trace is below of the entire login is
Yes, MySQL with InnoDB (http://www.innodb.com/) can handle VERY large
tables. Each table is not a single data file, but rather a collection of
'table spaces', much like oracle.
--
Mike Machado
[EMAIL PROTECTED]
InnerCite Inc.
Engineering Director / CTO
-
List info/subscribe/unsubscribe? See
ting data to flat files.
>
>Now I'm setting up freeradius with mysql support to handle my authentication
>and accounting, but the more I think about it, the sheer size of the radacct
>table gives me worries.
>
>Looking at my old accounting log files, I figure the radacct tabl
ysql support to handle my authentication
and accounting, but the more I think about it, the sheer size of the radacct
table gives me worries.
Looking at my old accounting log files, I figure the radacct table would
grow to about 25,000,000 rows in about a year time. Can mysql handle this?
Won't
bronc <[EMAIL PROTECTED]> wrote:
> rad_recv: Accounting-Request packet from host 10.16.247.84:32772, id=157, length=51
> Thread 5 assigned request 8
> Thread 5 handling request 8, (1 handled so far)
> User-Name = "steve"
> Password = "\322\361g\220\031\2666\n\227X)\247\025\316\336\
Hello Sergey
When I add "sql" to accounting entry and run radiusd with "-xx" option.
It output:
===
rad_recv: Accounting-Request packet from host 10.16.247.84:32772, id=157, length=51
Thread 5 assigned request 8
-
Hello bronc,
Monday, September 24, 2001, 7:18:44 AM, you wrote:
b> accounting {
b> # acct_unique
b> detail
b> # counter
b> unix
b> radutmp
b> # sradutmp
b> }
b> What else should i add for accout with postgresql?
sql
Best regards,
Sergey
'accounting' entry in my raddb/radiusd.conf:
accounting {
# acct_unique
detail
# counter
unix
radutmp
# sradutmp
}
What else should i add for accout with postgresql?
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
bronc <[EMAIL PROTECTED]> wrote:
> I have build freeradius with postgresql, and it work. But when i test with
>
> "radclient -f test ip acct key", the accounting information is write to file "detail"
>
> correctly, but it not write to database ta
hi
I have build freeradius with postgresql, and it work. But when i test with
"radclient -f test ip acct key", the accounting information is write to file "detail"
correctly, but it not write to database table "radacct", why?
-
List info/s
At 12:33 AM 9/6/2001 +0430, you wrote:
>My radius uses the default configuration for the location
>of detail logs:
>
> radacctdir = ${logdir}/radacct
> detailfile = ${radacctdir}/%{Client-IP-Address}/detail
>
>when i saw my radacctdir, surprisingly i found out
My radius uses the default configuration for the location
of detail logs:
radacctdir = ${logdir}/radacct
detailfile = ${radacctdir}/%{Client-IP-Address}/detail
when i saw my radacctdir, surprisingly i found out that there
are many directories there that are not my clients
56 matches
Mail list logo
