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

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:

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

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, delet

Re: warnings...

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=j

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

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 (u

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

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/

Re: warnings...

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 W

Re: Upgrading from OM 5 M4

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 ab

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 > > > -

Upgrading from OM 5 M4

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 server

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

Hello Maxim,   using the ID 2, the update was successful:   ID   |LOGIN     |PASSWORD ---

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+1KOQqBnponK8VQ8SyR0Cwq61By4DOIZb5qBx7QPIXSj3DkYgKjr0XhoE

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

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 428

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`

Re: Re: Regaining admin access to an openmeetings installation

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:de

Aw: Re: Regaining admin access to an openmeetings installation

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

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 :))

Regaining admin access to an openmeetings installation

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 a