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