We have a Redhat server that authenticates based on MAC, records amount of
data transferred, and tells us how much to bill for. It also automatically
creates whatever email address' you enter, and will create a domain space
with DNS entries for hosting. It also keeps track of inventory, and tracks
users and hardware together.
Kevin
----- Original Message -----
From: "Eje Gustafsson" <[EMAIL PROTECTED]>
To: "Mike Davis" <[EMAIL PROTECTED]>
Sent: Thursday, September 25, 2003 4:14 PM
Subject: Re[2]: [smartBridges] APPO internal Mac authentication
> 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
----------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
