You MUST have huge stack-trace in the log in this case .....
On Mon, 15 Apr 2019 at 12:47, Stefan Kühl <ste...@quatrekuehl.eu> 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 <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
>
>
--
WBR
Maxim aka solomax
