Cannot connect to database when creating history chart / graphs

Related topics Copied

History Chart, Historical graphs, Active Console, Database, graphs not working

Problem Copied

• You cannot connect to the database when creating a history chart.

Possible causes Copied

• Root Cause 1 - Active Console version may be outdated or does not include the library for the particular database
• Root Cause 2 - The database is not accessible from your Active Console workstation.
• Root Cause 3 - MySQL JDBC jar file is missing. If you are using MySQL for DB logging, you need to download the MySQL from their website.

Possible solutions Copied

• Solution to Root Cause 1 - User can go to the Help > About menu, and scroll down to locate the Database support section. Please check that the respective database library is available.

Most databases are set up to be secured and only accessible from certain hosts like the Gateway host or server. Check with your network and database team if connections can be permitted from your workstation to the database.

• Solution to Root Cause 2 - A quick way to check if to perform a connection test via telnet or cURL or PowerShell’s Test-NetConnection from your Active Console workstation to the database’s host and port.

Below sample commands show successful connection from a workstation to the database’s host and port.

• telnet

C:\WINDOWS\system32>**echo quit | telnet 192.168.101.43 3306**
Welcome to Microsoft Telnet Client
Escape Character is 'CTRL+]'
C:\WINDOWS\system32>

• cURL

C:\WINDOWS\system32>**curl -v 192.168.101.43:3306**
- Rebuilt URL to: 192.168.101.43:3306/
- Trying 192.168.101.43...
- TCP_NODELAY set
- Connected to 192.168.101.43 (192.168.101.43) port 3306 (#0)

• PowerShell Test-NetConnection

PS C:\WINDOWS\system32> **Test-NetConnection -ComputerName 192.168.101.43 -Port 3306**
ComputerName : 192.168.101.43
RemoteAddress : 192.168.101.43
RemotePort : 3306
InterfaceAlias : Ethernet 4
SourceAddress : 192.168.200.1
TcpTestSucceeded : True

• Solution to Root Cause 3 - You need to download the MySQL JDBC jar and place it under ...\geneos-desktop-activeconsole-6.2.0-windows-x64\jars\JDBC then restart Active Console.

Related articles Copied

• What is a History Chart and how does it work?
• Create history charts
• When history chart is not working