doubt in installing Appian 18.3

 Hi All,

i doing fresh installtion 18.3 on server. I am just following 18.3 installation guide but here i have one doubt : 

as per the link (https://docs.appian.com/suite/help/18.3/Configuring_Relational_Databases.html#troubleshooting) what are changes i need to make in the xml file ?

i updated the username & password(hascode generated by running the script). Apart from this anything else i need to make changes? 

below are the file available in 

/repo_home/tomcat 

:

tomcatResources.xml.dev 

 

<Resource name="jdbc/AppianDS"
factory="com.appiancorp.tomcat.datasource.EncodedPasswordDataSourceFactory"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/primary_appian?useOldAliasMetadataBehavior=true&amp;useUnicode=true&amp;characterEncoding=utf8"
username=""
password=""
initialSize="5"
maxTotal="100"
defaultTransactionIsolation="READ_COMMITTED"
maxWaitMillis="30000"
minIdle="5"
minEvictableIdleTimeMillis="90000"
timeBetweenEvictionRunsMillis="450000"
numTestsPerEvictionRun="100"
accessToUnderlyingConnectionAllowed="true"
validationQuery="SELECT 1"
testOnBorrow="true"
/>

 

Regards

Abhay

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer
    Hi Abhay !

    Where did you struck in the installation process?
    What is the Error message you are getting in the installation process?

    Thanks,
    Ravi.
  • Hi Ravi,

    find the log file details, what error m facing :

    2018-10-15 09:47:42.006 INFO [localhost-startStop-1] org.apache.catalina.core.ApplicationContext.log Initializing Spring root WebApplicationContext
    2018-10-15 09:47:42,006 [localhost-startStop-1] INFO org.springframework.web.context.ContextLoader - Root WebApplicationContext: initialization started
    2018-10-15 09:47:46,750 [localhost-startStop-1] INFO com.appiancorp.common.persistence.search.SearchServerClientConfiguration - Using the Search Server client configuration specified in appian-topology.xml.
    ERROR StatusLogger No log4j2 configuration file found. Using default configuration: logging only errors to the console. Set system property 'log4j2.debug' to show Log4j2 internal initialization logging.
    2018-10-15 09:48:07,754 [localhost-startStop-1] INFO com.appiancorp.common.persistence.search.AppianSearchSpringConfig - initializing client with server addresses: [localhost:9300]
    2018-10-15 09:48:49,729 [localhost-startStop-1] INFO com.appiancorp.common.persistence.search.AppianSearchSpringConfig - client settings: {"client.transport.ping_timeout":"20s","client.transport.sniff":"true","client.type":"transport","cluster.name":"appian-search-cluster","http.type.default":"netty4","network.server":"false","node.name":"Client C7CB6DF3","path.logs":"/usr/local/appian/logs","transport.ping_schedule":"5s","transport.type.default":"netty4"}
    2018-10-15 09:48:49,730 [localhost-startStop-1] INFO com.appiancorp.common.persistence.search.AppianSearchSpringConfig - client configured nodes: [{#transport#-1}{ORU2P_fXQ1CNdIId-B_vXw}{localhost}{127.0.0.1:9300}]
    2018-10-15 09:48:49,730 [localhost-startStop-1] INFO com.appiancorp.common.persistence.search.AppianSearchSpringConfig - client connected nodes: [{Node localhost:9300}{eYGyBYM4SpODVvWN1cPF2w}{bzGWUuyhSqO-ntXOymwfrg}{localhost}{127.0.0.1:9300}]
    2018-10-15 09:48:49,841 [localhost-startStop-1] INFO com.appiancorp.common.persistence.search.AppianSearchSpringConfig - search server: productName=ElasticSearch, productVersion=6.2.4, driverName=org.elasticsearch.transport.client.PreBuiltTransportClient, driverVersion=6.2.4
    2018-10-15 09:48:49,849 [localhost-startStop-1] INFO com.appiancorp.common.persistence.search.SearchServerClientConfiguration - Using the Search Server client configuration specified in appian-topology.xml.
    2018-10-15 09:48:55,287 [localhost-startStop-1] INFO com.appiancorp.rdbms.hb.DataSourceManagerHbImpl - [jdbc/AppianDS] Checking schema and migrating if necessary (appian/db/changelog/db-changelog-master.xml)...
    2018-10-15 09:48:58,504 [localhost-startStop-1] INFO com.appiancorp.rdbms.hb.DataSourceManagerHbImpl - [jdbc/AppianDS] Schema check/migration completed successfully.
    2018-10-15 09:48:58,507 [localhost-startStop-1] INFO com.appiancorp.rdbms.hb.DataSourceManagerHbImpl - [jdbc/AppianDS] Verifying that entity mappings match the schema...
    2018-10-15 09:48:59,608 [localhost-startStop-1] INFO com.appiancorp.rdbms.hb.DataSourceManagerHbImpl - [jdbc/AppianDS] Mappings and schema validated successfully.
    2018-10-15 09:49:03,320 [localhost-startStop-1] INFO com.appiancorp.common.crypto.KeyStoreConfig - KeyStoreConfig initialized in 2 seconds
    2018-10-15 09:49:08,788 [localhost-startStop-1] INFO com.appiancorp.rdbms.config.PrimaryDataSourceConfig - Validating and initializing the Appian data source: jdbc/AppianDS
    2018-10-15 09:49:08,807 [localhost-startStop-1] INFO com.appiancorp.rdbms.config.PrimaryDataSourceConfig - Appian data source: jdbc/AppianDS DataSourceMetadata[databaseProductName=MySQL, databaseProductVersion=5.7.23, driverName=MySQL Connector Java, driverVersion=mysql-connector-java-5.1.40 ( Revision: 402933ef52cad9aa82624e80acbea46e3a701ce6 )]
    2018-10-15 09:49:09,420 [localhost-startStop-1] INFO com.appiancorp.common.persistence.search.SearchServerClientConfiguration - Using the Search Server client configuration specified in appian-topology.xml.
    2018-10-15 09:49:36,587 [localhost-startStop-1] INFO com.appiancorp.common.persistence.search.SearchServerClientConfiguration - Using the Search Server client configuration specified in appian-topology.xml.
    2018-10-15 09:49:40,997 [localhost-startStop-1] ERROR com.appiancorp.connectedenvironments.ConnectedEnvironmentsServiceImpl - Error initializing keypair
    org.hibernate.PropertyValueException: not-null property references a null or transient value: com.appiancorp.security.ssl.CertificateData.commonName
    at org.hibernate.engine.Nullability.checkNullability(Nullability.java:100)
Reply
  • Hi Ravi,

    find the log file details, what error m facing :

    2018-10-15 09:47:42.006 INFO [localhost-startStop-1] org.apache.catalina.core.ApplicationContext.log Initializing Spring root WebApplicationContext
    2018-10-15 09:47:42,006 [localhost-startStop-1] INFO org.springframework.web.context.ContextLoader - Root WebApplicationContext: initialization started
    2018-10-15 09:47:46,750 [localhost-startStop-1] INFO com.appiancorp.common.persistence.search.SearchServerClientConfiguration - Using the Search Server client configuration specified in appian-topology.xml.
    ERROR StatusLogger No log4j2 configuration file found. Using default configuration: logging only errors to the console. Set system property 'log4j2.debug' to show Log4j2 internal initialization logging.
    2018-10-15 09:48:07,754 [localhost-startStop-1] INFO com.appiancorp.common.persistence.search.AppianSearchSpringConfig - initializing client with server addresses: [localhost:9300]
    2018-10-15 09:48:49,729 [localhost-startStop-1] INFO com.appiancorp.common.persistence.search.AppianSearchSpringConfig - client settings: {"client.transport.ping_timeout":"20s","client.transport.sniff":"true","client.type":"transport","cluster.name":"appian-search-cluster","http.type.default":"netty4","network.server":"false","node.name":"Client C7CB6DF3","path.logs":"/usr/local/appian/logs","transport.ping_schedule":"5s","transport.type.default":"netty4"}
    2018-10-15 09:48:49,730 [localhost-startStop-1] INFO com.appiancorp.common.persistence.search.AppianSearchSpringConfig - client configured nodes: [{#transport#-1}{ORU2P_fXQ1CNdIId-B_vXw}{localhost}{127.0.0.1:9300}]
    2018-10-15 09:48:49,730 [localhost-startStop-1] INFO com.appiancorp.common.persistence.search.AppianSearchSpringConfig - client connected nodes: [{Node localhost:9300}{eYGyBYM4SpODVvWN1cPF2w}{bzGWUuyhSqO-ntXOymwfrg}{localhost}{127.0.0.1:9300}]
    2018-10-15 09:48:49,841 [localhost-startStop-1] INFO com.appiancorp.common.persistence.search.AppianSearchSpringConfig - search server: productName=ElasticSearch, productVersion=6.2.4, driverName=org.elasticsearch.transport.client.PreBuiltTransportClient, driverVersion=6.2.4
    2018-10-15 09:48:49,849 [localhost-startStop-1] INFO com.appiancorp.common.persistence.search.SearchServerClientConfiguration - Using the Search Server client configuration specified in appian-topology.xml.
    2018-10-15 09:48:55,287 [localhost-startStop-1] INFO com.appiancorp.rdbms.hb.DataSourceManagerHbImpl - [jdbc/AppianDS] Checking schema and migrating if necessary (appian/db/changelog/db-changelog-master.xml)...
    2018-10-15 09:48:58,504 [localhost-startStop-1] INFO com.appiancorp.rdbms.hb.DataSourceManagerHbImpl - [jdbc/AppianDS] Schema check/migration completed successfully.
    2018-10-15 09:48:58,507 [localhost-startStop-1] INFO com.appiancorp.rdbms.hb.DataSourceManagerHbImpl - [jdbc/AppianDS] Verifying that entity mappings match the schema...
    2018-10-15 09:48:59,608 [localhost-startStop-1] INFO com.appiancorp.rdbms.hb.DataSourceManagerHbImpl - [jdbc/AppianDS] Mappings and schema validated successfully.
    2018-10-15 09:49:03,320 [localhost-startStop-1] INFO com.appiancorp.common.crypto.KeyStoreConfig - KeyStoreConfig initialized in 2 seconds
    2018-10-15 09:49:08,788 [localhost-startStop-1] INFO com.appiancorp.rdbms.config.PrimaryDataSourceConfig - Validating and initializing the Appian data source: jdbc/AppianDS
    2018-10-15 09:49:08,807 [localhost-startStop-1] INFO com.appiancorp.rdbms.config.PrimaryDataSourceConfig - Appian data source: jdbc/AppianDS DataSourceMetadata[databaseProductName=MySQL, databaseProductVersion=5.7.23, driverName=MySQL Connector Java, driverVersion=mysql-connector-java-5.1.40 ( Revision: 402933ef52cad9aa82624e80acbea46e3a701ce6 )]
    2018-10-15 09:49:09,420 [localhost-startStop-1] INFO com.appiancorp.common.persistence.search.SearchServerClientConfiguration - Using the Search Server client configuration specified in appian-topology.xml.
    2018-10-15 09:49:36,587 [localhost-startStop-1] INFO com.appiancorp.common.persistence.search.SearchServerClientConfiguration - Using the Search Server client configuration specified in appian-topology.xml.
    2018-10-15 09:49:40,997 [localhost-startStop-1] ERROR com.appiancorp.connectedenvironments.ConnectedEnvironmentsServiceImpl - Error initializing keypair
    org.hibernate.PropertyValueException: not-null property references a null or transient value: com.appiancorp.security.ssl.CertificateData.commonName
    at org.hibernate.engine.Nullability.checkNullability(Nullability.java:100)
Children