- Freeradius-Users - lists.freeradius.org

Script to archive radacct table
by Barry O'Donovan 03 Jul '06

03 Jul '06

Folks, I just wrote a PHP (sorry!) CLI script to archive completed radacct session data that's older than the current month and last month to a separate database. As the radacct table grows in size, INSERTs, UPDATEs and DELETEs take longer as the data and index file sizes grow. SELECTs also take longer for the same reasons. While the script archives complete sessions older than the current month and past month, this can be amended to today and yesterday, this week and last week, etc easily enough. Note that only complete sessions are moved. This script should run nightly to catch recently closed sessions that were not caught in the "big move" at the start of a new month. Record dates are determined by the AcctStopTime field by default. A MySQL merge table is used to make searching on the archived records easy. The records are archived to a different database and the merge does not include the live radacct. This was a decision I made but others can do as they choose - a merge can include table from different databases as of MySQL 4.1.1. For more information please see: http://www.barryodonovan.com/development/other/radacct_archive/ Comments, updates, patches, suggestions, etc all gratefully appreciated. Suggestions on including this (after making it somewhat more generic) in the radacct bin tree would be appreciated. - Barry

1 0

unsuscribe
by alfonso 03 Jul '06

03 Jul '06

1 0

LDAP related questions
by Kostas Zorbadelos 02 Jul '06

02 Jul '06

Hello to everyone. I have a question regarding a configuration I am trying to achieve. I have users stored in an ldap database. An example user entry looks like this: dn: uid=kzorba,ou=people,dc=company,dc=gr cn: ZORBADELOS KONSTANTINOS uid: kzorba clearTextPwd: mypassword radiusProfile: PSTN_STATIC radiusAccountStatus: activated radiusMaxLogins: 1 radiusExpDate: 2030/12/31 00:00:00 Framed-IP-Address: 62.103.176.39 objectClass: account objectClass: MyRadiusAccount objectClass: top Tha attribute radiusProfile groups the users. For each group we have a corresponding profile # PSTN_STATIC, radiusProfiles, company.gr dn: cn=PSTN_STATIC,ou=radiusProfiles,dc=company,dc=gr cn: PSTN_STATIC objectClass: freeradiusProfile objectClass: top radiusNASPortType: Async radiusFramedProtocol: PPP radiusCisco-AVPair: lcp:interface-config#1=ip vrf forwarding STATIC_USER radiusCisco-AVPair: lcp:interface-config#2=ip unnumbered Loopback1001 radiusServiceType: Framed Now, I want to authorize the user according to this information. I have read and tried the configuration described in ldap_howto.txt shipped in the freeradius distribution. It uses the Ldap-Group attribute and the users file. This configuration is sub-optimal because it generates many ldap queries trying to figure out in which group a user belongs. If we have many entries in the users file, one for each group, each entry will generate a couple of queries until the matching entry is found. So if we have, for example, a hundred groups and the last one in the users file matches, we will have generated ~200 ldap queries, just to find the group the user belongs to. I try the following alternative approach: #ldap.attrmap checkItem Group radiusProfile #users file ... DEFAULT Group == PSTN_STATIC, User-Profile := "cn=PSTN_DYNAMIC,ou=radiusProfiles,dc=company,dc=gr" Fall-Through = no DEFAULT Auth-Type := Reject Reply-Message = "Unauthorized access." #radiusd.conf authorize { preprocess chap mschap suffix ldap files ldap } In the first pass through the ldap module I want to set the Group attribute, then in users file set the User-Profile and I use one more pass through the ldap module to get the profile attributes. However this is what I get when testing with radclient: rad_recv: Access-Request packet from host 127.0.0.1:41392, id=167, length=52 User-Name = "kzorba" User-Password = "XXXXXX" NAS-IP-Address = 62.103.0.99 Processing the authorize section of radiusd.conf modcall: entering group authorize for request 0 modcall[authorize]: module "preprocess" returns ok for request 0 modcall[authorize]: module "chap" returns noop for request 0 modcall[authorize]: module "mschap" returns noop for request 0 rlm_realm: No '@' in User-Name = "kzorba", looking up realm NULL rlm_realm: Found realm "NULL" rlm_realm: Adding Stripped-User-Name = "kzorba" rlm_realm: Proxying request from user kzorba to realm NULL rlm_realm: Adding Realm = "NULL" rlm_realm: Authentication realm is LOCAL. modcall[authorize]: module "suffix" returns noop for request 0 rlm_ldap: - authorize rlm_ldap: performing user authorization for kzorba radius_xlat: '(&(uid=kzorba)(objectClass=MyRadiusAccount)(radiusAccountStatus=activated))' radius_xlat: 'ou=people,dc=company,dc=gr' rlm_ldap: ldap_get_conn: Checking Id: 0 rlm_ldap: ldap_get_conn: Got Id: 0 rlm_ldap: attempting LDAP reconnection rlm_ldap: (re)connect to ldapserver.company.gr:489, authentication 0 rlm_ldap: bind as cn=Directory Manager/XXXXXX to ldapserver.company.gr:489 rlm_ldap: waiting for bind result ... rlm_ldap: Bind was successful rlm_ldap: performing search in ou=people,dc=company,dc=gr, with filter (&(uid=kzorba)(objectClass=MyRadiusAccount)(radiusAccountStatus=activated)) rlm_ldap: Added password XXXXXX in check items rlm_ldap: looking for check items in directory... rlm_ldap: Adding radiusProfile as Group, value PSTN_STATIC & op=21 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ rlm_ldap: Adding radiusMaxLogins as Simultaneous-Use, value 1 & op=21 rlm_ldap: looking for reply items in directory... rlm_ldap: Adding Framed-IP-Address as Framed-IP-Address, value 62.103.176.39 & op=11 rlm_ldap: user kzorba authorized to use remote access rlm_ldap: ldap_release_conn: Release Id: 0 modcall[authorize]: module "ldap" returns ok for request 0 users: Matched entry DEFAULT at line 82 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^(?) Here, the files module does not match the line with the Group == PSTN_STATIC condition, but the last DEFAULT line that rejects the user modcall[authorize]: module "files" returns ok for request 0 rlm_ldap: - authorize rlm_ldap: performing user authorization for kzorba radius_xlat: '(&(uid=kzorba)(objectClass=MyRadiusAccount)(radiusAccountStatus=activated))' radius_xlat: 'ou=people,dc=company,dc=gr' rlm_ldap: ldap_get_conn: Checking Id: 0 rlm_ldap: ldap_get_conn: Got Id: 0 rlm_ldap: performing search in ou=people,dc=company,dc=gr, with filter (&(uid=kzorba)(objectClass=MyRadiusAccount)(radiusAccountStatus=activated)) rlm_ldap: looking for check items in directory... rlm_ldap: Adding radiusProfile as Group, value PSTN_STATIC & op=21 rlm_ldap: Adding radiusMaxLogins as Simultaneous-Use, value 1 & op=21 rlm_ldap: looking for reply items in directory... rlm_ldap: Adding Framed-IP-Address as Framed-IP-Address, value 62.103.176.39 & op=11 rlm_ldap: user kzorba authorized to use remote access rlm_ldap: ldap_release_conn: Release Id: 0 modcall[authorize]: module "ldap" returns ok for request 0 modcall: leaving group authorize (returns ok) for request 0 rad_check_password: Found Auth-Type Reject rad_check_password: Auth-Type = Reject, rejecting user auth: Failed to validate the user. Delaying request 0 for 1 seconds Finished request 0 Going to the next request --- Walking the entire request list --- Waking up in 1 seconds... --- Walking the entire request list --- Waking up in 1 seconds... --- Walking the entire request list --- Sending Access-Reject of id 167 to 127.0.0.1 port 41392 Reply-Message = "Unauthorized access." Nothing to do. Sleeping until we see a request. My questions are: - Does this approach have a meaning? - Why the Group attribute returned through LDAP does not match the correct entry in users file? - Are there any alternative ideas to achieve the setup I want (users + profiles stored in LDAP with the form of the user entry as I described) Thanks in advance for any answers. Kostas -- Kostas Zorbadelos m@il contact: kzorba (at) otenet.gr Out there in the darkness, out there in the night out there in the starlight, one soul burns brighter than a thousand suns.

3 9

not-logged off users... how to decide whether a user is connected or not?
by liran tal 02 Jul '06

02 Jul '06

As it happens, (no idea why), a user is disconnceted after a poweroutage/powersurge/modem disconnection or whatever the reason is but the radius doesnt see the user as online. The record in the radacct table has a Start Time but doesnt have a Stop time, the AcctStopTime is set at " 0000-00-00 00:00:00" which is probably because the user was disconnected abruptly and didn't have the chance to send the Account Stop packet or a Disconnect packet. Anyway, to the bottom line - how do i deal with such situation? Thanks in advance.

2 1

Called-Station-Id not logged to sql when login fails csid check
by Mike Jakubik 01 Jul '06

01 Jul '06

Hello, It seems that the Called-Station-Id is not logged to SQL when the login fails the Called-Station-Id check using the rlm_checkval module. Any ideas why that is? It makes troubleshooting impossible. Thanks.

2 3

rlm_perl %RAD_REQUEST rewrite
by Evil I_Am 01 Jul '06

01 Jul '06

Hi Is the %RAD_REQUEST hash used by rlm_perl read only? i need to modify some of the request packet attributes but it do not seems to work.

4 3

Simultaneous-Use does not match on Huntgroup-Name
by B Thompson 01 Jul '06

01 Jul '06

Hi I have just been testing out Simultaneaous-Use and I cannot get it to match on a Huntgroup-Name (where the the huntgroup is a list of NAS-IP-Address entries). If I specify Simultaneous-Use against each NAS-IP-Address individually in the users file it works fine. This works :- DEFAULT NAS-IP-Address == x.x.x.x, Simultaneous-Use := 1 Fall-Through = Yes This does not work :- DEFAULT Huntgroup-Name == blah, Simultaneous-Use := 1 Fall-Through = Yes This is with the stock RedHat FreeRADIUS 1.0.1 Am I doing something wrong or is this a bug? Thanks Ben -- Ben Thompson University of York

1 1

How to Disable user
by Jeremy ohara 01 Jul '06

01 Jul '06

hi there i have Freeradius 1.0.5 and using MYSQL backend how can i disble a user from logging in? hope you can help. Jeremy ---------------------------------------------------------------------------- This email has been scanned for Virus by MDaemon AntiVirus part of MDaemon. Updated daily to keep up-to-date with all new and old viruses. ----------------------------------------------------------------------------

2 4

Throttle On Cap
by Alex Abraham 01 Jul '06

01 Jul '06

I need some help with implementing "Throttle on Cap Usage" type feature for our ADSL project. Wondering if any one has implemented this using Freeradius and MySQL and if you could point me in the right direction. The BRAS we are using is Huawei MA5200F. Thanks in Advance ============================================ Alex Abraham

3 5

error: Failed dependencies: libeap-1.1.2.so is needed by freeradius-1.1.2-0.i386
by Alberto Cruz 30 Jun '06

30 Jun '06

Hi everybody. I'm trying to install the RPM file that I built for RedHat Entrerprise 4.0 (RHEL4) and Freeradius 1.1.2 When I tried the command I'm getting the following error: error: Failed dependencies: libeap-1.1.2.so is needed by freeradius-1.1.2-0.i386 Do I need to install something else before the freeradius RPM file? Should I had added a prefix/option at the time of build the RPM packet in order to include the libeap-1.1.2 libray? Regards Alberto Cruz

4 10