RE: accouting detail

2008-04-17 Thread Guillaume Chartrand
age = 0x03e50004 Message-Authenticator = 0x User-Name = "guillaume" Finished request 9. I didn't copy all the debug output because with just one request he made about 1000 lines. If you want all the debug output, I can send it in attached file. Thank ---

accouting detail

2008-04-17 Thread Guillaume Chartrand
esn't send accounting packet? For my testing purpose I use a sample D-Link router. Thanks Guillaume Chartrand Technicien informatique Cégep régional de Lanaudière Centre administratif, Repentigny (450) 470-0911 poste 7218 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

RE: SQL log accounting and post_auth

2008-04-17 Thread Guillaume Chartrand
>Hi, >> And change the insert line with this line >> postauth_query = "INSERT INTO ${postauth_table} (username, pass, reply) >> VALUES >> ('%{User-Name}','%{%{User-Password}:-%{Chap-Password}}','%{reply:Packet- >> Type}')" >yes. but do you REALLY want to log peoples passwords into a nice >databa

RE: SQL log accounting and post_auth

2008-04-16 Thread Guillaume Chartrand
I re and reread man unlang And change the insert line with this line postauth_query = "INSERT INTO ${postauth_table} (username, pass, reply) VALUES ('%{User-Name}','%{%{User-Password}:-%{Chap-Password}}','%{reply:Packet- Type}')" It's the value chap-password who's corrected. So for the fix, plea

RE: SQL log accounting and post_auth

2008-04-16 Thread Guillaume Chartrand
>Hi, >> So for this, now it's working. But I have nothing in radacct table and even if I only keep the sql_log in the >>accounting section, i have nothing in my sql-relay file. >to get the sql-relay file you will need to call sql_log in the accounting >stanza and ensure that the sql_log is confi

RE: SQL log accounting and post_auth

2008-04-16 Thread Guillaume Chartrand
sql in accouting section and leave uncomment sql_log but I have nothing in sql-relay file >which version of FR are you running? >ideally you'd be with 2.x and then just activate the buffered-sql virtual >server I run 2.0.3 Guillaume Chartrand Technicie

SQL log accounting and post_auth

2008-04-16 Thread Guillaume Chartrand
Hi, I want to log accounting information and post-auth information in my sql database. I have an MSSQL database. In my accounting section I uncomment sql and sql_log. In post_auth section I uncomment sql and sql_log too. Here is the result I receive with debug mode Login OK: [guillaume\000/] (fr

SQL Fall-Through

2008-04-04 Thread Guillaume Chartrand
ing type peap rlm_eap_peap: Authenticate rlm_eap_tls: processing TLS eaptls_verify returned 7 rlm_eap_tls: Done initial handshake eaptls_process returned 7 rlm_eap_peap: EAPTLS_OK rlm_eap_peap: Session established. Decoding tunneled attributes. rlm_eap_peap: Received EAP-TLV response. rlm_eap

RE: Authorize with SQL and/or AD with ntlm_auth !!!SOLVED!!!

2008-04-04 Thread Guillaume Chartrand
>> If in the radius.conf mschap section module I insert the same ntlm_auth >> line of the exec. The sql don’t work but AD work. If I put nothing in >> mschap section. The SQL works but not AD. So what I did make wrong > 1) Do not create your own "ntlm_auth" module. > 2) configure ntlm_auth in t

Authorize with SQL and/or AD with ntlm_auth

2008-04-03 Thread Guillaume Chartrand
the authentification section is call, he try to authentification with my module ntlm_auth but it fail and I don't know why. If in the radius.conf mschap section module I insert the same ntlm_auth line of the exec. The sql don't work but AD work. If I put nothing in mschap section. The SQL works but not AD. So what I did make wrong Thank Guillaume Chartrand - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

RE: Freeradius push attribute to wireless connection

2008-04-02 Thread Guillaume Chartrand
IP, is it possible that the AP cannot send this kind of attribute? Dana 2/4/2008, "Guillaume Chartrand" <[EMAIL PROTECTED]> piše: >Hi, > > > >I'm using Freeradius 2.0, I configurated it with an sql database and the >principal job of the radius server

Freeradius push attribute to wireless connection

2008-04-02 Thread Guillaume Chartrand
WHERE Username = 'guillaume' ORDER BY id query: SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'guillaume' ORDER BY id rlm_sql (sql): Released sql socket id: 2 ++[sql] returns ok I have access but my session didn't disconnect after 30 sec. So ca

RE: Two authorize instance

2008-04-01 Thread Guillaume Chartrand
>Guillaume Chartrand wrote: >> I use freeradius 2.0.0 on red hat enterprise 3 AS and I set the authorize section to check the user credential with an >sql database. This configuration works. >> But I want to know and how to do that if it's possible, if the user isn&

Two authorize instance

2008-03-31 Thread Guillaume Chartrand
mschap } unix eap } ---- Guillaume Chartrand Technicien informatique Cégep régional de Lanaudière Centre administratif, Repentigny (450) 470-0911 poste 7218 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Wifi with Welcome message?

2008-03-19 Thread Guillaume Chartrand
Hi, Is it possible to send or execute a script to a user when he authenticated thru wi-fi connection with particular NAS. Like when user joe successfully authenticated with the sql database, if he was connected with NAS IP address X, he receive a Welcome message X and if he authenticated with

RE: Can freeRadius do that?

2008-03-11 Thread Guillaume Chartrand
do that? >>> >>>I'm using freeradius, with CoovaChilli, and a Squid Proxy (to reduce >>>internet traffic). Wich AP do you use. Do you know if Cisco AP or D-Link AP is supported by CoovaChilli without modifying firmware APs. Guillaume Thank >>>Works a

Can freeRadius do that?

2008-03-11 Thread Guillaume Chartrand
ination of software. Like a freeradius server and a proxy or freeradius with third party software. Can someone help me with my interrogation. Thanks a lot Guillaume Chartrand Technicien informatique Cégep régional de Lanaudière Centre administratif, Repent

freeradius SQL + EAP + Windows client

2008-02-28 Thread Guillaume Chartrand
name = '%{SQL-User-Name}' ORDER BY id -> SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'guillaume' ORDER BY id query: SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'guillaume' ORDER BY id rlm_sql (sql): Releas