On Fri, 2 Oct 2020 at 09:35, seba.wag...@gmail.com <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 (user_id, OM_RIGHT) VALUES (_ID_OF_YOUR_USER_, 'Admin'); > > 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 >> > -- Best regards, Maxim
