State Server Settings

This window 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' query. You should specify a query 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 attribute substitutions described here. The query should not return any rows. Empty query is allowed.

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

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

Here's the example of such query: <DELETE FROM ActiveSessions WHERE User='%u' AND NAS='{NAS-IP-Address}' AND Port={NAS-Port?0}>.

'Get concurrent sessions number' query. This query is run by the server when it needs to substitute $s in the authentication query or to check against a global concurrent sessions limit defined within a realm. You may use exactly the same syntax as in the previous queries. The query should return one row with exactly one numeric field containing the number of active sessions started by a user.

The example query: <SELECT COUNT(ID) FROM ActiveSessions WHERE User='$u'>.

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

A typical query 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.