Info: No Pool-Name defined. Trying to add new APN
Sophie Loewenthal
sophie.loewenthal at trimbletl.com
Tue Sep 15 10:02:04 CEST 2015
Hi guys,
I have been trying to work out why our new APN cannot have any
IP addresses allocated. The IP addresses should come from an existing
pool already in use by other APNs. I've inherited this from since
departed colleagues. I did post this a earlier but thought I should
start a fresh thread with debug infomation.
FreeRadius package is : freeradius-2.1.12-1.el6.x86_64 / Centos 6
The user name is 0TESTUSER1
The new APN is m2m.vod.trim.com
In the users file I added ,
DEFAULT NAS-IP-Address == 195.123.123.0, Pool-Name := vodafone
DEFAULT NAS-IP-Address == 195.123.123.50, Pool-Name := vodafone
DEFAULT NAS-IP-Address == 195.123.123.51, Pool-Name := vodafone
DEFAULT NAS-IP-Address == 195.123.123.52, Pool-Name := vodafone
DEFAULT NAS-IP-Address == 195.123.123.53, Pool-Name := vodafone
DEFAULT NAS-IP-Address == 195.123.123.54, Pool-Name := vodafone
The first line already worked with another APN with IP addresses assigned.
When I tried to authenticate with our new SIM and APN log in worked but
no pool was defined.
Tue Sep 15 09:42:25 2015 : Auth: Login OK: [0TESTUSER1] (from client
vodafone-nas-m2m-51 port 511026 cli 882393728079768)
Tue Sep 15 09:42:25 2015 : Info: No Pool-Name defined (did
m2m.vod.trim.com cli 882393728079768 port 511026 user 0TESTUSER1)
Debug: I ran in debug to see if I could get any more info and you'll
find thus below.
I'd be grateful if somebody would let me know how I mend this, or point
me the right direction?
Thanks and kind regards,
Sophie
[sql] expand: UPDATE radacct SET acctstoptime =
'%S', acctsessiontime =
'%{Acct-Session-Time}', acctinputoctets =
'%{%{Acct-Input-Gigawords}:-0}' << 32 |
'%{%{Acct-Input-Octets}:-0}', acctoutputoctets =
'%{%{Acct-Output-Gigawords}:-0}' << 32 |
'%{%{Acct-Output-Octets}:-0}', acctterminatecause =
'%{Acct-Terminate-Cause}', acctstopdelay =
'%{%{Acct-Delay-Time}:-0}', connectinfo_stop =
'%{Connect-Info}' WHERE acctsessionid =
'%{Acct-Session-Id}' AND username =
'%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}'
-> UPDATE radacct SET acctstoptime =
'2015-09-15 09:46:13', acctsessiontime =
'510', acctinputoctets = '0' << 32
| '2643', acctoutputoctets = '0' << 32 |
rlm_sql (sql): Reserving sql socket id: 0
rlm_sql (sql): Released sql socket id: 0
++[sql] returns ok
++[exec] returns noop
[attr_filter.accounting_response] expand: %{User-Name} -> 000005a8a
attr_filter: Matched entry DEFAULT at line 12
++[attr_filter.accounting_response] returns updated
Finished request 128.
Going to the next request
Thread 4 waiting to be assigned a request
Waking up in 0.6 seconds.
Thread 5 got semaphore
Thread 5 handling request 129, (17 handled so far)
[<thread>] # Executing section authorize from file
/etc/raddb/sites-enabled/default
[<thread>] +- entering group authorize {...}
++[preprocess] returns ok
++[chap] returns noop
++[digest] returns noop
[eap] No EAP-Message, not doing EAP
++[eap] returns noop
[files] users: Matched entry DEFAULT at line 228
++[files] returns ok
[sql] expand: %{User-Name} -> 0TESTUSER1
[sql] sql_set_user escaped user --> '0TESTUSER1'
rlm_sql (sql): Reserving sql socket id: 23
[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 = '0TESTUSER1' 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 = '0TESTUSER1' ORDER BY id
[sql] expand: SELECT groupname FROM radusergroup
WHERE username = '%{SQL-User-Name}' ORDER BY priority ->
SELECT groupname FROM radusergroup WHERE username =
'0TESTUSER1' 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 =
'm2m.vod.trim.com' ORDER BY id
[sql] User found in group m2m.vod.trim.com
[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 =
'm2m.vod.trim.com' ORDER BY id
rlm_sql (sql): Released sql socket id: 23
++[sql] returns ok
++[expiration] returns noop
++[logintime] returns noop
++[pap] returns updated
Found Auth-Type = PAP
# Executing group from file /etc/raddb/sites-enabled/default
+- entering group PAP {...}
[pap] login attempt with password "F8BB45FCDC59995EE2C12A96E10B1091"
[pap] Using clear text password "F8BB45FCDC59995EE2C12A96E10B1091"
[pap] User authenticated successfully
++[pap] returns ok
Login OK: [0TESTUSER1] (from client vodafone-nas-m2m-51 port 443593 cli
882393728079768)
# Executing section post-auth from file /etc/raddb/sites-enabled/default
+- entering group post-auth {...}
[sqlippool] No Pool-Name defined.
[sqlippool] expand: No Pool-Name defined (did %{Called-Station-Id}
cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name}) -> No
Pool-Name defined (did m2m.vod.trim.com cli 882393728079768 port 443593
user 0TESTUSER1)
No Pool-Name defined (did m2m.vod.trim.com cli 882393728079768 port
443593 user 0TESTUSER1)
++[sqlippool] returns noop
[sql] expand: %{User-Name} -> 0TESTUSER1
[sql] sql_set_user escaped user --> '0TESTUSER1'
[sql] expand: %{User-Password} -> F8BB45FCDC59995EE2C12A96E10B1091
[sql] expand: INSERT INTO radpostauth
(username, pass, reply, authdate) VALUES (
'%{User-Name}', '%{%{User-Password}:-%{Chap-Password}}',
'%{reply:Packet-Type}', '%S') -> INSERT INTO
radpostauth (username, pass, reply,
authdate) VALUES ( '0TESTUSER1',
'F8BB45FCDC59995EE2C12A96E10B1091', 'Access-Accept', '2015-09-15 09:46:13')
rlm_sql (sql) in sql_postauth: query is INSERT INTO
radpostauth (username, pass, reply,
authdate) VALUES ( '0TESTUSER1',
'F8BB45FCDC59995EE2C12A96E10B1091', 'Access-Accept', '2015-09-15 09:46:13')
rlm_sql (sql): Reserving sql socket id: 22
rlm_sql (sql): Released sql socket id: 22
++[sql] returns ok
++[exec] returns noop
Finished request 129.
Going to the next request
Thread 5 waiting to be assigned a request
Waking up in 0.5 seconds.
Thread 6 got semaphore
Thread 6 handling request 130, (17 handled so far)
[<thread>] # Executing section authorize from file
/etc/raddb/sites-enabled/default
[<thread>] +- entering group authorize {...}
++[preprocess] returns ok
++[chap] returns noop
++[digest] returns noop
[eap] No EAP-Message, not doing EAP
++[eap] returns noop
[files] users: Matched entry DEFAULT at line 207
++[files] returns ok
[sql] expand: %{User-Name} -> 357541001195173
[sql] sql_set_user escaped user --> '357541001195173'
rlm_sql (sql): Reserving sql socket id: 21
------------------------------------- END OF EMAIL
---------------------------------------------------
More information about the Freeradius-Users
mailing list