sqlippool problem 2 NAS

sekchel lee sekchel at gmail.com
Mon Sep 19 14:51:59 CEST 2011


--no Problem--
nas1 (localhost)
Only one NAS login and logout No problem



--Problem--
nas1 (localhost)
nas2(remote)

Username  NASIPAddress  CalledStationId    CallingStationID
expiry_time                pool_key
  user1          127.0.0.1                                   1xx.2xx.3xx.1
2011-09-19 20:00:00      0
  user2
127.0.0.1                                   1xx.3xx.3xx.2    2011-09-29
20:21:13     10
  user3          127.0.0.1
1xx.4xx.3xx.3    2011-09-29 20:21:13      9
  user4          127.0.0.1
1xx.5xx.3xx.4    2011-09-29 20:21:13      4

Now time is 2011-09-19 20:00:00
user5 login.......

   Username  NASIPAddress  CalledStationId    CallingStationID
expiry_time                pool_key
   user1
                                                                  2011-09-19
20:00:00      0
  user2
127.0.0.1                                   1xx.3xx.3xx.2    2011-09-29
20:21:13     10
  user3          127.0.0.1
1xx.4xx.3xx.3    2011-09-29 20:21:13      9
  user4          127.0.0.1
1xx.5xx.3xx.4    2011-09-29 20:21:13      4
  user5          127.0.0.1
1xx.6xx.3xx.5    2011-09-29 20:21:13      0


NASIPAddress,CallingStationID,pool_key  is random
over time
nas1 10 user  connect
nas2 8 user  connect

but sqlippool is

Username  NASIPAddress  CalledStationId    CallingStationID
expiry_time                pool_key
  user1
                                                                  2011-09-19
20:00:00      0
  user2
127.0.0.1                                   1xx.3xx.3xx.2    2011-09-29
20:21:13     10
  user3          127.0.0.1
1xx.4xx.3xx.3    2011-09-29 20:21:13      9
  user4          127.0.0.1
1xx.5xx.3xx.4    2011-09-29 20:21:13      4
  user5          127.0.0.1
1xx.6xx.3xx.5    2011-09-29 20:21:13      0

user6
                 2011-09-19
20:00:00      0

user7
2011-09-19 20:00:00      0

user8
                 2011-09-19
20:00:00      0
  user5          127.0.0.1
1xx.9xx.3xx.9    2011-09-29 20:21:13      20
  ..
  ..

 nas1(localhost) no problem
 nas1(localhost) + nas2(remote) ==> This problem
 Help me.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20110919/41c2140d/attachment.html>


More information about the Freeradius-Users mailing list