Public IP Address & static ip over SQL

[Juliano Raymundo dos Santos]

Hi everyone, this is my first post in this fórum, so if I write 
something and this is ansewred in another time, please tell me.

I'm configuring a freeradius server for a ISP provider, and I need to 
deliver for clients public Ip addresses but this one need to be static 
at the same time, because is the main poli of the network.

I'm using sqlippool for delivery IP addresses for clients but I don't 
want use this for public IP addresses, just for private. The ippool is 
working fine.

I'm tried to configure at this way the table radcheck:


	
		
	
	
	
	

	
	
	3
	13
	juliano
	ClearText-Password
	:=
	juliano123
	Edit Edit 
<http://187.85.132.121/phpmyadmin/tbl_change.php?db=radius&table=radcheck&where_clause=%60radcheck%60.%60id%60+%3D+14&clause_is_unique=1&sql_query=SELECT+%2A+FROM+%60radcheck%60+WHERE+1&goto=sql.php&default_action=update&token=6578993c5b2dd6ac0a96ff0f00f033ff> 
	Copy Copy 
<http://187.85.132.121/phpmyadmin/tbl_change.php?db=radius&table=radcheck&where_clause=%60radcheck%60.%60id%60+%3D+14&clause_is_unique=1&sql_query=SELECT+%2A+FROM+%60radcheck%60+WHERE+1&goto=sql.php&default_action=insert&token=6578993c5b2dd6ac0a96ff0f00f033ff> 
	Delete Delete 
<http://187.85.132.121/phpmyadmin/sql.php?db=radius&table=radcheck&sql_query=DELETE+FROM+%60radcheck%60+WHERE+%60radcheck%60.%60id%60+%3D+14&message_to_show=The+row+has+been+deleted.&goto=sql.php%3Fdb%3Dradius%26table%3Dradcheck%26sql_query%3DSELECT%2B%252A%2BFROM%2B%2560radcheck%2560%2BWHERE%2B1%26message_to_show%3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted.%26goto%3Dtbl_sql.php%26token%3D6578993c5b2dd6ac0a96ff0f00f033ff&token=6578993c5b2dd6ac0a96ff0f00f033ff> 
	14 	juliano 	Framed-Ip-Address 	:= 	191.241.***.***
	Edit Edit 
<http://187.85.132.121/phpmyadmin/tbl_change.php?db=radius&table=radcheck&where_clause=%60radcheck%60.%60id%60+%3D+15&clause_is_unique=1&sql_query=SELECT+%2A+FROM+%60radcheck%60+WHERE+1&goto=sql.php&default_action=update&token=6578993c5b2dd6ac0a96ff0f00f033ff> 
	Copy Copy 
<http://187.85.132.121/phpmyadmin/tbl_change.php?db=radius&table=radcheck&where_clause=%60radcheck%60.%60id%60+%3D+15&clause_is_unique=1&sql_query=SELECT+%2A+FROM+%60radcheck%60+WHERE+1&goto=sql.php&default_action=insert&token=6578993c5b2dd6ac0a96ff0f00f033ff> 
	Delete Delete 
<http://187.85.132.121/phpmyadmin/sql.php?db=radius&table=radcheck&sql_query=DELETE+FROM+%60radcheck%60+WHERE+%60radcheck%60.%60id%60+%3D+15&message_to_show=The+row+has+been+deleted.&goto=sql.php%3Fdb%3Dradius%26table%3Dradcheck%26sql_query%3DSELECT%2B%252A%2BFROM%2B%2560radcheck%2560%2BWHERE%2B1%26message_to_show%3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted.%26goto%3Dtbl_sql.php%26token%3D6578993c5b2dd6ac0a96ff0f00f033ff&token=6578993c5b2dd6ac0a96ff0f00f033ff> 
	15 	juliano 	Framed-Route 	:= 	"191.241.***.***"
	Edit Edit 
<http://187.85.132.121/phpmyadmin/tbl_change.php?db=radius&table=radcheck&where_clause=%60radcheck%60.%60id%60+%3D+16&clause_is_unique=1&sql_query=SELECT+%2A+FROM+%60radcheck%60+WHERE+1&goto=sql.php&default_action=update&token=6578993c5b2dd6ac0a96ff0f00f033ff> 
	Copy Copy 
<http://187.85.132.121/phpmyadmin/tbl_change.php?db=radius&table=radcheck&where_clause=%60radcheck%60.%60id%60+%3D+16&clause_is_unique=1&sql_query=SELECT+%2A+FROM+%60radcheck%60+WHERE+1&goto=sql.php&default_action=insert&token=6578993c5b2dd6ac0a96ff0f00f033ff> 
	Delete Delete 
<http://187.85.132.121/phpmyadmin/sql.php?db=radius&table=radcheck&sql_query=DELETE+FROM+%60radcheck%60+WHERE+%60radcheck%60.%60id%60+%3D+16&message_to_show=The+row+has+been+deleted.&goto=sql.php%3Fdb%3Dradius%26table%3Dradcheck%26sql_query%3DSELECT%2B%252A%2BFROM%2B%2560radcheck%2560%2BWHERE%2B1%26message_to_show%3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted.%26goto%3Dtbl_sql.php%26token%3D6578993c5b2dd6ac0a96ff0f00f033ff&token=6578993c5b2dd6ac0a96ff0f00f033ff> 
	16 	juliano 	Framed-Netmask 	:= 	255.255.255.0
	Edit Edit 
<http://187.85.132.121/phpmyadmin/tbl_change.php?db=radius&table=radcheck&where_clause=%60radcheck%60.%60id%60+%3D+17&clause_is_unique=1&sql_query=SELECT+%2A+FROM+%60radcheck%60+WHERE+1&goto=sql.php&default_action=update&token=6578993c5b2dd6ac0a96ff0f00f033ff> 
	Copy Copy 
<http://187.85.132.121/phpmyadmin/tbl_change.php?db=radius&table=radcheck&where_clause=%60radcheck%60.%60id%60+%3D+17&clause_is_unique=1&sql_query=SELECT+%2A+FROM+%60radcheck%60+WHERE+1&goto=sql.php&default_action=insert&token=6578993c5b2dd6ac0a96ff0f00f033ff> 
	Delete Delete 
<http://187.85.132.121/phpmyadmin/sql.php?db=radius&table=radcheck&sql_query=DELETE+FROM+%60radcheck%60+WHERE+%60radcheck%60.%60id%60+%3D+17&message_to_show=The+row+has+been+deleted.&goto=sql.php%3Fdb%3Dradius%26table%3Dradcheck%26sql_query%3DSELECT%2B%252A%2BFROM%2B%2560radcheck%2560%2BWHERE%2B1%26message_to_show%3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted.%26goto%3Dtbl_sql.php%26token%3D6578993c5b2dd6ac0a96ff0f00f033ff&token=6578993c5b2dd6ac0a96ff0f00f033ff> 
	17 	juliano 	Auth-Type 	:= 	Accept


Glad for help, best regards.