Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

New pom.xml file #29

Open
DSSUSER opened this issue Aug 12, 2019 · 38 comments
Open

New pom.xml file #29

DSSUSER opened this issue Aug 12, 2019 · 38 comments

Comments

@DSSUSER
Copy link

DSSUSER commented Aug 12, 2019

The old pom.xml file had entries for each of the following entries:

datasource1.user
datasource1.password

datasource2.user
datasoruce2.password

github.username
github.password

The new pom.xml does not contain any of these login credentials.

Am I missing something?

Are these credentials no longer needed?

Do I need to plug these entries into the new pom.xml?

Or, do we need to configure these credentials somewhere else now?

@aniskand
Copy link
Collaborator

Which pom are you referring to? The one in the most recent branch does have those parameters,

https://github.com/VHAINNOVATIONS/InfoButtons/blob/2.3-SNAPSHOT/oib-request/pom.xml

@DSSUSER
Copy link
Author

DSSUSER commented Aug 12, 2019

Sorry, there was some confusion.

In one of your notes, you mentioned copying a new pom.xml file into place.

This new pom.xml file did not contain any of these credentials.

I went back to the pom.xml that was delivered with the 2.3 branch, and used it.

So, hopefully, that issue is resolved.

@DSSUSER
Copy link
Author

DSSUSER commented Aug 12, 2019

There are two errors in one of your delivered SQL scripts:

valueset_and_log.sql

Line 22 is missing a ";" at the end of the line.

Line 41 is missing a "," at the end of the line.

@DSSUSER
Copy link
Author

DSSUSER commented Aug 12, 2019

I managed to get everything installed, without any further errors.

The Site Lite GUI is coming up.

But, none of the links are working.

If I click on any of the menu item links, nothing happens.

Any ideas or suggestions at this point would be greatly appreciated.

@aniskand
Copy link
Collaborator

In which branch did you find those SQL errors? I thought those were fixed in 2.3.

Sometimes LITE doesn't build right with just the npm start command. Trying running ,

npm install -g bower
bower install

from the oib-site-lite-ui folder, before running 'npm start'. Let me know if that helps.

@aniskand aniskand reopened this Aug 12, 2019
@DSSUSER
Copy link
Author

DSSUSER commented Aug 12, 2019

We still get the maven build error, when trying to install Maven:

[INFO] Reactor Summary for oib-request 2.3-SNAPSHOT:
[INFO]
[INFO] oib-request ........................................ SUCCESS [ 1.609 s]
[INFO] oib-profile-schema ................................. SUCCESS [ 8.070 s]
[INFO] oib-service-test ................................... SUCCESS [ 1.632 s]
[INFO] oib-request-schema ................................. SUCCESS [ 2.419 s]
[INFO] OIB Core Utility Module ............................ SUCCESS [ 1.919 s]
[INFO] oib-valueset-matcher ............................... SUCCESS [ 0.405 s]
[INFO] oib-request-db ..................................... SUCCESS [ 1.494 s]
[INFO] oib-request-inference-rxnorm ....................... SUCCESS [ 0.492 s]
[INFO] oib-ext-resources .................................. FAILURE [ 0.075 s]
[INFO] oib-request-service ................................ SKIPPED
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 18.353 s
[INFO] Finished at: 2019-08-12T15:52:53-04:00
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal on project oib-ext-resources: Could not resolve dependencies for project org.openinfobutton:oib-ext-resources:jar:2.3-SNAPSHOT: The following artifacts could not be resolved: org.openinfobutton:rest-api:jar:1.2-SNAPSHOT, org.openinfobutton:rest-impl:jar:1.2-SNAPSHOT: Could not find artifact org.openinfobutton:rest-api:jar:1.2-SNAPSHOT -> [Help 1]
org.apache.maven.lifecycle.LifecycleExecutionException: Failed to execute goal on project oib-ext-resources: Could not resolve dependencies for project org.openinfobutton:oib-ext-resources:jar:2.3-SNAPSHOT: The following artifacts could not be resolved: org.openinfobutton:rest-api:jar:1.2-SNAPSHOT, org.openinfobutton:rest-impl:jar:1.2-SNAPSHOT: Could not find artifact org.openinfobutton:rest-api:jar:1.2-SNAPSHOT

@aniskand
Copy link
Collaborator

@DSSUSER
Copy link
Author

DSSUSER commented Aug 12, 2019

That was it!

Maven built cleanly.

Thanks.

@DSSUSER
Copy link
Author

DSSUSER commented Aug 13, 2019

I do have one more issue that I need assistance with.

When I attempt to run "npm start", it errors out:

--> npm start
npm ERR! Linux 3.10.0-957.27.2.el7.x86_64
npm ERR! argv "/usr/bin/node" "/bin/npm" "start"
npm ERR! node v6.17.1
npm ERR! npm v3.10.10
npm ERR! path /etc/systemd/system/package.json
npm ERR! code ENOENT
npm ERR! errno -2
npm ERR! syscall open

npm ERR! enoent ENOENT: no such file or directory, open '/etc/systemd/system/package.json'
npm ERR! enoent ENOENT: no such file or directory, open '/etc/systemd/system/package.json'
npm ERR! enoent This is most likely not a problem with npm itself
npm ERR! enoent and is related to npm not being able to find a file.
npm ERR! enoent

npm ERR! Please include the following file with any support request:
npm ERR! /etc/systemd/system/npm-debug.log

Here is the output from the "npm-debug.log":

0 info it worked if it ends with ok
1 verbose cli [ '/usr/bin/node', '/bin/npm', 'start' ]
2 info using [email protected]
3 info using [email protected]
4 verbose stack Error: ENOENT: no such file or directory, open '/etc/systemd/system/package.json'
4 verbose stack at Error (native)
5 verbose cwd /etc/systemd/system
6 error Linux 3.10.0-957.27.2.el7.x86_64
7 error argv "/usr/bin/node" "/bin/npm" "start"
8 error node v6.17.1
9 error npm v3.10.10
10 error path /etc/systemd/system/package.json
11 error code ENOENT
12 error errno -2
13 error syscall open
14 error enoent ENOENT: no such file or directory, open '/etc/systemd/system/package.json'
15 error enoent ENOENT: no such file or directory, open '/etc/systemd/system/package.json'
15 error enoent This is most likely not a problem with npm itself
15 error enoent and is related to npm not being able to find a file.
16 verbose exit [ -2, true ]

@DSSUSER
Copy link
Author

DSSUSER commented Aug 13, 2019

Note that tomcat and mariadb both start just fine.

Note that the SITE LITE GUI is up and running, but I am not able to login to the GUI.

Maybe I'm using the wrong LoginID and Password, but maybe it's related to the fact that npm did not start.

@DSSUSER
Copy link
Author

DSSUSER commented Aug 13, 2019

I managed to fix the "npm start" issue.

I did not realize that we needed to clone the Angular repository, or copy the package.json to the tomcat webapps directory.

This is not something we needed to do in the original install we did more than 2 years ago.

But, it appears to be running now.

@aniskand
Copy link
Collaborator

aniskand commented Aug 13, 2019 via email

@DSSUSER
Copy link
Author

DSSUSER commented Aug 13, 2019

And, what is the best way to stop it?

The man page was not very helpful, and neither was "npm help"

@lrasmus
Copy link
Collaborator

lrasmus commented Aug 13, 2019

I have used PM2 for other node apps for stopping/starting/logging.

@DSSUSER
Copy link
Author

DSSUSER commented Aug 13, 2019

Also, is there any specific order in which the services need to be stopped?

NPM first, or Tomcat first?

@aniskand
Copy link
Collaborator

aniskand commented Aug 13, 2019 via email

@DSSUSER
Copy link
Author

DSSUSER commented Aug 13, 2019

Are we supposed to be "in" a particular directory when we run the "npm start" command?

It appears as if it is creating the "npm-debug.log" in whatever directory we happen to be in, when the command is run.

Additionally, we need to run the "npm start" command from a directory structure that has a package.json file.

So, is there a particular directory that we need to be in, when we run the "npm start" command?

@aniskand
Copy link
Collaborator

aniskand commented Aug 13, 2019 via email

@DSSUSER
Copy link
Author

DSSUSER commented Aug 13, 2019

There appears to be 2 different package.json files:

oib-site-lite-ui/package.json

oib-client package.json

And, they appear to be different.

I have in my notes to modify "localhost" to the IP address of the server, in the oib-client version of the package.json.

Is this correct?

Do I need to change anything inside of the oib-site-lite-ui version of this package.json file?

@aniskand
Copy link
Collaborator

Yeah you can disregard the one in oib-client, I'm going to actually move that module to a different branch. Just use the one in oib-site-lite-ui/package.json

@DSSUSER
Copy link
Author

DSSUSER commented Aug 13, 2019

Ok, a few more questions for clarification:

Originally, your documentation tells us to clone the angular-seed from the oib-client directory structure, in order to install bower.

But, earlier, when I was having problems with the Maven build, you told me to install bower manually from the oib-site-lite-ui folder.

Did I need to install the angular-seed?

And, if I installed the angular-seed from the oib-client directory, did I still need to install bower from within the oib-site-lite-ui directory?

@DSSUSER
Copy link
Author

DSSUSER commented Aug 13, 2019

Finally, which UserID should I use when logging into the Site Lite GUI?

@aniskand
Copy link
Collaborator

If you ran this script to create the user database for LITE,

https://github.com/VHAINNOVATIONS/InfoButtons/blob/2.3-SNAPSHOT/DeploymentPackage/dbScripts/userAuthentication.sql

then the username / password are the defaults that were inserted by the script,

INSERT INTO users (username, password, role) VALUES ('root', 'password', 'ADMIN');

@DSSUSER
Copy link
Author

DSSUSER commented Aug 13, 2019

Everything appears to be up and running. NPM, Tomcat, MariaDB.

The GUI is up, and I can get to the GUI just fine.

But, I still can not login to the Site Lite GUI.

Any ideas?

@DSSUSER
Copy link
Author

DSSUSER commented Aug 13, 2019

I verified that the "username" and "password" entered via the userAuthentication.sql script are in fact what I am entering in the GUI credential login prompt.

But, they do not seem to be working.

Is there anyplace else where these values might have been configured?

@DSSUSER
Copy link
Author

DSSUSER commented Aug 14, 2019

Are there any new instructions, specifically as they pertain to installing and configuring the SITE LITE GUI?

As I noted earlier, the GUI is coming up, but I can not seem to login to it.

And, the OpenInfobuttonDemo.html is not loading.

I'm getting an "Http Status 404 - Not Found.

@aniskand
Copy link
Collaborator

aniskand commented Aug 14, 2019 via email

@DSSUSER
Copy link
Author

DSSUSER commented Aug 14, 2019

--> cat localhost_access_log.2019-08-14.txt
10.16.90.58 - - [14/Aug/2019:08:56:56 -0400] "GET /infobutton-service/OpenInfobuttonDemo.html HTTP/1.1" 404 1120
10.16.90.58 - - [14/Aug/2019:08:56:56 -0400] "GET /favicon.ico HTTP/1.1" 200 21630
10.16.90.58 - - [14/Aug/2019:08:56:58 -0400] "GET /infobutton-service/OpenInfobuttonDemo.html HTTP/1.1" 404 1120
10.16.90.58 - - [14/Aug/2019:08:56:58 -0400] "GET /favicon.ico HTTP/1.1" 200 21630
10.16.90.58 - - [14/Aug/2019:08:57:46 -0400] "POST /infobutton-service/liteManager/getUser HTTP/1.1" 404 1120
10.16.90.58 - - [14/Aug/2019:09:09:53 -0400] "GET /app/index.html HTTP/1.1" 304 -
10.16.90.58 - - [14/Aug/2019:09:09:53 -0400] "GET /favicon.ico HTTP/1.1" 200 21630
10.16.90.58 - - [14/Aug/2019:09:10:14 -0400] "POST /infobutton-service/liteManager/getUser HTTP/1.1" 404 1120
10.16.90.58 - - [14/Aug/2019:09:19:46 -0400] "GET /app/index.html HTTP/1.1" 304 -
10.16.90.58 - - [14/Aug/2019:09:19:47 -0400] "GET /favicon.ico HTTP/1.1" 200 21630

@DSSUSER
Copy link
Author

DSSUSER commented Aug 14, 2019

10.16.90.58 - - [14/Aug/2019:09:52:36 -0400] "POST /infobutton-service/liteManager/getUser HTTP/1.1" 404 1120

@DSSUSER
Copy link
Author

DSSUSER commented Aug 14, 2019

I do not see a path to any "liteManager" folder under the infobutton-service folder.

@DSSUSER
Copy link
Author

DSSUSER commented Aug 14, 2019

I did a complete search through each and every file under the base InfoButtons directory, and I found references to "liteManager", but not one piece of documentation telling me how to install or configure it.

/opt/InfoButtons
--> find . -exec grep -l liteManager {} ; 2>/dev/null
./oib-request/oib-request-service/src/main/java/org/openinfobutton/service/web/ProfileManagerService.java
./oib-request/oib-request-service/target/classes/org/openinfobutton/service/web/ProfileManagerService.class
./oib-request/oib-request-service/target/infobutton-service/WEB-INF/classes/org/openinfobutton/service/web/ProfileManagerService.class
./oib-site-lite-ui/app/setup/setupServices.js
./oib-site-lite-ui/app/manager/profileServices.js
./oib-site-lite-ui/app/responder/assetServices.js
./oib-site-lite-ui/app/authentication/authenticationService.js

@aniskand
Copy link
Collaborator

aniskand commented Aug 14, 2019 via email

@DSSUSER
Copy link
Author

DSSUSER commented Aug 14, 2019

CATALINA.OUT:

14-Aug-2019 10:33:13.430 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version: Apache Tomcat/8.5.43
14-Aug-2019 10:33:13.432 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Jul 4 2019 20:53:15 UTC
14-Aug-2019 10:33:13.432 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number: 8.5.43.0
14-Aug-2019 10:33:13.432 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Linux
14-Aug-2019 10:33:13.432 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 3.10.0-957.27.2.el7.x86_64
14-Aug-2019 10:33:13.432 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: amd64
14-Aug-2019 10:33:13.432 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.222.b10-0.el7_6.x86_64/jre
14-Aug-2019 10:33:13.433 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 1.8.0_222-b10
14-Aug-2019 10:33:13.433 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: Oracle Corporation
14-Aug-2019 10:33:13.433 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: /opt/tomcat/apache-tomcat-8.5.43
14-Aug-2019 10:33:13.433 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: /opt/tomcat/apache-tomcat-8.5.43
14-Aug-2019 10:33:13.433 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/opt/tomcat/latest/conf/logging.properties
14-Aug-2019 10:33:13.433 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
14-Aug-2019 10:33:13.433 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
14-Aug-2019 10:33:13.434 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
14-Aug-2019 10:33:13.434 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.catalina.security.SecurityListener.UMASK=0027
14-Aug-2019 10:33:13.434 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs=
14-Aug-2019 10:33:13.434 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/opt/tomcat/latest
14-Aug-2019 10:33:13.434 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/opt/tomcat/latest
14-Aug-2019 10:33:13.434 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/opt/tomcat/latest/temp
14-Aug-2019 10:33:13.434 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: [/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib]
14-Aug-2019 10:33:13.530 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
14-Aug-2019 10:33:13.544 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
14-Aug-2019 10:33:13.561 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-nio-8009"]
14-Aug-2019 10:33:13.562 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
14-Aug-2019 10:33:13.569 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 543 ms
14-Aug-2019 10:33:13.598 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
14-Aug-2019 10:33:13.598 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.43
14-Aug-2019 10:33:13.623 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive [/opt/tomcat/apache-tomcat-8.5.43/webapps/infobutton-service.war]
14-Aug-2019 10:33:15.351 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
14-Aug-2019 10:33:15.381 INFO [localhost-startStop-1] org.springframework.web.context.ContextLoader.initWebApplicationContext Root WebApplicationContext: initialization started
14-Aug-2019 10:33:15.435 INFO [localhost-startStop-1] org.springframework.web.context.support.XmlWebApplicationContext.prepareRefresh Refreshing Root WebApplicationContext: startup date [Wed Aug 14 10:33:15 EDT 2019]; root of context hierarchy
14-Aug-2019 10:33:15.484 INFO [localhost-startStop-1] org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions Loading XML bean definitions from class path resource [core-data-annotation-context.xml]
14-Aug-2019 10:33:15.901 INFO [localhost-startStop-1] org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions Loading XML bean definitions from class path resource [core-data-datasource-context.xml]
14-Aug-2019 10:33:15.958 INFO [localhost-startStop-1] org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions Loading XML bean definitions from class path resource [core-profile-datasource-context.xml]
14-Aug-2019 10:33:18.455 INFO [localhost-startStop-1] org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping.register Mapped "{[/infoRequest],methods=[GET]}" onto public org.springframework.http.ResponseEntity<java.lang.String> org.openinfobutton.service.web.KnowledgeRequestServlet.infoRequest(java.util.Map<java.lang.String, java.lang.String[]>,javax.servlet.http.HttpServletRequest)
14-Aug-2019 10:33:18.475 INFO [localhost-startStop-1] org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping.register Mapped "{[/liteManager/customProfiles],methods=[GET],produces=[application/json]}" onto public java.util.List<org.openinfobutton.liteprofiledb.domain.CustomProfiles> org.openinfobutton.service.web.ProfileManagerService.getCustomProfiles()
14-Aug-2019 10:33:18.480 INFO [localhost-startStop-1] org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping.register Mapped "{[/liteManager/cloudProfiles],methods=[GET],produces=[application/json]}" onto public java.util.List<org.openinfobutton.liteprofiledb.domain.CloudProfiles> org.openinfobutton.service.web.ProfileManagerService.getCloudProfiles()
14-Aug-2019 10:33:18.480 INFO [localhost-startStop-1] org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping.register Mapped "{[/liteManager/getProfile/{id}],methods=[GET],produces=[application/json]}" onto public org.openinfobutton.liteprofiledb.domain.CustomProfiles org.openinfobutton.service.web.ProfileManagerService.getCustomProfile(java.lang.Long)
14-Aug-2019 10:33:18.481 INFO [localhost-startStop-1] org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping.register Mapped "{[/liteManager/getUser],methods=[POST],produces=[application/json]}" onto public org.openinfobutton.liteprofiledb.domain.UserAuthentication org.openinfobutton.service.web.ProfileManagerService.getUser(org.openinfobutton.liteprofiledb.domain.UserAuthentication)
14-Aug-2019 10:33:18.482 INFO [localhost-startStop-1] org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping.register Mapped "{[/liteManager/deleteUser],methods=[POST],produces=[application/json]}" onto public void org.openinfobutton.service.web.ProfileManagerService.deleteUser(org.openinfobutton.liteprofiledb.domain.UserAuthentication)
14-Aug-2019 10:33:18.483 INFO [localhost-startStop-1] org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping.register Mapped "{[/liteManager/createProfile],methods=[POST]}" onto public java.lang.String org.openinfobutton.service.web.ProfileManagerService.createProfile(org.openinfobutton.liteprofiledb.domain.CustomProfiles)
14-Aug-2019 10:33:18.483 INFO [localhost-startStop-1] org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping.register Mapped "{[/liteManager/updateCustomProfile/{id}],methods=[POST],produces=[application/xml]}" onto public java.lang.String org.openinfobutton.service.web.ProfileManagerService.updateCustomProfile(java.lang.Long,java.lang.String) throws java.io.IOException,javax.xml.bind.JAXBException
14-Aug-2019 10:33:18.484 INFO [localhost-startStop-1] org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping.register Mapped "{[/liteManager/createCloudProfile],methods=[POST]}" onto public void org.openinfobutton.service.web.ProfileManagerService.createCloudProfile(org.openinfobutton.liteprofiledb.domain.CloudProfiles)
14-Aug-2019 10:33:18.485 INFO [localhost-startStop-1] org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping.register Mapped "{[/liteManager/jsonProfile/{id}],methods=[GET],produces=[application/json]}" onto public java.lang.String org.openinfobutton.service.web.ProfileManagerService.getJsonProfile(java.lang.Long) throws com.fasterxml.jackson.core.JsonProcessingException
14-Aug-2019 10:33:18.485 INFO [localhost-startStop-1] org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping.register Mapped "{[/liteManager/jsonProfileSchema],methods=[GET],produces=[application/json]}" onto public java.lang.String org.openinfobutton.service.web.ProfileManagerService.getJsonProfileSchema()
14-Aug-2019 10:33:18.485 INFO [localhost-startStop-1] org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping.register Mapped "{[/liteManager/updateUser],methods=[POST]}" onto public void org.openinfobutton.service.web.ProfileManagerService.updateUser(org.openinfobutton.liteprofiledb.domain.UserAuthentication)
14-Aug-2019 10:33:18.486 INFO [localhost-startStop-1] org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping.register Mapped "{[/liteManager/updateAdminUser],methods=[POST],produces=[application/json]}" onto public void org.openinfobutton.service.web.ProfileManagerService.updateAdminUser(org.openinfobutton.liteprofiledb.domain.UserAuthentication)
14-Aug-2019 10:33:18.487 INFO [localhost-startStop-1] org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping.register Mapped "{[/liteManager/searchUts/{codeSystem}/{search}],methods=[GET],produces=[application/json]}" onto public java.lang.String org.openinfobutton.service.web.ProfileManagerService.searchUts(java.lang.String,java.lang.String)
14-Aug-2019 10:33:18.487 INFO [localhost-startStop-1] org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping.register Mapped "{[/liteManager/getUsers],methods=[GET],produces=[application/json]}" onto public java.util.List<org.openinfobutton.liteprofiledb.domain.UserAuthentication> org.openinfobutton.service.web.ProfileManagerService.getUsers()
14-Aug-2019 10:33:18.495 INFO [localhost-startStop-1] org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping.register Mapped "{[/propertiesManager/updateProperty/{propertyName}],methods=[POST]}" onto public void org.openinfobutton.service.web.PropertiesManagerService.updateProperty(java.lang.String,java.lang.String)
14-Aug-2019 10:33:18.495 INFO [localhost-startStop-1] org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping.register Mapped "{[/propertiesManager/deleteProperty/{id}],methods=[GET]}" onto public void org.openinfobutton.service.web.PropertiesManagerService.deleteProperty(int)
14-Aug-2019 10:33:18.496 INFO [localhost-startStop-1] org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping.register Mapped "{[/propertiesManager/addProperty/{propertyName}/{propertyValue}/{propertyDescription}],methods=[GET]}" onto public void org.openinfobutton.service.web.PropertiesManagerService.addProperty(java.lang.String,java.lang.String,java.lang.String)
14-Aug-2019 10:33:18.496 INFO [localhost-startStop-1] org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping.register Mapped "{[/propertiesManager/getProperty/{propertyName}],methods=[GET],produces=[application/json]}" onto public org.openinfobutton.oibpropertydb.domain.OibAppProperty org.openinfobutton.service.web.PropertiesManagerService.getProperty(java.lang.String)
14-Aug-2019 10:33:18.497 INFO [localhost-startStop-1] org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping.register Mapped "{[/propertiesManager/getProperties/{propertyName}],methods=[GET],produces=[application/json]}" onto public java.util.List<org.openinfobutton.oibpropertydb.domain.OibAppProperty> org.openinfobutton.service.web.PropertiesManagerService.getProperties(java.lang.String)
14-Aug-2019 10:33:18.560 INFO [localhost-startStop-1] org.hibernate.validator.internal.util.Version. HV000001: Hibernate Validator 5.4.1.Final
14-Aug-2019 10:33:19.419 INFO [localhost-startStop-1] org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.initControllerAdviceCache Looking for @ControllerAdvice: Root WebApplicationContext: startup date [Wed Aug 14 10:33:15 EDT 2019]; root of context hierarchy
14-Aug-2019 10:33:19.575 INFO [localhost-startStop-1] org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.initControllerAdviceCache Looking for @ControllerAdvice: Root WebApplicationContext: startup date [Wed Aug 14 10:33:15 EDT 2019]; root of context hierarchy
14-Aug-2019 10:33:19.733 INFO [localhost-startStop-1] org.springframework.web.servlet.handler.SimpleUrlHandlerMapping.registerHandler Mapped URL path [/images/] onto handler 'org.springframework.web.servlet.resource.ResourceHttpRequestHandler#0'
14-Aug-2019 10:33:19.735 INFO [localhost-startStop-1] org.springframework.web.servlet.handler.SimpleUrlHandlerMapping.registerHandler Mapped URL path [/css/
] onto handler 'org.springframework.web.servlet.resource.ResourceHttpRequestHandler#1'
14-Aug-2019 10:33:19.951 INFO [localhost-startStop-1] org.apache.commons.beanutils.FluentPropertyBeanIntrospector.introspect Error when creating PropertyDescriptor for public final void org.apache.commons.configuration2.AbstractConfiguration.setProperty(java.lang.String,java.lang.Object)! Ignoring this property.
14-Aug-2019 10:33:20.496 WARNING [localhost-startStop-1] org.apache.commons.configuration2.DatabaseConfiguration.warn Internal error
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command denied to user 'oib_user'@'localhost' for table 'oib_app_property'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114)
at com.sun.proxy.$Proxy52.executeQuery(Unknown Source)
at org.apache.commons.configuration2.DatabaseConfiguration$JdbcOperation.openResultSet(DatabaseConfiguration.java:847)
at org.apache.commons.configuration2.DatabaseConfiguration$7.performOperation(DatabaseConfiguration.java:569)
at org.apache.commons.configuration2.DatabaseConfiguration$7.performOperation(DatabaseConfiguration.java:565)
at org.apache.commons.configuration2.DatabaseConfiguration$JdbcOperation.execute(DatabaseConfiguration.java:742)
at org.apache.commons.configuration2.DatabaseConfiguration.getKeysInternal(DatabaseConfiguration.java:579)
at org.apache.commons.configuration2.AbstractConfiguration.getKeys(AbstractConfiguration.java:935)
at org.apache.commons.configuration2.CompositeConfiguration.getKeysInternal(CompositeConfiguration.java:322)
at org.apache.commons.configuration2.AbstractConfiguration.getKeys(AbstractConfiguration.java:935)
at org.apache.commons.configuration2.ConfigurationConverter.getProperties(ConfigurationConverter.java:85)
at org.apache.commons.configuration2.spring.ConfigurationPropertiesFactoryBean.getObject(ConfigurationPropertiesFactoryBean.java:78)
at org.openinfobutton.service.configuration.OibPropertiesConfig.initializeDatabasePropertySourceUsage(OibPropertiesConfig.java:62)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:366)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:311)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:134)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:409)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1620)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:761)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:866)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:542)
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:443)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:325)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4699)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5165)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:743)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:719)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:714)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:970)
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1841)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
14-Aug-2019 10:33:20.675 INFO [localhost-startStop-1] org.hibernate.annotations.common.reflection.java.JavaReflectionManager. HCANN000001: Hibernate Commons Annotations {4.0.5.Final}
14-Aug-2019 10:33:20.689 INFO [localhost-startStop-1] org.hibernate.Version.logVersion HHH000412: Hibernate Core {4.3.11.Final}
14-Aug-2019 10:33:20.691 INFO [localhost-startStop-1] org.hibernate.cfg.Environment. HHH000206: hibernate.properties not found
14-Aug-2019 10:33:20.692 INFO [localhost-startStop-1] org.hibernate.cfg.Environment.buildBytecodeProvider HHH000021: Bytecode provider name : javassist
14-Aug-2019 10:33:21.139 INFO [localhost-startStop-1] org.hibernate.dialect.Dialect. HHH000400: Using dialect: org.hibernate.dialect.MySQL5Dialect
14-Aug-2019 10:33:21.318 INFO [localhost-startStop-1] org.hibernate.engine.transaction.internal.TransactionFactoryInitiator.initiateService HHH000399: Using default transaction strategy (direct JDBC transactions)
14-Aug-2019 10:33:21.324 INFO [localhost-startStop-1] org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory. HHH000397: Using ASTQueryTranslatorFactory
14-Aug-2019 10:33:21.906 INFO [localhost-startStop-1] org.hibernate.tool.hbm2ddl.SchemaValidator.validate HHH000229: Running schema validator
14-Aug-2019 10:33:21.906 INFO [localhost-startStop-1] org.hibernate.tool.hbm2ddl.SchemaValidator.validate HHH000102: Fetching database metadata
14-Aug-2019 10:33:21.911 INFO [localhost-startStop-1] org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata HHH000262: Table not found: logs
14-Aug-2019 10:33:21.912 WARNING [localhost-startStop-1] org.springframework.web.context.support.XmlWebApplicationContext.refresh Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'databaseValueSets': Unsatisfied dependency expressed through field 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [core-data-datasource-context.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: Missing table: logs
14-Aug-2019 10:33:21.917 SEVERE [localhost-startStop-1] org.springframework.web.context.ContextLoader.initWebApplicationContext Context initialization failed
org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'databaseValueSets': Unsatisfied dependency expressed through field 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [core-data-datasource-context.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: Missing table: logs
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:588)
at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88)
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:366)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1264)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:553)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:761)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:866)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:542)
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:443)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:325)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4699)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5165)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:743)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:719)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:714)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:970)
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1841)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [core-data-datasource-context.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: Missing table: logs
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1628)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1066)
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:585)
... 28 more
Caused by: org.hibernate.HibernateException: Missing table: logs
at org.hibernate.cfg.Configuration.validateSchema(Configuration.java:1335)
at org.hibernate.tool.hbm2ddl.SchemaValidator.validate(SchemaValidator.java:175)
at org.hibernate.internal.SessionFactoryImpl.(SessionFactoryImpl.java:525)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1859)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1930)
at org.springframework.orm.hibernate4.LocalSessionFactoryBuilder.buildSessionFactory(LocalSessionFactoryBuilder.java:372)
at org.springframework.orm.hibernate4.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:454)
at org.springframework.orm.hibernate4.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:439)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1687)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1624)
... 38 more
14-Aug-2019 10:33:21.918 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal One or more listeners failed to start. Full details will be found in the appropriate container log file
14-Aug-2019 10:33:21.924 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal Context [/infobutton-service] startup failed due to previous errors
14-Aug-2019 10:33:21.931 WARNING [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc The web application [infobutton-service] registered the JDBC driver [com.mysql.jdbc.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
14-Aug-2019 10:33:21.932 WARNING [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [infobutton-service] appears to have started a thread named [Tomcat JDBC Pool Cleaner[1351298397:1565793199971]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
java.lang.Object.wait(Native Method)
java.util.TimerThread.mainLoop(Timer.java:552)
java.util.TimerThread.run(Timer.java:505)
14-Aug-2019 10:33:21.932 WARNING [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [infobutton-service] appears to have started a thread named [Abandoned connection cleanup thread] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
java.lang.Object.wait(Native Method)
java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:144)
com.mysql.jdbc.AbandonedConnectionCleanupThread.run(AbandonedConnectionCleanupThread.java:64)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
java.lang.Thread.run(Thread.java:748)
14-Aug-2019 10:33:21.937 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [/opt/tomcat/apache-tomcat-8.5.43/webapps/infobutton-service.war] has finished in [8,314] ms
14-Aug-2019 10:33:21.938 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/opt/tomcat/apache-tomcat-8.5.43/webapps/docs]
14-Aug-2019 10:33:21.960 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/tomcat/apache-tomcat-8.5.43/webapps/docs] has finished in [22] ms
14-Aug-2019 10:33:21.961 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/opt/tomcat/apache-tomcat-8.5.43/webapps/examples]
14-Aug-2019 10:33:22.102 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/tomcat/apache-tomcat-8.5.43/webapps/examples] has finished in [141] ms
14-Aug-2019 10:33:22.102 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/opt/tomcat/apache-tomcat-8.5.43/webapps/app]
14-Aug-2019 10:33:22.113 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/tomcat/apache-tomcat-8.5.43/webapps/app] has finished in [11] ms
14-Aug-2019 10:33:22.113 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/opt/tomcat/apache-tomcat-8.5.43/webapps/manager]
14-Aug-2019 10:33:22.131 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/tomcat/apache-tomcat-8.5.43/webapps/manager] has finished in [18] ms
14-Aug-2019 10:33:22.131 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/opt/tomcat/apache-tomcat-8.5.43/webapps/node_modules]
14-Aug-2019 10:33:22.140 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/tomcat/apache-tomcat-8.5.43/webapps/node_modules] has finished in [9] ms
14-Aug-2019 10:33:22.141 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/opt/tomcat/apache-tomcat-8.5.43/webapps/host-manager]
14-Aug-2019 10:33:22.154 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/tomcat/apache-tomcat-8.5.43/webapps/host-manager] has finished in [12] ms
14-Aug-2019 10:33:22.154 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/opt/tomcat/apache-tomcat-8.5.43/webapps/ROOT]
14-Aug-2019 10:33:22.164 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/tomcat/apache-tomcat-8.5.43/webapps/ROOT] has finished in [10] ms
14-Aug-2019 10:33:22.168 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
14-Aug-2019 10:33:22.183 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["ajp-nio-8009"]
14-Aug-2019 10:33:22.185 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 8615 ms
14-Aug-2019 10:33:24.971 INFO [Tomcat JDBC Pool Cleaner[1351298397:1565793199971]] org.apache.catalina.loader.WebappClassLoaderBase.checkStateForResourceLoading Illegal access: this web application instance has been stopped already. Could not load [org.apache.tomcat.jdbc.pool.FairBlockingQueue$FairIterator]. The following stack trace is thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access.
java.lang.IllegalStateException: Illegal access: this web application instance has been stopped already. Could not load [org.apache.tomcat.jdbc.pool.FairBlockingQueue$FairIterator]. The following stack trace is thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access.
at org.apache.catalina.loader.WebappClassLoaderBase.checkStateForResourceLoading(WebappClassLoaderBase.java:1380)
at org.apache.catalina.loader.WebappClassLoaderBase.checkStateForClassLoading(WebappClassLoaderBase.java:1368)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1220)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1182)
at org.apache.tomcat.jdbc.pool.FairBlockingQueue.iterator(FairBlockingQueue.java:246)
at org.apache.tomcat.jdbc.pool.ConnectionPool.testAllIdle(ConnectionPool.java:1075)
at org.apache.tomcat.jdbc.pool.ConnectionPool$PoolCleaner.run(ConnectionPool.java:1472)
at java.util.TimerThread.mainLoop(Timer.java:555)
at java.util.TimerThread.run(Timer.java:505)
Exception in thread "Tomcat JDBC Pool Cleaner[1351298397:1565793199971]" java.lang.NoClassDefFoundError: org/apache/tomcat/jdbc/pool/FairBlockingQueue$FairIterator
at org.apache.tomcat.jdbc.pool.FairBlockingQueue.iterator(FairBlockingQueue.java:246)
at org.apache.tomcat.jdbc.pool.ConnectionPool.testAllIdle(ConnectionPool.java:1075)
at org.apache.tomcat.jdbc.pool.ConnectionPool$PoolCleaner.run(ConnectionPool.java:1472)
at java.util.TimerThread.mainLoop(Timer.java:555)
at java.util.TimerThread.run(Timer.java:505)
Caused by: java.lang.ClassNotFoundException: Illegal access: this web application instance has been stopped already. Could not load [org.apache.tomcat.jdbc.pool.FairBlockingQueue$FairIterator]. The following stack trace is thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access.
at org.apache.catalina.loader.WebappClassLoaderBase.checkStateForClassLoading(WebappClassLoaderBase.java:1370)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1220)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1182)
... 5 more
Caused by: java.lang.IllegalStateException: Illegal access: this web application instance has been stopped already. Could not load [org.apache.tomcat.jdbc.pool.FairBlockingQueue$FairIterator]. The following stack trace is thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access.
at org.apache.catalina.loader.WebappClassLoaderBase.checkStateForResourceLoading(WebappClassLoaderBase.java:1380)
at org.apache.catalina.loader.WebappClassLoaderBase.checkStateForClassLoading(WebappClassLoaderBase.java:1368)
... 7 more
14-Aug-2019 10:33:24.986 INFO [Abandoned connection cleanup thread] org.apache.catalina.loader.WebappClassLoaderBase.checkStateForResourceLoading Illegal access: this web application instance has been stopped already. Could not load []. The following stack trace is thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access.
java.lang.IllegalStateException: Illegal access: this web application instance has been stopped already. Could not load []. The following stack trace is thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access.
at org.apache.catalina.loader.WebappClassLoaderBase.checkStateForResourceLoading(WebappClassLoaderBase.java:1380)
at org.apache.catalina.loader.WebappClassLoaderBase.getResource(WebappClassLoaderBase.java:1032)
at com.mysql.jdbc.AbandonedConnectionCleanupThread.checkContextClassLoaders(AbandonedConnectionCleanupThread.java:90)
at com.mysql.jdbc.AbandonedConnectionCleanupThread.run(AbandonedConnectionCleanupThread.java:63)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

@DSSUSER
Copy link
Author

DSSUSER commented Aug 14, 2019

LOCALHOST.xxxxx.LOG:

--> cat localhost.2019-08-14.log
14-Aug-2019 10:33:15.257 INFO [localhost-startStop-1] org.apache.catalina.core.ApplicationContext.log No Spring WebApplicationInitializer types detected on classpath
14-Aug-2019 10:33:15.381 INFO [localhost-startStop-1] org.apache.catalina.core.ApplicationContext.log Initializing Spring root WebApplicationContext
14-Aug-2019 10:33:21.918 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.listenerStart Exception sending context initialized event to listener instance of class [org.springframework.web.context.ContextLoaderListener]
org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'databaseValueSets': Unsatisfied dependency expressed through field 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [core-data-datasource-context.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: Missing table: logs
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:588)
at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88)
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:366)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1264)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:553)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)

@DSSUSER
Copy link
Author

DSSUSER commented Aug 14, 2019

Excerpts from the catalina.log:

org.apache.commons.beanutils.FluentPropertyBeanIntrospector.introspect Error when creating PropertyDescriptor for public final void org.apache.commons.configuration2.AbstractConfiguration.setProperty(java.lang.String,java.lang.Object)! Ignoring this property.
14-Aug-2019 10:33:20.496 WARNING [localhost-startStop-1] org.apache.commons.configuration2.DatabaseConfiguration.warn Internal error
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command denied to user 'oib_user'@'localhost' for table 'oib_app_property'

14-Aug-2019 10:33:21.911 INFO [localhost-startStop-1] org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata HHH000262: Table not found: logs
14-Aug-2019 10:33:21.912 WARNING [localhost-startStop-1] org.springframework.web.context.support.XmlWebApplicationContext.refresh Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'databaseValueSets': Unsatisfied dependency expressed through field 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [core-data-datasource-context.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: Missing table: logs
14-Aug-2019 10:33:21.917 SEVERE [localhost-startStop-1] org.springframework.web.context.ContextLoader.initWebApplicationContext Context initialization failed
org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'databaseValueSets': Unsatisfied dependency expressed through field 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [core-data-datasource-context.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: Missing table: logs
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredField

at java.lang.Thread.run(Thread.java:748)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [core-data-datasource-context.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: Missing table: logs
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(Abstract

AutowireCapableBeanFactory.java:1624)
... 38 more
14-Aug-2019 10:33:21.918 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal One or more listeners failed to start. Full details will be found in the appropriate container log file
14-Aug-2019 10:33:21.924 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal Context [/infobutton-service] startup failed due to previous errors
14-Aug-2019 10:33:21.931 WARNING [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc The web application [infobutton-service] registered the JDBC driver [com.mysql.jdbc.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
14-Aug-2019 10:33:21.932 WARNING [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [infobutton-service] appears to have started a thread named [Tomcat JDBC Pool Cleaner[1351298397:1565793199971]] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
java.lang.Object.wait(Native Method)
java.util.TimerThread.mainLoop(Timer.java:552)
java.util.TimerThread.run(Timer.java:505)
14-Aug-2019 10:33:21.932 WARNING [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [infobutton-service] appears to have started a thread named [Abandoned connection cleanup thread] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
java.lang.Object.wait(Native Method)
java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:144)
com.mysql.jdbc.AbandonedConnectionCleanupThread.run(AbandonedConnectionCleanupThread.java:64)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
java.lang.Thread.run(Thread.java:748)
14-Aug-2019 10:33:21.937 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [/opt/tomcat/apache-tomcat-8.5.43/webapps/infobutton-service.war] has finished in [8,314] ms

14-Aug-2019 10:33:24.971 INFO [Tomcat JDBC Pool Cleaner[1351298397:1565793199971]] org.apache.catalina.loader.WebappClassLoaderBase.checkStateForResourceLoading Illegal access: this web application instance has been stopped already. Could not load [org.apache.tomcat.jdbc.pool.FairBlockingQueue$FairIterator]. The following stack trace is thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access.
java.lang.IllegalStateException: Illegal access: this web application instance has been stopped already. Could not load [org.apache.tomcat.jdbc.pool.FairBlockingQueue$FairIterator]. The following stack trace is thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access.
at org.apache.catalina.loader.WebappClassLoaderBase.checkStateForResourceLoading(WebappClassLoader

Exception in thread "Tomcat JDBC Pool Cleaner[1351298397:1565793199971]" java.lang.NoClassDefFoundError: org/apache/tomcat/jdbc/pool/FairBlockingQueue$FairIterator
at org.apache.tomcat.jdbc.pool.FairBlockingQueue.iterator(FairBlockingQueue.java:246)
at org.apache.tomcat.jdbc.pool.ConnectionPool.testAllIdle(ConnectionPool.java:1075)
at org.apache.tomcat.jdbc.pool.ConnectionPool$PoolCleaner.run(ConnectionPool.java:1472)
at java.util.TimerThread.mainLoop(Timer.java:555)
at java.util.TimerThread.run(Timer.java:505)
Caused by: java.lang.ClassNotFoundException: Illegal access: this web application instance has been stopped already. Could not load [org.apache.tomcat.jdbc.pool.FairBlockingQueue$FairIterator]. The following stack trace is thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access.
at org.apache.catalina.loader.WebappClassLoaderBase.checkStateForClassLoading(WebappClassLoaderBase.java:1370)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1220)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1182)
... 5 more
Caused by: java.lang.IllegalStateException: Illegal access: this web application instance has been stopped already. Could not load [org.apache.tomcat.jdbc.pool.FairBlockingQueue$FairIterator]. The following stack trace is thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access.
at org.apache.catalina.loader.WebappClassLoaderBase.checkStateForResourceLoading(WebappClassLoader

@aniskand
Copy link
Collaborator

aniskand commented Aug 14, 2019 via email

@DSSUSER
Copy link
Author

DSSUSER commented Aug 14, 2019

When I run the "CREATE USER" command for the oib_user, do I need to USE a particular table?

The instructions I have, have me running the CREATE USER command, before "using" a particular table.

Additionally, there is no instruction to INSERT the "oib_user" in the "users" table.

Should there be?

And, if it should be in the "users" table, what would its "ROLE" be?

The long and short of this is: How do I fix this?

@aniskand
Copy link
Collaborator

aniskand commented Oct 30, 2019 via email

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants