thanks for your reply sir but i am not working with ippool module file because when i delete this file my radius works properly nothing get wrong. i am working with radusergroup table in mysql , and mikrotik here are some screen shots. table structure: id | groupname | attribute | op | value 1024 | framed-pool | == | all-ips. thanks regards zubair ayub ________________________________ From: Freeradius-Users <freeradius-users-bounces+zubairayub=hotmail.com@lists.freeradius.org> on behalf of Alan DeKok <aland@deployingradius.com> Sent: Friday, September 9, 2016 3:38:01 PM To: FreeRadius users mailing list Subject: Re: HOW TO CHANGE PUBLIC IP RANDOMLY EVERY TIME USER CONNECT. On Sep 9, 2016, at 10:56 AM, Zubair Ayub <Zubairayub@hotmail.com> wrote:

my user get every time same public ip i want to do that my user should get new public ip every time he connect.. i am not using ippool file .

Use the ippool module. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html FreeRADIUS -- users' list info<http://www.freeradius.org/list/users.html> www.freeradius.org Users' List Information. The freeradius-users mailing list is for users of the FreeRADIUS server not Cistron's server! There are a few house-rules to which we'd like ...

yes sir definitely i will follow your instruction so please tell me what to do n how to do .. thanks again regards zubair ayub. ________________________________ From: Freeradius-Users <freeradius-users-bounces+zubairayub=hotmail.com@lists.freeradius.org> on behalf of Alan DeKok <aland@deployingradius.com> Sent: Saturday, September 10, 2016 12:30:04 PM To: FreeRadius users mailing list Subject: Re: HOW TO CHANGE PUBLIC IP RANDOMLY EVERY TIME USER CONNECT. On Sep 10, 2016, at 7:15 AM, Zubair Ayub <Zubairayub@hotmail.com> wrote:

but i am not working with ippool module file because when i delete this file my radius works properly nothing get wrong.

The way to get different IP addresses every time a user connects is to use the ippool module.

i am working with radusergroup table in mysql , and mikrotik here are some screen shots.

You have IP pools on the mikrotik, and/or in SQL. That's why the IPs are fixed. You now have a choice. a) keep arguing, and you won't solve the problem b) follow my instructions, and you will solve the problem. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

On Sep 10, 2016, at 8:47 AM, Zubair Ayub <Zubairayub@hotmail.com> wrote:

now i dont know why my ippool file is not working i am really very weak in radius sorry for asking stupid questions

Read the ippool documentation and follow the examples. Alan DeKok.

You need to add sqlippool to the accounting an post_auth section in sites-available/default also you need to insert ips with pool name in the radippool table then assign for each group the pool already created in radippool table using the attribute Pool-Name K. Yaghi On Thu, Sep 22, 2016 at 1:40 PM, Zubair Ayub <Zubairayub@hotmail.com> wrote:

i tried alot but didnt get result may be i am asking wrong quesion .

i have ips in my mikrotik name as all ips

then i have stored in my radgroupreply table with name all ips

now my pppoe dailer user get same public ip everytime

and every thing works fine

but i am that my user should get different ip everytime.

thanks

regards

zubair ayub

________________________________ From: Freeradius-Users <freeradius-users-bounces+zubairayub= hotmail.com@lists.freeradius.org> on behalf of Alan DeKok < aland@deployingradius.com> Sent: Saturday, September 10, 2016 12:59:50 PM To: FreeRadius users mailing list Subject: Re: HOW TO CHANGE PUBLIC IP RANDOMLY EVERY TIME USER CONNECT.

On Sep 10, 2016, at 8:47 AM, Zubair Ayub <Zubairayub@hotmail.com> wrote:

...

now i dont know why my ippool file is not working i am really very weak

in radius sorry for asking stupid questions

Read the ippool documentation and follow the examples.

Alan DeKok.

- List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html

thanks Aurélio de Souza Ribeiro Neto but i have these query in my ippool confg file and i am not using this file and also i have stored my ips in radgroup reply table not in rapippool. regards zubair ayub ________________________________ From: Freeradius-Users <freeradius-users-bounces+zubairayub=hotmail.com@lists.freeradius.org> on behalf of Aurélio de Souza Ribeiro Neto <netolistas@mpc.com.br> Sent: Thursday, September 22, 2016 11:19:03 AM To: FreeRadius users mailing list Subject: Re: HOW TO CHANGE PUBLIC IP RANDOMLY EVERY TIME USER CONNECT. Zubair, In your SQL conf file you have a Query Sample to do Randomly or not. Take a look: ## The ORDER BY clause of this query tries to allocate the same IP-address ## which user had last session... allocate-find = "SELECT framedipaddress FROM ${ippool_table} \ WHERE pool_name = '%{control:Pool-Name}' AND (expiry_time < NOW() OR expiry_time = '0000-00-00 00:00:00') \ ORDER BY (username <> '%{User-Name}'), \ (callingstationid <> '%{Calling-Station-Id}'), \ expiry_time \ LIMIT 1 \ FOR UPDATE" # ## If you prefer to allocate a random IP address every time, i # ## use this query instead # allocate-find = "SELECT framedipaddress FROM ${ippool_table} \ # WHERE pool_name = '%{control:Pool-Name}' \ # AND expiry_time = '0000-00-00 00:00:00' \ # ORDER BY RAND() \ # LIMIT 1 \ # FOR UPDATE" Em 22/09/2016 07:40, Zubair Ayub escreveu:

i tried alot but didnt get result may be i am asking wrong quesion .

i have ips in my mikrotik name as all ips

then i have stored in my radgroupreply table with name all ips

now my pppoe dailer user get same public ip everytime

and every thing works fine

but i am that my user should get different ip everytime.

thanks

regards

zubair ayub

________________________________ From: Freeradius-Users <freeradius-users-bounces+zubairayub=hotmail.com@lists.freeradius.org> on behalf of Alan DeKok <aland@deployingradius.com> Sent: Saturday, September 10, 2016 12:59:50 PM To: FreeRadius users mailing list Subject: Re: HOW TO CHANGE PUBLIC IP RANDOMLY EVERY TIME USER CONNECT.

On Sep 10, 2016, at 8:47 AM, Zubair Ayub <Zubairayub@hotmail.com> wrote:

...

now i dont know why my ippool file is not working i am really very weak in radius sorry for asking stupid questions Read the ippool documentation and follow the examples.

Alan DeKok.

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

how to assign each group to a specific ip pole can you please show me demo ________________________________ From: Freeradius-Users <freeradius-users-bounces+zubairayub=hotmail.com@lists.freeradius.org> on behalf of khouzam yaghi <khouzam.yaghi@gmail.com> Sent: Thursday, September 22, 2016 12:02:33 PM To: FreeRadius users mailing list Subject: Re: HOW TO CHANGE PUBLIC IP RANDOMLY EVERY TIME USER CONNECT. YOU NEED TO USE sqlippool as i told you! and also u MUST store the ips in radippool table and then in radgroupreply you assign each group to a specific pool-name you already stored in radippool K. Yaghi On Thu, Sep 22, 2016 at 2:51 PM, Zubair Ayub <Zubairayub@hotmail.com> wrote:

thanks Aurélio de Souza Ribeiro Neto but i have these query in my ippool confg file and i am not using this file and also i have stored my ips in radgroup reply table not in rapippool.

regards

zubair ayub

________________________________ From: Freeradius-Users <freeradius-users-bounces+zubairayub= hotmail.com@lists.freeradius.org> on behalf of Aurélio de Souza Ribeiro Neto <netolistas@mpc.com.br> Sent: Thursday, September 22, 2016 11:19:03 AM To: FreeRadius users mailing list Subject: Re: HOW TO CHANGE PUBLIC IP RANDOMLY EVERY TIME USER CONNECT.

Zubair,

In your SQL conf file you have a Query Sample to do Randomly or not.

Take a look:

## The ORDER BY clause of this query tries to allocate the same IP-address ## which user had last session... allocate-find = "SELECT framedipaddress FROM ${ippool_table} \ WHERE pool_name = '%{control:Pool-Name}' AND (expiry_time < NOW() OR expiry_time = '0000-00-00 00:00:00') \ ORDER BY (username <> '%{User-Name}'), \ (callingstationid <> '%{Calling-Station-Id}'), \ expiry_time \ LIMIT 1 \ FOR UPDATE"

# ## If you prefer to allocate a random IP address every time, i # ## use this query instead # allocate-find = "SELECT framedipaddress FROM ${ippool_table} \ # WHERE pool_name = '%{control:Pool-Name}' \ # AND expiry_time = '0000-00-00 00:00:00' \ # ORDER BY RAND() \ # LIMIT 1 \ # FOR UPDATE"

Em 22/09/2016 07:40, Zubair Ayub escreveu:

...

i tried alot but didnt get result may be i am asking wrong quesion .

i have ips in my mikrotik name as all ips

then i have stored in my radgroupreply table with name all ips

now my pppoe dailer user get same public ip everytime

and every thing works fine

but i am that my user should get different ip everytime.

thanks

regards

zubair ayub

________________________________ From: Freeradius-Users <freeradius-users-bounces+zubairayub= hotmail.com@lists.freeradius.org> on behalf of Alan DeKok < aland@deployingradius.com> Sent: Saturday, September 10, 2016 12:59:50 PM To: FreeRadius users mailing list Subject: Re: HOW TO CHANGE PUBLIC IP RANDOMLY EVERY TIME USER CONNECT.

On Sep 10, 2016, at 8:47 AM, Zubair Ayub <Zubairayub@hotmail.com> wrote:

...

now i dont know why my ippool file is not working i am really very weak in radius sorry for asking stupid questions Read the ippool documentation and follow the examples.

Alan DeKok.

- List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html

- List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

i have multiple nas servers so if you can give be all steps than i will be very thankful to you ________________________________ From: Freeradius-Users <freeradius-users-bounces+zubairayub=hotmail.com@lists.freeradius.org> on behalf of khouzam yaghi <khouzam.yaghi@gmail.com> Sent: Thursday, September 22, 2016 12:02:33 PM To: FreeRadius users mailing list Subject: Re: HOW TO CHANGE PUBLIC IP RANDOMLY EVERY TIME USER CONNECT. YOU NEED TO USE sqlippool as i told you! and also u MUST store the ips in radippool table and then in radgroupreply you assign each group to a specific pool-name you already stored in radippool K. Yaghi On Thu, Sep 22, 2016 at 2:51 PM, Zubair Ayub <Zubairayub@hotmail.com> wrote:

thanks Aurélio de Souza Ribeiro Neto but i have these query in my ippool confg file and i am not using this file and also i have stored my ips in radgroup reply table not in rapippool.

regards

zubair ayub

________________________________ From: Freeradius-Users <freeradius-users-bounces+zubairayub= hotmail.com@lists.freeradius.org> on behalf of Aurélio de Souza Ribeiro Neto <netolistas@mpc.com.br> Sent: Thursday, September 22, 2016 11:19:03 AM To: FreeRadius users mailing list Subject: Re: HOW TO CHANGE PUBLIC IP RANDOMLY EVERY TIME USER CONNECT.

Zubair,

In your SQL conf file you have a Query Sample to do Randomly or not.

Take a look:

## The ORDER BY clause of this query tries to allocate the same IP-address ## which user had last session... allocate-find = "SELECT framedipaddress FROM ${ippool_table} \ WHERE pool_name = '%{control:Pool-Name}' AND (expiry_time < NOW() OR expiry_time = '0000-00-00 00:00:00') \ ORDER BY (username <> '%{User-Name}'), \ (callingstationid <> '%{Calling-Station-Id}'), \ expiry_time \ LIMIT 1 \ FOR UPDATE"

# ## If you prefer to allocate a random IP address every time, i # ## use this query instead # allocate-find = "SELECT framedipaddress FROM ${ippool_table} \ # WHERE pool_name = '%{control:Pool-Name}' \ # AND expiry_time = '0000-00-00 00:00:00' \ # ORDER BY RAND() \ # LIMIT 1 \ # FOR UPDATE"

Em 22/09/2016 07:40, Zubair Ayub escreveu:

...

i tried alot but didnt get result may be i am asking wrong quesion .

i have ips in my mikrotik name as all ips

then i have stored in my radgroupreply table with name all ips

now my pppoe dailer user get same public ip everytime

and every thing works fine

but i am that my user should get different ip everytime.

thanks

regards

zubair ayub

________________________________ From: Freeradius-Users <freeradius-users-bounces+zubairayub= hotmail.com@lists.freeradius.org> on behalf of Alan DeKok < aland@deployingradius.com> Sent: Saturday, September 10, 2016 12:59:50 PM To: FreeRadius users mailing list Subject: Re: HOW TO CHANGE PUBLIC IP RANDOMLY EVERY TIME USER CONNECT.

On Sep 10, 2016, at 8:47 AM, Zubair Ayub <Zubairayub@hotmail.com> wrote:

...

now i dont know why my ippool file is not working i am really very weak in radius sorry for asking stupid questions Read the ippool documentation and follow the examples.

Alan DeKok.

- List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html

- List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

it works for me thanks alot for your kind help [??] ________________________________ From: Freeradius-Users <freeradius-users-bounces+zubairayub=hotmail.com@lists.freeradius.org> on behalf of Aurélio de Souza Ribeiro Neto <netolistas@mpc.com.br> Sent: Thursday, September 22, 2016 2:04:03 PM To: FreeRadius users mailing list Subject: Re: HOW TO CHANGE PUBLIC IP RANDOMLY EVERY TIME USER CONNECT. Zubair, I use this structure on MySQL for Mikrotik Nas, and FreeRadius 2.2.9, and it's only begin for solution: radcheck: +------+-------------+------------------+----+---------------+ | id | username | attribute | op | value | +------+-------------+------------------+----+---------------+ | 3540 | testepppoe2 | Simultaneous-Use | := | 1 | | 3541 | testepppoe2 | Pool-Name | := | main_pool | | 3542 | testepppoe2 | User-Password | := | userpassword | +------+-------------+------------------+----+---------------+ radusergroup: +-------------+-----------+----------+ | username | groupname | priority | +-------------+-----------+----------+ | testepppoe2 | 717 | 1 | +-------------+-----------+----------+ radgroupreply: +----+-----------+---------------------+----+----------------------------------------------+ | id | groupname | attribute | op | value | +----+-----------+---------------------+----+----------------------------------------------+ | 56 | 717 | Framed-Compression | := | Van-Jacobsen-TCP-IP | | 57 | 717 | Framed-Protocol | := | PPP | | 58 | 717 | Framed-Routing | := | Broadcast-Listen | | 59 | 717 | Framed-MTU | := | 1500 | | 60 | 717 | Service-Type | := | Framed-User | | 61 | 717 | Mikrotik-Rate-Limit | := | 1024k/4096k 1126k/11264k 1075k/8192k 108/108 | +----+-----------+---------------------+----+----------------------------------------------+ radippool: +-----+-----------+-----------------+--------------+-----------------+------------------+---------------------+----------+----------+ | id | pool_name | framedipaddress | nasipaddress | calledstationid | callingstationid | expiry_time | username | pool_key | +-----+-----------+-----------------+--------------+-----------------+------------------+---------------------+----------+----------+ | 509 | main_pool | 123.123.123.123 | | | | 0000-00-00 00:00:00 | | 0 | +-----+-----------+-----------------+--------------+-----------------+------------------+---------------------+----------+----------+ nas: +----+---------------+-------------+----------+-------+----------+--------+-----------+---------------------------+ | id | nasname | shortname | type | ports | secret | server | community | description | +----+---------------+-------------+----------+-------+----------+--------+-----------+---------------------------+ | 0 | 127.0.0.1 | Local Host | other | NULL | nassecret| NULL | NULL | RADIUS Client | | 1 | 172.20.30.2 | ce-poppa-rb | mikrotik | 1812 | nassecret| NULL | NULL | COND. CDHU PADRE ANCHIETA | | 2 | 172.20.200.22 | ce-teste-rb | mikrotik | 1812 | nassecret| NULL | NULL | TESTE PPPoE | +----+---------------+-------------+----------+-------+----------+--------+-----------+---------------------------+ Em 22/09/2016 10:07, Zubair Ayub escreveu:

i have multiple nas servers so if you can give be all steps than i will

be very thankful to you

________________________________ From: Freeradius-Users <freeradius-users-bounces+zubairayub=hotmail.com@lists.freeradius.org> on behalf of khouzam yaghi <khouzam.yaghi@gmail.com> Sent: Thursday, September 22, 2016 12:02:33 PM To: FreeRadius users mailing list Subject: Re: HOW TO CHANGE PUBLIC IP RANDOMLY EVERY TIME USER CONNECT.

YOU NEED TO USE sqlippool as i told you! and also u MUST store the ips in radippool table and then in radgroupreply you assign each group to a specific pool-name you already stored in radippool

K. Yaghi

On Thu, Sep 22, 2016 at 2:51 PM, Zubair Ayub <Zubairayub@hotmail.com> wrote:

...

thanks Aurélio de Souza Ribeiro Neto but i have these query in my ippool confg file and i am not using this file and also i have stored my ips in radgroup reply table not in rapippool.

regards

zubair ayub

________________________________ From: Freeradius-Users <freeradius-users-bounces+zubairayub= hotmail.com@lists.freeradius.org> on behalf of Aurélio de Souza Ribeiro Neto <netolistas@mpc.com.br> Sent: Thursday, September 22, 2016 11:19:03 AM To: FreeRadius users mailing list Subject: Re: HOW TO CHANGE PUBLIC IP RANDOMLY EVERY TIME USER CONNECT.

Zubair,

In your SQL conf file you have a Query Sample to do Randomly or not.

Take a look:

## The ORDER BY clause of this query tries to allocate the same IP-address ## which user had last session... allocate-find = "SELECT framedipaddress FROM ${ippool_table} \ WHERE pool_name = '%{control:Pool-Name}' AND (expiry_time < NOW() OR expiry_time = '0000-00-00 00:00:00') \ ORDER BY (username <> '%{User-Name}'), \ (callingstationid <> '%{Calling-Station-Id}'), \ expiry_time \ LIMIT 1 \ FOR UPDATE"

# ## If you prefer to allocate a random IP address every time, i # ## use this query instead # allocate-find = "SELECT framedipaddress FROM ${ippool_table} \ # WHERE pool_name = '%{control:Pool-Name}' \ # AND expiry_time = '0000-00-00 00:00:00' \ # ORDER BY RAND() \ # LIMIT 1 \ # FOR UPDATE"

Em 22/09/2016 07:40, Zubair Ayub escreveu:

...

i tried alot but didnt get result may be i am asking wrong quesion .

i have ips in my mikrotik name as all ips

then i have stored in my radgroupreply table with name all ips

now my pppoe dailer user get same public ip everytime

and every thing works fine

but i am that my user should get different ip everytime.

thanks

regards

zubair ayub

________________________________ From: Freeradius-Users <freeradius-users-bounces+zubairayub= hotmail.com@lists.freeradius.org> on behalf of Alan DeKok < aland@deployingradius.com> Sent: Saturday, September 10, 2016 12:59:50 PM To: FreeRadius users mailing list Subject: Re: HOW TO CHANGE PUBLIC IP RANDOMLY EVERY TIME USER CONNECT.

On Sep 10, 2016, at 8:47 AM, Zubair Ayub <Zubairayub@hotmail.com> wrote:

...

now i dont know why my ippool file is not working i am really very weak in radius sorry for asking stupid questions Read the ippool documentation and follow the examples.

Alan DeKok.

- List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html

- List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

sir here we assign only one pool to that user what if i have many pool and want to assign them against that user ________________________________ From: Freeradius-Users <freeradius-users-bounces+zubairayub=hotmail.com@lists.freeradius.org> on behalf of Aurélio de Souza Ribeiro Neto <netolistas@mpc.com.br> Sent: Thursday, September 22, 2016 2:04:03 PM To: FreeRadius users mailing list Subject: Re: HOW TO CHANGE PUBLIC IP RANDOMLY EVERY TIME USER CONNECT. Zubair, I use this structure on MySQL for Mikrotik Nas, and FreeRadius 2.2.9, and it's only begin for solution: radcheck: +------+-------------+------------------+----+---------------+ | id | username | attribute | op | value | +------+-------------+------------------+----+---------------+ | 3540 | testepppoe2 | Simultaneous-Use | := | 1 | | 3541 | testepppoe2 | Pool-Name | := | main_pool | | 3542 | testepppoe2 | User-Password | := | userpassword | +------+-------------+------------------+----+---------------+ radusergroup: +-------------+-----------+----------+ | username | groupname | priority | +-------------+-----------+----------+ | testepppoe2 | 717 | 1 | +-------------+-----------+----------+ radgroupreply: +----+-----------+---------------------+----+----------------------------------------------+ | id | groupname | attribute | op | value | +----+-----------+---------------------+----+----------------------------------------------+ | 56 | 717 | Framed-Compression | := | Van-Jacobsen-TCP-IP | | 57 | 717 | Framed-Protocol | := | PPP | | 58 | 717 | Framed-Routing | := | Broadcast-Listen | | 59 | 717 | Framed-MTU | := | 1500 | | 60 | 717 | Service-Type | := | Framed-User | | 61 | 717 | Mikrotik-Rate-Limit | := | 1024k/4096k 1126k/11264k 1075k/8192k 108/108 | +----+-----------+---------------------+----+----------------------------------------------+ radippool: +-----+-----------+-----------------+--------------+-----------------+------------------+---------------------+----------+----------+ | id | pool_name | framedipaddress | nasipaddress | calledstationid | callingstationid | expiry_time | username | pool_key | +-----+-----------+-----------------+--------------+-----------------+------------------+---------------------+----------+----------+ | 509 | main_pool | 123.123.123.123 | | | | 0000-00-00 00:00:00 | | 0 | +-----+-----------+-----------------+--------------+-----------------+------------------+---------------------+----------+----------+ nas: +----+---------------+-------------+----------+-------+----------+--------+-----------+---------------------------+ | id | nasname | shortname | type | ports | secret | server | community | description | +----+---------------+-------------+----------+-------+----------+--------+-----------+---------------------------+ | 0 | 127.0.0.1 | Local Host | other | NULL | nassecret| NULL | NULL | RADIUS Client | | 1 | 172.20.30.2 | ce-poppa-rb | mikrotik | 1812 | nassecret| NULL | NULL | COND. CDHU PADRE ANCHIETA | | 2 | 172.20.200.22 | ce-teste-rb | mikrotik | 1812 | nassecret| NULL | NULL | TESTE PPPoE | +----+---------------+-------------+----------+-------+----------+--------+-----------+---------------------------+ Em 22/09/2016 10:07, Zubair Ayub escreveu:

i have multiple nas servers so if you can give be all steps than i will

be very thankful to you

________________________________ From: Freeradius-Users <freeradius-users-bounces+zubairayub=hotmail.com@lists.freeradius.org> on behalf of khouzam yaghi <khouzam.yaghi@gmail.com> Sent: Thursday, September 22, 2016 12:02:33 PM To: FreeRadius users mailing list Subject: Re: HOW TO CHANGE PUBLIC IP RANDOMLY EVERY TIME USER CONNECT.

YOU NEED TO USE sqlippool as i told you! and also u MUST store the ips in radippool table and then in radgroupreply you assign each group to a specific pool-name you already stored in radippool

K. Yaghi

On Thu, Sep 22, 2016 at 2:51 PM, Zubair Ayub <Zubairayub@hotmail.com> wrote:

...

thanks Aurélio de Souza Ribeiro Neto but i have these query in my ippool confg file and i am not using this file and also i have stored my ips in radgroup reply table not in rapippool.

regards

zubair ayub

________________________________ From: Freeradius-Users <freeradius-users-bounces+zubairayub= hotmail.com@lists.freeradius.org> on behalf of Aurélio de Souza Ribeiro Neto <netolistas@mpc.com.br> Sent: Thursday, September 22, 2016 11:19:03 AM To: FreeRadius users mailing list Subject: Re: HOW TO CHANGE PUBLIC IP RANDOMLY EVERY TIME USER CONNECT.

Zubair,

In your SQL conf file you have a Query Sample to do Randomly or not.

Take a look:

## The ORDER BY clause of this query tries to allocate the same IP-address ## which user had last session... allocate-find = "SELECT framedipaddress FROM ${ippool_table} \ WHERE pool_name = '%{control:Pool-Name}' AND (expiry_time < NOW() OR expiry_time = '0000-00-00 00:00:00') \ ORDER BY (username <> '%{User-Name}'), \ (callingstationid <> '%{Calling-Station-Id}'), \ expiry_time \ LIMIT 1 \ FOR UPDATE"

# ## If you prefer to allocate a random IP address every time, i # ## use this query instead # allocate-find = "SELECT framedipaddress FROM ${ippool_table} \ # WHERE pool_name = '%{control:Pool-Name}' \ # AND expiry_time = '0000-00-00 00:00:00' \ # ORDER BY RAND() \ # LIMIT 1 \ # FOR UPDATE"

Em 22/09/2016 07:40, Zubair Ayub escreveu:

...

i tried alot but didnt get result may be i am asking wrong quesion .

i have ips in my mikrotik name as all ips

then i have stored in my radgroupreply table with name all ips

now my pppoe dailer user get same public ip everytime

and every thing works fine

but i am that my user should get different ip everytime.

thanks

regards

zubair ayub

________________________________ From: Freeradius-Users <freeradius-users-bounces+zubairayub= hotmail.com@lists.freeradius.org> on behalf of Alan DeKok < aland@deployingradius.com> Sent: Saturday, September 10, 2016 12:59:50 PM To: FreeRadius users mailing list Subject: Re: HOW TO CHANGE PUBLIC IP RANDOMLY EVERY TIME USER CONNECT.

On Sep 10, 2016, at 8:47 AM, Zubair Ayub <Zubairayub@hotmail.com> wrote:

...

now i dont know why my ippool file is not working i am really very weak in radius sorry for asking stupid questions Read the ippool documentation and follow the examples.

Alan DeKok.

- List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html

- List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html