search

billchen198318 / bamboobsc

next version move to https://github.com/billchen198318/hillfog, bambooBSC is an opensource Balanced Scorecard (BSC) Business Intelligence (BI) Web platform. BSC's Vision, Perspectives, Objectives of strategy, Key Performance Indicators (KPIs), Strategy Map, and SWOT, PDCA & PDCA report, Time Series Analysis.
Apache License 2.0
227 stars 110 forks source link

tomcat server not starting with startup.sh. #77

Closed mahesh-wor closed 5 years ago

mahesh-wor commented 5 years ago

i get "Tomcat Started" success message but " can't seem to access anything on localhost:8080. can't anything in "netstat -l".

billchen198318 commented 5 years ago

trace log /tmp/greenstep-core.log , /tmp/greenstep-bsc.log

mahesh-wor commented 5 years ago

2018-12-10 13:19:36 [] WARN ClassPathXmlApplicationContext:551 - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'scheduler' defined in URL [file:/home/bamboobsc-0.7.5-RELEASE/bamboobsc-07/apache-tomcat-8.5.35/webapps/gsbsc-web/WEB-INF/classes/applicationContext/applicationContext-STANDARD-QUARTZ.xml]: Invocation of init method failed; nested exception is org.quartz.JobPersistenceException: Couldn't retrieve trigger: Table 'bbcore.qrtz_z_bsc_TRIGGERS' doesn't exist [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'bbcore.qrtz_z_bsc_TRIGGERS' doesn't exist] 2018-12-10 13:19:36 [] INFO SpringCamelContext:3496 - Apache Camel 2.23.0 (CamelContext: esb.BSC-SystemCamelContext) is shutting down 2018-12-10 13:19:36 [] INFO SpringCamelContext:3596 - Apache Camel 2.23.0 (CamelContext: esb.BSC-SystemCamelContext) uptime 2018-12-10 13:19:36 [] INFO SpringCamelContext:3597 - Apache Camel 2.23.0 (CamelContext: esb.BSC-SystemCamelContext) is shutdown in 0.002 seconds 2018-12-10 13:19:36 [] INFO DefaultAsyncJobExecutor:208 - Shutting down the default async job executor [org.activiti.engine.impl.asyncexecutor.DefaultAsyncJobExecutor]. 2018-12-10 13:19:36 [] INFO AcquireTimerJobsRunnable:115 - {} stopped async job due acquisition 2018-12-10 13:19:36 [] INFO ResetExpiredJobsRunnable:99 - {} stopped resetting expired jobs 2018-12-10 13:19:36 [] INFO AcquireAsyncJobsDueRunnable:115 - {} stopped async job due acquisition 2018-12-10 13:19:36 [] INFO EhCacheManagerFactoryBean:187 - Shutting down EhCache CacheManager 2018-12-10 13:19:36 [] INFO JMXPlatformImpl:76 - Unregistering existing Dozer JMX MBean [org.dozer.jmx:type=DozerAdminController]. 2018-12-10 13:19:36 [] INFO JMXPlatformImpl:76 - Unregistering existing Dozer JMX MBean [org.dozer.jmx:type=DozerStatisticsController]. 2018-12-10 13:19:36 [] INFO HikariDataSource:350 - HikariPool-4 - Shutdown initiated... 2018-12-10 13:19:36 [] INFO HikariDataSource:352 - HikariPool-4 - Shutdown completed.

mahesh-wor commented 5 years ago

it says "bbcore.qrtz_z_bsc_TRIGGERS' doesn't exists. and then shutsdown. I am running it on lxc-container ; "ubuntu;xenial".

billchen198318 commented 5 years ago

Please view install.pdf , you no set mysql lower_case_table_names config

mahesh-wor commented 5 years ago

2018-12-10 13:56:32 [] WARN ClassPathXmlApplicationContext:551 - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngine': FactoryBean threw exception on object creation; nested exception is org.activiti.engine.ActivitiException: couldn't check if tables are already present using metadata: Access denied for user 'root'@'localhost' (using password: YES) 2018-12-10 13:56:32 [] INFO EhCacheManagerFactoryBean:187 - Shutting down EhCache CacheManager 2018-12-10 13:56:32 [] INFO JMXPlatformImpl:76 - Unregistering existing Dozer JMX MBean [org.dozer.jmx:type=DozerAdminController]. 2018-12-10 13:56:32 [] INFO JMXPlatformImpl:76 - Unregistering existing Dozer JMX MBean [org.dozer.jmx:type=DozerStatisticsController]. 2018-12-10 13:56:32 [] INFO USessLogHelperImpl:58 - delete tb_sys_usess data!...

looks like i can't access mysql.

billchen198318 commented 5 years ago

Please check core-web , gsbsc-web, gsbsc-mobile-web the three web module applicationContext-dataSource.properties has settings OK.

billchen198318 commented 5 years ago

Please view the issues : https://github.com/billchen198318/bamboobsc/issues/70 like you problem.

mahesh-wor commented 5 years ago

checked those 3 web module's setting they are good. But i am still getting denied root@localhost & some other exceptions.

greenstep-bsc.log greenstep-core.log greenstep-bsc-mobile.log

billchen198318 commented 5 years ago

I try the bambooBSC-0.7.5 RELEASE in ununtu-18.04.1.0 Server work success in VM.

My apt-install package list:

  1. mysql-server (MySQL 5.7)
  2. openjdk-8-jre-headless (open-JRE8)
  3. p7zip-full (decompress .7z file)

and has config /etc/mysql/mysql.conf.d/mysqld.cnf add lower_case_table_names=1 and success import bbcore.sql to database.

my start tomcat service command: sudo catalina.sh run

2018-12-11 08-32-54

mahesh-wor commented 5 years ago

i did manage to run in using VM through the image you provided on your site. but, i couldn't get it to work from scratch on my either of my containers(lxc/docker). it would be great if you could maybe try running it on docker and may be push out images on hub.docker or share your Dockerfile.

billchen198318 commented 5 years ago

I think when I have time, I will create a Dockerfile. need wait.