"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 <ste...@quatrekuehl.eu> 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 <ste...@quatrekuehl.eu> 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
