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