- Freeradius-Users - lists.freeradius.org

requiring a sample of a mysql radius database
by liran tal 12 Mar '07

12 Mar '07

Hey everyone, I'm working on a new radius control panel in php and for the sake of working with actual records I need some "real" data to fill my radacct table as well as my radreply and others. Ofcourse those tables are including passwords and other private stuff so I'm not talking about a dump of the radius database from your production systems :) So if you have any test systems I would love it if you could attach a dump of the radius database. Thanks guys.

3 3

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 10 Mar '07

10 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 10 Mar '07

10 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 10 Mar '07

10 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