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.
Data Source |
GTA Firewall |
GTA Firewall Admin |
Database |
gta_firewall |
mysql |
Host/Server |
(ìlocalhostî or database IP address) |
|
User |
gnatbox |
root |
Port |
3306 |
3306 |
Data Source |
GTA Firewall |
GTA Firewall Admin |
Database |
gta_firewall |
template1 |
Host/Server |
(ìlocalhostî or database IP address) |
|
User |
gnatbox |
admin |
Port |
5432 |
5432 |
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 |
Create a new DSN named ìGTA Firewall Admin,î select the SQL Server driver ì(local).
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.
Select ìChange the default database...î and enter ìmaster.î Uncheck ìAttach database filename.î Check both ìAnsi...î boxes.
Check ìPerform translation for character dataî and uncheck everything else on screen.
Create a new DSN named ìGTA Firewall,î select the SQL Server driver ì(local).
Check ìwith Windows SQL Server authentication...î and uncheck ìConnect to SQL Server....î No ID or password is entered.
Select ìChange the default database...î and enter ìmaster.î Uncheck ìAttach database filename.î Check both ìAnsi...î boxes.
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.