Creating Supported DSNs

The DSNs required for GTA Reporting Suite should be set up before installation. Two DSNs must be set up on the GTAsyslog server machine: GTA Firewall and GTA Firewall Admin. The GTA Reporting Suite installation location requires only the GTA Firewall DSN.

Use a standard Windows interface to create a DSN. On a Windows 2000 system, go to Start/Control Panel/Administrative Tools and select Data Sources (ODBC). Click on the System DSN tab and choose ADD to open the Create New Datasource window. Scroll down and select the driver for your selected database. The DSN setup screen will appear.

Enter the information and save to create each of the DSNs. Click Save and exit the Data Source Administrator. The DSN descriptions will be filled by the database ODBC drivers. When complete, the DSNs will appear in the System DSN list.

The configuration of DSNs will vary by database. See below for examples and suggested settings to apply to the DSNs of three supported databases.

MySQL DSNs

Data Source

GTA Firewall

GTA Firewall Admin

Database

gta_firewall

mysql

Host/Server

 (ìlocalhostî or database IP address)

User

gnatbox

root

Port

3306

3306

PostgreSQL DSNs

Data Source

GTA Firewall

GTA Firewall Admin

Database

gta_firewall

template1

Host/Server

 (ìlocalhostî or database IP address)

User

gnatbox

admin

Port

5432

5432

SQL Server DSNs

Use the DSN wizard to create the two required DSNs for SQL server.

Data Source

GTA Firewall

GTA Firewall Admin

Database

gta_firewall

master

Host/Server

 (ìlocalhostî or database IP address)

User

gnatbox

sa

Password

gnatbox

None

Port

1433

1433

SQL Server DSN Wizard

GTA Firewall Admin DSN

  1. Create a new DSN named ìGTA Firewall Admin,î select the SQL Server driver ì(local).

  2. Check ìwith Windows SQL Server authentication...î and ìConnect to SQL Server...,î then enter ìsaî (default) or another ID in the LOGIN ID field. Leave PASSWORD field blank.

  3. Select ìChange the default database...î and enter ìmaster.î Uncheck ìAttach database filename.î Check both ìAnsi...î boxes.

  4. Check ìPerform translation for character dataî and uncheck everything else on screen.

GTA Firewall DSN

  1. Create a new DSN named ìGTA Firewall,î select the SQL Server driver ì(local).

  2. Check ìwith Windows SQL Server authentication...î and uncheck ìConnect to SQL Server....î No ID or password is entered.

  3. Select ìChange the default database...î and enter ìmaster.î Uncheck ìAttach database filename.î Check both ìAnsi...î boxes.

  4. Check ìPerform translation for character dataî and uncheck everything else on screen.

¨ Note

In GB-Commander, GB-Commander Client and GTA Reporting Suite share the database and DSNs.