I have to mysql configurations for one for my authentication request and
one for the accounting data. When it make a groupcheck query it is
always using the module for the accounting server is there anyway to
make this function correctly and have it use the configuration for the
authentication database.
Any Ideas of why this is happening
Here some output while doing a request sql1 is the authentication DB and
sql2 is the accounting
rad_recv: Access-Request packet from host 127.0.0.1 port 2701, id=94,
length=61
User-Name = "u...@domain.net"
CHAP-Password = 0x00000000000000000000000
+- entering group authorize {...}
++[preprocess] returns ok
[chap] Setting 'Auth-Type := CHAP'
++[chap] returns ok
++[mschap] returns noop
[suffix] Looking up realm "domain.net" for User-Name = "u...@domain.net"
[suffix] No such realm "vortexmail.com"
++[suffix] returns noop
[sql1] expand: %{User-Name} -> u...@domain.net
[sql1] sql_set_user escaped user --> 'u...@domain.net'
rlm_sql (sql1): Reserving sql socket id: 4
[sql1] expand: SELECT ..........................................
rlm_sql_mysql: query: SELECT ...................................
[sql1] User found in radcheck table
[sql1] expand: SELECT ..........................................
rlm_sql_mysql: query: SELECT ...................................
[sql1] expand: SELECT ...........................................
rlm_sql_mysql: query: SELECT....................................
[sql1] expand: SELECT ...........................................
rlm_sql_mysql: query: SELECT ..................................
[sql1] sql_groupcmp
[sql1] expand: %{User-Name} -> u...@domain.net
[sql1] sql_set_user escaped user --> 'u...@domain.net'
rlm_sql (sql2): Reserving sql socket id: 4
rlm_sql (sql2): Released sql socket id: 4
[sql1] sql_groupcmp finished: User is NOT a member of group active
Invalid operator for item Sql-Group: reverting to '=='
rlm_sql (sql1): Released sql socket id: 4
++[sql1] returns ok
[files] sql_groupcmp
[files] expand: %{User-Name} -> u...@domain.net
[files] sql_set_user escaped user --> 'u...@domain.net'
rlm_sql (sql2): Reserving sql socket id: 3
rlm_sql (sql2): Released sql socket id: 3
[files] sql_groupcmp finished: User is NOT a member of group active
[files] sql_groupcmp
[files] expand: %{User-Name} -> u...@domain.net
[files] sql_set_user escaped user --> 'u...@domain.net'
rlm_sql (sql2): Reserving sql socket id: 2
rlm_sql (sql2): Released sql socket id: 2
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
