Re: Multiple MACs per Network

2011-05-03 Thread John Corps
Sure no problem...I have made it so it is very easy to see who's mac belongs to who.. -- -- Table structure for table `MACAUTH` -- CREATE TABLE IF NOT EXISTS `MACAUTH` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `macaddress` varchar(64) NOT NULL, `SSID` varchar(255) NOT NULL, `CLIENT

Re: Multiple MACs per Network

2011-05-02 Thread Arran Cudbard-Bell
Yeah I missed out a bunch of things, well done for figuring it out . Would you mind dumping out the schema of your table, and I can add it and the below snippet to the wiki for future users? Thanks, Arran On May 2, 2011, at 6:51 AM, John Corps wrote: > wow i totally overlooked that, many thanks

Re: Multiple MACs per Network

2011-05-02 Thread John Corps
wow i totally overlooked that, many thanks Aaran! I have it setup and working perfectly! Many many thanks again. The sql was wrong in your post, missing some quotes or something so the working code was, my complete authorize section: authorize { preprocess rewrite_calling_station_i

Re: Multiple MACs per Network

2011-04-29 Thread Arran Cudbard-Bell
John, To be honest its probably easier to use SQL xlat then calling the SQL module if you're just trying to determine whether a mac address is allowed to access an SSID. SQL module is meant for more complex configurations. Create a new table with two fields 'ssid' and 'macaddress' authorize {

Re: Multiple MACs per Network

2011-04-29 Thread John Corps
Do you have an example of how to accomplish this? I have tried a lot of things but can't seem to get it to work. I have this in my authorize section: authorize { preprocess rewrite_calling_station_id rewrite_called_station_id sql sql.authorize if(notf

Re: Multiple MACs per Network

2011-04-28 Thread Arran Cudbard-Bell
On Apr 28, 2011, at 1:13 PM, John Corps wrote: > Thank you Aaran. It does indeed work. Is there an easy way of > implementing the same functionality to work with calling the > SSID.00-11-22-33-44-55 pulling from the radcheck sql table? Sure, you can use Calling-Station-SSID as a check attribute

Re: Multiple MACs per Network

2011-04-28 Thread John Corps
Thank you Aaran. It does indeed work. Is there an easy way of implementing the same functionality to work with calling the SSID.00-11-22-33-44-55 pulling from the radcheck sql table? On Thu, Apr 28, 2011 at 3:27 PM, Arran Cudbard-Bell wrote: > > On Apr 28, 2011, at 11:54 AM, John Corps wrote: > >

Re: Multiple MACs per Network

2011-04-28 Thread Arran Cudbard-Bell
On Apr 28, 2011, at 11:54 AM, John Corps wrote: > I have done a testing environment with the Mac-Auth section from the > Wiki. http://wiki.freeradius.org/Mac-Auth > > Not to sure what module you would be referring to...only thing I could > think of is the files module? Updated the wiki page wit

Re: Multiple MACs per Network

2011-04-28 Thread John Corps
I have done a testing environment with the Mac-Auth section from the Wiki. http://wiki.freeradius.org/Mac-Auth Not to sure what module you would be referring to...only thing I could think of is the files module? On Thu, Apr 28, 2011 at 2:43 PM, Arran Cudbard-Bell wrote: > Yes it's possible. What

Re: Multiple MACs per Network

2011-04-28 Thread Arran Cudbard-Bell
Yes it's possible. What module are you using to do mac authorisation? On Apr 28, 2011, at 11:34 AM, John Corps wrote: > Just a quick question, hope someone has an answer. Does anyone know > how, or if its even possible, to do mac filtering for multiple > networks? Say I have 1 AP with 2 WLAN SSID

Multiple MACs per Network

2011-04-28 Thread John Corps
Just a quick question, hope someone has an answer. Does anyone know how, or if its even possible, to do mac filtering for multiple networks? Say I have 1 AP with 2 WLAN SSIDs, I want list of macs allowed access to SSID1 but not SSID2 and list of macs allowed access to SSID2 and not SSID1. As far as