search

SafeExamBrowser / seb-server-setup

Cotains resources and packages to setup and install SEB-Server. Currently only docker-based setup is supported
Mozilla Public License 2.0
8 stars 13 forks source link

SQL error in production environment #5

Closed gianlucacometa closed 3 years ago

gianlucacometa commented 3 years ago

Following the guide https://seb-server-setup.readthedocs.io/en/latest/install-production.html the installation of the demo succeeds perfectly, installing the basic version of production or tls with all the necessary configurations, installs and configures the mysql docker container with the DB completely empty, without schema or structure. The error is the following:

. ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _ | \ \ \ \ \/ _)| |)| | | | | || (| | ) ) ) ) ' |__| .|| ||| |\, | / / / / =========|_|==============|__/=//// :: Spring Boot :: (v2.1.0.RELEASE)

15:22:03.492 INFO [main]:[ch.ethz.seb.sebserver.SEBServer] Starting SEBServer v1.1.1-SNAPSHOT on e19da0201a1e with PID 1 (/sebserver/seb-server-1.1-latest.jar started by root in /sebserver) 15:22:03.494 INFO [main]:[ch.ethz.seb.sebserver.SEBServer] The following profiles are active: ws,gui,prod,prod-gui,prod-ws 15:22:08.584 INFO [main]:[ch.ethz.seb.sebserver.gui.RAPSpringConfig] +++ Register external messages resources from: file:/sebserver/config/spring/messages cacheManager:Eh107CacheManager[classpath:config/ehcache.xml] 15:22:12.731 WARN [main]:[ch.ethz.seb.sebserver.webservice.WebserviceInfo] NOTE: External server name, property : 'sebserver.webservice.http.external.servername' is not set from configuration. The external server name is set to the server address! 15:22:15.085 INFO [main]:[ch.ethz.seb.sebserver.webservice.servicelayer.dao.impl.ConfigurationDAOBatchService] Registered MyBatis Mappers: [interface ch.ethz.seb.sebserver.webservice.datalayer.batis.mapper.UserRecordMapper, interface ch.ethz.seb.sebserver.webservice.datalayer.batis.mapper.IndicatorRecordMapper, interface ch.ethz.seb.sebserver.webservice.datalayer.batis.mapper.InstitutionRecordMapper, interface ch.ethz.seb.sebserver.webservice.datalayer.batis.mapper.ClientInstructionRecordMapper, interface ch.ethz.seb.sebserver.webservice.datalayer.batis.mapper.RoleRecordMapper, interface ch.ethz.seb.sebserver.webservice.datalayer.batis.mapper.AdditionalAttributeRecordMapper, interface ch.ethz.seb.sebserver.webservice.datalayer.batis.mapper.ConfigurationRecordMapper, interface ch.ethz.seb.sebserver.webservice.datalayer.batis.ClientEventExtensionMapper, interface ch.ethz.seb.sebserver.webservice.datalayer.batis.mapper.ClientConnectionRecordMapper, interface ch.ethz.seb.sebserver.webservice.datalayer.batis.mapper.SebClientConfigRecordMapper, interface ch.ethz.seb.sebserver.webservice.datalayer.batis.mapper.ClientEventRecordMapper, interface ch.ethz.seb.sebserver.webservice.datalayer.batis.mapper.ExamRecordMapper, interface ch.ethz.seb.sebserver.webservice.datalayer.batis.mapper.ThresholdRecordMapper, interface ch.ethz.seb.sebserver.webservice.datalayer.batis.mapper.RemoteProctoringRoomRecordMapper, interface ch.ethz.seb.sebserver.webservice.datalayer.batis.mapper.LmsSetupRecordMapper, interface ch.ethz.seb.sebserver.webservice.datalayer.batis.mapper.ConfigurationValueRecordMapper, interface ch.ethz.seb.sebserver.webservice.datalayer.batis.mapper.ConfigurationAttributeRecordMapper, interface ch.ethz.seb.sebserver.webservice.datalayer.batis.mapper.OrientationRecordMapper] 15:22:15.972 WARN [main]:[org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext] Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'guiServiceInfo' defined in URL [jar:file:/sebserver/seb-server-1.1-latest.jar!/BOOT-INF/classes!/ch/ethz/seb/sebserver/gui/GuiServiceInfo.class]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [ch.ethz.seb.sebserver.gui.GuiServiceInfo]: Constructor threw exception; nested exception is java.lang.RuntimeException: Missing mandatory inital parameter sebserver.gui.http.external.servername 15:22:15.973 INFO [main]:[ch.ethz.seb.sebserver.webservice.servicelayer.session.impl.AsyncBatchEventSaveStrategy] Reset workersRunning flag to stop worker after event queue is empty 15:22:15.974 INFO [main]:[ch.ethz.seb.SEB_SERVER_INIT] Gracefully Shutdown of SEB Server instance 0.0.0.0 15:22:15.974 INFO [main]:[ch.ethz.seb.SEB_SERVER_INIT] ----> 15:22:15.974 INFO [main]:[ch.ethz.seb.SEB_SERVER_INIT] ----> Unregister Webservice: 89b8d865-dff3-445a-8d14-6c9aa06966b3 WARNING: An illegal reflective access operation has occurred WARNING: Illegal reflective access by org.apache.ibatis.binding.MapperProxy (jar:file:/sebserver/seb-server-1.1-latest.jar!/BOOT-INF/lib/mybatis-3.4.6.jar!/) to constructor java.lang.invoke.MethodHandles$Lookup(java.lang.Class,int) WARNING: Please consider reporting this to the maintainers of org.apache.ibatis.binding.MapperProxy WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations WARNING: All illegal access operations will be denied in a future release 15:22:16.231 INFO [main]:[ch.ethz.seb.SEB_SERVER_INIT] ----> 15:22:16.232 INFO [main]:[ch.ethz.seb.SEB_SERVER_INIT] ----> Webservice down 15:22:16.311 ERROR [main]:[org.springframework.boot.SpringApplication] Application run failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'guiServiceInfo' defined in URL [jar:file:/sebserver/seb-server-1.1-latest.jar!/BOOT-INF/classes!/ch/ethz/seb/sebserver/gui/GuiServiceInfo.class]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [ch.ethz.seb.sebserver.gui.GuiServiceInfo]: Constructor threw exception; nested exception is java.lang.RuntimeException: Missing mandatory inital parameter sebserver.gui.http.external.servername at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:303) at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:284) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1308) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1154) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:538) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:498) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:846) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:863) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:546) at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:140) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:775) at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397) at org.springframework.boot.SpringApplication.run(SpringApplication.java:316) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1260) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1248) at ch.ethz.seb.sebserver.SEBServer.main(SEBServer.java:46) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.base/java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48) at org.springframework.boot.loader.Launcher.launch(Launcher.java:87) at org.springframework.boot.loader.Launcher.launch(Launcher.java:50) at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51) Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [ch.ethz.seb.sebserver.gui.GuiServiceInfo]: Constructor threw exception; nested exception is java.lang.RuntimeException: Missing mandatory inital parameter sebserver.gui.http.external.servername at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:184) at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:117) at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:299) ... 27 common frames omitted Caused by: java.lang.RuntimeException: Missing mandatory inital parameter sebserver.gui.http.external.servername at ch.ethz.seb.sebserver.gui.GuiServiceInfo.(GuiServiceInfo.java:44) at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.base/java.lang.reflect.Constructor.newInstance(Unknown Source) at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:172) ... 29 common frames omitted 15:22:18.621 [main] DEBUG org.apache.ibatis.logging.LogFactory - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter. 15:22:18.630 [main] DEBUG org.apache.ibatis.logging.LogFactory - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.`

Seeing the repository there is some update since the guide, is it possible that there are different steps to take now?

Thank you!

anhefti commented 3 years ago

Hi,

There seems to be at least one missing initial setting: "sebserver.webservice.http.external.servername"

Please make sure the following settings are set correctly within the application-prod.properties file: Note that this settings must point to the external URL of your production server.

sebserver.webservice.http.external.scheme= sebserver.webservice.http.external.servername= sebserver.webservice.http.external.port=

sebserver.gui.http.external.scheme= sebserver.gui.http.external.servername= sebserver.gui.http.external.port=

gianlucacometa commented 3 years ago

Yes! sebserver.webservice.http.external.servername is missing but now its work!

:)