March 2007 - Freeradius-Users - lists.freeradius.org

sql_counter
by Pierluigi Di Lorenzo 12 Mar '07

12 Mar '07

Hi all, somebody knows how to pass external variables to sql_counter modules? and especially CallingStationId? I'd like to pass macaddress of pc makes the request. Thank's in advance, ciao! -- Pierluigi Di Lorenzo ePrometeus s.r.l

2 1

sqlippool.conf in mysql format
by MSamir 11 Mar '07

11 Mar '07

dear all, i try find sqlippool.conf in mysql format it try http://wiki.freeradius.org/Talk:Rlm_sqlippool but it's not work with me this is what i see in debug ============================ Processing the post-auth section of radiusd.conf modcall: entering group post-auth for request 0 Value Of the Pool-Name is [sqlippool] and its [9] Chars rlm_sql (sql): Reserving sql socket id: 2 radius_xlat: 'BEGIN' rlm_sql_mysql: query: BEGIN radius_xlat: 'UPDATE radippool SET nasipaddress = '', pool_key = 0, callingstationid = '', expiry_time = 'now'::timestamp(0) - '1 second'::interval WHERE pool_key = ''' rlm_sql_mysql: query: UPDATE radippool SET nasipaddress = '', pool_key = 0, callingstationid = '', expiry_time = 'now'::timestamp(0) - '1 second'::interval WHERE pool_key = '' rlm_sql_mysql: MYSQL check_error: 1064 received sqlippool_command: database query error radius_xlat: 'SELECT framedipaddress FROM radippool WHERE pool_name = '' AND expiry_time < 'now'::timestamp(0) ORDER BY pool_name, (username <> 'test1'), (callingstationid <> ''), expiry_time LIMIT 1 FOR UPDATE' rlm_sql_mysql: query: SELECT framedipaddress FROM radippool WHERE pool_name = '' AND expiry_time < 'now'::timestamp(0) ORDER BY pool_name, (username <> 'test1'), (callingstationid <> ''), expiry_time LIMIT 1 FOR UPDATE rlm_sql_mysql: MYSQL check_error: 1064 received sqlippool_query1: database query error rlm_sqlippool: ip=[] len=0 radius_xlat: 'COMMIT' rlm_sql_mysql: query: COMMIT rlm_sqlippool: IP number could not be allocated. rlm_sql (sql): Released sql socket id: 2 modcall[post-auth]: module "sqlippool" returns notfound for request 0 =================================================== thanks --------------------------------- Food fight? Enjoy some healthy debate in the Yahoo! Answers Food & Drink Q&A.

1 0

Freeradius on ubuntu
by adreas Polyxronopoulos 11 Mar '07

11 Mar '07

Hi list, I have tried ubuntu 6.10 desktop with freeradius1.1.3 source and everything work perfect. Now i have installed on another PC ubuntu 6.06 server LAMP and i am in the moment where the freeradius should be installed. I can download the source of freeradius and compile it or i can download the package of freeradius. The package version is 1.1.0 but for the source of freeradius i can choose any version i want (i would choose freeradius 1.1.3 source because i have tested). Which one is better choice ? thanks Adreas Polyxronopoulos ___________________________________________________________ Inbox full of unwanted email? Get leading protection and 1GB storage with All New Yahoo! Mail. http://uk.docs.yahoo.com/nowyoucan.html

2 1

checkrad snmp error
by satish patel 11 Mar '07

11 Mar '07

I have getting this error when i run manualy checkrad [root@radius mibs]# checkrad cisco 192.168.1.1 766 mlpm264 0000BC3F SNMP Error: Received SNMP response with error code error status: noSuchName index 1 (OID: 1.3.6.1.4.1.9.2.9.2.1.18.766) SNMPv1_Session (remote host: "192.168.1.1" [192.168.1.1].161) community: "public" request ID: -422345818 PDU bufsize: 8000 bytes timeout: 2s retries: 5 backoff: 1) at /usr/local/sbin/checkrad line 221 checkrad: No SNMP answer from cisco. [root@radius mibs]# and i got this error when i check log No SNMP answer from cisco. user at port S766: snpwalk: /usr/bin/snmpwalk -r 1 -t 5 -v2c -c 'public' 192.168.1.1 .iso.org.dod.internet.private.enterprises.9.10.19.1.3.1.1.3 Returning 0 (login ok) Sun Mar 11 15:35:15 2007 checkrad cisco 192.168.1.1 766 mlpm264 0000BC3F No SNMP answer from cisco. user at port S766: snpwalk: /usr/bin/snmpwalk -r 1 -t 5 -v2c -c 'public' 192.168.1.1 .iso.org.dod.internet.private.enterprises.9.10.19.1.3.1.1.3 Returning 0 (login ok) [root@radius mibs]# what is this how can i checkrad use with snmp i have enable SNMP on cisco router $ cat ~/satish/url.txt System administrator ( Data Center ) please visit this site http://linux.tulipit.com --------------------------------- Heres a new way to find what you're looking for - Yahoo! Answers

2 1

freeradius simultenoues-use error
by satish patel 11 Mar '07

11 Mar '07

Dear all i fedup from this problem i dont know how to resolve it no one help me out from this problem i have freradius-1.1.4 + MSSQL setup user databases and accouting done by mssql and my NAS is cisco router with VPDN configuration but i have faceing some problem since last week suposse one user login in to cisco router and he/she accouting start on MSSQL server i am useting simultenouse-use feature in SQL example radacct tables User AcctStartTime AcctStopTime abc 08/03/2007:01:30 1/1/1900 Now user can access internet and anything everything going fine but after when i stop radiusd proccess and start it my user disconnected and he/she try for login in to cisco VPDN he/she got error access deny and i got some log multiple user login Thu Mar 8 20:12:05 2007 : Auth: Multiple logins (max 1) : [mlpm484/<CHAP-Password>] (from client cisco port 974) Thu Mar 8 20:12:08 2007 : Auth: Multiple logins (max 1) : [mlpm629/<CHAP-Password>] (from client cisco port 1111) Thu Mar 8 20:12:10 2007 : Auth: Multiple logins (max 1) : [mlpm484/<CHAP-Password>] (from client cisco port 460) Thu Mar 8 20:12:14 2007 : Auth: Multiple logins (max 1) : SomeThing like this it means in MSSQL AcctStopTime there is i still user login means that entry is not still clear thats why i got error 'Multiple logins (max 1)' in my client.conf file NAStype is "other" caz when i user cisco nastype my Simulteneous-use not working ?? so i thing this detail enough for help plz tell me right suggesstion if i am wrong .... $ cat ~/satish/url.txt System administrator ( Data Center ) please visit this site http://linux.tulipit.com --------------------------------- Heres a new way to find what you're looking for - Yahoo! Answers

5 11

Digest before authorize_check_query
by Dariusz Dwornikowski 10 Mar '07

10 Mar '07

Hi, I am using freeradius 1.1.4 with postgresql. My question is howto force digest to extract attributes from Digest-Attributes, before the authorize_check_query is run. I am using this to authenticate openser users. Similar problem was on this list but noone responded :) http://www.mail-archive.com/freeradius-users@lists.freeradius.org/ msg27755.html Thanks in advance Dariusz Dwornikowski tdi(a)vercom.pl

1 1

Correction of Reply Messages
by PD 09 Mar '07

09 Mar '07

Dear all, Sorry for cross post... since I doubt about which area of this question. I just create one account call test for duration 300 second / 5 minutes. After the maximum time reached, I logged by the system out. When I try to log in again, the reply message display is "Your maximum never usage time has been reached" Seems that I have some correction for the message (take out never), but I do not know how to do it. Can some one let me know where to edit the above reply message ? TIA PD

1 0

checkval guide
by Antuan Avdioukhine 09 Mar '07

09 Mar '07

Is there any detailed documentation on checkval using? URLs are ok ;) -- Antuan Avdioukhine (DEKA-RIPE). Convey Plus Telecommunications St.Petersburg, Russia.

2 1

sqlcounter & reauthentication flag
by Jan Lausch 09 Mar '07

09 Mar '07

Hi, I just heard about a so-called "reauthentication flag". Has this something to do with the sqlcounter-module? Could I use this flag to logout the clients automatically after their login expires instead of using the sqlcounter module (as I do not get a self-compiled fr running properly)? How would I have to use it, is there some documentation somewhere? If I use neither sqlcounter nor this flag, do I understand correct, that the clients would not be logged off automatically after their login expires? But they could not login again after expiration? Thanks for this hint, Jan

1 0

problems with vpn
by Marilene Lima 09 Mar '07

09 Mar '07

Hi, I am with a big problem. I configured the freeradius and mysql with linux debian. When I use the radtest, I receive a sucess message: # radtest joao senhasecreta 10.0.164.71 1812 radius_secret Sending Access-Request of id 69 to 10.0.164.71:1812 User-Name = "joao" User-Password = "senhasecreta" NAS-IP-Address = wireless6e NAS-Port = 1812 rad_recv: Access-Accept packet from host 10.0.164.71:1812, id=69, length=20 wireless6e:~# But, when I try to access from a client windows, through a vpn, the freeradius not respond. I configured the vpn server with the ip of vpn server. Thanks a lot, Marilene

2 1