• State Suggested Answer
  • +2 person also asked this people also asked this
  • Replies 15 replies
  • Answers 1 answer
  • Subscribers 13 subscribers
  • Views 12039 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Administration

Cannot start app server in 19.1

Ankur V

I'm upgrading appian from 18.3 to 19.1 and have made all required changes however when i try to start the appserver it creates a new folder in the default appian log directory called "tomcat" but there are no logs in that folder.  Previous release did have tomcat-stdout.log file that contained logs for the tomcat server has any one else run into this issue?

  Discussion posts and replies are publicly visible

  • 0 in reply to Shoaib

    Hi Ankur,

    Hope so you are doing fine, thank you for your reply.

    I have placed the following connector jars in the (repo\appian\tomcat\apache-tomcat\lib)

    mysql-connector-java-5.1.47

    mysql-connector-java-5.1.47-bin

    mysql-connector-java-8.0.11

    mysql-connector-java-8.0.16

    ------------------------------------

    I am trying to install appian server but having difficulty with configuring the MySql connection can you kindly tell me what is JNDI? what do I need to put in .xml file 

    e.g: 

    for tomcat.resource.xml

    what should be the name? here (<Resource name="jdbc/") what should be after jdbc/ should it be the schema name? e.g appian_schema I created in MySql server ->  (<Resource name="jdbc/appian_schema") or it should be something else?

    -------------------------------------------------------------

    what should be in url after port/

    is this the correct url? if I my sql servr is on local machine and the schema is appian_schema

    url="jdbc:mysql://localhost:3306/appian_schema?useOldAliasMetadataBehavior=true&amp;useServerPrepStmts=true"

    ---------------------------------------

    and for custom.properties.dev file, should the data source look like this?

    conf.data.datasources=appian_schema 

    I am new to appian and need to set a an appian server on my local machine, I am setting up server for first time, kindly help me out.

    Any help would be really appreciated 

    Thank you

  • 0 in reply to Shoaib

    Looks like you are installing appian and all components on a single server i would suggest you follow the steps mentioned here https://docs.appian.com/suite/help/19.2/Quick_Start_Installation_Guide.html and refer to this post if you encounter any issues. 

    conf.data.APPIAN_DATA_SOURCE=jdbc/AppianDS --- AppianDS is the jndi name specified in Resource name="jdbc/xxx" in tomact resource.xml

    Your datasource url should be jdbc:mysql://localhost:3306/business_schema( name of businessschema)?useOldAliasMetadataBehavior=true

  • 0 in reply to Ankur V

    Thank you for your reply and helping me out with the connection string and JNDI.

    I am already using that "Quick Start Installation Guide" and I have only followed that instruction guide for setting up Appian server but still facing error. 

    This is the error in the log file

    SEVERE [localhost-startStop-1] org.apache.tomcat.jdbc.pool.ConnectionPool.init Unable to create initial connections of pool.
 java.sql.SQLException: Access denied for user ''@'localhost' (using password: NO)
  • 0 in reply to Ankur V

    here is the link to my tomcat log file, all services start without any issues, the only issue I am facing is with the Tomcat server, its not getting started

    community.appian.com/.../0118.tomcat_2D00_stdOut.log

  • 0 in reply to Shoaib

    What is the version of mysql and the connectors you are using? I had issues with latest mysql version on appian they are not always supported. I have mysql-installer-community-8.0.15.0 , mysql-workbench-community-8.0.15 and mysql-connector-java-5.1.47 and is works fine on 19.2

© 2024 Appian. All rights reserved.