State Server Settings

This dialog lets you configure a state server, a database table where the information on current user activity is stored.

State server ID. This is an arbitrary name given to the state server at its creation and uniquely identifying it. No two state servers may have equal IDs.

Data source ID. Select a configured data source where the state server information is stored and managed.

'Session is started' SQL command. You should specify a command here which adds a new record to the state server, i.e. inserts a new row in a database table on receiving Accounting-Start request.
You may use all the special symbols and RADIUS attributes described here. The command should not return any rows. Empty command is allowed.

A typical command is <INSERT INTO ActiveSessions(User,NAS,Port) VALUES('$u','{NAS-IP-Address}',{NAS-Port?0})>.

'Session is in progress' SQL command. You should specify a command here which possibly updates the state server on receiving Interim-Accounting request.
You may use all the special symbols and RADIUS attributes described here. The command should not return any rows. Empty command is allowed.

'Session is terminated' SQL command. This command removes an entry from the table when a session terminates on receiving Accounting-Stop request. You may use exactly the same syntax as in the previous command. The command should not return any rows. Empty command string is allowed.

Sample command: <DELETE FROM ActiveSessions WHERE User='$u' AND NAS='{NAS-IP-Address}' AND Port={NAS-Port?0}>.

'Get concurrent sessions number' query. This mandatory SQL command is run by the server in order to substitute $s in the authentication query with an actual value or to check against a global concurrent sessions limit defined in a realm. You may use exactly the same syntax as in the previous commands. The command should return one row with exactly one numeric field containing the number of active sessions started by a user.

Sample command: <SELECT COUNT(ID) FROM ActiveSessions WHERE User='$u'>.

'Accounting is stopped' SQL command. This SQL command is optional and is executed when the server receives Accounting-On or Accounting-Off requests. This command should clear all the entries for the NAS which is turned on or off. You may use exactly the same syntax as in the previous commands. The command should not return any rows. Empty command string is allowed.

A typical command is <DELETE FROM ActiveSessions WHERE NAS='{NAS-IP-Address}'>.

Apply Changes. Click this button after you have created the new state server or have made changes so to save them.