<html><div style='background-color:'><P>this is the example of my dhcpd.conf </P>
<P>im using dhcp3 for ubuntu and freeradius 1.1.3 , here for example I have two ip pools one for users that belong to the group A and another one for the rest of the users, the class name is "A", here im using the MAC address to divide users, all the MACs with start with "00:04" belong to class "A" and they are gonna get ips from 150.151.6.86 - 90 the rest of the users gonna get from 80 -85 </P>
<P>i wanna do something like that but with mysql, for example i have in radcheck table the user "bectizm" this user is gonna belong to group A so i want freeradius to auth the user ( freeradius already do this) and i want dhcp3 to recognize the same user "bectizm" that is stored in mysql and assing him and ip from the range 86-90 </P>
<P> </P>
<P>ddns-update-style none;</P>
<P>option domain-name-servers 150.6.2.105, 150.6.2.100;</P>
<P>default-lease-time 86400;<BR>max-lease-time 604800;</P>
<P>authoritative;</P>
<P>subnet 150.151.0.0 netmask 255.255.0.0 {<BR>#range 150.151.6.60 150.151.6.65; <BR>option subnet-mask 255.255.0.0;<BR>option broadcast-address 150.151.255.255;<BR>option routers 150.151.1.250;<BR>option netbios-name-servers 150.151.1.132, 142.188.1.47; </P>
<P> </P>
<P>class "A" {<BR>match if substring (hardware, 1, 2) = 00:04;</P>
<P>#subclass "foo" 00:04;<BR># 00-04-23-54-45-0f;<BR>}</P>
<P>pool {<BR>deny members of "foo";<BR>range 150.151.6.80 150.151.6.85;<BR>max-lease-time 300;</P>
<P>}</P>
<P>pool {<BR>allow members of "foo";<BR>max-lease-time 28800;<BR>range 150.151.6.86 150.151.6.90;</P>
<P>}</P>
<P>}</P>
<P><BR>**************************<BR>please if somebody can help me im gonna give him my life! =)</P>
<P>or any idea to do the same with the ip pools in freeradius? or with the tables in radius database of mysql?</P>
<P>regards and thanks in advance</P>
<P><BR><BR><BR><BR> </P>
<DIV>
<H6 align=left><FONT size=2></FONT> </H6></DIV></div><br clear=all><hr>Crea tu Space y compartelo con quién tu quieras <a href="http://g.msn.com/8HMBESMX/2752??PS=47575" target="_top">Haz clic aquí </a> Windows Live Spaces en Prodigy/MSN</html>