Public IP Address & static ip over SQL
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.
On Apr 10, 2018, at 4:20 PM, Juliano Raymundo dos Santos <juliano.raimundu@gmail.com> wrote:
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.
For users with dynamic IPs, set a Pool-Name attribute. For users with static IPs, set a Framed-IP-Address attribute.
I'm tried to configure at this way the table radcheck:
That text makes no sense whatsoever. Alan DeKok.
participants (2)
-
Alan DeKok -
Juliano Raymundo dos Santos