SV: reading hosts from NAS table not working on 2.2.6?

Alexander Silveröhrt Alexander.Silverohrt at itux.se
Fri May 1 06:51:14 CEST 2015


Same problem after recompiling and installing freeradius-server-2.x.x. from git

I guess? Since all clients got ignored for this VR server at start...i guess it makes sense it rejects the request.. It would have made sense if a request worked for the first VR server that actually didn't ignore the clients following the debug in my earlier email? But now i tested that as well and all VR servers ignores all requests read from the NAS.

Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Processing generate_sql_clients
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng) in generate_sql_clients: query is SELECT id, nasname, shortname, type, secret, server FROM nas
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Reserving sql socket id: 49
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Read entry nasname=192.168.6.78,shortname=sth0-labb0-bng0,secret=cisco
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Adding client 192.168.6.78 (sth0-labb0-bng0, server=cisco-bng) to clients list
Fri May  1 06:34:43 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.78
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Read entry nasname=192.168.6.22,shortname=gbg1-ser1,secret=cisco
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Adding client 192.168.6.22 (gbg1-ser1, server=cisco-bng) to clients list
Fri May  1 06:34:43 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.22
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Read entry nasname=192.168.6.20,shortname=mlm0-ser0,secret=redback
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Adding client 192.168.6.20 (mlm0-ser0, server=smartedge-bng) to clients list
Fri May  1 06:34:43 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.20
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Read entry nasname=192.168.6.5,shortname=labb0,secret=redback
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Adding client 192.168.6.5 (labb0, server=smartedge-bng) to clients list
Fri May  1 06:34:43 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.5
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Read entry nasname=192.168.6.23,shortname=mlm0-ser0,secret=cisco
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Adding client 192.168.6.23 (mlm0-ser0, server=cisco-bng) to clients list
Fri May  1 06:34:43 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.23
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Read entry nasname=192.168.6.24,shortname=fl0-ser0,secret=cisco
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Adding client 192.168.6.24 (fl0-ser0, server=cisco-bng) to clients list
Fri May  1 06:34:43 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.24
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Read entry nasname=10.11.12.222,shortname=fl0-ser1,secret=redback
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Adding client 10.11.12.222 (fl0-ser1, server=smartedge-bng) to clients list
Fri May  1 06:34:43 2015 : Debug: WARNING: Ignoring duplicate client 10.11.12.222
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Read entry nasname=192.168.6.13/32,shortname=ids-72-cr0,secret=testing123
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Adding client 192.168.6.13 (ids-72-cr0, server=asr-bng) to clients list
Fri May  1 06:34:43 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.13
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Read entry nasname=192.168.6.14/32,shortname=ids-72-cr1,secret=testing123
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Adding client 192.168.6.14 (ids-72-cr1, server=asr-bng) to clients list
Fri May  1 06:34:43 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.14
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Read entry nasname=192.168.6.25,shortname=sth0-ser0,secret=cisco
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Adding client 192.168.6.25 (sth0-ser0, server=cisco-bng) to clients list
Fri May  1 06:34:43 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.25
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Read entry nasname=192.168.5.101,shortname=gbg0-lb0,secret=redback
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Adding client 192.168.5.101 (gbg0-lb0, server=smartedge-bng) to clients list
Fri May  1 06:34:43 2015 : Debug: WARNING: Ignoring duplicate client 192.168.5.101
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Read entry nasname=192.168.6.26,shortname=gbg0-ser1,secret=cisco
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Adding client 192.168.6.26 (gbg0-ser1, server=cisco-bng) to clients list
Fri May  1 06:34:43 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.26
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Read entry nasname=192.168.6.40,shortname=labb1,secret=cisco
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Adding client 192.168.6.40 (labb1, server=cisco-bng) to clients list
Fri May  1 06:34:43 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.40
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Read entry nasname=192.168.6.27,shortname=sv0-ser0,secret=cisco
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Adding client 192.168.6.27 (sv0-ser0, server=cisco-bng) to clients list
Fri May  1 06:34:43 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.27
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Read entry nasname=192.168.6.28,shortname=gbg0-ser2,secret=cisco
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Adding client 192.168.6.28 (gbg0-ser2, server=cisco-bng) to clients list
Fri May  1 06:34:43 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.28
Fri May  1 06:34:43 2015 : Debug: rlm_sql (sql-smartedge-bng): Released sql socket id: 49
Fri May  1 06:34:43 2015 : Info: Ready to process requests.

#####
root at itop1:/usr/local/etc/raddb/sites-enabled# echo "User-Name = 'alex_smartedge', NAS-Identifier = 'labb0', NAS-IP-Address = '10.173.5.11'" | radclient -x -s -c 1 -r 1 -t 3  10.173.5.11:1812 auth redback
Sending Access-Request of id 169 to 10.173.5.11 port 1812
        User-Name = "alex_smartedge"
        NAS-Identifier = "labb0"
        NAS-IP-Address = 10.173.5.11
radclient: no response from server for ID 169 socket 3

           Total approved auths:  0
             Total denied auths:  0
               Total lost auths:  1

##### Rad debug
Fri May  1 06:35:22 2015 : Error: Ignoring request to authentication address 10.173.5.11 port 1812 from unknown client 10.173.5.11 port 36790
Fri May  1 06:35:22 2015 : Info: Ready to process requests.
^C

###freeradius-server-2.x.x.
/usr/local/lib/libfreeradius-radius-020208.so



Best regards
Alex
________________________________________
Från: Freeradius-Users [freeradius-users-bounces+alexander.silverohrt=itux.se at lists.freeradius.org] för Alexander Silveröhrt [Alexander.Silverohrt at itux.se]
Skickat: den 1 maj 2015 05:31
Till: FreeRadius users mailing list
Ämne: SV: reading hosts from NAS table not working on 2.2.6?

I will try the fix soon..

With a basic with no VR servers the NAS table is read and used and its working.

### radius debug
Fri May  1 05:22:36 2015 : Info: rlm_sql (sql): Connected new DB handle, #29
Fri May  1 05:22:36 2015 : Debug: rlm_sql (sql): Processing generate_sql_clients
Fri May  1 05:22:36 2015 : Debug: rlm_sql (sql) in generate_sql_clients: query is SELECT id, nasname, shortname, type, secret, server FROM nas
Fri May  1 05:22:36 2015 : Debug: rlm_sql (sql): Reserving sql socket id: 29
Fri May  1 05:22:36 2015 : Debug: rlm_sql (sql): Read entry nasname=10.173.5.11,shortname=labb0,secret=redback
Fri May  1 05:22:36 2015 : Debug: rlm_sql (sql): Adding client 10.173.5.11 (labb0, server=<none>) to clients list
Fri May  1 05:22:36 2015 : Debug: rlm_sql (sql): Released sql socket id: 29

###
echo "User-Name = 'alex_smartedge', NAS-Identifier = 'labb0', NAS-IP-Address = '10.173.5.11'" | radclient -x -s -c 1 -r 1 -t 3  10.173.5.11:1812 auth redback
Sending Access-Request of id 62 to 10.173.5.11 port 1812
        User-Name = "alex_smartedge"
        NAS-Identifier = "labb0"
        NAS-IP-Address = 10.173.5.11
rad_recv: Access-Accept packet from host 10.173.5.11 port 1812, id=62, length=115
        Qos-Metering-Profile-Name = "default_qos_metering_policy"
        DHCP-Max-Leases = 1
        Qos-Policing-Profile-Name = "default_qos_policing_policy"
        Context-Name = "BASIC"

           Total approved auths:  1
             Total denied auths:  0
               Total lost auths:  0


### radius debug
rad_recv: Access-Request packet from host 10.173.5.11 port 49659, id=62, length=49
        User-Name = "alex_smartedge"
        NAS-Identifier = "labb0"
        NAS-IP-Address = 10.173.5.11

Sending Access-Accept of id 62 to 10.173.5.11 port 49659
        Qos-Metering-Profile-Name = "default_qos_metering_policy"
        DHCP_Max_Leases = 1
        Qos-Policing-Profile-Name = "default_qos_policing_policy"
        Context-Name = "BASIC"


Also noticed this new behaviour that each VR server checks the NAS table and then checks the other VR servers hosts as well and only ads clients to current VR server if the hosts doesn't exist in other VR servers  or a shared variable?(at least thats what it looks like from the debug)..? Why is that there? Its a VR server? Shouldn't it be independant and be able to use its on set of hosts no matter they exist in other VR servers or in a global variable or not?

Here is a log from a 3 VR server setup. First is working and reads the hosts from the NAS table the rest seems to be ignored

.
.

Fri May  1 04:44:17 2015 : Info: rlm_sql (sql-cisco-bng): Attempting to connect rlm_sql_mysql #49
Fri May  1 04:44:17 2015 : Info: rlm_sql_mysql: Starting connect to MySQL server for #49
Fri May  1 04:44:17 2015 : Info: rlm_sql (sql-cisco-bng): Connected new DB handle, #49
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Processing generate_sql_clients
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng) in generate_sql_clients: query is SELECT id, nasname, shortname, type, secret, server FROM nas
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Reserving sql socket id: 49
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Read entry nasname=192.168.6.78,shortname=sth0-labb0-bng0,secret=cisco
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Adding client 192.168.6.78 (sth0-labb0-bng0, server=cisco-bng) to clients list
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Read entry nasname=192.168.6.22,shortname=gbg1-ser1,secret=cisco
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Adding client 192.168.6.22 (gbg1-ser1, server=cisco-bng) to clients list
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Read entry nasname=192.168.6.20,shortname=mlm0-ser0,secret=redback
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Adding client 192.168.6.20 (mlm0-ser0, server=smartedge-bng) to clients list
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Read entry nasname=192.168.6.5,shortname=labb0,secret=redback
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Adding client 192.168.6.5 (labb0, server=smartedge-bng) to clients list
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Read entry nasname=192.168.6.23,shortname=mlm0-ser0,secret=cisco
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Adding client 192.168.6.23 (mlm0-ser0, server=cisco-bng) to clients list
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Read entry nasname=192.168.6.24,shortname=fl0-ser0,secret=cisco
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Adding client 192.168.6.24 (fl0-ser0, server=cisco-bng) to clients list
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Read entry nasname=10.11.12.222,shortname=fl0-ser1,secret=redback
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Adding client 10.11.12.222 (fl0-ser1, server=smartedge-bng) to clients list
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Read entry nasname=192.168.6.13/32,shortname=ids-72-cr0,secret=testing123
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Adding client 192.168.6.13 (ids-72-cr0, server=asr-bng) to clients list
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Read entry nasname=192.168.6.14/32,shortname=ids-72-cr1,secret=testing123
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Adding client 192.168.6.14 (ids-72-cr1, server=asr-bng) to clients list
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Read entry nasname=192.168.6.25,shortname=sth0-ser0,secret=cisco
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Adding client 192.168.6.25 (sth0-ser0, server=cisco-bng) to clients list
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Read entry nasname=192.168.5.101,shortname=gbg0-lb0,secret=redback
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Adding client 192.168.5.101 (gbg0-lb0, server=smartedge-bng) to clients list
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Read entry nasname=192.168.6.26,shortname=gbg0-ser1,secret=cisco
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Adding client 192.168.6.26 (gbg0-ser1, server=cisco-bng) to clients list
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Read entry nasname=192.168.6.40,shortname=labb1,secret=cisco
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Adding client 192.168.6.40 (labb1, server=cisco-bng) to clients list
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Read entry nasname=192.168.6.27,shortname=sv0-ser0,secret=cisco
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Adding client 192.168.6.27 (sv0-ser0, server=cisco-bng) to clients list
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Read entry nasname=192.168.6.28,shortname=gbg0-ser2,secret=cisco
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Adding client 192.168.6.28 (gbg0-ser2, server=cisco-bng) to clients list
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-cisco-bng): Released sql socket id: 49

.
.
.
.
Fri May  1 04:44:17 2015 : Info: rlm_sql (sql-asr-bng): Attempting to connect rlm_sql_mysql #49
Fri May  1 04:44:17 2015 : Info: rlm_sql_mysql: Starting connect to MySQL server for #49
Fri May  1 04:44:17 2015 : Info: rlm_sql (sql-asr-bng): Connected new DB handle, #49
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Processing generate_sql_clients
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng) in generate_sql_clients: query is SELECT id, nasname, shortname, type, secret, server FROM nas
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Reserving sql socket id: 49
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Read entry nasname=192.168.6.78,shortname=sth0-labb0-bng0,secret=cisco
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Adding client 192.168.6.78 (sth0-labb0-bng0, server=cisco-bng) to clients list
Fri May  1 04:44:17 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.78
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Read entry nasname=192.168.6.22,shortname=gbg1-ser1,secret=cisco
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Adding client 192.168.6.22 (gbg1-ser1, server=cisco-bng) to clients list
Fri May  1 04:44:17 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.22
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Read entry nasname=192.168.6.20,shortname=mlm0-ser0,secret=redback
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Adding client 192.168.6.20 (mlm0-ser0, server=smartedge-bng) to clients list
Fri May  1 04:44:17 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.20
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Read entry nasname=192.168.6.5,shortname=labb0,secret=redback
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Adding client 192.168.6.5 (labb0, server=smartedge-bng) to clients list
Fri May  1 04:44:17 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.5
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Read entry nasname=192.168.6.23,shortname=mlm0-ser0,secret=cisco
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Adding client 192.168.6.23 (mlm0-ser0, server=cisco-bng) to clients list
Fri May  1 04:44:17 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.23
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Read entry nasname=192.168.6.24,shortname=fl0-ser0,secret=cisco
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Adding client 192.168.6.24 (fl0-ser0, server=cisco-bng) to clients list
Fri May  1 04:44:17 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.24
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Read entry nasname=10.11.12.222,shortname=fl0-ser1,secret=redback
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Adding client 10.11.12.222 (fl0-ser1, server=smartedge-bng) to clients list
Fri May  1 04:44:17 2015 : Debug: WARNING: Ignoring duplicate client 10.11.12.222
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Read entry nasname=192.168.6.13/32,shortname=ids-72-cr0,secret=testing123
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Adding client 192.168.6.13 (ids-72-cr0, server=asr-bng) to clients list
Fri May  1 04:44:17 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.13
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Read entry nasname=192.168.6.14/32,shortname=ids-72-cr1,secret=testing123
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Adding client 192.168.6.14 (ids-72-cr1, server=asr-bng) to clients list
Fri May  1 04:44:17 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.14
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Read entry nasname=192.168.6.25,shortname=sth0-ser0,secret=cisco
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Adding client 192.168.6.25 (sth0-ser0, server=cisco-bng) to clients list
Fri May  1 04:44:17 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.25
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Read entry nasname=192.168.5.101,shortname=gbg0-lb0,secret=redback
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Adding client 192.168.5.101 (gbg0-lb0, server=smartedge-bng) to clients list
Fri May  1 04:44:17 2015 : Debug: WARNING: Ignoring duplicate client 192.168.5.101
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Read entry nasname=192.168.6.26,shortname=gbg0-ser1,secret=cisco
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Adding client 192.168.6.26 (gbg0-ser1, server=cisco-bng) to clients list
Fri May  1 04:44:17 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.26
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Read entry nasname=192.168.6.40,shortname=labb1,secret=cisco
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Adding client 192.168.6.40 (labb1, server=cisco-bng) to clients list
Fri May  1 04:44:17 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.40
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Read entry nasname=192.168.6.27,shortname=sv0-ser0,secret=cisco
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Adding client 192.168.6.27 (sv0-ser0, server=cisco-bng) to clients list
Fri May  1 04:44:17 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.27
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Read entry nasname=192.168.6.28,shortname=gbg0-ser2,secret=cisco
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Adding client 192.168.6.28 (gbg0-ser2, server=cisco-bng) to clients list
Fri May  1 04:44:17 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.28
Fri May  1 04:44:17 2015 : Debug: rlm_sql (sql-asr-bng): Released sql socket id: 49

.
.
.
.
Fri May  1 04:44:18 2015 : Info: rlm_sql (sql-smartedge-bng): Connected new DB handle, #49
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Processing generate_sql_clients
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng) in generate_sql_clients: query is SELECT id, nasname, shortname, type, secret, server FROM nas
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Reserving sql socket id: 49
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Read entry nasname=192.168.6.78,shortname=sth0-labb0-bng0,secret=cisco
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Adding client 192.168.6.78 (sth0-labb0-bng0, server=cisco-bng) to clients list
Fri May  1 04:44:18 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.78
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Read entry nasname=192.168.6.22,shortname=gbg1-ser1,secret=cisco
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Adding client 192.168.6.22 (gbg1-ser1, server=cisco-bng) to clients list
Fri May  1 04:44:18 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.22
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Read entry nasname=192.168.6.20,shortname=mlm0-ser0,secret=redback
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Adding client 192.168.6.20 (mlm0-ser0, server=smartedge-bng) to clients list
Fri May  1 04:44:18 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.20
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Read entry nasname=192.168.6.5,shortname=labb0,secret=redback
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Adding client 192.168.6.5 (labb0, server=smartedge-bng) to clients list
Fri May  1 04:44:18 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.5
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Read entry nasname=192.168.6.23,shortname=mlm0-ser0,secret=cisco
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Adding client 192.168.6.23 (mlm0-ser0, server=cisco-bng) to clients list
Fri May  1 04:44:18 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.23
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Read entry nasname=192.168.6.24,shortname=fl0-ser0,secret=cisco
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Adding client 192.168.6.24 (fl0-ser0, server=cisco-bng) to clients list
Fri May  1 04:44:18 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.24
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Read entry nasname=10.11.12.222,shortname=fl0-ser1,secret=redback
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Adding client 10.11.12.222 (fl0-ser1, server=smartedge-bng) to clients list
Fri May  1 04:44:18 2015 : Debug: WARNING: Ignoring duplicate client 10.11.12.222
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Read entry nasname=192.168.6.13/32,shortname=ids-72-cr0,secret=testing123
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Adding client 192.168.6.13 (ids-72-cr0, server=asr-bng) to clients list
Fri May  1 04:44:18 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.13
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Read entry nasname=192.168.6.14/32,shortname=ids-72-cr1,secret=testing123
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Adding client 192.168.6.14 (ids-72-cr1, server=asr-bng) to clients list
Fri May  1 04:44:18 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.14
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Read entry nasname=192.168.6.25,shortname=sth0-ser0,secret=cisco
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Adding client 192.168.6.25 (sth0-ser0, server=cisco-bng) to clients list
Fri May  1 04:44:18 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.25
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Read entry nasname=192.168.5.101,shortname=gbg0-lb0,secret=redback
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Adding client 192.168.5.101 (gbg0-lb0, server=smartedge-bng) to clients list
Fri May  1 04:44:18 2015 : Debug: WARNING: Ignoring duplicate client 192.168.5.101
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Read entry nasname=192.168.6.26,shortname=gbg0-ser1,secret=cisco
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Adding client 192.168.6.26 (gbg0-ser1, server=cisco-bng) to clients list
Fri May  1 04:44:18 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.26
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Read entry nasname=192.168.6.40,shortname=labb1,secret=cisco
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Adding client 192.168.6.40 (labb1, server=cisco-bng) to clients list
Fri May  1 04:44:18 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.40
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Read entry nasname=192.168.6.27,shortname=sv0-ser0,secret=cisco
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Adding client 192.168.6.27 (sv0-ser0, server=cisco-bng) to clients list
Fri May  1 04:44:18 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.27
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Read entry nasname=192.168.6.28,shortname=gbg0-ser2,secret=cisco
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Adding client 192.168.6.28 (gbg0-ser2, server=cisco-bng) to clients list
Fri May  1 04:44:18 2015 : Debug: WARNING: Ignoring duplicate client 192.168.6.28
Fri May  1 04:44:18 2015 : Debug: rlm_sql (sql-smartedge-bng): Released sql socket id: 49

The only way to get around this was to create 3 different NAS tables one for each VR server and not use hosts that existed in the other tables.   Then there was no warningsand  hosts got read correctly but all requests still ignored of course.


Will see if your fix solved things now.

Best regards
Alex


________________________________________
Från: Freeradius-Users [freeradius-users-bounces+alexander.silverohrt=itux.se at lists.freeradius.org] för A.L.M.Buxey at lboro.ac.uk [A.L.M.Buxey at lboro.ac.uk]
Skickat: den 1 maj 2015 00:40
Till: FreeRadius users mailing list
Ämne: Re: reading hosts from NAS table not working on 2.2.6?

Hi,

>   How many listen sections do you have?  Where else are your clients defined?

just the one. in the main radiusd.conf   (well, i have the listen {} in buffered-sql, control-socket and
inner-tunnel)

>   My guess is that you don't have a "listen" section associated with the virtual server.  But you do have a global "listen" section, which has its own set of clients.  So when you add clients to the virtual server, they aren't used by any "listen" section.

right

>   If you have a "listen" section tied to a virtual server, then the clients from SQL will be associated with that virtual server, and the associated "listen" section will pick them up.  That's what didn't work in 2.2.4.

yes - this was to allow duplicate clients to be defined differently in seperate virtual servers  (which isnt something
I want/need ;-) )

>   I supposed I could fix the code so that if there's no "listen" section in a virtual server, then the client is associated with the global list of clients.  That's easy enough to do, and probably meets most peoples expectations.

that sounds about right....to ensure behaviour stays the same as you migrate from earlier 2.x releases

alan
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

********* DISCLAIMER *********

This message and any attachment are confidential and may be privileged or otherwise protected from disclosure and may include proprietary information. If you are not the intended recipient, please telephone or email the sender and delete this message and any attachment from your system. If you are not the intended recipient you must not copy this message or attachment or disclose the contents to any other person

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

********* DISCLAIMER *********

This message and any attachment are confidential and may be privileged or otherwise protected from disclosure and may include proprietary information. If you are not the intended recipient, please telephone or email the sender and delete this message and any attachment from your system. If you are not the intended recipient you must not copy this message or attachment or disclose the contents to any other person



More information about the Freeradius-Users mailing list