- Freeradius-Users - lists.freeradius.org

Fwd: SQL Counter
by Enrique Acosta 11 Dec '06

11 Dec '06

I have the same error message. Somebody adviced me that I have to download the latest release of freeradius . ---------- Forwarded Message ---------- Subject: SQL Counter Date: Monday 11 December 2006 02:04 pm From: Sean <sean(a)swarmhotspots.com> To: freeradius-users(a)lists.freeradius.org Hi, Sorry if this is a repeat. I'm not sure if an email I sent yesterday got through. Clearly I'm missing something simple here. I'm trying to create accounts that will renew on a daily or monthly basis. I've put this code into my radiusd.conf file to test daily renewals. $INCLUDE ${confdir}/sql.conf sqlcounter dailycounter { counter-name = Daily-Session-Time check-name = Max-Daily-Session sqlmod-inst = sql key = User-Name reset = daily query = "SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='%{%k}'" } I've created this account in the MySQL radcheck table. ropgis12 User-Password := gisnopum ropgis12 Simultaneous-Use:= 1 ropgis12 Max-Daily-Session := 1800 radiusd -X gives the following result. rlm_sql (sql): Reserving sql socket id: 0 rlm_sql: Failed to create the pair: Unknown attribute "Max-Daily-Session" rlm_sql (sql): Error getting data from database rlm_sql (sql): SQL query error; rejecting user rlm_sql (sql): Released sql socket id: 0 modcall[authorize]: module "sql" returns fail for request 39 modcall: group authorize returns fail for request 39 I can't understand why Max-Daily-Session is an unknown attribute when it's declared in the radiusd.conf and radius loads with no errors. As usual any help would be appreciated. Sean Bracken - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html ------------------------------------------------------- -- Enrique Acosta Administrador de Red en Nodo Infosur Cfgos, Cuba Est modus in rebus Linux user # 391079 http://counter.li.org

1 0

Re: Simultaneous-Use doesn't work.
by Ernie Dunbar 11 Dec '06

11 Dec '06

> Hello Ernie, > > Just wondering if you are using clients.conf at all? Yup. The way you can tell is by running `freeradius -X`, like I did. You'll see a line like this: Config: including file: /etc/freeradius/clients.conf > I need to migrate > an older freeradius 0.9x to 1.2 and notice that the newer sql setup > uses an "nas" table that was not in the older setup. We used > clients.conf for the nas's and I'm trying to figure out how/if > clients.conf gets migrated to the nas table. Did you find any > pertinent docs? Nope. The best documentation I can find is the FreeRADIUS faq on the FreeRADIUS home page. And it's out of date in this matter. > > Friday, December 1, 2006, 2:46:04 PM, you wrote: > >> I'm using FreeRADIUS 1.0.2 and its associated mysql plugin on a Debian >> 3.1 >> system. I've managed to get the server working to where our customers >> are >> authenticating out of the mysql database just fine and the accounting >> records are being stored in mysql properly too. > >> But the Simultaneous-Use configuration directive doesn't do a thing. It >> doesn't even check against radwtmp (even though the radwho command works >> fine) when someone logs on. The FAQ at >> http://www.freeradius.org/faq/#4.7.2 doesn't help any either, in no >> small >> part because it's outdated and neither raddb/naslist nor radcheck.pl >> exist >> in the new version. I don't see anything about Simultaneous-Use being >> parsed when I run 'freeradius -X' however, so that might be a clue. > >> Here's the appropriate configuration on our server: > >> clients.conf: > >> client XXX.XXX.XXX.XXX { >> secret = XXXXXX >> nastype = cisco >> login = XXXXXX >> password = XXXXXX >> shortname = dialup >> } > >> users: > >> DEFAULT Framed-Protocol == PPP, Simultaneous-Use := 1 >> Framed-Protocol = PPP, >> Service-Type = Framed-User, >> Framed-Compression = Van-Jacobson-TCP-IP > >> And finally, the output of freeradius -X: > >> ns2:/etc/freeradius# /usr/sbin/freeradius -X >> Starting - reading configuration files ... >> reread_config: reading radiusd.conf >> Config: including file: /etc/freeradius/proxy.conf >> Config: including file: /etc/freeradius/clients.conf >> Config: including file: /etc/freeradius/snmp.conf >> Config: including file: /etc/freeradius/eap.conf >> Config: including file: /etc/freeradius/sql.conf >> main: prefix = "/usr" >> main: localstatedir = "/var" >> main: logdir = "/var/log/freeradius" >> main: libdir = "/usr/lib/freeradius" >> main: radacctdir = "/var/log/freeradius/radacct" >> main: hostname_lookups = no >> main: max_request_time = 30 >> main: cleanup_delay = 5 >> main: max_requests = 256 >> main: delete_blocked_requests = 0 >> main: port = 1812 >> main: allow_core_dumps = no >> main: log_stripped_names = yes >> main: log_file = "/var/log/freeradius/radius.log" >> main: log_auth = yes >> main: log_auth_badpass = yes >> main: log_auth_goodpass = yes >> main: pidfile = "/var/run/freeradius/freeradius.pid" >> main: user = "freerad" >> main: group = "freerad" >> main: usercollide = no >> main: lower_user = "no" >> main: lower_pass = "no" >> main: nospace_user = "after" >> main: nospace_pass = "after" >> main: checkrad = "/usr/sbin/checkrad" >> main: proxy_requests = off >> security: max_attributes = 200 >> security: reject_delay = 1 >> security: status_server = no >> main: debug_level = 0 >> read_config_files: reading dictionary >> read_config_files: reading naslist >> read_config_files: reading clients >> read_config_files: reading realms >> radiusd: entering modules setup >> Module: Library search path is /usr/lib/freeradius >> Module: Loaded exec >> exec: wait = yes >> exec: program = "(null)" >> exec: input_pairs = "request" >> exec: output_pairs = "(null)" >> exec: packet_type = "(null)" >> rlm_exec: Wait=yes but no output defined. Did you mean output=none? >> Module: Instantiated exec (exec) >> Module: Loaded expr >> Module: Instantiated expr (expr) >> Module: Loaded PAP >> pap: encryption_scheme = "crypt" >> Module: Instantiated pap (pap) >> Module: Loaded MS-CHAP >> mschap: use_mppe = yes >> mschap: require_encryption = no >> mschap: require_strong = no >> mschap: with_ntdomain_hack = no >> mschap: passwd = "(null)" >> mschap: authtype = "MS-CHAP" >> mschap: ntlm_auth = "(null)" >> Module: Instantiated mschap (mschap) >> Module: Loaded System >> unix: cache = no >> unix: passwd = "(null)" >> unix: shadow = "/etc/shadow" >> unix: group = "(null)" >> unix: radwtmp = "/var/log/freeradius/radwtmp" >> unix: usegroup = no >> unix: cache_reload = 600 >> Module: Instantiated unix (unix) >> Module: Loaded preprocess >> preprocess: huntgroups = "/etc/freeradius/huntgroups" >> preprocess: hints = "/etc/freeradius/hints" >> preprocess: with_ascend_hack = no >> preprocess: ascend_channels_per_line = 23 >> preprocess: with_ntdomain_hack = no >> preprocess: with_specialix_jetstream_hack = no >> preprocess: with_cisco_vsa_hack = no >> Module: Instantiated preprocess (preprocess) >> Module: Loaded files >> files: usersfile = "/etc/freeradius/users" >> files: acctusersfile = "/etc/freeradius/acct_users" >> files: preproxy_usersfile = "/etc/freeradius/preproxy_users" >> files: compat = "no" >> Module: Instantiated files (files) >> Module: Loaded SQL >> sql: driver = "rlm_sql_mysql" >> sql: server = "localhost" >> sql: port = "" >> sql: login = "dialupacct" >> sql: password = "d8271@#1" >> sql: radius_db = "dialupacct" >> sql: acct_table = "radacct" >> sql: acct_table2 = "radacct" >> sql: authcheck_table = "radcheck" >> sql: authreply_table = "radreply" >> sql: groupcheck_table = "radgroupcheck" >> sql: groupreply_table = "radgroupreply" >> sql: usergroup_table = "usergroup" >> sql: nas_table = "nas" >> sql: dict_table = "dictionary" >> sql: sqltrace = yes >> sql: sqltracefile = "/var/log/freeradius/sqltrace.sql" >> sql: readclients = no >> sql: deletestalesessions = yes >> sql: num_sql_socks = 5 >> sql: sql_user_name = "%{User-Name}" >> sql: default_user_profile = "" >> sql: query_on_not_found = no >> sql: authorize_check_query = "SELECT >> id,UserName,Attribute,Value,op FROM >> radcheck WHERE Username = '%{SQL-User-Name}' ORDER BY id" >> sql: authorize_reply_query = "SELECT >> id,UserName,Attribute,Value,op FROM >> radreply WHERE Username = '%{SQL-User-Name}' ORDER BY id" >> sql: authorize_group_check_query = "SELECT >> radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op >> FROM radgroupcheck,usergroup WHERE usergroup.Username = >> '%{SQL-User-Name}' AND usergroup.GroupName = radgroupcheck.GroupName >> ORDER BY radgroupcheck.id" >> sql: authorize_group_reply_query = "SELECT >> radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op >> FROM radgroupreply,usergroup WHERE usergroup.Username = >> '%{SQL-User-Name}' AND usergroup.GroupName = radgroupreply.GroupName >> ORDER BY radgroupreply.id" >> sql: accounting_onoff_query = "UPDATE radacct SET AcctStopTime='%S', >> AcctSessionTime=unix_timestamp('%S') - unix_timestamp(AcctStartTime), >> AcctTerminateCause='%{Acct-Terminate-Cause}', AcctStopDelay = >> '%{Acct-Delay-Time}' WHERE AcctSessionTime=0 AND AcctStopTime=0 AND >> NASIPAddress= '%{NAS-IP-Address}' AND AcctStartTime <= '%S'" >> sql: accounting_update_query = "UPDATE radacct ? SET FramedIPAddress = >> '%{Framed-IP-Address}', ? AcctSessionTime = '%{Acct-Session-Time}', ? >> AcctInputOctets = '%{Acct-Input-Octets}', ? AcctOutputOctets = >> '%{Acct-Output-Octets}' ? WHERE AcctSessionId = '%{Acct-Session-Id}' ? >> AND UserName = '%{SQL-User-Name}' ? AND NASIPAddress= >> '%{NAS-IP-Address}'" >> sql: accounting_update_query_alt = "INSERT into radacct (AcctSessionId, >> AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, >> AcctStartTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, >> AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, >> ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay) >> values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', >> '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', >> '%{NAS-Port-Type}', DATE_SUB('%S',INTERVAL (%{Acct-Session-Time:-0} + >> %{Acct-Delay-Time:-0}) SECOND), '%{Acct-Session-Time}', >> '%{Acct-Authentic}', '', '%{Acct-Input-Octets}', >> '%{Acct-Output-Octets}', >> '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Service-Type}', >> '%{Framed-Protocol}', '%{Framed-IP-Address}', '0')" >> sql: accounting_start_query = "INSERT into radacct (AcctSessionId, >> AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, >> AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic, >> ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, >> CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, >> FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) >> values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', >> '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', >> '%{NAS-Port-Type}', '%S', '0', '0', '%{Acct-Authentic}', >> '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', >> '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', >> '%{Framed-IP-Address}', '%{Acct-Delay-Time}', '0')" >> sql: accounting_start_query_alt = "UPDATE radacct SET AcctStartTime = >> '%S', AcctStartDelay = '%{Acct-Delay-Time}', ConnectInfo_start = >> '%{Connect-Info}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND >> UserName >> = '%{SQL-User-Name}' AND NASIPAddress = '%{NAS-IP-Address}'" >> sql: accounting_stop_query = "UPDATE radacct SET AcctStopTime = '%S', >> AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets = >> '%{Acct-Input-Octets}', AcctOutputOctets = '%{Acct-Output-Octets}', >> AcctTerminateCause = '%{Acct-Terminate-Cause}', AcctStopDelay = >> '%{Acct-Delay-Time}', ConnectInfo_stop = '%{Connect-Info}' WHERE >> AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' >> AND NASIPAddress = '%{NAS-IP-Address}'" >> sql: accounting_stop_query_alt = "INSERT into radacct (AcctSessionId, >> AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, >> AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic, >> ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, >> CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, >> FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) >> values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', >> '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', >> '%{NAS-Port-Type}', DATE_SUB('%S', INTERVAL (%{Acct-Session-Time:-0} + >> %{Acct-Delay-Time:-0}) SECOND), '%S', '%{Acct-Session-Time}', >> '%{Acct-Authentic}', '', '%{Connect-Info}', '%{Acct-Input-Octets}', >> '%{Acct-Output-Octets}', '%{Called-Station-Id}', >> '%{Calling-Station-Id}', >> '%{Acct-Terminate-Cause}', '%{Service-Type}', '%{Framed-Protocol}', >> '%{Framed-IP-Address}', '0', '%{Acct-Delay-Time}')" >> sql: group_membership_query = "SELECT GroupName FROM usergroup WHERE >> UserName='%{SQL-User-Name}'" >> sql: connect_failure_retry_delay = 60 >> sql: simul_count_query = "SELECT COUNT(*) FROM radacct WHERE >> UserName='%{SQL-User-Name}' AND AcctStopTime = 0" >> sql: simul_verify_query = "SELECT RadAcctId, AcctSessionId, UserName, >> NASIPAddress, NASPortId, FramedIPAddress, CallingStationId, >> FramedProtocol FROM radacct WHERE UserName='%{SQL-User-Name}' AND >> AcctStopTime = 0" >> sql: postauth_table = "radpostauth" >> sql: postauth_query = "INSERT into radpostauth (id, user, pass, reply, >> date) values ('', '%{User-Name}', '%{User-Password:-Chap-Password}', >> '%{reply:Packet-Type}', NOW())" >> sql: safe-characters = >> "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" >> rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and >> linked >> rlm_sql (sql): Attempting to connect to dialupacct@localhost:/dialupacct >> rlm_sql (sql): starting 0 >> rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 >> rlm_sql_mysql: Starting connect to MySQL server for #0 >> rlm_sql (sql): Connected new DB handle, #0 >> rlm_sql (sql): starting 1 >> rlm_sql (sql): Attempting to connect rlm_sql_mysql #1 >> rlm_sql_mysql: Starting connect to MySQL server for #1 >> rlm_sql (sql): Connected new DB handle, #1 >> rlm_sql (sql): starting 2 >> rlm_sql (sql): Attempting to connect rlm_sql_mysql #2 >> rlm_sql_mysql: Starting connect to MySQL server for #2 >> rlm_sql (sql): Connected new DB handle, #2 >> rlm_sql (sql): starting 3 >> rlm_sql (sql): Attempting to connect rlm_sql_mysql #3 >> rlm_sql_mysql: Starting connect to MySQL server for #3 >> rlm_sql (sql): Connected new DB handle, #3 >> rlm_sql (sql): starting 4 >> rlm_sql (sql): Attempting to connect rlm_sql_mysql #4 >> rlm_sql_mysql: Starting connect to MySQL server for #4 >> rlm_sql (sql): Connected new DB handle, #4 >> Module: Instantiated sql (sql) >> Module: Loaded realm >> realm: format = "suffix" >> realm: delimiter = "@" >> realm: ignore_default = no >> realm: ignore_null = no >> Module: Instantiated realm (suffix) >> Module: Loaded detail >> detail: detailfile = >> "/var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d" >> detail: detailperm = 384 >> detail: dirperm = 493 >> detail: locking = no >> Module: Instantiated detail (detail) >> Module: Loaded radutmp >> radutmp: filename = "/var/log/freeradius/radutmp" >> radutmp: username = "%{User-Name}" >> radutmp: case_sensitive = yes >> radutmp: check_with_nas = yes >> radutmp: perm = 384 >> radutmp: callerid = yes >> Module: Instantiated radutmp (radutmp) >> Module: Loaded eap >> eap: default_eap_type = "md5" >> eap: timer_expire = 60 >> eap: ignore_unknown_eap_types = no >> eap: cisco_accounting_username_bug = no >> rlm_eap: Loaded and initialized type md5 >> rlm_eap: Loaded and initialized type leap >> gtc: challenge = "Password: " >> gtc: auth_type = "PAP" >> rlm_eap: Loaded and initialized type gtc >> mschapv2: with_ntdomain_hack = no >> rlm_eap: Loaded and initialized type mschapv2 >> Module: Instantiated eap (eap) >> Listening on authentication *:1812 >> Listening on accounting *:1813 >> Ready to process requests. > >> - >> List info/subscribe/unsubscribe? See >> http://www.freeradius.org/list/users.html > >

2 1

SQL Counter
by Sean 11 Dec '06

11 Dec '06

Hi, Sorry if this is a repeat. I'm not sure if an email I sent yesterday got through. Clearly I'm missing something simple here. I'm trying to create accounts that will renew on a daily or monthly basis. I've put this code into my radiusd.conf file to test daily renewals. $INCLUDE ${confdir}/sql.conf sqlcounter dailycounter { counter-name = Daily-Session-Time check-name = Max-Daily-Session sqlmod-inst = sql key = User-Name reset = daily query = "SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='%{%k}'" } I've created this account in the MySQL radcheck table. ropgis12 User-Password := gisnopum ropgis12 Simultaneous-Use:= 1 ropgis12 Max-Daily-Session := 1800 radiusd -X gives the following result. rlm_sql (sql): Reserving sql socket id: 0 rlm_sql: Failed to create the pair: Unknown attribute "Max-Daily-Session" rlm_sql (sql): Error getting data from database rlm_sql (sql): SQL query error; rejecting user rlm_sql (sql): Released sql socket id: 0 modcall[authorize]: module "sql" returns fail for request 39 modcall: group authorize returns fail for request 39 I can't understand why Max-Daily-Session is an unknown attribute when it's declared in the radiusd.conf and radius loads with no errors. As usual any help would be appreciated. Sean Bracken

1 0

Counter
by Sean 11 Dec '06

11 Dec '06

Hi, Clearly I'm missing something simple here. I'm trying to create accounts that will renew on a daily or weekly basis. I've put this code into my radiusd.conf file $INCLUDE ${confdir}/sql.conf sqlcounter dailycounter { counter-name = Daily-Session-Time check-name = Max-Daily-Session sqlmod-inst = sql key = User-Name reset = daily query = "SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='%{%k}'" } I've created this account in the MySQL radcheck table. ropgis12 User-Password := gisnopum ropgis12 Simultaneous-Use:= 1 ropgis12 Max-Daily-Session := 1800 radiusd -X gives the following result. rlm_sql (sql): Reserving sql socket id: 0 rlm_sql: Failed to create the pair: Unknown attribute "Max-Daily-Session" rlm_sql (sql): Error getting data from database rlm_sql (sql): SQL query error; rejecting user rlm_sql (sql): Released sql socket id: 0 modcall[authorize]: module "sql" returns fail for request 39 modcall: group authorize returns fail for request 39 I can't understand why Max-Daily-Session is an unknown attribute when it's declared in the radiusd.conf and radius loads with no errors. As usual any help would be appreciated. Sean Bracken

2 1

HELP
by Tomas Eduardo Lotina Ramos 11 Dec '06

11 Dec '06

3 2

How to integrate Postgresql database with freeradius on Debian/Ubuntu
by TAGE 11 Dec '06

11 Dec '06

Hi, I am new to freeradius+postgresql, i am unable to authenticate users from postgresql database. When i execute script : sudo freeradius -XXX -A freeradius do not loaded postgresql modules. There is an incompatibility between freeradius and postgresql for Debian/Ubuntu ? How can i resolv this problem. Errors: Sun Dec 10 23:21:06 2006 : Error: radiusd.conf[11]: sql: Module instantiation failed. Sun Dec 10 23:21:06 2006 : Error: radiusd.conf[1845] Unknown module "sql". Sun Dec 10 23:21:06 2006 : Error: radiusd.conf[1774] Failed to parse authorize section. Kindly help me out. ___________________________________________________________________________ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com

2 1

Backing up Mysql
by Sarkis Gabriel 10 Dec '06

10 Dec '06

Hi all i started backing up the db using a crontab job early in the morning which backs up everything, but i have had complains from users who try to logon after the backup process. What is the best way to backup an active database with radiusd waiting for connection? Thank you Sarky

6 9

confusion in nas topic!!!!!
by rina maharjan 10 Dec '06

10 Dec '06

hello, i configure freeradiusd server and it is working fine. but i really confuse about nas table and its entry. In my radiusd server ,people can login multiple with same username and password.i couldn't made simultaneouse login =1 at a same time for that similar username. i try so much to made this simutaneouse login =1 but i couldn't so i feel that it that a problem of naslist because i get this kind of messege in radiusd log file when i start the rasdiusd server. i attached this radiusd log file with this posting. regards rina freeradius-users-request(a)lists.freeradius.org wrote: Send Freeradius-Users mailing list submissions to freeradius-users(a)lists.freeradius.org To subscribe or unsubscribe via the World Wide Web, visit http://lists.freeradius.org/mailman/listinfo/freeradius-users or, via email, send a message with subject or body 'help' to freeradius-users-request(a)lists.freeradius.org You can reach the person managing the list at freeradius-users-owner(a)lists.freeradius.org When replying, please edit your Subject line so it is more specific than "Re: Contents of Freeradius-Users digest..." Today's Topics: 1. Re: PEAP+MSCHAP+AD (please help) (Phil Mayers) 2. How to pass information between modules? (Martin Gadbois) 3. Re: How to pass information between modules? (Alan DeKok) 4. Re: LDAP->RADIUS Attribute Mapping (Alan DeKok) 5. Re: How to pass information between modules? (Martin Gadbois) 6. Re: Choosing The best replication system. (Sarkis Gabriel) 7. Re: TTLS : where to indicate User/Password ? (Bruno Costacurta) ---------------------------------------------------------------------- Message: 1 Date: Fri, 08 Dec 2006 18:31:37 +0000 From: Phil Mayers Subject: Re: PEAP+MSCHAP+AD (please help) To: FreeRadius users mailing list Message-ID: <4579AF89.3010307(a)imperial.ac.uk> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Hector.Ortiz(a)swisscom.com wrote: > Hi there, this is an old issue, but AFAIAC hasn't been solved yet, that's why I'm asking for help with this problem which is driving me crazy. > > > In the first attempt the user has checked the option "Automatically use my Windows logon name and password (and domain if any)", user account is valid in the domain and is not locked out, however user authentication fails. > > In the next attempt the user has unchecked this option, so everytime he connects to the network he has to type his credentials in. After clicking "Connect" he gets access. > > Why if Windows sends the same user information only in the latter case user is able to get in? > > Exec-Program: /opt/samba/bin/ntlm_auth --request-nt-key --domain=DOMAIN --username=testuser --challenge=c61ad7019723b68d --nt-response=70fb1b0438208667d0bac6eb895ea8644b413566785d5785 > Exec-Program output: Logon failure (0xc000006d) > Exec-Program-Wait: plaintext: Logon failure (0xc000006d) > Exec-Program: returned: 1 > rlm_mschap: External script failed. > rlm_mschap: FAILED: MS-CHAP2-Response is incorrect > modcall[authenticate]: module "mschap" returns reject for request 7 It failed because the client returned the wrong challenge > Exec-Program: /opt/samba/bin/ntlm_auth --request-nt-key --domain=DOMAIN --username=testuser --challenge=aea3ef9fe78f8ac2 --nt-response=8c6a735e29ed7cddb8c02ae601424aca79d115544324731d > Exec-Program output: NT_KEY: 12047FA4AC9D0AA0F53475F2FA2D03AF > Exec-Program-Wait: plaintext: NT_KEY: 12047FA4AC9D0AA0F53475F2FA2D03AF > Exec-Program: returned: 0 > modcall[authenticate]: module "mschap" returns ok for request 16 > modcall: leaving group MS-CHAP (returns ok) for request 16 > MSCHAP Success Whereas that worked. It looks to me as if you've edited the debug output so I can't be sure, but I'd suggest looking at the client - the radius server is configured correctly. Perhaps the client is not in fact logging on to the laptop with the correct username and password. ------------------------------ Message: 2 Date: Fri, 08 Dec 2006 14:02:36 -0500 From: Martin Gadbois Subject: How to pass information between modules? To: FreeRadius users mailing list Message-ID: <4579B6CC.5010406(a)colubris.com> Content-Type: text/plain; charset=UTF-8 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi! Let's say I have the following authorize {} section: authorize { ldap sql } What would be the best way to pass information between ldap and sql? For example, if I were to extract a group name from "ldap" and pass it to "sql" to get all the RADIUS attributes associated to this group, what would be the strategy to acheive that? In other words, how to configure those modules if the "ldap" contains the group info, but "sql" the actual RADIUS attribute per group? Thanks! - -- ============== +----------------------------------------------+ Martin Gadbois | "Windows might take you from 0 to 60 faster, | S/W Developer | but to go to 100 you need Unix." | Colubris Networks Inc. +----------------------------------------------+ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFFebbM9Y3/iTTCEDkRAlbtAJ9xef4aCw0IGd5SIJXXn7UxLtUwEACZAf/e hPg7eJ53Xt+PgxSYPpFecPM= =K9c0 -----END PGP SIGNATURE----- ------------------------------ Message: 3 Date: Fri, 08 Dec 2006 11:11:27 -0800 From: Alan DeKok Subject: Re: How to pass information between modules? To: FreeRadius users mailing list Message-ID: <4579B8DF.6030008(a)deployingradius.com> Content-Type: text/plain; charset=UTF-8 Martin Gadbois wrote: > What would be the best way to pass information between ldap and sql? In the same way that all of the other modules do it: Put the information into attributes. That's what the "config item" list is for. > For example, if I were to extract a group name from "ldap" and pass it > to "sql" to get all the RADIUS attributes associated to this group, what > would be the strategy to acheive that? Put it into an attribute in the config items. > In other words, how to configure those modules if the "ldap" contains > the group info, but "sql" the actual RADIUS attribute per group? You can use the "LDAP-Group" attribute, see the rlm_ldap documentation. Alan DeKok. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog ------------------------------ Message: 4 Date: Fri, 08 Dec 2006 11:21:59 -0800 From: Alan DeKok Subject: Re: LDAP->RADIUS Attribute Mapping To: FreeRadius users mailing list Message-ID: <4579BB57.5040504(a)deployingradius.com> Content-Type: text/plain; charset=ISO-8859-1 Owen DeLong wrote: > We have historically used the AuthorizedService attribute in LDAP to > control the level > of access available to the user. We would like to continue to do so. > However, in order > for that to work, I need to map AuthorizedService to different RADIUS > attributes in > the response depending on the authentication client. Do it in two steps. Map the AuthorisedService LDAP attribute to a RADIUS attribute (invent a local one, see the dictionary docs), and then depending on the NAS, map that to another attribute. The reason for doing it this way is that the LDAP -> RADIUS attribute mapping is simple, and should be kept simple. > Ideally, I'd like to be able to map RADIUS clients into "groups" and > have a mapping > of AuthorizedService values for each group. The client groups would, > ideally, > be defined by matching the client IP address. An example of what I'd > like that > mapping to look like is below: Use rlm_passwd to map clients to groups (see it's documentation), and then the "users" file to map AuthorizedService to another RADIUS attribute, as described above. > Alan, your flames and RTFM comments are welcome, but, please understand, > I've done my best to RTFM before posting this. As I tell my co-workers, "Remember, there are no stupid questions. There are only stupid people.". And they still speak to me after that. :) Alan DeKok. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog ------------------------------ Message: 5 Date: Fri, 08 Dec 2006 15:41:28 -0500 From: Martin Gadbois Subject: Re: How to pass information between modules? To: FreeRadius users mailing list Message-ID: <4579CDF8.5090207(a)colubris.com> Content-Type: text/plain; charset=UTF-8 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Alan DeKok wrote: >> What would be the best way to pass information between ldap and sql? > > In the same way that all of the other modules do it: Put the > information into attributes. That's what the "config item" list is for. My subconscious FreeRADIUS mind was saying that as well; but how to use config items and what makes them different from RADIUS Reply attributes? An theoritical example: modules { file users { ... } file groups { ... } } authorized { users groups } file users: martin User-Password == "gadbois" Group = "staff" file groups: DEFAULT Group == "staff" Reply-Message = "Hello Staff!" I expect this to set "martin" into the "staff" group, and a RADIUS request returns Reply-Message "Hello Staff!!" This does not work: [/etc/raddb/users]:223 WARNING! Check item "Group" ?found in reply item list for user "martin". ?This attribute MUST go on the first line with the other check items Some explaination, a C function or a URL would greatly help! > >> In other words, how to configure those modules if the "ldap" contains >> the group info, but "sql" the actual RADIUS attribute per group? > > You can use the "LDAP-Group" attribute, see the rlm_ldap documentation. I got it now; LDAP-Group is like a callback into the "ldap" module, where the LDAP group is going to be checked to the value. I'll go update the FR LDAP Wiki.. ;-) Thanks Alan for the quick reply. - -- ============== +----------------------------------------------+ Martin Gadbois | "Windows might take you from 0 to 60 faster, | S/W Developer | but to go to 100 you need Unix." | Colubris Networks Inc. +----------------------------------------------+ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFFec349Y3/iTTCEDkRAsgfAJ45vsoHrRKwsPkITrUBuPsFgbGBXACgm1yU gjlFYOPYrcMsN80odSYfAWA= =6TFA -----END PGP SIGNATURE----- ------------------------------ Message: 6 Date: Fri, 8 Dec 2006 22:53:07 +0100 From: "Sarkis Gabriel" Subject: Re: Choosing The best replication system. To: FreeRadius users mailing list Message-ID: <20061208215219.M71831(a)raycon.net> Content-Type: text/plain; charset=iso-8859-1 Anyone out there with some guide or atleast some pitfalls i should try and avoid on Replicating the radius server ? Sarky ---------- Original Message ----------- From: "Sarkis Gabriel" To: FreeRadius users mailing list Sent: Thu, 7 Dec 2006 17:29:22 +0100 Subject: Choosing The best replication system. > Hello all, > > With the way work is and the pops are growing looks like i need to start > centralising the database. > > At the moment i have 4 pops around the country and all are feeding from a > satellite links, as the company is growing it is becoming very hard to > maintain and we are looking to have a central MySQL DB in the UK which feeds > the slave machines with the updated info. > > Each pop will have a live radius / mysql db feeding info back to a master > machine in the UK and that would replicate the info down to the slaves on the > other pops, this is the wishfull thinking i have :). > > I have read about Replication with MySQL (One-Way) and radrelay, then i > noticed there is rlm_slq_log and radsqlrelay. > > One thing I must mention there is a lot of LAG on satellite connection looking > at approx 650ms and because of BW cost we do rely on proxies which makes BW > usage during the day very expensive, so i would like to be able to replicate > maybe once a night lets say at midnight being less busy and cheaper. > > Any one out there with some ideas they can send my way.. > > Thanks > > Sarky > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html ------- End of Original Message ------- ------------------------------ Message: 7 Date: Sat, 9 Dec 2006 00:12:01 +0100 From: Bruno Costacurta Subject: Re: TTLS : where to indicate User/Password ? To: FreeRadius users mailing list Message-ID: <200612090012.01376.pubmb01(a)skynet.be> Content-Type: text/plain; charset="iso-8859-1" On Monday 04 December 2006 22:21, Alan DeKok wrote: > Bruno Costacurta wrote: > > I'm trying to configure FreeRadius using TTLS (certificate on server side > > only) and MySQL. Client is a Linux laptop using wpa_supplicant. > > I'm in a learning curve regarding 802.1x and FreeRadius and especially > > TTLS. > > That should work without too much effort. > > > Questions: > > - TTLS available authentications are: CHAP,PAP,MS-CHAP,EAP (correct ?) > > Yes. > > > - 'Auth-Type=local' means CHAP,PAP and MS-CHAP (correct ?) > > No, just CHAP and PAP. You shouldn't be using it at all. > > > - for the learning curve : > > --- which is the easiest authentications to start with ? > > PAP. > > > --- MySQL will be removed at the first stage to ease debugging / setup of > > the config (good idea ?) > > Yes. > > Alan DeKok. > -- > http://deployingradius.com - The web site of the book > http://deployingradius.com/blog/ - The blog > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html Dear Alan, thanks for your answers. Indeed starting from a fresh FreeRadius install, following instructions http://deployingradius.com/documents/configuration/ I'm now able to authenticate via TTLS. Thanks again for attention. Bye, Bruno ------------------------------ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html End of Freeradius-Users Digest, Vol 20, Issue 29 ************************************************ --------------------------------- Access over 1 million songs - Yahoo! Music Unlimited.

2 1

HELP
by Tomas Eduardo Lotina Ramos 09 Dec '06

09 Dec '06

1 0

route_by_callerid
by Pezhman Lali 09 Dec '06

09 Dec '06

Dear I have a cisco2600,voice enabled, with freeradius, for accounting. some of my customers,always dial a same International number . let me know how cisco accepts CALLED-STATION-ID that was sended by radius server. thanks a lot Best Pezhman ____________________________________________________________________________________ Have a burning question? Go to www.Answers.yahoo.com and get answers from real people who know.

1 0