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

Stefan Günther Thu, 01 Oct 2020 23:39:46 -0700

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...@xxxx.eu, phone=0721xxxxxx], 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" <solomax...@gmail.com>
An: "Openmeetings user-list" <user@openmeetings.apache.org>
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 <smguent...@web.de> 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" <solomax...@gmail.com>
An: "Openmeetings user-list" <user@openmeetings.apache.org>
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 <smguent...@web.de> 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" <solomax...@gmail.com>
An: "Openmeetings user-list" <user@openmeetings.apache.org>
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 <solomax...@gmail.com> 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 <smguent...@web.de> 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

.....

<property name="openjpa.ConnectionDriverName" value="org.apache.commons.dbcp2.BasicDataSource"/>
<property name="openjpa.ConnectionProperties" value="DriverClassName=org.apache.derby.jdbc.EmbeddedDriver,Url="" create=true, MaxActive=100, MaxWait=10000, TestOnBorrow=true,Username=omdbuser,Password="/>

......

Thanks for your help,

Stefan

Gesendet: Donnerstag, 01. Oktober 2020 um 09:45 Uhr
Von: "Maxim Solodovnik" <solomax...@gmail.com>
An: "Openmeetings user-list" <user@openmeetings.apache.org>
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 <smguent...@web.de> 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

Best regards,
Maxim

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

Reply via email to