Managing User Records

The Server Management Tool (SMT) uses the Sybase Database server to allow you access to add, change, or delete user records from the pre-configured database. The database can also be used with the JDBC plug-in to authenticate users using the NavisRadius servers .

The NavisRadius sample files provide a basic user file that can be edited as needed. If you have an existing user database, you can import and manage those files. The database schema is pre-configured. Any changes in the database fields are not visible in the SMT.

Before you can manage user information in the database, you must first have the Server Management Tool and the Sybase database server running. See Starting the SMT and Starting the Database Server for the procedures.

To connect to the user database

  1. Once the Server Management Tool is running and you are connected, from the resource outline, select Database > Tools User Table.
    The Authentication Database Editor connect panel appears.


  2. The SMT uses the JDBC Information dialog to allow you specify the connection information to use to find the Sybase database and log in. Default log in information is provided that allows you to connect to a locally running Sybase database server. If you want to connect to a remote database, you will need to change the appropriate JDBC configuration information.
    Accept the defaults or make any changes based on the following table, and enter the required user information:

    Property Specifies
    JAVA JDBC Class The Java JDBC class file to use when connecting and for managing user records in your database. A Sybase database and a JDBC driver is included with your NavisRadius server. To specify the JDBC driver included, use com.sybase.jdbc.SybDriver
    JDBC Connection URL The JDBC connection URL. To specify the included Sybase database and JDBC Driver for a database running on the same machine that you are running the SMT, use jdbc:sybase:Tds:localhost:2638. If you are connected to a database that is remote, replace localhost with the host name or IP address of the remote server.
    Database User Name The database administrator's user name. Default is dba
    Database Password The database administrator's password. Default is sql.

    To change database user name see Changing Database User Access.
  3. Click Connect.
    Once you are connected the empty user record panel displays in the SMT workspace.
    You will do all user record management from this panel.

Panel Layout

As you can see, the panel is divided into two work areas.

Panel Fields

Left Side-User Record Search
User Name Enter the user name to search for.
You can search for a specific user by entering an exact match in the User Name field, or use one or more characters and the percent (%) wildcard character.
For example, entering a% in the User Name field, leaving User Realm blank, the search returns all users whose name begins with the letter a. The search key is not case sensitive.
User Realm Enter the user realm to search for.
You can search for users in a specific realm by entering an exact match in the User Realm field, or use use one or more characters and the percent (%) wildcard character.
For example, entering Log% or l% in the User Realm field, leaving User Name blank, the search returns all users whose realm begins with log or l. The search key is not case sensitive.
Right Side-Display/Edit User Records
User Name Displays user information from the selected record.
User Realm
Password
Check Template Displays any information in the user record n these fields.

These three fields are place holders for user information to use to reply to the NAS client. These are free-form fields. You can enter any values you want. The details of these fields are a function of the PolicyFlow configuration you are using. See the JDBC plug-in documentation about using these fields.
Reply Template
Generic 1-5

Panel Buttons

Edit User Buttons-Right Side-Only effects the single user file displayed
Button Function
New Clears and user information displayed and Inserts a new blank record into the database.
Save Saves any changes to user record displayed.
Delete Deletes any changes to user records displayed.
Revert Displays records before any changes were made.
General Panel Buttons-Effects the database
Button Function
Import Use this to import user records from a database.
Export Use this to export a user record to a database.
Delete All Warning: This will delete ALL user records from the database.
Disconnect End the connection with the Sybase Database.
Help Displays database help documentation.

Searching for Users

To search the database

  1. Enter the search criteria in the User Name and User Realm fields.
    Note: Leaving either search field blank is equivalent to specifying a search for all records (%).
  2. Once you have entered the search criteria, click the search button.
    Records display that match the search criteria in a two column table and displays the number of records found in the status bar. If an error occurs, it also displays in the status bar.

To display a result

  1. Double-click the entry in the results table you want to display.


Importing from a User File Database

The Server Management Tool allows you to import user records from a traditional RADIUS Users file into the Sybase database.

To import a users file

  1. Click the Import button.
    The SMT displays the Import dialog box.


  2. In the User File field, you must specify the complete path and file name of the RADIUS Users file that you want to import.
    You can use the Find File... button to display a file dialog to locate your users file. The User Name field will be extracted automatically from the users file.
    For each of the other fields, you can specify which attributes from the RADIUS Users file you want to place in that database field. We have provided a few predefined fields (User Realm, Password, Check Template, Reply Template) and some generic fields for you to store data specific to your configuration.
  3. Once you have specified all the information you want, click OK.
    The SMT imports the file in two stages: reading the file and saving records. If any of these stages will be time consuming, a progress monitor is displayed so you can see its progression.
    Upon completion, the SMT displays the number of records imported.



    If an error occurs, you will see an error message.



    Any record parsing errors are written to standard out, usually back to the command prompt that you used to run the SMT.

Exporting to User File Database

The Server Management Tool allows you to export user files from your database to a traditional RADIUS Users file.

  1. To export to a users file,
  2. Click the Export button.
    The SMT displays the Export dialog.



  3. In the User File field, you must specify the complete path and file name of the RADIUS Users file the you want the SMT to create.
    You can use the Find File... button to display a file dialog to locate an existing users file.
    The User Name field will be exported automatically to the users file.
  4. For each of the other database fields, you can specify which attributes to put in the RADIUS users file for each field in that database field.
  5. Once you have specified all the information you desire, click OK.
    The SMT starts exporting records to the file. As it exports, it displays the number of records exported in the status bar. If an error occurred, you will see an error message. 

Managing User Records

To add a user to the database

  1. Click the New button.
    The user panel displays a blank user record.
  2. Based on the field descriptions above, starting with the User Name, enter the User Name and User Realm values.
    Note: The combination of values for User Name and User Realm are required to be unique.
  3. Continue to enter values for all desired fields and
  4. Click Save .
    The result of the save attempt is displayed in the status line. If the record was saved, Saved record for User Name is displayed. If the record could not be saved, an error is displayed.

To edit a user in the database

  1. Use the Searching for Users section above to find and display the record you want to change.
  2. Make all desired changes and click Save.

To remove a user from the database

  1. You must first display an existing user record from the database.
    Follow the Searching for Users discussion above to find and display the record you want to delete from the database.
  2. Once the user record is displayed, click the Delete button to remove that record from the database.
    There is no prompt to delete a single user record.
    Deletions cannot be undone.
    The result of the delete attempt is displayed in the status line. If the record was deleted, the Deleted record for User Name message appears. If the record could not be deleted, an error message appears.

To remove all users from the database

  1. To delete all the records, select Delete All.
    This option permanently removes ALL user records from your database.
  2. You are prompted to confirm the delete.
    The result of the delete attempt is displayed in the status line. If the delete operation was successful, a status message displays showing the number of records removed.

Also See

Starting the Database Server from SMT
JDBC Plug-in for more information about using the user database to authenticate users.