Re: [smartBridges] APPO internal Mac authentication

Mon, 22 Sep 2003 18:59:11 -0700

I use freeradius on rh8.  I have all customer info in a mysql db with a web front end.  The script below runs from a cron job every 15 minutes and writes a radius users file then reloads radius daemon.  I don't have tens of thousands of users so the radius text file works for me and is easy scp to a backup radius server in the same cron job. 
 
The script below creates two entries, one formatted for smart bridges and the other for mikrotik wireless auth (not hotspot).
 
Thought this might spark some creative thinking from the list users regarding auth methods.
 
 
[EMAIL PROTECTED] macaddress]# cat dbToRad
#!/usr/bin/php -q
 
<?php
 
define('MYSQL_HOST', 'localhost');
define('MYSQL_USER', 'yourdbuser');
define('MYSQL_PASS', 'yourdbpass');
define('MYSQL_DB', 'custmain');
 
$fp=fopen("/usr/local/etc/raddb/users","w");
mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASS);
mysql_select_db(MYSQL_DB);
 
$result = mysql_query('SELECT * from sub');
 
while ($row = mysql_fetch_array($result))
{
fputs($fp,"#".$row['lastname']."-".$row['firstname']."-".$row['company']."\r\n");
$str = strtolower($row['macaddress']);
list($mac1, $mac2, $mac3, $mac4, $mac5, $mac6) = split (":", $str, 6);
$macmikro = $mac1.":".$mac2.":".$mac3.":".$mac4.":".$mac5.":".$mac6."\tpassword == \"\"\r\n";
$macsmart = $mac1.$mac2.$mac3.$mac4.$mac5.$mac6."\tpassword==\"".$mac1.$mac2.$mac3.$mac4.$mac5.$mac6."\"\r\n";
fputs($fp,$macmikro);
fputs($fp,$macsmart);
}
fclose($fp);
?>
----- Original Message -----
Sent: Monday, September 22, 2003 9:23 PM
Subject: Re: [smartBridges] APPO internal Mac authentication

Yes I figured that it would not take much for now it seems to work good but before I load up to much more I need to get a radius server going, anyone have any recommendations for that setup on a Linux redhat machine 9.0?
 
Thanks
----- Original Message -----
Sent: Monday, September 22, 2003 4:51 PM
Subject: RE: [smartBridges] APPO internal Mac authentication

Martin,

 

Storing 30 Macs will not take much of the memory space or resources on the radio. But looking at the management perspective, it is recommended that you use Radius authentication for centralize and ease of management.

 

Alex

sB Tech Support

[EMAIL PROTECTED]

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Blazen Wireless
Sent: Tuesday, September 23, 2003 6:08 AM
To: [EMAIL PROTECTED]
Subject: [smartBridges] APPO internal Mac authentication

 

Question when using this feature I have 30 macs in there now how much resources does this use up on the radio? Should I make some kind of external radius server instead I am learning Linux and have a redhat machine ready to go and can add a virtual ip on the existing Lan card and load software on it. This will also be serving as my production mail server as well with Spam assassin as soon as I figure out how to the password feature of squirrel mail to work and also get all my other domains on it.

 

Has anyone else set up squirrel mail on this type of OS I can get in and use mail but I want to have users admin their own passwords as well as their own black lists but I control the backend blacklists to filter most all the crap out that I don't want them to get by either domain, IP and or other blacklists.

 

Thanks

 

Martin & Steve
Blazen Wireless

www.blazenwireless.com

Reply via email to