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 <[email protected]> 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 <[email protected]> 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" <[email protected]> >> *An:* "Openmeetings user-list" <[email protected]> >> *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 <[email protected]> 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
