- Freeradius-Users - lists.freeradius.org

radwho radzap problem
by Oguzhan Kayhan 16 Jan '08

16 Jan '08

Hello, I am using rlm_perl script for authentication. And logging radacct in sql. But it is strange that, i couldnt use radwho radzap radlast etc for a while.. had the error "file not found" etc.. So i manually created the files with touch. Now i can see theres records inside files, but still i cant see any data with radwho or radlast commands. And also, i can not zap staled sessions too with radzap, even i tried to clean sql log with a cleanstale.php script , some of my users still seem online. I am attaching the radiusd.conf file and i wonder if smbody can help me about this situation. Thanks a lot.

2 2

Freeradius is unable to connect to Oracle Server through an Oracle client
by Ripunjay 16 Jan '08

16 Jan '08

Hi, I have installed Oracle Client on a Linux Machine. Then I installed FreeRadius-1.1.4 Server on the same machine.I could succesfully create rlm_sql drivers for oracle. But even after supplying correct remote DB info in oraclesql.conf and sql.conf freeradius server is unable to connect to remote DB. There is some error that pops up on console - reads like : Could not resolve TNS name Plz help -- View this message in context: http://www.nabble.com/Freeradius-is-unable-to-connect-to-Oracle-Server-thro… Sent from the FreeRadius - User mailing list archive at Nabble.com.

2 1

radsqlrelay v1.7 on freebsd 6.3
by roy 16 Jan '08

16 Jan '08

Apologies for cross-posting. Just wondering if anyone else was able to run radsqlrelay successfully on FBSD 6.3. I've ran into file lock issue right after I've tried running the pl script: # ls -al total 8 drwxr-xr-x 3 root wheel 512 Jan 14 13:39 . drwxr-xr-x 5 root wheel 512 Jan 14 11:42 .. drwxr-xr-x 2 root wheel 512 Jan 14 11:49 127.0.0.1 -rw-r--r-- 1 root wheel 51 Jan 14 11:49 sql-relay # radsqlrelay -b radius -d pg -h 172.16.10.100 -u postgres /home/radius/sql-relay error: Couldn't lock /home/radius/sql-relay.work: Invalid argument # ls -al total 8 drwxr-xr-x 3 root wheel 512 Jan 14 13:39 . drwxr-xr-x 5 root wheel 512 Jan 14 11:42 .. drwxr-xr-x 2 root wheel 512 Jan 14 11:49 127.0.0.1 -rw-r--r-- 1 root wheel 51 Jan 14 11:49 sql-relay.work Inspecting radsqlrelay shows the following lines: # /!\ OS-dependent structure # Linux struct flock # short l_type; # short l_whence; # off_t l_start; # off_t l_len; # pid_t l_pid; # c2ph says: typedef='s2 l2 i', sizeof=16 my $FLOCK_STRUCT = 's2l2i'; Application versions that are being used: FreeBSD 6.3-PRERELEASE p5-DBD-Pg-1.49 p5-DBI-1.60.1 postgresql-client-8.1.11 freeradius-devel-2.0.0.p2 radsqlrelay v1.7 I'm no real coder myself, hence, the need to seek direction. Any necessary change on the script that I need to make? Thanks again, roy

2 4

eap-mschapv2
by Indira Keesara 16 Jan '08

16 Jan '08

I am using freeradius to test the eap-mschapv2. According to specs To the access-challenge reply radius should sent a access-success with the mppe keys. But what I see is to the reply radius is sending the access-challenge request again with mschap-success similar to the Eap-tls. I am not sure if I missed any configuration.

4 6

RE: Help Needed Please freeradius traffic limiting
by hamid benane 16 Jan '08

16 Jan '08

hello, i need help to authenticate win-xp client throw cisco3560 on freeradius-1.1.1. i use EAP-PEAP and my certificate is good. on wireless its work nice but not on lan wired area. i try tou authenticate user with simple password thanks _________________________________________________________________

2 1

eap-mschapv2
by Indira Keesara 15 Jan '08

15 Jan '08

Does freeradius support eap-mschapv2 ?

2 2

Help Needed Please freeradius traffic limiting
by Keith Dovale 15 Jan '08

15 Jan '08

FFs, Lol Hi List, Ok I need to do this and if someone could help I would appreciate it as I am new to this 1. I Need to limit users by traffic and NOT session time (I setup the monthly counters to check but the counters cannot go beyond 2,148,000,000 and they fail I think this is due to the counters using the type as integer. If I can get this value to go beyond this this then sorts out my problem based on traffic.) 2. I need to execute a query to check the clients total traffic usage and compare it to their limit, if they have gone beyond their limit I need to be able to execute a disconnect. (The disconnect side I have got working manually, so if there is a way to trigger / execute a program on a interim update which will force a discon that will help, else if this can be done another way please let me know. 3. Any recommendations on how to go about the above issues which will do this in an easier way please let me know. Regards Keith Dovale <http://www.hostworx.co.za/> LogoNBG

1 0

Freeradius-client in pppd
by Damjan 15 Jan '08

15 Jan '08

I need the feature to specify the local ip address for the radius requests in PPPd and I see that freeradius-client-1.1.5 has that feature. Is there any patch to make pppd use this radius client instead of it's own copy of the old radiusclient? -- damjan | дамјан This is my jabber ID --> damjan(a)bagra.net.mk -- not my mail address, it's a Jabber ID --^ :)

3 6

Switch from Static IP to IPpool
by Grant Wright 15 Jan '08

15 Jan '08

Hi there Just a question, is this scenario possible from within freeRADIUS or should I just write a script to achieve it. I basically assign the connecting client a static IP address using the Framed-IP-Address attribute. Once he has reached his threshold (Receive-Limit) and gets disconnected I would like to assign him an IP out of a pool. Is there a fall back option within freeRadius that supports this type of query? Thanks

2 1

Mysql error
by Pablo Lucchetti 15 Jan '08

15 Jan '08

Hi, I'm working with Freeradius in production enviroment (start up), at this time is working with only two users, they can connect whitout problems and all seems to work fine but looking into radius.log i found this messages: radius:/usr/local/var/log/radius# tail radius.log -f Mon Jan 14 16:01:37 2008 : Error: rlm_sql (sql): Couldn't insert SQL accounting ALIVE record - Unknown column 'XAscendSessionSvrKey' in 'field list' Mon Jan 14 16:01:37 2008 : Error: rlm_sql_mysql: Cannot store result Mon Jan 14 16:01:37 2008 : Error: rlm_sql_mysql: MySQL error 'Unknown column 'XAscendSessionSvrKey' in 'field list'' Mon Jan 14 16:01:37 2008 : Error: rlm_sql_mysql: Cannot store result Mon Jan 14 16:01:37 2008 : Error: rlm_sql_mysql: MySQL error 'Unknown column 'XAscendSessionSvrKey' in 'field list'' Mon Jan 14 16:01:38 2008 : Error: rlm_sql (sql): Couldn't insert SQL accounting ALIVE record - Unknown column 'XAscendSessionSvrKey' in 'field list' Mon Jan 14 16:01:38 2008 : Error: rlm_sql_mysql: Cannot store result Mon Jan 14 16:01:38 2008 : Error: rlm_sql_mysql: MySQL error 'Unknown column 'XAscendSessionSvrKey' in 'field list'' Mon Jan 14 16:01:38 2008 : Error: rlm_sql_mysql: Cannot store result Mon Jan 14 16:01:38 2008 : Error: rlm_sql_mysql: MySQL error 'Unknown column 'XAscendSessionSvrKey' in 'field list'' Any help please? Thanks in advance, Pablo

3 6