What are the mysql databases in NFA and what are the default user names and passwords?

Document ID : KB000046391
Last Modified Date : 14/02/2018
Show Technical Document Details

Question: 

What are the mysql databases used by NFA and what are the default usernames and passwords?

 

Answer

 

The NFA Console has 1 database called 'reporter' which runs on port 3308. 

The username/password for the reporter database is netqos/netqos 

 

The Harvester has several databases listed below, along with the usernames and passwords, that run on port 3308 that hold inventory and configuration information: 

harvester - harvest/harvest 

poller - netqos/netqos 

data_retention - netqos/netqos 

 

The Harvester also has 2 databases on port 3307, which are custom mysql storage engines, in which the data is accessed through: 

archive - archive/archive 

archive15 - archive/archive 

 

Additional Information: 

-If you are attempting to login to mysql remotely you will need to use one of the username/passwords above in the format below:

-To connect to the 'reporter' database on the NFA Console server run the command:

mysql -D reporter -h <host IP address> -u netqos -p

Then enter the password 'netqos' when prompted.

-To connect to a database running on the non default port of 3307 you must specific the port using -P in the mysql syntax, for example below is how to connect to the archive15 database on a Harvester:

mysql -P3307 -D archive15 -h <host IP Address> -u archive -p

Then enter the password 'archive' when prompted.

-If you are attempting to login to mysql locally on one of the NFA servers, you will not need to enter a user or password by default, below is an example of how to login to mysql locally on a server.

mysql harvester

-Below is how to login to a database on port 3307 locally on the server:

mysql -P3307 archive

 

-If you wish to login as root, root has no password but is only available locally on each server.  Remote connections will not allow root access. To login locally to a database using root credentials, use the syntax below:

mysql reporter -u root

 

**Note we do not recommend changing the default mysql usernames as passwords, as this can cause issues with Support gathering database information via the CA RemoteEngineer, as well as it causing issues with upgrades and other product functionality.**