IP allocation problem
Tevfik Ceydeliler
tevfik.ceydeliler at astron.yasar.com.tr
Thu Mar 5 14:18:17 CET 2015
thnx for reply but not work in debug mode:
WARNING: No such configuration item pool-key
/etc/freeradius/sql/mysql/ippool.conf[62]: Reference "UPDATE
${ippool_table} SET nasipaddress = '%{NAS-IP-Address}', pool_key =
'${pool-key}', callingstationid = '%{Calling-Station-Id}', username =
'%{User-Name}', expiry_time = NOW() + INTERVAL ${lease-duration}
SECOND WHERE framedipaddress = '%I' AND expiry_time IS NULL" not found
On 03/05/2015 03:10 PM, Marcelo Santoro wrote:
> 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
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
--
More information about the Freeradius-Users
mailing list