usergroup problems with separate auth and accounting databases
Trey Scarborough
treys at door.net
Wed Aug 25 04:41:40 CEST 2010
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 = "user at 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 = "user at domain.net"
[suffix] No such realm "vortexmail.com"
++[suffix] returns noop
[sql1] expand: %{User-Name} -> user at domain.net
[sql1] sql_set_user escaped user --> 'user at 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} -> user at domain.net
[sql1] sql_set_user escaped user --> 'user at 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} -> user at domain.net
[files] sql_set_user escaped user --> 'user at 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} -> user at domain.net
[files] sql_set_user escaped user --> 'user at domain.net'
rlm_sql (sql2): Reserving sql socket id: 2
rlm_sql (sql2): Released sql socket id: 2
More information about the Freeradius-Users
mailing list