openmeetings-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stefan G√ľnther <SMGuent...@web.de>
Subject Aw: Re: Re: Re: Regaining admin access to an openmeetings installation
Date Thu, 01 Oct 2020 17:21:55 GMT
<html><head></head><body><div style="font-family: Verdana;font-size:
12.0px;"><div>Hello Maxim,</div>

<div>&nbsp;</div>

<div>using the ID 2, the update was successful:</div>

<div>&nbsp;</div>

<div>ID &nbsp;&nbsp;&#124;LOGIN &nbsp;&nbsp;&nbsp;&nbsp;
&nbsp; &nbsp; &#124;PASSWORD &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br/>
2&nbsp; &nbsp; &nbsp;&#124;omadmin&nbsp; &nbsp; &nbsp;&#124;BERxbKlDr1P+1KOQqBnponK8VQ8SyR0Cwq61By4DOIZb5qBx7QPIXSj3DkYgKjr0XhoEKCtiY1soramoYYst/PunMXfT0H+zoOAoDpWHMGf6ZqX/KThPVGeHoQp33m7&amp;<br/>
<br/>
&nbsp;</div>

<div>But I still cannot login with omadmin /&nbsp;Q!w2e3r4t5 (I tried it more than
once).</div>

<div>&nbsp;</div>

<div>Regards,</div>

<div>&nbsp;</div>

<div>Stefan</div>

<div>&nbsp;
<div>&nbsp;
<div name="quote" style="margin:10px 5px 5px 10px; padding: 10px 0 10px 10px; border-left:2px
solid #C3D9E5; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">
<div style="margin:0 0 10px 0;"><b>Gesendet:</b>&nbsp;Donnerstag, 01.
Oktober 2020 um 18:03 Uhr<br/>
<b>Von:</b>&nbsp;&quot;Maxim Solodovnik&quot; &lt;solomax666@gmail.com&gt;<br/>
<b>An:</b>&nbsp;&quot;Openmeetings user-list&quot; &lt;user@openmeetings.apache.org&gt;<br/>
<b>Betreff:</b>&nbsp;Re: Re: Re: Regaining admin access to an openmeetings
installation</div>

<div name="quoted-content">
<div>obviously ID is numeric identificator
<div>for ex. 1</div>
</div>
&nbsp;

<div class="gmail_quote">
<div class="gmail_attr">On Thu, 1 Oct 2020 at 23:01, Stefan G&uuml;nther &lt;<a
href="mailto:SMGuenther@web.de" onclick="parent.window.location.href=&#39;mailto:SMGuenther@web.de&#39;;
return false;" target="_blank">SMGuenther@web.de</a>&gt; wrote:</div>

<blockquote class="gmail_quote" style="margin: 0.0px 0.0px 0.0px 0.8ex;border-left: 1.0px
solid rgb(204,204,204);padding-left: 1.0ex;">
<div>
<div style="font-family: Verdana;font-size: 12.0px;">
<div>Hi Maxim,</div>

<div>&nbsp;</div>

<div>thanks a lot for your help, but let&#39;s assume the account is &#39;admin&#39;:</div>

<div>&nbsp;</div>

<div>
<div>UPDATE OMDBUSER.OM_USER SET PASSWORD=&#39;BERxbKlDr1P+1KOQqBnponK8VQ8SyR0Cwq61By4DOIZb5qBx7QPIXSj3DkYgKjr0XhoEKCtiY1soramoYYst/PunMXfT0H+zoOAoDpWHMGf6ZqX/KThPVGeHoQp33m7&amp;&#39;
WHERE ID=&#39;admin&#39;;</div>

<div>&nbsp;</div>

<div>returns</div>

<div>&nbsp;</div>

<div>ERROR 42818: Comparisons between &#39;BIGINT&#39; and &#39;CHAR (UCS_BASIC)&#39;
are not supported. Types must be comparable. String types must also have matching collation.
If collation does not match, a possible solution is t<br/>
o cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables
WHERE CAST(tablename AS VARCHAR(128)) = &#39;T1&#39;)<br/>
&nbsp;</div>

<div>Regards,</div>

<div>&nbsp;</div>

<div>Stefan</div>

<div>&nbsp;</div>

<div>&nbsp;
<div style="margin: 10.0px 5.0px 5.0px 10.0px;padding: 10.0px 0.0px 10.0px 10.0px;border-left:
2.0px solid rgb(195,217,229);">
<div style="margin: 0.0px 0.0px 10.0px;"><b>Gesendet:</b>&nbsp;Donnerstag,
01. Oktober 2020 um 10:56 Uhr<br/>
<b>Von:</b>&nbsp;&quot;Maxim Solodovnik&quot; &lt;<a href="mailto:solomax666@gmail.com"
onclick="parent.window.location.href=&#39;mailto:solomax666@gmail.com&#39;; return
false;" target="_blank">solomax666@gmail.com</a>&gt;<br/>
<b>An:</b>&nbsp;&quot;Openmeetings user-list&quot; &lt;<a href="mailto:user@openmeetings.apache.org"
onclick="parent.window.location.href=&#39;mailto:user@openmeetings.apache.org&#39;;
return false;" target="_blank">user@openmeetings.apache.org</a>&gt;<br/>
<b>Betreff:</b>&nbsp;Re: Re: Regaining admin access to an openmeetings installation</div>

<div>
<div>just realized
<div>the last step is easy:</div>

<div>&#96;UPDATE OMDBUSER.OM_USER SET PASSWORD=&#39;BERxbKlDr1P+1KOQqBnponK8VQ8SyR0Cwq61By4DOIZb5qBx7QPIXSj3DkYgKjr0XhoEKCtiY1soramoYYst/PunMXfT0H+zoOAoDpWHMGf6ZqX/KThPVGeHoQp33m7&amp;&#39;
WHERE ID=_YOUR_ID_HERE_;&#96;</div>

<div>&nbsp;</div>

<div>after this you can start OM and log in with password: &#96;Q!w2e3r4t5&#96;</div>
</div>
&nbsp;

<div class="gmail_quote">
<div class="gmail_attr">On Thu, 1 Oct 2020 at 15:41, Maxim Solodovnik &lt;<a
href="mailto:solomax666@gmail.com" onclick="parent.window.location.href=&#39;mailto:solomax666@gmail.com&#39;;
return false;" target="_blank">solomax666@gmail.com</a>&gt; wrote:</div>

<blockquote class="gmail_quote" style="margin: 0.0px 0.0px 0.0px 0.8ex;border-left: 1.0px
solid rgb(204,204,204);padding-left: 1.0ex;">
<div>OK
<div>&nbsp;</div>

<div>1) go to&nbsp;<a href="https://mvnrepository.com/artifact/org.apache.derby/derbytools/10.14.1.0"
target="_blank">https://mvnrepository.com/artifact/org.apache.derby/derbytools/10.14.1.0</a></div>

<div>2) save JAR file to &#36;{OM_HOME}</div>

<div>3) in Terminal write:</div>

<div>&#96;cd &#36;{OM_HOME}&#96;</div>

<div>&#96;java -cp &quot;derbytools-10.14.1.0.jar:webapps/openmeetings/WEB-INF/lib/*&quot;
org.apache.derby.tools.ij&#96;</div>

<div>&nbsp;</div>

<div>In the &quot;ij &gt;&quot; prompt enter &#96;connect &#39;jdbc:derby:openmeetings&#39;;&#96;</div>

<div>then</div>

<div>&#96;select id, login, password from OMDBUSER.OM_USER WHERE ID IN (select user_id
from OMDBUSER.OM_USER_RIGHT WHERE OM_RIGHT = &#39;Admin&#39;) AND deleted = 0;&#96;</div>

<div>&nbsp;</div>

<div>you will get login of admin user/users and hash of the password</div>

<div>&nbsp;</div>

<div>I&#39;ll check how to change password later (day-time-job time)</div>

<div>&nbsp;</div>

<div>please check if instructions above works for you</div>

<div>&nbsp;</div>
</div>
&nbsp;

<div class="gmail_quote">
<div class="gmail_attr">On Thu, 1 Oct 2020 at 15:15, Stefan G&uuml;nther &lt;<a
href="mailto:SMGuenther@web.de" onclick="parent.window.location.href=&#39;mailto:SMGuenther@web.de&#39;;
return false;" target="_blank">SMGuenther@web.de</a>&gt; wrote:</div>

<blockquote class="gmail_quote" style="margin: 0.0px 0.0px 0.0px 0.8ex;border-left: 1.0px
solid rgb(204,204,204);padding-left: 1.0ex;">
<div>
<div style="font-family: Verdana;font-size: 12.0px;">
<div>Hello Maxim,</div>

<div>&nbsp;</div>

<div>according to /opt/om/README it is Version 4.0.3</div>

<div>&nbsp;
<div>
<div>/opt/om/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml</div>

<div>&nbsp;</div>

<div>.....</div>

<div>&lt;property name=&quot;openjpa.ConnectionDriverName&quot; value=&quot;org.apache.commons.dbcp2.BasicDataSource&quot;/&gt;<br/>
&lt;property name=&quot;openjpa.ConnectionProperties&quot; value=&quot;DriverClassName=org.apache.derby.jdbc.EmbeddedDriver,Url=jdbc:derby:openmeetings;create=true,
create=true, MaxActive=100,&nbsp;MaxWait=10000, &nbsp; &nbsp; TestOnBorrow=true,Username=omdbuser,Password=&quot;/&gt;</div>

<div>......<br/>
&nbsp;</div>

<div>&nbsp;</div>

<div>Thanks for your help,</div>

<div>&nbsp;</div>

<div>Stefan</div>

<div>&nbsp;</div>

<div style="margin: 10.0px 5.0px 5.0px 10.0px;padding: 10.0px 0.0px 10.0px 10.0px;border-left:
2.0px solid rgb(195,217,229);">
<div style="margin: 0.0px 0.0px 10.0px;"><b>Gesendet:</b>&nbsp;Donnerstag,
01. Oktober 2020 um 09:45 Uhr<br/>
<b>Von:</b>&nbsp;&quot;Maxim Solodovnik&quot; &lt;<a href="mailto:solomax666@gmail.com"
onclick="parent.window.location.href=&#39;mailto:solomax666@gmail.com&#39;; return
false;" target="_blank">solomax666@gmail.com</a>&gt;<br/>
<b>An:</b>&nbsp;&quot;Openmeetings user-list&quot; &lt;<a href="mailto:user@openmeetings.apache.org"
onclick="parent.window.location.href=&#39;mailto:user@openmeetings.apache.org&#39;;
return false;" target="_blank">user@openmeetings.apache.org</a>&gt;<br/>
<b>Betreff:</b>&nbsp;Re: Regaining admin access to an openmeetings installation</div>

<div>
<div>Hello Stefan,
<div>&nbsp;</div>

<div>What version of Om are you using?</div>

<div>&nbsp;</div>

<div>top level instructions</div>

<div>&nbsp;</div>

<div>0) assuming OM is in &#36;{OM_HOME}</div>

<div>1) check&nbsp;&#36;{OM_HOME}/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml</div>

<div>here you can get DB_TYPE, DB_URL, DB_USER, DB_PASS</div>

<div>&nbsp;</div>

<div>share DB type from above file with me to get next steps :))</div>

<div>&nbsp;</div>
</div>
&nbsp;

<div class="gmail_quote">
<div class="gmail_attr">On Thu, 1 Oct 2020 at 14:42, Stefan G&uuml;nther &lt;<a
href="mailto:SMGuenther@web.de" onclick="parent.window.location.href=&#39;mailto:SMGuenther@web.de&#39;;
return false;" target="_blank">SMGuenther@web.de</a>&gt; wrote:</div>

<blockquote class="gmail_quote" style="margin: 0.0px 0.0px 0.0px 0.8ex;border-left: 1.0px
solid rgb(204,204,204);padding-left: 1.0ex;">
<div>
<div style="font-family: Verdana;font-size: 12.0px;">
<div>Hello,</div>

<div>&nbsp;</div>

<div>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&#39;t reachable anymore.</div>

<div>&nbsp;</div>

<div>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.</div>

<div>&nbsp;</div>

<div>How can we find out the name of the admin account and how can we reset its password?</div>

<div>&nbsp;</div>

<div>Thanks for any help or suggestions,</div>

<div>&nbsp;</div>

<div>Regards,</div>

<div>&nbsp;</div>

<div>Stefan</div>
</div>
</div>
</blockquote>
</div>
&nbsp;

<div>&nbsp;</div>
--

<div>
<div>
<div>Best regards,<br/>
Maxim</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
&nbsp;

<div>&nbsp;</div>
--

<div>
<div>
<div>Best regards,<br/>
Maxim</div>
</div>
</div>
</blockquote>
</div>
&nbsp;

<div>&nbsp;</div>
--

<div>
<div>
<div>Best regards,<br/>
Maxim</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
&nbsp;

<div>&nbsp;</div>
--

<div class="gmail_signature">
<div>
<div>Best regards,<br/>
Maxim</div>
</div>
</div>
</div>
</div>
</div>
</div></div></body></html>

Mime
View raw message