IP allocation problem

Marcelo Santoro santoro.ice at gmail.com
Thu Mar 5 14:10:47 CET 2015


My Friend… here i am using the follow configuration:

pool_key = "%{NAS-IP-Address}-%{NAS-Port}"

i don`t have problem here !!!

Hope it help you.

Best Regards

Marcelo Santoro

> Em 05/03/2015, à(s) 09:57, Tevfik Ceydeliler <tevfik.ceydeliler at astron.yasar.com.tr> escreveu:
> 
> Can problrm is this?
> on sqlippool.conf
> -------------------------------
> pool-key = "%{NAS-Port}"
> # pool-key = "%{Calling-Station-Id}"
> ----------------------------------
> On 03/05/2015 02:41 PM, Tevfik Ceydeliler wrote:
>> here is  debug log.
>> There is a warning about two type atuhentication. But I think this is not cause of problem.
>> 
>> I check that same calling station ID .
>> But cant find why happen this:
>> 
>> rad_recv: Access-Request packet from host 172.30.80.1 port 24288, id=190, length=396
>>    Calling-Station-Id = "905303643912"
>>    User-Name = "biryudumgida3"
>>    NAS-IP-Address = 172.30.80.1
>>    NAS-Identifier = "MTCGGSNK3"
>>    Service-Type = Framed-User
>>    Framed-Protocol = GPRS-PDP-Context
>>    NAS-Port-Type = Wireless-Other
>> ---3GPP things--
>>    Called-Station-Id = "yasarapn"
>> ---3GPP things--
>>    CHAP-Challenge = 0xa326bfbfa326bfbfa326bfbfa326bfbf
>>    CHAP-Password = 0x004de14711758f194ae8bbc0b2cd18899e
>>    NAS-Port = 98076
>>    3GPP-Charging-Gateway-Address = 10.200.211.27
>> # Executing section authorize from file /etc/freeradius/sites-enabled/default
>> +- entering group authorize {...}
>> ++[preprocess] returns ok
>> [chap] Setting 'Auth-Type := CHAP'
>> ++[chap] returns ok
>> ++[mschap] returns noop
>> ++[digest] returns noop
>> [suffix] No '@' in User-Name = "biryudumgida3", looking up realm NULL
>> [suffix] No such realm "NULL"
>> ++[suffix] returns noop
>> [eap] No EAP-Message, not doing EAP
>> ++[eap] returns noop
>> ++[files] returns noop
>> [sql]     expand: %{User-Name} -> biryudumgida3
>> [sql] sql_set_user escaped user --> 'biryudumgida3'
>> rlm_sql (sql): Reserving sql socket id: 0
>> [sql]     expand: SELECT id, username, attribute, value, op           FROM radcheck           WHERE username = '%{SQL-User-Name}'           ORDER BY id -> SELECT id, username, attribute, value, op           FROM radcheck WHERE username = 'biryudumgida3'           ORDER BY id
>> [sql] User found in radcheck table
>> [sql]     expand: SELECT id, username, attribute, value, op           FROM radreply           WHERE username = '%{SQL-User-Name}'           ORDER BY id -> SELECT id, username, attribute, value, op           FROM radreply WHERE username = 'biryudumgida3'           ORDER BY id
>> [sql]     expand: SELECT groupname           FROM radusergroup           WHERE username = '%{SQL-User-Name}'           ORDER BY priority -> SELECT groupname           FROM radusergroup           WHERE username = 'biryudumgida3'           ORDER BY priority
>> [sql]     expand: SELECT id, groupname, attribute, Value, op           FROM radgroupcheck           WHERE groupname = '%{Sql-Group}'           ORDER BY id -> SELECT id, groupname, attribute,           Value, op           FROM radgroupcheck           WHERE groupname = 'UGR_TcellOtonomYBB-Secovid'           ORDER BY id
>> [sql] User found in group UGR_TcellOtonomYBB-Secovid
>> [sql]     expand: SELECT id, groupname, attribute, value, op           FROM radgroupreply           WHERE groupname = '%{Sql-Group}'           ORDER BY id -> SELECT id, groupname, attribute,           value, op           FROM radgroupreply           WHERE groupname = 'UGR_TcellOtonomYBB-Secovid'           ORDER BY id
>> rlm_sql (sql): Released sql socket id: 0
>> ++[sql] returns ok
>> ++[expiration] returns noop
>> ++[logintime] returns noop
>> ++[pap] returns noop
>>  WARNING: Empty pre-proxy section.  Using default return values.
>> Sending Access-Request of id 234 to 10.1.1.51 port 1812
>>    Calling-Station-Id = "905303643912"
>>    User-Name = "biryudumgida3"
>>    NAS-IP-Address = 172.30.80.1
>>    NAS-Identifier = "MTCGGSNK3"
>>    Service-Type = Framed-User
>>    Framed-Protocol = GPRS-PDP-Context
>>    NAS-Port-Type = Wireless-Other
>> ---3GPP things--
>>    Called-Station-Id = "yasarapn"
>> ---3GPP things--
>>    CHAP-Challenge = 0xa326bfbfa326bfbfa326bfbfa326bfbf
>>    CHAP-Password = 0x004de14711758f194ae8bbc0b2cd18899e
>>    NAS-Port = 98076
>>    3GPP-Charging-Gateway-Address = 10.200.211.27
>>    Proxy-State = 0x313930
>> Proxying request 4 to home server 10.1.1.51 port 1812
>> Sending Access-Request of id 234 to 10.1.1.51 port 1812
>>    Calling-Station-Id = "905303643912"
>>    User-Name = "biryudumgida3"
>>    NAS-IP-Address = 172.30.80.1
>>    NAS-Identifier = "MTCGGSNK3"
>>    Service-Type = Framed-User
>>    Framed-Protocol = GPRS-PDP-Context
>>    NAS-Port-Type = Wireless-Other
>> ---3GPP things--
>>    Called-Station-Id = "yasarapn"
>> ---3GPP things--
>>    CHAP-Challenge = 0xa326bfbfa326bfbfa326bfbfa326bfbf
>>    CHAP-Password = 0x004de14711758f194ae8bbc0b2cd18899e
>>    NAS-Port = 98076
>>    3GPP-Charging-Gateway-Address = 10.200.211.27
>>    Proxy-State = 0x313930
>> Going to the next request
>> Waking up in 0.9 seconds.
>> rad_recv: Access-Accept packet from host 10.1.1.51 port 1812, id=234, length=25
>>    Proxy-State = 0x313930
>> # Executing section post-proxy from file /etc/freeradius/sites-enabled/default
>> +- entering group post-proxy {...}
>> [eap] No pre-existing handler found
>> ++[eap] returns noop
>> Found Auth-Type = CHAP
>> Found Auth-Type = Accept
>> ###THERE IS A WARNING HERE!! ####
>> Warning:  Found 2 auth-types on request for user 'biryudumgida3'
>> Auth-Type = Accept, accepting the user
>> # Executing section post-auth from file /etc/freeradius/sites-enabled/default
>> +- entering group post-auth {...}
>> rlm_sql (sql): Reserving sql socket id: 4
>> [sqlippool]     expand: %{User-Name} -> biryudumgida3
>> [sqlippool] sql_set_user escaped user --> 'biryudumgida3'
>> [sqlippool]     expand: START TRANSACTION -> START TRANSACTION
>> [sqlippool]     expand: UPDATE radippool   SET nasipaddress = '', pool_key = 0,   callingstationid = '', username = '', expiry_time = NULL   WHERE expiry_time <= NOW() - INTERVAL 1 SECOND   AND nasipaddress = '%{Nas-IP-Address}' -> UPDATE radippool   SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '',   expiry_time = NULL WHERE expiry_time <= NOW() - INTERVAL 1 SECOND   AND nasipaddress = '172.30.80.1'
>> [sqlippool]     expand: SELECT framedipaddress FROM radippool WHERE pool_name = '%{control:Pool-Name}' AND (expiry_time < NOW() OR expiry_time IS NULL)  ORDER BY (username <> '%{User-Name}'),  (callingstationid <> '%{Calling-Station-Id}'),  expiry_time  LIMIT 1  FOR UPDATE -> SELECT framedipaddress FROM radippool  WHERE pool_name = 'IP_TcellOtonomYBB' AND (expiry_time < NOW() OR expiry_time IS NULL)  ORDER BY (username <> 'biryudumgida3'), (callingstationid <> '905303643912'),  expiry_time  LIMIT 1  FOR UPDATE
>> [sqlippool]     expand: UPDATE radippool  SET nasipaddress = '%{NAS-IP-Address}', pool_key = '%{NAS-Port}',  callingstationid = '%{Calling-Station-Id}', username = '%{User-Name}', expiry_time = NOW() + INTERVAL 7200 SECOND  WHERE framedipaddress = '172.30.64.191' AND expiry_time IS NULL -> UPDATE radippool  SET nasipaddress = '172.30.80.1', pool_key = '98076',  callingstationid = '905303643912', username = 'biryudumgida3',  expiry_time = NOW() + INTERVAL 7200 SECOND WHERE framedipaddress = '172.30.64.191' AND expiry_time IS NULL
>> [sqlippool] Allocated IP 172.30.64.191 [bf401eac]
>> [sqlippool]     expand: COMMIT -> COMMIT
>> rlm_sql (sql): Released sql socket id: 4
>> [sqlippool]     expand: Allocated IP: %{reply:Framed-IP-Address} from %{control:Pool-Name}   (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name}) -> Allocated IP: 172.30.64.191 from IP_TcellOtonomYBB   (did yasarapn cli 905303643912 port 98076 user biryudumgida3)
>> #####IP ALLOCATED AS 172.30.64.191 #######
>> Allocated IP: 172.30.64.191 from IP_TcellOtonomYBB   (did yasarapn cli 905303643912 port 98076 user biryudumgida3)
>> ++[sqlippool] returns ok
>> ++[exec] returns noop
>> Sending Access-Accept of id 190 to 172.30.80.1 port 24288
>>    Framed-IP-Address = 172.30.64.191
>> Finished request 4.
>> Going to the next request
>> Waking up in 4.9 seconds.
>> Cleaning up request 4 ID 190 with timestamp +875
>> Ready to process requests.
>> #####REQ. COMES AGAIN ######
>> rad_recv: Access-Request packet from host 172.30.80.1 port 24480, id=83, length=396
>>    Calling-Station-Id = "905303643912"
>>    User-Name = "biryudumgida3"
>>    NAS-IP-Address = 172.30.80.1
>>    NAS-Identifier = "MTCGGSNK3"
>>    Service-Type = Framed-User
>>    Framed-Protocol = GPRS-PDP-Context
>>    NAS-Port-Type = Wireless-Other
>> ---3GPP things--
>>    Called-Station-Id = "yasarapn"
>> ---3GPP things--
>>    CHAP-Challenge = 0x2d9abfbf2d9abfbf2d9abfbf2d9abfbf
>>    CHAP-Password = 0x00ec83996af9236f1afe60dacc246bc3c4
>>    NAS-Port = 128247
>>    3GPP-Charging-Gateway-Address = 10.200.211.27
>> # Executing section authorize from file /etc/freeradius/sites-enabled/default
>> +- entering group authorize {...}
>> ++[preprocess] returns ok
>> [chap] Setting 'Auth-Type := CHAP'
>> ++[chap] returns ok
>> ++[mschap] returns noop
>> ++[digest] returns noop
>> [suffix] No '@' in User-Name = "biryudumgida3", looking up realm NULL
>> [suffix] No such realm "NULL"
>> ++[suffix] returns noop
>> [eap] No EAP-Message, not doing EAP
>> ++[eap] returns noop
>> ++[files] returns noop
>> [sql]     expand: %{User-Name} -> biryudumgida3
>> [sql] sql_set_user escaped user --> 'biryudumgida3'
>> rlm_sql (sql): Reserving sql socket id: 3
>> [sql]     expand: SELECT id, username, attribute, value, op           FROM radcheck           WHERE username = '%{SQL-User-Name}'           ORDER BY id -> SELECT id, username, attribute, value, op           FROM radcheck WHERE username = 'biryudumgida3'           ORDER BY id
>> [sql] User found in radcheck table
>> [sql]     expand: SELECT id, username, attribute, value, op           FROM radreply           WHERE username = '%{SQL-User-Name}'           ORDER BY id -> SELECT id, username, attribute, value, op           FROM radreply WHERE username = 'biryudumgida3'           ORDER BY id
>> [sql]     expand: SELECT groupname           FROM radusergroup           WHERE username = '%{SQL-User-Name}'           ORDER BY priority -> SELECT groupname           FROM radusergroup           WHERE username = 'biryudumgida3'           ORDER BY priority
>> [sql]     expand: SELECT id, groupname, attribute, Value, op           FROM radgroupcheck           WHERE groupname = '%{Sql-Group}'           ORDER BY id -> SELECT id, groupname, attribute,           Value, op           FROM radgroupcheck           WHERE groupname = 'UGR_TcellOtonomYBB-Secovid'           ORDER BY id
>> [sql] User found in group UGR_TcellOtonomYBB-Secovid
>> [sql]     expand: SELECT id, groupname, attribute, value, op           FROM radgroupreply           WHERE groupname = '%{Sql-Group}'           ORDER BY id -> SELECT id, groupname, attribute,           value, op           FROM radgroupreply           WHERE groupname = 'UGR_TcellOtonomYBB-Secovid'           ORDER BY id
>> rlm_sql (sql): Released sql socket id: 3
>> ++[sql] returns ok
>> ++[expiration] returns noop
>> ++[logintime] returns noop
>> ++[pap] returns noop
>>  WARNING: Empty pre-proxy section.  Using default return values.
>> Sending Access-Request of id 132 to 10.1.1.51 port 1812
>>    Calling-Station-Id = "905303643912"
>>    User-Name = "biryudumgida3"
>>    NAS-IP-Address = 172.30.80.1
>>    NAS-Identifier = "MTCGGSNK3"
>>    Service-Type = Framed-User
>>    Framed-Protocol = GPRS-PDP-Context
>>    NAS-Port-Type = Wireless-Other
>> ---3GPP things--
>>    Called-Station-Id = "yasarapn"
>> ---3GPP things--
>>    CHAP-Challenge = 0x2d9abfbf2d9abfbf2d9abfbf2d9abfbf
>>    CHAP-Password = 0x00ec83996af9236f1afe60dacc246bc3c4
>>    NAS-Port = 128247
>>    3GPP-Charging-Gateway-Address = 10.200.211.27
>>    Proxy-State = 0x3833
>> Proxying request 5 to home server 10.1.1.51 port 1812
>> Sending Access-Request of id 132 to 10.1.1.51 port 1812
>>    Calling-Station-Id = "905303643912"
>>    User-Name = "biryudumgida3"
>>    NAS-IP-Address = 172.30.80.1
>>    NAS-Identifier = "MTCGGSNK3"
>>    Service-Type = Framed-User
>>    Framed-Protocol = GPRS-PDP-Context
>>    NAS-Port-Type = Wireless-Other
>> ---3GPP things--
>>    Called-Station-Id = "yasarapn"
>> ---3GPP things--
>>    CHAP-Challenge = 0x2d9abfbf2d9abfbf2d9abfbf2d9abfbf
>>    CHAP-Password = 0x00ec83996af9236f1afe60dacc246bc3c4
>>    NAS-Port = 128247
>>    3GPP-Charging-Gateway-Address = 10.200.211.27
>>    Proxy-State = 0x3833
>> Going to the next request
>> Waking up in 0.9 seconds.
>> rad_recv: Access-Reject packet from host 10.1.1.51 port 1812, id=132, length=24
>>    Proxy-State = 0x3833
>> # Executing section post-proxy from file /etc/freeradius/sites-enabled/default
>> +- entering group post-proxy {...}
>> [eap] No pre-existing handler found
>> ++[eap] returns noop
>> Using Post-Auth-Type Reject
>> # Executing group from file /etc/freeradius/sites-enabled/default
>> +- entering group REJECT {...}
>> [attr_filter.access_reject]     expand: %{User-Name} -> biryudumgida3
>> attr_filter: Matched entry DEFAULT at line 11
>> ++[attr_filter.access_reject] returns updated
>> Delaying reject of request 5 for 1 seconds
>> Going to the next request
>> Waking up in 0.9 seconds.
>> Sending delayed reject for request 5
>> #####ACCESS_REJECT SEND#######
>> Sending Access-Reject of id 83 to 172.30.80.1 port 24480
>> Waking up in 4.9 seconds.
>> Cleaning up request 5 ID 83 with timestamp +905
>> Ready to process requests.
>> ######## REQ. COMES AGAIN ######
>> rad_recv: Access-Request packet from host 172.30.80.1 port 24304, id=169, length=396
>>    Calling-Station-Id = "905303643912"
>>    User-Name = "biryudumgida3"
>>    NAS-IP-Address = 172.30.80.1
>>    NAS-Identifier = "MTCGGSNK3"
>>    Service-Type = Framed-User
>>    Framed-Protocol = GPRS-PDP-Context
>>    NAS-Port-Type = Wireless-Other
>> ---3GPP things--
>>    Called-Station-Id = "yasarapn"
>> ---3GPP things--
>>    CHAP-Challenge = 0x3f10c0c03f10c0c03f10c0c03f10c0c0
>>    CHAP-Password = 0x00b66d4ff74c3480f2c1542a25e80a2339
>>    NAS-Port = 85715
>>    3GPP-Charging-Gateway-Address = 10.200.211.27
>> # Executing section authorize from file /etc/freeradius/sites-enabled/default
>> +- entering group authorize {...}
>> ++[preprocess] returns ok
>> [chap] Setting 'Auth-Type := CHAP'
>> ++[chap] returns ok
>> ++[mschap] returns noop
>> ++[digest] returns noop
>> [suffix] No '@' in User-Name = "biryudumgida3", looking up realm NULL
>> [suffix] No such realm "NULL"
>> ++[suffix] returns noop
>> [eap] No EAP-Message, not doing EAP
>> ++[eap] returns noop
>> ++[files] returns noop
>> [sql]     expand: %{User-Name} -> biryudumgida3
>> [sql] sql_set_user escaped user --> 'biryudumgida3'
>> rlm_sql (sql): Reserving sql socket id: 2
>> [sql]     expand: SELECT id, username, attribute, value, op           FROM radcheck           WHERE username = '%{SQL-User-Name}'           ORDER BY id -> SELECT id, username, attribute, value, op           FROM radcheck WHERE username = 'biryudumgida3'           ORDER BY id
>> [sql] User found in radcheck table
>> [sql]     expand: SELECT id, username, attribute, value, op           FROM radreply           WHERE username = '%{SQL-User-Name}'           ORDER BY id -> SELECT id, username, attribute, value, op           FROM radreply WHERE username = 'biryudumgida3'           ORDER BY id
>> [sql]     expand: SELECT groupname           FROM radusergroup           WHERE username = '%{SQL-User-Name}'           ORDER BY priority -> SELECT groupname           FROM radusergroup           WHERE username = 'biryudumgida3'           ORDER BY priority
>> [sql]     expand: SELECT id, groupname, attribute, Value, op           FROM radgroupcheck           WHERE groupname = '%{Sql-Group}'           ORDER BY id -> SELECT id, groupname, attribute,           Value, op           FROM radgroupcheck           WHERE groupname = 'UGR_TcellOtonomYBB-Secovid'           ORDER BY id
>> [sql] User found in group UGR_TcellOtonomYBB-Secovid
>> [sql]     expand: SELECT id, groupname, attribute, value, op           FROM radgroupreply           WHERE groupname = '%{Sql-Group}'           ORDER BY id -> SELECT id, groupname, attribute,           value, op           FROM radgroupreply           WHERE groupname = 'UGR_TcellOtonomYBB-Secovid'           ORDER BY id
>> rlm_sql (sql): Released sql socket id: 2
>> ++[sql] returns ok
>> ++[expiration] returns noop
>> ++[logintime] returns noop
>> ++[pap] returns noop
>>  WARNING: Empty pre-proxy section.  Using default return values.
>> Sending Access-Request of id 115 to 10.1.1.51 port 1812
>>    Calling-Station-Id = "905303643912"
>>    User-Name = "biryudumgida3"
>>    NAS-IP-Address = 172.30.80.1
>>    NAS-Identifier = "MTCGGSNK3"
>>    Service-Type = Framed-User
>>    Framed-Protocol = GPRS-PDP-Context
>>    NAS-Port-Type = Wireless-Other
>> ---3GPP things--
>>    Called-Station-Id = "yasarapn"
>> ---3GPP things--
>>    CHAP-Challenge = 0x3f10c0c03f10c0c03f10c0c03f10c0c0
>>    CHAP-Password = 0x00b66d4ff74c3480f2c1542a25e80a2339
>>    NAS-Port = 85715
>>    3GPP-Charging-Gateway-Address = 10.200.211.27
>>    Proxy-State = 0x313639
>> Proxying request 6 to home server 10.1.1.51 port 1812
>> Sending Access-Request of id 115 to 10.1.1.51 port 1812
>>    Calling-Station-Id = "905303643912"
>>    User-Name = "biryudumgida3"
>>    NAS-IP-Address = 172.30.80.1
>>    NAS-Identifier = "MTCGGSNK3"
>>    Service-Type = Framed-User
>>    Framed-Protocol = GPRS-PDP-Context
>>    NAS-Port-Type = Wireless-Other
>> ---3GPP things--
>>    Called-Station-Id = "yasarapn"
>> ---3GPP things--
>>    CHAP-Challenge = 0x3f10c0c03f10c0c03f10c0c03f10c0c0
>>    CHAP-Password = 0x00b66d4ff74c3480f2c1542a25e80a2339
>>    NAS-Port = 85715
>>    3GPP-Charging-Gateway-Address = 10.200.211.27
>>    Proxy-State = 0x313639
>> Going to the next request
>> Waking up in 0.9 seconds.
>> rad_recv: Access-Accept packet from host 10.1.1.51 port 1812, id=115, length=25
>>    Proxy-State = 0x313639
>> # Executing section post-proxy from file /etc/freeradius/sites-enabled/default
>> +- entering group post-proxy {...}
>> [eap] No pre-existing handler found
>> ++[eap] returns noop
>> Found Auth-Type = CHAP
>> Found Auth-Type = Accept
>> ######## THERE IS A WARNING HERE ##############
>> Warning:  Found 2 auth-types on request for user 'biryudumgida3'
>> Auth-Type = Accept, accepting the user
>> # Executing section post-auth from file /etc/freeradius/sites-enabled/default
>> +- entering group post-auth {...}
>> rlm_sql (sql): Reserving sql socket id: 1
>> [sqlippool]     expand: %{User-Name} -> biryudumgida3
>> [sqlippool] sql_set_user escaped user --> 'biryudumgida3'
>> [sqlippool]     expand: START TRANSACTION -> START TRANSACTION
>> [sqlippool]     expand: UPDATE radippool   SET nasipaddress = '', pool_key = 0,   callingstationid = '', username = '', expiry_time = NULL   WHERE expiry_time <= NOW() - INTERVAL 1 SECOND   AND nasipaddress = '%{Nas-IP-Address}' -> UPDATE radippool   SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '',   expiry_time = NULL WHERE expiry_time <= NOW() - INTERVAL 1 SECOND   AND nasipaddress = '172.30.80.1'
>> [sqlippool]     expand: SELECT framedipaddress FROM radippool WHERE pool_name = '%{control:Pool-Name}' AND (expiry_time < NOW() OR expiry_time IS NULL)  ORDER BY (username <> '%{User-Name}'),  (callingstationid <> '%{Calling-Station-Id}'),  expiry_time  LIMIT 1  FOR UPDATE -> SELECT framedipaddress FROM radippool  WHERE pool_name = 'IP_TcellOtonomYBB' AND (expiry_time < NOW() OR expiry_time IS NULL)  ORDER BY (username <> 'biryudumgida3'), (callingstationid <> '905303643912'),  expiry_time  LIMIT 1  FOR UPDATE
>> [sqlippool]     expand: UPDATE radippool  SET nasipaddress = '%{NAS-IP-Address}', pool_key = '%{NAS-Port}',  callingstationid = '%{Calling-Station-Id}', username = '%{User-Name}', expiry_time = NOW() + INTERVAL 7200 SECOND  WHERE framedipaddress = '172.30.64.190' AND expiry_time IS NULL -> UPDATE radippool  SET nasipaddress = '172.30.80.1', pool_key = '85715',  callingstationid = '905303643912', username = 'biryudumgida3',  expiry_time = NOW() + INTERVAL 7200 SECOND WHERE framedipaddress = '172.30.64.190' AND expiry_time IS NULL
>> [sqlippool] Allocated IP 172.30.64.190 [be401eac]
>> [sqlippool]     expand: COMMIT -> COMMIT
>> rlm_sql (sql): Released sql socket id: 1
>> [sqlippool]     expand: Allocated IP: %{reply:Framed-IP-Address} from %{control:Pool-Name}   (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name}) -> Allocated IP: 172.30.64.190 from IP_TcellOtonomYBB   (did yasarapn cli 905303643912 port 85715 user biryudumgida3)
>> ########## NOW ALLOCATE DIFFERENT IP TO SAME USER EVEN RELEASE TIME 7200 SEC #######
>> Allocated IP: 172.30.64.190 from IP_TcellOtonomYBB   (did yasarapn cli 905303643912 port 85715 user biryudumgida3)
>> ++[sqlippool] returns ok
>> ++[exec] returns noop
>> Sending Access-Accept of id 169 to 172.30.80.1 port 24304
>>    Framed-IP-Address = 172.30.64.190
>> Finished request 6.
>> Going to the next request
>> Waking up in 4.9 seconds.
>> Cleaning up request 6 ID 169 with timestamp +935
>> Ready to process requests.
>> 
>> On 03/03/2015 02:43 PM, Alan DeKok wrote:
>>> On Mar 3, 2015, at 3:47 AM, Tevfik Ceydeliler<tevfik.ceydeliler at astron.yasar.com.tr>  wrote:
>>>> Altough I use sqlippool adn lease time 6 hours, why one user get more than one IP?
>>>   No idea.
>>> 
>>>> Any idea? or suggestion where I look?
>>>   How about the debug output?  Which tells you when / why the user was assigned an IP address?
>>> 
>>>   I’ll note that the default configuration hands out IP addresses based on Calling-Station-Id.  And re-uses the same IP if the user logs in again with the same Calling-Station-Id.  So… the problem doesn’t seem to be the default configuration.
>>> 
>>>   Alan DeKok.
>>> 
>>> 
>>> 
>>> -
>>> List info/subscribe/unsubscribe? Seehttp://www.freeradius.org/list/users.html
>> 
>> -- 
> 
> -- 
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html



More information about the Freeradius-Users mailing list