simultaneous check - MYSQL

[Rohaizam Abu Bakar]

Dear all,

FB: 4.11
FR: 1.0.4
mysql: 4.1

>From sql.conf file, I would to add one more checking for simul. use i.e 
NAS-Port-Type...  and changes as below:- Seems working..

Just wanna confirmation regarding "simul_verify_query "...  what exactly 
this line do? I know it do verification  .. but for what purpose..

thanks..


        # Simultaneous Use Checking Queries
        #######################################################################
        # simul_count_query     - query for the number of current 
connections
        #                       - If this is not defined, no simultaneouls 
use checking
        #                       - will be performed by this module instance
        # simul_verify_query    - query to return details of current 
connections for verification
        #                       - Leave blank or commented out to disable 
verification step
        #                       - Note that the returned field order should 
not be changed.
        #######################################################################

        # Uncomment simul_count_query to enable simultaneous use checking
        # simul_count_query = "SELECT COUNT(*) FROM ${acct_table1} WHERE 
UserName='%{SQL-User-Name}' AND Acct
StopTime = 0"
        ##simul_count_query = "SELECT COUNT(*) FROM ${acct_table1} WHERE 
UserName='%{SQL-User-Name}' AND Acct
StopTime = 0"
        simul_count_query = "SELECT COUNT(*) FROM ${acct_table1} WHERE 
UserName='%{SQL-User-Name}' AND NASPor
tType = '%{NAS-Port-Type}' AND AcctStopTime = 0"
        ##simul_verify_query = "SELECT RadAcctId, AcctSessionId, UserName, 
NASIPAddress, NASPortId, FramedIPA
ddress, CallingStationId, FramedProtocol FROM ${acct_table1} WHERE 
UserName='%{SQL-User-Name}' AND AcctStopTi
me = 0"
        simul_verify_query = "SELECT RadAcctId, AcctSessionId, UserName, 
NASIPAddress, NASPortId, FramedIPAdd
ress, CallingStationId, FramedProtocol FROM ${acct_table1} WHERE 
UserName='%{SQL-User-Name}' AND NASPortType
= '%{NAS-Port-Type}' AND AcctStopTime = 0"