On Thu, Nov 8, 2012 at 2:43 PM, Erich Titl erich.t...@think.ch wrote:
Hi Fajar
on 08.11.2012 08:16, Fajar A. Nugraha wrote:
...
IIRC only one of them will be used. I suggest you dop MD5 (since it's
useless for your purpose) and Cleartext (you don't want that, right?)
and verify you use
On Thu, Nov 8, 2012 at 2:08 PM, Erich Titl erich.t...@think.ch wrote:
2) I could see login and logout information, but no data usage, e.g.
dowload and upload sizes appear to be zeroes.
Some NAS (e.g. AP's flashed with dd-wrt) simply doesn't send
accounting packets. Blame your NAS :P
:-(
on 08.11.2012 09:01, Fajar A. Nugraha wrote:
...
It is a ZyXEL, so basically a black box, even to the local vendor.
Just to be sure, you HAVE enabled sql in accounting section, right?
I guess the fact that I have entries in the radacct table which
correspond to actual connection attempts
On Thu, Nov 8, 2012 at 4:27 PM, Erich Titl erich.t...@think.ch wrote:
I _guess_ it shows some accounting
rad_recv: Accounting-Request packet from host 194.124.158.62 port 47037,
id=165, length=135
Acct-Session-Id = 509ACAB9-000F
Acct-Status-Type = Start
Do some stuff
Hi Folks
I succeeded to get my set up running with FR 2.2.0 and Mysql, e.g. I can
connect through a ZyXEL NWA 3160 using credentials in the MySQL database
using a M$ Windows 7 client.
Everything is still quite raw and blurry to me. Could someone point me
to the right dos for the following?
1) I
On Wed, Nov 7, 2012 at 10:16 PM, Erich Titl erich.t...@think.ch wrote:
Hi Folks
I succeeded to get my set up running with FR 2.2.0 and Mysql, e.g. I can
connect through a ZyXEL NWA 3160 using credentials in the MySQL database
using a M$ Windows 7 client.
Everything is still quite raw and
Hi Fajar
on 08.11.2012 03:35, Fajar A. Nugraha wrote:
On Wed, Nov 7, 2012 at 10:16 PM, Erich Titl erich.t...@think.ch wrote:
Hi Folks
I succeeded to get my set up running with FR 2.2.0 and Mysql, e.g. I can
connect through a ZyXEL NWA 3160 using credentials in the MySQL database
using a M$
On Thu, Nov 8, 2012 at 2:08 PM, Erich Titl erich.t...@think.ch wrote:
Thanks, I read that URL, actually that one guided me to enter a
Cleartext Password at all.
See the column labeled NT hash?
mysql select * from radcheck;
Hi Fajar
on 08.11.2012 08:16, Fajar A. Nugraha wrote:
...
IIRC only one of them will be used. I suggest you dop MD5 (since it's
useless for your purpose) and Cleartext (you don't want that, right?)
and verify you use the correct NT-Password (use smbencrypt if you
haven't already done so)
Andy Smith wrote:
I have attempted to configure freeradius to write accounting data to
MySQL, however currently its not working. No data is being written
to MySQL and the Radius client is complaining its not recieving a reply
for accounting requests. I subsituted the detail setting in
the
Hi,
ok this is an example of when its meant to do some accounting, in this
example I have both detail and sql set for accounting in radiusd.conf.
Nothing to do. Sleeping until we see a request.
rad_recv: Accounting-Request packet from host 89.107.16.10:35377, id=82,
length=145
Ah,
ok, now I see the other post regarding this. The problem is OpenSER and
this status type:
rlm_sql (sql): Unsupported Acct-Status-Type = 15
Whats the latest on this? Has the incompatibility been addressed in
freeradius 2.0?
thanks Andy.
Again, send a debug with the Start and Stop packets.
Ivan Kalik
Kalik Informatika ISP
Dana 21/1/2008, A.smith [EMAIL PROTECTED] piše:
Also, regarding radius 1.x I now have a patch which allows this type of
record.
However next issue is that with accounting set to sql in radiusd.conf the
SQL
put in the database... What have I done wrong?
thank u!
- Original Message -
From: Andy Smith [EMAIL PROTECTED]
To: FreeRadius users mailing list freeradius-users@lists.freeradius.org
Sent: Monday, January 21, 2008 4:40 PM
Subject: Re: MySQL accounting issue
Ok, Im seeing this from
Dana 21/1/2008, A.smith [EMAIL PROTECTED] piše:
Also, regarding radius 1.x I now have a patch which allows this type of
record.
However next issue is that with accounting set to sql in radiusd.conf the
SQL statements are being written just to
/usr/local/var/log/radius/sqltrace.sql
and nothing is
Hi List,
ok next issue I have :P
I have attempted to configure freeradius to write accounting data to MySQL,
however currently its not working. No data is being written
to MySQL and the Radius client is complaining its not recieving a reply for
accounting requests. I subsituted the detail
Jan Satko wrote:
So it looks like (for me) that AP is sending outer information for
accounting. Maybe there is some option howto force AP to show inner
username ?
Send the inner user name back in the Access-Accept.
Set use_tunneled_reply, and it should work.
I noticed that TTLS has some
Peap also has use_tunneled_reply.
Alan DeKok.
Tyvm. It is working.
I'm still using old eap.conf from 2 years ago and this
option was before only in TTLS section ;-)
S pozdravom
--
Bc. Jan 'EIS' Satko Slovak University of Agriculture
network system managerTr. A.
I need to log connect speeds from users
At any rate things working fine from our own carrier globalpops to capture
these on the start packet
but Yournetplus for some reason it doesn't work.
I see this info in the update accounting packet so i thought I would modify the
update query but
And the errors are?
Ivan Kalik
Kalik Informatika ISP
Dana 16/7/2007, Jeff [EMAIL PROTECTED] piše:
I need to log connect speeds from users
At any rate things working fine from our own carrier globalpops to capture
these on the start packet
but Yournetplus for some reason it doesn't
to use near
'AscendDataRate = '19200' USRConnectSpeed = '' WHERE
AcctSess' at line 1
_
From: [EMAIL PROTECTED]
To: FreeRadius users mailing list [mailto:[EMAIL PROTECTED]
Sent: Mon, 16 Jul 2007 11:06:28 -0400
Subject: Re: mysql accounting connect speeds
PROTECTED]
To: 'FreeRadius users mailing list' [mailto:[EMAIL PROTECTED]
Sent: Mon, 16 Jul 2007 11:40:53 -0400
Subject: RE: mysql accounting connect speeds
Jeff said:
USRConnectSpeed = '%{USR-Connect-Speed}' \
Did you actually add a USRConnectSpeed column to the radacct table? There
isn't
Jeff wrote:
Mon Jul 16 11:23:22 2007 : Error: rlm_sql (sql): Couldn't update SQL
accounting ALIVE record - You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right
syntax to use near 'AscendDataRate = '24000' USRConnectSpeed =
near
'AscendDataRate = '19200', USRConnectSpeed = '' WHERE
AcctSes' at line
_
From: Dennis Skinner [mailto:[EMAIL PROTECTED]
To: FreeRadius users mailing list [mailto:[EMAIL PROTECTED]
Sent: Mon, 16 Jul 2007 11:59:34 -0400
Subject: Re: mysql accounting
Yes. You are missing commas before AscendDataRate and USRConnectSpeed
expressions that you have added to the update query.
Ivan Kalik
Kalik Informatika ISP
Dana 16/7/2007, Dennis Skinner [EMAIL PROTECTED] piše:
Jeff wrote:
Mon Jul 16 11:23:22 2007 : Error: rlm_sql (sql): Couldn't update SQL
Jeff wrote:
AcctOutputOctets = '%{Acct-Output-Octets}' \
Need comma on live above. This is a MySQL issue, not a FR issue.
Please read the MySQL docs if you don't understand how to create a valid
query.
--
Dennis Skinner
Systems Administrator
BlueFrog Internet
http://www.bluefrog.com
-0400
Subject: Re: mysql accounting connect speeds
Jeff wrote:
AcctOutputOctets = '%{Acct-Output-Octets}' \
Need comma on live above. This is a MySQL issue, not a FR issue.
Please read the MySQL docs if you don't understand how to create a valid
query.
--
Dennis Skinner
Systems Administrator
hi
i try to account with mysql
here are the mysql start stop and update definition
accounting_start_query = INSERT into radaact SET\
`User-Name` = '%{User-Name}',\
`Calling-Station-Id` = '%{Calling-Station-Id}',\
`Called-Station-Id` =
On Thursday 21 December 2006 06:45, basile wrote:
but start and stop not
rlm_sql (sql): sql_set_user escaped user -- ''
radius_xlat: 'INSERT into radaact SET '
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql_mysql: MYSQL check_error: 1064 received
When you run in debug mode, do you
basile wrote:
accounting_start_query = INSERT into radaact SET\
`User-Name` = '%{User-Name}',\
`Calling-Station-Id` = '%{Calling-Station-Id}',\
`Called-Station-Id` = '%{Called-Station-Id}',\
`NAS-IP-Address` =
Hello,
I have been
researching the use of FreeRADIUS on my network for the past few days. I'm
not sure if FreeRADIUS can do what I want. Here is a list of my
requirements:
-Authentication
through LDAP
-Authorization
through LDAP
-Accounting through
MySQL
I have multiple
Cisco and
-Authentication through LDAP
YES. Using it currently !
-Authorization through LDAP
YES. See above :)
-Accounting through MySQL
YES. Doing traffic accounting.
I have multiple Cisco and Foundry devices on my network. The RADIUS server
will primarily be used for AAA for Telnet/SSH logins and
Seferovic Edvin wrote:
I do NOT want to be rude, but sometimes searching the archives helps A LOT !
BELIEVE ME ! But for the lazy developers among you people - here is the part
that describes the needed feature. Thanks to Jamal ( of course ). This is
copy paste - so do NOT blame me ;)
You're
Thanks for that,
I cant believe I didnt find it. I scoured the wiki. I seriously don't
like to ask for help unless I just cant find it anywhere. Anyways, I'm
working on a pretty neat php5 driven interface for this whole thing that
I would be happy to share after it's finished if there would be
I have a quick question on the mysql accounting. I am working on my own
interface for managing the freeradius+mysql setup. Everything is
working great, I can view all my users, see who's connected, add new
users, manage static vs. dynamic IP's, etc..The problem is it doesnt
seem to log
fails_log.
END
Regards,
Edvin Seferovic
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
g] On Behalf Of Sean Taylor
Sent: Donnerstag, 15. Juni 2006 07:13
To: freeradius-users@lists.freeradius.org
Subject: mysql accounting
I have a quick question on the mysql
fails_log.
END
Regards,
Edvin Seferovic
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
g] On Behalf Of Sean Taylor
Sent: Donnerstag, 15. Juni 2006 07:13
To: freeradius-users@lists.freeradius.org
Subject: mysql accounting
I have a quick question
I noticed that the stop query changed at some point between 0.9.3 and
1.0.1. Here are the queries:
## 0.9.3 ##
accounting_stop_query = UPDATE ${acct_table2}
SET
AcctStopTime = '%S',
AcctSessionTime = '%{Acct-Session-Time}',
AcctInputOctets =
Hello,
I use Debian Linux Sarge, kernel 2.6.8-2(368),
freeradius 1.0.2, and I'm trying to configure
freeradius + mysql Accounting.
I created database from script db_mysql.sql, and
created a user to access database with full
privileges. I tested to access database from another
host and it's fine
to configure
freeradius + mysql Accounting.
I created database from script db_mysql.sql, and
created a user to access database with full
privileges. I tested to access database from another
host and it's fine.
I can get authentication from localhost and another
host. BUT freeradius
] wrote:
Hello,
I use Debian Linux Sarge, kernel 2.6.8-2(368),
freeradius 1.0.2, and I'm trying to configure
freeradius + mysql Accounting.
I created database from script db_mysql.sql, and
created a user to access database with full
privileges. I tested to access database from
another
Hi,
I have a question about the uniqueness of the AcctUniqueId field. Everytime
the user connects, the id is always the same. AcctSessionId is always the
same as well. All that would be fine, except that the times get messed up by
being updated to the last AcctStopTime. The update query is as
Andrey [EMAIL PROTECTED] wrote:
I have a question about the uniqueness of the AcctUniqueId field. Everytime
the user connects, the id is always the same. AcctSessionId is always the
same as well.
Then there isn't much you can do.
Some NAS vendors re-use Acct-Session-Id's, even though the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello All,
I'm using the default sql.conf for the Acount start/stop information
that will be inserted into the SQL database.
however I found some of the info was inserted into the SQL server.
E.g
NASPortType (I've sure the request have this)
I am running Freeradius 1.0.1 on Fedora Core 3 and authenticating
wireless users with PEAP. I am trying to get accounting to work, but I don't
understand the results that I am getting. The first entry has the MAC
address as the UserName, no realm, and the AcctAtthentic is Local.
INSERT into
Hi All
I'm using a free radius with EAP TLS and Mysql and i work :)
but the Accounting Query no working when the user authenticates !
My Config :
authorize {
#
# The preprocess module takes care of sanitizing some bizarre
# attributes in the request, and turning them
My Mysql database is about 50 megs right now.. because of the accounting
table.
How large does most people let it get before rolling it?
I Guess other people will just roll it on a Time/Date basis in cron..
But what if I want to keep it for a year so I can pull stats out of it?
Can it get to a
cris boisvert escreveu:
My Mysql database is about 50 megs right now.. because of the accounting
table.
How large does most people let it get before rolling it?
My radacct table is over 500 MB / 1.3 million records right now. For
now I'm just letting it grow. Make sure you have plenty of
I got 4 gigs of ram.. I hope its enough..
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Keith
Yoder
Sent: Monday, October 04, 2004 3:52 PM
To: [EMAIL PROTECTED]
Subject: Re: MYSQL Accounting Table Size?
cris boisvert escreveu:
My Mysql database
cris boisvert escreveu:
I got 4 gigs of ram.. I hope its enough..
I've only got 1 so you should be fine.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On Mon, 4 Oct 2004, cris boisvert wrote:
My Mysql database is about 50 megs right now.. because of the accounting
table.
How large does most people let it get before rolling it?
I Guess other people will just roll it on a Time/Date basis in cron..
But what if I want to keep it for a year
On Wed, 28 Jul 2004, Ken A wrote:
Edgars wrote:
i am writing my own program to get them in human-readable form:)
Edgars
Yep. I made some changes that make it easier for me to start from
scratch with a language I'm more familiar with (perl) than to modify
dialupadmin to do what I
On Wed, 28 Jul 2004, Edgars wrote:
i am writing my own program to get them in human-readable form:)
Edgars
Ken A wrote:
Those of you that use mysql with freeradius, can anyone recommend some
software for linux to process mysql radacct table logs?
dialupadmin has a user statistics and a
Kostas Kalevras wrote:
On Wed, 28 Jul 2004, Ken A wrote:
Edgars wrote:
i am writing my own program to get them in human-readable form:)
Edgars
Yep. I made some changes that make it easier for me to start from
scratch with a language I'm more familiar with (perl) than to modify
dialupadmin to do
i am writing my own program to get them in human-readable form:)
Edgars
Ken A wrote:
Those of you that use mysql with freeradius, can anyone recommend some
software for linux to process mysql radacct table logs?
Do you just roll your own scripts to query the logs and make reports?
Seems simple
Edgars wrote:
i am writing my own program to get them in human-readable form:)
Edgars
Yep. I made some changes that make it easier for me to start from
scratch with a language I'm more familiar with (perl) than to modify
dialupadmin to do what I want, especially since I'm not very good with
Those of you that use mysql with freeradius, can anyone recommend some
software for linux to process mysql radacct table logs?
Do you just roll your own scripts to query the logs and make reports?
Seems simple enough, but what are others doing? is always a good
question :-)
Thanks,
Ken A
-
Those of you that use mysql with freeradius, can anyone recommend some
software for linux to process mysql radacct table logs?
Do you just roll your own scripts to query the logs and make reports?
Seems simple enough, but what are others doing? is always a good
question :-)
if dialup_admin is
duh! I didn't know it was there. Thanks.
Ken A
Milver S. Nisay wrote:
Those of you that use mysql with freeradius, can anyone recommend some
software for linux to process mysql radacct table logs?
Do you just roll your own scripts to query the logs and make reports?
Seems simple enough, but what
Hello,
Forgive me if this has been covered. I'm using FreeRADIUS 0.8.1 and am
using MySQL for accounting (and LDAP for authorization, but that's probably
not important). This works well for getting totals of time used for each
user. However, I'm now trying to write a tool to search
: www.qnet.com.pe
- Original Message -
From: Andre Fortin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 05, 2004 12:26 PM
Subject: MySQL accounting strangeness
Hello,
Forgive me if this has been covered. I'm using FreeRADIUS 0.8.1 and am
using MySQL for accounting (and LDAP
: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Ernesto
Freyre
Sent: Monday, July 05, 2004 5:27 PM
To: [EMAIL PROTECTED]
Subject: Re: MySQL accounting strangeness
Normally this could depend on your NAS configuration. Check this
is sending
the attributes you need.
Untitled
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
sql.conf to store this info on db radacct
and now it's ok
i don't know if the cisco_vsa_hack now is ok but it seems to works fine
-Messaggio originale-
Da: Jérôme Warnier [mailto:[EMAIL PROTECTED]
Inviato: giovedì 25 marzo 2004 19:30
A: '[EMAIL PROTECTED]'
Oggetto: Re: MySQL
modified sql.conf to store this info on db radacct
and now it's ok
i don't know if the cisco_vsa_hack now is ok but it seems to works fine
-Messaggio originale-
Da: Jérôme Warnier [mailto:[EMAIL PROTECTED]
Inviato: giovedì 25 marzo 2004 19:30
A: '[EMAIL PROTECTED]'
Oggetto: Re: MySQL
Le lun 22/03/2004 à 11:47, Pugnaloni Federico a écrit :
Hi,
i'm using FreeRADIUS Version 0.9.3on FreeBSD 4.9
i'm using with a Cisco PIX to AAA internet access
it works fine, but i need to store the Cisco-AVPair info in radacct SQL
table.
As i can see in the detail accounting freeradius
Hi,
i'm using FreeRADIUS Version 0.9.3on FreeBSD 4.9
i'm using with a Cisco PIX to AAA internet access
it works fine, but i need to store the Cisco-AVPair info in radacct SQL
table.
As i can see in the detail accounting freeradius store Cisco-AVPair info
-snip-
Cisco-AVPair =
Hi!
I see messages like this in radius.log:
Sun Jan 11 13:00:06 2004 : Info: rlm_sql (sql): There are no DB handles
to use! skipped 0, tried to connect 0
When it happens, the accounting will be continous or this message
indicates lost data?
Thanks,
Andras
--
-
List
-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Fogarasi Andras
Sent: Sunday, January 11, 2004 2:08 PM
To: [EMAIL PROTECTED]
Subject: mysql accounting question
Hi!
I see messages like this in radius.log:
Sun Jan 11 13:00:06 2004 : Info: rlm_sql (sql): There are no DB handles
to use
69 matches
Mail list logo