Link MAC adress to user after 1st login

Hi people, Im wondering if the following is possible with freeradius: At the 1st login of a client, the MAC adress is put into the database At all next logins, if the MAC adress of that client does not match the allready recorded MAC adress the login gets rejected. I presume the MAC adress of

RE: Link MAC adress to user after 1st login

list Onderwerp: Re: Link MAC adress to user after 1st login Jurgen van Vliet wrote: Hi people, hi, At the 1st login of a client, the MAC adress is put into the database At all next logins, if the MAC adress of that client does not match the allready recorded MAC adress the login gets rejected

RE: Mysql procedure and freeradius

Hi Alesha, I had SP running with 1.1.1 before I upgraded, should work too. Regards, Jurgen -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Alesha Verzonden: vrijdag 11 augustus 2006 5:50 Aan: FreeRadius users mailing list Onderwerp: Re: Mysql

RE: Mysql procedure and freeradius

Hi, That cant be the case, im using mysql 5 and a SP with freeradius 1.1.2 without any problems or recompiling. It must be an other issue. Maybe the sql user you let freeradius connect with has no rights to start the SP ? Regards, Jurgen -Oorspronkelijk bericht- Van: [EMAIL PROTECTED]

RE: Bandwidth control...

Hi Wagner, the lastest beta of monowall ( http://m0n0.ch/wall) is a nas with captive portal and supports the WISPr attributes for bandwidth management. it might work for you, works perfect here. Good luck. Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens WagnerVerzonden:

RE: How to execute TWO OR MORE Sql statement?

Im using stored procs to do a series of queries even with IF THEN ELSE structires, with variables being the result of a query and being used in other queries. Works like a charm for me with mysql5 and freeradius 1.1.2 In the sql.conf I just use as query something like call

RE: multiple post-auth sql queries, possible?

;call postauth1('%{SQL-User-Name}');" this calls the stored procedure postauth1 and gives the sql user name as parameter for the procedure to work with. Maybe that solves your problem :) Good luck! Jurgen van Vliet WANBound Technologies| Veldzigt 28 | 3454 PW De Meern | The Netherlands

question on postauth_query

Title: WANBound Briefpapier Hi people, I have a question I coulnt find in FAQ/Google, maybe I missed it or maybe I am thinking too difficult, but: Is it possible to do multiple queries in 1 postauth_queryusing somesort of IF THEN meganism ? Like : postauth_query = { if QUERY1=1