informixhq on https

Posted in 2018

Topics: Connectivity: ODBC / JDBC / .NET, Security, Permissions & Auditing, Java & JDBC Development

KAMRAN HAQ — Thu, 21 Jun 2018 13:26:40 — source: IIUG Forums & Mailing Lists

We are running informixhq server on http protocol with 2 agents connected(one agent per informix instance). Now we are trying to run the same setup using https. Sever is up and accessible over the network. But we are unable to connect agents with that server. Here are configurations for both informixhq server and agent server config ------------- initialAdminPassword=pwd123 keystore.file=/export/home/informix/ifxhq/keystore.key keystore.password=secret httpPort=8181 httpsPort=8080 redirectHTTPtoHTTPS=true agent config ------------ id=2 # url and INFORMIXDIR of the target database server to be monitored target.url=jdbc:informix-sqli://192.168.150.191:9215/sysmaster:user=informix;pas sword=Lh@qb91 target.informixdir=/u/informix12.10.FC10 # url of the repository database where monitored data should be stored repository.url=jdbc:informix-sqli://192.168.150.191:6052/monitordb:user=informix ;password=Lh@qb91 ssl.enable=true ssl.keystore.file=/export/home/informix/ifxhq/keystore.key ssl.keystore.password=secret redirectHTTPtoHTTPS=true # host and port of the InformixHQ server server.host=lhr-infomon.dom.com server.port=8080 Here are few first lines of exception we got when try to run an agent: ---------------------------------------------------------------------- -bash-4.4$ java -jar informixhq_agent.jar informixhq_agent_185.properties [main] INFO com.informix.hq.agent.MetricMonitorApplication - InformixHQ Monitoring Agent, version 0.1.0 (build date: 2018-04-19T15: 22:41-0500) [main] INFO com.informix.hq.agent.MetricMonitorApplication - Starting Monitor [main] INFO com.informix.hq.agent.MetricMonitorApplication - Attempting to connect to target database server [main] INFO com.zaxxer.hikari.HikariDataSource - pool-target - Starting... [main] ERROR com.zaxxer.hikari.pool.HikariPool - pool-target - Exception during pool initialization. java.sql.SQLException: Can't load driver java.sql.SQLException: com.informix.asf.IfxASFException: Attempt to connect to database se rver () failed. Could you please guide what could be the reason or anything missing ? regards, Kamran

↪ replying to KAMRAN HAQ

ERIC VERCELLETTO — Wed, 04 Jul 2018 12:10:09 — source: IIUG Forums & Mailing Lists

Although I don't have any detail, this looks like a problem with locating the Informix JDBC driver. Anyone from HCL monitoring this topic ?