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/ <https://www.youracclaim.com/badges/da4e8828-743d-4968-af6f-49033f10d60a/public_url> <https://www.youracclaim.com/badges/b7e709c6-aa87-4b02-9faf-099038475e36/public_url> On Fri, 2 Oct 2020 at 14:00, Maxim Solodovnik <solomax...@gmail.com> 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 <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 >
