GAX installation with SQL DB instance

[bilge]

Hello all,

I'm trying to install Genesys Administrator Extension on Microsoft Server 2012. The database is MSSQL 2012 with a db instance. We installed GAX several times successfully where the database does not have an instance. When the GAX URL is called, the login page opens. After entering the credentials, main GAX page does not load.

Is there any consideration that I need to take when I have an instanced database? I guess there need to be a jdbcurl option somewhere in the GAXDAP. I post the GAX log, problem is the error in SQL connection. When I connect the same GAX to a db without instance, it works well.

2017-05-31 09:01:27,017 DEBUG: com.genesyslab.gax.core.web.HttpHeaderFilter [main] - [177] Initializing filter 'headerFilter'
2017-05-31 09:01:27,017 DEBUG: com.genesyslab.gax.core.web.HttpHeaderFilter [main] - [202] Filter 'headerFilter' configured successfully
2017-05-31 09:01:28,017 ERROR: com.genesyslab.gax.core.database.GAXBasicDataSource [Thread-19] - [29] ---------------------------------------------------------------------
2017-05-31 09:01:28,017 ERROR: com.genesyslab.gax.core.database.GAXBasicDataSource [Thread-19] - [30] Retrieving connection to database for opm-arm failed.
2017-05-31 09:01:28,017 ERROR: com.genesyslab.gax.core.database.GAXBasicDataSource [Thread-19] - [32] ---------------------------------------------------------------------
2017-05-31 09:01:28,021 WARN : org.hibernate.util.JDBCExceptionReporter [Thread-19] - [233] SQL Error: 0, SQLState: null
2017-05-31 09:01:28,021 ERROR: com.genesyslab.gax.core.database.GAXBasicDataSource [Thread-15] - [29] ---------------------------------------------------------------------
2017-05-31 09:01:28,021 ERROR: org.hibernate.util.JDBCExceptionReporter [Thread-19] - [234] Cannot create PoolableConnectionFactory (Network error IOException: Connection refused: connect)
2017-05-31 09:01:28,021 ERROR: com.genesyslab.gax.core.database.GAXBasicDataSource [Thread-21] - [29] ---------------------------------------------------------------------
2017-05-31 09:01:28,021 ERROR: com.genesyslab.gax.core.database.GAXBasicDataSource [Thread-15] - [30] Retrieving connection to database for core failed.
2017-05-31 09:01:28,021 ERROR: com.genesyslab.gax.core.database.GAXBasicDataSource [Thread-15] - [32] ---------------------------------------------------------------------
2017-05-31 09:01:28,021 ERROR: com.genesyslab.gax.core.database.GAXBasicDataSource [Thread-21] - [30] Retrieving connection to database for asd failed.
2017-05-31 09:01:28,021 WARN : org.hibernate.util.JDBCExceptionReporter [Thread-15] - [233] SQL Error: 0, SQLState: null
2017-05-31 09:01:28,021 ERROR: com.genesyslab.gax.core.database.GAXBasicDataSource [Thread-21] - [32] ---------------------------------------------------------------------
2017-05-31 09:01:28,021 ERROR: org.hibernate.util.JDBCExceptionReporter [Thread-15] - [234] Cannot create PoolableConnectionFactory (Network error IOException: Connection refused: connect)
2017-05-31 09:01:28,021 WARN : com.genesyslab.gax.api.database.DefaultDatabaseInspectorImpl [Thread-19] - [94] Failed to load database schema version for opm-arm
2017-05-31 09:01:28,021 WARN : org.hibernate.util.JDBCExceptionReporter [Thread-21] - [233] SQL Error: 0, SQLState: null
2017-05-31 09:01:28,021 WARN : com.genesyslab.gax.core.util.CoreDatabaseInspectorImpl [Thread-15] - [94] Failed to load database schema version for core
2017-05-31 09:01:28,021 ERROR: org.hibernate.util.JDBCExceptionReporter [Thread-21] - [234] Cannot create PoolableConnectionFactory (Network error IOException: Connection refused: connect)
2017-05-31 09:01:28,025 WARN : com.genesyslab.gax.api.database.DefaultDatabaseInspectorImpl [Thread-21] - [94] Failed to load database schema version for asd
2017-05-31 09:01:29,033 ERROR: com.genesyslab.gax.core.database.GAXBasicDataSource [Thread-21] - [29] ---------------------------------------------------------------------
2017-05-31 09:01:29,033 ERROR: com.genesyslab.gax.core.database.GAXBasicDataSource [Thread-15] - [29] ---------------------------------------------------------------------
2017-05-31 09:01:29,033 ERROR: com.genesyslab.gax.core.database.GAXBasicDataSource [Thread-19] - [29] ---------------------------------------------------------------------
2017-05-31 09:01:29,033 ERROR: com.genesyslab.gax.core.database.GAXBasicDataSource [Thread-15] - [30] Retrieving connection to database for core failed.
2017-05-31 09:01:29,033 ERROR: com.genesyslab.gax.core.database.GAXBasicDataSource [Thread-15] - [32] ---------------------------------------------------------------------
2017-05-31 09:01:29,033 ERROR: com.genesyslab.gax.core.database.GAXBasicDataSource [Thread-21] - [30] Retrieving connection to database for asd failed.
2017-05-31 09:01:29,033 WARN : org.hibernate.util.JDBCExceptionReporter [Thread-15] - [233] SQL Error: 0, SQLState: null
2017-05-31 09:01:29,033 ERROR: com.genesyslab.gax.core.database.GAXBasicDataSource [Thread-21] - [32] ---------------------------------------------------------------------
2017-05-31 09:01:29,037 ERROR: org.hibernate.util.JDBCExceptionReporter [Thread-15] - [234] Cannot create PoolableConnectionFactory (Network error IOException: Connection refused: connect)
2017-05-31 09:01:29,033 ERROR: com.genesyslab.gax.core.database.GAXBasicDataSource [Thread-19] - [30] Retrieving connection to database for opm-arm failed.
2017-05-31 09:01:29,037 WARN : org.hibernate.util.JDBCExceptionReporter [Thread-21] - [233] SQL Error: 0, SQLState: null
2017-05-31 09:01:29,037 ERROR: com.genesyslab.gax.core.database.GAXBasicDataSource [Thread-19] - [32] ---------------------------------------------------------------------
2017-05-31 09:01:29,037 ERROR: org.hibernate.util.JDBCExceptionReporter [Thread-21] - [234] Cannot create PoolableConnectionFactory (Network error IOException: Connection refused: connect)
2017-05-31 09:01:29,037 WARN : com.genesyslab.gax.core.util.CoreDatabaseInspectorImpl [Thread-15] - [94] Failed to load database schema version for core
2017-05-31 09:01:29,037 WARN : org.hibernate.util.JDBCExceptionReporter [Thread-19] - [233] SQL Error: 0, SQLState: null
2017-05-31 09:01:29,037 WARN : com.genesyslab.gax.core.util.CoreDatabaseInspectorImpl [Thread-15] - [47] Db Schema Version for plugin gax-core 8.1.301.01 is not matching the current Db Version for PluginSummary in the Database: null !!!
2017-05-31 09:01:29,037 ERROR: org.hibernate.util.JDBCExceptionReporter [Thread-19] - [234] Cannot create PoolableConnectionFactory (Network error IOException: Connection refused: connect)
2017-05-31 09:01:29,037 INFO : com.genesyslab.gax.core.util.CoreDatabaseInspectorImpl [Thread-15] - [50] ------------------------------------------------------------------------
2017-05-31 09:01:29,037 WARN : com.genesyslab.gax.api.database.DefaultDatabaseInspectorImpl [Thread-21] - [94] Failed to load database schema version for asd
2017-05-31 09:01:29,037 WARN : com.genesyslab.gax.api.database.DefaultDatabaseInspectorImpl [Thread-21] - [47] Db Schema Version for plugin gax-asd 8.5.000.01 is not matching the current Db Version for PluginSummary in the Database: null !!!
2017-05-31 09:01:29,037 ERROR: com.genesyslab.gax.core.plugin.DefaultPluginManagerImpl [Thread-15] - [190] Plugin gax-core database schema version mismatch
2017-05-31 09:01:29,037 WARN : com.genesyslab.gax.api.database.DefaultDatabaseInspectorImpl [Thread-19] - [94] Failed to load database schema version for opm-arm
2017-05-31 09:01:29,037 WARN : com.genesyslab.gax.api.database.DefaultDatabaseInspectorImpl [Thread-19] - [47] Db Schema Version for plugin gax-opm-arm 8.1.301.01 is not matching the current Db Version for PluginSummary in the Database: null !!!
2017-05-31 09:01:29,037 INFO : com.genesyslab.gax.api.database.DefaultDatabaseInspectorImpl [Thread-19] - [50] ------------------------------------------------------------------------
2017-05-31 09:01:29,037 INFO : com.genesyslab.gax.api.database.DefaultDatabaseInspectorImpl [Thread-21] - [50] ------------------------------------------------------------------------
2017-05-31 09:01:29,037 ERROR: com.genesyslab.gax.core.plugin.DefaultPluginManagerImpl [Thread-19] - [190] Plugin gax-opm-arm database schema version mismatch
2017-05-31 09:01:29,037 ERROR: com.genesyslab.gax.core.plugin.DefaultPluginManagerImpl [Thread-21] - [190] Plugin gax-asd database schema version mismatch


Any suggestions?

Best Regards,

[Kubig]

DB is mandatory for GAX. Set up the database part according the documentation and try it again.

[bilge]

Hi Kubig,

Thank you for your response.

We have a GAX database but the problem is that the working db host is ISTHOST01, while the problematic db has an instance and the db host is like ISTHOST02\GenesysDB.

When we carried the other components' databases (Infomart, Datamart, etc.) ,we changed their jdbcurl option in DAPs such that it contains the instanceName, however we could not find any configuration related to jdbcurl for GAX DAP.

Thanks,

[Kubig]

You have to configure the DAP for GAX in genesys configuration - follow the documentation.

[mao_dzen]

GAX does not support instances. At all.
I heard that someone was able to make it work defining static listening port for SQL instance and pointing gax to it without instance_name but only db_name and that static port.
But I never seen working GAX on multi-instance SQL.

[bilge]

When the default configuration is used for GAXDAP (jdbc connection with DBInfo and GAX section with role=main) GAX cannot connect to database. The same database server works with other components.

Thank you,

[cavagnaro]

[quote author=bilge link=topic=10373.msg47104#msg47104 date=1496294387]
When the default configuration is used for GAXDAP (jdbc connection with DBInfo and GAX section with role=main) GAX cannot connect to database. The same database server works with other components.

Thank you,
[/quote]


So, what about the instance remark mao_dzen did? Why ommit points?

[bilge]

Hi cavagnaro,

I think we posted at the same time with mao_dzen. We are trying to convince our customer to open a static port on sql. If we cannot achieve this I will install a separate sql server on the Genesys server just for GAX and Pulse as Pulse does not start with db instance as well.

Do you have any other suggestions or experience on this issue?

Thank you,

[cavagnaro]

Hi,
Unfortunately no. My installations on MSSQL have been by luck without an instance. Others we used Oracle.