Hi,
I have downloaded flowable-6.3.0.zip, modified all the application.properties inside war to enable the postgresql connection and disable the h2 connection, run the db script flowable.postgres.all.create.sql, deploy into Tomcat 8.5.30 on Ubuntu.
Out of 5 wars, only flowable-admin.war and flowable-modeler.war able to start.
Rest of wars, flowable-idm.war, flowable-task.war and flowable-rest.war couldn’t start.
The error message from catalina.out as following,
////////// &&&& &&& ,,, ,,,
////////////// &&&&&&& &&& , ,
/// /// &&& &&& , ,
//////// /// &&&&&&&& &&& &&&&&&& &&& &&& &&& , , , ,
////// // /// &&&&&&&& &&& &&&& &&&& &&& &&& &&& , , , , , , ,
/// //// /// &&& &&& &&& &&& &&& &&& &&& , , , , , ,
// ///// /// &&& &&& &&& &&&& &&& &&& &&& , , , , , ,
/////////// &&& &&& &&&&&&&& &&&&&&&&&&&&&& , , , ,
:: Flowable :: (v6.3.0) :: Spring Boot :: (v2.0.0.RELEASE)
2018-05-09 12:18:58,234 [localhost-startStop-1] INFO org.flowable.app.idm.application.FlowableIdmApplication - Starting FlowableIdmApplication v6.3.0 on ubuntu-nuxeo with PID 76339 (/opt/tomcat/webapps/flowable-idm/WEB-INF/classes started by tomcat in /)
2018-05-09 12:18:58,235 [localhost-startStop-1] INFO org.flowable.app.idm.application.FlowableIdmApplication - No active profile set, falling back to default profiles: default
2018-05-09 12:18:58,446 [localhost-startStop-1] INFO org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext - Refreshing org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext@71efd583: startup date [Wed May 09 12:18:58 CST 2018]; root of context hierarchy
2018-05-09 12:18:58,626 [localhost-startStop-1] INFO org.springframework.context.annotation.ConfigurationClassParser - Properties location [classpath:/META-INF/flowable-ui-app/flowable-ui-app.properties] not resolvable: class path resource [META-INF/flowable-ui-app/flowable-ui-app.properties] cannot be opened because it does not exist
2018-05-09 12:18:58,626 [localhost-startStop-1] INFO org.springframework.context.annotation.ConfigurationClassParser - Properties location [classpath:flowable-ui-app.properties] not resolvable: class path resource [flowable-ui-app.properties] cannot be opened because it does not exist
2018-05-09 12:18:58,629 [localhost-startStop-1] INFO org.springframework.context.annotation.ConfigurationClassParser - Properties location [file:flowable-ui-app.properties] not resolvable: flowable-ui-app.properties (No such file or directory)
2018-05-09 12:18:59,485 [localhost-startStop-1] INFO org.springframework.beans.factory.support.DefaultListableBeanFactory - Overriding bean definition for bean ‘dataSource’ with a different definition: replacing [Root bean: class [null]; scope=; abstract=false; lazyInit=false; autowireMode=3; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=org.springframework.boot.autoconfigure.jdbc.DataSourceConfiguration$Tomcat; factoryMethodName=dataSource; initMethodName=null; destroyMethodName=(inferred); defined in class path resource [org/springframework/boot/autoconfigure/jdbc/DataSourceConfiguration$Tomcat.class]] with [Root bean: class [null]; scope=; abstract=false; lazyInit=false; autowireMode=3; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=org.springframework.boot.autoconfigure.jdbc.DataSourceConfiguration$Hikari; factoryMethodName=dataSource; initMethodName=null; destroyMethodName=(inferred); defined in class path resource [org/springframework/boot/autoconfigure/jdbc/DataSourceConfiguration$Hikari.class]]
2018-05-09 12:19:00,452 [localhost-startStop-1] INFO org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean ‘org.springframework.security.config.annotation.configuration.ObjectPostProcessorConfiguration’ of type [org.springframework.security.config.annotation.configuration.ObjectPostProcessorConfiguration$$EnhancerBySpringCGLIB$$838dcb96] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2018-05-09 12:19:00,465 [localhost-startStop-1] INFO org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean ‘org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration’ of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$eae0035c] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2018-05-09 12:19:00,523 [localhost-startStop-1] INFO org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean ‘objectPostProcessor’ of type [org.springframework.security.config.annotation.configuration.AutowireBeanFactoryObjectPostProcessor] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2018-05-09 12:19:00,524 [localhost-startStop-1] INFO org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean ‘org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@6fa5a93f’ of type [org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2018-05-09 12:19:00,534 [localhost-startStop-1] INFO org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean ‘org.springframework.security.config.annotation.method.configuration.Jsr250MetadataSourceConfiguration’ of type [org.springframework.security.config.annotation.method.configuration.Jsr250MetadataSourceConfiguration$$EnhancerBySpringCGLIB$$cdb7865e] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2018-05-09 12:19:00,544 [localhost-startStop-1] INFO org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean ‘jsr250MethodSecurityMetadataSource’ of type [org.springframework.security.access.annotation.Jsr250MethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2018-05-09 12:19:00,548 [localhost-startStop-1] INFO org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean ‘org.springframework.security.config.annotation.method.configuration.GlobalMethodSecurityConfiguration’ of type [org.springframework.security.config.annotation.method.configuration.GlobalMethodSecurityConfiguration$$EnhancerBySpringCGLIB$$a8626e48] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2018-05-09 12:19:00,562 [localhost-startStop-1] INFO org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean ‘org.flowable.app.properties.FlowableRemoteIdmAutoConfiguration’ of type [org.flowable.app.properties.FlowableRemoteIdmAutoConfiguration$$EnhancerBySpringCGLIB$$628f4076] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2018-05-09 12:19:00,580 [localhost-startStop-1] INFO org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean ‘org.springframework.boot.context.properties.ConversionServiceDeducer$Factory’ of type [org.springframework.boot.context.properties.ConversionServiceDeducer$Factory] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2018-05-09 12:19:00,602 [localhost-startStop-1] INFO org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean ‘flowable.common.app-org.flowable.app.properties.FlowableCommonAppProperties’ of type [org.flowable.app.properties.FlowableCommonAppProperties] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2018-05-09 12:19:00,606 [localhost-startStop-1] INFO org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean ‘grantedAuthorityDefaults’ of type [org.springframework.security.config.core.GrantedAuthorityDefaults] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2018-05-09 12:19:00,610 [localhost-startStop-1] INFO org.springframework.context.support.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean ‘methodSecurityMetadataSource’ of type [org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2018-05-09 12:19:00,633 [localhost-startStop-1] INFO org.springframework.web.context.ContextLoader - Root WebApplicationContext: initialization completed in 2187 ms
2018-05-09 12:19:02,096 [localhost-startStop-1] INFO org.springframework.boot.web.servlet.FilterRegistrationBean - Mapping filter: ‘characterEncodingFilter’ to: [/]
2018-05-09 12:19:02,097 [localhost-startStop-1] INFO org.springframework.boot.web.servlet.FilterRegistrationBean - Mapping filter: ‘errorPageFilter’ to: [/]
2018-05-09 12:19:02,097 [localhost-startStop-1] INFO org.springframework.boot.web.servlet.FilterRegistrationBean - Mapping filter: ‘hiddenHttpMethodFilter’ to: [/]
2018-05-09 12:19:02,097 [localhost-startStop-1] INFO org.springframework.boot.web.servlet.FilterRegistrationBean - Mapping filter: ‘httpPutFormContentFilter’ to: [/]
2018-05-09 12:19:02,097 [localhost-startStop-1] INFO org.springframework.boot.web.servlet.FilterRegistrationBean - Mapping filter: ‘requestContextFilter’ to: [/]
2018-05-09 12:19:02,097 [localhost-startStop-1] INFO org.springframework.boot.web.servlet.DelegatingFilterProxyRegistrationBean - Mapping filter: ‘springSecurityFilterChain’ to: [/]
2018-05-09 12:19:02,097 [localhost-startStop-1] INFO org.springframework.boot.web.servlet.FilterRegistrationBean - Mapping filter: ‘httpTraceFilter’ to: [/]
2018-05-09 12:19:02,097 [localhost-startStop-1] INFO org.springframework.boot.web.servlet.FilterRegistrationBean - Mapping filter: ‘webMvcMetricsFilter’ to: [/]
2018-05-09 12:19:02,097 [localhost-startStop-1] INFO org.springframework.boot.web.servlet.ServletRegistrationBean - Servlet Flowable IDM App API Servlet mapped to [/api/*]
2018-05-09 12:19:02,099 [localhost-startStop-1] INFO org.springframework.boot.web.servlet.ServletRegistrationBean - Servlet dispatcherServlet mapped to [/]
2018-05-09 12:19:02,374 [localhost-startStop-1] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting…
2018-05-09 12:19:02,502 [localhost-startStop-1] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Start completed.
2018-05-09 12:19:03,041 [localhost-startStop-1] ERROR org.flowable.engine.common.impl.db.AbstractSqlScriptBasedDbSchemaManager - Could not get property from table ACT_ID_PROPERTY
org.postgresql.util.PSQLException: ERROR: permission denied for relation act_id_property
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:155)
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:118)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
at org.flowable.engine.common.impl.db.AbstractSqlScriptBasedDbSchemaManager.getProperty(AbstractSqlScriptBasedDbSchemaManager.java:187)
at org.flowable.engine.common.impl.db.ServiceSqlScriptBasedDbSchemaManager.getSchemaVersion(ServiceSqlScriptBasedDbSchemaManager.java:103)
at org.flowable.engine.common.impl.db.ServiceSqlScriptBasedDbSchemaManager.dbSchemaUpdate(ServiceSqlScriptBasedDbSchemaManager.java:67)
at org.flowable.idm.engine.impl.db.IdmDbSchemaManager.performSchemaOperationsIdmEngineBuild(IdmDbSchemaManager.java:154)
at org.flowable.idm.engine.impl.SchemaOperationsIdmEngineBuild.execute(SchemaOperationsIdmEngineBuild.java:29)
at org.flowable.engine.common.impl.interceptor.DefaultCommandInvoker.execute(DefaultCommandInvoker.java:10)
at org.flowable.engine.common.impl.interceptor.TransactionContextInterceptor.execute(TransactionContextInterceptor.java:53)
at org.flowable.engine.common.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:71)
at org.flowable.idm.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:49)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)
at org.flowable.idm.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:46)
at org.flowable.engine.common.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:30)
at org.flowable.engine.common.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:56)
at org.flowable.idm.engine.impl.IdmEngineImpl.(IdmEngineImpl.java:45)
at org.flowable.idm.engine.IdmEngineConfiguration.buildIdmEngine(IdmEngineConfiguration.java:173)
at org.flowable.idm.spring.SpringIdmEngineConfiguration.buildIdmEngine(SpringIdmEngineConfiguration.java:48)
at org.flowable.idm.spring.IdmEngineFactoryBean.getObject(IdmEngineFactoryBean.java:53)
at org.flowable.idm.spring.IdmEngineFactoryBean.getObject(IdmEngineFactoryBean.java:30)
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:161)
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:101)
at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1645)