I have downloaded 4.0.3 Perform quick install with h2 Did select from db of login and password ....
Weird it doesn't work You can elevate permissions of any existing users .... from mobile (sorry for typos ;) On Fri, Oct 2, 2020, 13:39 Stefan Günther <smguent...@web.de> wrote: > 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=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 >
