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