date:20201001

Re: Re: Re: Re: Re: Regaining admin access to an openmeetings installation

2020-10-01 Thread Maxim Solodovnik

I have downloaded 4.0.3
Perform quick install with h2
Did select from db of login and password 

Weird it doesn't work

You can elevate permissions of any existing users 

from mobile (sorry for typos ;)


On Fri, Oct 2, 2020, 13:39 Stefan Günther  wrote:

> Hello Maxim,
>
> DEBUG 10-02 08:37:11.709 o.a.o.d.d.u.UserDao:588 [0.0-5443-exec-8] -
> login:: 1 users were found
> DEBUG 10-02 08:37:11.728 o.a.o.d.d.u.UserDao:597 [0.0-5443-exec-8] -
> Password does not match: User [id=2, firstname=Johannes, lastname=Weber,
> login=omadmin, pictureuri=profile.jpg, deleted=false, languageId=2, add
> ress=Address [id=2, country=DE, street=Landauer Straße, town=Karlsruhe,
> zip=76227, deleted=false, email=omad...@.eu, phone=0721xx],
> externalId=null, externalType=null, type=user]
>
> How did you create the hash?
>
> Regards,
>
> Stefan
>
>
> *Gesendet:* Freitag, 02. Oktober 2020 um 02:59 Uhr
> *Von:* "Maxim Solodovnik" 
> *An:* "Openmeetings user-list" 
> *Betreff:* Re: Re: Re: Re: Regaining admin access to an openmeetings
> installation
> Is this the only admin in the system?
> what in the openmeetings.log during login?
>
> On Fri, 2 Oct 2020 at 00:22, Stefan Günther  wrote:
>
>> Hello Maxim,
>>
>> using the ID 2, the update was successful:
>>
>> ID   |LOGIN  |PASSWORD
>>
>>
>> --
>> 2 |omadmin
>>  
>> |BERxbKlDr1P+1KOQqBnponK8VQ8SyR0Cwq61By4DOIZb5qBx7QPIXSj3DkYgKjr0XhoEKCtiY1soramoYYst/PunMXfT0H+zoOAoDpWHMGf6ZqX/KThPVGeHoQp33m7&
>>
>>
>> But I still cannot login with omadmin / Q!w2e3r4t5 (I tried it more than
>> once).
>>
>> Regards,
>>
>> Stefan
>>
>>
>> *Gesendet:* Donnerstag, 01. Oktober 2020 um 18:03 Uhr
>> *Von:* "Maxim Solodovnik" 
>> *An:* "Openmeetings user-list" 
>> *Betreff:* Re: Re: Re: Regaining admin access to an openmeetings
>> installation
>> obviously ID is numeric identificator
>> for ex. 1
>>
>> On Thu, 1 Oct 2020 at 23:01, Stefan Günther  wrote:
>>
>>> Hi Maxim,
>>>
>>> thanks a lot for your help, but let's assume the account is 'admin':
>>>
>>> UPDATE OMDBUSER.OM_USER SET
>>> PASSWORD='BERxbKlDr1P+1KOQqBnponK8VQ8SyR0Cwq61By4DOIZb5qBx7QPIXSj3DkYgKjr0XhoEKCtiY1soramoYYst/PunMXfT0H+zoOAoDpWHMGf6ZqX/KThPVGeHoQp33m7&'
>>> WHERE ID='admin';
>>>
>>> returns
>>>
>>> ERROR 42818: Comparisons between 'BIGINT' and 'CHAR (UCS_BASIC)' are not
>>> supported. Types must be comparable. String types must also have matching
>>> collation. If collation does not match, a possible solution is t
>>> o cast operands to force them to the default collation (e.g. SELECT
>>> tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')
>>>
>>> Regards,
>>>
>>> Stefan
>>>
>>>
>>> *Gesendet:* Donnerstag, 01. Oktober 2020 um 10:56 Uhr
>>> *Von:* "Maxim Solodovnik" 
>>> *An:* "Openmeetings user-list" 
>>> *Betreff:* Re: Re: Regaining admin access to an openmeetings
>>> installation
>>> just realized
>>> the last step is easy:
>>> `UPDATE OMDBUSER.OM_USER SET
>>> PASSWORD='BERxbKlDr1P+1KOQqBnponK8VQ8SyR0Cwq61By4DOIZb5qBx7QPIXSj3DkYgKjr0XhoEKCtiY1soramoYYst/PunMXfT0H+zoOAoDpWHMGf6ZqX/KThPVGeHoQp33m7&'
>>> WHERE ID=_YOUR_ID_HERE_;`
>>>
>>> after this you can start OM and log in with password: `Q!w2e3r4t5`
>>>
>>> On Thu, 1 Oct 2020 at 15:41, Maxim Solodovnik 
>>> wrote:
>>>
 OK

 1) go to
 https://mvnrepository.com/artifact/org.apache.derby/derbytools/10.14.1.0
 2) save JAR file to ${OM_HOME}
 3) in Terminal write:
 `cd ${OM_HOME}`
 `java -cp "derbytools-10.14.1.0.jar:webapps/openmeetings/WEB-INF/lib/*"
 org.apache.derby.tools.ij`

 In the "ij >" prompt enter `connect 'jdbc:derby:openmeetings';`
 then
 `select id, login, password from OMDBUSER.OM_USER WHERE ID IN (select
 user_id from OMDBUSER.OM_USER_RIGHT WHERE OM_RIGHT = 'Admin') AND deleted =
 0;`

 you will get login of admin user/users and hash of the password

 I'll check how to change password later (day-time-job time)

 please check if instructions above works for you


 On Thu, 1 Oct 2020 at 15:15, Stefan Günther  wrote:

> Hello Maxim,
>
> according to /opt/om/README it is Version 4.0.3
>
> /opt/om/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml
>
> .
>  value="org.apache.commons.dbcp2.BasicDataSource"/>
>  value="DriverClassName=org.apache.derby.jdbc.EmbeddedDriver,Url=jdbc:derby:openmeetings;create=true,
> create=true, MaxActive=100, MaxWait=1,
> TestOnBorrow=true,Username=omdbuser,Password="/>
> ..
>
>
> Thanks for your help,
>
> Stefan
>
> *Gesendet:* Donnerstag, 01. Oktober 2020 um 09:45 Uhr
> *Von:* "Maxim Solodovnik" 
> *An:* "Openmeetings user-list" 
> *Betreff:* Re: Regaining admin access to an openmeetings installation
> Hello S

Aw: Re: Re: Re: Re: Regaining admin access to an openmeetings installation

2020-10-01 Thread Stefan Günther

Hello Maxim,

 

DEBUG 10-02 08:37:11.709 o.a.o.d.d.u.UserDao:588 [0.0-5443-exec-8] - login:: 1 users were found
DEBUG 10-02 08:37:11.728 o.a.o.d.d.u.UserDao:597 [0.0-5443-exec-8] - Password does not match: User [id=2, firstname=Johannes, lastname=Weber, login=omadmin, pictureuri=profile.jpg, deleted=false, languageId=2, add
ress=Address [id=2, country=DE, street=Landauer Straße, town=Karlsruhe, zip=76227, deleted=false, email=omad...@.eu, phone=0721xx], externalId=null, externalType=null, type=user]

How did you create the hash?

 

Regards,

 

Stefan

 
 

Gesendet: Freitag, 02. Oktober 2020 um 02:59 Uhr
Von: "Maxim Solodovnik" 
An: "Openmeetings user-list" 
Betreff: Re: Re: Re: Re: Regaining admin access to an openmeetings installation


Is this the only admin in the system?

what in the openmeetings.log during login?


 


On Fri, 2 Oct 2020 at 00:22, Stefan Günther  wrote:




Hello Maxim,

 

using the ID 2, the update was successful:

 

ID   |LOGIN      |PASSWORD 
--
2     |omadmin     |BERxbKlDr1P+1KOQqBnponK8VQ8SyR0Cwq61By4DOIZb5qBx7QPIXSj3DkYgKjr0XhoEKCtiY1soramoYYst/PunMXfT0H+zoOAoDpWHMGf6ZqX/KThPVGeHoQp33m7&

 

But I still cannot login with omadmin / Q!w2e3r4t5 (I tried it more than once).

 

Regards,

 

Stefan

 
 

Gesendet: Donnerstag, 01. Oktober 2020 um 18:03 Uhr
Von: "Maxim Solodovnik" 
An: "Openmeetings user-list" 
Betreff: Re: Re: Re: Regaining admin access to an openmeetings installation


obviously ID is numeric identificator
for ex. 1

 


On Thu, 1 Oct 2020 at 23:01, Stefan Günther  wrote:




Hi Maxim,

 

thanks a lot for your help, but let's assume the account is 'admin':

 


UPDATE OMDBUSER.OM_USER SET PASSWORD='BERxbKlDr1P+1KOQqBnponK8VQ8SyR0Cwq61By4DOIZb5qBx7QPIXSj3DkYgKjr0XhoEKCtiY1soramoYYst/PunMXfT0H+zoOAoDpWHMGf6ZqX/KThPVGeHoQp33m7&' WHERE ID='admin';

 

returns

 

ERROR 42818: Comparisons between 'BIGINT' and 'CHAR (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is t
o cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')
 

Regards,

 

Stefan

 

 

Gesendet: Donnerstag, 01. Oktober 2020 um 10:56 Uhr
Von: "Maxim Solodovnik" 
An: "Openmeetings user-list" 
Betreff: Re: Re: Regaining admin access to an openmeetings installation


just realized
the last step is easy:

`UPDATE OMDBUSER.OM_USER SET PASSWORD='BERxbKlDr1P+1KOQqBnponK8VQ8SyR0Cwq61By4DOIZb5qBx7QPIXSj3DkYgKjr0XhoEKCtiY1soramoYYst/PunMXfT0H+zoOAoDpWHMGf6ZqX/KThPVGeHoQp33m7&' WHERE ID=_YOUR_ID_HERE_;`

 

after this you can start OM and log in with password: `Q!w2e3r4t5`

 


On Thu, 1 Oct 2020 at 15:41, Maxim Solodovnik  wrote:


OK
 

1) go to https://mvnrepository.com/artifact/org.apache.derby/derbytools/10.14.1.0

2) save JAR file to ${OM_HOME}

3) in Terminal write:

`cd ${OM_HOME}`

`java -cp "derbytools-10.14.1.0.jar:webapps/openmeetings/WEB-INF/lib/*" org.apache.derby.tools.ij`

 

In the "ij >" prompt enter `connect 'jdbc:derby:openmeetings';`

then

`select id, login, password from OMDBUSER.OM_USER WHERE ID IN (select user_id from OMDBUSER.OM_USER_RIGHT WHERE OM_RIGHT = 'Admin') AND deleted = 0;`

 

you will get login of admin user/users and hash of the password

 

I'll check how to change password later (day-time-job time)

 

please check if instructions above works for you

 

 


On Thu, 1 Oct 2020 at 15:15, Stefan Günther  wrote:




Hello Maxim,

 

according to /opt/om/README it is Version 4.0.3

 

/opt/om/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml

 

.




..
 

 

Thanks for your help,

 

Stefan

 


Gesendet: Donnerstag, 01. Oktober 2020 um 09:45 Uhr
Von: "Maxim Solodovnik" 
An: "Openmeetings user-list" 
Betreff: Re: Regaining admin access to an openmeetings installation


Hello Stefan,
 

What version of Om are you using?

 

top level instructions

 

0) assuming OM is in ${OM_HOME}

1) check ${OM_HOME}/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml

here you can get DB_TYPE, DB_URL, DB_USER, DB_PASS

 

share DB type from above file with me to get next steps :))

 

 


On Thu, 1 Oct 2020 at 14:42, Stefan Günther  wrote:




Hello,

 

we have a new client who is already using openmeetings. The accounts of the employees do not have admin rights and the guy, who setup OpenMeetings did not send the credentials for the admin account and isn't reachable anymore.

 

We hav

Re: warnings...

2020-10-01 Thread Ali Alhaidary


Thank you Max, very informative, helpful and right to the point :-)


On 10/2/20 4:41 AM, Maxim Solodovnik wrote:

it seems it's my turn to answer :)))

On Thu, 1 Oct 2020 at 11:37, Ali Alhaidary 
mailto:ali.alhaid...@the5stars.org>> wrote:


NOTE: Picked up JDK_JAVA_OPTIONS:
--add-opens=java.base/java.lang=ALL-UNNAMED
--add-opens=java.base/java.io =ALL-UNNAMED
--add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED

01-Oct-2020 04:23:56.669 WARNING [main]
org.apache.tomcat.util.digester.SetPropertiesRule.begin Match
[Server/Service/Connector/SSLHostConfig/Certificate] failed to set
property [certificateVerification] to [false]
01-Oct-2020 04:23:56.675 WARNING [main]
org.apache.tomcat.util.digester.SetPropertiesRule.begin Match
[Server/Service/Connector/SSLHostConfig/Certificate] failed to set
property [sslProtocol] to [TLS]
01-Oct-2020 04:26:10.897 WARNING [main]
org.apache.catalina.util.SessionIdGeneratorBase.createSecureRandom
Creation of SecureRandom instance for session ID generation using
[SHA1PRNG] took [132,520] milliseconds.


it takes time to generate SecureRandom, you can provide faster (but 
less secure) random source

to speed up start-up:  -Djava.security.egd=file:/dev/./urandom


 [31mWARN  [0;39m 10-01 04:26:23.398 [36mo.a.o.c.r.KurentoHandler:177
[pool-1-thread-1] [0;39m - Fail to create Kurento client, will
re-try in
1 ms


Your KMS server is down


01-Oct-2020 04:26:24.485 WARNING [main]
com.hazelcast.instance.impl.HazelcastInstanceFactory.null
Hazelcast is
starting in a Java modular environment (Java 9 and newer) but without
proper access to required Java packages. Use additional Java
arguments
to provide Hazelcast access to Java internal API. The internal API
access is used to get the best performance results. Arguments to
be used:


You have to provide additional ENV variable to eliminate this one

JDK_JAVA_OPTIONS="--add-modules java.se  --add-exports 
java.base/jdk.internal.ref=ALL-UNNAMED --add-opens 
java.base/java.lang=ALL-UNNAMED --add-opens 
java.base/java.nio=ALL-UNNAMED --add-opens java.base/sun.nio.ch 
=ALL-UNNAMED --add-opens 
java.management/sun.management=ALL-UNNAMED --add-opens 
jdk.management/com.sun.management.internal=ALL-UNNAMED"



 [31mWARN  [0;39m 10-01 04:26:25.380 [36mc.h.c.CPSubsystem:67
[main] [0;39m - [10.19.0.5]:5701 [dev] [4.0.2] CP Subsystem is not
enabled. CP data structures will operate in UNSAFE mode! Please note
that UNSAFE mode will not provide strong consistency guarantees.



this is about this 
https://docs.hazelcast.org/docs/latest/javadoc/com/hazelcast/cp/CPSubsystem.html

not sure if CP need to be set-up or not
will investigate in the future (most probably)


WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by
com.hazelcast.internal.networking.nio.SelectorOptimizer
(file:/opt/rooms/webapps/openmeetings/WEB-INF/lib/hazelcast-4.0.2.jar)

to field sun.nio.ch.SelectorImpl.selectedKeys
WARNING: Please consider reporting this to the maintainers of
com.hazelcast.internal.networking.nio.SelectorOptimizer
WARNING: Use --illegal-access=warn to enable warnings of further
illegal
reflective access operations
WARNING: All illegal access operations will be denied in a future
release


this is fixed with JDK_JAVA_OPTIONS above


 [31mWARN  [0;39m 10-01 04:26:25.889  [36mc.h.i.impl.Node:67
[main] [0;39m - [10.19.0.5]:5701 [dev] [4.0.2] No join method is
enabled! Starting standalone.


you have no cluster configured



Should I be concerned by the above warnings from catalina.log please ?



--
Best regards,
Maxim

Re: Re: Re: Re: Regaining admin access to an openmeetings installation

2020-10-01 Thread Maxim Solodovnik

On Fri, 2 Oct 2020 at 09:35, seba.wag...@gmail.com 
wrote:

> Assuming you know the password of another user
> => You could also construct a SQL to increase the permission level of any
> existing user and promote that one to admin level.
>

yep
something like this:

INSERT OMDBUSER.OM_USER_RIGHT (user_id, OM_RIGHT) VALUES
(_ID_OF_YOUR_USER_, 'Admin');


>
> Cheers
> Seb
>
> Sebastian Wagner
> Director Arrakeen Solutions
> http://arrakeen-solutions.co.nz/
>
> 
> 
>
>
> On Fri, 2 Oct 2020 at 14:00, Maxim Solodovnik 
> wrote:
>
>> Is this the only admin in the system?
>> what in the openmeetings.log during login?
>>
>> On Fri, 2 Oct 2020 at 00:22, Stefan Günther  wrote:
>>
>>> Hello Maxim,
>>>
>>> using the ID 2, the update was successful:
>>>
>>> ID   |LOGIN  |PASSWORD
>>>
>>>
>>> --
>>> 2 |omadmin
>>>  
>>> |BERxbKlDr1P+1KOQqBnponK8VQ8SyR0Cwq61By4DOIZb5qBx7QPIXSj3DkYgKjr0XhoEKCtiY1soramoYYst/PunMXfT0H+zoOAoDpWHMGf6ZqX/KThPVGeHoQp33m7&
>>>
>>>
>>> But I still cannot login with omadmin / Q!w2e3r4t5 (I tried it more than
>>> once).
>>>
>>> Regards,
>>>
>>> Stefan
>>>
>>>
>>> *Gesendet:* Donnerstag, 01. Oktober 2020 um 18:03 Uhr
>>> *Von:* "Maxim Solodovnik" 
>>> *An:* "Openmeetings user-list" 
>>> *Betreff:* Re: Re: Re: Regaining admin access to an openmeetings
>>> installation
>>> obviously ID is numeric identificator
>>> for ex. 1
>>>
>>> On Thu, 1 Oct 2020 at 23:01, Stefan Günther  wrote:
>>>
 Hi Maxim,

 thanks a lot for your help, but let's assume the account is 'admin':

 UPDATE OMDBUSER.OM_USER SET
 PASSWORD='BERxbKlDr1P+1KOQqBnponK8VQ8SyR0Cwq61By4DOIZb5qBx7QPIXSj3DkYgKjr0XhoEKCtiY1soramoYYst/PunMXfT0H+zoOAoDpWHMGf6ZqX/KThPVGeHoQp33m7&'
 WHERE ID='admin';

 returns

 ERROR 42818: Comparisons between 'BIGINT' and 'CHAR (UCS_BASIC)' are
 not supported. Types must be comparable. String types must also have
 matching collation. If collation does not match, a possible solution is t
 o cast operands to force them to the default collation (e.g. SELECT
 tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')

 Regards,

 Stefan


 *Gesendet:* Donnerstag, 01. Oktober 2020 um 10:56 Uhr
 *Von:* "Maxim Solodovnik" 
 *An:* "Openmeetings user-list" 
 *Betreff:* Re: Re: Regaining admin access to an openmeetings
 installation
 just realized
 the last step is easy:
 `UPDATE OMDBUSER.OM_USER SET
 PASSWORD='BERxbKlDr1P+1KOQqBnponK8VQ8SyR0Cwq61By4DOIZb5qBx7QPIXSj3DkYgKjr0XhoEKCtiY1soramoYYst/PunMXfT0H+zoOAoDpWHMGf6ZqX/KThPVGeHoQp33m7&'
 WHERE ID=_YOUR_ID_HERE_;`

 after this you can start OM and log in with password: `Q!w2e3r4t5`

 On Thu, 1 Oct 2020 at 15:41, Maxim Solodovnik 
 wrote:

> OK
>
> 1) go to
> https://mvnrepository.com/artifact/org.apache.derby/derbytools/10.14.1.0
> 2) save JAR file to ${OM_HOME}
> 3) in Terminal write:
> `cd ${OM_HOME}`
> `java -cp
> "derbytools-10.14.1.0.jar:webapps/openmeetings/WEB-INF/lib/*"
> org.apache.derby.tools.ij`
>
> In the "ij >" prompt enter `connect 'jdbc:derby:openmeetings';`
> then
> `select id, login, password from OMDBUSER.OM_USER WHERE ID IN (select
> user_id from OMDBUSER.OM_USER_RIGHT WHERE OM_RIGHT = 'Admin') AND deleted 
> =
> 0;`
>
> you will get login of admin user/users and hash of the password
>
> I'll check how to change password later (day-time-job time)
>
> please check if instructions above works for you
>
>
> On Thu, 1 Oct 2020 at 15:15, Stefan Günther  wrote:
>
>> Hello Maxim,
>>
>> according to /opt/om/README it is Version 4.0.3
>>
>> /opt/om/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml
>>
>> .
>> > value="org.apache.commons.dbcp2.BasicDataSource"/>
>> > value="DriverClassName=org.apache.derby.jdbc.EmbeddedDriver,Url=jdbc:derby:openmeetings;create=true,
>> create=true, MaxActive=100, MaxWait=1,
>> TestOnBorrow=true,Username=omdbuser,Password="/>
>> ..
>>
>>
>> Thanks for your help,
>>
>> Stefan
>>
>> *Gesendet:* Donnerstag, 01. Oktober 2020 um 09:45 Uhr
>> *Von:* "Maxim Solodovnik" 
>> *An:* "Openmeetings user-list" 
>> *Betreff:* Re: Regaining admin access to an openmeetings installation
>> Hello Stefan,
>>
>> What version of Om are you using?
>>
>> top level instructions
>>
>> 0) assuming OM is in ${OM_HOME}
>> 1)
>> check 
>> ${OM_HOME}/webapps/openmeetings/WEB-INF/classes/META-I

Re: Re: Re: Re: Regaining admin access to an openmeetings installation

2020-10-01 Thread seba.wag...@gmail.com

Assuming you know the password of another user
=> You could also construct a SQL to increase the permission level of any
existing user and promote that one to admin level.

Cheers
Seb

Sebastian Wagner
Director Arrakeen Solutions
http://arrakeen-solutions.co.nz/




On Fri, 2 Oct 2020 at 14:00, Maxim Solodovnik  wrote:

> Is this the only admin in the system?
> what in the openmeetings.log during login?
>
> On Fri, 2 Oct 2020 at 00:22, Stefan Günther  wrote:
>
>> Hello Maxim,
>>
>> using the ID 2, the update was successful:
>>
>> ID   |LOGIN  |PASSWORD
>>
>>
>> --
>> 2 |omadmin
>>  
>> |BERxbKlDr1P+1KOQqBnponK8VQ8SyR0Cwq61By4DOIZb5qBx7QPIXSj3DkYgKjr0XhoEKCtiY1soramoYYst/PunMXfT0H+zoOAoDpWHMGf6ZqX/KThPVGeHoQp33m7&
>>
>>
>> But I still cannot login with omadmin / Q!w2e3r4t5 (I tried it more than
>> once).
>>
>> Regards,
>>
>> Stefan
>>
>>
>> *Gesendet:* Donnerstag, 01. Oktober 2020 um 18:03 Uhr
>> *Von:* "Maxim Solodovnik" 
>> *An:* "Openmeetings user-list" 
>> *Betreff:* Re: Re: Re: Regaining admin access to an openmeetings
>> installation
>> obviously ID is numeric identificator
>> for ex. 1
>>
>> On Thu, 1 Oct 2020 at 23:01, Stefan Günther  wrote:
>>
>>> Hi Maxim,
>>>
>>> thanks a lot for your help, but let's assume the account is 'admin':
>>>
>>> UPDATE OMDBUSER.OM_USER SET
>>> PASSWORD='BERxbKlDr1P+1KOQqBnponK8VQ8SyR0Cwq61By4DOIZb5qBx7QPIXSj3DkYgKjr0XhoEKCtiY1soramoYYst/PunMXfT0H+zoOAoDpWHMGf6ZqX/KThPVGeHoQp33m7&'
>>> WHERE ID='admin';
>>>
>>> returns
>>>
>>> ERROR 42818: Comparisons between 'BIGINT' and 'CHAR (UCS_BASIC)' are not
>>> supported. Types must be comparable. String types must also have matching
>>> collation. If collation does not match, a possible solution is t
>>> o cast operands to force them to the default collation (e.g. SELECT
>>> tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')
>>>
>>> Regards,
>>>
>>> Stefan
>>>
>>>
>>> *Gesendet:* Donnerstag, 01. Oktober 2020 um 10:56 Uhr
>>> *Von:* "Maxim Solodovnik" 
>>> *An:* "Openmeetings user-list" 
>>> *Betreff:* Re: Re: Regaining admin access to an openmeetings
>>> installation
>>> just realized
>>> the last step is easy:
>>> `UPDATE OMDBUSER.OM_USER SET
>>> PASSWORD='BERxbKlDr1P+1KOQqBnponK8VQ8SyR0Cwq61By4DOIZb5qBx7QPIXSj3DkYgKjr0XhoEKCtiY1soramoYYst/PunMXfT0H+zoOAoDpWHMGf6ZqX/KThPVGeHoQp33m7&'
>>> WHERE ID=_YOUR_ID_HERE_;`
>>>
>>> after this you can start OM and log in with password: `Q!w2e3r4t5`
>>>
>>> On Thu, 1 Oct 2020 at 15:41, Maxim Solodovnik 
>>> wrote:
>>>
 OK

 1) go to
 https://mvnrepository.com/artifact/org.apache.derby/derbytools/10.14.1.0
 2) save JAR file to ${OM_HOME}
 3) in Terminal write:
 `cd ${OM_HOME}`
 `java -cp "derbytools-10.14.1.0.jar:webapps/openmeetings/WEB-INF/lib/*"
 org.apache.derby.tools.ij`

 In the "ij >" prompt enter `connect 'jdbc:derby:openmeetings';`
 then
 `select id, login, password from OMDBUSER.OM_USER WHERE ID IN (select
 user_id from OMDBUSER.OM_USER_RIGHT WHERE OM_RIGHT = 'Admin') AND deleted =
 0;`

 you will get login of admin user/users and hash of the password

 I'll check how to change password later (day-time-job time)

 please check if instructions above works for you


 On Thu, 1 Oct 2020 at 15:15, Stefan Günther  wrote:

> Hello Maxim,
>
> according to /opt/om/README it is Version 4.0.3
>
> /opt/om/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml
>
> .
>  value="org.apache.commons.dbcp2.BasicDataSource"/>
>  value="DriverClassName=org.apache.derby.jdbc.EmbeddedDriver,Url=jdbc:derby:openmeetings;create=true,
> create=true, MaxActive=100, MaxWait=1,
> TestOnBorrow=true,Username=omdbuser,Password="/>
> ..
>
>
> Thanks for your help,
>
> Stefan
>
> *Gesendet:* Donnerstag, 01. Oktober 2020 um 09:45 Uhr
> *Von:* "Maxim Solodovnik" 
> *An:* "Openmeetings user-list" 
> *Betreff:* Re: Regaining admin access to an openmeetings installation
> Hello Stefan,
>
> What version of Om are you using?
>
> top level instructions
>
> 0) assuming OM is in ${OM_HOME}
> 1)
> check 
> ${OM_HOME}/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml
> here you can get DB_TYPE, DB_URL, DB_USER, DB_PASS
>
> share DB type from above file with me to get next steps :))
>
>
> On Thu, 1 Oct 2020 at 14:42, Stefan Günther  wrote:
>
>> Hello,
>>
>> we have a new client who is already using openmeetings. The accounts
>> of the employees do not ha

Re: warnings...

2020-10-01 Thread Maxim Solodovnik

it seems it's my turn to answer :)))

On Thu, 1 Oct 2020 at 11:37, Ali Alhaidary 
wrote:

> NOTE: Picked up JDK_JAVA_OPTIONS:
> --add-opens=java.base/java.lang=ALL-UNNAMED
> --add-opens=java.base/java.io=ALL-UNNAMED
> --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED
>
> 01-Oct-2020 04:23:56.669 WARNING [main]
> org.apache.tomcat.util.digester.SetPropertiesRule.begin Match
> [Server/Service/Connector/SSLHostConfig/Certificate] failed to set
> property [certificateVerification] to [false]
> 01-Oct-2020 04:23:56.675 WARNING [main]
> org.apache.tomcat.util.digester.SetPropertiesRule.begin Match
> [Server/Service/Connector/SSLHostConfig/Certificate] failed to set
> property [sslProtocol] to [TLS]
> 01-Oct-2020 04:26:10.897 WARNING [main]
> org.apache.catalina.util.SessionIdGeneratorBase.createSecureRandom
> Creation of SecureRandom instance for session ID generation using
> [SHA1PRNG] took [132,520] milliseconds.
>

it takes time to generate SecureRandom, you can provide faster (but less
secure) random source
to speed up start-up:   -Djava.security.egd=file:/dev/./urandom


>
>  [31mWARN  [0;39m 10-01 04:26:23.398  [36mo.a.o.c.r.KurentoHandler:177
> [pool-1-thread-1] [0;39m - Fail to create Kurento client, will re-try in
> 1 ms
>

Your KMS server is down


>
> 01-Oct-2020 04:26:24.485 WARNING [main]
> com.hazelcast.instance.impl.HazelcastInstanceFactory.null Hazelcast is
> starting in a Java modular environment (Java 9 and newer) but without
> proper access to required Java packages. Use additional Java arguments
> to provide Hazelcast access to Java internal API. The internal API
> access is used to get the best performance results. Arguments to be used:
>

You have to provide additional ENV variable to eliminate this one

JDK_JAVA_OPTIONS="--add-modules java.se --add-exports
java.base/jdk.internal.ref=ALL-UNNAMED --add-opens
java.base/java.lang=ALL-UNNAMED --add-opens java.base/java.nio=ALL-UNNAMED
--add-opens java.base/sun.nio.ch=ALL-UNNAMED --add-opens
java.management/sun.management=ALL-UNNAMED --add-opens
jdk.management/com.sun.management.internal=ALL-UNNAMED"


>
>  [31mWARN  [0;39m 10-01 04:26:25.380  [36mc.h.c.CPSubsystem:67
> [main] [0;39m - [10.19.0.5]:5701 [dev] [4.0.2] CP Subsystem is not
> enabled. CP data structures will operate in UNSAFE mode! Please note
> that UNSAFE mode will not provide strong consistency guarantees.
>


this is about this
https://docs.hazelcast.org/docs/latest/javadoc/com/hazelcast/cp/CPSubsystem.html
not sure if CP need to be set-up or not
will investigate in the future (most probably)


>
> WARNING: An illegal reflective access operation has occurred
> WARNING: Illegal reflective access by
> com.hazelcast.internal.networking.nio.SelectorOptimizer
> (file:/opt/rooms/webapps/openmeetings/WEB-INF/lib/hazelcast-4.0.2.jar)
> to field sun.nio.ch.SelectorImpl.selectedKeys
> WARNING: Please consider reporting this to the maintainers of
> com.hazelcast.internal.networking.nio.SelectorOptimizer
> WARNING: Use --illegal-access=warn to enable warnings of further illegal
> reflective access operations
> WARNING: All illegal access operations will be denied in a future release
>

this is fixed with JDK_JAVA_OPTIONS above


>
>  [31mWARN  [0;39m 10-01 04:26:25.889  [36mc.h.i.impl.Node:67
> [main] [0;39m - [10.19.0.5]:5701 [dev] [4.0.2] No join method is
> enabled! Starting standalone.
>

you have no cluster configured


>
>
> Should I be concerned by the above warnings from catalina.log please ?
>
>

-- 
Best regards,
Maxim

Re: Upgrading from OM 5 M4

2020-10-01 Thread Maxim Solodovnik

Hello Denis,

On Fri, 2 Oct 2020 at 05:58, Denis Noctor  wrote:

> Hi there Maxim,
>
> Are there a lot of differences between OM 5 M4 and OM 5.0.1 and current
> snapshots (regarding general architecture)?
>

Yes you have to do import/export
You can create the new DB (or backup previous DB) to be able to switch back
any time


>
> As I mentioned in previous emails (regarding the mute issue). I did such
> an upgrade but am starting to see a few glitches that I cannot emulate on
> the demo servers. Users can see and hear some users but not all and vice
> versa... and seems a little random.


I doubt this can be caused by DB changes
this behavior was observed on early versions and was caused by the fact
users were not notified on their connection issues

i.e. user A saw his/her picture and was sure everything is Ok with his/her
AV streaming while it was broken
Now connection state is monitored to ensure everything is OK


>I am aware of the whole turnserver side of things and I had this
> working great on OM 5 M4... and I purged and reinstalled Imagemagick to
> address the file conversion problem... but I am wondering if simply
> upgrading from M4 to OM 5.0.1 is not the way forward. For example, I
> reimported my a database recently from OM 5 M4 and that’s when things
> started to go a little odd. I assume that the DB structure is different in
> 5.0.1 +?
>
> As strange as it sounds... it appears that users that were imported from
> the old DB don’t “ appear “ to have “major” (the occasional refresh is
> required) connectivity issues regarding cams and mics... but most of the
> new users that were added do. 😳 I think I will reinstall afresh... and
> repopulate the DB manually and see if that makes a difference.
>

this part I didn't get :(


>
> Before I do I was wondering if anyone was in the same boat etc.
>
> All the best,
>
> Denis
>
> Sent from my iPhone



-- 
Best regards,
Maxim

Re: Re: Re: Re: Regaining admin access to an openmeetings installation

2020-10-01 Thread Maxim Solodovnik

Is this the only admin in the system?
what in the openmeetings.log during login?

On Fri, 2 Oct 2020 at 00:22, Stefan Günther  wrote:

> Hello Maxim,
>
> using the ID 2, the update was successful:
>
> ID   |LOGIN  |PASSWORD
>
>
> --
> 2 |omadmin
>  
> |BERxbKlDr1P+1KOQqBnponK8VQ8SyR0Cwq61By4DOIZb5qBx7QPIXSj3DkYgKjr0XhoEKCtiY1soramoYYst/PunMXfT0H+zoOAoDpWHMGf6ZqX/KThPVGeHoQp33m7&
>
>
> But I still cannot login with omadmin / Q!w2e3r4t5 (I tried it more than
> once).
>
> Regards,
>
> Stefan
>
>
> *Gesendet:* Donnerstag, 01. Oktober 2020 um 18:03 Uhr
> *Von:* "Maxim Solodovnik" 
> *An:* "Openmeetings user-list" 
> *Betreff:* Re: Re: Re: Regaining admin access to an openmeetings
> installation
> obviously ID is numeric identificator
> for ex. 1
>
> On Thu, 1 Oct 2020 at 23:01, Stefan Günther  wrote:
>
>> Hi Maxim,
>>
>> thanks a lot for your help, but let's assume the account is 'admin':
>>
>> UPDATE OMDBUSER.OM_USER SET
>> PASSWORD='BERxbKlDr1P+1KOQqBnponK8VQ8SyR0Cwq61By4DOIZb5qBx7QPIXSj3DkYgKjr0XhoEKCtiY1soramoYYst/PunMXfT0H+zoOAoDpWHMGf6ZqX/KThPVGeHoQp33m7&'
>> WHERE ID='admin';
>>
>> returns
>>
>> ERROR 42818: Comparisons between 'BIGINT' and 'CHAR (UCS_BASIC)' are not
>> supported. Types must be comparable. String types must also have matching
>> collation. If collation does not match, a possible solution is t
>> o cast operands to force them to the default collation (e.g. SELECT
>> tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')
>>
>> Regards,
>>
>> Stefan
>>
>>
>> *Gesendet:* Donnerstag, 01. Oktober 2020 um 10:56 Uhr
>> *Von:* "Maxim Solodovnik" 
>> *An:* "Openmeetings user-list" 
>> *Betreff:* Re: Re: Regaining admin access to an openmeetings installation
>> just realized
>> the last step is easy:
>> `UPDATE OMDBUSER.OM_USER SET
>> PASSWORD='BERxbKlDr1P+1KOQqBnponK8VQ8SyR0Cwq61By4DOIZb5qBx7QPIXSj3DkYgKjr0XhoEKCtiY1soramoYYst/PunMXfT0H+zoOAoDpWHMGf6ZqX/KThPVGeHoQp33m7&'
>> WHERE ID=_YOUR_ID_HERE_;`
>>
>> after this you can start OM and log in with password: `Q!w2e3r4t5`
>>
>> On Thu, 1 Oct 2020 at 15:41, Maxim Solodovnik 
>> wrote:
>>
>>> OK
>>>
>>> 1) go to
>>> https://mvnrepository.com/artifact/org.apache.derby/derbytools/10.14.1.0
>>> 2) save JAR file to ${OM_HOME}
>>> 3) in Terminal write:
>>> `cd ${OM_HOME}`
>>> `java -cp "derbytools-10.14.1.0.jar:webapps/openmeetings/WEB-INF/lib/*"
>>> org.apache.derby.tools.ij`
>>>
>>> In the "ij >" prompt enter `connect 'jdbc:derby:openmeetings';`
>>> then
>>> `select id, login, password from OMDBUSER.OM_USER WHERE ID IN (select
>>> user_id from OMDBUSER.OM_USER_RIGHT WHERE OM_RIGHT = 'Admin') AND deleted =
>>> 0;`
>>>
>>> you will get login of admin user/users and hash of the password
>>>
>>> I'll check how to change password later (day-time-job time)
>>>
>>> please check if instructions above works for you
>>>
>>>
>>> On Thu, 1 Oct 2020 at 15:15, Stefan Günther  wrote:
>>>
 Hello Maxim,

 according to /opt/om/README it is Version 4.0.3

 /opt/om/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml

 .
 >>> value="org.apache.commons.dbcp2.BasicDataSource"/>
 >>> value="DriverClassName=org.apache.derby.jdbc.EmbeddedDriver,Url=jdbc:derby:openmeetings;create=true,
 create=true, MaxActive=100, MaxWait=1,
 TestOnBorrow=true,Username=omdbuser,Password="/>
 ..


 Thanks for your help,

 Stefan

 *Gesendet:* Donnerstag, 01. Oktober 2020 um 09:45 Uhr
 *Von:* "Maxim Solodovnik" 
 *An:* "Openmeetings user-list" 
 *Betreff:* Re: Regaining admin access to an openmeetings installation
 Hello Stefan,

 What version of Om are you using?

 top level instructions

 0) assuming OM is in ${OM_HOME}
 1)
 check 
 ${OM_HOME}/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml
 here you can get DB_TYPE, DB_URL, DB_USER, DB_PASS

 share DB type from above file with me to get next steps :))


 On Thu, 1 Oct 2020 at 14:42, Stefan Günther  wrote:

> Hello,
>
> we have a new client who is already using openmeetings. The accounts
> of the employees do not have admin rights and the guy, who setup
> OpenMeetings did not send the credentials for the admin account and isn't
> reachable anymore.
>
> We have access to the command line of the Ubuntu system and since
> there is no mysql db for openmeeting we assume that it is a setup with
> Apache Derby.
>
> How can we find out the name of the admin account and how can we reset
> its password?
>
> Thanks for any help or suggestions,
>
> Regards,
>
> Stefan
>


 --
 Best regards,
 Maxim

>>>
>>>
>>> --
>>> Best regards,
>>> Maxim
>>>
>>
>>
>> --
>> Best reg

Upgrading from OM 5 M4

2020-10-01 Thread Denis Noctor

Hi there Maxim,

Are there a lot of differences between OM 5 M4 and OM 5.0.1 and current 
snapshots (regarding general architecture)?

As I mentioned in previous emails (regarding the mute issue). I did such an 
upgrade but am starting to see a few glitches that I cannot emulate on the demo 
servers. Users can see and hear some users but not all and vice versa... and 
seems a little random.   I am aware of the whole turnserver side of things and 
I had this working great on OM 5 M4... and I purged and reinstalled Imagemagick 
to address the file conversion problem... but I am wondering if simply 
upgrading from M4 to OM 5.0.1 is not the way forward. For example, I reimported 
my a database recently from OM 5 M4 and that’s when things started to go a 
little odd. I assume that the DB structure is different in 5.0.1 +?

As strange as it sounds... it appears that users that were imported from the 
old DB don’t “ appear “ to have “major” (the occasional refresh is required) 
connectivity issues regarding cams and mics... but most of the new users that 
were added do. 😳 I think I will reinstall afresh... and repopulate the DB 
manually and see if that makes a difference.

Before I do I was wondering if anyone was in the same boat etc.

All the best,

Denis

Sent from my iPhone

Aw: Re: Re: Re: Regaining admin access to an openmeetings installation

2020-10-01 Thread Stefan Günther

Hello Maxim,

 

using the ID 2, the update was successful:

 

ID   |LOGIN      |PASSWORD 
--
2     |omadmin     |BERxbKlDr1P+1KOQqBnponK8VQ8SyR0Cwq61By4DOIZb5qBx7QPIXSj3DkYgKjr0XhoEKCtiY1soramoYYst/PunMXfT0H+zoOAoDpWHMGf6ZqX/KThPVGeHoQp33m7&

 

But I still cannot login with omadmin / Q!w2e3r4t5 (I tried it more than once).

 

Regards,

 

Stefan

 
 

Gesendet: Donnerstag, 01. Oktober 2020 um 18:03 Uhr
Von: "Maxim Solodovnik" 
An: "Openmeetings user-list" 
Betreff: Re: Re: Re: Regaining admin access to an openmeetings installation


obviously ID is numeric identificator
for ex. 1

 


On Thu, 1 Oct 2020 at 23:01, Stefan Günther  wrote:




Hi Maxim,

 

thanks a lot for your help, but let's assume the account is 'admin':

 


UPDATE OMDBUSER.OM_USER SET PASSWORD='BERxbKlDr1P+1KOQqBnponK8VQ8SyR0Cwq61By4DOIZb5qBx7QPIXSj3DkYgKjr0XhoEKCtiY1soramoYYst/PunMXfT0H+zoOAoDpWHMGf6ZqX/KThPVGeHoQp33m7&' WHERE ID='admin';

 

returns

 

ERROR 42818: Comparisons between 'BIGINT' and 'CHAR (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is t
o cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')
 

Regards,

 

Stefan

 

 

Gesendet: Donnerstag, 01. Oktober 2020 um 10:56 Uhr
Von: "Maxim Solodovnik" 
An: "Openmeetings user-list" 
Betreff: Re: Re: Regaining admin access to an openmeetings installation


just realized
the last step is easy:

`UPDATE OMDBUSER.OM_USER SET PASSWORD='BERxbKlDr1P+1KOQqBnponK8VQ8SyR0Cwq61By4DOIZb5qBx7QPIXSj3DkYgKjr0XhoEKCtiY1soramoYYst/PunMXfT0H+zoOAoDpWHMGf6ZqX/KThPVGeHoQp33m7&' WHERE ID=_YOUR_ID_HERE_;`

 

after this you can start OM and log in with password: `Q!w2e3r4t5`

 


On Thu, 1 Oct 2020 at 15:41, Maxim Solodovnik  wrote:


OK
 

1) go to https://mvnrepository.com/artifact/org.apache.derby/derbytools/10.14.1.0

2) save JAR file to ${OM_HOME}

3) in Terminal write:

`cd ${OM_HOME}`

`java -cp "derbytools-10.14.1.0.jar:webapps/openmeetings/WEB-INF/lib/*" org.apache.derby.tools.ij`

 

In the "ij >" prompt enter `connect 'jdbc:derby:openmeetings';`

then

`select id, login, password from OMDBUSER.OM_USER WHERE ID IN (select user_id from OMDBUSER.OM_USER_RIGHT WHERE OM_RIGHT = 'Admin') AND deleted = 0;`

 

you will get login of admin user/users and hash of the password

 

I'll check how to change password later (day-time-job time)

 

please check if instructions above works for you

 

 


On Thu, 1 Oct 2020 at 15:15, Stefan Günther  wrote:




Hello Maxim,

 

according to /opt/om/README it is Version 4.0.3

 

/opt/om/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml

 

.




..
 

 

Thanks for your help,

 

Stefan

 


Gesendet: Donnerstag, 01. Oktober 2020 um 09:45 Uhr
Von: "Maxim Solodovnik" 
An: "Openmeetings user-list" 
Betreff: Re: Regaining admin access to an openmeetings installation


Hello Stefan,
 

What version of Om are you using?

 

top level instructions

 

0) assuming OM is in ${OM_HOME}

1) check ${OM_HOME}/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml

here you can get DB_TYPE, DB_URL, DB_USER, DB_PASS

 

share DB type from above file with me to get next steps :))

 

 


On Thu, 1 Oct 2020 at 14:42, Stefan Günther  wrote:




Hello,

 

we have a new client who is already using openmeetings. The accounts of the employees do not have admin rights and the guy, who setup OpenMeetings did not send the credentials for the admin account and isn't reachable anymore.

 

We have access to the command line of the Ubuntu system and since there is no mysql db for openmeeting we assume that it is a setup with Apache Derby.

 

How can we find out the name of the admin account and how can we reset its password?

 

Thanks for any help or suggestions,

 

Regards,

 

Stefan




 

 
--



Best regards,
Maxim










 

 
--



Best regards,
Maxim




 

 
--



Best regards,
Maxim










 

 
--



Best regards,
Maxim

Re: Re: Re: Regaining admin access to an openmeetings installation

2020-10-01 Thread Maxim Solodovnik

obviously ID is numeric identificator
for ex. 1

On Thu, 1 Oct 2020 at 23:01, Stefan Günther  wrote:

> Hi Maxim,
>
> thanks a lot for your help, but let's assume the account is 'admin':
>
> UPDATE OMDBUSER.OM_USER SET
> PASSWORD='BERxbKlDr1P+1KOQqBnponK8VQ8SyR0Cwq61By4DOIZb5qBx7QPIXSj3DkYgKjr0XhoEKCtiY1soramoYYst/PunMXfT0H+zoOAoDpWHMGf6ZqX/KThPVGeHoQp33m7&'
> WHERE ID='admin';
>
> returns
>
> ERROR 42818: Comparisons between 'BIGINT' and 'CHAR (UCS_BASIC)' are not
> supported. Types must be comparable. String types must also have matching
> collation. If collation does not match, a possible solution is t
> o cast operands to force them to the default collation (e.g. SELECT
> tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')
>
> Regards,
>
> Stefan
>
>
> *Gesendet:* Donnerstag, 01. Oktober 2020 um 10:56 Uhr
> *Von:* "Maxim Solodovnik" 
> *An:* "Openmeetings user-list" 
> *Betreff:* Re: Re: Regaining admin access to an openmeetings installation
> just realized
> the last step is easy:
> `UPDATE OMDBUSER.OM_USER SET
> PASSWORD='BERxbKlDr1P+1KOQqBnponK8VQ8SyR0Cwq61By4DOIZb5qBx7QPIXSj3DkYgKjr0XhoEKCtiY1soramoYYst/PunMXfT0H+zoOAoDpWHMGf6ZqX/KThPVGeHoQp33m7&'
> WHERE ID=_YOUR_ID_HERE_;`
>
> after this you can start OM and log in with password: `Q!w2e3r4t5`
>
> On Thu, 1 Oct 2020 at 15:41, Maxim Solodovnik 
> wrote:
>
>> OK
>>
>> 1) go to
>> https://mvnrepository.com/artifact/org.apache.derby/derbytools/10.14.1.0
>> 2) save JAR file to ${OM_HOME}
>> 3) in Terminal write:
>> `cd ${OM_HOME}`
>> `java -cp "derbytools-10.14.1.0.jar:webapps/openmeetings/WEB-INF/lib/*"
>> org.apache.derby.tools.ij`
>>
>> In the "ij >" prompt enter `connect 'jdbc:derby:openmeetings';`
>> then
>> `select id, login, password from OMDBUSER.OM_USER WHERE ID IN (select
>> user_id from OMDBUSER.OM_USER_RIGHT WHERE OM_RIGHT = 'Admin') AND deleted =
>> 0;`
>>
>> you will get login of admin user/users and hash of the password
>>
>> I'll check how to change password later (day-time-job time)
>>
>> please check if instructions above works for you
>>
>>
>> On Thu, 1 Oct 2020 at 15:15, Stefan Günther  wrote:
>>
>>> Hello Maxim,
>>>
>>> according to /opt/om/README it is Version 4.0.3
>>>
>>> /opt/om/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml
>>>
>>> .
>>> >> value="org.apache.commons.dbcp2.BasicDataSource"/>
>>> >> value="DriverClassName=org.apache.derby.jdbc.EmbeddedDriver,Url=jdbc:derby:openmeetings;create=true,
>>> create=true, MaxActive=100, MaxWait=1,
>>> TestOnBorrow=true,Username=omdbuser,Password="/>
>>> ..
>>>
>>>
>>> Thanks for your help,
>>>
>>> Stefan
>>>
>>> *Gesendet:* Donnerstag, 01. Oktober 2020 um 09:45 Uhr
>>> *Von:* "Maxim Solodovnik" 
>>> *An:* "Openmeetings user-list" 
>>> *Betreff:* Re: Regaining admin access to an openmeetings installation
>>> Hello Stefan,
>>>
>>> What version of Om are you using?
>>>
>>> top level instructions
>>>
>>> 0) assuming OM is in ${OM_HOME}
>>> 1)
>>> check 
>>> ${OM_HOME}/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml
>>> here you can get DB_TYPE, DB_URL, DB_USER, DB_PASS
>>>
>>> share DB type from above file with me to get next steps :))
>>>
>>>
>>> On Thu, 1 Oct 2020 at 14:42, Stefan Günther  wrote:
>>>
 Hello,

 we have a new client who is already using openmeetings. The accounts of
 the employees do not have admin rights and the guy, who setup OpenMeetings
 did not send the credentials for the admin account and isn't reachable
 anymore.

 We have access to the command line of the Ubuntu system and since there
 is no mysql db for openmeeting we assume that it is a setup with Apache
 Derby.

 How can we find out the name of the admin account and how can we reset
 its password?

 Thanks for any help or suggestions,

 Regards,

 Stefan

>>>
>>>
>>> --
>>> Best regards,
>>> Maxim
>>>
>>
>>
>> --
>> Best regards,
>> Maxim
>>
>
>
> --
> Best regards,
> Maxim
>


-- 
Best regards,
Maxim

Aw: Re: Re: Regaining admin access to an openmeetings installation

2020-10-01 Thread Stefan Günther

Hi Maxim,

 

thanks a lot for your help, but let's assume the account is 'admin':

 


UPDATE OMDBUSER.OM_USER SET PASSWORD='BERxbKlDr1P+1KOQqBnponK8VQ8SyR0Cwq61By4DOIZb5qBx7QPIXSj3DkYgKjr0XhoEKCtiY1soramoYYst/PunMXfT0H+zoOAoDpWHMGf6ZqX/KThPVGeHoQp33m7&' WHERE ID='admin';

 

returns

 

ERROR 42818: Comparisons between 'BIGINT' and 'CHAR (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is t
o cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')
 

Regards,

 

Stefan

 

 

Gesendet: Donnerstag, 01. Oktober 2020 um 10:56 Uhr
Von: "Maxim Solodovnik" 
An: "Openmeetings user-list" 
Betreff: Re: Re: Regaining admin access to an openmeetings installation


just realized
the last step is easy:

`UPDATE OMDBUSER.OM_USER SET PASSWORD='BERxbKlDr1P+1KOQqBnponK8VQ8SyR0Cwq61By4DOIZb5qBx7QPIXSj3DkYgKjr0XhoEKCtiY1soramoYYst/PunMXfT0H+zoOAoDpWHMGf6ZqX/KThPVGeHoQp33m7&' WHERE ID=_YOUR_ID_HERE_;`

 

after this you can start OM and log in with password: `Q!w2e3r4t5`

 


On Thu, 1 Oct 2020 at 15:41, Maxim Solodovnik  wrote:


OK
 

1) go to https://mvnrepository.com/artifact/org.apache.derby/derbytools/10.14.1.0

2) save JAR file to ${OM_HOME}

3) in Terminal write:

`cd ${OM_HOME}`

`java -cp "derbytools-10.14.1.0.jar:webapps/openmeetings/WEB-INF/lib/*" org.apache.derby.tools.ij`

 

In the "ij >" prompt enter `connect 'jdbc:derby:openmeetings';`

then

`select id, login, password from OMDBUSER.OM_USER WHERE ID IN (select user_id from OMDBUSER.OM_USER_RIGHT WHERE OM_RIGHT = 'Admin') AND deleted = 0;`

 

you will get login of admin user/users and hash of the password

 

I'll check how to change password later (day-time-job time)

 

please check if instructions above works for you

 

 


On Thu, 1 Oct 2020 at 15:15, Stefan Günther  wrote:




Hello Maxim,

 

according to /opt/om/README it is Version 4.0.3

 

/opt/om/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml

 

.




..
 

 

Thanks for your help,

 

Stefan

 


Gesendet: Donnerstag, 01. Oktober 2020 um 09:45 Uhr
Von: "Maxim Solodovnik" 
An: "Openmeetings user-list" 
Betreff: Re: Regaining admin access to an openmeetings installation


Hello Stefan,
 

What version of Om are you using?

 

top level instructions

 

0) assuming OM is in ${OM_HOME}

1) check ${OM_HOME}/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml

here you can get DB_TYPE, DB_URL, DB_USER, DB_PASS

 

share DB type from above file with me to get next steps :))

 

 


On Thu, 1 Oct 2020 at 14:42, Stefan Günther  wrote:




Hello,

 

we have a new client who is already using openmeetings. The accounts of the employees do not have admin rights and the guy, who setup OpenMeetings did not send the credentials for the admin account and isn't reachable anymore.

 

We have access to the command line of the Ubuntu system and since there is no mysql db for openmeeting we assume that it is a setup with Apache Derby.

 

How can we find out the name of the admin account and how can we reset its password?

 

Thanks for any help or suggestions,

 

Regards,

 

Stefan




 

 
--



Best regards,
Maxim










 

 
--



Best regards,
Maxim




 

 
--



Best regards,
Maxim

Re: Re: Regaining admin access to an openmeetings installation

2020-10-01 Thread Maxim Solodovnik

just realized
the last step is easy:
`UPDATE OMDBUSER.OM_USER SET
PASSWORD='BERxbKlDr1P+1KOQqBnponK8VQ8SyR0Cwq61By4DOIZb5qBx7QPIXSj3DkYgKjr0XhoEKCtiY1soramoYYst/PunMXfT0H+zoOAoDpWHMGf6ZqX/KThPVGeHoQp33m7&'
WHERE ID=_YOUR_ID_HERE_;`

after this you can start OM and log in with password: `Q!w2e3r4t5`

On Thu, 1 Oct 2020 at 15:41, Maxim Solodovnik  wrote:

> OK
>
> 1) go to
> https://mvnrepository.com/artifact/org.apache.derby/derbytools/10.14.1.0
> 2) save JAR file to ${OM_HOME}
> 3) in Terminal write:
> `cd ${OM_HOME}`
> `java -cp "derbytools-10.14.1.0.jar:webapps/openmeetings/WEB-INF/lib/*"
> org.apache.derby.tools.ij`
>
> In the "ij >" prompt enter `connect 'jdbc:derby:openmeetings';`
> then
> `select id, login, password from OMDBUSER.OM_USER WHERE ID IN (select
> user_id from OMDBUSER.OM_USER_RIGHT WHERE OM_RIGHT = 'Admin') AND deleted =
> 0;`
>
> you will get login of admin user/users and hash of the password
>
> I'll check how to change password later (day-time-job time)
>
> please check if instructions above works for you
>
>
> On Thu, 1 Oct 2020 at 15:15, Stefan Günther  wrote:
>
>> Hello Maxim,
>>
>> according to /opt/om/README it is Version 4.0.3
>>
>> /opt/om/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml
>>
>> .
>> > value="org.apache.commons.dbcp2.BasicDataSource"/>
>> > value="DriverClassName=org.apache.derby.jdbc.EmbeddedDriver,Url=jdbc:derby:openmeetings;create=true,
>> create=true, MaxActive=100, MaxWait=1,
>> TestOnBorrow=true,Username=omdbuser,Password="/>
>> ..
>>
>>
>> Thanks for your help,
>>
>> Stefan
>>
>> *Gesendet:* Donnerstag, 01. Oktober 2020 um 09:45 Uhr
>> *Von:* "Maxim Solodovnik" 
>> *An:* "Openmeetings user-list" 
>> *Betreff:* Re: Regaining admin access to an openmeetings installation
>> Hello Stefan,
>>
>> What version of Om are you using?
>>
>> top level instructions
>>
>> 0) assuming OM is in ${OM_HOME}
>> 1)
>> check 
>> ${OM_HOME}/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml
>> here you can get DB_TYPE, DB_URL, DB_USER, DB_PASS
>>
>> share DB type from above file with me to get next steps :))
>>
>>
>> On Thu, 1 Oct 2020 at 14:42, Stefan Günther  wrote:
>>
>>> Hello,
>>>
>>> we have a new client who is already using openmeetings. The accounts of
>>> the employees do not have admin rights and the guy, who setup OpenMeetings
>>> did not send the credentials for the admin account and isn't reachable
>>> anymore.
>>>
>>> We have access to the command line of the Ubuntu system and since there
>>> is no mysql db for openmeeting we assume that it is a setup with Apache
>>> Derby.
>>>
>>> How can we find out the name of the admin account and how can we reset
>>> its password?
>>>
>>> Thanks for any help or suggestions,
>>>
>>> Regards,
>>>
>>> Stefan
>>>
>>
>>
>> --
>> Best regards,
>> Maxim
>>
>
>
> --
> Best regards,
> Maxim
>


-- 
Best regards,
Maxim

Re: Re: Regaining admin access to an openmeetings installation

2020-10-01 Thread Maxim Solodovnik

OK

1) go to
https://mvnrepository.com/artifact/org.apache.derby/derbytools/10.14.1.0
2) save JAR file to ${OM_HOME}
3) in Terminal write:
`cd ${OM_HOME}`
`java -cp "derbytools-10.14.1.0.jar:webapps/openmeetings/WEB-INF/lib/*"
org.apache.derby.tools.ij`

In the "ij >" prompt enter `connect 'jdbc:derby:openmeetings';`
then
`select id, login, password from OMDBUSER.OM_USER WHERE ID IN (select
user_id from OMDBUSER.OM_USER_RIGHT WHERE OM_RIGHT = 'Admin') AND deleted =
0;`

you will get login of admin user/users and hash of the password

I'll check how to change password later (day-time-job time)

please check if instructions above works for you


On Thu, 1 Oct 2020 at 15:15, Stefan Günther  wrote:

> Hello Maxim,
>
> according to /opt/om/README it is Version 4.0.3
>
> /opt/om/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml
>
> .
>  value="org.apache.commons.dbcp2.BasicDataSource"/>
>  value="DriverClassName=org.apache.derby.jdbc.EmbeddedDriver,Url=jdbc:derby:openmeetings;create=true,
> create=true, MaxActive=100, MaxWait=1,
> TestOnBorrow=true,Username=omdbuser,Password="/>
> ..
>
>
> Thanks for your help,
>
> Stefan
>
> *Gesendet:* Donnerstag, 01. Oktober 2020 um 09:45 Uhr
> *Von:* "Maxim Solodovnik" 
> *An:* "Openmeetings user-list" 
> *Betreff:* Re: Regaining admin access to an openmeetings installation
> Hello Stefan,
>
> What version of Om are you using?
>
> top level instructions
>
> 0) assuming OM is in ${OM_HOME}
> 1)
> check ${OM_HOME}/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml
> here you can get DB_TYPE, DB_URL, DB_USER, DB_PASS
>
> share DB type from above file with me to get next steps :))
>
>
> On Thu, 1 Oct 2020 at 14:42, Stefan Günther  wrote:
>
>> Hello,
>>
>> we have a new client who is already using openmeetings. The accounts of
>> the employees do not have admin rights and the guy, who setup OpenMeetings
>> did not send the credentials for the admin account and isn't reachable
>> anymore.
>>
>> We have access to the command line of the Ubuntu system and since there
>> is no mysql db for openmeeting we assume that it is a setup with Apache
>> Derby.
>>
>> How can we find out the name of the admin account and how can we reset
>> its password?
>>
>> Thanks for any help or suggestions,
>>
>> Regards,
>>
>> Stefan
>>
>
>
> --
> Best regards,
> Maxim
>


-- 
Best regards,
Maxim

Aw: Re: Regaining admin access to an openmeetings installation

2020-10-01 Thread Stefan Günther

Hello Maxim,

 

according to /opt/om/README it is Version 4.0.3

 

/opt/om/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml

 

.




..
 

 

Thanks for your help,

 

Stefan

 


Gesendet: Donnerstag, 01. Oktober 2020 um 09:45 Uhr
Von: "Maxim Solodovnik" 
An: "Openmeetings user-list" 
Betreff: Re: Regaining admin access to an openmeetings installation


Hello Stefan,
 

What version of Om are you using?

 

top level instructions

 

0) assuming OM is in ${OM_HOME}

1) check ${OM_HOME}/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml

here you can get DB_TYPE, DB_URL, DB_USER, DB_PASS

 

share DB type from above file with me to get next steps :))

 

 


On Thu, 1 Oct 2020 at 14:42, Stefan Günther  wrote:




Hello,

 

we have a new client who is already using openmeetings. The accounts of the employees do not have admin rights and the guy, who setup OpenMeetings did not send the credentials for the admin account and isn't reachable anymore.

 

We have access to the command line of the Ubuntu system and since there is no mysql db for openmeeting we assume that it is a setup with Apache Derby.

 

How can we find out the name of the admin account and how can we reset its password?

 

Thanks for any help or suggestions,

 

Regards,

 

Stefan




 

 
--



Best regards,
Maxim

Re: Regaining admin access to an openmeetings installation

2020-10-01 Thread Maxim Solodovnik

Hello Stefan,

What version of Om are you using?

top level instructions

0) assuming OM is in ${OM_HOME}
1)
check ${OM_HOME}/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml
here you can get DB_TYPE, DB_URL, DB_USER, DB_PASS

share DB type from above file with me to get next steps :))


On Thu, 1 Oct 2020 at 14:42, Stefan Günther  wrote:

> Hello,
>
> we have a new client who is already using openmeetings. The accounts of
> the employees do not have admin rights and the guy, who setup OpenMeetings
> did not send the credentials for the admin account and isn't reachable
> anymore.
>
> We have access to the command line of the Ubuntu system and since there is
> no mysql db for openmeeting we assume that it is a setup with Apache Derby.
>
> How can we find out the name of the admin account and how can we reset its
> password?
>
> Thanks for any help or suggestions,
>
> Regards,
>
> Stefan
>


-- 
Best regards,
Maxim

Regaining admin access to an openmeetings installation

2020-10-01 Thread Stefan Günther

Hello,

 

we have a new client who is already using openmeetings. The accounts of the employees do not have admin rights and the guy, who setup OpenMeetings did not send the credentials for the admin account and isn't reachable anymore.

 

We have access to the command line of the Ubuntu system and since there is no mysql db for openmeeting we assume that it is a setup with Apache Derby.

 

How can we find out the name of the admin account and how can we reset its password?

 

Thanks for any help or suggestions,

 

Regards,

 

Stefan

Re: Re: Re: Re: Re: Regaining admin access to an openmeetings installation

Aw: Re: Re: Re: Re: Regaining admin access to an openmeetings installation

Re: warnings...

Re: Re: Re: Re: Regaining admin access to an openmeetings installation

Re: Re: Re: Re: Regaining admin access to an openmeetings installation

Re: warnings...

Re: Upgrading from OM 5 M4

Re: Re: Re: Re: Regaining admin access to an openmeetings installation

Upgrading from OM 5 M4

Aw: Re: Re: Re: Regaining admin access to an openmeetings installation

Re: Re: Re: Regaining admin access to an openmeetings installation

Aw: Re: Re: Regaining admin access to an openmeetings installation

Re: Re: Regaining admin access to an openmeetings installation

Re: Re: Regaining admin access to an openmeetings installation

Aw: Re: Regaining admin access to an openmeetings installation

Re: Regaining admin access to an openmeetings installation

Regaining admin access to an openmeetings installation

17 matches

Site Navigation

Mail list logo

Footer information