Why not set freeradius to auth from mysql dbdirectly ?
Easier quicker and less failure prone.
Monday, September 22, 2003, 8:58:36 PM, you wrote:
MD> 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
MD> 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.
MD> The script below creates two entries, one formatted for smart bridges and the
other for mikrotik wireless auth (not hotspot).
MD> Thought this might spark some creative thinking from the list users regarding auth
methods.
MD> [EMAIL PROTECTED] macaddress]# cat dbToRad
MD> #!/usr/bin/php -q
MD> <?php
MD> define('MYSQL_HOST', 'localhost');
MD> define('MYSQL_USER', 'yourdbuser');
MD> define('MYSQL_PASS', 'yourdbpass');
MD> define('MYSQL_DB', 'custmain');
MD> $fp=fopen("/usr/local/etc/raddb/users","w");
MD> mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASS);
MD> mysql_select_db(MYSQL_DB);
MD> $result = mysql_query('SELECT * from sub');
MD> while ($row = mysql_fetch_array($result))
MD> {
MD> fputs($fp,"#".$row['lastname']."-".$row['firstname']."-".$row['company']."\r\n");
MD> $str = strtolower($row['macaddress']);
MD> list($mac1, $mac2, $mac3, $mac4, $mac5, $mac6) = split (":", $str, 6);
MD> $macmikro = $mac1.":".$mac2.":".$mac3.":".$mac4.":".$mac5.":".$mac6."\tpassword ==
\"\"\r\n";
MD> $macsmart =
$mac1.$mac2.$mac3.$mac4.$mac5.$mac6."\tpassword==\"".$mac1.$mac2.$mac3.$mac4.$mac5.$mac6."\"\r\n";
MD> fputs($fp,$macmikro);
MD> fputs($fp,$macsmart);
MD> }
MD> fclose($fp);
?>>
MD> ----- Original Message -----
MD> From: Blazen Wireless
MD> To: [EMAIL PROTECTED]
MD> Sent: Monday, September 22, 2003 9:23 PM
MD> Subject: Re: [smartBridges] APPO internal Mac authentication
MD> 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
MD> a Linux redhat machine 9.0?
MD> Thanks
MD> ----- Original Message -----
MD> From: sB Tech Support
MD> To: [EMAIL PROTECTED]
MD> Sent: Monday, September 22, 2003 4:51 PM
MD> Subject: RE: [smartBridges] APPO internal Mac authentication
MD> Martin,
MD> 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
MD> centralize and ease of management.
MD> Alex
MD> sB Tech Support
MD> [EMAIL PROTECTED]
MD> -----Original Message-----
MD> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Blazen Wireless
MD> Sent: Tuesday, September 23, 2003 6:08 AM
MD> To: [EMAIL PROTECTED]
MD> Subject: [smartBridges] APPO internal Mac authentication
MD> 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
MD> 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
MD> 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.
MD> 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
MD> blacklists to filter most all the crap out that I don't want them to get by either
domain, IP and or other blacklists.
MD> Thanks
MD> Martin & Steve
MD> Blazen Wireless
MD> www.blazenwireless.com
Best regards,
Eje Gustafsson mailto:[EMAIL PROTECTED]
---
The Family Entertainment Network eFax : 240-376-7272
Phone : 620-231-7777 Fax : 620-231-4066
Online Store http://www.fament.com/catalog/
- Your Full Time Professionals -
--
[This E-mail scanned for viruses by Declude Virus]
----------ANNOUNCEMENT----------
Don't forget to register for WISPCON IV
http://www.wispcon.info/us/wispcon-iv/wispcon-iv.htm
The PART-15.ORG smartBridges Discussion List
To Join: mailto:[EMAIL PROTECTED] (in the body type subscribe smartBridges
<yournickname>
To Remove: mailto:[EMAIL PROTECTED] (in the body type unsubscribe smartBridges)
Archives: http://archives.part-15.org
