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
