Additional NOTE: please check log file is writable i.e. sometimes OM is being run as root for the first time, then user is changed, but log dir/file is not writable ...
On Mon, 15 Apr 2019 at 12:50, Maxim Solodovnik <[email protected]> wrote: > You MUST have huge stack-trace in the log in this case ..... > > On Mon, 15 Apr 2019 at 12:47, Stefan Kühl <[email protected]> wrote: > >> Hey ;-) >> >> could it be so easy? >> >> Unfortunately not: >> >> >> >> >> Am 15.04.2019 07:15, schrieb Maxim Solodovnik: >> >> "No hint for MySql connection" === no errors, everything works as >> expected :))) >> Old driver will not work (unless you will change class name) >> >> On Mon, 15 Apr 2019 at 12:14, Stefan Kühl <[email protected]> wrote: >> >>> Hey Maxim, >>> >>> as I wrote, I've tried the newest java-connector (and to be sure also >>> the old one ;-)) >>> >>> Here my openmeetingslog from the last try: >>> >>> INFO 04-14 19:19:44.180 o.s.w.c.ContextLoader:270 [main] - Root >>> WebApplicationContext: initialization started >>> INFO 04-14 19:19:46.138 o.s.o.j.LocalEntityManagerFactoryBean:415 >>> [main] - Initialized JPA EntityManagerFactory for persistence unit >>> 'openmeetings' >>> INFO 04-14 19:19:46.809 o.s.s.c.ThreadPoolTaskExecutor:171 [main] - >>> Initializing ExecutorService 'taskExecutor' >>> INFO 04-14 19:19:50.427 o.k.j.c.JsonRpcClientNettyWebSocket:191 >>> [rbeatExec-e1-t0] - [KurentoClient] Connecting native client >>> INFO 04-14 19:19:50.443 o.k.j.c.JsonRpcClientNettyWebSocket:220 >>> [rbeatExec-e1-t0] - [KurentoClient] Creating new NioEventLoopGroup >>> INFO 04-14 19:19:51.126 o.k.j.c.JsonRpcClientNettyWebSocket:234 >>> [ntLoopGroup-2-1] - [KurentoClient] Initiating new Netty channel. Will >>> create new handler too! >>> WARN 04-14 19:19:51.298 o.k.j.c.JsonRpcClientNettyWebSocket:308 >>> [rbeatExec-e1-t0] - [KurentoClient] Trying to close a >>> JsonRpcClientNettyWebSocket with channel == null >>> WARN 04-14 19:19:51.306 o.k.j.c.JsonRpcClient:270 [rbeatExec-e1-t0] - >>> [KurentoClient] Error sending heartbeat to server. Exception: >>> [KurentoClient] Exception connecting to WebSocket server ws:// >>> 127.0.0.1:8888/kurento >>> INFO 04-14 19:19:51.306 o.k.j.c.JsonRpcClientNettyWebSocket:191 [main] >>> - [KurentoClient] Connecting native client >>> WARN 04-14 19:19:51.306 o.k.j.c.JsonRpcClient:287 [rbeatExec-e1-t0] - >>> [KurentoClient] Stopping heartbeat and closing client: failure during >>> heartbeat mechanism >>> INFO 04-14 19:19:51.307 o.k.j.c.JsonRpcClientNettyWebSocket:220 [main] >>> - [KurentoClient] Creating new NioEventLoopGroup >>> INFO 04-14 19:19:51.310 o.k.j.c.JsonRpcClientNettyWebSocket:234 >>> [ntLoopGroup-3-1] - [KurentoClient] Initiating new Netty channel. Will >>> create new handler too! >>> WARN 04-14 19:19:51.313 o.k.j.c.JsonRpcClientNettyWebSocket:308 [main] >>> - [KurentoClient] Trying to close a JsonRpcClientNettyWebSocket with >>> channel == null >>> WARN 04-14 19:19:51.325 o.a.o.c.r.KurentoHandler:124 [main] - Fail to >>> create Kurento client, will re-try in 10000 ms >>> INFO 04-14 19:19:51.834 o.q.i.StdSchedulerFactory:1184 [main] - Using >>> default implementation for ThreadExecutor >>> INFO 04-14 19:19:51.869 o.q.c.SchedulerSignalerImpl:61 [main] - >>> Initialized Scheduler Signaller of type: class >>> org.quartz.core.SchedulerSignalerImpl >>> INFO 04-14 19:19:51.872 o.q.c.QuartzScheduler:249 [main] - Quartz >>> Scheduler v.2.2.0 created. >>> INFO 04-14 19:19:51.874 o.q.s.RAMJobStore:155 [main] - RAMJobStore >>> initialized. >>> INFO 04-14 19:19:51.875 o.q.c.QuartzScheduler:318 [main] - Scheduler >>> meta-data: Quartz Scheduler (v2.2.0) >>> 'org.springframework.scheduling.quartz.SchedulerFactoryBean#0' with >>> instanceId 'NON_CLUSTERED' >>> Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally. >>> NOT STARTED. >>> Currently in standby mode. >>> Number of jobs executed: 0 >>> Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 >>> threads. >>> Using job-store 'org.quartz.simpl.RAMJobStore' - which does not >>> support persistence. and is not clustered. >>> >>> INFO 04-14 19:19:51.876 o.q.i.StdSchedulerFactory:1339 [main] - Quartz >>> scheduler 'org.springframework.scheduling.quartz.SchedulerFactoryBean#0' >>> initialized from an externally provided properties instance. >>> INFO 04-14 19:19:51.876 o.q.i.StdSchedulerFactory:1343 [main] - Quartz >>> scheduler version: 2.2.0 >>> INFO 04-14 19:19:51.878 o.q.c.QuartzScheduler:2346 [main] - JobFactory >>> set to: org.springframework.scheduling.quartz.AdaptableJobFactory@5e83677e >>> INFO 04-14 19:19:51.909 o.s.s.q.SchedulerFactoryBean:726 [main] - >>> Starting Quartz Scheduler now >>> INFO 04-14 19:19:51.913 o.q.c.QuartzScheduler:588 [main] - Scheduler >>> org.springframework.scheduling.quartz.SchedulerFactoryBean#0_$_NON_CLUSTERED >>> started. >>> INFO 04-14 19:19:51.926 o.s.w.c.ContextLoader:306 [main] - Root >>> WebApplicationContext initialized in 7740 ms >>> INFO 04-14 19:19:51.947 o.a.w.u.f.WebXmlFile:235 [main] - web.xml: url >>> mapping found for filter with name OpenmeetingsApplication: [/*] >>> INFO 04-14 19:19:52.081 o.a.w.Application:569 [main] - >>> [OpenmeetingsApplication] init: Wicket jQuery UI initializer >>> INFO 04-14 19:19:52.083 o.a.w.Application:569 [main] - >>> [OpenmeetingsApplication] init: Wicket core library initializer >>> INFO 04-14 19:19:52.087 o.a.w.Application:569 [main] - >>> [OpenmeetingsApplication] init: >>> org.wicketstuff.dashboard.DashboardContextInitializer@75c880f1 >>> INFO 04-14 19:19:52.447 o.a.w.Application:569 [main] - >>> [OpenmeetingsApplication] init: Wicket extensions initializer >>> INFO 04-14 19:19:52.473 o.a.w.Application:569 [main] - >>> [OpenmeetingsApplication] init: Wicket Kendo UI initializer >>> INFO 04-14 19:19:52.475 o.a.w.Application:569 [main] - >>> [OpenmeetingsApplication] init: DevUtils DebugBar Initializer >>> INFO 04-14 19:19:52.477 o.a.w.Application:569 [main] - >>> [OpenmeetingsApplication] init: Wicket jQuery UI initializer (plugins) >>> INFO 04-14 19:19:52.478 o.a.w.Application:569 [main] - >>> [OpenmeetingsApplication] init: Wicket Kendo UI initializer (theme-default) >>> DEBUG 04-14 19:19:52.775 o.a.o.w.a.Application:291 [main] - >>> Application::init >>> DEBUG 04-14 19:19:52.832 o.a.o.w.a.Application:298 [main] - webAppPath : >>> /opt/open500/webapps/openmeetings >>> WARN 04-14 19:19:57.944 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: max.upload.size >>> WARN 04-14 19:19:57.948 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: crypt.class.name >>> WARN 04-14 19:19:57.950 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: application.name >>> WARN 04-14 19:19:57.951 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: default.lang.id >>> WARN 04-14 19:19:57.967 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: application.base.url >>> WARN 04-14 19:19:57.968 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: sip.enable >>> WARN 04-14 19:19:57.969 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: google.analytics.code >>> WARN 04-14 19:19:57.971 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: mp4.audio.rate >>> WARN 04-14 19:19:57.973 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: mp4.audio.bitrate >>> WARN 04-14 19:19:57.974 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: mp4.video.preset >>> WARN 04-14 19:19:57.976 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: default.timezone >>> WARN 04-14 19:19:57.978 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: rest.allow.origin >>> WARN 04-14 19:19:57.980 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: video.arrange.keycode >>> WARN 04-14 19:19:57.982 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: mute.others.keycode >>> DEBUG 04-14 19:19:57.983 o.a.o.u.c.CryptProvider:38 [Bean#0_Worker-8] - >>> getInstanceOfCrypt:: configKeyCryptClassName: null >>> WARN 04-14 19:19:57.985 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: mute.keycode >>> WARN 04-14 19:19:57.987 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: cam.fps >>> WARN 04-14 19:19:57.989 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: mic.rate >>> WARN 04-14 19:19:57.990 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: mic.echo.cancellation >>> WARN 04-14 19:19:57.992 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: mic.noise.suppression >>> WARN 04-14 19:19:57.999 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: user.login.minimum.length >>> WARN 04-14 19:19:58.001 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: user.login.minimum.length >>> WARN 04-14 19:19:58.002 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: default.group.id >>> WARN 04-14 19:19:58.004 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: sip.exten.context >>> WARN 04-14 19:19:58.006 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: user.fname.minimum.length >>> WARN 04-14 19:19:58.007 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: user.lname.minimum.length >>> WARN 04-14 19:19:58.009 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: chat.send.on.enter >>> WARN 04-14 19:19:58.011 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: allow.frontend.register >>> WARN 04-14 19:19:58.013 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: allow.soap.register >>> WARN 04-14 19:19:58.014 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: allow.oauth.register >>> WARN 04-14 19:19:58.018 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: send.email.with.verfication >>> WARN 04-14 19:19:58.020 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: send.email.at.register >>> WARN 04-14 19:19:58.022 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: header.csp.frame.options >>> WARN 04-14 19:19:58.023 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: header.content.security.policy >>> WARN 04-14 19:19:58.025 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: chrome.sharing.ext.url >>> WARN 04-14 19:19:58.026 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: display.name.editable >>> WARN 04-14 19:19:58.033 o.a.o.d.d.b.ConfigurationDao:199 [main] - Could >>> not find key in configurations: external.process.ttl >>> DEBUG 04-14 19:19:58.035 o.a.o.u.Version:82 [main] - >>> >>> >>> ################################################################################ >>> # Openmeetings is >>> up # >>> # 5.0.0-M1 c88fce9 >>> 2019-03-29T14:46:44Z # >>> # and ready to >>> use # >>> >>> >>> ################################################################################ >>> >>> INFO 04-14 19:19:58.165 o.a.w.p.h.WebApplication:935 [main] - >>> [OpenmeetingsApplication] Started Wicket version 8.3.0 in DEPLOYMENT mode >>> INFO 04-14 19:19:59.134 o.a.c.e.ServerImpl:94 [main] - Setting the >>> server's publish address to be / >>> INFO 04-14 19:19:59.349 o.a.c.w.s.f.ReflectionServiceFactoryBean:437 >>> [main] - Creating Service { >>> http://webservice.openmeetings.apache.org/}org.apache.openmeetings.webservice.CalendarWebService >>> from class org.apache.openmeetings.webservice.CalendarWebService >>> INFO 04-14 19:20:00.765 o.a.c.e.ServerImpl:94 [main] - Setting the >>> server's publish address to be /CalendarService >>> INFO 04-14 19:20:00.780 o.a.c.w.s.f.ReflectionServiceFactoryBean:437 >>> [main] - Creating Service { >>> http://webservice.openmeetings.apache.org/}org.apache.openmeetings.webservice.ErrorWebService >>> from class org.apache.openmeetings.webservice.ErrorWebService >>> INFO 04-14 19:20:00.815 o.a.c.e.ServerImpl:94 [main] - Setting the >>> server's publish address to be /ErrorService >>> INFO 04-14 19:20:00.818 o.a.c.w.s.f.ReflectionServiceFactoryBean:437 >>> [main] - Creating Service { >>> http://webservice.openmeetings.apache.org/}org.apache.openmeetings.webservice.GroupWebService >>> from class org.apache.openmeetings.webservice.GroupWebService >>> INFO 04-14 19:20:00.973 o.a.c.e.ServerImpl:94 [main] - Setting the >>> server's publish address to be /GroupService >>> INFO 04-14 19:20:00.976 o.a.c.w.s.f.ReflectionServiceFactoryBean:437 >>> [main] - Creating Service { >>> http://webservice.openmeetings.apache.org/}org.apache.openmeetings.webservice.InfoWebService >>> from class org.apache.openmeetings.webservice.InfoWebService >>> INFO 04-14 19:20:01.090 o.a.c.e.ServerImpl:94 [main] - Setting the >>> server's publish address to be /InfoService >>> INFO 04-14 19:20:01.100 o.a.c.w.s.f.ReflectionServiceFactoryBean:437 >>> [main] - Creating Service { >>> http://webservice.openmeetings.apache.org/}org.apache.openmeetings.webservice.FileWebService >>> from class org.apache.openmeetings.webservice.FileWebService >>> INFO 04-14 19:20:01.337 o.k.j.c.JsonRpcClientNettyWebSocket:191 >>> [pool-1-thread-1] - [KurentoClient] Connecting native client >>> INFO 04-14 19:20:01.338 o.k.j.c.JsonRpcClientNettyWebSocket:220 >>> [pool-1-thread-1] - [KurentoClient] Creating new NioEventLoopGroup >>> INFO 04-14 19:20:01.400 o.k.j.c.JsonRpcClientNettyWebSocket:234 >>> [ntLoopGroup-4-1] - [KurentoClient] Initiating new Netty channel. Will >>> create new handler too! >>> WARN 04-14 19:20:01.419 o.k.j.c.JsonRpcClientNettyWebSocket:308 >>> [pool-1-thread-1] - [KurentoClient] Trying to close a >>> JsonRpcClientNettyWebSocket with channel == null >>> WARN 04-14 19:20:01.469 o.a.o.c.r.KurentoHandler:124 [pool-1-thread-1] >>> - Fail to create Kurento client, will re-try in 10000 ms >>> WARN 04-14 19:20:01.480 o.k.j.c.JsonRpcClient:270 [rbeatExec-e5-t0] - >>> [KurentoClient] Error sending heartbeat to server. Exception: >>> InterruptedException while trying to acquire lock >>> WARN 04-14 19:20:01.481 o.k.j.c.JsonRpcClient:287 [rbeatExec-e5-t0] - >>> [KurentoClient] Stopping heartbeat and closing client: failure during >>> heartbeat mechanism >>> INFO 04-14 19:20:01.493 o.a.c.e.ServerImpl:94 [main] - Setting the >>> server's publish address to be /FileService >>> INFO 04-14 19:20:01.502 o.a.c.w.s.f.ReflectionServiceFactoryBean:437 >>> [main] - Creating Service { >>> http://webservice.openmeetings.apache.org/}org.apache.openmeetings.webservice.RecordingWebService >>> from class org.apache.openmeetings.webservice.RecordingWebService >>> INFO 04-14 19:20:01.704 o.a.c.e.ServerImpl:94 [main] - Setting the >>> server's publish address to be /RecordService >>> INFO 04-14 19:20:01.707 o.a.c.w.s.f.ReflectionServiceFactoryBean:437 >>> [main] - Creating Service { >>> http://webservice.openmeetings.apache.org/}org.apache.openmeetings.webservice.RoomWebService >>> from class org.apache.openmeetings.webservice.RoomWebService >>> INFO 04-14 19:20:02.272 o.a.c.e.ServerImpl:94 [main] - Setting the >>> server's publish address to be /RoomService >>> INFO 04-14 19:20:02.275 o.a.c.w.s.f.ReflectionServiceFactoryBean:437 >>> [main] - Creating Service { >>> http://webservice.openmeetings.apache.org/}org.apache.openmeetings.webservice.UserWebService >>> from class org.apache.openmeetings.webservice.UserWebService >>> INFO 04-14 19:20:02.395 o.a.c.e.ServerImpl:94 [main] - Setting the >>> server's publish address to be /UserService >>> INFO 04-14 19:20:03.404 o.a.w.Application:550 [main] - >>> [OpenmeetingsApplication] destroy: Wicket jQuery UI initializer >>> INFO 04-14 19:20:03.405 o.a.w.Application:550 [main] - >>> [OpenmeetingsApplication] destroy: Wicket core library initializer >>> INFO 04-14 19:20:03.405 o.a.w.Application:550 [main] - >>> [OpenmeetingsApplication] destroy: >>> org.wicketstuff.dashboard.DashboardContextInitializer@75c880f1 >>> INFO 04-14 19:20:03.406 o.a.w.Application:550 [main] - >>> [OpenmeetingsApplication] destroy: Wicket extensions initializer >>> INFO 04-14 19:20:03.406 o.a.w.Application:550 [main] - >>> [OpenmeetingsApplication] destroy: Wicket Kendo UI initializer >>> INFO 04-14 19:20:03.406 o.a.w.Application:550 [main] - >>> [OpenmeetingsApplication] destroy: DevUtils DebugBar Initializer >>> INFO 04-14 19:20:03.406 o.a.w.Application:550 [main] - >>> [OpenmeetingsApplication] destroy: Wicket jQuery UI initializer (plugins) >>> INFO 04-14 19:20:03.407 o.a.w.Application:550 [main] - >>> [OpenmeetingsApplication] destroy: Wicket Kendo UI initializer >>> (theme-default) >>> >>> >>> No hint for the mysql connection (maybe I'm blind ;-)) >>> >>> If you mention the time zone in the connection string, you tlak about >>> the persistense.xml and the values of the connectionstring, right? >>> >>> Greetz Stefan >>> >>> Am 15.04.2019 06:49, schrieb Maxim Solodovnik: >>> >>> Hello, >>> >>> for 5.0.0-M1 you need to use latest MySql java driver (8.0.15 at the >>> time of writing): >>> https://mvnrepository.com/artifact/mysql/mysql-connector-java >>> Also please check openmeetings.log and ensure what the exact error is >>> being reported while connecting >>> (you might need to add server time zone to connection string ....) >>> >>> On Mon, 15 Apr 2019 at 11:34, Stefan Kühl <[email protected]> wrote: >>> >>>> Good Morning @all, >>>> >>>> I'm sorry and don't wanna create a messenger out of this list, but the >>>> problem is still present. >>>> To make a clear summary: >>>> >>>> The host is a VPS with 4 core and 12GB RAM, running under an >>>> "up-to-date" Ubuntu 18.04. OS. I am hsting to vHosts using an Apache2 >>>> Webserver. >>>> The former installation of OM was an 4.0.4., running well (but with >>>> flash). My steps to upgrade to OM5 were the following: >>>> >>>> 1. Delete folder with existing installtion of OM (backup not nessecary, >>>> no files, just a few users) >>>> >>>> 2. Drop Database >>>> >>>> 3. Create new Database (tried same name first, later on tried different >>>> names) >>>> >>>> 4. Unzip OM 5 in the folder (same procedure: same name first...) >>>> >>>> 5. Start OM using the tomcat3 script (folder-names updatet if nessecary) >>>> >>>> 6. Running Web-Installer >>>> >>>> Facing Problem that the mysql settings not work. Error: >>>> >>>> Could not create connection to database server. Attempted reconnect 3 >>>> times. Giving up. (second page web-installer) >>>> >>>> Credentials are correct and worked fine via cli! >>>> >>>> Additional steps I've tried: >>>> >>>> reinstall of OM with Tutorial (sparing out the steps Java - version 1.8 >>>> is installed), >>>> tried both java connectors (version 5.x and 8.x), >>>> reinstall mariadb-server, >>>> drop databases und recreate, >>>> copy mysql-persistence.xml with valid database and credentials, >>>> ... >>>> >>>> Something strange: When stopped and leave the web-installer in step 2 >>>> (Database settings) I receive a "redirection error" if I try to restart the >>>> web-installer?! >>>> >>>> Ok, so far....any ideas? >>>> >>>> Maybe a problem of Apache2? (no idea why, but the last thing I didn't >>>> change) >>>> >>>> Greetz >>>> >>>> Stefan >>>> >>> >>> >>> -- >>> WBR >>> Maxim aka solomax >>> >>> >> >> -- >> WBR >> Maxim aka solomax >> >> > > -- > WBR > Maxim aka solomax > -- WBR Maxim aka solomax
