You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@openmeetings.apache.org by Maxim Solodovnik <so...@gmail.com> on 2019/04/02 05:35:35 UTC
Could not connect to MariaDB
Hello All,
recently I got error report from Alvaro regarding DB connection issue while
MariaDB us used
After some "email ping-pong" I got logs, relevant part of logs can be found
here [1]
The first, huge stack trace provides only general information: "Could not
create connection to database server. Attempted reconnect 3 times. Giving
up."
Nothing to work with
BUT the second one states: "The server time zone value 'CEST' is
unrecognized or represents more than one time zone. You must configure
either the server or JDBC driver (via the serverTimezone configuration
property) to use a more specifc time zone value if you want to utilize time
zone support."
This one provides the root cause of the problem and possible solutions:
1) change server TZ to be more specific i.e. Europe/Berlin (not CEST)
2) edit persistense.xml file and add `serverTimezone` configuration
property with TZ of MariaDb server
Hope it can help
[1]
java.sql.SQLNonTransientConnectionException: Could not create connection to
database server. Attempted reconnect 3 times. Giving up.
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
at
com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:905)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:830)
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
at
com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at
org.apache.openmeetings.web.pages.install.InstallWizard$DbStep$1.onValidateModelObjects(InstallWizard.java:266)
at
org.apache.wicket.markup.html.form.Form.internalOnValidateModelObjects(Form.java:1870)
at org.apache.wicket.markup.html.form.Form.process(Form.java:956)
at org.apache.wicket.markup.html.form.Form.onFormSubmitted(Form.java:788)
at
org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:176)
at
org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:127)
at
org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:598)
at
org.apache.wicket.core.request.handler.ListenerRequestHandler.internalInvoke(ListenerRequestHandler.java:306)
at
org.apache.wicket.core.request.handler.ListenerRequestHandler.invoke(ListenerRequestHandler.java:280)
at
org.apache.wicket.core.request.handler.ListenerRequestHandler.invokeListener(ListenerRequestHandler.java:222)
at
org.apache.wicket.core.request.handler.ListenerRequestHandler.respond(ListenerRequestHandler.java:208)
at
org.apache.wicket.request.cycle.RequestCycle$HandlerExecutor.respond(RequestCycle.java:914)
at
org.apache.wicket.request.RequestHandlerExecutor.execute(RequestHandlerExecutor.java:65)
at
org.apache.wicket.request.cycle.RequestCycle.execute(RequestCycle.java:282)
at
org.apache.wicket.request.cycle.RequestCycle.processRequest(RequestCycle.java:253)
at
org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(RequestCycle.java:221)
at
org.apache.wicket.protocol.ws.AbstractUpgradeFilter.processRequestCycle(AbstractUpgradeFilter.java:70)
at
org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:206)
at
org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:299)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:607)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at
org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at
org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
at
org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at
org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834)
at
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415)
at
org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The
server time zone value 'CEST' is unrecognized or represents more than one
time zone. You must configure either the server or JDBC driver (via the
serverTimezone configuration property) to use a more specifc time zone
value if you want to utilize time zone support.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at
com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
at
com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132)
at
com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2241)
at
com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2265)
at
com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1319)
at
com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:868)
... 44 common frames omitted
--
WBR
Maxim aka solomax
Re: Import backup
Posted by Maxim Solodovnik <so...@gmail.com>.
Hello Peter,
just have tried the same steps and everything was OK for me
maybe you can share "demo" backup with me?
On Fri, 12 Apr 2019 at 20:48, Peter Dähn <da...@vcrp.de> wrote:
> Hi Maxim,
>
> finally, unfortunately this didn't fix it...
>
>
>
>
> This one I "produce" on purpose follow your steps...
>
> to verify you need some installation with
> 1) multiple users
> 2) users should have private files/recordings
>
> Test:
> 1) delete user with private files/recordings
> 2) perform export
> 3) create new OM server/instance
> 4) perform import
> 5) Check none of private files/recordings became public :)
>
> Greetings Peter
>
>
>
> Am 11.04.19 um 14:44 schrieb Maxim Solodovnik:
>
> Thanks for checking!
>
> On Thu, 11 Apr 2019 at 19:42, Peter Dähn <da...@vcrp.de> wrote:
>
>> Hi Maxim,
>>
>> I'm testing update procedure for Monday with nearly original data. There
>> are over 9000 Rooms with a lot of files (up to 185GB over all). Cleanup
>> runs ones a week, but didn't help that much... ;-)
>>
>> Greetings Peter
>>
>>
>> Am 11.04.19 um 14:13 schrieb Maxim Solodovnik:
>>
>> Thanks Peter!
>>
>> BTW this can be speed-up if you will remove files :) (all XMLs should be
>> on their original places ...)
>>
>> On Thu, 11 Apr 2019 at 19:06, Peter Dähn <da...@vcrp.de> wrote:
>>
>>> still take a while...
>>>
>>>
>>>
>>> runs for houres for all room files during backup...
>>>
>>> but working on it... ;-)
>>>
>>> Am 11.04.19 um 10:45 schrieb Maxim Solodovnik:
>>>
>>> It was fixed for both branches :)
>>>
>>>
>>> https://builds.apache.org/view/M-R/view/OpenMeetings/job/OpenMeetings%204.0.x/
>>>
>>> On Thu, 11 Apr 2019 at 15:35, Peter Dähn <da...@vcrp.de> wrote:
>>>
>>>> Hi Maxim,
>>>>
>>>> I would like to test it, but I have no working 5.0.x setup by now.
>>>>
>>>> Btw. I would need it for 4.0.x ... ;-)
>>>>
>>>> Greetings Peter
>>>>
>>>> Am 10.04.19 um 17:40 schrieb Maxim Solodovnik:
>>>>
>>>> Should be fixed,
>>>>
>>>> would appreciate if you can test :)
>>>>
>>>> On Mon, 8 Apr 2019 at 20:52, Maxim Solodovnik <so...@gmail.com>
>>>> wrote:
>>>>
>>>>> I need to check the code, but here is the possible scenario:
>>>>>
>>>>> 1) recording belongs to deleted user
>>>>> 2) no "Admin->Clean-up"
>>>>> 3) Export/Import
>>>>> deleted user -> null
>>>>>
>>>>> Recording belong to `null` user and `null` room == public
>>>>>
>>>>> Could you please file the JIRA?
>>>>> I'll try to check and fix this ASAP
>>>>>
>>>>> On Mon, 8 Apr 2019 at 19:52, Peter Dähn <da...@vcrp.de> wrote:
>>>>> >
>>>>> > Yes, thats what I meant.
>>>>> >
>>>>> > 3.0.7 public recordings 0 and 4.0.8 public recordings ~110
>>>>> >
>>>>> >
>>>>> >
>>>>> > Am 08.04.19 um 14:22 schrieb Maxim Solodovnik:
>>>>> > > Hello Peter,
>>>>> > >
>>>>> > > What do you mean by "But in 4.0.8 we get a few public recordings,
>>>>> that
>>>>> > > are not there in the current installation (3.0.7)" ?
>>>>> > > While importing recordings were moved to "Public recordings"?
>>>>> > >
>>>>> > > On Mon, 8 Apr 2019 at 19:17, Peter Dähn <da...@vcrp.de> wrote:
>>>>> > >> Hi Maxim,
>>>>> > >>
>>>>> > >> we are going to (finally) install om 4.0.8 next week. I made a
>>>>> few tests
>>>>> > >> with backup/restore. This worked so far. But in 4.0.8 we get a few
>>>>> > >> public recordings, that are not there in the current installation
>>>>> (3.0.7).
>>>>> > >>
>>>>> > >> I would like to simply unpublish this recordings. But I didn't
>>>>> find the
>>>>> > >> way to do so.
>>>>> > >>
>>>>> > >> Any hints for me?
>>>>> > >>
>>>>> > >> Greetings Peter
>>>>> > >>
>>>>> > >
>>>>> >
>>>>> >
>>>>>
>>>>>
>>>>> --
>>>>> WBR
>>>>> Maxim aka solomax
>>>>>
>>>>
>>>>
>>>> --
>>>> WBR
>>>> Maxim aka solomax
>>>>
>>>>
>>>>
>>>
>>> --
>>> WBR
>>> Maxim aka solomax
>>>
>>>
>>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>>
>>
>
> --
> WBR
> Maxim aka solomax
>
>
>
--
WBR
Maxim aka solomax
Re: Import backup
Posted by Peter Dähn <da...@vcrp.de>.
Hi Maxim,
finally, unfortunately this didn't fix it...
This one I "produce" on purpose follow your steps...
to verify you need some installation with
1) multiple users
2) users should have private files/recordings
Test:
1) delete user with private files/recordings
2) perform export
3) create new OM server/instance
4) perform import
5) Check none of private files/recordings became public :)
Greetings Peter
Am 11.04.19 um 14:44 schrieb Maxim Solodovnik:
> Thanks for checking!
>
> On Thu, 11 Apr 2019 at 19:42, Peter Dähn <daehn@vcrp.de
> <ma...@vcrp.de>> wrote:
>
> Hi Maxim,
>
> I'm testing update procedure for Monday with nearly original data.
> There are over 9000 Rooms with a lot of files (up to 185GB over
> all). Cleanup runs ones a week, but didn't help that much... ;-)
>
> Greetings Peter
>
>
> Am 11.04.19 um 14:13 schrieb Maxim Solodovnik:
>> Thanks Peter!
>>
>> BTW this can be speed-up if you will remove files :) (all XMLs
>> should be on their original places ...)
>>
>> On Thu, 11 Apr 2019 at 19:06, Peter Dähn <daehn@vcrp.de
>> <ma...@vcrp.de>> wrote:
>>
>> still take a while...
>>
>>
>>
>> runs for houres for all room files during backup...
>>
>> but working on it... ;-)
>>
>> Am 11.04.19 um 10:45 schrieb Maxim Solodovnik:
>>> It was fixed for both branches :)
>>>
>>> https://builds.apache.org/view/M-R/view/OpenMeetings/job/OpenMeetings%204.0.x/
>>>
>>> On Thu, 11 Apr 2019 at 15:35, Peter Dähn <daehn@vcrp.de
>>> <ma...@vcrp.de>> wrote:
>>>
>>> Hi Maxim,
>>>
>>> I would like to test it, but I have no working 5.0.x
>>> setup by now.
>>>
>>> Btw. I would need it for 4.0.x ... ;-)
>>>
>>> Greetings Peter
>>>
>>> Am 10.04.19 um 17:40 schrieb Maxim Solodovnik:
>>>> Should be fixed,
>>>>
>>>> would appreciate if you can test :)
>>>>
>>>> On Mon, 8 Apr 2019 at 20:52, Maxim Solodovnik
>>>> <solomax666@gmail.com <ma...@gmail.com>> wrote:
>>>>
>>>> I need to check the code, but here is the possible
>>>> scenario:
>>>>
>>>> 1) recording belongs to deleted user
>>>> 2) no "Admin->Clean-up"
>>>> 3) Export/Import
>>>> deleted user -> null
>>>>
>>>> Recording belong to `null` user and `null` room ==
>>>> public
>>>>
>>>> Could you please file the JIRA?
>>>> I'll try to check and fix this ASAP
>>>>
>>>> On Mon, 8 Apr 2019 at 19:52, Peter Dähn
>>>> <daehn@vcrp.de <ma...@vcrp.de>> wrote:
>>>> >
>>>> > Yes, thats what I meant.
>>>> >
>>>> > 3.0.7 public recordings 0 and 4.0.8 public
>>>> recordings ~110
>>>> >
>>>> >
>>>> >
>>>> > Am 08.04.19 um 14:22 schrieb Maxim Solodovnik:
>>>> > > Hello Peter,
>>>> > >
>>>> > > What do you mean by "But in 4.0.8 we get a few
>>>> public recordings, that
>>>> > > are not there in the current installation
>>>> (3.0.7)" ?
>>>> > > While importing recordings were moved to
>>>> "Public recordings"?
>>>> > >
>>>> > > On Mon, 8 Apr 2019 at 19:17, Peter Dähn
>>>> <daehn@vcrp.de <ma...@vcrp.de>> wrote:
>>>> > >> Hi Maxim,
>>>> > >>
>>>> > >> we are going to (finally) install om 4.0.8
>>>> next week. I made a few tests
>>>> > >> with backup/restore. This worked so far. But
>>>> in 4.0.8 we get a few
>>>> > >> public recordings, that are not there in the
>>>> current installation (3.0.7).
>>>> > >>
>>>> > >> I would like to simply unpublish this
>>>> recordings. But I didn't find the
>>>> > >> way to do so.
>>>> > >>
>>>> > >> Any hints for me?
>>>> > >>
>>>> > >> Greetings Peter
>>>> > >>
>>>> > >
>>>> >
>>>> >
>>>>
>>>>
>>>> --
>>>> WBR
>>>> Maxim aka solomax
>>>>
>>>>
>>>>
>>>> --
>>>> WBR
>>>> Maxim aka solomax
>>>
>>>
>>>
>>> --
>>> WBR
>>> Maxim aka solomax
>>
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>
>
>
> --
> WBR
> Maxim aka solomax
Re: Import backup
Posted by Maxim Solodovnik <so...@gmail.com>.
Thanks for checking!
On Thu, 11 Apr 2019 at 19:42, Peter Dähn <da...@vcrp.de> wrote:
> Hi Maxim,
>
> I'm testing update procedure for Monday with nearly original data. There
> are over 9000 Rooms with a lot of files (up to 185GB over all). Cleanup
> runs ones a week, but didn't help that much... ;-)
>
> Greetings Peter
>
>
> Am 11.04.19 um 14:13 schrieb Maxim Solodovnik:
>
> Thanks Peter!
>
> BTW this can be speed-up if you will remove files :) (all XMLs should be
> on their original places ...)
>
> On Thu, 11 Apr 2019 at 19:06, Peter Dähn <da...@vcrp.de> wrote:
>
>> still take a while...
>>
>>
>>
>> runs for houres for all room files during backup...
>>
>> but working on it... ;-)
>>
>> Am 11.04.19 um 10:45 schrieb Maxim Solodovnik:
>>
>> It was fixed for both branches :)
>>
>>
>> https://builds.apache.org/view/M-R/view/OpenMeetings/job/OpenMeetings%204.0.x/
>>
>> On Thu, 11 Apr 2019 at 15:35, Peter Dähn <da...@vcrp.de> wrote:
>>
>>> Hi Maxim,
>>>
>>> I would like to test it, but I have no working 5.0.x setup by now.
>>>
>>> Btw. I would need it for 4.0.x ... ;-)
>>>
>>> Greetings Peter
>>>
>>> Am 10.04.19 um 17:40 schrieb Maxim Solodovnik:
>>>
>>> Should be fixed,
>>>
>>> would appreciate if you can test :)
>>>
>>> On Mon, 8 Apr 2019 at 20:52, Maxim Solodovnik <so...@gmail.com>
>>> wrote:
>>>
>>>> I need to check the code, but here is the possible scenario:
>>>>
>>>> 1) recording belongs to deleted user
>>>> 2) no "Admin->Clean-up"
>>>> 3) Export/Import
>>>> deleted user -> null
>>>>
>>>> Recording belong to `null` user and `null` room == public
>>>>
>>>> Could you please file the JIRA?
>>>> I'll try to check and fix this ASAP
>>>>
>>>> On Mon, 8 Apr 2019 at 19:52, Peter Dähn <da...@vcrp.de> wrote:
>>>> >
>>>> > Yes, thats what I meant.
>>>> >
>>>> > 3.0.7 public recordings 0 and 4.0.8 public recordings ~110
>>>> >
>>>> >
>>>> >
>>>> > Am 08.04.19 um 14:22 schrieb Maxim Solodovnik:
>>>> > > Hello Peter,
>>>> > >
>>>> > > What do you mean by "But in 4.0.8 we get a few public recordings,
>>>> that
>>>> > > are not there in the current installation (3.0.7)" ?
>>>> > > While importing recordings were moved to "Public recordings"?
>>>> > >
>>>> > > On Mon, 8 Apr 2019 at 19:17, Peter Dähn <da...@vcrp.de> wrote:
>>>> > >> Hi Maxim,
>>>> > >>
>>>> > >> we are going to (finally) install om 4.0.8 next week. I made a few
>>>> tests
>>>> > >> with backup/restore. This worked so far. But in 4.0.8 we get a few
>>>> > >> public recordings, that are not there in the current installation
>>>> (3.0.7).
>>>> > >>
>>>> > >> I would like to simply unpublish this recordings. But I didn't
>>>> find the
>>>> > >> way to do so.
>>>> > >>
>>>> > >> Any hints for me?
>>>> > >>
>>>> > >> Greetings Peter
>>>> > >>
>>>> > >
>>>> >
>>>> >
>>>>
>>>>
>>>> --
>>>> WBR
>>>> Maxim aka solomax
>>>>
>>>
>>>
>>> --
>>> WBR
>>> Maxim aka solomax
>>>
>>>
>>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>>
>>
>
> --
> WBR
> Maxim aka solomax
>
>
>
--
WBR
Maxim aka solomax
Re: Import backup
Posted by Peter Dähn <da...@vcrp.de>.
Hi Maxim,
I'm testing update procedure for Monday with nearly original data. There
are over 9000 Rooms with a lot of files (up to 185GB over all). Cleanup
runs ones a week, but didn't help that much... ;-)
Greetings Peter
Am 11.04.19 um 14:13 schrieb Maxim Solodovnik:
> Thanks Peter!
>
> BTW this can be speed-up if you will remove files :) (all XMLs should
> be on their original places ...)
>
> On Thu, 11 Apr 2019 at 19:06, Peter Dähn <daehn@vcrp.de
> <ma...@vcrp.de>> wrote:
>
> still take a while...
>
>
>
> runs for houres for all room files during backup...
>
> but working on it... ;-)
>
> Am 11.04.19 um 10:45 schrieb Maxim Solodovnik:
>> It was fixed for both branches :)
>>
>> https://builds.apache.org/view/M-R/view/OpenMeetings/job/OpenMeetings%204.0.x/
>>
>> On Thu, 11 Apr 2019 at 15:35, Peter Dähn <daehn@vcrp.de
>> <ma...@vcrp.de>> wrote:
>>
>> Hi Maxim,
>>
>> I would like to test it, but I have no working 5.0.x setup by
>> now.
>>
>> Btw. I would need it for 4.0.x ... ;-)
>>
>> Greetings Peter
>>
>> Am 10.04.19 um 17:40 schrieb Maxim Solodovnik:
>>> Should be fixed,
>>>
>>> would appreciate if you can test :)
>>>
>>> On Mon, 8 Apr 2019 at 20:52, Maxim Solodovnik
>>> <solomax666@gmail.com <ma...@gmail.com>> wrote:
>>>
>>> I need to check the code, but here is the possible scenario:
>>>
>>> 1) recording belongs to deleted user
>>> 2) no "Admin->Clean-up"
>>> 3) Export/Import
>>> deleted user -> null
>>>
>>> Recording belong to `null` user and `null` room == public
>>>
>>> Could you please file the JIRA?
>>> I'll try to check and fix this ASAP
>>>
>>> On Mon, 8 Apr 2019 at 19:52, Peter Dähn <daehn@vcrp.de
>>> <ma...@vcrp.de>> wrote:
>>> >
>>> > Yes, thats what I meant.
>>> >
>>> > 3.0.7 public recordings 0 and 4.0.8 public recordings ~110
>>> >
>>> >
>>> >
>>> > Am 08.04.19 um 14:22 schrieb Maxim Solodovnik:
>>> > > Hello Peter,
>>> > >
>>> > > What do you mean by "But in 4.0.8 we get a few
>>> public recordings, that
>>> > > are not there in the current installation (3.0.7)" ?
>>> > > While importing recordings were moved to "Public
>>> recordings"?
>>> > >
>>> > > On Mon, 8 Apr 2019 at 19:17, Peter Dähn
>>> <daehn@vcrp.de <ma...@vcrp.de>> wrote:
>>> > >> Hi Maxim,
>>> > >>
>>> > >> we are going to (finally) install om 4.0.8 next
>>> week. I made a few tests
>>> > >> with backup/restore. This worked so far. But in
>>> 4.0.8 we get a few
>>> > >> public recordings, that are not there in the
>>> current installation (3.0.7).
>>> > >>
>>> > >> I would like to simply unpublish this recordings.
>>> But I didn't find the
>>> > >> way to do so.
>>> > >>
>>> > >> Any hints for me?
>>> > >>
>>> > >> Greetings Peter
>>> > >>
>>> > >
>>> >
>>> >
>>>
>>>
>>> --
>>> WBR
>>> Maxim aka solomax
>>>
>>>
>>>
>>> --
>>> WBR
>>> Maxim aka solomax
>>
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>
>
>
> --
> WBR
> Maxim aka solomax
Re: Import backup
Posted by Maxim Solodovnik <so...@gmail.com>.
Thanks Peter!
BTW this can be speed-up if you will remove files :) (all XMLs should be on
their original places ...)
On Thu, 11 Apr 2019 at 19:06, Peter Dähn <da...@vcrp.de> wrote:
> still take a while...
>
>
>
> runs for houres for all room files during backup...
>
> but working on it... ;-)
>
> Am 11.04.19 um 10:45 schrieb Maxim Solodovnik:
>
> It was fixed for both branches :)
>
>
> https://builds.apache.org/view/M-R/view/OpenMeetings/job/OpenMeetings%204.0.x/
>
> On Thu, 11 Apr 2019 at 15:35, Peter Dähn <da...@vcrp.de> wrote:
>
>> Hi Maxim,
>>
>> I would like to test it, but I have no working 5.0.x setup by now.
>>
>> Btw. I would need it for 4.0.x ... ;-)
>>
>> Greetings Peter
>>
>> Am 10.04.19 um 17:40 schrieb Maxim Solodovnik:
>>
>> Should be fixed,
>>
>> would appreciate if you can test :)
>>
>> On Mon, 8 Apr 2019 at 20:52, Maxim Solodovnik <so...@gmail.com>
>> wrote:
>>
>>> I need to check the code, but here is the possible scenario:
>>>
>>> 1) recording belongs to deleted user
>>> 2) no "Admin->Clean-up"
>>> 3) Export/Import
>>> deleted user -> null
>>>
>>> Recording belong to `null` user and `null` room == public
>>>
>>> Could you please file the JIRA?
>>> I'll try to check and fix this ASAP
>>>
>>> On Mon, 8 Apr 2019 at 19:52, Peter Dähn <da...@vcrp.de> wrote:
>>> >
>>> > Yes, thats what I meant.
>>> >
>>> > 3.0.7 public recordings 0 and 4.0.8 public recordings ~110
>>> >
>>> >
>>> >
>>> > Am 08.04.19 um 14:22 schrieb Maxim Solodovnik:
>>> > > Hello Peter,
>>> > >
>>> > > What do you mean by "But in 4.0.8 we get a few public recordings,
>>> that
>>> > > are not there in the current installation (3.0.7)" ?
>>> > > While importing recordings were moved to "Public recordings"?
>>> > >
>>> > > On Mon, 8 Apr 2019 at 19:17, Peter Dähn <da...@vcrp.de> wrote:
>>> > >> Hi Maxim,
>>> > >>
>>> > >> we are going to (finally) install om 4.0.8 next week. I made a few
>>> tests
>>> > >> with backup/restore. This worked so far. But in 4.0.8 we get a few
>>> > >> public recordings, that are not there in the current installation
>>> (3.0.7).
>>> > >>
>>> > >> I would like to simply unpublish this recordings. But I didn't find
>>> the
>>> > >> way to do so.
>>> > >>
>>> > >> Any hints for me?
>>> > >>
>>> > >> Greetings Peter
>>> > >>
>>> > >
>>> >
>>> >
>>>
>>>
>>> --
>>> WBR
>>> Maxim aka solomax
>>>
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>>
>>
>
> --
> WBR
> Maxim aka solomax
>
>
>
--
WBR
Maxim aka solomax
Re: Import backup
Posted by Stefan Kühl <st...@quatrekuehl.eu>.
Hey Peter,
do you use Docker for KMS or do you try the native installation?
Greetz
Stefan
Am 11.04.2019 14:06, schrieb Peter Dähn:
> still take a while...
>
> runs for houres for all room files during backup...
>
> but working on it... ;-)
>
> Am 11.04.19 um 10:45 schrieb Maxim Solodovnik:
> It was fixed for both branches :)
>
> https://builds.apache.org/view/M-R/view/OpenMeetings/job/OpenMeetings%204.0.x/
>
> On Thu, 11 Apr 2019 at 15:35, Peter Dähn <da...@vcrp.de> wrote:
> Hi Maxim,
>
> I would like to test it, but I have no working 5.0.x setup by now.
>
> Btw. I would need it for 4.0.x ... ;-)
>
> Greetings Peter
>
> Am 10.04.19 um 17:40 schrieb Maxim Solodovnik:
> Should be fixed,
>
> would appreciate if you can test :)
>
> On Mon, 8 Apr 2019 at 20:52, Maxim Solodovnik <so...@gmail.com> wrote: I need to check the code, but here is the possible scenario:
>
> 1) recording belongs to deleted user
> 2) no "Admin->Clean-up"
> 3) Export/Import
> deleted user -> null
>
> Recording belong to `null` user and `null` room == public
>
> Could you please file the JIRA?
> I'll try to check and fix this ASAP
>
> On Mon, 8 Apr 2019 at 19:52, Peter Dähn <da...@vcrp.de> wrote:
>>
>> Yes, thats what I meant.
>>
>> 3.0.7 public recordings 0 and 4.0.8 public recordings ~110
>>
>>
>>
>> Am 08.04.19 um 14:22 schrieb Maxim Solodovnik:
>>> Hello Peter,
>>>
>>> What do you mean by "But in 4.0.8 we get a few public recordings, that
>>> are not there in the current installation (3.0.7)" ?
>>> While importing recordings were moved to "Public recordings"?
>>>
>>> On Mon, 8 Apr 2019 at 19:17, Peter Dähn <da...@vcrp.de> wrote:
>>>> Hi Maxim,
>>>>
>>>> we are going to (finally) install om 4.0.8 next week. I made a few tests
>>>> with backup/restore. This worked so far. But in 4.0.8 we get a few
>>>> public recordings, that are not there in the current installation (3.0.7).
>>>>
>>>> I would like to simply unpublish this recordings. But I didn't find the
>>>> way to do so.
>>>>
>>>> Any hints for me?
>>>>
>>>> Greetings Peter
>>>>
>>>
>>
>>
>
> --
> WBR
> Maxim aka solomax
> --
> WBR
> Maxim aka solomax
--
WBR
Maxim aka solomax
Re: Import backup
Posted by Peter Dähn <da...@vcrp.de>.
still take a while...
runs for houres for all room files during backup...
but working on it... ;-)
Am 11.04.19 um 10:45 schrieb Maxim Solodovnik:
> It was fixed for both branches :)
>
> https://builds.apache.org/view/M-R/view/OpenMeetings/job/OpenMeetings%204.0.x/
>
> On Thu, 11 Apr 2019 at 15:35, Peter Dähn <daehn@vcrp.de
> <ma...@vcrp.de>> wrote:
>
> Hi Maxim,
>
> I would like to test it, but I have no working 5.0.x setup by now.
>
> Btw. I would need it for 4.0.x ... ;-)
>
> Greetings Peter
>
> Am 10.04.19 um 17:40 schrieb Maxim Solodovnik:
>> Should be fixed,
>>
>> would appreciate if you can test :)
>>
>> On Mon, 8 Apr 2019 at 20:52, Maxim Solodovnik
>> <solomax666@gmail.com <ma...@gmail.com>> wrote:
>>
>> I need to check the code, but here is the possible scenario:
>>
>> 1) recording belongs to deleted user
>> 2) no "Admin->Clean-up"
>> 3) Export/Import
>> deleted user -> null
>>
>> Recording belong to `null` user and `null` room == public
>>
>> Could you please file the JIRA?
>> I'll try to check and fix this ASAP
>>
>> On Mon, 8 Apr 2019 at 19:52, Peter Dähn <daehn@vcrp.de
>> <ma...@vcrp.de>> wrote:
>> >
>> > Yes, thats what I meant.
>> >
>> > 3.0.7 public recordings 0 and 4.0.8 public recordings ~110
>> >
>> >
>> >
>> > Am 08.04.19 um 14:22 schrieb Maxim Solodovnik:
>> > > Hello Peter,
>> > >
>> > > What do you mean by "But in 4.0.8 we get a few public
>> recordings, that
>> > > are not there in the current installation (3.0.7)" ?
>> > > While importing recordings were moved to "Public recordings"?
>> > >
>> > > On Mon, 8 Apr 2019 at 19:17, Peter Dähn <daehn@vcrp.de
>> <ma...@vcrp.de>> wrote:
>> > >> Hi Maxim,
>> > >>
>> > >> we are going to (finally) install om 4.0.8 next week. I
>> made a few tests
>> > >> with backup/restore. This worked so far. But in 4.0.8 we
>> get a few
>> > >> public recordings, that are not there in the current
>> installation (3.0.7).
>> > >>
>> > >> I would like to simply unpublish this recordings. But I
>> didn't find the
>> > >> way to do so.
>> > >>
>> > >> Any hints for me?
>> > >>
>> > >> Greetings Peter
>> > >>
>> > >
>> >
>> >
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>
>
>
> --
> WBR
> Maxim aka solomax
Re: Import backup
Posted by Maxim Solodovnik <so...@gmail.com>.
Thanks for willing to help!
to verify you need some installation with
1) multiple users
2) users should have private files/recordings
Test:
1) delete user with private files/recordings
2) perform export
3) create new OM server/instance
4) perform import
5) Check none of private files/recordings became public :)
On Thu, 11 Apr 2019 at 17:58, Mettavihari D <tv...@gmail.com> wrote:
> Greetings
>
> We have installed 5.0.x
>
> I would like to help testing, but I am a beginner
> If you tell me what to do I have the time to help with several trials.
>
> With metta
> Mettavihari
>
> On Thu, 11 Apr 2019, 14:15 Maxim Solodovnik, <so...@gmail.com> wrote:
>
>> It was fixed for both branches :)
>>
>>
>> https://builds.apache.org/view/M-R/view/OpenMeetings/job/OpenMeetings%204.0.x/
>>
>> On Thu, 11 Apr 2019 at 15:35, Peter Dähn <da...@vcrp.de> wrote:
>>
>>> Hi Maxim,
>>>
>>> I would like to test it, but I have no working 5.0.x setup by now.
>>>
>>> Btw. I would need it for 4.0.x ... ;-)
>>>
>>> Greetings Peter
>>>
>>> Am 10.04.19 um 17:40 schrieb Maxim Solodovnik:
>>>
>>> Should be fixed,
>>>
>>> would appreciate if you can test :)
>>>
>>> On Mon, 8 Apr 2019 at 20:52, Maxim Solodovnik <so...@gmail.com>
>>> wrote:
>>>
>>>> I need to check the code, but here is the possible scenario:
>>>>
>>>> 1) recording belongs to deleted user
>>>> 2) no "Admin->Clean-up"
>>>> 3) Export/Import
>>>> deleted user -> null
>>>>
>>>> Recording belong to `null` user and `null` room == public
>>>>
>>>> Could you please file the JIRA?
>>>> I'll try to check and fix this ASAP
>>>>
>>>> On Mon, 8 Apr 2019 at 19:52, Peter Dähn <da...@vcrp.de> wrote:
>>>> >
>>>> > Yes, thats what I meant.
>>>> >
>>>> > 3.0.7 public recordings 0 and 4.0.8 public recordings ~110
>>>> >
>>>> >
>>>> >
>>>> > Am 08.04.19 um 14:22 schrieb Maxim Solodovnik:
>>>> > > Hello Peter,
>>>> > >
>>>> > > What do you mean by "But in 4.0.8 we get a few public recordings,
>>>> that
>>>> > > are not there in the current installation (3.0.7)" ?
>>>> > > While importing recordings were moved to "Public recordings"?
>>>> > >
>>>> > > On Mon, 8 Apr 2019 at 19:17, Peter Dähn <da...@vcrp.de> wrote:
>>>> > >> Hi Maxim,
>>>> > >>
>>>> > >> we are going to (finally) install om 4.0.8 next week. I made a few
>>>> tests
>>>> > >> with backup/restore. This worked so far. But in 4.0.8 we get a few
>>>> > >> public recordings, that are not there in the current installation
>>>> (3.0.7).
>>>> > >>
>>>> > >> I would like to simply unpublish this recordings. But I didn't
>>>> find the
>>>> > >> way to do so.
>>>> > >>
>>>> > >> Any hints for me?
>>>> > >>
>>>> > >> Greetings Peter
>>>> > >>
>>>> > >
>>>> >
>>>> >
>>>>
>>>>
>>>> --
>>>> WBR
>>>> Maxim aka solomax
>>>>
>>>
>>>
>>> --
>>> WBR
>>> Maxim aka solomax
>>>
>>>
>>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>
--
WBR
Maxim aka solomax
Re: Import backup
Posted by Mettavihari D <tv...@gmail.com>.
Greetings
We have installed 5.0.x
I would like to help testing, but I am a beginner
If you tell me what to do I have the time to help with several trials.
With metta
Mettavihari
On Thu, 11 Apr 2019, 14:15 Maxim Solodovnik, <so...@gmail.com> wrote:
> It was fixed for both branches :)
>
>
> https://builds.apache.org/view/M-R/view/OpenMeetings/job/OpenMeetings%204.0.x/
>
> On Thu, 11 Apr 2019 at 15:35, Peter Dähn <da...@vcrp.de> wrote:
>
>> Hi Maxim,
>>
>> I would like to test it, but I have no working 5.0.x setup by now.
>>
>> Btw. I would need it for 4.0.x ... ;-)
>>
>> Greetings Peter
>>
>> Am 10.04.19 um 17:40 schrieb Maxim Solodovnik:
>>
>> Should be fixed,
>>
>> would appreciate if you can test :)
>>
>> On Mon, 8 Apr 2019 at 20:52, Maxim Solodovnik <so...@gmail.com>
>> wrote:
>>
>>> I need to check the code, but here is the possible scenario:
>>>
>>> 1) recording belongs to deleted user
>>> 2) no "Admin->Clean-up"
>>> 3) Export/Import
>>> deleted user -> null
>>>
>>> Recording belong to `null` user and `null` room == public
>>>
>>> Could you please file the JIRA?
>>> I'll try to check and fix this ASAP
>>>
>>> On Mon, 8 Apr 2019 at 19:52, Peter Dähn <da...@vcrp.de> wrote:
>>> >
>>> > Yes, thats what I meant.
>>> >
>>> > 3.0.7 public recordings 0 and 4.0.8 public recordings ~110
>>> >
>>> >
>>> >
>>> > Am 08.04.19 um 14:22 schrieb Maxim Solodovnik:
>>> > > Hello Peter,
>>> > >
>>> > > What do you mean by "But in 4.0.8 we get a few public recordings,
>>> that
>>> > > are not there in the current installation (3.0.7)" ?
>>> > > While importing recordings were moved to "Public recordings"?
>>> > >
>>> > > On Mon, 8 Apr 2019 at 19:17, Peter Dähn <da...@vcrp.de> wrote:
>>> > >> Hi Maxim,
>>> > >>
>>> > >> we are going to (finally) install om 4.0.8 next week. I made a few
>>> tests
>>> > >> with backup/restore. This worked so far. But in 4.0.8 we get a few
>>> > >> public recordings, that are not there in the current installation
>>> (3.0.7).
>>> > >>
>>> > >> I would like to simply unpublish this recordings. But I didn't find
>>> the
>>> > >> way to do so.
>>> > >>
>>> > >> Any hints for me?
>>> > >>
>>> > >> Greetings Peter
>>> > >>
>>> > >
>>> >
>>> >
>>>
>>>
>>> --
>>> WBR
>>> Maxim aka solomax
>>>
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>>
>>
>
> --
> WBR
> Maxim aka solomax
>
Re: Import backup
Posted by Maxim Solodovnik <so...@gmail.com>.
It was fixed for both branches :)
https://builds.apache.org/view/M-R/view/OpenMeetings/job/OpenMeetings%204.0.x/
On Thu, 11 Apr 2019 at 15:35, Peter Dähn <da...@vcrp.de> wrote:
> Hi Maxim,
>
> I would like to test it, but I have no working 5.0.x setup by now.
>
> Btw. I would need it for 4.0.x ... ;-)
>
> Greetings Peter
>
> Am 10.04.19 um 17:40 schrieb Maxim Solodovnik:
>
> Should be fixed,
>
> would appreciate if you can test :)
>
> On Mon, 8 Apr 2019 at 20:52, Maxim Solodovnik <so...@gmail.com>
> wrote:
>
>> I need to check the code, but here is the possible scenario:
>>
>> 1) recording belongs to deleted user
>> 2) no "Admin->Clean-up"
>> 3) Export/Import
>> deleted user -> null
>>
>> Recording belong to `null` user and `null` room == public
>>
>> Could you please file the JIRA?
>> I'll try to check and fix this ASAP
>>
>> On Mon, 8 Apr 2019 at 19:52, Peter Dähn <da...@vcrp.de> wrote:
>> >
>> > Yes, thats what I meant.
>> >
>> > 3.0.7 public recordings 0 and 4.0.8 public recordings ~110
>> >
>> >
>> >
>> > Am 08.04.19 um 14:22 schrieb Maxim Solodovnik:
>> > > Hello Peter,
>> > >
>> > > What do you mean by "But in 4.0.8 we get a few public recordings, that
>> > > are not there in the current installation (3.0.7)" ?
>> > > While importing recordings were moved to "Public recordings"?
>> > >
>> > > On Mon, 8 Apr 2019 at 19:17, Peter Dähn <da...@vcrp.de> wrote:
>> > >> Hi Maxim,
>> > >>
>> > >> we are going to (finally) install om 4.0.8 next week. I made a few
>> tests
>> > >> with backup/restore. This worked so far. But in 4.0.8 we get a few
>> > >> public recordings, that are not there in the current installation
>> (3.0.7).
>> > >>
>> > >> I would like to simply unpublish this recordings. But I didn't find
>> the
>> > >> way to do so.
>> > >>
>> > >> Any hints for me?
>> > >>
>> > >> Greetings Peter
>> > >>
>> > >
>> >
>> >
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>
>
> --
> WBR
> Maxim aka solomax
>
>
>
--
WBR
Maxim aka solomax
Re: Import backup
Posted by Peter Dähn <da...@vcrp.de>.
Hi Maxim,
I would like to test it, but I have no working 5.0.x setup by now.
Btw. I would need it for 4.0.x ... ;-)
Greetings Peter
Am 10.04.19 um 17:40 schrieb Maxim Solodovnik:
> Should be fixed,
>
> would appreciate if you can test :)
>
> On Mon, 8 Apr 2019 at 20:52, Maxim Solodovnik <solomax666@gmail.com
> <ma...@gmail.com>> wrote:
>
> I need to check the code, but here is the possible scenario:
>
> 1) recording belongs to deleted user
> 2) no "Admin->Clean-up"
> 3) Export/Import
> deleted user -> null
>
> Recording belong to `null` user and `null` room == public
>
> Could you please file the JIRA?
> I'll try to check and fix this ASAP
>
> On Mon, 8 Apr 2019 at 19:52, Peter Dähn <daehn@vcrp.de
> <ma...@vcrp.de>> wrote:
> >
> > Yes, thats what I meant.
> >
> > 3.0.7 public recordings 0 and 4.0.8 public recordings ~110
> >
> >
> >
> > Am 08.04.19 um 14:22 schrieb Maxim Solodovnik:
> > > Hello Peter,
> > >
> > > What do you mean by "But in 4.0.8 we get a few public
> recordings, that
> > > are not there in the current installation (3.0.7)" ?
> > > While importing recordings were moved to "Public recordings"?
> > >
> > > On Mon, 8 Apr 2019 at 19:17, Peter Dähn <daehn@vcrp.de
> <ma...@vcrp.de>> wrote:
> > >> Hi Maxim,
> > >>
> > >> we are going to (finally) install om 4.0.8 next week. I made
> a few tests
> > >> with backup/restore. This worked so far. But in 4.0.8 we get
> a few
> > >> public recordings, that are not there in the current
> installation (3.0.7).
> > >>
> > >> I would like to simply unpublish this recordings. But I
> didn't find the
> > >> way to do so.
> > >>
> > >> Any hints for me?
> > >>
> > >> Greetings Peter
> > >>
> > >
> >
> >
>
>
> --
> WBR
> Maxim aka solomax
>
>
>
> --
> WBR
> Maxim aka solomax
Re: Import backup
Posted by Maxim Solodovnik <so...@gmail.com>.
Should be fixed,
would appreciate if you can test :)
On Mon, 8 Apr 2019 at 20:52, Maxim Solodovnik <so...@gmail.com> wrote:
> I need to check the code, but here is the possible scenario:
>
> 1) recording belongs to deleted user
> 2) no "Admin->Clean-up"
> 3) Export/Import
> deleted user -> null
>
> Recording belong to `null` user and `null` room == public
>
> Could you please file the JIRA?
> I'll try to check and fix this ASAP
>
> On Mon, 8 Apr 2019 at 19:52, Peter Dähn <da...@vcrp.de> wrote:
> >
> > Yes, thats what I meant.
> >
> > 3.0.7 public recordings 0 and 4.0.8 public recordings ~110
> >
> >
> >
> > Am 08.04.19 um 14:22 schrieb Maxim Solodovnik:
> > > Hello Peter,
> > >
> > > What do you mean by "But in 4.0.8 we get a few public recordings, that
> > > are not there in the current installation (3.0.7)" ?
> > > While importing recordings were moved to "Public recordings"?
> > >
> > > On Mon, 8 Apr 2019 at 19:17, Peter Dähn <da...@vcrp.de> wrote:
> > >> Hi Maxim,
> > >>
> > >> we are going to (finally) install om 4.0.8 next week. I made a few
> tests
> > >> with backup/restore. This worked so far. But in 4.0.8 we get a few
> > >> public recordings, that are not there in the current installation
> (3.0.7).
> > >>
> > >> I would like to simply unpublish this recordings. But I didn't find
> the
> > >> way to do so.
> > >>
> > >> Any hints for me?
> > >>
> > >> Greetings Peter
> > >>
> > >
> >
> >
>
>
> --
> WBR
> Maxim aka solomax
>
--
WBR
Maxim aka solomax
Re: Import backup
Posted by Maxim Solodovnik <so...@gmail.com>.
I need to check the code, but here is the possible scenario:
1) recording belongs to deleted user
2) no "Admin->Clean-up"
3) Export/Import
deleted user -> null
Recording belong to `null` user and `null` room == public
Could you please file the JIRA?
I'll try to check and fix this ASAP
On Mon, 8 Apr 2019 at 19:52, Peter Dähn <da...@vcrp.de> wrote:
>
> Yes, thats what I meant.
>
> 3.0.7 public recordings 0 and 4.0.8 public recordings ~110
>
>
>
> Am 08.04.19 um 14:22 schrieb Maxim Solodovnik:
> > Hello Peter,
> >
> > What do you mean by "But in 4.0.8 we get a few public recordings, that
> > are not there in the current installation (3.0.7)" ?
> > While importing recordings were moved to "Public recordings"?
> >
> > On Mon, 8 Apr 2019 at 19:17, Peter Dähn <da...@vcrp.de> wrote:
> >> Hi Maxim,
> >>
> >> we are going to (finally) install om 4.0.8 next week. I made a few tests
> >> with backup/restore. This worked so far. But in 4.0.8 we get a few
> >> public recordings, that are not there in the current installation (3.0.7).
> >>
> >> I would like to simply unpublish this recordings. But I didn't find the
> >> way to do so.
> >>
> >> Any hints for me?
> >>
> >> Greetings Peter
> >>
> >
>
>
--
WBR
Maxim aka solomax
Re: Result 1st test - 10 Users
Posted by Maxim Solodovnik <so...@gmail.com>.
Will try to answer inline
On Mon, 8 Apr 2019 at 20:35, René Scholz
<re...@abakus-edv-systems.de> wrote:
>
> Hello,
>
> today I made test "OM5-M2" with 10 Users.
M1 was released (not announced)
M2 right now is equal to M1, but this is actually latest DEVELOPMENT version
>
> Here are my results:
>
> - sharing of a Application: An application (written in Delphi) only
> shares a black window by the viewer.
> No border, nothing. Only black. In the preview-windows it was black too.
> The moderator see it normal.
> Other application are fully visible. This is reproducable.
>
> - I gave a collegue the moderator-rights during the event. He tried to
> share the application ("black-screen") himself.
> First time he had not the whole list of running applications to share.
> Only the tabs into his browser (Firefox).
> After closing the browser, editing the room-configuration and made him
> default-moderator, start browser he saw "a few" applications in
> the pull-down-list. It was OK, the application "black-screen" was there.
> That's enough for this moment. But it was the same result, it was black too.
>
> - BTW: Whats the difference between the choice "Screen", "Window" and
> "Application"? After that the same question appears.
As I wrote in some other thread:
- Screen sharing is made by browser, we have almost no control on it
(only type can be selected)
- It is weird Delphi app resulting a black screen
- It is super weird there is difference in displaying shared area to
moderators/non-moderators, is it reproducible with all types of
sharing?
'Whats the difference between the choice "Screen", "Window" and
"Application"?' - I _believe_ this is:
* "Screen" - you are sharing one of your screens, with all windows,
applications notifications etc.
* "Window" - you are sharing particular window, for ex. browser
window, or window of terminal
* "Application" - most probably all application windows will be
shared, not sure about this
All above are my assumptions :))
>
> - Sometimes the button to share Desktop is away. Also the menu (Actions-
> Share...).
This should be as designed for non-moderator users
Could you please share your steps if this is not the case?
> Solution: Exit the room a moment and enter again: The Buttons are on the
> right places.
>
> - Soundquality: Very good.
>
> - A few persons login into the room before I go into it myself. Where I
> can configrate that this people only see a static picture (Logo).
You can put something to WB :)
> When I go into the room all members already in switch to the "normal
> screen".
>
>
> Short word: Fantastic. The new HTML5 is very nice.
Thanks!
While reading was sure resume would be awful :)
>
> Best regards,
>
> René
>
--
WBR
Maxim aka solomax
Result 1st test - 10 Users
Posted by René Scholz <re...@abakus-edv-systems.de>.
Hello,
today I made test "OM5-M2" with 10 Users.
Here are my results:
- sharing of a Application: An application (written in Delphi) only
shares a black window by the viewer.
No border, nothing. Only black. In the preview-windows it was black too.
The moderator see it normal.
Other application are fully visible. This is reproducable.
- I gave a collegue the moderator-rights during the event. He tried to
share the application ("black-screen") himself.
First time he had not the whole list of running applications to share.
Only the tabs into his browser (Firefox).
After closing the browser, editing the room-configuration and made him
default-moderator, start browser he saw "a few" applications in
the pull-down-list. It was OK, the application "black-screen" was there.
That's enough for this moment. But it was the same result, it was black too.
- BTW: Whats the difference between the choice "Screen", "Window" and
"Application"? After that the same question appears.
- Sometimes the button to share Desktop is away. Also the menu (Actions-
Share...).
Solution: Exit the room a moment and enter again: The Buttons are on the
right places.
- Soundquality: Very good.
- A few persons login into the room before I go into it myself. Where I
can configrate that this people only see a static picture (Logo).
When I go into the room all members already in switch to the "normal
screen".
Short word: Fantastic. The new HTML5 is very nice.
Best regards,
René
Re: Import backup
Posted by Peter Dähn <da...@vcrp.de>.
Yes, thats what I meant.
3.0.7 public recordings 0 and 4.0.8 public recordings ~110
Am 08.04.19 um 14:22 schrieb Maxim Solodovnik:
> Hello Peter,
>
> What do you mean by "But in 4.0.8 we get a few public recordings, that
> are not there in the current installation (3.0.7)" ?
> While importing recordings were moved to "Public recordings"?
>
> On Mon, 8 Apr 2019 at 19:17, Peter Dähn <da...@vcrp.de> wrote:
>> Hi Maxim,
>>
>> we are going to (finally) install om 4.0.8 next week. I made a few tests
>> with backup/restore. This worked so far. But in 4.0.8 we get a few
>> public recordings, that are not there in the current installation (3.0.7).
>>
>> I would like to simply unpublish this recordings. But I didn't find the
>> way to do so.
>>
>> Any hints for me?
>>
>> Greetings Peter
>>
>
Re: OM5 - Desktop-Sharing
Posted by Maxim Solodovnik <so...@gmail.com>.
Most probably this is historical behavior
Maybe because user can click "flashing icon" to check what it is :))
I don't know :)
On Mon, 8 Apr 2019 at 17:26, René Scholz
<re...@abakus-edv-systems.de> wrote:
>
> Aha. In the browser from the viewer you have to klick at the icon top right.
> There came the question to allow the desktop-sharing.
>
> Hm. Why the question come? it is necessary with technical reasons?
>
> Best regards,
>
> René
>
>
> Am 08.04.2019 um 12:16 schrieb Maxim Solodovnik:
>
> Not sure I got your question
>
> As soon as you press "Start" application you choose will be visible to
> other attendees
>
> Nothing to do
>
> On Mon, 8 Apr 2019 at 16:40, René Scholz
> <re...@abakus-edv-systems.de> wrote:
>
> Hello,
>
> I try to share my desktop - specially only one program.
>
> I open with the Button on the right side the Popup, choose "Application",
> select the right window and "Start".
>
> What I have to do next to publish the window?
>
> Best regards,
>
> René
>
>
>
>
>
>
--
WBR
Maxim aka solomax
Re: OM5 - Desktop-Sharing
Posted by René Scholz <re...@abakus-edv-systems.de>.
Aha. In the browser from the viewer you have to klick at the icon top
right.
There came the question to allow the desktop-sharing.
Hm. Why the question come? it is necessary with technical reasons?
Best regards,
René
Am 08.04.2019 um 12:16 schrieb Maxim Solodovnik:
> Not sure I got your question
>
> As soon as you press "Start" application you choose will be visible to
> other attendees
>
> Nothing to do
>
> On Mon, 8 Apr 2019 at 16:40, René Scholz
> <re...@abakus-edv-systems.de> wrote:
>> Hello,
>>
>> I try to share my desktop - specially only one program.
>>
>> I open with the Button on the right side the Popup, choose
>> "Application",
>> select the right window and "Start".
>>
>> What I have to do next to publish the window?
>>
>> Best regards,
>>
>> René
>>
>>
>>
>>
>
Re: OM5 - Desktop-Sharing
Posted by Maxim Solodovnik <so...@gmail.com>.
Not sure I got your question
As soon as you press "Start" application you choose will be visible to
other attendees
Nothing to do :)
On Mon, 8 Apr 2019 at 16:40, René Scholz
<re...@abakus-edv-systems.de> wrote:
>
> Hello,
>
> I try to share my desktop - specially only one program.
>
> I open with the Button on the right side the Popup, choose "Application",
> select the right window and "Start".
>
> What I have to do next to publish the window?
>
> Best regards,
>
> René
>
>
>
>
--
WBR
Maxim aka solomax
OM5 - Desktop-Sharing
Posted by René Scholz <re...@abakus-edv-systems.de>.
Hello,
I try to share my desktop - specially only one program.
I open with the Button on the right side the Popup, choose "Application",
select the right window and "Start".
What I have to do next to publish the window?
Best regards,
René
Re: Import backup
Posted by Maxim Solodovnik <so...@gmail.com>.
Hello Peter,
What do you mean by "But in 4.0.8 we get a few public recordings, that
are not there in the current installation (3.0.7)" ?
While importing recordings were moved to "Public recordings"?
On Mon, 8 Apr 2019 at 19:17, Peter Dähn <da...@vcrp.de> wrote:
>
> Hi Maxim,
>
> we are going to (finally) install om 4.0.8 next week. I made a few tests
> with backup/restore. This worked so far. But in 4.0.8 we get a few
> public recordings, that are not there in the current installation (3.0.7).
>
> I would like to simply unpublish this recordings. But I didn't find the
> way to do so.
>
> Any hints for me?
>
> Greetings Peter
>
--
WBR
Maxim aka solomax
Import backup
Posted by Peter Dähn <da...@vcrp.de>.
Hi Maxim,
we are going to (finally) install om 4.0.8 next week. I made a few tests
with backup/restore. This worked so far. But in 4.0.8 we get a few
public recordings, that are not there in the current installation (3.0.7).
I would like to simply unpublish this recordings. But I didn't find the
way to do so.
Any hints for me?
Greetings Peter
Import backup
Posted by Peter Dähn <da...@vcrp.de>.
Hi Maxim,
we are going to install om 4.0.8 next week (,finally). I made a few
tests with backup/restore. This worked so far. But in 4.0.8 we get a few
public recordings, that are not there in the current installation (3.0.7).
I would like to simply unpublish this recordings. But I didn't find the
way to do so.
Any hints for me?
Greetings Peter
Re: OM5: Latency Audio/Video
Posted by Maxim Solodovnik <so...@gmail.com>.
Hello René,
I'm afraid I need some more info on your HW config
Could you tell me how camera/microphone is connected to your client PC/laptop?
On Mon, 8 Apr 2019 at 16:43, René Scholz
<re...@abakus-edv-systems.de> wrote:
>
> Hello,
>
> it is possible that the reason for the delay is in my IP-Camera.
> The quality of the picture is much better than a webcam, but I am frightened
> that there is potential to make it better.
>
> I will buy a GoPro and try it out.
> Of course I will report and share my knowledge.
>
> Best regards,
>
> René
>
> Am 05.04.2019 um 09:44 schrieb Maxim Solodovnik:
> > So it is "audio/video not in sync?"
> > Do you have KMS in docker?
> > Is the behavior depends on user count? i.e. not reproducible on 3
> > participants, smaller audio delay on 5 participants?
> >
> > Is it reproducible on our demo server?
> >
> > On Fri, 5 Apr 2019 at 14:32, René Scholz
> > <re...@abakus-edv-systems.de> wrote:
> >> Hm, Google told me that the german word "Latenz" is not what I thought...
> >>
> >> I mean that the video is ~1 second later than the sound at the the
> >> remote participant.
> >>
> >> Best regards,
> >>
> >> René
> >>
> >>
> >>
> >>
> >> Am 05.04.2019 um 09:08 schrieb Maxim Solodovnik:
> >>> Hello René,
> >>>
> >>> what do you mean by "latency" ?
> >>> audio/video displayed 1-2 seconds later to the remote participants?
> >>> audio/video not in sync?
> >>>
> >>> What parameter name in 4.0.x you are referring to?
> >>>
> >>> On Fri, 5 Apr 2019 at 13:18, René Scholz
> >>> <re...@abakus-edv-systems.de> wrote:
> >>>> Hello,
> >>>>
> >>>> today I made a try with 10 peoples.
> >>>>
> >>>> I make a camera-video with myself and a USB-microphone. The latency
> >>>> between this are ~1-2 seconds.
> >>>> I mean that under Flash there were parameters to correct this.
> >>>> Is it possible to correct this under HTML5 too?
> >>>>
> >>>> Best regards,
> >>>>
> >>>> René
> >>>>
> >
>
--
WBR
Maxim aka solomax
Re: OM5: Latency Audio/Video
Posted by René Scholz <re...@abakus-edv-systems.de>.
Hello,
it is possible that the reason for the delay is in my IP-Camera.
The quality of the picture is much better than a webcam, but I am frightened
that there is potential to make it better.
I will buy a GoPro and try it out.
Of course I will report and share my knowledge.
Best regards,
René
Am 05.04.2019 um 09:44 schrieb Maxim Solodovnik:
> So it is "audio/video not in sync?"
> Do you have KMS in docker?
> Is the behavior depends on user count? i.e. not reproducible on 3
> participants, smaller audio delay on 5 participants?
>
> Is it reproducible on our demo server?
>
> On Fri, 5 Apr 2019 at 14:32, René Scholz
> <re...@abakus-edv-systems.de> wrote:
>> Hm, Google told me that the german word "Latenz" is not what I thought...
>>
>> I mean that the video is ~1 second later than the sound at the the
>> remote participant.
>>
>> Best regards,
>>
>> René
>>
>>
>>
>>
>> Am 05.04.2019 um 09:08 schrieb Maxim Solodovnik:
>>> Hello René,
>>>
>>> what do you mean by "latency" ?
>>> audio/video displayed 1-2 seconds later to the remote participants?
>>> audio/video not in sync?
>>>
>>> What parameter name in 4.0.x you are referring to?
>>>
>>> On Fri, 5 Apr 2019 at 13:18, René Scholz
>>> <re...@abakus-edv-systems.de> wrote:
>>>> Hello,
>>>>
>>>> today I made a try with 10 peoples.
>>>>
>>>> I make a camera-video with myself and a USB-microphone. The latency
>>>> between this are ~1-2 seconds.
>>>> I mean that under Flash there were parameters to correct this.
>>>> Is it possible to correct this under HTML5 too?
>>>>
>>>> Best regards,
>>>>
>>>> René
>>>>
>
Re: OM5: Latency Audio/Video
Posted by Maxim Solodovnik <so...@gmail.com>.
So it is "audio/video not in sync?"
Do you have KMS in docker?
Is the behavior depends on user count? i.e. not reproducible on 3
participants, smaller audio delay on 5 participants?
Is it reproducible on our demo server?
On Fri, 5 Apr 2019 at 14:32, René Scholz
<re...@abakus-edv-systems.de> wrote:
>
> Hm, Google told me that the german word "Latenz" is not what I thought...
>
> I mean that the video is ~1 second later than the sound at the the
> remote participant.
>
> Best regards,
>
> René
>
>
>
>
> Am 05.04.2019 um 09:08 schrieb Maxim Solodovnik:
> > Hello René,
> >
> > what do you mean by "latency" ?
> > audio/video displayed 1-2 seconds later to the remote participants?
> > audio/video not in sync?
> >
> > What parameter name in 4.0.x you are referring to?
> >
> > On Fri, 5 Apr 2019 at 13:18, René Scholz
> > <re...@abakus-edv-systems.de> wrote:
> >> Hello,
> >>
> >> today I made a try with 10 peoples.
> >>
> >> I make a camera-video with myself and a USB-microphone. The latency
> >> between this are ~1-2 seconds.
> >> I mean that under Flash there were parameters to correct this.
> >> Is it possible to correct this under HTML5 too?
> >>
> >> Best regards,
> >>
> >> René
> >>
> >
>
--
WBR
Maxim aka solomax
Re: OM5: Latency Audio/Video
Posted by René Scholz <re...@abakus-edv-systems.de>.
Hm, Google told me that the german word "Latenz" is not what I thought...
I mean that the video is ~1 second later than the sound at the the
remote participant.
Best regards,
René
Am 05.04.2019 um 09:08 schrieb Maxim Solodovnik:
> Hello René,
>
> what do you mean by "latency" ?
> audio/video displayed 1-2 seconds later to the remote participants?
> audio/video not in sync?
>
> What parameter name in 4.0.x you are referring to?
>
> On Fri, 5 Apr 2019 at 13:18, René Scholz
> <re...@abakus-edv-systems.de> wrote:
>> Hello,
>>
>> today I made a try with 10 peoples.
>>
>> I make a camera-video with myself and a USB-microphone. The latency
>> between this are ~1-2 seconds.
>> I mean that under Flash there were parameters to correct this.
>> Is it possible to correct this under HTML5 too?
>>
>> Best regards,
>>
>> René
>>
>
Re: OM5: Latency Audio/Video
Posted by Maxim Solodovnik <so...@gmail.com>.
Hello René,
what do you mean by "latency" ?
audio/video displayed 1-2 seconds later to the remote participants?
audio/video not in sync?
What parameter name in 4.0.x you are referring to?
On Fri, 5 Apr 2019 at 13:18, René Scholz
<re...@abakus-edv-systems.de> wrote:
>
> Hello,
>
> today I made a try with 10 peoples.
>
> I make a camera-video with myself and a USB-microphone. The latency
> between this are ~1-2 seconds.
> I mean that under Flash there were parameters to correct this.
> Is it possible to correct this under HTML5 too?
>
> Best regards,
>
> René
>
--
WBR
Maxim aka solomax
OM5: Latency Audio/Video
Posted by René Scholz <re...@abakus-edv-systems.de>.
Hello,
today I made a try with 10 peoples.
I make a camera-video with myself and a USB-microphone. The latency
between this are ~1-2 seconds.
I mean that under Flash there were parameters to correct this.
Is it possible to correct this under HTML5 too?
Best regards,
René
Re: Chat in a room with the new feature "usercount"
Posted by René Scholz <re...@abakus-edv-systems.de>.
Thank you.
After the hint with the Administration/Configuration it's good.
Best regards,
René
Am 04.04.2019 um 14:27 schrieb Maxim Solodovnik:
> You can completely disable global chat in "Admin -> Config"
> You can make chat moderated in Admin->Rooms
>
> Recording should work
> Upper right icon in the room
>
> On Thu, 4 Apr 2019 at 19:24, René Scholz
> <re...@abakus-edv-systems.de> wrote:
>> Hello,
>>
>> the new feature "usercount" works wonderful.
>>
>> In one of the last messages from Peter he notes the Chat.
>>
>> Is it possible, when the feature "Usercount" is enabled, then should be
>> only one chat-window
>> for the "normal-viewer" visible. (No Chat "all".)
>> When the viewer write something this message goes only to the moderator.
>>
>> BTW: I dont find the record-functionality in OM5. It's possible that I
>> overlook something?
>>
>> Best regards,
>>
>> René
>>
>>
>>
>
Re: Chat in a room with the new feature "usercount"
Posted by Maxim Solodovnik <so...@gmail.com>.
You can completely disable global chat in "Admin -> Config"
You can make chat moderated in Admin->Rooms
Recording should work
Upper right icon in the room
On Thu, 4 Apr 2019 at 19:24, René Scholz
<re...@abakus-edv-systems.de> wrote:
>
> Hello,
>
> the new feature "usercount" works wonderful.
>
> In one of the last messages from Peter he notes the Chat.
>
> Is it possible, when the feature "Usercount" is enabled, then should be
> only one chat-window
> for the "normal-viewer" visible. (No Chat "all".)
> When the viewer write something this message goes only to the moderator.
>
> BTW: I dont find the record-functionality in OM5. It's possible that I
> overlook something?
>
> Best regards,
>
> René
>
>
>
--
WBR
Maxim aka solomax
Chat in a room with the new feature "usercount"
Posted by René Scholz <re...@abakus-edv-systems.de>.
Hello,
the new feature "usercount" works wonderful.
In one of the last messages from Peter he notes the Chat.
Is it possible, when the feature "Usercount" is enabled, then should be
only one chat-window
for the "normal-viewer" visible. (No Chat "all".)
When the viewer write something this message goes only to the moderator.
BTW: I dont find the record-functionality in OM5. It's possible that I
overlook something?
Best regards,
René
Re: display email/name in userlist
Posted by Maxim Solodovnik <so...@gmail.com>.
Just have checked
you also can enter email as
4) firstname1 lastname1 <email1>
On Thu, 4 Apr 2019 at 17:26, Maxim Solodovnik <so...@gmail.com> wrote:
>
> Hello René,
>
> people usually not really like the idea of displaying email to everyone
>
> Since these users are invited by you, you can do the following
> 1) enter email as "Maxim Solodovnik" <my...@email.com> (as described in tooltip)
> 2) enter email as 'Maxim Solodovnik' <my...@email.com> (as described in tooltip)
> 3) enter email as my@email.com and let your invitees to choose how
> they would like to be named :)
>
> On Thu, 4 Apr 2019 at 17:04, René Scholz
> <re...@abakus-edv-systems.de> wrote:
> >
> > Hello,
> >
> > when I make a invitation with the Action-Menu to someone who is not a
> > registered-user
> > this person get a login with
> >
> > firstname = guest
> > lastname = guest
> > email - the correct email-address
> >
> > Today I make some tests with a few collegues and nobody put his real
> > name into this.
> > So I get displayed a list of login-user, but I can not identify.
> >
> > Is it possible to display the email instead of name? Or name and email?
> >
> > Best regards,
> >
> > René
> >
> >
>
>
> --
> WBR
> Maxim aka solomax
--
WBR
Maxim aka solomax
Re: display email/name in userlist
Posted by Maxim Solodovnik <so...@gmail.com>.
Hello René,
people usually not really like the idea of displaying email to everyone
Since these users are invited by you, you can do the following
1) enter email as "Maxim Solodovnik" <my...@email.com> (as described in tooltip)
2) enter email as 'Maxim Solodovnik' <my...@email.com> (as described in tooltip)
3) enter email as my@email.com and let your invitees to choose how
they would like to be named :)
On Thu, 4 Apr 2019 at 17:04, René Scholz
<re...@abakus-edv-systems.de> wrote:
>
> Hello,
>
> when I make a invitation with the Action-Menu to someone who is not a
> registered-user
> this person get a login with
>
> firstname = guest
> lastname = guest
> email - the correct email-address
>
> Today I make some tests with a few collegues and nobody put his real
> name into this.
> So I get displayed a list of login-user, but I can not identify.
>
> Is it possible to display the email instead of name? Or name and email?
>
> Best regards,
>
> René
>
>
--
WBR
Maxim aka solomax
Re: display email/name in userlist
Posted by Peter Dähn <da...@vcrp.de>.
Hi René,
I wouldn't suggest this in general, maybe someone doesn't want to expose
his/her e-mail...
Maybe it is better to ask the invited people to fill in the form with
first and last name correctly?
Greetings Peter
Am 04.04.19 um 12:04 schrieb René Scholz:
> Hello,
>
> when I make a invitation with the Action-Menu to someone who is not a
> registered-user
> this person get a login with
>
> firstname = guest
> lastname = guest
> email - the correct email-address
>
> Today I make some tests with a few collegues and nobody put his real
> name into this.
> So I get displayed a list of login-user, but I can not identify.
>
> Is it possible to display the email instead of name? Or name and email?
>
> Best regards,
>
> René
>
>
>
display email/name in userlist
Posted by René Scholz <re...@abakus-edv-systems.de>.
Hello,
when I make a invitation with the Action-Menu to someone who is not a
registered-user
this person get a login with
firstname = guest
lastname = guest
email - the correct email-address
Today I make some tests with a few collegues and nobody put his real
name into this.
So I get displayed a list of login-user, but I can not identify.
Is it possible to display the email instead of name? Or name and email?
Best regards,
René
Re: Could not connect to MariaDB
Posted by Maxim Solodovnik <so...@gmail.com>.
Thanks for reporting back and investigation
This make a lot of sense
On Thu, 4 Apr 2019 at 15:46, René Scholz
<re...@abakus-edv-systems.de> wrote:
>
> Hello Maxim,
>
> thank you for the indoctrination about the using of graphics in emails. I will do better next time.
>
> My Solution:
>
> The Parameter "serverTimezone" must in the first line of the Driver-command (where is separated by "&").
> It doesn't matter where you put it.
> When I put it into the comma-separated-part it's not functionally.
>
>
> Here's my line in the mysql-persistence.xml:
>
> value="DriverClassName=com.mysql.cj.jdbc.Driver
> , Url=jdbc:mysql://localhost:3306/openmeetings?autoReconnect=true&useUnicode=true&serverTimezone=Europe/Berlin&createDatabaseIfNotExist=true&characterEncoding=utf-8 &connectionCollation=utf8_general_ci&cachePrepStmts=true&cacheCallableStatements=true&cacheServerConfiguration=true&useLocalSessionState=true&elideSetAutoCommits=true&alwaysSendSetIsolation=false&enableQueryTimeouts=false&prepStmtCacheSize=3000&prepStmtCacheSqlLimit=1000&useSSL=false&nullNamePatternMatchesAll=true
> , maxTotal=100
> , maxIdle=100
> , minIdle=0
> , maxWaitMillis=10000
> , TestOnBorrow=true
> , poolPreparedStatements=true
> , Username=
> , Password=" />
>
>
> Best regards,
>
> René
>
>
>
>
> Am 03.04.2019 um 14:28 schrieb Maxim Solodovnik:
>
> 2 points:
> 1) no need to share screen-shot to share _text_ :)
> 2) when I wrote "Could you please check if persistense.xml have all necessary parameters" I mean:
> a) open file in your favorite editor
> b) check it's content
>
> If changes made by installer are "disappear", check:
> 1) if you have only one copy of OM on your VM
> 2) if you don't have some script rewriting persistense.xml
>
> Additionally after successful installation there should be DB tables, and these tables shouldn't be empty
>
> BTW are you using MariaDB or MySql?
>
> On Wed, 3 Apr 2019 at 18:51, R. Scholz <re...@abakus-edv-systems.de> wrote:
>>
>> No way.
>> At the installation-process it stuck.
>>
>>
>>
>> Am 03.04.2019 um 11:55 schrieb Maxim Solodovnik:
>>
>> Hello René,
>>
>> after successful installation your mysql_persistense.xml file should be copied to persistense.xml
>> Could you please check if persistense.xml have all necessary parameters?
>> 1) correct DB host/port/name
>> 2) correct DB credentials
>> 3) this additional time-zone parameter
>>
>> On Wed, 3 Apr 2019 at 16:28, R. Scholz <re...@abakus-edv-systems.de> wrote:
>>>
>>> Hm, since a few minutes the " The server time zone value 'CEST' "-error is back.
>>>
>>> I had change that after boot there is no GUI.
>>> sudo systemctl set-default multi-user.target
>>> and make a reboot.
>>>
>>> After that I get the installation-screen and on the scond screen with the Database-choice I get the error.
>>>
>>> A little bit frustrating.
>>>
>>> Best regards,
>>>
>>> René
>>>
>>>
>>> Am 03.04.2019 um 11:06 schrieb Maxim Solodovnik:
>>>
>>> Thanks for reporting back!
>>> great it works as expected :)
>>>
>>> On Wed, 3 Apr 2019 at 13:22, R. Scholz <re...@abakus-edv-systems.de> wrote:
>>>>
>>>> Hello Maxim,
>>>>
>>>> the result of "timedatectl":
>>>> Local time: Mi 2019-04-03 08:06:21 CEST
>>>> Universal time: Mi 2019-04-03 06:06:21 UTC
>>>> RTC time: Mi 2019-04-03 06:06:21
>>>> Time zone: Europe/Berlin (CEST, +0200)
>>>> System clock synchronized: no
>>>> systemd-timesyncd.service active: no
>>>> RTC in local TZ: no
>>>>
>>>> Now I put the parameter you wrote helpful in your last email and it seems to be functionally.
>>>>
>>>> Here is the fully parameter I actually use, if someone need it.
>>>>
>>>> <property name="openjpa.ConnectionProperties"
>>>> value="DriverClassName=com.mysql.cj.jdbc.Driver
>>>> , Url=jdbc:mysql://localhost:3306/openmeetings?autoReconnect=true&useUnicode=true&createDatabaseIfNotExist=true&characterEncoding=utf-8&connectionCollation=utf8_ge
>>>> , maxTotal=100
>>>> , maxIdle=100
>>>> , minIdle=0
>>>> , maxWaitMillis=10000
>>>> , TestOnBorrow=true
>>>> , poolPreparedStatements=true
>>>> , serverTimezone=Europe/Berlin
>>>> , Username=
>>>> , Password=" />
>>>>
>>>> I am a little bit amazed about one thing: To test the new OM5 I made a lot of times a new virtual machine with the same Ubuntu 18.04-Installation. I mean that the
>>>> the first times the OM-MySQL-Connection runs without problems. No modification necessary. Anytime the error Maxim describe occurs, and I dont know why.
>>>> Sure, I made something different, but I have no idea what it can be.
>>>>
>>>> OK, for the moment I am very happy, get a gulp from my fresh/hot coffee and look forward to test the newest modification Maxim implemented yesterday in a speed where I am very surprised.
>>>> Maxim: Very good work!
>>>>
>>>> Best regards,
>>>>
>>>> René
>>>>
>>>>
>>>> Am 03.04.2019 um 05:25 schrieb Maxim Solodovnik:
>>>>
>>>> Just have tried to change TZ on my test Ubuntu server to be CEST and:
>>>>
>>>> sudo timedatectl set-timezone CEST
>>>> Failed to set time zone: Invalid time zone 'CEST'
>>>>
>>>> What is the result of `timedatectl` command on your system?
>>>>
>>>>
>>>> On Wed, 3 Apr 2019 at 07:35, Maxim Solodovnik <so...@gmail.com> wrote:
>>>>>
>>>>> Hello René,
>>>>>
>>>>> I'll try to set up VM to test following steps (so here it is untested)
>>>>> 1) open ${OM_HOME}/webapps/openmeetings/WEB-INF/classes/META-INF/mysql_persistence.xml
>>>>> 2) find <property name="openjpa.ConnectionProperties"
>>>>> 3) add ", serverTimezone=Europe/Berlin" to the comma separated values
>>>>>
>>>>> run command line or web installer
>>>>>
>>>>> On Wed, 3 Apr 2019 at 02:16, R. Scholz
>>>>> <re...@abakus-edv-systems.de> wrote:
>>>>> >
>>>>> > Hello,
>>>>> >
>>>>> > I dont know where I have to write what TimeZone-Variable.
>>>>> > I think it is the "/opt/open500/webapps/openmeetings/WEB-INF/classes/META-INF/mysql_persistence.xml".
>>>>> >
>>>>> > But where I have to write what to eliminate the "The server time zone value 'CEST' is unrecognized or..."-error?
>>>>> >
>>>>> > Best regards,
>>>>> >
>>>>> > René
>>>>> >
>>>>> >
>>>>> >
>>>>> >
>>>>> > Am 02.04.2019 um 07:35 schrieb Maxim Solodovnik:
>>>>> >
>>>>> > Hello All,
>>>>> >
>>>>> > recently I got error report from Alvaro regarding DB connection issue while MariaDB us used
>>>>> > After some "email ping-pong" I got logs, relevant part of logs can be found here [1]
>>>>> >
>>>>> > The first, huge stack trace provides only general information: "Could not create connection to database server. Attempted reconnect 3 times. Giving up."
>>>>> > Nothing to work with
>>>>> >
>>>>> > BUT the second one states: "The server time zone value 'CEST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support."
>>>>> >
>>>>> > This one provides the root cause of the problem and possible solutions:
>>>>> > 1) change server TZ to be more specific i.e. Europe/Berlin (not CEST)
>>>>> > 2) edit persistense.xml file and add `serverTimezone` configuration property with TZ of MariaDb server
>>>>> >
>>>>> > Hope it can help
>>>>> >
>>>>> > [1]
>>>>> > java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
>>>>> > at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
>>>>> > at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
>>>>> > at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
>>>>> > at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
>>>>> > at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
>>>>> > at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:905)
>>>>> > at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:830)
>>>>> > at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455)
>>>>> > at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
>>>>> > at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
>>>>> > at java.sql.DriverManager.getConnection(DriverManager.java:664)
>>>>> > at java.sql.DriverManager.getConnection(DriverManager.java:247)
>>>>> > at org.apache.openmeetings.web.pages.install.InstallWizard$DbStep$1.onValidateModelObjects(InstallWizard.java:266)
>>>>> > at org.apache.wicket.markup.html.form.Form.internalOnValidateModelObjects(Form.java:1870)
>>>>> > at org.apache.wicket.markup.html.form.Form.process(Form.java:956)
>>>>> > at org.apache.wicket.markup.html.form.Form.onFormSubmitted(Form.java:788)
>>>>> > at org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:176)
>>>>> > at org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:127)
>>>>> > at org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:598)
>>>>> > at org.apache.wicket.core.request.handler.ListenerRequestHandler.internalInvoke(ListenerRequestHandler.java:306)
>>>>> > at org.apache.wicket.core.request.handler.ListenerRequestHandler.invoke(ListenerRequestHandler.java:280)
>>>>> > at org.apache.wicket.core.request.handler.ListenerRequestHandler.invokeListener(ListenerRequestHandler.java:222)
>>>>> > at org.apache.wicket.core.request.handler.ListenerRequestHandler.respond(ListenerRequestHandler.java:208)
>>>>> > at org.apache.wicket.request.cycle.RequestCycle$HandlerExecutor.respond(RequestCycle.java:914)
>>>>> > at org.apache.wicket.request.RequestHandlerExecutor.execute(RequestHandlerExecutor.java:65)
>>>>> > at org.apache.wicket.request.cycle.RequestCycle.execute(RequestCycle.java:282)
>>>>> > at org.apache.wicket.request.cycle.RequestCycle.processRequest(RequestCycle.java:253)
>>>>> > at org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(RequestCycle.java:221)
>>>>> > at org.apache.wicket.protocol.ws.AbstractUpgradeFilter.processRequestCycle(AbstractUpgradeFilter.java:70)
>>>>> > at org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:206)
>>>>> > at org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:299)
>>>>> > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
>>>>> > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
>>>>> > at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
>>>>> > at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
>>>>> > at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:607)
>>>>> > at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
>>>>> > at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
>>>>> > at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)
>>>>> > at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
>>>>> > at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
>>>>> > at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
>>>>> > at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
>>>>> > at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834)
>>>>> > at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415)
>>>>> > at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
>>>>> > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>>>>> > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>>>>> > at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
>>>>> > at java.lang.Thread.run(Thread.java:748)
>>>>> > Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'CEST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
>>>>> > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>>>>> > at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
>>>>> > at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
>>>>> > at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
>>>>> > at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
>>>>> > at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
>>>>> > at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132)
>>>>> > at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2241)
>>>>> > at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2265)
>>>>> > at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1319)
>>>>> > at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:868)
>>>>> > ... 44 common frames omitted
>>>>> >
>>>>> > --
>>>>> > WBR
>>>>> > Maxim aka solomax
>>>>> >
>>>>> >
>>>>>
>>>>>
>>>>> --
>>>>> WBR
>>>>> Maxim aka solomax
>>>>
>>>>
>>>>
>>>> --
>>>> WBR
>>>> Maxim aka solomax
>>>>
>>>>
>>>
>>>
>>> --
>>> WBR
>>> Maxim aka solomax
>>>
>>>
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>>
>
>
> --
> WBR
> Maxim aka solomax
>
>
--
WBR
Maxim aka solomax
Re: Could not connect to MariaDB
Posted by René Scholz <re...@abakus-edv-systems.de>.
Hello Maxim,
thank you for the indoctrination about the using of graphics in emails.
I will do better next time.
My Solution:
The Parameter "serverTimezone" must in the first line of the
Driver-command (where is separated by "&").
It doesn't matter where you put it.
When I put it into the comma-separated-part it's not functionally.
Here's my line in the mysql-persistence.xml:
value="DriverClassName=com.mysql.cj.jdbc.Driver
,
Url=jdbc:mysql://localhost:3306/openmeetings?autoReconnect=true&useUnicode=true&*serverTimezone=Europe/Berlin&*createDatabaseIfNotExist=true&characterEncoding=utf-8
&connectionCollation=utf8_general_ci&cachePrepStmts=true&cacheCallableStatements=true&cacheServerConfiguration=true&useLocalSessionState=true&elideSetAutoCommits=true&alwaysSendSetIsolation=false&enableQueryTimeouts=false&prepStmtCacheSize=3000&prepStmtCacheSqlLimit=1000&useSSL=false&nullNamePatternMatchesAll=true
, maxTotal=100
, maxIdle=100
, minIdle=0
, maxWaitMillis=10000
, TestOnBorrow=true
, poolPreparedStatements=true
, Username=
, Password=" />
Best regards,
René
Am 03.04.2019 um 14:28 schrieb Maxim Solodovnik:
> 2 points:
> 1) no need to share screen-shot to share _text_ :)
> 2) when I wrote "Could you please check if persistense.xml have all
> necessary parameters" I mean:
> a) open file in your favorite editor
> b) check it's content
>
> If changes made by installer are "disappear", check:
> 1) if you have only one copy of OM on your VM
> 2) if you don't have some script rewriting persistense.xml
>
> Additionally after successful installation there should be DB tables,
> and these tables shouldn't be empty
>
> BTW are you using MariaDB or MySql?
>
> On Wed, 3 Apr 2019 at 18:51, R. Scholz
> <rene.scholz@abakus-edv-systems.de
> <ma...@abakus-edv-systems.de>> wrote:
>
> No way.
> At the installation-process it stuck.
>
>
>
> Am 03.04.2019 um 11:55 schrieb Maxim Solodovnik:
>> Hello René,
>>
>> after successful installation your mysql_persistense.xml file
>> should be copied to persistense.xml
>> Could you please check if persistense.xml have all necessary
>> parameters?
>> 1) correct DB host/port/name
>> 2) correct DB credentials
>> 3) this additional time-zone parameter
>>
>> On Wed, 3 Apr 2019 at 16:28, R. Scholz
>> <rene.scholz@abakus-edv-systems.de
>> <ma...@abakus-edv-systems.de>> wrote:
>>
>> Hm, since a few minutes the " The server time zone value
>> 'CEST' "-error is back.
>>
>> I had change that after boot there is no GUI.
>> sudo systemctl set-default multi-user.target
>> and make a reboot.
>>
>> After that I get the installation-screen and on the scond
>> screen with the Database-choice I get the error.
>>
>> A little bit frustrating.
>>
>> Best regards,
>>
>> René
>>
>>
>> Am 03.04.2019 um 11:06 schrieb Maxim Solodovnik:
>>> Thanks for reporting back!
>>> great it works as expected :)
>>>
>>> On Wed, 3 Apr 2019 at 13:22, R. Scholz
>>> <rene.scholz@abakus-edv-systems.de
>>> <ma...@abakus-edv-systems.de>> wrote:
>>>
>>> Hello Maxim,
>>>
>>> the result of "timedatectl":
>>> Local time: Mi 2019-04-03 08:06:21
>>> CEST
>>> Universal time: Mi 2019-04-03 06:06:21 UTC
>>> RTC time: Mi 2019-04-03 06:06:21
>>> Time zone: Europe/Berlin (CEST,
>>> +0200)
>>> System clock synchronized: no
>>> systemd-timesyncd.service active: no
>>> RTC in local TZ: no
>>>
>>> Now I put the parameter you wrote helpful in your last
>>> email and it seems to be functionally.
>>>
>>> Here is the fully parameter I actually use, if someone
>>> need it.
>>>
>>> <property name="openjpa.ConnectionProperties"
>>> value="DriverClassName=com.mysql.cj.jdbc.Driver
>>> ,
>>> Url=jdbc:mysql://localhost:3306/openmeetings?autoReconnect=true&useUnicode=true&createDatabaseIfNotExist=true&characterEncoding=utf-8&connectionCollation=utf8_ge
>>> , maxTotal=100
>>> , maxIdle=100
>>> , minIdle=0
>>> , maxWaitMillis=10000
>>> , TestOnBorrow=true
>>> , poolPreparedStatements=true
>>> , serverTimezone=Europe/Berlin
>>> , Username=
>>> , Password=" />
>>>
>>> I am a little bit amazed about one thing: To test the
>>> new OM5 I made a lot of times a new virtual machine with
>>> the same Ubuntu 18.04-Installation. I mean that the
>>> the first times the OM-MySQL-Connection runs without
>>> problems. No modification necessary. Anytime the error
>>> Maxim describe occurs, and I dont know why.
>>> Sure, I made something different, but I have no idea
>>> what it can be.
>>>
>>> OK, for the moment I am very happy, get a gulp from my
>>> fresh/hot coffee and look forward to test the newest
>>> modification Maxim implemented yesterday in a speed
>>> where I am very surprised.
>>> Maxim: Very good work!
>>>
>>> Best regards,
>>>
>>> René
>>>
>>>
>>> Am 03.04.2019 um 05:25 schrieb Maxim Solodovnik:
>>>> Just have tried to change TZ on my test Ubuntu server
>>>> to be CEST and:
>>>>
>>>> *sudo timedatectl set-timezone CEST*
>>>> Failed to set time zone: Invalid time zone 'CEST'
>>>>
>>>> What is the result of `timedatectl` command on your system?
>>>>
>>>>
>>>> On Wed, 3 Apr 2019 at 07:35, Maxim Solodovnik
>>>> <solomax666@gmail.com <ma...@gmail.com>> wrote:
>>>>
>>>> Hello René,
>>>>
>>>> I'll try to set up VM to test following steps (so
>>>> here it is untested)
>>>> 1) open
>>>> ${OM_HOME}/webapps/openmeetings/WEB-INF/classes/META-INF/mysql_persistence.xml
>>>> 2) find <property name="openjpa.ConnectionProperties"
>>>> 3) add ", serverTimezone=Europe/Berlin" to the
>>>> comma separated values
>>>>
>>>> run command line or web installer
>>>>
>>>> On Wed, 3 Apr 2019 at 02:16, R. Scholz
>>>> <rene.scholz@abakus-edv-systems.de
>>>> <ma...@abakus-edv-systems.de>> wrote:
>>>> >
>>>> > Hello,
>>>> >
>>>> > I dont know where I have to write what
>>>> TimeZone-Variable.
>>>> > I think it is the
>>>> "/opt/open500/webapps/openmeetings/WEB-INF/classes/META-INF/mysql_persistence.xml".
>>>> >
>>>> > But where I have to write what to eliminate the
>>>> "The server time zone value 'CEST' is unrecognized
>>>> or..."-error?
>>>> >
>>>> > Best regards,
>>>> >
>>>> > René
>>>> >
>>>> >
>>>> >
>>>> >
>>>> > Am 02.04.2019 um 07:35 schrieb Maxim Solodovnik:
>>>> >
>>>> > Hello All,
>>>> >
>>>> > recently I got error report from Alvaro regarding
>>>> DB connection issue while MariaDB us used
>>>> > After some "email ping-pong" I got logs, relevant
>>>> part of logs can be found here [1]
>>>> >
>>>> > The first, huge stack trace provides only general
>>>> information: "Could not create connection to
>>>> database server. Attempted reconnect 3 times.
>>>> Giving up."
>>>> > Nothing to work with
>>>> >
>>>> > BUT the second one states: "The server time zone
>>>> value 'CEST' is unrecognized or represents more
>>>> than one time zone. You must configure either the
>>>> server or JDBC driver (via the serverTimezone
>>>> configuration property) to use a more specifc time
>>>> zone value if you want to utilize time zone support."
>>>> >
>>>> > This one provides the root cause of the problem
>>>> and possible solutions:
>>>> > 1) change server TZ to be more specific i.e.
>>>> Europe/Berlin (not CEST)
>>>> > 2) edit persistense.xml file and add
>>>> `serverTimezone` configuration property with TZ of
>>>> MariaDb server
>>>> >
>>>> > Hope it can help
>>>> >
>>>> > [1]
>>>> > java.sql.SQLNonTransientConnectionException:
>>>> Could not create connection to database server.
>>>> Attempted reconnect 3 times. Giving up.
>>>> > at
>>>> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
>>>> > at
>>>> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
>>>> > at
>>>> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
>>>> > at
>>>> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
>>>> > at
>>>> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
>>>> > at
>>>> com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:905)
>>>> > at
>>>> com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:830)
>>>> > at
>>>> com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455)
>>>> > at
>>>> com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
>>>> > at
>>>> com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
>>>> > at
>>>> java.sql.DriverManager.getConnection(DriverManager.java:664)
>>>> > at
>>>> java.sql.DriverManager.getConnection(DriverManager.java:247)
>>>> > at
>>>> org.apache.openmeetings.web.pages.install.InstallWizard$DbStep$1.onValidateModelObjects(InstallWizard.java:266)
>>>> > at
>>>> org.apache.wicket.markup.html.form.Form.internalOnValidateModelObjects(Form.java:1870)
>>>> > at
>>>> org.apache.wicket.markup.html.form.Form.process(Form.java:956)
>>>> > at
>>>> org.apache.wicket.markup.html.form.Form.onFormSubmitted(Form.java:788)
>>>> > at
>>>> org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:176)
>>>> > at
>>>> org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:127)
>>>> > at
>>>> org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:598)
>>>> > at
>>>> org.apache.wicket.core.request.handler.ListenerRequestHandler.internalInvoke(ListenerRequestHandler.java:306)
>>>> > at
>>>> org.apache.wicket.core.request.handler.ListenerRequestHandler.invoke(ListenerRequestHandler.java:280)
>>>> > at
>>>> org.apache.wicket.core.request.handler.ListenerRequestHandler.invokeListener(ListenerRequestHandler.java:222)
>>>> > at
>>>> org.apache.wicket.core.request.handler.ListenerRequestHandler.respond(ListenerRequestHandler.java:208)
>>>> > at
>>>> org.apache.wicket.request.cycle.RequestCycle$HandlerExecutor.respond(RequestCycle.java:914)
>>>> > at
>>>> org.apache.wicket.request.RequestHandlerExecutor.execute(RequestHandlerExecutor.java:65)
>>>> > at
>>>> org.apache.wicket.request.cycle.RequestCycle.execute(RequestCycle.java:282)
>>>> > at
>>>> org.apache.wicket.request.cycle.RequestCycle.processRequest(RequestCycle.java:253)
>>>> > at
>>>> org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(RequestCycle.java:221)
>>>> > at org.apache.wicket.protocol.ws
>>>> <http://org.apache.wicket.protocol.ws>.AbstractUpgradeFilter.processRequestCycle(AbstractUpgradeFilter.java:70)
>>>> > at
>>>> org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:206)
>>>> > at
>>>> org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:299)
>>>> > at
>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
>>>> > at
>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
>>>> > at
>>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
>>>> > at
>>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
>>>> > at
>>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:607)
>>>> > at
>>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
>>>> > at
>>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
>>>> > at
>>>> org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)
>>>> > at
>>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
>>>> > at
>>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
>>>> > at
>>>> org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
>>>> > at
>>>> org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
>>>> > at
>>>> org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834)
>>>> > at org.apache.tomcat.util.net
>>>> <http://org.apache.tomcat.util.net>.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415)
>>>> > at org.apache.tomcat.util.net
>>>> <http://org.apache.tomcat.util.net>.SocketProcessorBase.run(SocketProcessorBase.java:49)
>>>> > at
>>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>>>> > at
>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>>>> > at
>>>> org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
>>>> > at java.lang.Thread.run(Thread.java:748)
>>>> > Caused by:
>>>> com.mysql.cj.exceptions.InvalidConnectionAttributeException:
>>>> The server time zone value 'CEST' is unrecognized
>>>> or represents more than one time zone. You must
>>>> configure either the server or JDBC driver (via the
>>>> serverTimezone configuration property) to use a
>>>> more specifc time zone value if you want to utilize
>>>> time zone support.
>>>> > at
>>>> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
>>>> Method)
>>>> > at
>>>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
>>>> > at
>>>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
>>>> > at
>>>> java.lang.reflect.Constructor.newInstance(Constructor.java:423)
>>>> > at
>>>> com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
>>>> > at
>>>> com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
>>>> > at
>>>> com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132)
>>>> > at
>>>> com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2241)
>>>> > at
>>>> com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2265)
>>>> > at
>>>> com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1319)
>>>> > at
>>>> com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:868)
>>>> > ... 44 common frames omitted
>>>> >
>>>> > --
>>>> > WBR
>>>> > Maxim aka solomax
>>>> >
>>>> >
>>>>
>>>>
>>>> --
>>>> WBR
>>>> Maxim aka solomax
>>>>
>>>>
>>>>
>>>> --
>>>> WBR
>>>> Maxim aka solomax
>>>
>>>
>>>
>>> --
>>> WBR
>>> Maxim aka solomax
>>
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>
>
>
> --
> WBR
> Maxim aka solomax
Re: Could not connect to MariaDB
Posted by Maxim Solodovnik <so...@gmail.com>.
2 points:
1) no need to share screen-shot to share _text_ :)
2) when I wrote "Could you please check if persistense.xml have all
necessary parameters" I mean:
a) open file in your favorite editor
b) check it's content
If changes made by installer are "disappear", check:
1) if you have only one copy of OM on your VM
2) if you don't have some script rewriting persistense.xml
Additionally after successful installation there should be DB tables, and
these tables shouldn't be empty
BTW are you using MariaDB or MySql?
On Wed, 3 Apr 2019 at 18:51, R. Scholz <re...@abakus-edv-systems.de>
wrote:
> No way.
> At the installation-process it stuck.
>
>
>
> Am 03.04.2019 um 11:55 schrieb Maxim Solodovnik:
>
> Hello René,
>
> after successful installation your mysql_persistense.xml file should be
> copied to persistense.xml
> Could you please check if persistense.xml have all necessary parameters?
> 1) correct DB host/port/name
> 2) correct DB credentials
> 3) this additional time-zone parameter
>
> On Wed, 3 Apr 2019 at 16:28, R. Scholz <re...@abakus-edv-systems.de>
> wrote:
>
>> Hm, since a few minutes the " The server time zone value 'CEST' "-error
>> is back.
>>
>> I had change that after boot there is no GUI.
>> sudo systemctl set-default multi-user.target
>> and make a reboot.
>>
>> After that I get the installation-screen and on the scond screen with the
>> Database-choice I get the error.
>>
>> A little bit frustrating.
>>
>> Best regards,
>>
>> René
>>
>>
>> Am 03.04.2019 um 11:06 schrieb Maxim Solodovnik:
>>
>> Thanks for reporting back!
>> great it works as expected :)
>>
>> On Wed, 3 Apr 2019 at 13:22, R. Scholz <re...@abakus-edv-systems.de>
>> wrote:
>>
>>> Hello Maxim,
>>>
>>> the result of "timedatectl":
>>> Local time: Mi 2019-04-03 08:06:21 CEST
>>> Universal time: Mi 2019-04-03 06:06:21 UTC
>>> RTC time: Mi 2019-04-03 06:06:21
>>> Time zone: Europe/Berlin (CEST, +0200)
>>> System clock synchronized: no
>>> systemd-timesyncd.service active: no
>>> RTC in local TZ: no
>>>
>>> Now I put the parameter you wrote helpful in your last email and it
>>> seems to be functionally.
>>>
>>> Here is the fully parameter I actually use, if someone need it.
>>>
>>> <property name="openjpa.ConnectionProperties"
>>> value="DriverClassName=com.mysql.cj.jdbc.Driver
>>> ,
>>> Url=jdbc:mysql://localhost:3306/openmeetings?autoReconnect=true&useUnicode=true&createDatabaseIfNotExist=true&characterEncoding=utf-8&connectionCollation=utf8_ge
>>> , maxTotal=100
>>> , maxIdle=100
>>> , minIdle=0
>>> , maxWaitMillis=10000
>>> , TestOnBorrow=true
>>> , poolPreparedStatements=true
>>> , serverTimezone=Europe/Berlin
>>> , Username=
>>> , Password=" />
>>>
>>> I am a little bit amazed about one thing: To test the new OM5 I made a
>>> lot of times a new virtual machine with the same Ubuntu 18.04-Installation.
>>> I mean that the
>>> the first times the OM-MySQL-Connection runs without problems. No
>>> modification necessary. Anytime the error Maxim describe occurs, and I dont
>>> know why.
>>> Sure, I made something different, but I have no idea what it can be.
>>>
>>> OK, for the moment I am very happy, get a gulp from my fresh/hot coffee
>>> and look forward to test the newest modification Maxim implemented
>>> yesterday in a speed where I am very surprised.
>>> Maxim: Very good work!
>>>
>>> Best regards,
>>>
>>> René
>>>
>>>
>>> Am 03.04.2019 um 05:25 schrieb Maxim Solodovnik:
>>>
>>> Just have tried to change TZ on my test Ubuntu server to be CEST and:
>>>
>>> *sudo timedatectl set-timezone CEST*
>>> Failed to set time zone: Invalid time zone 'CEST'
>>>
>>> What is the result of `timedatectl` command on your system?
>>>
>>>
>>> On Wed, 3 Apr 2019 at 07:35, Maxim Solodovnik <so...@gmail.com>
>>> wrote:
>>>
>>>> Hello René,
>>>>
>>>> I'll try to set up VM to test following steps (so here it is untested)
>>>> 1) open
>>>> ${OM_HOME}/webapps/openmeetings/WEB-INF/classes/META-INF/mysql_persistence.xml
>>>> 2) find <property name="openjpa.ConnectionProperties"
>>>> 3) add ", serverTimezone=Europe/Berlin" to the comma separated values
>>>>
>>>> run command line or web installer
>>>>
>>>> On Wed, 3 Apr 2019 at 02:16, R. Scholz
>>>> <re...@abakus-edv-systems.de> wrote:
>>>> >
>>>> > Hello,
>>>> >
>>>> > I dont know where I have to write what TimeZone-Variable.
>>>> > I think it is the
>>>> "/opt/open500/webapps/openmeetings/WEB-INF/classes/META-INF/mysql_persistence.xml".
>>>> >
>>>> > But where I have to write what to eliminate the "The server time zone
>>>> value 'CEST' is unrecognized or..."-error?
>>>> >
>>>> > Best regards,
>>>> >
>>>> > René
>>>> >
>>>> >
>>>> >
>>>> >
>>>> > Am 02.04.2019 um 07:35 schrieb Maxim Solodovnik:
>>>> >
>>>> > Hello All,
>>>> >
>>>> > recently I got error report from Alvaro regarding DB connection issue
>>>> while MariaDB us used
>>>> > After some "email ping-pong" I got logs, relevant part of logs can be
>>>> found here [1]
>>>> >
>>>> > The first, huge stack trace provides only general information: "Could
>>>> not create connection to database server. Attempted reconnect 3 times.
>>>> Giving up."
>>>> > Nothing to work with
>>>> >
>>>> > BUT the second one states: "The server time zone value 'CEST' is
>>>> unrecognized or represents more than one time zone. You must configure
>>>> either the server or JDBC driver (via the serverTimezone configuration
>>>> property) to use a more specifc time zone value if you want to utilize time
>>>> zone support."
>>>> >
>>>> > This one provides the root cause of the problem and possible
>>>> solutions:
>>>> > 1) change server TZ to be more specific i.e. Europe/Berlin (not CEST)
>>>> > 2) edit persistense.xml file and add `serverTimezone` configuration
>>>> property with TZ of MariaDb server
>>>> >
>>>> > Hope it can help
>>>> >
>>>> > [1]
>>>> > java.sql.SQLNonTransientConnectionException: Could not create
>>>> connection to database server. Attempted reconnect 3 times. Giving up.
>>>> > at
>>>> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
>>>> > at
>>>> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
>>>> > at
>>>> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
>>>> > at
>>>> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
>>>> > at
>>>> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
>>>> > at
>>>> com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:905)
>>>> > at
>>>> com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:830)
>>>> > at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455)
>>>> > at
>>>> com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
>>>> > at
>>>> com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
>>>> > at java.sql.DriverManager.getConnection(DriverManager.java:664)
>>>> > at java.sql.DriverManager.getConnection(DriverManager.java:247)
>>>> > at
>>>> org.apache.openmeetings.web.pages.install.InstallWizard$DbStep$1.onValidateModelObjects(InstallWizard.java:266)
>>>> > at
>>>> org.apache.wicket.markup.html.form.Form.internalOnValidateModelObjects(Form.java:1870)
>>>> > at org.apache.wicket.markup.html.form.Form.process(Form.java:956)
>>>> > at
>>>> org.apache.wicket.markup.html.form.Form.onFormSubmitted(Form.java:788)
>>>> > at
>>>> org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:176)
>>>> > at
>>>> org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:127)
>>>> > at
>>>> org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:598)
>>>> > at
>>>> org.apache.wicket.core.request.handler.ListenerRequestHandler.internalInvoke(ListenerRequestHandler.java:306)
>>>> > at
>>>> org.apache.wicket.core.request.handler.ListenerRequestHandler.invoke(ListenerRequestHandler.java:280)
>>>> > at
>>>> org.apache.wicket.core.request.handler.ListenerRequestHandler.invokeListener(ListenerRequestHandler.java:222)
>>>> > at
>>>> org.apache.wicket.core.request.handler.ListenerRequestHandler.respond(ListenerRequestHandler.java:208)
>>>> > at
>>>> org.apache.wicket.request.cycle.RequestCycle$HandlerExecutor.respond(RequestCycle.java:914)
>>>> > at
>>>> org.apache.wicket.request.RequestHandlerExecutor.execute(RequestHandlerExecutor.java:65)
>>>> > at
>>>> org.apache.wicket.request.cycle.RequestCycle.execute(RequestCycle.java:282)
>>>> > at
>>>> org.apache.wicket.request.cycle.RequestCycle.processRequest(RequestCycle.java:253)
>>>> > at
>>>> org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(RequestCycle.java:221)
>>>> > at org.apache.wicket.protocol.ws
>>>> .AbstractUpgradeFilter.processRequestCycle(AbstractUpgradeFilter.java:70)
>>>> > at
>>>> org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:206)
>>>> > at
>>>> org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:299)
>>>> > at
>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
>>>> > at
>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
>>>> > at
>>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
>>>> > at
>>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
>>>> > at
>>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:607)
>>>> > at
>>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
>>>> > at
>>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
>>>> > at
>>>> org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)
>>>> > at
>>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
>>>> > at
>>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
>>>> > at
>>>> org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
>>>> > at
>>>> org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
>>>> > at
>>>> org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834)
>>>> > at org.apache.tomcat.util.net
>>>> .NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415)
>>>> > at org.apache.tomcat.util.net
>>>> .SocketProcessorBase.run(SocketProcessorBase.java:49)
>>>> > at
>>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>>>> > at
>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>>>> > at
>>>> org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
>>>> > at java.lang.Thread.run(Thread.java:748)
>>>> > Caused by:
>>>> com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server
>>>> time zone value 'CEST' is unrecognized or represents more than one time
>>>> zone. You must configure either the server or JDBC driver (via the
>>>> serverTimezone configuration property) to use a more specifc time zone
>>>> value if you want to utilize time zone support.
>>>> > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
>>>> Method)
>>>> > at
>>>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
>>>> > at
>>>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
>>>> > at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
>>>> > at
>>>> com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
>>>> > at
>>>> com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
>>>> > at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132)
>>>> > at
>>>> com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2241)
>>>> > at
>>>> com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2265)
>>>> > at
>>>> com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1319)
>>>> > at
>>>> com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:868)
>>>> > ... 44 common frames omitted
>>>> >
>>>> > --
>>>> > WBR
>>>> > Maxim aka solomax
>>>> >
>>>> >
>>>>
>>>>
>>>> --
>>>> WBR
>>>> Maxim aka solomax
>>>>
>>>
>>>
>>> --
>>> WBR
>>> Maxim aka solomax
>>>
>>>
>>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>>
>>
>
> --
> WBR
> Maxim aka solomax
>
>
>
--
WBR
Maxim aka solomax
Re: Could not connect to MariaDB
Posted by "R. Scholz" <re...@abakus-edv-systems.de>.
No way.
At the installation-process it stuck.
Am 03.04.2019 um 11:55 schrieb Maxim Solodovnik:
> Hello René,
>
> after successful installation your mysql_persistense.xml file should
> be copied to persistense.xml
> Could you please check if persistense.xml have all necessary parameters?
> 1) correct DB host/port/name
> 2) correct DB credentials
> 3) this additional time-zone parameter
>
> On Wed, 3 Apr 2019 at 16:28, R. Scholz
> <rene.scholz@abakus-edv-systems.de
> <ma...@abakus-edv-systems.de>> wrote:
>
> Hm, since a few minutes the " The server time zone value 'CEST'
> "-error is back.
>
> I had change that after boot there is no GUI.
> sudo systemctl set-default multi-user.target
> and make a reboot.
>
> After that I get the installation-screen and on the scond screen
> with the Database-choice I get the error.
>
> A little bit frustrating.
>
> Best regards,
>
> René
>
>
> Am 03.04.2019 um 11:06 schrieb Maxim Solodovnik:
>> Thanks for reporting back!
>> great it works as expected :)
>>
>> On Wed, 3 Apr 2019 at 13:22, R. Scholz
>> <rene.scholz@abakus-edv-systems.de
>> <ma...@abakus-edv-systems.de>> wrote:
>>
>> Hello Maxim,
>>
>> the result of "timedatectl":
>> Local time: Mi 2019-04-03 08:06:21 CEST
>> Universal time: Mi 2019-04-03 06:06:21 UTC
>> RTC time: Mi 2019-04-03 06:06:21
>> Time zone: Europe/Berlin (CEST, +0200)
>> System clock synchronized: no
>> systemd-timesyncd.service active: no
>> RTC in local TZ: no
>>
>> Now I put the parameter you wrote helpful in your last email
>> and it seems to be functionally.
>>
>> Here is the fully parameter I actually use, if someone need it.
>>
>> <property name="openjpa.ConnectionProperties"
>> value="DriverClassName=com.mysql.cj.jdbc.Driver
>> ,
>> Url=jdbc:mysql://localhost:3306/openmeetings?autoReconnect=true&useUnicode=true&createDatabaseIfNotExist=true&characterEncoding=utf-8&connectionCollation=utf8_ge
>> , maxTotal=100
>> , maxIdle=100
>> , minIdle=0
>> , maxWaitMillis=10000
>> , TestOnBorrow=true
>> , poolPreparedStatements=true
>> , serverTimezone=Europe/Berlin
>> , Username=
>> , Password=" />
>>
>> I am a little bit amazed about one thing: To test the new OM5
>> I made a lot of times a new virtual machine with the same
>> Ubuntu 18.04-Installation. I mean that the
>> the first times the OM-MySQL-Connection runs without
>> problems. No modification necessary. Anytime the error Maxim
>> describe occurs, and I dont know why.
>> Sure, I made something different, but I have no idea what it
>> can be.
>>
>> OK, for the moment I am very happy, get a gulp from my
>> fresh/hot coffee and look forward to test the newest
>> modification Maxim implemented yesterday in a speed where I
>> am very surprised.
>> Maxim: Very good work!
>>
>> Best regards,
>>
>> René
>>
>>
>> Am 03.04.2019 um 05:25 schrieb Maxim Solodovnik:
>>> Just have tried to change TZ on my test Ubuntu server to be
>>> CEST and:
>>>
>>> *sudo timedatectl set-timezone CEST*
>>> Failed to set time zone: Invalid time zone 'CEST'
>>>
>>> What is the result of `timedatectl` command on your system?
>>>
>>>
>>> On Wed, 3 Apr 2019 at 07:35, Maxim Solodovnik
>>> <solomax666@gmail.com <ma...@gmail.com>> wrote:
>>>
>>> Hello René,
>>>
>>> I'll try to set up VM to test following steps (so here
>>> it is untested)
>>> 1) open
>>> ${OM_HOME}/webapps/openmeetings/WEB-INF/classes/META-INF/mysql_persistence.xml
>>> 2) find <property name="openjpa.ConnectionProperties"
>>> 3) add ", serverTimezone=Europe/Berlin" to the comma
>>> separated values
>>>
>>> run command line or web installer
>>>
>>> On Wed, 3 Apr 2019 at 02:16, R. Scholz
>>> <rene.scholz@abakus-edv-systems.de
>>> <ma...@abakus-edv-systems.de>> wrote:
>>> >
>>> > Hello,
>>> >
>>> > I dont know where I have to write what TimeZone-Variable.
>>> > I think it is the
>>> "/opt/open500/webapps/openmeetings/WEB-INF/classes/META-INF/mysql_persistence.xml".
>>> >
>>> > But where I have to write what to eliminate the "The
>>> server time zone value 'CEST' is unrecognized or..."-error?
>>> >
>>> > Best regards,
>>> >
>>> > René
>>> >
>>> >
>>> >
>>> >
>>> > Am 02.04.2019 um 07:35 schrieb Maxim Solodovnik:
>>> >
>>> > Hello All,
>>> >
>>> > recently I got error report from Alvaro regarding DB
>>> connection issue while MariaDB us used
>>> > After some "email ping-pong" I got logs, relevant part
>>> of logs can be found here [1]
>>> >
>>> > The first, huge stack trace provides only general
>>> information: "Could not create connection to database
>>> server. Attempted reconnect 3 times. Giving up."
>>> > Nothing to work with
>>> >
>>> > BUT the second one states: "The server time zone value
>>> 'CEST' is unrecognized or represents more than one time
>>> zone. You must configure either the server or JDBC
>>> driver (via the serverTimezone configuration property)
>>> to use a more specifc time zone value if you want to
>>> utilize time zone support."
>>> >
>>> > This one provides the root cause of the problem and
>>> possible solutions:
>>> > 1) change server TZ to be more specific i.e.
>>> Europe/Berlin (not CEST)
>>> > 2) edit persistense.xml file and add `serverTimezone`
>>> configuration property with TZ of MariaDb server
>>> >
>>> > Hope it can help
>>> >
>>> > [1]
>>> > java.sql.SQLNonTransientConnectionException: Could not
>>> create connection to database server. Attempted
>>> reconnect 3 times. Giving up.
>>> > at
>>> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
>>> > at
>>> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
>>> > at
>>> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
>>> > at
>>> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
>>> > at
>>> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
>>> > at
>>> com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:905)
>>> > at
>>> com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:830)
>>> > at
>>> com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455)
>>> > at
>>> com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
>>> > at
>>> com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
>>> > at
>>> java.sql.DriverManager.getConnection(DriverManager.java:664)
>>> > at
>>> java.sql.DriverManager.getConnection(DriverManager.java:247)
>>> > at
>>> org.apache.openmeetings.web.pages.install.InstallWizard$DbStep$1.onValidateModelObjects(InstallWizard.java:266)
>>> > at
>>> org.apache.wicket.markup.html.form.Form.internalOnValidateModelObjects(Form.java:1870)
>>> > at
>>> org.apache.wicket.markup.html.form.Form.process(Form.java:956)
>>> > at
>>> org.apache.wicket.markup.html.form.Form.onFormSubmitted(Form.java:788)
>>> > at
>>> org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:176)
>>> > at
>>> org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:127)
>>> > at
>>> org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:598)
>>> > at
>>> org.apache.wicket.core.request.handler.ListenerRequestHandler.internalInvoke(ListenerRequestHandler.java:306)
>>> > at
>>> org.apache.wicket.core.request.handler.ListenerRequestHandler.invoke(ListenerRequestHandler.java:280)
>>> > at
>>> org.apache.wicket.core.request.handler.ListenerRequestHandler.invokeListener(ListenerRequestHandler.java:222)
>>> > at
>>> org.apache.wicket.core.request.handler.ListenerRequestHandler.respond(ListenerRequestHandler.java:208)
>>> > at
>>> org.apache.wicket.request.cycle.RequestCycle$HandlerExecutor.respond(RequestCycle.java:914)
>>> > at
>>> org.apache.wicket.request.RequestHandlerExecutor.execute(RequestHandlerExecutor.java:65)
>>> > at
>>> org.apache.wicket.request.cycle.RequestCycle.execute(RequestCycle.java:282)
>>> > at
>>> org.apache.wicket.request.cycle.RequestCycle.processRequest(RequestCycle.java:253)
>>> > at
>>> org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(RequestCycle.java:221)
>>> > at org.apache.wicket.protocol.ws
>>> <http://org.apache.wicket.protocol.ws>.AbstractUpgradeFilter.processRequestCycle(AbstractUpgradeFilter.java:70)
>>> > at
>>> org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:206)
>>> > at
>>> org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:299)
>>> > at
>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
>>> > at
>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
>>> > at
>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
>>> > at
>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
>>> > at
>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:607)
>>> > at
>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
>>> > at
>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
>>> > at
>>> org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)
>>> > at
>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
>>> > at
>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
>>> > at
>>> org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
>>> > at
>>> org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
>>> > at
>>> org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834)
>>> > at org.apache.tomcat.util.net
>>> <http://org.apache.tomcat.util.net>.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415)
>>> > at org.apache.tomcat.util.net
>>> <http://org.apache.tomcat.util.net>.SocketProcessorBase.run(SocketProcessorBase.java:49)
>>> > at
>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>>> > at
>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>>> > at
>>> org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
>>> > at java.lang.Thread.run(Thread.java:748)
>>> > Caused by:
>>> com.mysql.cj.exceptions.InvalidConnectionAttributeException:
>>> The server time zone value 'CEST' is unrecognized or
>>> represents more than one time zone. You must configure
>>> either the server or JDBC driver (via the serverTimezone
>>> configuration property) to use a more specifc time zone
>>> value if you want to utilize time zone support.
>>> > at
>>> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
>>> Method)
>>> > at
>>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
>>> > at
>>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
>>> > at
>>> java.lang.reflect.Constructor.newInstance(Constructor.java:423)
>>> > at
>>> com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
>>> > at
>>> com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
>>> > at
>>> com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132)
>>> > at
>>> com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2241)
>>> > at
>>> com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2265)
>>> > at
>>> com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1319)
>>> > at
>>> com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:868)
>>> > ... 44 common frames omitted
>>> >
>>> > --
>>> > WBR
>>> > Maxim aka solomax
>>> >
>>> >
>>>
>>>
>>> --
>>> WBR
>>> Maxim aka solomax
>>>
>>>
>>>
>>> --
>>> WBR
>>> Maxim aka solomax
>>
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>
>
>
> --
> WBR
> Maxim aka solomax
Re: Could not connect to MariaDB
Posted by Maxim Solodovnik <so...@gmail.com>.
Hello René,
after successful installation your mysql_persistense.xml file should be
copied to persistense.xml
Could you please check if persistense.xml have all necessary parameters?
1) correct DB host/port/name
2) correct DB credentials
3) this additional time-zone parameter
On Wed, 3 Apr 2019 at 16:28, R. Scholz <re...@abakus-edv-systems.de>
wrote:
> Hm, since a few minutes the " The server time zone value 'CEST' "-error is
> back.
>
> I had change that after boot there is no GUI.
> sudo systemctl set-default multi-user.target
> and make a reboot.
>
> After that I get the installation-screen and on the scond screen with the
> Database-choice I get the error.
>
> A little bit frustrating.
>
> Best regards,
>
> René
>
>
> Am 03.04.2019 um 11:06 schrieb Maxim Solodovnik:
>
> Thanks for reporting back!
> great it works as expected :)
>
> On Wed, 3 Apr 2019 at 13:22, R. Scholz <re...@abakus-edv-systems.de>
> wrote:
>
>> Hello Maxim,
>>
>> the result of "timedatectl":
>> Local time: Mi 2019-04-03 08:06:21 CEST
>> Universal time: Mi 2019-04-03 06:06:21 UTC
>> RTC time: Mi 2019-04-03 06:06:21
>> Time zone: Europe/Berlin (CEST, +0200)
>> System clock synchronized: no
>> systemd-timesyncd.service active: no
>> RTC in local TZ: no
>>
>> Now I put the parameter you wrote helpful in your last email and it seems
>> to be functionally.
>>
>> Here is the fully parameter I actually use, if someone need it.
>>
>> <property name="openjpa.ConnectionProperties"
>> value="DriverClassName=com.mysql.cj.jdbc.Driver
>> ,
>> Url=jdbc:mysql://localhost:3306/openmeetings?autoReconnect=true&useUnicode=true&createDatabaseIfNotExist=true&characterEncoding=utf-8&connectionCollation=utf8_ge
>> , maxTotal=100
>> , maxIdle=100
>> , minIdle=0
>> , maxWaitMillis=10000
>> , TestOnBorrow=true
>> , poolPreparedStatements=true
>> , serverTimezone=Europe/Berlin
>> , Username=
>> , Password=" />
>>
>> I am a little bit amazed about one thing: To test the new OM5 I made a
>> lot of times a new virtual machine with the same Ubuntu 18.04-Installation.
>> I mean that the
>> the first times the OM-MySQL-Connection runs without problems. No
>> modification necessary. Anytime the error Maxim describe occurs, and I dont
>> know why.
>> Sure, I made something different, but I have no idea what it can be.
>>
>> OK, for the moment I am very happy, get a gulp from my fresh/hot coffee
>> and look forward to test the newest modification Maxim implemented
>> yesterday in a speed where I am very surprised.
>> Maxim: Very good work!
>>
>> Best regards,
>>
>> René
>>
>>
>> Am 03.04.2019 um 05:25 schrieb Maxim Solodovnik:
>>
>> Just have tried to change TZ on my test Ubuntu server to be CEST and:
>>
>> *sudo timedatectl set-timezone CEST*
>> Failed to set time zone: Invalid time zone 'CEST'
>>
>> What is the result of `timedatectl` command on your system?
>>
>>
>> On Wed, 3 Apr 2019 at 07:35, Maxim Solodovnik <so...@gmail.com>
>> wrote:
>>
>>> Hello René,
>>>
>>> I'll try to set up VM to test following steps (so here it is untested)
>>> 1) open
>>> ${OM_HOME}/webapps/openmeetings/WEB-INF/classes/META-INF/mysql_persistence.xml
>>> 2) find <property name="openjpa.ConnectionProperties"
>>> 3) add ", serverTimezone=Europe/Berlin" to the comma separated values
>>>
>>> run command line or web installer
>>>
>>> On Wed, 3 Apr 2019 at 02:16, R. Scholz
>>> <re...@abakus-edv-systems.de> wrote:
>>> >
>>> > Hello,
>>> >
>>> > I dont know where I have to write what TimeZone-Variable.
>>> > I think it is the
>>> "/opt/open500/webapps/openmeetings/WEB-INF/classes/META-INF/mysql_persistence.xml".
>>> >
>>> > But where I have to write what to eliminate the "The server time zone
>>> value 'CEST' is unrecognized or..."-error?
>>> >
>>> > Best regards,
>>> >
>>> > René
>>> >
>>> >
>>> >
>>> >
>>> > Am 02.04.2019 um 07:35 schrieb Maxim Solodovnik:
>>> >
>>> > Hello All,
>>> >
>>> > recently I got error report from Alvaro regarding DB connection issue
>>> while MariaDB us used
>>> > After some "email ping-pong" I got logs, relevant part of logs can be
>>> found here [1]
>>> >
>>> > The first, huge stack trace provides only general information: "Could
>>> not create connection to database server. Attempted reconnect 3 times.
>>> Giving up."
>>> > Nothing to work with
>>> >
>>> > BUT the second one states: "The server time zone value 'CEST' is
>>> unrecognized or represents more than one time zone. You must configure
>>> either the server or JDBC driver (via the serverTimezone configuration
>>> property) to use a more specifc time zone value if you want to utilize time
>>> zone support."
>>> >
>>> > This one provides the root cause of the problem and possible solutions:
>>> > 1) change server TZ to be more specific i.e. Europe/Berlin (not CEST)
>>> > 2) edit persistense.xml file and add `serverTimezone` configuration
>>> property with TZ of MariaDb server
>>> >
>>> > Hope it can help
>>> >
>>> > [1]
>>> > java.sql.SQLNonTransientConnectionException: Could not create
>>> connection to database server. Attempted reconnect 3 times. Giving up.
>>> > at
>>> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
>>> > at
>>> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
>>> > at
>>> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
>>> > at
>>> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
>>> > at
>>> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
>>> > at
>>> com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:905)
>>> > at
>>> com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:830)
>>> > at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455)
>>> > at
>>> com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
>>> > at
>>> com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
>>> > at java.sql.DriverManager.getConnection(DriverManager.java:664)
>>> > at java.sql.DriverManager.getConnection(DriverManager.java:247)
>>> > at
>>> org.apache.openmeetings.web.pages.install.InstallWizard$DbStep$1.onValidateModelObjects(InstallWizard.java:266)
>>> > at
>>> org.apache.wicket.markup.html.form.Form.internalOnValidateModelObjects(Form.java:1870)
>>> > at org.apache.wicket.markup.html.form.Form.process(Form.java:956)
>>> > at
>>> org.apache.wicket.markup.html.form.Form.onFormSubmitted(Form.java:788)
>>> > at
>>> org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:176)
>>> > at
>>> org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:127)
>>> > at
>>> org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:598)
>>> > at
>>> org.apache.wicket.core.request.handler.ListenerRequestHandler.internalInvoke(ListenerRequestHandler.java:306)
>>> > at
>>> org.apache.wicket.core.request.handler.ListenerRequestHandler.invoke(ListenerRequestHandler.java:280)
>>> > at
>>> org.apache.wicket.core.request.handler.ListenerRequestHandler.invokeListener(ListenerRequestHandler.java:222)
>>> > at
>>> org.apache.wicket.core.request.handler.ListenerRequestHandler.respond(ListenerRequestHandler.java:208)
>>> > at
>>> org.apache.wicket.request.cycle.RequestCycle$HandlerExecutor.respond(RequestCycle.java:914)
>>> > at
>>> org.apache.wicket.request.RequestHandlerExecutor.execute(RequestHandlerExecutor.java:65)
>>> > at
>>> org.apache.wicket.request.cycle.RequestCycle.execute(RequestCycle.java:282)
>>> > at
>>> org.apache.wicket.request.cycle.RequestCycle.processRequest(RequestCycle.java:253)
>>> > at
>>> org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(RequestCycle.java:221)
>>> > at org.apache.wicket.protocol.ws
>>> .AbstractUpgradeFilter.processRequestCycle(AbstractUpgradeFilter.java:70)
>>> > at
>>> org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:206)
>>> > at
>>> org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:299)
>>> > at
>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
>>> > at
>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
>>> > at
>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
>>> > at
>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
>>> > at
>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:607)
>>> > at
>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
>>> > at
>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
>>> > at
>>> org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)
>>> > at
>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
>>> > at
>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
>>> > at
>>> org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
>>> > at
>>> org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
>>> > at
>>> org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834)
>>> > at org.apache.tomcat.util.net
>>> .NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415)
>>> > at org.apache.tomcat.util.net
>>> .SocketProcessorBase.run(SocketProcessorBase.java:49)
>>> > at
>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>>> > at
>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>>> > at
>>> org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
>>> > at java.lang.Thread.run(Thread.java:748)
>>> > Caused by:
>>> com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server
>>> time zone value 'CEST' is unrecognized or represents more than one time
>>> zone. You must configure either the server or JDBC driver (via the
>>> serverTimezone configuration property) to use a more specifc time zone
>>> value if you want to utilize time zone support.
>>> > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
>>> Method)
>>> > at
>>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
>>> > at
>>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
>>> > at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
>>> > at
>>> com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
>>> > at
>>> com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
>>> > at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132)
>>> > at
>>> com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2241)
>>> > at
>>> com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2265)
>>> > at
>>> com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1319)
>>> > at
>>> com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:868)
>>> > ... 44 common frames omitted
>>> >
>>> > --
>>> > WBR
>>> > Maxim aka solomax
>>> >
>>> >
>>>
>>>
>>> --
>>> WBR
>>> Maxim aka solomax
>>>
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>>
>>
>
> --
> WBR
> Maxim aka solomax
>
>
>
--
WBR
Maxim aka solomax
Re: Could not connect to MariaDB
Posted by "R. Scholz" <re...@abakus-edv-systems.de>.
Hm, since a few minutes the " The server time zone value 'CEST' "-error
is back.
I had change that after boot there is no GUI.
sudo systemctl set-default multi-user.target
and make a reboot.
After that I get the installation-screen and on the scond screen with
the Database-choice I get the error.
A little bit frustrating.
Best regards,
René
Am 03.04.2019 um 11:06 schrieb Maxim Solodovnik:
> Thanks for reporting back!
> great it works as expected :)
>
> On Wed, 3 Apr 2019 at 13:22, R. Scholz
> <rene.scholz@abakus-edv-systems.de
> <ma...@abakus-edv-systems.de>> wrote:
>
> Hello Maxim,
>
> the result of "timedatectl":
> Local time: Mi 2019-04-03 08:06:21 CEST
> Universal time: Mi 2019-04-03 06:06:21 UTC
> RTC time: Mi 2019-04-03 06:06:21
> Time zone: Europe/Berlin (CEST, +0200)
> System clock synchronized: no
> systemd-timesyncd.service active: no
> RTC in local TZ: no
>
> Now I put the parameter you wrote helpful in your last email and
> it seems to be functionally.
>
> Here is the fully parameter I actually use, if someone need it.
>
> <property name="openjpa.ConnectionProperties"
> value="DriverClassName=com.mysql.cj.jdbc.Driver
> ,
> Url=jdbc:mysql://localhost:3306/openmeetings?autoReconnect=true&useUnicode=true&createDatabaseIfNotExist=true&characterEncoding=utf-8&connectionCollation=utf8_ge
> , maxTotal=100
> , maxIdle=100
> , minIdle=0
> , maxWaitMillis=10000
> , TestOnBorrow=true
> , poolPreparedStatements=true
> , serverTimezone=Europe/Berlin
> , Username=
> , Password=" />
>
> I am a little bit amazed about one thing: To test the new OM5 I
> made a lot of times a new virtual machine with the same Ubuntu
> 18.04-Installation. I mean that the
> the first times the OM-MySQL-Connection runs without problems. No
> modification necessary. Anytime the error Maxim describe occurs,
> and I dont know why.
> Sure, I made something different, but I have no idea what it can be.
>
> OK, for the moment I am very happy, get a gulp from my fresh/hot
> coffee and look forward to test the newest modification Maxim
> implemented yesterday in a speed where I am very surprised.
> Maxim: Very good work!
>
> Best regards,
>
> René
>
>
> Am 03.04.2019 um 05:25 schrieb Maxim Solodovnik:
>> Just have tried to change TZ on my test Ubuntu server to be CEST and:
>>
>> *sudo timedatectl set-timezone CEST*
>> Failed to set time zone: Invalid time zone 'CEST'
>>
>> What is the result of `timedatectl` command on your system?
>>
>>
>> On Wed, 3 Apr 2019 at 07:35, Maxim Solodovnik
>> <solomax666@gmail.com <ma...@gmail.com>> wrote:
>>
>> Hello René,
>>
>> I'll try to set up VM to test following steps (so here it is
>> untested)
>> 1) open
>> ${OM_HOME}/webapps/openmeetings/WEB-INF/classes/META-INF/mysql_persistence.xml
>> 2) find <property name="openjpa.ConnectionProperties"
>> 3) add ", serverTimezone=Europe/Berlin" to the comma
>> separated values
>>
>> run command line or web installer
>>
>> On Wed, 3 Apr 2019 at 02:16, R. Scholz
>> <rene.scholz@abakus-edv-systems.de
>> <ma...@abakus-edv-systems.de>> wrote:
>> >
>> > Hello,
>> >
>> > I dont know where I have to write what TimeZone-Variable.
>> > I think it is the
>> "/opt/open500/webapps/openmeetings/WEB-INF/classes/META-INF/mysql_persistence.xml".
>> >
>> > But where I have to write what to eliminate the "The server
>> time zone value 'CEST' is unrecognized or..."-error?
>> >
>> > Best regards,
>> >
>> > René
>> >
>> >
>> >
>> >
>> > Am 02.04.2019 um 07:35 schrieb Maxim Solodovnik:
>> >
>> > Hello All,
>> >
>> > recently I got error report from Alvaro regarding DB
>> connection issue while MariaDB us used
>> > After some "email ping-pong" I got logs, relevant part of
>> logs can be found here [1]
>> >
>> > The first, huge stack trace provides only general
>> information: "Could not create connection to database server.
>> Attempted reconnect 3 times. Giving up."
>> > Nothing to work with
>> >
>> > BUT the second one states: "The server time zone value
>> 'CEST' is unrecognized or represents more than one time zone.
>> You must configure either the server or JDBC driver (via the
>> serverTimezone configuration property) to use a more specifc
>> time zone value if you want to utilize time zone support."
>> >
>> > This one provides the root cause of the problem and
>> possible solutions:
>> > 1) change server TZ to be more specific i.e. Europe/Berlin
>> (not CEST)
>> > 2) edit persistense.xml file and add `serverTimezone`
>> configuration property with TZ of MariaDb server
>> >
>> > Hope it can help
>> >
>> > [1]
>> > java.sql.SQLNonTransientConnectionException: Could not
>> create connection to database server. Attempted reconnect 3
>> times. Giving up.
>> > at
>> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
>> > at
>> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
>> > at
>> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
>> > at
>> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
>> > at
>> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
>> > at
>> com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:905)
>> > at
>> com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:830)
>> > at
>> com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455)
>> > at
>> com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
>> > at
>> com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
>> > at java.sql.DriverManager.getConnection(DriverManager.java:664)
>> > at java.sql.DriverManager.getConnection(DriverManager.java:247)
>> > at
>> org.apache.openmeetings.web.pages.install.InstallWizard$DbStep$1.onValidateModelObjects(InstallWizard.java:266)
>> > at
>> org.apache.wicket.markup.html.form.Form.internalOnValidateModelObjects(Form.java:1870)
>> > at
>> org.apache.wicket.markup.html.form.Form.process(Form.java:956)
>> > at
>> org.apache.wicket.markup.html.form.Form.onFormSubmitted(Form.java:788)
>> > at
>> org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:176)
>> > at
>> org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:127)
>> > at
>> org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:598)
>> > at
>> org.apache.wicket.core.request.handler.ListenerRequestHandler.internalInvoke(ListenerRequestHandler.java:306)
>> > at
>> org.apache.wicket.core.request.handler.ListenerRequestHandler.invoke(ListenerRequestHandler.java:280)
>> > at
>> org.apache.wicket.core.request.handler.ListenerRequestHandler.invokeListener(ListenerRequestHandler.java:222)
>> > at
>> org.apache.wicket.core.request.handler.ListenerRequestHandler.respond(ListenerRequestHandler.java:208)
>> > at
>> org.apache.wicket.request.cycle.RequestCycle$HandlerExecutor.respond(RequestCycle.java:914)
>> > at
>> org.apache.wicket.request.RequestHandlerExecutor.execute(RequestHandlerExecutor.java:65)
>> > at
>> org.apache.wicket.request.cycle.RequestCycle.execute(RequestCycle.java:282)
>> > at
>> org.apache.wicket.request.cycle.RequestCycle.processRequest(RequestCycle.java:253)
>> > at
>> org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(RequestCycle.java:221)
>> > at org.apache.wicket.protocol.ws
>> <http://org.apache.wicket.protocol.ws>.AbstractUpgradeFilter.processRequestCycle(AbstractUpgradeFilter.java:70)
>> > at
>> org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:206)
>> > at
>> org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:299)
>> > at
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
>> > at
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
>> > at
>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
>> > at
>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
>> > at
>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:607)
>> > at
>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
>> > at
>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
>> > at
>> org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)
>> > at
>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
>> > at
>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
>> > at
>> org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
>> > at
>> org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
>> > at
>> org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834)
>> > at org.apache.tomcat.util.net
>> <http://org.apache.tomcat.util.net>.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415)
>> > at org.apache.tomcat.util.net
>> <http://org.apache.tomcat.util.net>.SocketProcessorBase.run(SocketProcessorBase.java:49)
>> > at
>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>> > at
>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>> > at
>> org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
>> > at java.lang.Thread.run(Thread.java:748)
>> > Caused by:
>> com.mysql.cj.exceptions.InvalidConnectionAttributeException:
>> The server time zone value 'CEST' is unrecognized or
>> represents more than one time zone. You must configure either
>> the server or JDBC driver (via the serverTimezone
>> configuration property) to use a more specifc time zone value
>> if you want to utilize time zone support.
>> > at
>> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
>> Method)
>> > at
>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
>> > at
>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
>> > at
>> java.lang.reflect.Constructor.newInstance(Constructor.java:423)
>> > at
>> com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
>> > at
>> com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
>> > at
>> com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132)
>> > at
>> com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2241)
>> > at
>> com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2265)
>> > at
>> com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1319)
>> > at
>> com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:868)
>> > ... 44 common frames omitted
>> >
>> > --
>> > WBR
>> > Maxim aka solomax
>> >
>> >
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>
>
>
> --
> WBR
> Maxim aka solomax
Re: Could not connect to MariaDB
Posted by Maxim Solodovnik <so...@gmail.com>.
Thanks for reporting back!
great it works as expected :)
On Wed, 3 Apr 2019 at 13:22, R. Scholz <re...@abakus-edv-systems.de>
wrote:
> Hello Maxim,
>
> the result of "timedatectl":
> Local time: Mi 2019-04-03 08:06:21 CEST
> Universal time: Mi 2019-04-03 06:06:21 UTC
> RTC time: Mi 2019-04-03 06:06:21
> Time zone: Europe/Berlin (CEST, +0200)
> System clock synchronized: no
> systemd-timesyncd.service active: no
> RTC in local TZ: no
>
> Now I put the parameter you wrote helpful in your last email and it seems
> to be functionally.
>
> Here is the fully parameter I actually use, if someone need it.
>
> <property name="openjpa.ConnectionProperties"
> value="DriverClassName=com.mysql.cj.jdbc.Driver
> ,
> Url=jdbc:mysql://localhost:3306/openmeetings?autoReconnect=true&useUnicode=true&createDatabaseIfNotExist=true&characterEncoding=utf-8&connectionCollation=utf8_ge
> , maxTotal=100
> , maxIdle=100
> , minIdle=0
> , maxWaitMillis=10000
> , TestOnBorrow=true
> , poolPreparedStatements=true
> , serverTimezone=Europe/Berlin
> , Username=
> , Password=" />
>
> I am a little bit amazed about one thing: To test the new OM5 I made a lot
> of times a new virtual machine with the same Ubuntu 18.04-Installation. I
> mean that the
> the first times the OM-MySQL-Connection runs without problems. No
> modification necessary. Anytime the error Maxim describe occurs, and I dont
> know why.
> Sure, I made something different, but I have no idea what it can be.
>
> OK, for the moment I am very happy, get a gulp from my fresh/hot coffee
> and look forward to test the newest modification Maxim implemented
> yesterday in a speed where I am very surprised.
> Maxim: Very good work!
>
> Best regards,
>
> René
>
>
> Am 03.04.2019 um 05:25 schrieb Maxim Solodovnik:
>
> Just have tried to change TZ on my test Ubuntu server to be CEST and:
>
> *sudo timedatectl set-timezone CEST*
> Failed to set time zone: Invalid time zone 'CEST'
>
> What is the result of `timedatectl` command on your system?
>
>
> On Wed, 3 Apr 2019 at 07:35, Maxim Solodovnik <so...@gmail.com>
> wrote:
>
>> Hello René,
>>
>> I'll try to set up VM to test following steps (so here it is untested)
>> 1) open
>> ${OM_HOME}/webapps/openmeetings/WEB-INF/classes/META-INF/mysql_persistence.xml
>> 2) find <property name="openjpa.ConnectionProperties"
>> 3) add ", serverTimezone=Europe/Berlin" to the comma separated values
>>
>> run command line or web installer
>>
>> On Wed, 3 Apr 2019 at 02:16, R. Scholz
>> <re...@abakus-edv-systems.de> wrote:
>> >
>> > Hello,
>> >
>> > I dont know where I have to write what TimeZone-Variable.
>> > I think it is the
>> "/opt/open500/webapps/openmeetings/WEB-INF/classes/META-INF/mysql_persistence.xml".
>> >
>> > But where I have to write what to eliminate the "The server time zone
>> value 'CEST' is unrecognized or..."-error?
>> >
>> > Best regards,
>> >
>> > René
>> >
>> >
>> >
>> >
>> > Am 02.04.2019 um 07:35 schrieb Maxim Solodovnik:
>> >
>> > Hello All,
>> >
>> > recently I got error report from Alvaro regarding DB connection issue
>> while MariaDB us used
>> > After some "email ping-pong" I got logs, relevant part of logs can be
>> found here [1]
>> >
>> > The first, huge stack trace provides only general information: "Could
>> not create connection to database server. Attempted reconnect 3 times.
>> Giving up."
>> > Nothing to work with
>> >
>> > BUT the second one states: "The server time zone value 'CEST' is
>> unrecognized or represents more than one time zone. You must configure
>> either the server or JDBC driver (via the serverTimezone configuration
>> property) to use a more specifc time zone value if you want to utilize time
>> zone support."
>> >
>> > This one provides the root cause of the problem and possible solutions:
>> > 1) change server TZ to be more specific i.e. Europe/Berlin (not CEST)
>> > 2) edit persistense.xml file and add `serverTimezone` configuration
>> property with TZ of MariaDb server
>> >
>> > Hope it can help
>> >
>> > [1]
>> > java.sql.SQLNonTransientConnectionException: Could not create
>> connection to database server. Attempted reconnect 3 times. Giving up.
>> > at
>> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
>> > at
>> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
>> > at
>> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
>> > at
>> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
>> > at
>> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
>> > at
>> com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:905)
>> > at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:830)
>> > at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455)
>> > at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
>> > at
>> com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
>> > at java.sql.DriverManager.getConnection(DriverManager.java:664)
>> > at java.sql.DriverManager.getConnection(DriverManager.java:247)
>> > at
>> org.apache.openmeetings.web.pages.install.InstallWizard$DbStep$1.onValidateModelObjects(InstallWizard.java:266)
>> > at
>> org.apache.wicket.markup.html.form.Form.internalOnValidateModelObjects(Form.java:1870)
>> > at org.apache.wicket.markup.html.form.Form.process(Form.java:956)
>> > at
>> org.apache.wicket.markup.html.form.Form.onFormSubmitted(Form.java:788)
>> > at
>> org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:176)
>> > at
>> org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:127)
>> > at
>> org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:598)
>> > at
>> org.apache.wicket.core.request.handler.ListenerRequestHandler.internalInvoke(ListenerRequestHandler.java:306)
>> > at
>> org.apache.wicket.core.request.handler.ListenerRequestHandler.invoke(ListenerRequestHandler.java:280)
>> > at
>> org.apache.wicket.core.request.handler.ListenerRequestHandler.invokeListener(ListenerRequestHandler.java:222)
>> > at
>> org.apache.wicket.core.request.handler.ListenerRequestHandler.respond(ListenerRequestHandler.java:208)
>> > at
>> org.apache.wicket.request.cycle.RequestCycle$HandlerExecutor.respond(RequestCycle.java:914)
>> > at
>> org.apache.wicket.request.RequestHandlerExecutor.execute(RequestHandlerExecutor.java:65)
>> > at
>> org.apache.wicket.request.cycle.RequestCycle.execute(RequestCycle.java:282)
>> > at
>> org.apache.wicket.request.cycle.RequestCycle.processRequest(RequestCycle.java:253)
>> > at
>> org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(RequestCycle.java:221)
>> > at org.apache.wicket.protocol.ws
>> .AbstractUpgradeFilter.processRequestCycle(AbstractUpgradeFilter.java:70)
>> > at
>> org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:206)
>> > at
>> org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:299)
>> > at
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
>> > at
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
>> > at
>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
>> > at
>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
>> > at
>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:607)
>> > at
>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
>> > at
>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
>> > at
>> org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)
>> > at
>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
>> > at
>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
>> > at
>> org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
>> > at
>> org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
>> > at
>> org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834)
>> > at org.apache.tomcat.util.net
>> .NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415)
>> > at org.apache.tomcat.util.net
>> .SocketProcessorBase.run(SocketProcessorBase.java:49)
>> > at
>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>> > at
>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>> > at
>> org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
>> > at java.lang.Thread.run(Thread.java:748)
>> > Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException:
>> The server time zone value 'CEST' is unrecognized or represents more than
>> one time zone. You must configure either the server or JDBC driver (via the
>> serverTimezone configuration property) to use a more specifc time zone
>> value if you want to utilize time zone support.
>> > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>> > at
>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
>> > at
>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
>> > at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
>> > at
>> com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
>> > at
>> com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
>> > at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132)
>> > at
>> com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2241)
>> > at
>> com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2265)
>> > at
>> com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1319)
>> > at
>> com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:868)
>> > ... 44 common frames omitted
>> >
>> > --
>> > WBR
>> > Maxim aka solomax
>> >
>> >
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>
>
> --
> WBR
> Maxim aka solomax
>
>
>
--
WBR
Maxim aka solomax
Re: Could not connect to MariaDB
Posted by "R. Scholz" <re...@abakus-edv-systems.de>.
Hello Maxim,
the result of "timedatectl":
Local time: Mi 2019-04-03 08:06:21 CEST
Universal time: Mi 2019-04-03 06:06:21 UTC
RTC time: Mi 2019-04-03 06:06:21
Time zone: Europe/Berlin (CEST, +0200)
System clock synchronized: no
systemd-timesyncd.service active: no
RTC in local TZ: no
Now I put the parameter you wrote helpful in your last email and it
seems to be functionally.
Here is the fully parameter I actually use, if someone need it.
<property name="openjpa.ConnectionProperties"
value="DriverClassName=com.mysql.cj.jdbc.Driver
,
Url=jdbc:mysql://localhost:3306/openmeetings?autoReconnect=true&useUnicode=true&createDatabaseIfNotExist=true&characterEncoding=utf-8&connectionCollation=utf8_ge
, maxTotal=100
, maxIdle=100
, minIdle=0
, maxWaitMillis=10000
, TestOnBorrow=true
, poolPreparedStatements=true
, serverTimezone=Europe/Berlin
, Username=
, Password=" />
I am a little bit amazed about one thing: To test the new OM5 I made a
lot of times a new virtual machine with the same Ubuntu
18.04-Installation. I mean that the
the first times the OM-MySQL-Connection runs without problems. No
modification necessary. Anytime the error Maxim describe occurs, and I
dont know why.
Sure, I made something different, but I have no idea what it can be.
OK, for the moment I am very happy, get a gulp from my fresh/hot coffee
and look forward to test the newest modification Maxim implemented
yesterday in a speed where I am very surprised.
Maxim: Very good work!
Best regards,
René
Am 03.04.2019 um 05:25 schrieb Maxim Solodovnik:
> Just have tried to change TZ on my test Ubuntu server to be CEST and:
>
> *sudo timedatectl set-timezone CEST*
> Failed to set time zone: Invalid time zone 'CEST'
>
> What is the result of `timedatectl` command on your system?
>
>
> On Wed, 3 Apr 2019 at 07:35, Maxim Solodovnik <solomax666@gmail.com
> <ma...@gmail.com>> wrote:
>
> Hello René,
>
> I'll try to set up VM to test following steps (so here it is untested)
> 1) open
> ${OM_HOME}/webapps/openmeetings/WEB-INF/classes/META-INF/mysql_persistence.xml
> 2) find <property name="openjpa.ConnectionProperties"
> 3) add ", serverTimezone=Europe/Berlin" to the comma separated values
>
> run command line or web installer
>
> On Wed, 3 Apr 2019 at 02:16, R. Scholz
> <rene.scholz@abakus-edv-systems.de
> <ma...@abakus-edv-systems.de>> wrote:
> >
> > Hello,
> >
> > I dont know where I have to write what TimeZone-Variable.
> > I think it is the
> "/opt/open500/webapps/openmeetings/WEB-INF/classes/META-INF/mysql_persistence.xml".
> >
> > But where I have to write what to eliminate the "The server time
> zone value 'CEST' is unrecognized or..."-error?
> >
> > Best regards,
> >
> > René
> >
> >
> >
> >
> > Am 02.04.2019 um 07:35 schrieb Maxim Solodovnik:
> >
> > Hello All,
> >
> > recently I got error report from Alvaro regarding DB connection
> issue while MariaDB us used
> > After some "email ping-pong" I got logs, relevant part of logs
> can be found here [1]
> >
> > The first, huge stack trace provides only general information:
> "Could not create connection to database server. Attempted
> reconnect 3 times. Giving up."
> > Nothing to work with
> >
> > BUT the second one states: "The server time zone value 'CEST' is
> unrecognized or represents more than one time zone. You must
> configure either the server or JDBC driver (via the serverTimezone
> configuration property) to use a more specifc time zone value if
> you want to utilize time zone support."
> >
> > This one provides the root cause of the problem and possible
> solutions:
> > 1) change server TZ to be more specific i.e. Europe/Berlin (not
> CEST)
> > 2) edit persistense.xml file and add `serverTimezone`
> configuration property with TZ of MariaDb server
> >
> > Hope it can help
> >
> > [1]
> > java.sql.SQLNonTransientConnectionException: Could not create
> connection to database server. Attempted reconnect 3 times. Giving up.
> > at
> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
> > at
> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
> > at
> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
> > at
> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
> > at
> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
> > at
> com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:905)
> > at
> com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:830)
> > at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455)
> > at
> com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
> > at
> com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
> > at java.sql.DriverManager.getConnection(DriverManager.java:664)
> > at java.sql.DriverManager.getConnection(DriverManager.java:247)
> > at
> org.apache.openmeetings.web.pages.install.InstallWizard$DbStep$1.onValidateModelObjects(InstallWizard.java:266)
> > at
> org.apache.wicket.markup.html.form.Form.internalOnValidateModelObjects(Form.java:1870)
> > at org.apache.wicket.markup.html.form.Form.process(Form.java:956)
> > at
> org.apache.wicket.markup.html.form.Form.onFormSubmitted(Form.java:788)
> > at
> org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:176)
> > at
> org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:127)
> > at
> org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:598)
> > at
> org.apache.wicket.core.request.handler.ListenerRequestHandler.internalInvoke(ListenerRequestHandler.java:306)
> > at
> org.apache.wicket.core.request.handler.ListenerRequestHandler.invoke(ListenerRequestHandler.java:280)
> > at
> org.apache.wicket.core.request.handler.ListenerRequestHandler.invokeListener(ListenerRequestHandler.java:222)
> > at
> org.apache.wicket.core.request.handler.ListenerRequestHandler.respond(ListenerRequestHandler.java:208)
> > at
> org.apache.wicket.request.cycle.RequestCycle$HandlerExecutor.respond(RequestCycle.java:914)
> > at
> org.apache.wicket.request.RequestHandlerExecutor.execute(RequestHandlerExecutor.java:65)
> > at
> org.apache.wicket.request.cycle.RequestCycle.execute(RequestCycle.java:282)
> > at
> org.apache.wicket.request.cycle.RequestCycle.processRequest(RequestCycle.java:253)
> > at
> org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(RequestCycle.java:221)
> > at org.apache.wicket.protocol.ws
> <http://org.apache.wicket.protocol.ws>.AbstractUpgradeFilter.processRequestCycle(AbstractUpgradeFilter.java:70)
> > at
> org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:206)
> > at
> org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:299)
> > at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
> > at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
> > at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
> > at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
> > at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:607)
> > at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
> > at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
> > at
> org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)
> > at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
> > at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
> > at
> org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
> > at
> org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
> > at
> org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834)
> > at org.apache.tomcat.util.net
> <http://org.apache.tomcat.util.net>.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415)
> > at org.apache.tomcat.util.net
> <http://org.apache.tomcat.util.net>.SocketProcessorBase.run(SocketProcessorBase.java:49)
> > at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> > at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> > at
> org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
> > at java.lang.Thread.run(Thread.java:748)
> > Caused by:
> com.mysql.cj.exceptions.InvalidConnectionAttributeException: The
> server time zone value 'CEST' is unrecognized or represents more
> than one time zone. You must configure either the server or JDBC
> driver (via the serverTimezone configuration property) to use a
> more specifc time zone value if you want to utilize time zone support.
> > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
> > at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
> > at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> > at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
> > at
> com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
> > at
> com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
> > at
> com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132)
> > at
> com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2241)
> > at
> com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2265)
> > at
> com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1319)
> > at
> com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:868)
> > ... 44 common frames omitted
> >
> > --
> > WBR
> > Maxim aka solomax
> >
> >
>
>
> --
> WBR
> Maxim aka solomax
>
>
>
> --
> WBR
> Maxim aka solomax
Re: Could not connect to MariaDB
Posted by Maxim Solodovnik <so...@gmail.com>.
Just have tried to change TZ on my test Ubuntu server to be CEST and:
*sudo timedatectl set-timezone CEST*
Failed to set time zone: Invalid time zone 'CEST'
What is the result of `timedatectl` command on your system?
On Wed, 3 Apr 2019 at 07:35, Maxim Solodovnik <so...@gmail.com> wrote:
> Hello René,
>
> I'll try to set up VM to test following steps (so here it is untested)
> 1) open
> ${OM_HOME}/webapps/openmeetings/WEB-INF/classes/META-INF/mysql_persistence.xml
> 2) find <property name="openjpa.ConnectionProperties"
> 3) add ", serverTimezone=Europe/Berlin" to the comma separated values
>
> run command line or web installer
>
> On Wed, 3 Apr 2019 at 02:16, R. Scholz
> <re...@abakus-edv-systems.de> wrote:
> >
> > Hello,
> >
> > I dont know where I have to write what TimeZone-Variable.
> > I think it is the
> "/opt/open500/webapps/openmeetings/WEB-INF/classes/META-INF/mysql_persistence.xml".
> >
> > But where I have to write what to eliminate the "The server time zone
> value 'CEST' is unrecognized or..."-error?
> >
> > Best regards,
> >
> > René
> >
> >
> >
> >
> > Am 02.04.2019 um 07:35 schrieb Maxim Solodovnik:
> >
> > Hello All,
> >
> > recently I got error report from Alvaro regarding DB connection issue
> while MariaDB us used
> > After some "email ping-pong" I got logs, relevant part of logs can be
> found here [1]
> >
> > The first, huge stack trace provides only general information: "Could
> not create connection to database server. Attempted reconnect 3 times.
> Giving up."
> > Nothing to work with
> >
> > BUT the second one states: "The server time zone value 'CEST' is
> unrecognized or represents more than one time zone. You must configure
> either the server or JDBC driver (via the serverTimezone configuration
> property) to use a more specifc time zone value if you want to utilize time
> zone support."
> >
> > This one provides the root cause of the problem and possible solutions:
> > 1) change server TZ to be more specific i.e. Europe/Berlin (not CEST)
> > 2) edit persistense.xml file and add `serverTimezone` configuration
> property with TZ of MariaDb server
> >
> > Hope it can help
> >
> > [1]
> > java.sql.SQLNonTransientConnectionException: Could not create connection
> to database server. Attempted reconnect 3 times. Giving up.
> > at
> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
> > at
> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
> > at
> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
> > at
> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
> > at
> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
> > at
> com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:905)
> > at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:830)
> > at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455)
> > at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
> > at
> com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
> > at java.sql.DriverManager.getConnection(DriverManager.java:664)
> > at java.sql.DriverManager.getConnection(DriverManager.java:247)
> > at
> org.apache.openmeetings.web.pages.install.InstallWizard$DbStep$1.onValidateModelObjects(InstallWizard.java:266)
> > at
> org.apache.wicket.markup.html.form.Form.internalOnValidateModelObjects(Form.java:1870)
> > at org.apache.wicket.markup.html.form.Form.process(Form.java:956)
> > at org.apache.wicket.markup.html.form.Form.onFormSubmitted(Form.java:788)
> > at
> org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:176)
> > at
> org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:127)
> > at
> org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:598)
> > at
> org.apache.wicket.core.request.handler.ListenerRequestHandler.internalInvoke(ListenerRequestHandler.java:306)
> > at
> org.apache.wicket.core.request.handler.ListenerRequestHandler.invoke(ListenerRequestHandler.java:280)
> > at
> org.apache.wicket.core.request.handler.ListenerRequestHandler.invokeListener(ListenerRequestHandler.java:222)
> > at
> org.apache.wicket.core.request.handler.ListenerRequestHandler.respond(ListenerRequestHandler.java:208)
> > at
> org.apache.wicket.request.cycle.RequestCycle$HandlerExecutor.respond(RequestCycle.java:914)
> > at
> org.apache.wicket.request.RequestHandlerExecutor.execute(RequestHandlerExecutor.java:65)
> > at
> org.apache.wicket.request.cycle.RequestCycle.execute(RequestCycle.java:282)
> > at
> org.apache.wicket.request.cycle.RequestCycle.processRequest(RequestCycle.java:253)
> > at
> org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(RequestCycle.java:221)
> > at org.apache.wicket.protocol.ws
> .AbstractUpgradeFilter.processRequestCycle(AbstractUpgradeFilter.java:70)
> > at
> org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:206)
> > at
> org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:299)
> > at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
> > at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
> > at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
> > at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
> > at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:607)
> > at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
> > at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
> > at
> org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)
> > at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
> > at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
> > at
> org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
> > at
> org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
> > at
> org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834)
> > at org.apache.tomcat.util.net
> .NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415)
> > at org.apache.tomcat.util.net
> .SocketProcessorBase.run(SocketProcessorBase.java:49)
> > at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> > at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> > at
> org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
> > at java.lang.Thread.run(Thread.java:748)
> > Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException:
> The server time zone value 'CEST' is unrecognized or represents more than
> one time zone. You must configure either the server or JDBC driver (via the
> serverTimezone configuration property) to use a more specifc time zone
> value if you want to utilize time zone support.
> > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> > at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
> > at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> > at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
> > at
> com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
> > at
> com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
> > at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132)
> > at
> com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2241)
> > at
> com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2265)
> > at
> com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1319)
> > at
> com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:868)
> > ... 44 common frames omitted
> >
> > --
> > WBR
> > Maxim aka solomax
> >
> >
>
>
> --
> WBR
> Maxim aka solomax
>
--
WBR
Maxim aka solomax
Re: Could not connect to MariaDB
Posted by Maxim Solodovnik <so...@gmail.com>.
Hello René,
I'll try to set up VM to test following steps (so here it is untested)
1) open ${OM_HOME}/webapps/openmeetings/WEB-INF/classes/META-INF/mysql_persistence.xml
2) find <property name="openjpa.ConnectionProperties"
3) add ", serverTimezone=Europe/Berlin" to the comma separated values
run command line or web installer
On Wed, 3 Apr 2019 at 02:16, R. Scholz
<re...@abakus-edv-systems.de> wrote:
>
> Hello,
>
> I dont know where I have to write what TimeZone-Variable.
> I think it is the "/opt/open500/webapps/openmeetings/WEB-INF/classes/META-INF/mysql_persistence.xml".
>
> But where I have to write what to eliminate the "The server time zone value 'CEST' is unrecognized or..."-error?
>
> Best regards,
>
> René
>
>
>
>
> Am 02.04.2019 um 07:35 schrieb Maxim Solodovnik:
>
> Hello All,
>
> recently I got error report from Alvaro regarding DB connection issue while MariaDB us used
> After some "email ping-pong" I got logs, relevant part of logs can be found here [1]
>
> The first, huge stack trace provides only general information: "Could not create connection to database server. Attempted reconnect 3 times. Giving up."
> Nothing to work with
>
> BUT the second one states: "The server time zone value 'CEST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support."
>
> This one provides the root cause of the problem and possible solutions:
> 1) change server TZ to be more specific i.e. Europe/Berlin (not CEST)
> 2) edit persistense.xml file and add `serverTimezone` configuration property with TZ of MariaDb server
>
> Hope it can help
>
> [1]
> java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
> at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
> at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
> at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
> at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
> at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
> at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:905)
> at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:830)
> at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455)
> at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
> at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
> at java.sql.DriverManager.getConnection(DriverManager.java:664)
> at java.sql.DriverManager.getConnection(DriverManager.java:247)
> at org.apache.openmeetings.web.pages.install.InstallWizard$DbStep$1.onValidateModelObjects(InstallWizard.java:266)
> at org.apache.wicket.markup.html.form.Form.internalOnValidateModelObjects(Form.java:1870)
> at org.apache.wicket.markup.html.form.Form.process(Form.java:956)
> at org.apache.wicket.markup.html.form.Form.onFormSubmitted(Form.java:788)
> at org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:176)
> at org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:127)
> at org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:598)
> at org.apache.wicket.core.request.handler.ListenerRequestHandler.internalInvoke(ListenerRequestHandler.java:306)
> at org.apache.wicket.core.request.handler.ListenerRequestHandler.invoke(ListenerRequestHandler.java:280)
> at org.apache.wicket.core.request.handler.ListenerRequestHandler.invokeListener(ListenerRequestHandler.java:222)
> at org.apache.wicket.core.request.handler.ListenerRequestHandler.respond(ListenerRequestHandler.java:208)
> at org.apache.wicket.request.cycle.RequestCycle$HandlerExecutor.respond(RequestCycle.java:914)
> at org.apache.wicket.request.RequestHandlerExecutor.execute(RequestHandlerExecutor.java:65)
> at org.apache.wicket.request.cycle.RequestCycle.execute(RequestCycle.java:282)
> at org.apache.wicket.request.cycle.RequestCycle.processRequest(RequestCycle.java:253)
> at org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(RequestCycle.java:221)
> at org.apache.wicket.protocol.ws.AbstractUpgradeFilter.processRequestCycle(AbstractUpgradeFilter.java:70)
> at org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:206)
> at org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:299)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:607)
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
> at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
> at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
> at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
> at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834)
> at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415)
> at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
> at java.lang.Thread.run(Thread.java:748)
> Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'CEST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
> at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
> at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
> at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132)
> at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2241)
> at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2265)
> at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1319)
> at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:868)
> ... 44 common frames omitted
>
> --
> WBR
> Maxim aka solomax
>
>
--
WBR
Maxim aka solomax
Re: Could not connect to MariaDB
Posted by "R. Scholz" <re...@abakus-edv-systems.de>.
Hello,
I dont know where I have to write what TimeZone-Variable.
I think it is the
"/opt/open500/webapps/openmeetings/WEB-INF/classes/META-INF/mysql_persistence.xml".
But where I have to write what to eliminate the "The server time zone
value 'CEST' is unrecognized or..."-error?
Best regards,
René
Am 02.04.2019 um 07:35 schrieb Maxim Solodovnik:
> Hello All,
>
> recently I got error report from Alvaro regarding DB connection issue
> while MariaDB us used
> After some "email ping-pong" I got logs, relevant part of logs can be
> found here [1]
>
> The first, huge stack trace provides only general information: "Could
> not create connection to database server. Attempted reconnect 3 times.
> Giving up."
> Nothing to work with
>
> BUT the second one states: "The server time zone value 'CEST' is
> unrecognized or represents more than one time zone. You must configure
> either the server or JDBC driver (via the serverTimezone configuration
> property) to use a more specifc time zone value if you want to utilize
> time zone support."
>
> This one provides the root cause of the problem and possible solutions:
> 1) change server TZ to be more specific i.e. Europe/Berlin (not CEST)
> 2) edit persistense.xml file and add `serverTimezone` configuration
> property with TZ of MariaDb server
>
> Hope it can help
>
> [1]
> java.sql.SQLNonTransientConnectionException: Could not create
> connection to database server. Attempted reconnect 3 times. Giving up.
> at
> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
> at
> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
> at
> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
> at
> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
> at
> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
> at
> com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:905)
> at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:830)
> at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455)
> at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
> at
> com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
> at java.sql.DriverManager.getConnection(DriverManager.java:664)
> at java.sql.DriverManager.getConnection(DriverManager.java:247)
> at
> org.apache.openmeetings.web.pages.install.InstallWizard$DbStep$1.onValidateModelObjects(InstallWizard.java:266)
> at
> org.apache.wicket.markup.html.form.Form.internalOnValidateModelObjects(Form.java:1870)
> at org.apache.wicket.markup.html.form.Form.process(Form.java:956)
> at org.apache.wicket.markup.html.form.Form.onFormSubmitted(Form.java:788)
> at
> org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:176)
> at
> org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:127)
> at
> org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:598)
> at
> org.apache.wicket.core.request.handler.ListenerRequestHandler.internalInvoke(ListenerRequestHandler.java:306)
> at
> org.apache.wicket.core.request.handler.ListenerRequestHandler.invoke(ListenerRequestHandler.java:280)
> at
> org.apache.wicket.core.request.handler.ListenerRequestHandler.invokeListener(ListenerRequestHandler.java:222)
> at
> org.apache.wicket.core.request.handler.ListenerRequestHandler.respond(ListenerRequestHandler.java:208)
> at
> org.apache.wicket.request.cycle.RequestCycle$HandlerExecutor.respond(RequestCycle.java:914)
> at
> org.apache.wicket.request.RequestHandlerExecutor.execute(RequestHandlerExecutor.java:65)
> at
> org.apache.wicket.request.cycle.RequestCycle.execute(RequestCycle.java:282)
> at
> org.apache.wicket.request.cycle.RequestCycle.processRequest(RequestCycle.java:253)
> at
> org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(RequestCycle.java:221)
> at
> org.apache.wicket.protocol.ws.AbstractUpgradeFilter.processRequestCycle(AbstractUpgradeFilter.java:70)
> at
> org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:206)
> at
> org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:299)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:607)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
> at
> org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
> at
> org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
> at
> org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
> at
> org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834)
> at
> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415)
> at
> org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> at
> org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
> at java.lang.Thread.run(Thread.java:748)
> Caused by:
> com.mysql.cj.exceptions.InvalidConnectionAttributeException: The
> server time zone value 'CEST' is unrecognized or represents more than
> one time zone. You must configure either the server or JDBC driver
> (via the serverTimezone configuration property) to use a more specifc
> time zone value if you want to utilize time zone support.
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
> at
> com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
> at
> com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
> at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132)
> at
> com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2241)
> at
> com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2265)
> at
> com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1319)
> at
> com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:868)
> ... 44 common frames omitted
>
> --
> WBR
> Maxim aka solomax