Contents

User's Guide
Overview
What It Is
What's New
Key Features List
ClearBox Enterprise vs ClearBox
System Requirements
Purchasing Licenses
Getting Started
Quick Start
Understanding Server Components
Managing User Accounts
Configuring RADIUS Realms
Realm Settings
Realm Rules
Dynamic Realm Rules
Authentication
Authentication Protocols Compatibility
Logging Authentication Packets
Logging Discarded Requests
Authorization
Accounting
Account Log Files
Realm Settings
Configuring SQL Queries
Private RADIUS Attributes
Regular Expressions Syntax
RADIUS Clients
RADIUS Client Settings
Dynamic Clients Settings
SQL Data Sources
SQL Data Source Settings
LDAP Servers
LDAP Server Settings
Remote RADIUS Servers
Remote RADIUS Server Settings
State Servers
State Server Settings
Meta Configuration
Meta Configuration
Meta Configuration Settings
Meta Base Schema
TLS Settings
Creating SSL Certificates
Creating Server Sertificate
Requesting Server Certificate
Creating Client Certificates
Revoking a Certificate or Renewing CRL
Exporting CA Certificate
Issuing a Certificate in Active Directory CA
Remote Configuration
Advanced ISP Billing Integration
DTH Billing Integration
Platypus Billing System Intergration
OnDO SIP Server Integration
How Do I...
Wi-Fi Security
Wireless Authentication
Wi-Fi and RADIUS
Supported EAP Authentication Types
Security Considerations
10 Tips for Wireless Network Security
Administering the Server
Logging
Debug Logs
Troubleshooting
Using Client Tool
List of Server Errors
Maintaining RADIUS Dictionary
Basic Concepts
AAA
Authentication
Wireless Authentication
Authentication Protocols
Authorization
Accounting
RADIUS
RADIUS
Realms
RADIUS Proxy
RADIUS Attributes
Example of RADIUS Packet Transactions
List of Standard RADIUS Attributes
Glossary
Technical Support
Purchasing Licenses
Contacts

 
Home
ClearBox Enterprise Server 2.0 Online Manual
Prev Page Next Page
 
 
ClearBox Enterprise Serverâ„¢ 2.0. User's Guide

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.

Field Meaning Type
1 Sessions number integer

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.


© 2001-2007 XPerience Technologies. www.xperiencetech.com
Converted from CHM to HTML with chm2web Pro 2.7 (unicode)