Open DSSUSER opened 5 years ago
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
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.
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.
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.
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.
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
Yeah you need to build this module first,
https://github.com/VHAINNOVATIONS/InfoButtons/tree/2.3-SNAPSHOT/rest-terminology-services
That was it!
Maven built cleanly.
Thanks.
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 npm@3.10.10 3 info using node@v6.17.1 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 ]
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.
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.
I generally start it with nohup npm start & , or ctrl + z/bg it after its started.
On Tue, Aug 13, 2019 at 9:42 AM DSSUSER notifications@github.com wrote:
I managed to fix the "npm start" issue.
But, the "npm start" command starts the Angular service, and takes control of my current PuTTY session.
I tried running the "npm start" command with the "&" sign, hoping to put the command in the background, but that did not work. (As far as I can tell)
It does bring me back to the command prompt, but I do not know how to check, to see if the service is actually running or not.
Is there a command I can run from the command line, to see if the Angular service is running or not?
Is there a way that I can start this service in the background, so that it does not take control of my PuTTY session?
— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub https://github.com/VHAINNOVATIONS/InfoButtons/issues/29?email_source=notifications&email_token=ABK7CKX2ETPUT3A4J3XSZEDQELI7DA5CNFSM4ILC6QKKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD4GCOFY#issuecomment-520890135, or mute the thread https://github.com/notifications/unsubscribe-auth/ABK7CKU3PRWKTFH3WBJR5MLQELI7DANCNFSM4ILC6QKA .
-- Andrew Iskander Software Engineer/BRISC 421 Wakara Way Home/Cell: (919) 442-8129 Office Phone: (801) 587-8045
And, what is the best way to stop it?
The man page was not very helpful, and neither was "npm help"
Also, is there any specific order in which the services need to be stopped?
NPM first, or Tomcat first?
You can just kill the process. The other option is, once it's built, you copy the "app" folder into web application container or server you like.There's nothing special about it once it's built, its just html/js/css.
On Tue, Aug 13, 2019 at 10:20 AM DSSUSER notifications@github.com wrote:
And, what is the best way to stop it?
— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub https://github.com/VHAINNOVATIONS/InfoButtons/issues/29?email_source=notifications&email_token=ABK7CKU77XR3JGZMVFYZJJ3QELMOZA5CNFSM4ILC6QKKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD4GFLGA#issuecomment-520902040, or mute the thread https://github.com/notifications/unsubscribe-auth/ABK7CKQLE2BMQNK2SFLH35LQELMOZANCNFSM4ILC6QKA .
-- Andrew Iskander Software Engineer/BRISC 421 Wakara Way Home/Cell: (919) 442-8129 Office Phone: (801) 587-8045
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?
Yes, you need to be in this directory,
https://github.com/VHAINNOVATIONS/InfoButtons/tree/2.3-SNAPSHOT/oib-site-lite-ui
In the same directory as the package.json file.
On Tue, Aug 13, 2019 at 10:44 AM DSSUSER notifications@github.com wrote:
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?
— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub https://github.com/VHAINNOVATIONS/InfoButtons/issues/29?email_source=notifications&email_token=ABK7CKSCYZA4A2NJKNPS22TQELQGPA5CNFSM4ILC6QKKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD4GIFSQ#issuecomment-520913610, or mute the thread https://github.com/notifications/unsubscribe-auth/ABK7CKUAZ35CKC54N4HKWHTQELQGPANCNFSM4ILC6QKA .
-- Andrew Iskander Software Engineer/BRISC 421 Wakara Way Home/Cell: (919) 442-8129 Office Phone: (801) 587-8045
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?
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
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?
Finally, which UserID should I use when logging into the Site Lite GUI?
If you ran this script to create the user database for LITE,
then the username / password are the defaults that were inserted by the script,
INSERT INTO users
(username
, password
, role
) VALUES ('root', 'password', 'ADMIN');
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?
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?
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.
The only reason I can think of is that the Infobutton manager web service did not start up correctly. LITE depends on that service running to work. Can you look at your Tomcat log and verify its started up?
On Wed, Aug 14, 2019, 7:09 AM DSSUSER notifications@github.com wrote:
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.
— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub https://github.com/VHAINNOVATIONS/InfoButtons/issues/29?email_source=notifications&email_token=ABK7CKSS7P55TSDACR5P65DQEP7YDA5CNFSM4ILC6QKKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD4IXRAQ#issuecomment-521238658, or mute the thread https://github.com/notifications/unsubscribe-auth/ABK7CKUU557Y2T27FIBWHJDQEP7YDANCNFSM4ILC6QKA .
--> 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
10.16.90.58 - - [14/Aug/2019:09:52:36 -0400] "POST /infobutton-service/liteManager/getUser HTTP/1.1" 404 1120
I do not see a path to any "liteManager" folder under the infobutton-service folder.
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
It doesn't need to be configured, it's part of the web service you started in Tomcat. What you need to check if the Tomcat server log , catalina.out, to see if it started up correctly. It looks to me that the web service isn't connectable because it didn't startup correctly.
On Wed, Aug 14, 2019, 8:21 AM DSSUSER notifications@github.com wrote:
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
— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub https://github.com/VHAINNOVATIONS/InfoButtons/issues/29?email_source=notifications&email_token=ABK7CKUHZ5HBPVZSAIUG72TQEQGXJA5CNFSM4ILC6QKKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD4I5DLA#issuecomment-521261484, or mute the thread https://github.com/notifications/unsubscribe-auth/ABK7CKVZURTLKKPPUDYUZMTQEQGXJANCNFSM4ILC6QKA .
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
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)
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
Looked like the db user you created, oib_user, doesn't have access to the tables you created.
On Wed, Aug 14, 2019, 8:45 AM DSSUSER notifications@github.com wrote:
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)
— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub https://github.com/VHAINNOVATIONS/InfoButtons/issues/29?email_source=notifications&email_token=ABK7CKTK5ZXUEFWWKLLEHSDQEQKC7A5CNFSM4ILC6QKKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD4I77RQ#issuecomment-521273286, or mute the thread https://github.com/notifications/unsubscribe-auth/ABK7CKVAPTPJSELEQSC7SUTQEQKC7ANCNFSM4ILC6QKA .
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?
Hi,
It looks like there's a missing database column which means you're running the unit tests against the wrong database version. Make sure you run the SQL scripts for the version you're building.
Alternatively, I have a docker build you can try now.
https://hub.docker.com/r/aniskand2/infobutton
It starts up a clean instance of the OpenInfobutton Manager, Responder and LITE.
On Wed, Oct 30, 2019 at 7:09 AM felipearaujodev notifications@github.com wrote:
can anyone help?
[INFO] --- maven-surefire-plugin:2.12.4:test (default-test) @ oib-request-db --- [INFO] Surefire report directory: E:\InfoButtons\oib-request\oib-request-db\target\surefire-reports
T E S T S
Running org.openinfobutton.db.test.ProfileDbTest out 30, 2019 9:50:26 AM org.springframework.test.context.support.DefaultTestContextBootstrapper getDefaultTestExecutionListenerClassNames INFORMA╟╒ES: Loaded default TestExecutionListener class names from location [META-INF/spring.factories]: [org.springframework.test.context.web.ServletTestExecutionListener, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener, org.springframework.test.context.support.DependencyInjectionTestExecutionListener, org.springframework.test.context.support.DirtiesContextTestExecutionListener, org.springframework.test.context.transaction.TransactionalTestExecutionListener, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener] out 30, 2019 9:50:26 AM org.springframework.test.context.support.DefaultTestContextBootstrapper instantiateListeners INFORMA╟╒ES: Could not instantiate TestExecutionListener [org.springframework.test.context.web.ServletTestExecutionListener]. Specify custom listener classes or make the default listener classes (and their required dependencies) available. Offending class: [javax/servlet/ServletContext] out 30, 2019 9:50:26 AM org.springframework.test.context.support.DefaultTestContextBootstrapper getTestExecutionListeners INFORMA╟╒ES: Using TestExecutionListeners: [org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener@776aec5c, org.springframework.test.context.support.DependencyInjectionTestExecutionListener@1d296da, org.springframework.test.context.support.DirtiesContextTestExecutionListener@7c7a06ec, org.springframework.test.context.transaction.TransactionalTestExecutionListener@75d4a5c2, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener@557caf28 ] out 30, 2019 9:50:27 AM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions INFORMA╟╒ES: Loading XML bean definitions from class path resource [core-data-annotation-context.xml] out 30, 2019 9:50:27 AM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions INFORMA╟╒ES: Loading XML bean definitions from class path resource [core-profile-datasource-context.xml] out 30, 2019 9:50:27 AM org.springframework.context.support.GenericApplicationContext prepareRefresh INFORMA╟╒ES: Refreshing org.springframework.context.support.GenericApplicationContext@4e50c791: startup date [Wed Oct 30 09:50:27 BRT 2019]; root of context hierarchy out 30, 2019 9:50:29 AM org.hibernate.annotations.common.reflection.java.JavaReflectionManager INFO: HCANN000001: Hibernate Commons Annotations {4.0.5.Final} out 30, 2019 9:50:29 AM org.hibernate.Version logVersion INFO: HHH000412: Hibernate Core {4.3.11.Final} out 30, 2019 9:50:29 AM org.hibernate.cfg.Environment INFO: HHH000206: hibernate.properties not found out 30, 2019 9:50:29 AM org.hibernate.cfg.Environment buildBytecodeProvider INFO: HHH000021: Bytecode provider name : javassist out 30, 2019 9:50:30 AM org.hibernate.dialect.Dialect INFO: HHH000400: Using dialect: org.hibernate.dialect.MySQL5Dialect out 30, 2019 9:50:31 AM org.hibernate.engine.transaction.internal.TransactionFactoryInitiator initiateService INFO: HHH000399: Using default transaction strategy (direct JDBC transactions) out 30, 2019 9:50:31 AM org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory INFO: HHH000397: Using ASTQueryTranslatorFactory out 30, 2019 9:50:31 AM org.hibernate.validator.internal.util.Version INFO: HV000001: Hibernate Validator 5.4.1.Final out 30, 2019 9:50:33 AM org.hibernate.tool.hbm2ddl.SchemaValidator validate INFO: HHH000229: Running schema validator out 30, 2019 9:50:33 AM org.hibernate.tool.hbm2ddl.SchemaValidator validate INFO: HHH000102: Fetching database metadata out 30, 2019 9:50:33 AM org.hibernate.tool.hbm2ddl.TableMetadata INFO: HHH000261: Table found: profilesdbprod.custom_profiles out 30, 2019 9:50:33 AM org.hibernate.tool.hbm2ddl.TableMetadata INFO: HHH000037: Columns: [image_url, name, id, published, version, content, status] out 30, 2019 9:50:33 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata INFO: HHH000262: Table not found: installed_store_profiles out 30, 2019 9:50:33 AM org.springframework.context.support.GenericApplicationContext refresh ADVERT╩NCIA: Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'profilesdbDao': Unsatisfied dependency expressed through field 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'profilesessionFactory' defined in class path resource [core-profile-datasource-context.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: Missing table: installed_store_profiles out 30, 2019 9:50:33 AM org.springframework.test.context.TestContextManager prepareTestInstance GRAVE: Caught exception while allowing TestExecutionListener [org.springframework.test.context.support.DependencyInjectionTestExecutionListener@1d296da] to prepare test instance [org.openinfobutton.db.test.ProfileDbTest@63f2d024 ] java.lang.IllegalStateException: Failed to load ApplicationContext at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:124) at org.springframework.test.context.support.DefaultTestContext.getApplicationContext(DefaultTestContext.java:83) at org.springframework.test.context.support.DependencyInjectionTestExecutionListener.injectDependencies(DependencyInjectionTestExecutionListener.java:117) at org.springframework.test.context.support.DependencyInjectionTestExecutionListener.prepareTestInstance(DependencyInjectionTestExecutionListener.java:83) at org.springframework.test.context.TestContextManager.prepareTestInstance(TestContextManager.java:230) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.createTest(SpringJUnit4ClassRunner.java:228) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner$1.runReflectiveCall(SpringJUnit4ClassRunner.java:287) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.methodBlock(SpringJUnit4ClassRunner.java:289) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:247) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:94) at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288) at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268) at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61) at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70) at org.junit.runners.ParentRunner.run(ParentRunner.java:363) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:191) at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:252) at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:141) at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:112) 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.maven.surefire.util.ReflectionUtils.invokeMethodWithArray(ReflectionUtils.java:189) at org.apache.maven.surefire.booter.ProviderFactory$ProviderProxy.invoke(ProviderFactory.java:165) at org.apache.maven.surefire.booter.ProviderFactory.invokeProvider(ProviderFactory.java:85) at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:115) at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:75) Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'profilesdbDao': Unsatisfied dependency expressed through field 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'profilesessionFactory' defined in class path resource [core-profile-datasource-context.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: Missing table: installed_store_profiles 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.test.context.support.AbstractGenericContextLoader.loadContext(AbstractGenericContextLoader.java:128) at org.springframework.test.context.support.AbstractGenericContextLoader.loadContext(AbstractGenericContextLoader.java:60) at org.springframework.test.context.support.AbstractDelegatingSmartContextLoader.delegateLoading(AbstractDelegatingSmartContextLoader.java:108) at org.springframework.test.context.support.AbstractDelegatingSmartContextLoader.loadContext(AbstractDelegatingSmartContextLoader.java:251) at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContextInternal(DefaultCacheAwareContextLoaderDelegate.java:98) at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:116) ... 31 more Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'profilesessionFactory' defined in class path resource [core-profile-datasource-context.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: Missing table: installed_store_profiles 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) ... 49 more Caused by: org.hibernate.HibernateException: Missing table: installed_store_profiles 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) ... 59 more
Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 8.812 sec <<< FAILURE! testProfileRead(org.openinfobutton.db.test.ProfileDbTest) Time elapsed: 0.003 sec <<< ERROR! java.lang.IllegalStateException: Failed to load ApplicationContext at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:124) at org.springframework.test.context.support.DefaultTestContext.getApplicationContext(DefaultTestContext.java:83) at org.springframework.test.context.support.DependencyInjectionTestExecutionListener.injectDependencies(DependencyInjectionTestExecutionListener.java:117) at org.springframework.test.context.support.DependencyInjectionTestExecutionListener.prepareTestInstance(DependencyInjectionTestExecutionListener.java:83) at org.springframework.test.context.TestContextManager.prepareTestInstance(TestContextManager.java:230) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.createTest(SpringJUnit4ClassRunner.java:228) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner$1.runReflectiveCall(SpringJUnit4ClassRunner.java:287) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.methodBlock(SpringJUnit4ClassRunner.java:289) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:247) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:94) at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288) at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268) at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61) at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70) at org.junit.runners.ParentRunner.run(ParentRunner.java:363) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:191) at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:252) at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:141) at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:112) 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.maven.surefire.util.ReflectionUtils.invokeMethodWithArray(ReflectionUtils.java:189) at org.apache.maven.surefire.booter.ProviderFactory$ProviderProxy.invoke(ProviderFactory.java:165) at org.apache.maven.surefire.booter.ProviderFactory.invokeProvider(ProviderFactory.java:85) at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:115) at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:75) Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'profilesdbDao': Unsatisfied dependency expressed through field 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'profilesessionFactory' defined in class path resource [core-profile-datasource-context.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: Missing table: installed_store_profiles 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.test.context.support.AbstractGenericContextLoader.loadContext(AbstractGenericContextLoader.java:128) at org.springframework.test.context.support.AbstractGenericContextLoader.loadContext(AbstractGenericContextLoader.java:60) at org.springframework.test.context.support.AbstractDelegatingSmartContextLoader.delegateLoading(AbstractDelegatingSmartContextLoader.java:108) at org.springframework.test.context.support.AbstractDelegatingSmartContextLoader.loadContext(AbstractDelegatingSmartContextLoader.java:251) at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContextInternal(DefaultCacheAwareContextLoaderDelegate.java:98) at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:116) ... 31 more Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'profilesessionFactory' defined in class path resource [core-profile-datasource-context.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: Missing table: installed_store_profiles 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) ... 49 more Caused by: org.hibernate.HibernateException: Missing table: installed_store_profiles 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) ... 59 more
Running org.openinfobutton.db.test.ValueSetAndLogsDbTest out 30, 2019 9:50:33 AM org.springframework.test.context.support.DefaultTestContextBootstrapper getDefaultTestExecutionListenerClassNames INFORMA╟╒ES: Loaded default TestExecutionListener class names from location [META-INF/spring.factories]: [org.springframework.test.context.web.ServletTestExecutionListener, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener, org.springframework.test.context.support.DependencyInjectionTestExecutionListener, org.springframework.test.context.support.DirtiesContextTestExecutionListener, org.springframework.test.context.transaction.TransactionalTestExecutionListener, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener] out 30, 2019 9:50:33 AM org.springframework.test.context.support.DefaultTestContextBootstrapper instantiateListeners INFORMA╟╒ES: Could not instantiate TestExecutionListener [org.springframework.test.context.web.ServletTestExecutionListener]. Specify custom listener classes or make the default listener classes (and their required dependencies) available. Offending class: [javax/servlet/ServletContext] out 30, 2019 9:50:33 AM org.springframework.test.context.support.DefaultTestContextBootstrapper getTestExecutionListeners INFORMA╟╒ES: Using TestExecutionListeners: [org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener@1136122a, org.springframework.test.context.support.DependencyInjectionTestExecutionListener@5a537a16, org.springframework.test.context.support.DirtiesContextTestExecutionListener@72288480, org.springframework.test.context.transaction.TransactionalTestExecutionListener@4ea43d4d, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener@6f22c1f1 ] out 30, 2019 9:50:33 AM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions INFORMA╟╒ES: Loading XML bean definitions from class path resource [core-valuelogs-annotation-context.xml] out 30, 2019 9:50:33 AM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions INFORMA╟╒ES: Loading XML bean definitions from class path resource [core-data-datasource-context.xml] out 30, 2019 9:50:33 AM org.springframework.context.support.GenericApplicationContext prepareRefresh INFORMA╟╒ES: Refreshing org.springframework.context.support.GenericApplicationContext@2ee095c9: startup date [Wed Oct 30 09:50:33 BRT 2019]; root of context hierarchy out 30, 2019 9:50:34 AM org.hibernate.dialect.Dialect INFO: HHH000400: Using dialect: org.hibernate.dialect.MySQL5Dialect out 30, 2019 9:50:34 AM org.hibernate.engine.transaction.internal.TransactionFactoryInitiator initiateService INFO: HHH000399: Using default transaction strategy (direct JDBC transactions) out 30, 2019 9:50:34 AM org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory INFO: HHH000397: Using ASTQueryTranslatorFactory out 30, 2019 9:50:34 AM org.hibernate.tool.hbm2ddl.SchemaValidator validate INFO: HHH000229: Running schema validator out 30, 2019 9:50:34 AM org.hibernate.tool.hbm2ddl.SchemaValidator validate INFO: HHH000102: Fetching database metadata out 30, 2019 9:50:34 AM org.hibernate.tool.hbm2ddl.TableMetadata INFO: HHH000261: Table found: prodoib.logs out 30, 2019 9:50:34 AM org.hibernate.tool.hbm2ddl.TableMetadata INFO: HHH000037: Columns: [request, logsid, clientip, orgid, timestamp] out 30, 2019 9:50:34 AM org.springframework.context.support.GenericApplicationContext refresh ADVERT╩NCIA: Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'logsDbDao': 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 column: response in prodoib.logs out 30, 2019 9:50:34 AM org.springframework.test.context.TestContextManager prepareTestInstance GRAVE: Caught exception while allowing TestExecutionListener [org.springframework.test.context.support.DependencyInjectionTestExecutionListener@5a537a16] to prepare test instance [org.openinfobutton.db.test.ValueSetAndLogsDbTest@2a20da9f] java.lang.IllegalStateException: Failed to load ApplicationContext at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:124) at org.springframework.test.context.support.DefaultTestContext.getApplicationContext(DefaultTestContext.java:83) at org.springframework.test.context.support.DependencyInjectionTestExecutionListener.injectDependencies(DependencyInjectionTestExecutionListener.java:117) at org.springframework.test.context.support.DependencyInjectionTestExecutionListener.prepareTestInstance(DependencyInjectionTestExecutionListener.java:83) at org.springframework.test.context.TestContextManager.prepareTestInstance(TestContextManager.java:230) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.createTest(SpringJUnit4ClassRunner.java:228) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner$1.runReflectiveCall(SpringJUnit4ClassRunner.java:287) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.methodBlock(SpringJUnit4ClassRunner.java:289) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:247) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:94) at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288) at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268) at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61) at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70) at org.junit.runners.ParentRunner.run(ParentRunner.java:363) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:191) at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:252) at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:141) at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:112) 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.maven.surefire.util.ReflectionUtils.invokeMethodWithArray(ReflectionUtils.java:189) at org.apache.maven.surefire.booter.ProviderFactory$ProviderProxy.invoke(ProviderFactory.java:165) at org.apache.maven.surefire.booter.ProviderFactory.invokeProvider(ProviderFactory.java:85) at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:115) at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:75) Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'logsDbDao': 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 column: response in prodoib.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.test.context.support.AbstractGenericContextLoader.loadContext(AbstractGenericContextLoader.java:128) at org.springframework.test.context.support.AbstractGenericContextLoader.loadContext(AbstractGenericContextLoader.java:60) at org.springframework.test.context.support.AbstractDelegatingSmartContextLoader.delegateLoading(AbstractDelegatingSmartContextLoader.java:108) at org.springframework.test.context.support.AbstractDelegatingSmartContextLoader.loadContext(AbstractDelegatingSmartContextLoader.java:251) at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContextInternal(DefaultCacheAwareContextLoaderDelegate.java:98) at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:116) ... 31 more 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 column: response in prodoib.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) ... 49 more Caused by: org.hibernate.HibernateException: Missing column: response in prodoib.logs at org.hibernate.mapping.Table.validateColumns(Table.java:366) at org.hibernate.cfg.Configuration.validateSchema(Configuration.java:1338) 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) ... 59 more
Tests run: 2, Failures: 0, Errors: 1, Skipped: 1, Time elapsed: 0.119 sec <<< FAILURE! testLogEntry(org.openinfobutton.db.test.ValueSetAndLogsDbTest) Time elapsed: 0 sec <<< ERROR! java.lang.IllegalStateException: Failed to load ApplicationContext at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:124) at org.springframework.test.context.support.DefaultTestContext.getApplicationContext(DefaultTestContext.java:83) at org.springframework.test.context.support.DependencyInjectionTestExecutionListener.injectDependencies(DependencyInjectionTestExecutionListener.java:117) at org.springframework.test.context.support.DependencyInjectionTestExecutionListener.prepareTestInstance(DependencyInjectionTestExecutionListener.java:83) at org.springframework.test.context.TestContextManager.prepareTestInstance(TestContextManager.java:230) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.createTest(SpringJUnit4ClassRunner.java:228) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner$1.runReflectiveCall(SpringJUnit4ClassRunner.java:287) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.methodBlock(SpringJUnit4ClassRunner.java:289) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:247) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:94) at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288) at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268) at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61) at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70) at org.junit.runners.ParentRunner.run(ParentRunner.java:363) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:191) at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:252) at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:141) at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:112) 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.maven.surefire.util.ReflectionUtils.invokeMethodWithArray(ReflectionUtils.java:189) at org.apache.maven.surefire.booter.ProviderFactory$ProviderProxy.invoke(ProviderFactory.java:165) at org.apache.maven.surefire.booter.ProviderFactory.invokeProvider(ProviderFactory.java:85) at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:115) at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:75) Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'logsDbDao': 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 column: response in prodoib.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.test.context.support.AbstractGenericContextLoader.loadContext(AbstractGenericContextLoader.java:128) at org.springframework.test.context.support.AbstractGenericContextLoader.loadContext(AbstractGenericContextLoader.java:60) at org.springframework.test.context.support.AbstractDelegatingSmartContextLoader.delegateLoading(AbstractDelegatingSmartContextLoader.java:108) at org.springframework.test.context.support.AbstractDelegatingSmartContextLoader.loadContext(AbstractDelegatingSmartContextLoader.java:251) at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContextInternal(DefaultCacheAwareContextLoaderDelegate.java:98) at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:116) ... 31 more 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 column: response in prodoib.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) ... 49 more Caused by: org.hibernate.HibernateException: Missing column: response in prodoib.logs at org.hibernate.mapping.Table.validateColumns(Table.java:366) at org.hibernate.cfg.Configuration.validateSchema(Configuration.java:1338) 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) ... 59 more
Results :
Tests in error: testProfileRead(org.openinfobutton.db.test.ProfileDbTest): Failed to load ApplicationContext testLogEntry(org.openinfobutton.db.test.ValueSetAndLogsDbTest): Failed to load ApplicationContext
Tests run: 3, Failures: 0, Errors: 2, Skipped: 1
[INFO]
[INFO] Reactor Summary for oib-request 2.3-SNAPSHOT: [INFO] [INFO] oib-request ........................................ SUCCESS [ 1.014 s] [INFO] oib-profile-schema ................................. SUCCESS [ 13.336 s] [INFO] oib-service-test ................................... SUCCESS [ 2.472 s] [INFO] oib-request-schema ................................. SUCCESS [ 9.254 s] [INFO] OIB Core Utility Module ............................ SUCCESS [ 1.294 s] [INFO] oib-valueset-matcher ............................... SUCCESS [ 12.616 s] [INFO] oib-request-db ..................................... FAILURE [ 13.774 s] [INFO] oib-request-inference-rxnorm ....................... SKIPPED [INFO] oib-ext-resources .................................. SKIPPED [INFO] oib-request-service ................................ SKIPPED [INFO]
[INFO]
[INFO] Total time: 55.793 s [INFO] Finished at: 2019-10-30T09:50:35-03:00 [INFO]
[ERROR] Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.12.4:test (default-test) on project oib-request-db: There are test failures. [ERROR] [ERROR] Please refer to E:\InfoButtons\oib-request\oib-request-db\target\surefire-reports for the individual test results. [ERROR] -> [Help 1] [ERROR] [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch. [ERROR] Re-run Maven using the -X switch to enable full debug logging. [ERROR] [ERROR] For more information about the errors and possible solutions, please read the following articles: [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoFailureException [ERROR] [ERROR] After correcting the problems, you can resume the build with the command [ERROR] mvn -rf :oib-request-db
— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub https://github.com/VHAINNOVATIONS/InfoButtons/issues/29?email_source=notifications&email_token=ABK7CKTCN77Z6LJ2UFCCWUDQRGBQXA5CNFSM4ILC6QKKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOECUDG4Q#issuecomment-547894130, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABK7CKWNZ3ACCIPC4ABWTGDQRGBQXANCNFSM4ILC6QKA .
-- Andrew Iskander Software Engineer/BRISC 421 Wakara Way Home/Cell: (919) 442-8129 Office Phone: (801) 587-8045
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?