August 2005 - Freeradius-Users - lists.freeradius.org

iptables rules from freeradius...
by tbsky＠annsky.us 09 Aug '05

09 Aug '05

Hi: i am using freeradius as wireless authenticator. windows xp client is using wpa + peap. and authentication through wireless ap is ok. now i want to setup some iptables rules for authenticated users. i wonder if this can be done via freeradius. can i find out the mac address or ip address information for authenticated users? can i run iptables scripts when a user authenticated successfully ? since ip address is offered by dhcp server after authenticated, i think it's difficult to get this info from freeradius. maybe there are better ways to implement what i want? thanks for reply !!! Best Regards, tbsky

2 3

OK, further along. Can radtest test my ntlm_auth?
by Derrick MacPherson 09 Aug '05

09 Aug '05

I'm wondering if I can use radtest to authenticate to my w2k server? If so whats the syntax? I've tested local and it works, I want to test the ntlm_auth. The syntax that I am using for the ntlm_auth = should work, it works from the cli.

1 0

Hi. Windows RADIUS server died.
by Derrick MacPherson 09 Aug '05

09 Aug '05

I just got asked to try and get a freeradius server running ASAP. I got it installed on a freebsd 5.4 box that I had just finished getting squid running on, not implemented yet still testing. I see freeradius can use ntlm_auth as well, though I'm not clear on it's syntax. I have squid using the same authentication criteria as the radius server was using, that was based upon being in certain group. Can freeradius support this as well? My syntax in squid: ntlm_auth --helper-protocol=squid-2.5-ntlmssp --require-membership -of=S-1-5-21-1058564242-1277044956-825688854-1337 Domain Group (2) Can someone save me with a quick example or am I off to read and google?

2 6

problem with using rlm_sql for accounting only
by John Donagher 09 Aug '05

09 Aug '05

Hi all- I've recently deployed freeradius at my employer to replace our old radius server which lacked native LDAP support which we've moved to for authentication and authorization. Thanks for a great application. I have one problem: I've configured freeradius to send accounting data to an SQL database for ease of reporting. It works fine, with one exception, which after extensive googling I don't find anyone else complaining about. If the SQL server is inaccessible (i.e. down, or locked), freeradius rejects all radius requests. In my case, since the SQL database is being used only for accounting, this is not desired behavior. I can see how it may have been to the designer given that rlm_sql can be used for auth. So my question is that: is that behavior by design, or is it due to some misconfiguration on my part? I figured I'd start with a simple question before I post configs/logging output. Thanks John

3 5

sql.conf (update query)
by Michel Bélanger 09 Aug '05

09 Aug '05

Hi, I try to add an additional query in the query update in sql.conf. This is possible to make it ? Here what I have test: accounting_update_query = "UPDATE ${acct_table1} \ 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}'; INSERT into radtempo (AcctInputOctets, AcctOutputOctets, AcctSessionId) values('%{Ac ct-Input-Octets}', '%{Acct-Output-Octets}', '%{Acct-Session-Id}')" rlm_sql_mysql: MYSQL check_error: 1064 received rlm_sql (sql): Couldn't update SQL accounting ALIVE record - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; INSERT into radtempo (AcctInputOctets, AcctOutputOctets, AcctSessionId) values' at line 1 -- ------------------------------------------------------------ Michel Bélanger

1 0

FreeRadius EAP-TLS quesitons
by Hamid Salim 09 Aug '05

09 Aug '05

Hello, Two part question: 1. Is it critical to have certificates, dh and random files in etc/raddb/certs directory for eap-tls to work. 2. Is it ok to generate random file as date > random thanks a lot. Hamid.

2 1

Newbie: General Questions About Installation
by Waylock WISP 09 Aug '05

09 Aug '05

I'm attempting to get my hands around installing FreeRadius-1.0.4 on a Debian Linux machine while also trying learn Linux better. I've been reading through all the various documentation, but had a few general questions that I was hoping someone would be so kind to reply on. 1. All the docs show installation starting with the tar file, but no one really specifies what directory to begin from. Should I create a new user "raduser" and copy the tar file into /home/raduser or is there somewhere else that is the proper place to begin? 2. After I installed this all (in /home/raduser), is there a quick test to see if the basic functionality works properly? I read the /doc/performance&testing but reached a problem while going through the process because I couldn't find or run the /user/local/sbin/radiusd There are zero files in the /user/local/sbin directory. If it would be helpful for me to post snippets of certain log files, please let me know which ones and what parts and I'll do it. Thank you! -Chad

8 9

rlm_ldap: Attribute "User-Password" is required for authentication
by melvin 09 Aug '05

09 Aug '05

Hi all, Currently I need to use ldap to authenticate my users and I keep encountering the same problem "rlm_ldap: Attribute "User-Password" is required for authentication". I have tried adding "checkItem User-Password userPassword" into ldap.attrmap but it still doesn't work. Anyone have any ideas how I can enable radius to authenticate thru ldap? rlm_ldap: - authenticate rlm_ldap: Attribute "User-Password" is required for authentication. modcall[authenticate]: module "ldap" returns invalid for request 0 modcall: group Auth-Type returns invalid for request 0 auth: Failed to validate the user. cheers, melvin

4 12

problems with mac address authentication
by robin rapa 09 Aug '05

09 Aug '05

I have linux fedora 3 and one lan wifi. I need to install a server freeradius for mac address authentication (only, without certificates). You can help me to configure the server Thank you _________________________________________________________________ ¿Estás pensando en cambiar de coche? Todas los modelos de serie y extras en MSN Motor. http://motor.msn.es/researchcentre/

1 0

unixodbc: Query sending problem
by Mykhaylo Tyulchenko 09 Aug '05

09 Aug '05

Hi, I'm having some problem with sending SQL query to MSSQL 7.0 Server through UnixODBC driver of FreeRadius (module rlm_sql_unixodbc) with error: rlm_sql_unixodbc: ' [unixODBC][FreeTDS][SQL Server]Unclosed quotation mark before the character string ''.' My SQL query is a stored procedure executed on MSSQL server with some parameters: exec sp_authenticate 'setup','123456',null,0,'255.255.255.255','L3',2 FreeTDS and UnixODBC configured fine, so i have normal MSSQL server execution of that query testing by tsql and isql programms. But when i try to use that query as Authorization Query in mssql.conf i get next screen: radius_xlat: 'exec sp_authenticate 'setup','123456',null,0,'255.255.255.255','L3',2' rlm_sql (sql): Reserving sql socket id: 4 query: exec sp_authenticate 'setup','123456',null,0,'255.255.255.255','L3',2 radius_xlat: '' radius_xlat: 'exec sp_authenticate '' query: exec sp_authenticate ' rlm_sql_unixodbc: ' [unixODBC][FreeTDS][SQL Server]Unclosed quotation mark before the character string ''.' rlm_sql_getvpdata: database query error radius_xlat: '' rlm_sql (sql): Released sql socket id: 4 modcall[authorize]: module "sql" returns ok for request 0 modcall: group authorize returns ok for request 0 Please help. FreeRadius 1.0.4, UnixODBC 2.2.11, MSSQL 7.0 Regards, Mykhaylo Tyulchenko

1 0