- Freeradius-Users - lists.freeradius.org

unixtime for %S in rlm_sql_log
by Jan Klopfleisch 09 Jun '10

09 Jun '10

Hi, is there a way to convert the %S in a unixtimestamp? I try to use unix_timestamp() but it only prints this string in the sql_relay file. Is there a list of all attributes which i can use in the sql_log? Thanks in advanced, Jan

1 0

Proxying inner requests from EAP-TTLS
by Martin Merkel 08 Jun '10

08 Jun '10

Hi, I'm currently working on a test setup for a study thesis. The goal is to use wired 802.1X and EAP-TTLS with a local AAA server which proxies the tunneled requests to the appropriate home servers. My problem right now is that I can't get freeradius to proxy the inner requests. The TTLS tunnel is successfully established and the inner request is sent to the virtual server. Freeradius recognizes that the inner request should be proxied but it says that it can't create a new socket. So my question is: Can requests in virtual servers be proxied at all or is there another way to do it? The version of freeradius is 2.1.9. The configuration on the local AAA server is: default site ------------ authorize { preprocess eap { ok = return } files } authenticate { eap } inner tunnel ------------ authorize { suffix eap { ok = return } files } authenticate { eap } proxy.conf ---------- home_server homeaaa { type = auth ipaddr = 10.10.0.22 port = 1812 secret = proxy require_message_authenticator = no response_window = 20 zombie_period = 40 revive_interval = 120 status_check = status-server check_interval = 30 num_answers_to_alive = 3 } home_server_pool aaa_pool { type = fail-over home_server = homeaaa } realm home { auth_pool = aaa_pool nostrip } The debug output: rad_recv: Access-Request packet from host 10.10.0.23 port 1645, id=12, length=254 User-Name = "anonymous@home" Service-Type = Framed-User Framed-MTU = 1504 Called-Station-Id = "00-16-C8-3D-1B-82" Calling-Station-Id = "00-1B-21-15-CF-1D" EAP-Message = 0x0207007015001703010020ffce9586905dafa8df6d7678d778ba49cf74ac059e4004604191a70b751841dd17030100400c32774ceaefd6d1544bc87a2bd47567e17f03976be24ebcd64faa95186efea24064f53563b55a98fb7469f9a83d191d15306fde31d0229d55fa27816cf55dfa Message-Authenticator = 0x6a3417e727dc739f3e989254b644b56f NAS-Port-Type = Ethernet NAS-Port = 50002 State = 0x47887413438f612a688db3fc6f33d684 NAS-IP-Address = 10.10.0.23 +- entering group authorize {...} ++[preprocess] returns ok [eap] EAP packet type response id 7 length 112 [eap] Continuing tunnel setup. ++[eap] returns ok Found Auth-Type = EAP +- entering group authenticate {...} [eap] Request found, released from the list [eap] EAP/ttls [eap] processing type ttls [ttls] Authenticate [ttls] processing EAP-TLS [ttls] eaptls_verify returned 7 [ttls] Done initial handshake [ttls] eaptls_process returned 7 [ttls] Session established. Proceeding to decode tunneled attributes. [ttls] Got tunneled request EAP-Message = 0x0200000e0164656d6f40686f6d65 FreeRADIUS-Proxied-To = 127.0.0.1 [ttls] Got tunneled identity of demo@home [ttls] Setting default EAP type for tunneled EAP session. [ttls] Sending tunneled request EAP-Message = 0x0200000e0164656d6f40686f6d65 FreeRADIUS-Proxied-To = 127.0.0.1 User-Name = "demo@home" server inner-tunnel { +- entering group authorize {...} [suffix] Looking up realm "home" for User-Name = "demo@home" [suffix] Found realm "home" [suffix] Adding Realm = "home" [suffix] Proxying request from user demo to realm home [suffix] Preparing to proxy authentication request to realm "home" ++[suffix] returns updated [eap] Request is supposed to be proxied to Realm home. Not doing EAP. ++[eap] returns noop ++[files] returns noop } # server inner-tunnel [ttls] Got tunneled reply code 0 [ttls] Tunneled authentication will be proxied to home [eap] Tunneled session will be proxied. Not doing EAP. ++[eap] returns handled +- entering group pre-proxy {...} [pre_proxy_log] expand: /usr/local/radius/2.1.9/var/log/radius/radacct/%{Client-IP-Address}/pre-proxy-detail-%Y%m%d -> /usr/local/radius/2.1.9/var/log/radius/radacct/10.10.0.23/pre-proxy-detail-20100607 [pre_proxy_log] /usr/local/radius/2.1.9/var/log/radius/radacct/%{Client-IP-Address}/pre-proxy-detail-%Y%m%d expands to /usr/local/radius/2.1.9/var/log/radius/radacct/10.10.0.23/pre-proxy-detail-20100607 [pre_proxy_log] expand: %t -> Mon Jun 7 18:22:01 2010 ++[pre_proxy_log] returns ok Failed to create a new socket for proxying requests. ERROR: Failed inserting request into proxy hash. ERROR: Failed to proxy request 5 There was no response configured: rejecting request 5 Using Post-Auth-Type Reject +- entering group REJECT {...} [attr_filter.access_reject] expand: %{User-Name} -> anonymous@home attr_filter: Matched entry DEFAULT at line 11 ++[attr_filter.access_reject] returns updated Delaying reject of request 5 for 1 seconds Going to the next request Waking up in 0.9 seconds. Sending delayed reject for request 5 Sending Access-Reject of id 12 to 10.10.0.23 port 1645 Waking up in 3.8 seconds. Cleaning up request 0 ID 7 with timestamp +32 Cleaning up request 1 ID 8 with timestamp +32 Cleaning up request 2 ID 9 with timestamp +32 Cleaning up request 3 ID 10 with timestamp +32 Cleaning up request 4 ID 11 with timestamp +32 Waking up in 1.0 seconds. Cleaning up request 5 ID 12 with timestamp +32 rlm_eap_ttls: Freeing handler for user demo@home Ready to process requests. If I read the code correctly, the problem should originate in listen.c in function rad_listen_t *proxy_new_listener(fr_ipaddr_t *ipaddr, int exists) I hope that I included all the neccessary information. Kind regards, Martin

2 4

CHAP wrong password issue
by lixo lixao 08 Jun '10

08 Jun '10

Hi folks, I have this trouble and i getting nuts with :) I have this scenario: MODEM DSLAM PPPoE-Server Version 3.10 FreeRADIUS Version 2.0.4 Mysql5 All worked fine for a while, but I messed up something, and i dont know what it is. All login request are refused: freeradius -X --------------------------------- ... rad_check_password: Found Auth-Type CHAP ... auth: type "CHAP" +- entering group CHAP rlm_chap: login attempt by "MYUSER" with CHAP password rlm_chap: Using clear text password "MYPASS" for user MYUSER authentication. rlm_chap: Password check failed ++[chap] returns reject auth: Failed to validate the user. Login incorrect (rlm_chap: Wrong user password): [MYUSER/<CHAP-Password>] (from client localhost port 40 cli 00:24:01:88:69:3F) ... -------------------------------- On user attributes @ mysql i have: User-Password := MYPASS Auth-Type := CHAP -------------------------------- I spend a lot of time looking for answers on google, but not helped. Please, anyone have a clue about this???? Thanks a lot.

2 5

Warning compiling pam_radius_auth on Solaris 10 x86 with gcc 3.4.3
by Martin Richard 08 Jun '10

08 Jun '10

Hello, I planning on testing pam_radius_auth under Solaris 10 at a client site. I've copied below the output I get which contains a certain amount of warnings. I do get the library .so produced, so can these warning be ignored safely ? Thanks for any pointers/advice. Martin ----8<------ $ gmake clean $ gmake /usr/sfw/bin/gcc -Wall -fPIC -c pam_radius_auth.c -o pam_radius_auth.o pam_radius_auth.c: In function `rad_converse': pam_radius_auth.c:1027: warning: passing arg 3 of `pam_get_item' from incompatible pointer type pam_radius_auth.c:1030: warning: passing arg 2 of pointer to function from incompatible pointer type pam_radius_auth.c: In function `pam_sm_authenticate': pam_radius_auth.c:1081: warning: passing arg 2 of `pam_get_user' from incompatible pointer type pam_radius_auth.c:1097: warning: passing arg 3 of `pam_get_item' from incompatible pointer type pam_radius_auth.c:1102: warning: assignment from incompatible pointer type pam_radius_auth.c:1121: warning: passing arg 3 of `pam_get_item' from incompatible pointer type pam_radius_auth.c:1135: warning: passing arg 3 of `pam_get_item' from incompatible pointer type pam_radius_auth.c:1168: warning: passing arg 3 of `pam_get_item' from incompatible pointer type pam_radius_auth.c: In function `pam_private_session': pam_radius_auth.c:1300: warning: passing arg 2 of `pam_get_user' from incompatible pointer type pam_radius_auth.c:1321: warning: passing arg 3 of `pam_get_item' from incompatible pointer type pam_radius_auth.c: In function `pam_sm_chauthtok': pam_radius_auth.c:1407: warning: passing arg 2 of `pam_get_user' from incompatible pointer type pam_radius_auth.c:1428: warning: passing arg 3 of `pam_get_item' from incompatible pointer type pam_radius_auth.c:1437: warning: passing arg 3 of `pam_get_item' from incompatible pointer type pam_radius_auth.c:1442: warning: passing arg 3 of `pam_get_item' from incompatible pointer type /usr/sfw/bin/gcc -Wall -fPIC -c -o md5.o md5.c /usr/sfw/bin/gld -Bshareable pam_radius_auth.o md5.o -lpam -o pam_radius_auth.so $ file pam_radius_auth.so pam_radius_auth.so: ELF 32-bit LSB dynamic lib 80386 Version 1, dynamically linked, not stripped, no debugging information available $ uname -a SunOS XXXXXXXXX 5.10 Generic_137138-09 i86pc i386 i86pc $ gcc --version gcc (GCC) 3.4.3 (csl-sol210-3_4-branch+sol_rpath) Copyright (C) 2004 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. $ -----8<------

2 1

Logging Attributes to SQL
by Natr Brazell 08 Jun '10

08 Jun '10

All, I've set up FR2 to log acct data to mysql and that appears to be working. I'm curious about how to enable the logging of specific attributes that are being sent by the NAS. Specifically: rad_recv: Accounting-Request packet from host x.x.x.120 port 51637, id=50, length=95 Acct-Status-Type = Interim-Update Acct-Session-Id = "C2594B9A71DB" Acct-Delay-Time = 0 User-Name = "joe.bobuser" NAS-Identifier = "M20" Juniper-Interactive-Command = "run start shell " NAS-IP-Address = x.x.x.120 +- entering group preacct {...} As you can see in the Accounting-Request packet above There is a NAS-Identifier and a Juniper-Interactive-Command entry. Those attributes are not being logged (nor do I think I'd want them) in my radacct file. Is there a way to have radius automatically populate an accountingactivity table (history file if you will)? Or this there a manual way say in postauth to send those attributes to a mysql table via script when an Accounting-Request packet is received. The above attributes are being sent and are logged in my detail-`date` log file in /var/log/radius/radacct/IP_OF_NAS directory. Thanks, N

1 0

freeradius authentication stops working after some time...
by Thomas Munck Steenholdt 08 Jun '10

08 Jun '10

Hi List... I've been having this strange issue, that I hope somebody in here will be able to assist me in solving. I have a Linux machine (Ubuntu 9.10, 32 bit), running freeradius 2.1.0 (ubuntu 9.10 version, but re-built with ssl), setup to provide authentication services for a wireless network using ntlm against a Windows 2008 AD. On fresh reboot of the machine, everything works just fine. After some time, though, things start to fail (I'm not sure exactly how long it works, or even if the working period of time is the same every time, but I'd say roughly a days time). Even when authentication is failing, wbinfo -t and ntlm_auth appears to be working and freeradius is still running. But it starts logging "Auth: Login incorrect:" errors. Restarting the server makes things work again - every time. Any idea where to look? Thanks in advance. /Thomas

5 5

FreeRADIUS and Asterisk. Problem with accounting
by Pawel Plato 08 Jun '10

08 Jun '10

Hi all. The problems start when I configure FreeRadius to insert RADIUS accounting data into SQL, in my case - postgreSQL database. I followed the steps on http://wiki.freeradius.org/SQL_HOWTO. FreeRadius creates SQL insert indeed, as you can see down below, but the thing is that the data from this table is totally useless, as e.g. acctstartime and acctstoptime fields are equal, which doesn't make sense. If we see the /var/log/radius/radacct/127.0.0.1/detail-20080107 file (see above), we can see that all of the AvPs are created in the SQL table, except the ones which have "Asterisk" as prefix (e.g. Asterisk-Acc-Code, Asterisk-Src, etc). I thought that FreeRadius will somehow map these values from Asterisk to values which can be put to radacct table, e.g. Asterisk-Start-Time ---> acctstarttime, etc. Obviously, it doesn't. I've been googling for whole day concerning this problem, and I wasn't able to find anything related to it, so probably other users had no problems with that. I assume that I would have to create a custom table for supporting asterisk RADIUS packets, but I wasn't able to find anything on google. I would appreciate any kind of help, hint, or advice. Paweł Plato

2 1

MYSQL and FR2
by Natr Brazell 08 Jun '10

08 Jun '10

I am looking for a good reference on how to integrate MYSQL and Freeradius. I've set up the basics and imported the schema's and modified the sql.conf file and the sites-enabled/default files. All starting and running fine. What I don't know about are how (if at all) you can log the rad_recv messages to sql. For instance my NAS is sending back the following: *rad_recv: Accounting-Request packet from host x.x.x.120 port 51637, id=50, length=95 Acct-Status-Type = Interim-Update Acct-Session-Id = "C2594B9A71DB" Acct-Delay-Time = 0 User-Name = "joe.bobuser" NAS-Identifier = "M20" Juniper-Interactive-Command = "run start shell " NAS-IP-Address = x.x.x.120 *+- entering group preacct {...} ++[preprocess] returns ok [acct_unique] WARNING: Attribute NAS-Port was not found in request, unique ID MAY be inconsistent [acct_unique] Hashing ',Client-IP-Address = x.x.x.120,NAS-IP-Address = x.x.x.120,Acct-Session-Id = "C2594B9A71DB",User-Name = "joe.bobuser"' [acct_unique] Acct-Unique-Session-ID = "c8c99ca6ea5c67dc". ++[acct_unique] returns ok [suffix] No '@' in User-Name = "joe.bobuser", looking up realm NULL [suffix] No such realm "NULL" ++[suffix] returns noop ++[files] returns noop +- entering group accounting {...} [detail] expand: /var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d -> /var/log/radius/radacct/x.x.x.120/detail-20100607 [detail] /var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to /var/log/radius/radacct/x.x.x.120/detail-20100607 [detail] expand: %t -> Mon Jun 7 11:13:24 2010 ++[detail] returns ok ++[unix] returns noop [radutmp] expand: /var/log/radius/radutmp -> /var/log/radius/radutmp [radutmp] expand: %{User-Name} -> joe.bobuser rlm_radutmp: No NAS-Port seen. Cannot do anything. rlm_radumtp: WARNING: checkrad will probably not work! ++[radutmp] returns noop [sql] expand: %{User-Name} -> joe.bobuser [sql] sql_set_user escaped user --> 'joe.bobuser' [sql] expand: %{Acct-Input-Gigawords} -> [sql] ... expanding second conditional [sql] expand: %{Acct-Input-Octets} -> [sql] ... expanding second conditional [sql] expand: %{Acct-Output-Gigawords} -> [sql] ... expanding second conditional [sql] expand: %{Acct-Output-Octets} -> [sql] ... expanding second conditional [sql] expand: UPDATE radacct SET framedipaddress = '%{Framed-IP-Address}', acctsessiontime = '%{Acct-Session-Time}', acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}' WHERE acctsessionid = '%{Acct-Session-Id}' AND username = '%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}' -> UPDATE radacct SET framedipaddress = '', acctsessiontime = '', acctinputoctets = '0' << 32 | '0', acctoutputoctets = '0' << 32 | '0' WHERE acctsessionid = 'C2594B9A71DB' AND username = 'joe.bobuser' AND nasipaddress = [sql] expand: /var/log/radius/sqltrace.sql -> /var/log/radius/sqltrace.sql rlm_sql (sql): Reserving sql socket id: 0 rlm_sql_mysql: query: UPDATE radacct SET framedipaddress = '', acctsessiontime = '', acctinputoctets = '0' << 32 | '0', acctoutputoctets = '0' << 32 | '0' WHERE acctsessionid = 'C2594B9A71DB' AND username = 'joe.bobuser' AND nasipaddress = 'x.x.x.120' rlm_sql (sql): Released sql socket id: 0 ++[sql] returns ok [attr_filter.accounting_response] expand: %{User-Name} -> joe.bobuser attr_filter: Matched entry DEFAULT at line 12 ++[attr_filter.accounting_response] returns updated Sending Accounting-Response of id 50 to x.x.x.120 port 51637 Finished request 5. Cleaning up request 5 ID 50 with timestamp +397 Going to the next request Ready to process requests. rad_recv: Accounting-Request packet from host x.x.x.120 port 51637, id=51, length=84 Acct-Status-Type = Interim-Update Acct-Session-Id = "C2594B9A71DB" Acct-Delay-Time = 0 User-Name = "joe.bobuser" NAS-Identifier = "M20" Juniper-Interactive-Command = "quit " NAS-IP-Address = x.x.x.120 ... As can be seen above the rad_recv: section is sending back a few items that I am interested in having logged. For instance the Juniper-Interactive-Command. Thanks if you can help or point me in the right direction. N

2 3

radtest and IPv6 support
by Panagiotis Georgopoulos 08 Jun '10

08 Jun '10

Hello all, I am trying to use radtest to test my freeradius configuration over IPv6. I have configured IPv6 on my freeradius server and a client machine from which I am firing radtest. However when I issue "radtest bob hello 2001:db95::100 100 testing123" on my client I get a "radclient: socket: cannot initialize udpfromto: Function not implemented" Google returns a few people reporting this, but answers are related to changing how localhost is resolved when testing it from the freeradius server. Is there a proper solution for using radtest over IPv6 from a remote machine? Btw radtest works fine over IPv4 on my current setup. Thanks a lot, Panos

3 7

authenticate fails
by Spacelee 08 Jun '10

08 Jun '10

radtest says: radtest test test localhost 2313 12345678 Sending Access-Request of id 142 to 127.0.0.1 port 1812 User-Name = "test" User-Password = "test" NAS-IP-Address = 127.0.0.1 NAS-Port = 2313 rad_recv: Access-Reject packet from host 127.0.0.1 port 1812, id=142, length=20 and the radius server says: rad_recv: Access-Request packet from host 127.0.0.1 port 39501, id=142, length=56 User-Name = "test" User-Password = "test" NAS-IP-Address = 127.0.0.1 NAS-Port = 2313 +- entering group authorize {...} ++[preprocess] returns ok ++[chap] returns noop ++[mschap] returns noop [suffix] No '@' in User-Name = "test", looking up realm NULL [suffix] No such realm "NULL" ++[suffix] returns noop [eap] No EAP-Message, not doing EAP ++[eap] returns noop ++[unix] returns notfound [files] users: Matched entry test at line 1 ++[files] returns ok ++[expiration] returns noop ++[logintime] returns noop [pap] Found existing Auth-Type, not changing it. ++[pap] returns noop Found Auth-Type = MSCHAP +- entering group MS-CHAP {...} [mschap] No MS-CHAP-Challenge in the request ++[mschap] returns reject Failed to authenticate the user. Using Post-Auth-Type Reject +- entering group REJECT {...} [attr_filter.access_reject] expand: %{User-Name} -> test attr_filter: Matched entry DEFAULT at line 11 ++[attr_filter.access_reject] returns updated Delaying reject of request 0 for 1 seconds Going to the next request Waking up in 0.9 seconds. Sending delayed reject for request 0 Sending Access-Reject of id 142 to 127.0.0.1 port 39501 Waking up in 4.9 seconds. Cleaning up request 0 ID 142 with timestamp +38 Ready to process requests. I don't know why it fails -- Spacelee

2 1