Having problem connecting to the primary database. I'm trying to start

Steve Satwah over 10 years ago

Having problem connecting to the primary database.
I'm trying to start JBOSS in Linux (UBUNTU 14.04), database is MySQL.

ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/suite]] (ServerService Thread Pool -- 56) JBWEB000287: Exception sending context initialized event to listener instance of class com.appiancorp.common.config.ConfigurationLoader: com.appiancorp.common.config.FatalConfigurationException: com.appiancorp.suiteapi.common.exceptions.AppianException: An unexpected error occurred while trying to initialize and validate the primary data source. (APNX-1-4179-004)
          at com.appiancorp.suiteapi.common.exceptions.AppianRuntimeException.<init>(AppianRuntimeException.java:52) [appian-suiteapi.jar:]
          at com.appiancorp.common.config.FatalConfigurationException.<init>(FatalConfigurationException.java:23) [appian-common.jar:]
          at com.appiancorp.rdbms.config.PrimaryDataSourceConfig.finish(PrimaryDataSourceConfi...

server.log_linux

Discussion posts and replies are publicly visible

Parents

0 Alok Mohare
Appian Employee
over 10 years ago

Hello Steve,

It seems like the issue is the hostname on which the My SQL is hosted.

16:18:07,975 INFO [stdout] (ServerService Thread Pool -- 56) 2014-06-02 16:18:07,974 [ServerService Thread Pool -- 56] INFO com.appiancorp.rdbms.config.PrimaryDataSourceConfig - Validating and initializing the primary data source: jdbc/AppianPrimaryDS
16:18:09,194 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.PoolBySubject] (ServerService Thread Pool -- 56) IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: Could not create connection
...
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
...
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
...
Caused by: java.net.UnknownHostException: @conf.data.primary.url@

Check your appian-ds.xml to see if the hostname for the MySQL Server is listed correctly. Currently it looks like the appian-ds.xml is using the *hostname token* from the build.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Alok Mohare
Appian Employee
over 10 years ago

Hello Steve,

It seems like the issue is the hostname on which the My SQL is hosted.

16:18:07,975 INFO [stdout] (ServerService Thread Pool -- 56) 2014-06-02 16:18:07,974 [ServerService Thread Pool -- 56] INFO com.appiancorp.rdbms.config.PrimaryDataSourceConfig - Validating and initializing the primary data source: jdbc/AppianPrimaryDS
16:18:09,194 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.PoolBySubject] (ServerService Thread Pool -- 56) IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: Could not create connection
...
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
...
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
...
Caused by: java.net.UnknownHostException: @conf.data.primary.url@

Check your appian-ds.xml to see if the hostname for the MySQL Server is listed correctly. Currently it looks like the appian-ds.xml is using the *hostname token* from the build.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data