informix-community

Open full view…

informixHQ over 14.10

speres
Mon, 25 Mar 2019 14:09:06 GMT

Hi, I am doing some tests over new informix version 14.10, but I am having some trouble about server configuration. I have follow the information on https://informix.hcldoc.com/14.10/help/topic/com.ibm.ifxhq.doc/informixhq.htm, but I am getting the server down. There are any specific requirements for database on informix server or configuration? Thanks for any help, SP

speres
Mon, 25 Mar 2019 21:11:05 GMT

Hi, I start the informix HQ server and when I connenct to it, it show that informixHQ server is down. On the log display I see one ERROR com.zaxxer.hikari.pool.HikariPool - InformixHQ-pool-1 - Exception during pool initialization.

I am Pradeep
Tue, 26 Mar 2019 06:28:05 GMT

Please share how you started InformixHQ server. The output from the command line will be helpful. How did you connect to InformixHQ server? You are seeing the error in a log file? Which file is that? Also, the stack for the error will be useful.

speres
Tue, 26 Mar 2019 11:48:47 GMT

My start command is: java -jar informixhq-server.jar informixhq-server.properties My properties file only have defined InitialAdminPassword My start log: 2019-03-26 11:44:32.696 [main] INFO com.informix.hq.server.JettyServer - InformixHQ Server, version 1.0.0 (build number: 311, build date: 2019-02-12T14:41:20-0600) 2019-03-26 11:44:32.698 [main] INFO com.informix.hq.server.JettyServer - Reading properties file informixhq-server.properties 2019-03-26 11:44:33.289 [main] INFO com.informix.hq.server.h2.H2Schema - H2 schema version 23 2019-03-26 11:44:33.511 [main] INFO com.informix.hq.server.alerting.AlertingIncident - Loaded 0 incidents from H2 2019-03-26 11:44:33.539 [main] INFO com.informix.hq.server.JettyServer - Loading package: /package-builtin-sensors.json 2019-03-26 11:44:34.555 [main] INFO org.eclipse.jetty.util.log - Logging initialized @2245ms 2019-03-26 11:44:34.580 [main] INFO com.informix.hq.server.JettyServer - Serving UI from JAR... 2019-03-26 11:44:34.738 [main] INFO com.informix.hq.server.JettyServer - Configuring server for HTTP on port 8080 2019-03-26 11:44:34.758 [main] INFO org.eclipse.jetty.server.Server - jetty-9.3.z-SNAPSHOT 2019-03-26 11:44:36.329 [main] INFO org.eclipse.jetty.server.handler.ContextHandler - Started o.e.j.s.ServletContextHandler@54d18072{/,jar:file:/home/informix/hq/in formixhq-server.jar!/webapp/,AVAILABLE} 2019-03-26 11:44:36.359 [main] INFO org.eclipse.jetty.server.AbstractConnector - Started ServerConnector@7fe7c640{HTTP/1.1,[http/1.1]}{0.0.0.0:8080} 2019-03-26 11:44:36.359 [main] INFO org.eclipse.jetty.server.Server - Started @4054ms 2019-03-26 11:44:36.362 [main] INFO com.informix.hq.server.jobs.RepositoryDataCleanupManager - Next runtime for data cleanup: 2019-03-27 00:00:00 when I connect thru browser is shows the following: 2019-03-26 11:46:54.506 [qtp112302969-83] INFO com.zaxxer.hikari.HikariDataSource - InformixHQ-pool-1 - Starting... 2019-03-26 11:46:56.155 [qtp112302969-83] ERROR com.zaxxer.hikari.pool.HikariPool - InformixHQ-pool-1 - Exception during pool initialization. java.sql.SQLException: com.informix.asf.IfxASFException at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1515) at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:198) at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource .java:119) at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:369) at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:198) at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:467) at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:541) at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:81) at com.informix.hq.server.informix.InformixServerConnectionPoolManager.ne wConnectionPool(InformixServerConnectionPoolManager.java:84) at com.informix.hq.server.informix.InformixServerConnectionPoolManager.do GetConnection(InformixServerConnectionPoolManager.java:106) at com.informix.hq.server.informix.InformixServerConnectionPoolManager.ge tConnection(InformixServerConnectionPoolManager.java:89) at com.informix.hq.server.informix.InformixConnector.getConnection(Inform ixConnector.java:70) at com.informix.hq.server.informix.InformixConnector.getConnection(Inform ixConnector.java:45) at com.informix.hq.server.informix.InformixServer.getMonitorConnection(In formixServer.java:267) at com.informix.hq.server.informix.InformixServer.getMonitorConnection(In formixServer.java:260) at com.informix.hq.server.rest.api.informix.ServerInfoResource.getServerS tatus(ServerInfoResource.java:125) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ...

ekuehnhausen
Tue, 26 Mar 2019 14:50:03 GMT

You haven't provided the full stack of the exception, so I can't see the original cause in the exception chain. But I can tell you that --- java.sql.SQLException: com.informix.asf.IfxASFException at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1515) --- is usually the sign of a -908 exception which means that the JDBC connection to the database server is failing. It looks like JDBC is not able to connect to the remote machine. Double check your host, port, etc. information and then check your firewall settings.

speres
Tue, 26 Mar 2019 17:03:49 GMT

I can send all the log, but I suspect that the problem is efectivelly the connection, because I only use onsocssl on the server. There are any special requirements for this kind of connection? On the previous versions I define connection on my agent.properties file, I don't see any options now, this parameters have changed? How can I get more details about this kind of errors, there is any special option? Thanks for your precious help.

ekuehnhausen
Tue, 26 Mar 2019 17:20:19 GMT

If you had set any JDBC connection properties in your URL in the agent.properties file in early versions of InformixHQ, you will now have to define these in the UI. Go to that server's "Setup" page in the UI. Underneath where you define the host, port, user, and password information for that server, there is a button to add JDBC connection properties.

speres
Tue, 26 Mar 2019 17:29:17 GMT

I have used on Ui the following setting referring to my informix: Server Name: srvinfx12_net = $INFORMIXSERVER Hostname: srvinfx12 = $hostname Port: 1526 = Informix TCP port Is this correct? On UI the server appear as offline...

speres
Tue, 26 Mar 2019 17:36:19 GMT

On the UI appears this message: [Hq](//muut.com/u/informix-community/s1/:informix-community:wvNe:hq.jpg.jpg)

ekuehnhausen
Tue, 26 Mar 2019 17:37:54 GMT

You screenshot is an indication that InformixHQ cannot connect to your database sever, which looks like the same exception as in your log file. Is the port you are connecting to using onsoctcp or onsocssl? If onsocssl, you will have to set some JDBC connection properties to configure the trust store, trust store password, etc.

speres
Tue, 26 Mar 2019 17:40:38 GMT

Can I use the previous settings, that I have used with other versions?

speres
Tue, 26 Mar 2019 17:42:00 GMT

is needed to create any database as before?

ekuehnhausen
Tue, 26 Mar 2019 17:55:22 GMT

You cannot use the old format of the agent.properties file where you specify the URL in that file. But everything you put in the URL in that file can be defined on the Setup page in the UI, so if it worked in the old version of InformixHQ, you should be able to use the same JDBC properties in the current version. I'm guessing your database question is about whether the repository database needs to exist ahead of time. The repository server and database are now also defined in the UI, on the Setup > Agent tab. That page will show you a drop down of all databases that exist on the selected repository server, so yes, your repository database needs to be defined ahead of time. You can always use the SQL page in the UI to run the "CREATE DATABASE ... " statement if you need to create one.

speres
Tue, 26 Mar 2019 18:08:59 GMT

Thanks for your reply, where or how can I define my INFORMIXSERVER? because it don't see it on connection string, is this correct? or I am doing some mistake?

ekuehnhausen
Tue, 26 Mar 2019 18:33:48 GMT

INFORMIXSERVER is not required for JDBC connections. You could as a connection property, but it's not required.

speres
Wed, 27 Mar 2019 10:23:59 GMT

Hi, I have changed my connection to use normal socket connection and everything is working now. Concerning GDPR rules I should use SSL for connections, I appreciatte if someone can send me the steps how can I do it on informixHQ. I have defined these parameters on my settings: javax.net.ssl.trustStore [/home/informix/ssl/srvinfx12_net.kdb] javax.net.ssl.trustStorePassword [/home/informix/ssl/srvinfx12_net.sth] cds.setPortNumber [1526] cds.setIfxSSLCONNECTION [true] As I have seen on IBM support site for JDBC connections over SSL, but the error still exists. Thanks for any help.

ekuehnhausen
Wed, 27 Mar 2019 15:38:02 GMT

Here are the JDBC connection property names for these: SSL_TRUSTSTORE SSL_TRUSTSTORE_PASSWORD SSLCONNECTION

speres
Wed, 27 Mar 2019 16:38:35 GMT

I defined the values as suggested and using SSL the server appear offline... Maybe I am doing some mistake! Sorry for my persistance, but I have 14 systems to install with informixHQ and I need to solve this.. How can I send the TXT agent.log?

I am Pradeep
Wed, 27 Mar 2019 19:26:25 GMT

Hi, You should be able to verify the network settings, and the SSL connectivity to the server with any Java (using JDBC driver) application. If your Java app can connect successfully communicate with the Informix server via SSL, you should be able to use the same settings with InformixHQ as well. It sounds like we will need additional info and log files from you to assist you with this. Can you please go ahead and open a support ticket?

speres
Wed, 27 Mar 2019 19:28:54 GMT

Hi, Yes I could open a ticket with IBM or HCL? My company is IBM client. Thanks for reply.

I am Pradeep
Wed, 27 Mar 2019 19:40:11 GMT

The support process remains the same as before for all IBM customers. You should be able to go to the IBM support portal and open a case.

next