Can't log into newly installed dev machine

I set up a new 18.2 container on my development machine. I got everything to boot up and the system is available.

The only issue I have is that it won't save my Administrator password to the data base so I can't log in.

I checked the mysql database, the appian_schema.usr table. This is what is in the DB. 

username       scs_key_salt    scs_key_h

Administrator  null                null

 

I know the password.properties file was filled out. I saved a copy since I found out the FIRST time I installed this I had an issue and the advice I read was to reinstall Appian.

 

I am getting a bit frustrated at this point, a week into this exercise and would appreciate some guidance.

 

Regards,

Mike Gardner

  Discussion posts and replies are publicly visible

Parents Reply Children
  • Hi Jonga,

    No, I get everything up and running. Get to the login screen, only to be told my username/password are invalid.

    I know they are correct because I saved the password.properties file. I also looked into the DB and the username is saved just not the password. Possibly there is an issue with the password hashing?

    Thanks,
    Mike
  • Just do again the Part Eight: Deploy the Configurations and the others steps below, i just do that and it works.
  • I believe I can do parts 8 & 10 but not 9. I though you could only do step 9 the first time you start up the server?

    Either way, I did these steps with the same result.

    I have a container that I can't log into.
  • you can do all the parts all the times you want, firts turn down all the services.
    -<JBOSS_HOME>\bin\shutdown.bat
    -<APPIAN_HOME>\search-server\bin\stop.bat
    -<APPIAN_HOME>\data-server\bin\stop.bat
    -<APPIAN_HOME>\services\bin\stop.bat -p <password> -s

    -then do the part 8 and deploy all the configuration.

    -the the part 9 verify if you are writting in <APPIAN_HOME>\conf/ and write in passwords.properties verify if you dont write in de file that has extentions ".example" or in the path repo/conf in the same file password.properties.

    -do the part 10, turn up all the services.
  • Hi Jonga,

    I did everything that you listed but my Administrator password is still not getting saved to the mysql db.

    also, I noticed for your \services\bin\stop.bat -p password command you have a '-s' instead of the '-all' what difference could this make?

    Thanks,
    Mike
  • 20:49:25,475 INFO [org.jboss.modules] (main) JBoss Modules version 1.3.6.Final-redhat-1
    20:49:25,834 INFO [org.jboss.msc] (main) JBoss MSC version 1.1.5.Final-redhat-1
    20:49:25,959 INFO [org.jboss.as] (MSC service thread 1-6) JBAS015899: JBoss EAP 6.4.0.GA (AS 7.5.0.Final-redhat-21) starting
    20:49:25,959 DEBUG [org.jboss.as.config] (MSC service thread 1-6) Configured system properties:
    appian.home.ear = C:\appian182\appian\ear
    awt.toolkit = sun.awt.windows.WToolkit
    file.encoding = UTF-8
    file.encoding.pkg = sun.io
    file.separator = \
    java.awt.graphicsenv = sun.awt.Win32GraphicsEnvironment
    java.awt.headless = true
    java.awt.printerjob = sun.awt.windows.WPrinterJob
    java.class.path = C:\appian182\appian\bin\jboss\jboss-eap-6.4\jboss-modules.jar
    java.class.version = 52.0
    java.endorsed.dirs = C:\Program Files\Java\jdk1.8.0_112\jre\lib\endorsed
    java.ext.dirs = C:\Program Files\Java\jdk1.8.0_112\jre\lib\ext;C:\WINDOWS\Sun\Java\lib\ext
    java.home = C:\Program Files\Java\jdk1.8.0_112\jre
    java.io.tmpdir = C:\Users\588746\AppData\Local\Temp\
    java.library.path = C:\Program Files\Java\jdk1.8.0_112\bin;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\Python27\;C:\Python27\Scripts;C:\Program Files\Docker\Docker\Resources\bin;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Users\588746\Documents\Apps\apache-maven-3.5.3\bin;C:\Program Files\Git\cmd;C:\Program Files\Java\jdk1.8.0_112\bin;C:\Program Files\LibreOffice 5\program\soffice.exe;C:\Users\588746\Documents\Apps\apache-ant-1.7.1\bin;C:\Users\588746\Documents\Apps\JUNIT\junit-4.12.jar;C:\Program Files (x86)\Sennheiser\SoftphoneSDK\;C:\Users\588746\AppData\Local\Microsoft\WindowsApps;;.
    java.net.preferIPv4Stack = true
    java.runtime.name = Java(TM) SE Runtime Environment
    java.runtime.version = 1.8.0_112-b15
    java.specification.name = Java Platform API Specification
    java.specification.vendor = Oracle Corporation
    java.specification.version = 1.8
    java.util.logging.manager = org.jboss.logmanager.LogManager
    java.vendor = Oracle Corporation
    java.vendor.url = http://java.oracle.com/
    java.vendor.url.bug = bugreport.sun.com/.../
    java.version = 1.8.0_112
    java.vm.info = mixed mode
    java.vm.name = Java HotSpot(TM) 64-Bit Server VM
    java.vm.specification.name = Java Virtual Machine Specification
    java.vm.specification.vendor = Oracle Corporation
    java.vm.specification.version = 1.8
    java.vm.vendor = Oracle Corporation
    java.vm.version = 25.112-b15
    javax.management.builder.initial = org.jboss.as.jmx.PluggableMBeanServerBuilder
    javax.xml.datatype.DatatypeFactory = __redirected.__DatatypeFactory
    javax.xml.parsers.DocumentBuilderFactory = __redirected.__DocumentBuilderFactory
    javax.xml.parsers.SAXParserFactory = __redirected.__SAXParserFactory
    javax.xml.stream.XMLEventFactory = __redirected.__XMLEventFactory
    javax.xml.stream.XMLInputFactory = __redirected.__XMLInputFactory
    javax.xml.stream.XMLOutputFactory = __redirected.__XMLOutputFactory
    javax.xml.transform.TransformerFactory = __redirected.__TransformerFactory
    javax.xml.validation.SchemaFactory:www.w3.org/.../XMLSchema = __redirected.__SchemaFactory
    javax.xml.xpath.XPathFactory:java.sun.com/.../dom = __redirected.__XPathFactory
    jboss.as.management.blocking.timeout = 3600
    jboss.home.dir = C:\appian182\appian\bin\jboss\jboss-eap-6.4
    jboss.host.name = bahcnu4089lp2
    jboss.modules.dir = C:\appian182\appian\bin\jboss\jboss-eap-6.4\modules
    jboss.node.name = bahcnu4089lp2
    jboss.qualified.host.name = bahcnu4089lp2
    jboss.server.base.dir = C:\appian182\appian\bin\jboss\jboss-eap-6.4\standalone
    jboss.server.config.dir = C:\appian182\appian\bin\jboss\jboss-eap-6.4\standalone\configuration
    jboss.server.data.dir = C:\appian182\appian\bin\jboss\jboss-eap-6.4\standalone\data
    jboss.server.default.config = standalone.xml
    jboss.server.deploy.dir = C:\appian182\appian\bin\jboss\jboss-eap-6.4\standalone\data\content
    jboss.server.log.dir = C:\appian182\appian\bin\jboss\jboss-eap-6.4\standalone\log
    jboss.server.name = bahcnu4089lp2
    jboss.server.persist.config = true
    jboss.server.temp.dir = C:\appian182\appian\bin\jboss\jboss-eap-6.4\standalone\tmp
    line.separator =

    logging.configuration = file:C:\appian182\appian\bin\jboss\jboss-eap-6.4\standalone\configuration/logging.properties
    module.path = C:\appian182\appian\bin\jboss\jboss-eap-6.4\modules
    org.apache.catalina.connector.URI_ENCODING = UTF-8
    org.jboss.boot.log.file = C:\appian182\appian\bin\jboss\jboss-eap-6.4\standalone\log\server.log
    org.jboss.resolver.warning = true
    org.xml.sax.driver = __redirected.__XMLReaderFactory
    os.arch = amd64
    os.name = Windows 10
    os.version = 10.0
    path.separator = ;
    program.name = standalone.bat
    sun.arch.data.model = 64
    sun.boot.class.path = C:\Program Files\Java\jdk1.8.0_112\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_112\jre\lib\rt.jar;C:\Program Files\Java\jdk1.8.0_112\jre\lib\sunrsasign.jar;C:\Program Files\Java\jdk1.8.0_112\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_112\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_112\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_112\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_112\jre\classes
    sun.boot.library.path = C:\Program Files\Java\jdk1.8.0_112\jre\bin
    sun.cpu.endian = little
    sun.cpu.isalist = amd64
    sun.desktop = windows
    sun.io.unicode.encoding = UnicodeLittle
    sun.java.command = C:\appian182\appian\bin\jboss\jboss-eap-6.4\jboss-modules.jar -mp C:\appian182\appian\bin\jboss\jboss-eap-6.4\modules -jaxpmodule javax.xml.jaxp-provider org.jboss.as.standalone -Djboss.home.dir=C:\appian182\appian\bin\jboss\jboss-eap-6.4
    sun.java.launcher = SUN_STANDARD
    sun.jnu.encoding = Cp1252
    sun.management.compiler = HotSpot 64-Bit Tiered Compilers
    sun.os.patch.level =
    sun.rmi.dgc.client.gcInterval = 3600000
    sun.rmi.dgc.server.gcInterval = 3600000
    sun.stderr.encoding = cp437
    sun.stdout.encoding = cp437
    user.country = US
    user.dir = C:\Users\588746
    user.home = C:\Users\588746
    user.language = en
    user.name = 588746
    user.script =
    user.timezone = GMT
    user.variant =
    20:49:25,959 DEBUG [org.jboss.as.config] (MSC service thread 1-6) VM Arguments: -Xloggc:C:\appian182\appian\bin\jboss\jboss-eap-6.4\standalone\log\gc.log -verbose:gc -XX:+PrintGCDetails -XX:+PrintGCDateStamps -XX:+UseGCLogFileRotation -XX:NumberOfGCLogFiles=5 -XX:GCLogFileSize=3M -XX:-TraceClassUnloading -XX:+UseCompressedOops -Dprogram.name=standalone.bat -Xms2048m -Xmx4096m -XX:+HeapDumpOnOutOfMemoryError -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000 -XX:+CMSClassUnloadingEnabled -XX:+UseConcMarkSweepGC -Dorg.apache.catalina.connector.URI_ENCODING=UTF-8 -Duser.timezone=GMT -Djava.awt.headless=true -Djava.net.preferIPv4Stack=true -Dfile.encoding=UTF-8 -Dappian.home.ear=C:\appian182\appian\ear -Djboss.as.management.blocking.timeout=3600 -Dorg.jboss.resolver.warning=true -Djboss.server.default.config=standalone.xml -Dorg.jboss.boot.log.file=C:\appian182\appian\bin\jboss\jboss-eap-6.4\standalone\log\server.log -Dlogging.configuration=file:C:\appian182\appian\bin\jboss\jboss-eap-6.4\standalone\configuration/logging.properties
    20:49:28,443 WARN [org.jboss.messaging] (ServerService Thread Pool -- 22) JBAS011618: There is no resource matching the expiry-address jms.queue.ExpiryQueue for the address-settings #, expired messages from destinations matching this address-setting will be lost!
    20:49:28,475 WARN [org.jboss.messaging] (ServerService Thread Pool -- 22) JBAS011619: There is no resource matching the dead-letter-address jms.queue.DLQ for the address-settings #, undelivered messages from destinations matching this address-setting will be lost!
    20:49:35,906 INFO [org.xnio] (MSC service thread 1-2) XNIO Version 3.0.13.GA-redhat-1
    20:49:35,906 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS015888: Creating http management service using socket-binding (management-http)
    20:49:35,922 INFO [org.xnio.nio] (MSC service thread 1-2) XNIO NIO Implementation Version 3.0.13.GA-redhat-1
    20:49:36,062 INFO [org.jboss.as.webservices] (ServerService Thread Pool -- 50) JBAS015537: Activating WebServices Extension
    20:49:36,062 WARN [org.jboss.as.txn] (ServerService Thread Pool -- 48) JBAS010153: Node identifier property is set to the default value. Please make sure it is unique.
    20:49:36,062 INFO [org.jboss.as.security] (ServerService Thread Pool -- 46) JBAS013371: Activating Security Subsystem
    20:49:36,109 INFO [org.jboss.as.jsf] (ServerService Thread Pool -- 39) JBAS012615: Activated the following JSF Implementations: [main, 1.2]
    20:49:36,141 INFO [org.jboss.as.naming] (ServerService Thread Pool -- 41) JBAS011800: Activating Naming Subsystem
    20:49:36,156 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 33) JBAS010280: Activating Infinispan subsystem.
    20:49:36,281 INFO [org.jboss.as.connector.logging] (MSC service thread 1-6) JBAS010408: Starting JCA Subsystem (IronJacamar 1.0.31.Final-redhat-1)
    20:49:36,281 INFO [org.jboss.as.security] (MSC service thread 1-7) JBAS013370: Current PicketBox version=4.1.1.Final-redhat-1
    20:49:36,297 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 29) JBAS010404: Deploying non-JDBC-compliant driver class com.mysql.jdbc.Driver (version 5.1)
    20:49:36,641 INFO [org.jboss.as.naming] (MSC service thread 1-8) JBAS011802: Starting Naming Service
    20:49:36,641 INFO [org.jboss.remoting] (MSC service thread 1-1) JBoss Remoting version 3.3.4.Final-redhat-1
    20:49:36,781 INFO [org.jboss.as.mail.extension] (MSC service thread 1-5) JBAS015400: Bound mail session [java:jboss/mail/Default]
    20:49:37,484 INFO [org.apache.coyote.http11.Http11Protocol] (MSC service thread 1-2) JBWEB003001: Coyote HTTP/1.1 initializing on : http-/0.0.0.0:8080
    20:49:37,531 INFO [org.apache.coyote.ajp] (MSC service thread 1-3) JBWEB003046: Starting Coyote AJP/1.3 on ajp-/0.0.0.0:8009
    20:49:37,547 INFO [org.apache.coyote.http11.Http11Protocol] (MSC service thread 1-2) JBWEB003000: Coyote HTTP/1.1 starting on: http-/0.0.0.0:8080
    20:49:37,609 INFO [org.jboss.as.remoting] (MSC service thread 1-8) JBAS017100: Listening on 0.0.0.0:4447
    20:49:37,609 INFO [org.jboss.as.remoting] (MSC service thread 1-3) JBAS017100: Listening on 127.0.0.1:9999
    20:49:37,953 WARN [org.jboss.as.messaging] (MSC service thread 1-8) JBAS011600: AIO wasn't located on this platform, it will fall back to using pure Java NIO. If your platform is Linux, install LibAIO to enable the AIO journal
    20:49:38,000 WARN [org.jboss.as.connector.logging] (MSC service thread 1-7) JBAS010489: -ds.xml file deployments are deprecated. Support may be removed in a future version.
    20:49:38,047 INFO [org.jboss.ws.common.management] (MSC service thread 1-6) JBWS022052: Starting JBoss Web Services - Stack CXF Server 4.3.4.Final-redhat-1
    20:49:38,234 INFO [org.hornetq.core.server] (ServerService Thread Pool -- 52) HQ221000: live server is starting with configuration HornetQ Configuration (clustered=false,backup=false,sharedStore=true,journalDirectory=C:\appian182\appian\bin\jboss\jboss-eap-6.4\standalone\data\messagingjournal,bindingsDirectory=C:\appian182\appian\bin\jboss\jboss-eap-6.4\standalone\data\messagingbindings,largeMessagesDirectory=C:\appian182\appian\bin\jboss\jboss-eap-6.4\standalone\data\messaginglargemessages,pagingDirectory=C:\appian182\appian\bin\jboss\jboss-eap-6.4\standalone\data\messagingpaging)
    20:49:38,453 INFO [org.hornetq.core.server] (ServerService Thread Pool -- 52) HQ221006: Waiting to obtain live lock
    20:49:38,625 INFO [org.hornetq.core.server] (ServerService Thread Pool -- 52) HQ221013: Using NIO Journal
    20:49:39,006 INFO [org.hornetq.core.server] (ServerService Thread Pool -- 52) HQ221034: Waiting to obtain live lock
    20:49:39,006 INFO [org.hornetq.core.server] (ServerService Thread Pool -- 52) HQ221035: Live Server Obtained live lock
    20:49:39,779 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-7) JBAS010400: Bound data source [java:/jdbc/AppianDS]
    20:49:40,076 INFO [org.hornetq.core.server] (ServerService Thread Pool -- 52) HQ221020: Started Netty Acceptor version 3.6.10.Final-266dbdf 0.0.0.0:5455 for CORE protocol
    20:49:40,248 INFO [org.hornetq.core.server] (ServerService Thread Pool -- 52) HQ221020: Started Netty Acceptor version 3.6.10.Final-266dbdf 0.0.0.0:5445 for CORE protocol
    20:49:40,279 INFO [org.hornetq.core.server] (ServerService Thread Pool -- 52) HQ221007: Server is now live
    20:49:40,310 INFO [org.hornetq.core.server] (ServerService Thread Pool -- 52) HQ221001: HornetQ Server version 2.3.25.Final (2.3.x, 123) [1f75ca13-8aca-11e8-894e-b99fc96dd08d]
    20:49:40,310 INFO [org.hornetq.core.server] (ServerService Thread Pool -- 52) HQ221003: trying to deploy queue jms.queue.jms/ProcessQueue
    20:49:40,342 INFO [org.jboss.as.messaging] (ServerService Thread Pool -- 52) JBAS011601: Bound messaging object to jndi name java:/jms/AppianProcessIntegrationQueue
    20:49:40,373 INFO [org.jboss.as.messaging] (ServerService Thread Pool -- 52) JBAS011601: Bound messaging object to jndi name java:jboss/exported/jms/AppianProcessIntegrationQueue
    20:49:40,420 INFO [org.hornetq.jms.server] (ServerService Thread Pool -- 53) HQ121005: Invalid "host" value "0.0.0.0" detected for "netty" connector. Switching to "BAHCNU4089LP2". If this new address is incorrect please manually configure the connector to use the proper one.
    20:49:40,467 INFO [org.jboss.as.messaging] (ServerService Thread Pool -- 53) JBAS011601: Bound messaging object to jndi name java:/jms/AppianProcessIntegrationConnectionFactory
    20:49:40,467 INFO [org.jboss.as.messaging] (ServerService Thread Pool -- 53) JBAS011601: Bound messaging object to jndi name java:jboss/exported/jms/AppianProcessIntegrationConnectionFactory
    20:49:40,482 INFO [org.jboss.as.connector.deployment] (MSC service thread 1-4) JBAS010406: Registered connection factory java:/JmsXA
    20:49:40,701 INFO [org.hornetq.ra] (MSC service thread 1-4) HornetQ resource adaptor started
    20:49:40,717 INFO [org.jboss.as.connector.services.resourceadapters.ResourceAdapterActivatorService$ResourceAdapterActivator] (MSC service thread 1-4) IJ020002: Deployed: file://RaActivatorhornetq-ra
    20:49:40,717 INFO [org.jboss.as.connector.deployment] (MSC service thread 1-3) JBAS010401: Bound JCA ConnectionFactory [java:/JmsXA]
    20:50:11,856 WARN [org.jboss.as.dependency.private] (MSC service thread 1-4) JBAS015867: Deployment "deployment.suite.ear" is using a private module ("com.sun.jsf-impl:main") which may be changed or removed in future versions without notice.
    20:50:11,856 WARN [org.jboss.as.dependency.private] (MSC service thread 1-4) JBAS015867: Deployment "deployment.suite.ear" is using a private module ("com.sun.jsf-impl:main") which may be changed or removed in future versions without notice.
    20:50:11,950 INFO [org.jboss.as.ejb3.deployment.processors.EjbJndiBindingsDeploymentUnitProcessor] (MSC service thread 1-8) JNDI bindings for session bean named ClasspathResourcesEjb in deployment unit subdeployment "resources-classpath.jar" of deployment "suite.ear" are as follows:

    java:global/suite/resources-classpath/ClasspathResourcesEjb!com.appiancorp.common.ClasspathResourcesEjb
    java:app/resources-classpath/ClasspathResourcesEjb!com.appiancorp.common.ClasspathResourcesEjb
    java:module/ClasspathResourcesEjb!com.appiancorp.common.ClasspathResourcesEjb
    java:global/suite/resources-classpath/ClasspathResourcesEjb
    java:app/resources-classpath/ClasspathResourcesEjb
    java:module/ClasspathResourcesEjb

    20:50:12,341 WARN [org.jboss.weld.deployer] (MSC service thread 1-3) JBAS016012: Deployment deployment "suite.ear" contains CDI annotations but beans.xml was not found.
    20:50:13,231 INFO [org.jboss.web] (ServerService Thread Pool -- 160) JBAS018210: Register web context: /suite
    20:50:13,419 ERROR [stderr] (ServerService Thread Pool -- 160) log4j:WARN No appenders could be found for logger (org.apache.commons.configuration.PropertiesConfiguration).

    20:50:13,419 ERROR [stderr] (ServerService Thread Pool -- 160) log4j:WARN Please initialize the log4j system properly.

    20:50:13,419 ERROR [stderr] (ServerService Thread Pool -- 160) log4j:WARN See logging.apache.org/.../faq.html for more info.

    20:50:16,102 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/suite]] (ServerService Thread Pool -- 160) Initializing Spring root WebApplicationContext
    20:50:21,846 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:50:21,846 [ServerService Thread Pool -- 160] INFO com.appiancorp.common.persistence.search.SearchServerClientConfiguration - Using the Search Server client configuration specified in appian-topology.xml.

    20:50:22,955 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:50:22,955 [ServerService Thread Pool -- 160] INFO com.appiancorp.common.persistence.search.AppianSearchSpringConfig - initializing client with server addresses: [localhost:9300]

    20:50:25,135 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:50:25,135 [ServerService Thread Pool -- 160] 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, name=Client 2CB4EA65, network.server=false, node.client=true, path.logs=C:\appian182\appian\logs, transport.ping_schedule=5s}

    20:50:25,166 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:50:25,166 [ServerService Thread Pool -- 160] INFO com.appiancorp.common.persistence.search.AppianSearchSpringConfig - client configured nodes: [{#transport#-1}{localhost}{127.0.0.1:9300}]

    20:50:25,182 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:50:25,182 [ServerService Thread Pool -- 160] INFO com.appiancorp.common.persistence.search.AppianSearchSpringConfig - client connected nodes: [{Node localhost:9300}{oZqClpA2RWC7XgxSJPPA5Q}{localhost}{127.0.0.1:9300}]

    20:50:25,307 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:50:25,307 [ServerService Thread Pool -- 160] INFO com.appiancorp.common.persistence.search.AppianSearchSpringConfig - search server: productName=ElasticSearch, productVersion=2.4.5, driverName=org.elasticsearch.client.transport.TransportClient, driverVersion=2.4.5

    20:50:34,556 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:50:34,556 [ServerService Thread Pool -- 160] INFO com.appiancorp.rdbms.hb.DataSourceManagerHbImpl - [java:/jdbc/AppianDS] Checking schema and migrating if necessary (appian/db/changelog/db-changelog-master.xml)...

    20:50:38,415 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:50:38,415 [ServerService Thread Pool -- 160] INFO com.appiancorp.rdbms.hb.DataSourceManagerHbImpl - [java:/jdbc/AppianDS] Schema check/migration completed successfully.

    20:50:38,415 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:50:38,415 [ServerService Thread Pool -- 160] INFO com.appiancorp.rdbms.hb.DataSourceManagerHbImpl - [java:/jdbc/AppianDS] Verifying that entity mappings match the schema...

    20:50:39,572 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:50:39,572 [ServerService Thread Pool -- 160] INFO com.appiancorp.rdbms.hb.DataSourceManagerHbImpl - [java:/jdbc/AppianDS] Mappings and schema validated successfully.

    20:50:40,759 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:50:40,759 [ServerService Thread Pool -- 160] INFO com.appiancorp.common.crypto.KeyStoreConfig - KeyStoreConfig initialized in 0 seconds

    20:50:47,042 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:50:47,042 [ServerService Thread Pool -- 160] INFO com.appiancorp.rdbms.config.PrimaryDataSourceConfig - Validating and initializing the Appian data source: java:/jdbc/AppianDS

    20:50:47,074 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:50:47,074 [ServerService Thread Pool -- 160] INFO com.appiancorp.rdbms.config.PrimaryDataSourceConfig - Appian data source: java:/jdbc/AppianDS DataSourceMetadata[databaseProductName=MySQL, databaseProductVersion=5.7.22-log, driverName=MySQL Connector Java, driverVersion=mysql-connector-java-5.1.46 ( Revision: 9cc87a48e75c2d2e87c1a293b2862ce651cb256e )]

    20:50:59,387 ERROR [stderr] (ServerService Thread Pool -- 160) ScriptEngineManager providers.next(): javax.script.ScriptEngineFactory: Provider com.sun.script.javascript.RhinoScriptEngineFactory not found

    20:51:08,557 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:51:08,557 [ServerService Thread Pool -- 160] ERROR com.appiancorp.suite.PasswordConfiguration - Could not create system administrator Administrator from passwords.properties: Could not create system administrator user “Administrator” as specified in password.properties: The username is not available

    20:51:08,557 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:51:08,557 [ServerService Thread Pool -- 160] INFO com.appiancorp.suite.PasswordConfiguration - Successfully read and encrypted passwords from conf/passwords.properties.

    20:51:08,573 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:51:08,573 [ServerService Thread Pool -- 160] INFO com.appiancorp.suite.PasswordConfiguration - Deleted /C:/appian182/appian/conf/passwords.properties.

    20:51:12,480 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:51:12,480 [ServerService Thread Pool -- 160] INFO com.appiancorp.common.spring.AbstractSpringContextListener - Received ContextRefreshedEvent: org.springframework.context.event.ContextRefreshedEvent[source=Root WebApplicationContext: startup date [Thu Jul 19 20:50:16 GMT 2018]; root of context hierarchy]

    20:51:12,496 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:51:12,496 [ServerService Thread Pool -- 160] INFO com.appiancorp.common.spring.AbstractSpringContextListener - Received ContextRefreshedEvent: org.springframework.context.event.ContextRefreshedEvent[source=Root WebApplicationContext: startup date [Thu Jul 19 20:50:16 GMT 2018]; root of context hierarchy]

    20:51:12,496 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:51:12,496 [ServerService Thread Pool -- 160] INFO com.appiancorp.common.spring.AbstractSpringContextListener - Received ContextRefreshedEvent: org.springframework.context.event.ContextRefreshedEvent[source=Root WebApplicationContext: startup date [Thu Jul 19 20:50:16 GMT 2018]; root of context hierarchy]

    20:51:12,543 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:51:12,543 [ServerService Thread Pool -- 160] INFO com.appiancorp.common.spring.AbstractSpringContextListener - Received ContextRefreshedEvent: org.springframework.context.event.ContextRefreshedEvent[source=Root WebApplicationContext: startup date [Thu Jul 19 20:50:16 GMT 2018]; root of context hierarchy]

    20:51:12,559 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:51:12,559 [ServerService Thread Pool -- 160] INFO com.appiancorp.ix.spring.IaSpringContextListener - Enabling ia listener for Appian data source transactions.

    20:51:12,574 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:51:12,574 [ServerService Thread Pool -- 160] INFO com.appiancorp.ix.spring.IaSpringContextListener - Scheduling ia replication timer with a 60000 ms delay.

    20:51:12,590 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:51:12,590 [ServerService Thread Pool -- 160] INFO com.appiancorp.common.spring.AbstractSpringContextListener - Received ContextRefreshedEvent: org.springframework.context.event.ContextRefreshedEvent[source=Root WebApplicationContext: startup date [Thu Jul 19 20:50:16 GMT 2018]; root of context hierarchy]

    20:51:12,590 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:51:12,590 [ServerService Thread Pool -- 160] INFO com.appiancorp.tempo.rdbms.index.NewsIndexSpringContextListener - Enabling news listener for Appian data source transactions.

    20:51:12,605 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:51:12,605 [ServerService Thread Pool -- 160] INFO com.appiancorp.tempo.rdbms.index.NewsIndexSpringContextListener - Scheduling news replication timer with a 60000 ms delay.

    20:51:12,621 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:51:12,621 [ServerService Thread Pool -- 160] INFO com.appiancorp.common.spring.AbstractSpringContextListener - Received ContextRefreshedEvent: org.springframework.context.event.ContextRefreshedEvent[source=Root WebApplicationContext: startup date [Thu Jul 19 20:50:16 GMT 2018]; root of context hierarchy]

    20:51:12,637 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:51:12,637 [ServerService Thread Pool -- 160] INFO com.appiancorp.object.schema.SchemaCreatorImpl - Checking for patch schema in Data Server...

    20:51:12,949 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:51:12,949 [ServerService Thread Pool -- 160] INFO com.appiancorp.object.schema.SchemaCreatorImpl - Schema already exists.

    20:51:26,560 INFO [stdout] (Appian Timer - 2) 2018-07-19 20:51:26,560 [Appian Timer - 2] WARN com.appiancorp.common.sigar.SigarLoader - Sigar native library not found at /native/sigar/sigar-amd64-winnt.dll

    20:51:26,591 INFO [stdout] (Appian Timer - 2) 2018-07-19 20:51:26,591 [Appian Timer - 2] WARN com.appiancorp.common.sigar.SigarLoader - Sigar native library not available. Some system metrics are not available on Windows.

    20:51:29,813 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:51:29,813 [ServerService Thread Pool -- 160] INFO com.appiancorp.rdbms.datasource.BusinessDataSourceValidator - Validating data sources.

    20:51:29,860 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:51:29,860 [ServerService Thread Pool -- 160] INFO com.appiancorp.plugins.PluginLoader - Appian Plug-in Framework starting for directory [C:\appian182\appian\_admin\plugins]

    20:52:10,133 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:52:10,133 [ServerService Thread Pool -- 160] INFO com.appiancorp.plugins.LoggingPluginEventListener - Successfully installed Plug-in 'Atlassian Template Renderer Velocity 1.6 Plugin' (com.atlassian.templaterenderer.atlassian-template-renderer-velocity16-plugin-1.3.1) version 1.3.1.

    20:52:10,149 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:52:10,149 [ServerService Thread Pool -- 160] INFO com.appiancorp.plugins.LoggingPluginEventListener - Successfully installed Plug-in 'Appian Integration - SAP' (appian.integration.sap) version 1.0.69.

    20:52:10,180 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:52:10,180 [ServerService Thread Pool -- 160] INFO com.appiancorp.plugins.LoggingPluginEventListener - Successfully installed Plug-in 'Appian Smart Services' (appian.system.smart-services) version 18.2.20.

    20:52:10,196 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:52:10,196 [ServerService Thread Pool -- 160] INFO com.appiancorp.plugins.LoggingPluginEventListener - Successfully installed Plug-in 'Appian Integration - Salesforce' (appian.integration.salesforce) version 1.0.69.

    20:52:10,211 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:52:10,211 [ServerService Thread Pool -- 160] INFO com.appiancorp.plugins.LoggingPluginEventListener - Successfully installed Plug-in 'Atlassian Template Renderer API' (com.atlassian.templaterenderer.atlassian-template-renderer-api-1.3.1) version 1.3.1.

    20:52:10,227 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:52:10,227 [ServerService Thread Pool -- 160] INFO com.appiancorp.plugins.LoggingPluginEventListener - Successfully installed Plug-in 'Appian Integration - HTTP' (appian.integration.httpclient) version 18.2.20.

    20:52:10,258 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:52:10,258 [ServerService Thread Pool -- 160] INFO com.appiancorp.plugins.LoggingPluginEventListener - Successfully installed Plug-in 'Appian Integration - SharePoint' (appian.integration.sharepoint) version 1.0.69.

    20:52:10,290 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:52:10,274 [ServerService Thread Pool -- 160] INFO com.appiancorp.plugins.LoggingPluginEventListener - Successfully installed Plug-in 'Appian Integration - Siebel' (appian.integration.siebel) version 1.0.69.

    20:52:10,321 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:52:10,321 [ServerService Thread Pool -- 160] INFO com.appiancorp.plugins.LoggingPluginEventListener - Successfully installed Plug-in 'Appian REST API' (appian.system.rest-api) version 18.2.20.

    20:52:10,352 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:52:10,352 [ServerService Thread Pool -- 160] INFO com.appiancorp.plugins.LoggingPluginEventListener - Successfully installed Plug-in 'Appian Integration - CMIS' (appian.integration.cmis) version 1.0.69.

    20:52:10,352 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:52:10,352 [ServerService Thread Pool -- 160] INFO com.appiancorp.plugins.LoggingPluginEventListener - Successfully installed Plug-in 'Atlassian REST - Module Types' (com.atlassian.plugins.rest.atlassian-rest-module) version 2.6.7.

    20:52:10,383 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:52:10,383 [ServerService Thread Pool -- 160] INFO com.appiancorp.plugins.LoggingPluginEventListener - Successfully installed Plug-in 'Appian Integration - Dynamics' (appian.integration.dynamics) version 1.0.69.

    20:52:10,415 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:52:10,415 [ServerService Thread Pool -- 160] INFO com.appiancorp.plugins.PluginLoader - Appian Plug-in Framework started in 0:00:40.555

    20:52:10,430 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:52:10,430 [ServerService Thread Pool -- 160] INFO com.appiancorp.applications.BundledApplicationsLoader - Loading system objects.

    20:52:10,461 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:52:10,461 [ServerService Thread Pool -- 160] INFO com.appiancorp.applications.BundledApplicationsLoader - Completed loading system objects in 0:00:00.031

    20:52:10,508 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:52:10,508 [ServerService Thread Pool -- 160] INFO com.appiancorp.process.workpoller.UnattendedRequestPollerLoader - Unattended Request Polling Framework started in 0:00:00.015

    20:52:10,748 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:52:10,747 [ServerService Thread Pool -- 160] INFO com.appiancorp.process.jms.JmsProcessIntegrationLoader - JMS Process Integration Framework started in 0:00:00.239

    20:52:10,752 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:52:10,751 [ServerService Thread Pool -- 160] INFO com.appiancorp.process.emailpoller.EmailPollerLoader - No endpoints configured in custom.properties...EmailPoller will not be enabled

    20:52:10,964 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:52:10,964 [ServerService Thread Pool -- 160] INFO com.appiancorp.common.web.WeblogicSessionAttributeClassLoaderRequestFilter - WeblogicSessionAttributeClassLoaderRequestFilter enabled = false server info = JBoss Web/7.5.7.Final-redhat-1

    20:52:12,189 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/suite]] (ServerService Thread Pool -- 160) org.tuckey.web.filters.urlrewrite.UrlRewriteFilter INFO: loaded (conf ok)
    20:52:12,360 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/suite]] (ServerService Thread Pool -- 160) org.tuckey.web.filters.urlrewrite.UrlRewriteFilter INFO: loaded (conf ok)
    20:52:15,421 INFO [org.jboss.as.server] (ServerService Thread Pool -- 30) JBAS015859: Deployed "appian-mysql-ds.xml" (runtime-name : "appian-mysql-ds.xml")
    20:52:15,422 INFO [org.jboss.as.server] (ServerService Thread Pool -- 30) JBAS015859: Deployed "suite.ear" (runtime-name : "suite.ear")
    20:52:15,601 INFO [org.jboss.as] (Controller Boot Thread) JBAS015961: Http management interface listening on 127.0.0.1:9990/management
    20:52:15,640 INFO [org.jboss.as] (Controller Boot Thread) JBAS015951: Admin console listening on http://127.0.0.1:9990
    20:52:15,642 INFO [org.jboss.as] (Controller Boot Thread) JBAS015874: JBoss EAP 6.4.0.GA (AS 7.5.0.Final-redhat-21) started in 170782ms - Started 1528 of 1565 services (73 services are lazy, passive or on-demand)
    20:59:17,001 INFO [com.sun.jersey.server.impl.application.WebApplicationImpl] (http-/0.0.0.0:8080-1) Initiating Jersey application, version 'Jersey: 1.8-atlassian-6 03/12/2012 02:59 PM'
  • 0
    Certified Lead Developer
    in reply to michaelg910

    Hello michaelg910,

    Source of the issue is here:

    20:51:08,557 INFO [stdout] (ServerService Thread Pool -- 160) 2018-07-19 20:51:08,557 [ServerService Thread Pool -- 160] ERROR com.appiancorp.suite.PasswordConfiguration - Could not create system administrator Administrator from passwords.properties: Could not create system administrator user “Administrator” as specified in password.properties: The username is not available

    Just choose a different username than "Administrator".

    Mat

  • Hi Mat,

    That was indeed the solution. For whatever reason the username was saved the first time through but not the user password. Since the username needs to be unique I just restarted with a different one specified in the password.properties file, and the .dev one too, and it was created.

    Thanks
    Mike