Step 1. Defining Database SchemaCreate new database with MS Access (we use Access 2000 in our tutorial).
Save it as C:\textext.mdb.
Create the following tables with data schema as described:
Clients
This table is filled with data by ClearBox Server administrator and contains
information about secrets which are shared by the server and its clients.
| Column name | Data type | Description |
| ID | Counter | |
| NASIP | Text(15) | IP address of a NAS for which shared secrets are stored |
| TACACShost | Boolean | Flag specifying if this is a TACACS+ shared secret
key |
| AuthenSecret | Boolean | Flag specifying whether this a secret for authentication
client or accounting (for TACACShost=false) |
| Secret | Text(50) | Secret shared with RADIUS or TACACS client |
UsersThis table is filled by ClearBox Server user and contains information about user names and passwords.
| Column name | Data type | Description |
| ID | Counter | Key field used to address a record in the table |
| Name | Text(50) | User name (or "login") |
| Password | Text(50) | User password |
| Enabled | Boolean | Flag specifying whether the user account is enabled
or disabled |
Accounting
This tabled is filled with data by ClearBox Server automatically and
contains information about user sessions.
| Column name | Data type | Description |
| ID | Counter | |
| UserID | Integer | Points to a record in Users table |
| StopTime | Date/time | Time when Stop accounting record was received |
| Elapsed | Integer | Duration of a session in seconds |
| BytesIn | Integer | Number of input bytes transferred during the connection |
| BytesOut | Integer | Number of input bytes transferred during the connection |
Go to the next step.
© 2001-2003 XPerience Technologies. www.xperiencetech.com
|