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=jdbc:derby:openmeetings;create=true, >>>> 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
