Commander Commander
Commander
172 views

smart connector for NSM 9.1.7.80

Hi,

I want to connect NSM 9.1.7.80 using the 8.1.0.8371.0 (ID-Based) connector.

The NSM database is version 5.5.5-10.3.20-MariaDB.

When I try to configure a connector, I get the following error:

Connector parameters did not pass the verification with error [0:Unable to open a connection to [jdbc:mysql://12.220.5.23:3306/lf].
(Driver:oracle.jdbc.driver.OracleDriver@93b151 returned null for URL:jdbc:mysql://12.220.5.23:3306/lf)
] for connector [a15-mcafee-ips-id]. Do you still want to continue?


1. I set up the user on the base according to the documentation for the connector.

2. I have a connection to the base. checked via telnet:

root@con1 mysql]# telnet 12.220.5.23 3306
Trying 12.220.5.23...
Connected to 12.220.5.23.
Escape character is '^]'.
]
5.5.5-10.3.20-MariaDB-log*]
]?`G$z^E!~m'u;ca>Sd|cmysql_native_passwordConnection closed by foreign host


3. I checked "mysql-connecetor-java" drivers in versions: 8.21, 5.1.40 (should be correct for the dbase).

Please help

Regards

Robert

 

 

 

 

0 Likes
1 Reply
Vice Admiral
Vice Admiral

I've been fighting JDBC connection issues myself and cannot get the connector to initialize the jdbc drivers no matter what I do. If you figure it out please post the solution here.

If you're using 8.1 version connector, then you actually need to download the IBM DB2 drivers apparently instead of the MySQL drivers. This is stated in the NSM guide under 'download mysql driver section'. But are we then still supposed to chose the mysql driver? Or DB2 driver? I cannot get either to work regardless.

Finally, I see your error references "Oracle"... Might be a simple issue of you selecting the wrong driver during connector install.
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.