User's Guide
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 Protocols Compatibility
Logging Authentication Packets
Logging Discarded Requests
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
Debug Logs
Using Client Tool
List of Server Errors
Maintaining RADIUS Dictionary
Basic Concepts
Wireless Authentication
Authentication Protocols
RADIUS Attributes
Example of RADIUS Packet Transactions
List of Standard RADIUS Attributes
Technical Support
Purchasing Licenses

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

SQL Data Sources

A data source is a connection to some SQL-compliant data source. These four general types of data sources are currently supported:

  • Any ODBC database;
  • Any OLE DB-compliant database;
  • MS SQL Server;
  • MS Access database.

ClearBox can work with multiple data connections simultaneously. This means that several databases can be used at the same time for different purposes. Currently data bases are used to store lists of RADIUS clients and shared secrets, user accounts (e.g. their names, passwords, optional fields), accounting records and 'authorization lists' (i.e. lists of attributes that should or should not be present in an access request packet or should be included in response packets granting access to a user).

When creating new a data source, give it a name, then define its type.

  • For MS Access database connection, you should specify a path to the database file. Optionally user name and password can be set.
  • For MS SQL Server, you define the database server (IP address of the server machine or its network name), database name and authentication credentials. Both native MS SQL server authentication and integrated Windows authentication are supported.
  • For ODBC data connection, select its system DSN and optionally a user name and a password.
  • For OLE DB data connection, specify its connection string and optionally a password.

A connection may be marked as 'delayed'. In The server connects then to the data source not at startup but at the moment when this connection is required for the first time.

By default the server is configured to use <server folder>\AAA\general.mdb MS Access database.

See how to configure a data source with Configurator.

How to create a new data connection:

1. Right-click the 'Data Sources' node in the left tree and select 'Add New Data Source':

2. Type the new data connection name instead of <new id> text:

3. Configure its settings and click 'Apply changes'.

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