Public IP Address & static ip over SQL

Juliano Raymundo dos Santos juliano.raimundu at gmail.com
Tue Apr 10 22:20:02 CEST 2018


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.




More information about the Freeradius-Users mailing list