OM APP

[Mettavihari D]

Greetings

Is there an app available for OM

With metta
Mettavihari

Re: OM5: program/desktop sharing: black screen

[Aaron Hepp]

In Chrome the box is grey.  Once you click on "Start Screening" on the 
new window that pops up "Share your screen" look at the top bar and you 
should see where to select what you want to share (see image)

Your Entire Screen
Application Window
Chrome Tab


On 4/13/19 2:40 PM, R. Scholz wrote:

Hello,

in the evening I spent some time to ttry out the dekstop-sharing under 
different circumstances.


OS: Windows 10 1809

Browser: Firefox 66.0.3
When I choose the "sharing-icon" I can slect between 3 possibilites.
No matter what I choose: A Software written in Delphi make at the 
viewer only a black window.


Chrome: 73.0.3683.103
When I choose the "sharing-icon" I can not select between Screen, 
Window ...

This box is disabled, I can ony choose "Screen". The FPS is disabled too.
Here the Delphi-Software runs perfectly. No black screen.

Result:
Firefox: Black window
Chrome: Works perfect

Have anybody an idea why in Chrome it works, in Firefox not?
(I tested Edge too, but there I get certificate-errors when I start 
the Sharing. But it's OK, it's a virtual machine

and I have there no https-certificate.)

Best regards,

René



Am 13.04.2019 um 14:13 schrieb Maxim Solodovnik:

Is this behavior Browser/OS dependent?

On Sat, 13 Apr 2019 at 17:23, Aaron Hepp > wrote:


Looks like there is some "program types" that it has trouble
capturing.  Would say a flaw of WebRTC.  I have the same problems
with certain java based programs.  When doing the screen sharing,
you will get a black screen but if you look every now and then is
will show for a brief instance then back to black "Flickers" more
so.  This was when capturing (window or Application).  If you
capture the screen then it can display it without issues.

On 4/13/19 3:34 AM, R. Scholz wrote:

Hello,

when I share a program in OM5 some programs only show at the
viewer a black window.
(I told it in an email a few days ago and Maxim made some ideas
to identify the problem.)

I tried out a lot of programs and, beneath our own programmed
software I saw that the
product "SoftPerfect Network Scanner" make this black screen too.
In my own "system-tools-libary" I use the (old) free-version
"4.4.5". (Its totally enough, this free version
do exactly what I want.)

A look into the binary-code shows that it is a delphi-program.

Has anyone an idea I can try?

Best regards,

René




Am 13.04.2019 um 09:19 schrieb R. Scholz:

Hello Aaron,

I think it is the same problem I had a few weeks ago. (And I
hope I solved it.)

To your questions with the log: You find relevant logs at
"/opt/logs" e.g. "/opt/%OMDIR%/logs". The actual log is named
"catalina.out".

When it is the error I think you have to edit the
"mysql-persistence.xml"
You find it in the openmeeting-Directory ->
webapps/openmeetings/WEB-INF/classes/META-INF.

Here the part of my email.

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=1
, TestOnBorrow=true
, poolPreparedStatements=true
, Username=
, Password=" />


I hope it helps.


Best regards,


René






Am 13.04.2019 um 01:58 schrieb Aaron Hepp:

Where are the connection logs to the database located at? 
Just stood up a new OM5 instance on a Ubuntu 16.04 install. 
went through all the steps, but does not look like it is
making a connection to the MySQL database.

Could not create connection to database server. Attempted
reconnect 3 times. Giving up.

Database is up and listening on port 3306, made sure database
name, user and password were correct, but keep getting the
errors.  Was going to look at the logs but forgot where they
are at to determine what the issue was.








--
WBR
Maxim aka solomax

Re: OM5: program/desktop sharing: black screen

[Aaron Hepp]

Right now it is looking like it is OS dependent (But I can not verify 
fully)  In Windows 7 using both Firefox and Chromium Based Browsers 
(Chrome / Opera) the application I am testing screening sharing with 
(E*Trade Pro java) when doing application / windows sharing you get a 
black screen.  When you share the "full screen" it streams without any 
issues.  Reason I can not fully verify if it is OS based; is that I only 
have Windows 7 running in a VM I do not have a bare metal install.


The same application tested on the same browsers in Windows 10 bare 
metal install works as expected.


The application I am using does not work natively in Linux nor OSX so I 
can not verify if it works there.  I will see if I can get a bare metal 
install of Windows 7 up to see if it is because of the OS or because it 
is running in a VM.


On 4/13/19 8:13 AM, Maxim Solodovnik wrote:

Is this behavior Browser/OS dependent?

On Sat, 13 Apr 2019 at 17:23, Aaron Hepp > wrote:


Looks like there is some "program types" that it has trouble
capturing.  Would say a flaw of WebRTC.  I have the same problems
with certain java based programs.  When doing the screen sharing,
you will get a black screen but if you look every now and then is
will show for a brief instance then back to black "Flickers" more
so.  This was when capturing (window or Application).  If you
capture the screen then it can display it without issues.

On 4/13/19 3:34 AM, R. Scholz wrote:

Hello,

when I share a program in OM5 some programs only show at the
viewer a black window.
(I told it in an email a few days ago and Maxim made some ideas
to identify the problem.)

I tried out a lot of programs and, beneath our own programmed
software I saw that the
product "SoftPerfect Network Scanner" make this black screen too.
In my own "system-tools-libary" I use the (old) free-version
"4.4.5". (Its totally enough, this free version
do exactly what I want.)

A look into the binary-code shows that it is a delphi-program.

Has anyone an idea I can try?

Best regards,

René




Am 13.04.2019 um 09:19 schrieb R. Scholz:

Hello Aaron,

I think it is the same problem I had a few weeks ago. (And I
hope I solved it.)

To your questions with the log: You find relevant logs at
"/opt/logs" e.g. "/opt/%OMDIR%/logs". The actual log is named
"catalina.out".

When it is the error I think you have to edit the
"mysql-persistence.xml"
You find it in the openmeeting-Directory ->
webapps/openmeetings/WEB-INF/classes/META-INF.

Here the part of my email.

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=1
, TestOnBorrow=true
, poolPreparedStatements=true
, Username=
, Password=" />


I hope it helps.


Best regards,


René






Am 13.04.2019 um 01:58 schrieb Aaron Hepp:

Where are the connection logs to the database located at?  Just
stood up a new OM5 instance on a Ubuntu 16.04 install.  went
through all the steps, but does not look like it is making a
connection to the MySQL database.

Could not create connection to database server. Attempted
reconnect 3 times. Giving up.

Database is up and listening on port 3306, made sure database
name, user and password were correct, but keep getting the
errors.  Was going to look at the logs but forgot where they
are at to determine what the issue was.








--
WBR
Maxim aka solomax

Re: OM5: program/desktop sharing: black screen

[R. Scholz]

Hello,

in the evening I spent some time to ttry out the dekstop-sharing under 
different circumstances.


OS: Windows 10 1809

Browser: Firefox 66.0.3
When I choose the "sharing-icon" I can slect between 3 possibilites.
No matter what I choose: A Software written in Delphi make at the viewer 
only a black window.


Chrome: 73.0.3683.103
When I choose the "sharing-icon" I can not select between Screen, Window ...
This box is disabled, I can ony choose "Screen". The FPS is disabled too.
Here the Delphi-Software runs perfectly. No black screen.

Result:
Firefox: Black window
Chrome: Works perfect

Have anybody an idea why in Chrome it works, in Firefox not?
(I tested Edge too, but there I get certificate-errors when I start the 
Sharing. But it's OK, it's a virtual machine

and I have there no https-certificate.)

Best regards,

René



Am 13.04.2019 um 14:13 schrieb Maxim Solodovnik:

Is this behavior Browser/OS dependent?

On Sat, 13 Apr 2019 at 17:23, Aaron Hepp > wrote:


Looks like there is some "program types" that it has trouble
capturing.  Would say a flaw of WebRTC.  I have the same problems
with certain java based programs.  When doing the screen sharing,
you will get a black screen but if you look every now and then is
will show for a brief instance then back to black "Flickers" more
so.  This was when capturing (window or Application).  If you
capture the screen then it can display it without issues.

On 4/13/19 3:34 AM, R. Scholz wrote:

Hello,

when I share a program in OM5 some programs only show at the
viewer a black window.
(I told it in an email a few days ago and Maxim made some ideas
to identify the problem.)

I tried out a lot of programs and, beneath our own programmed
software I saw that the
product "SoftPerfect Network Scanner" make this black screen too.
In my own "system-tools-libary" I use the (old) free-version
"4.4.5". (Its totally enough, this free version
do exactly what I want.)

A look into the binary-code shows that it is a delphi-program.

Has anyone an idea I can try?

Best regards,

René




Am 13.04.2019 um 09:19 schrieb R. Scholz:

Hello Aaron,

I think it is the same problem I had a few weeks ago. (And I
hope I solved it.)

To your questions with the log: You find relevant logs at
"/opt/logs" e.g. "/opt/%OMDIR%/logs". The actual log is named
"catalina.out".

When it is the error I think you have to edit the
"mysql-persistence.xml"
You find it in the openmeeting-Directory ->
webapps/openmeetings/WEB-INF/classes/META-INF.

Here the part of my email.

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=1
, TestOnBorrow=true
, poolPreparedStatements=true
, Username=
, Password=" />


I hope it helps.


Best regards,


René






Am 13.04.2019 um 01:58 schrieb Aaron Hepp:

Where are the connection logs to the database located at?  Just
stood up a new OM5 instance on a Ubuntu 16.04 install.  went
through all the steps, but does not look like it is making a
connection to the MySQL database.

Could not create connection to database server. Attempted
reconnect 3 times. Giving up.

Database is up and listening on port 3306, made sure database
name, user and password were correct, but keep getting the
errors.  Was going to look at the logs but forgot where they
are at to determine what the issue was.








--
WBR
Maxim aka solomax

Re: Upgrade 4.0.4 to 5.0

[Maxim Solodovnik]

Upgrade should work as expected
this what it was designed for :)

On Sat, 13 Apr 2019 at 22:08, Stefan Kühl  wrote:

> Hey@ all,
>
> just to keep my mind calm before trying: Will a "normal" update (as
> desrcribed in OM Backup etc.) work directly from version 4.0.4 to 5.0?
>
> This morning I tested a clean installation without docker on a 18.04.
> Ubuntu. Using native KMS installation. Works fine so far. I've recognized
> some weird behaviour, but I need to verify und reproduce this.
>
> Greetings
>
> Stefan
>


-- 
WBR
Maxim aka solomax

Upgrade 4.0.4 to 5.0

[Stefan Kühl]

Hey@ all, 

just to keep my mind calm before trying: Will a "normal" update (as
desrcribed in OM Backup etc.) work directly from version 4.0.4 to 5.0? 

This morning I tested a clean installation without docker on a 18.04.
Ubuntu. Using native KMS installation. Works fine so far. I've
recognized some weird behaviour, but I need to verify und reproduce
this. 

Greetings 

Stefan

Re: OM5: program/desktop sharing: black screen

[Maxim Solodovnik]

Is this behavior Browser/OS dependent?

On Sat, 13 Apr 2019 at 17:23, Aaron Hepp  wrote:

> Looks like there is some "program types" that it has trouble capturing.
> Would say a flaw of WebRTC.  I have the same problems with certain java
> based programs.  When doing the screen sharing, you will get a black screen
> but if you look every now and then is will show for a brief instance then
> back to black "Flickers" more so.  This was when capturing (window or
> Application).  If you capture the screen then it can display it without
> issues.
>
> On 4/13/19 3:34 AM, R. Scholz wrote:
>
> Hello,
>
> when I share a program in OM5 some programs only show at the viewer a
> black window.
> (I told it in an email a few days ago and Maxim made some ideas to
> identify the problem.)
>
> I tried out a lot of programs and, beneath our own programmed software I
> saw that the
> product "SoftPerfect Network Scanner" make this black screen too.
> In my own "system-tools-libary" I use the (old) free-version "4.4.5". (Its
> totally enough, this free version
> do exactly what I want.)
>
> A look into the binary-code shows that it is a delphi-program.
>
> Has anyone an idea I can try?
>
> Best regards,
>
> René
>
>
>
>
> Am 13.04.2019 um 09:19 schrieb R. Scholz:
>
> Hello Aaron,
>
> I think it is the same problem I had a few weeks ago. (And I hope I solved
> it.)
>
> To your questions with the log: You find relevant logs at "/opt/logs" e.g.
> "/opt/%OMDIR%/logs". The actual log is named "catalina.out".
>
> When it is the error I think you have to edit the "mysql-persistence.xml"
> You find it in the openmeeting-Directory ->
> webapps/openmeetings/WEB-INF/classes/META-INF.
>
> Here the part of my email.
>
> 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=1
> , TestOnBorrow=true
> , poolPreparedStatements=true
> , Username=
> , Password=" />
>
>
> I hope it helps.
>
>
> Best regards,
>
>
> René
>
>
>
>
>
>
> Am 13.04.2019 um 01:58 schrieb Aaron Hepp:
>
> Where are the connection logs to the database located at?  Just stood up a
> new OM5 instance on a Ubuntu 16.04 install.  went through all the steps,
> but does not look like it is making a connection to the MySQL database.
>
> Could not create connection to database server. Attempted reconnect 3
> times. Giving up.
>
> Database is up and listening on port 3306, made sure database name, user
> and password were correct, but keep getting the errors.  Was going to look
> at the logs but forgot where they are at to determine what the issue was.
>
>
>
>
>

-- 
WBR
Maxim aka solomax

Re: OM5: program/desktop sharing: black screen

[Aaron Hepp]

Looks like there is some "program types" that it has trouble capturing.  
Would say a flaw of WebRTC.  I have the same problems with certain java 
based programs.  When doing the screen sharing, you will get a black 
screen but if you look every now and then is will show for a brief 
instance then back to black "Flickers" more so.  This was when capturing 
(window or Application).  If you capture the screen then it can display 
it without issues.


On 4/13/19 3:34 AM, R. Scholz wrote:

Hello,

when I share a program in OM5 some programs only show at the viewer a 
black window.
(I told it in an email a few days ago and Maxim made some ideas to 
identify the problem.)


I tried out a lot of programs and, beneath our own programmed software 
I saw that the

product "SoftPerfect Network Scanner" make this black screen too.
In my own "system-tools-libary" I use the (old) free-version "4.4.5". 
(Its totally enough, this free version

do exactly what I want.)

A look into the binary-code shows that it is a delphi-program.

Has anyone an idea I can try?

Best regards,

René




Am 13.04.2019 um 09:19 schrieb R. Scholz:

Hello Aaron,

I think it is the same problem I had a few weeks ago. (And I hope I 
solved it.)


To your questions with the log: You find relevant logs at "/opt/logs" 
e.g. "/opt/%OMDIR%/logs". The actual log is named "catalina.out".


When it is the error I think you have to edit the "mysql-persistence.xml"
You find it in the openmeeting-Directory -> 
webapps/openmeetings/WEB-INF/classes/META-INF.


Here the part of my email.

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=1
, TestOnBorrow=true
, poolPreparedStatements=true
, Username=
, Password=" />


I hope it helps.


Best regards,


René






Am 13.04.2019 um 01:58 schrieb Aaron Hepp:
Where are the connection logs to the database located at?  Just 
stood up a new OM5 instance on a Ubuntu 16.04 install.  went through 
all the steps, but does not look like it is making a connection to 
the MySQL database.


Could not create connection to database server. Attempted reconnect 
3 times. Giving up.


Database is up and listening on port 3306, made sure database name, 
user and password were correct, but keep getting the errors.  Was 
going to look at the logs but forgot where they are at to determine 
what the issue was.

Re: db connection logs

[Aaron Hepp]

Not sure really what the problem was.  the persistence file was correct 
with the right db name in it.  I just dropped the database and rebuilt 
it, and it connected fine.  First time I had ever had the issue on a 
build.  But after recreating the database it connected without a 
problem.    Just going to chalk that one up the strange events.


On 4/13/19 3:19 AM, R. Scholz wrote:

Hello Aaron,

I think it is the same problem I had a few weeks ago. (And I hope I 
solved it.)


To your questions with the log: You find relevant logs at "/opt/logs" 
e.g. "/opt/%OMDIR%/logs". The actual log is named "catalina.out".


When it is the error I think you have to edit the "mysql-persistence.xml"
You find it in the openmeeting-Directory -> 
webapps/openmeetings/WEB-INF/classes/META-INF.


Here the part of my email.

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=1
, TestOnBorrow=true
, poolPreparedStatements=true
, Username=
, Password=" />


I hope it helps.


Best regards,


René






Am 13.04.2019 um 01:58 schrieb Aaron Hepp:
Where are the connection logs to the database located at?  Just stood 
up a new OM5 instance on a Ubuntu 16.04 install.  went through all 
the steps, but does not look like it is making a connection to the 
MySQL database.


Could not create connection to database server. Attempted reconnect 3 
times. Giving up.


Database is up and listening on port 3306, made sure database name, 
user and password were correct, but keep getting the errors.  Was 
going to look at the logs but forgot where they are at to determine 
what the issue was.

OM5: program/desktop sharing: black screen

[R. Scholz]

Hello,

when I share a program in OM5 some programs only show at the viewer a 
black window.
(I told it in an email a few days ago and Maxim made some ideas to 
identify the problem.)


I tried out a lot of programs and, beneath our own programmed software I 
saw that the

product "SoftPerfect Network Scanner" make this black screen too.
In my own "system-tools-libary" I use the (old) free-version "4.4.5". 
(Its totally enough, this free version

do exactly what I want.)

A look into the binary-code shows that it is a delphi-program.

Has anyone an idea I can try?

Best regards,

René




Am 13.04.2019 um 09:19 schrieb R. Scholz:

Hello Aaron,

I think it is the same problem I had a few weeks ago. (And I hope I 
solved it.)


To your questions with the log: You find relevant logs at "/opt/logs" 
e.g. "/opt/%OMDIR%/logs". The actual log is named "catalina.out".


When it is the error I think you have to edit the "mysql-persistence.xml"
You find it in the openmeeting-Directory -> 
webapps/openmeetings/WEB-INF/classes/META-INF.


Here the part of my email.

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=1
, TestOnBorrow=true
, poolPreparedStatements=true
, Username=
, Password=" />


I hope it helps.


Best regards,


René






Am 13.04.2019 um 01:58 schrieb Aaron Hepp:
Where are the connection logs to the database located at?  Just stood 
up a new OM5 instance on a Ubuntu 16.04 install.  went through all 
the steps, but does not look like it is making a connection to the 
MySQL database.


Could not create connection to database server. Attempted reconnect 3 
times. Giving up.


Database is up and listening on port 3306, made sure database name, 
user and password were correct, but keep getting the errors.  Was 
going to look at the logs but forgot where they are at to determine 
what the issue was.

Re: db connection logs

[R. Scholz]

Hello Aaron,

I think it is the same problem I had a few weeks ago. (And I hope I 
solved it.)


To your questions with the log: You find relevant logs at "/opt/logs" 
e.g. "/opt/%OMDIR%/logs". The actual log is named "catalina.out".


When it is the error I think you have to edit the "mysql-persistence.xml"
You find it in the openmeeting-Directory -> 
webapps/openmeetings/WEB-INF/classes/META-INF.


Here the part of my email.

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=1
, TestOnBorrow=true
, poolPreparedStatements=true
, Username=
, Password=" />


I hope it helps.


Best regards,


René






Am 13.04.2019 um 01:58 schrieb Aaron Hepp:
Where are the connection logs to the database located at?  Just stood 
up a new OM5 instance on a Ubuntu 16.04 install.  went through all the 
steps, but does not look like it is making a connection to the MySQL 
database.


Could not create connection to database server. Attempted reconnect 3 
times. Giving up.


Database is up and listening on port 3306, made sure database name, 
user and password were correct, but keep getting the errors.  Was 
going to look at the logs but forgot where they are at to determine 
what the issue was.