<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">HI Alex<div><br></div><div>did you find new issue on opensips cp</div><div><br></div><div>Thank you</div><div>Ha`<br><br>--- On <b>Sat, 3/13/10, Alex Ionescu <i><alex@opensips.org></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: Alex Ionescu <alex@opensips.org><br>Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0<br>To: "OpenSIPS users mailling list" <users@lists.opensips.org><br>Date: Saturday, March 13, 2010, 9:21 AM<br><br><div id="yiv1183892935">
Hi,<br>
<br>
I will investigate the problem and will let you know if I find any
issue.<br>
<br>
Regards,<br>
Alex<br>
<br>
On 3/13/2010 06:39, Do Nguyen Ha wrote:
<blockquote type="cite">
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td style="font-family:inherit;font-style:inherit;font-variant:inherit;font-weight:inherit;font-size:inherit;line-height:inherit;font-size-adjust:inherit;font-stretch:inherit;" valign="top"><br>
Hi Alex<br>
<br>
here is mysql query:<br>
mysql> select * from ocp_admin_privileges\G;<br>
*************************** 1. row ***************************<br>
id: 58<br>
first_name:<br>
last_name:<br>
username: admin<br>
password: admin<br>
ha1: d2abaa37a7c3db1137d385e1d8c15fd2<br>
available_tools: all<br>
permissions: all<br>
<br>
so i am still getting the invalid username on opensips-cp version 4<br>
the i remove the folder opensips-cp version 4 and replace with
opensips-cp version 3 and now it works without problem with opensips-cp
version 3<br>
<br>
i dont change anything and step i do :<br>
step 1. cd /var/www<br>
step 2. delete folder opensips-cp<br>
step 3. download the opensips-cp_3.0.tar.gz<br>
step 4. untar the file opensips-cp_3.0<br>
step 5. chown www-data:www-data opensips-cp -R<br>
<br>
Thank you for your help<br>
Ha<br>
<br>
--- On <b>Fri, 3/12/10, Alex Ionescu <i><a rel="nofollow" class="moz-txt-link-rfc2396E" ymailto="mailto:alex@opensips.org" target="_blank" href="/mc/compose?to=alex@opensips.org"><alex@opensips.org></a></i></b>
wrote:<br>
<blockquote style="border-left:2px solid rgb(16, 16, 255);margin-left:5px;padding-left:5px;"><br>
From: Alex Ionescu <a rel="nofollow" class="moz-txt-link-rfc2396E" ymailto="mailto:alex@opensips.org" target="_blank" href="/mc/compose?to=alex@opensips.org"><alex@opensips.org></a><br>
Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0<br>
To: "OpenSIPS users mailling list" <a rel="nofollow" class="moz-txt-link-rfc2396E" ymailto="mailto:users@lists.opensips.org" target="_blank" href="/mc/compose?to=users@lists.opensips.org"><users@lists.opensips.org></a><br>
Date: Friday, March 12, 2010, 9:02 AM<br>
<br>
<div id="yiv1014184499"> Sorry,<br>
<br>
My mistake ... the MD5 should be applied on the value not on the field
name ... So, it is : <br>
<br>
INSERT INTO ocp_admin_privileges
(username,password,ha1,available_tools,permissions) values
('admin','admin',md5('admin:admin'),'all','all');<br>
<br>
On 3/12/2010 13:06, Alex Ionescu wrote:
<blockquote type="cite">
Hi,<br>
<br>
The problem seems to be your "step 11" :<br>
<br>
step 11. INSERT INTO ocp_admin_privileges
(username,password,ha1,available_tools,permissions) values
('admin','admin','admin:admin','all','all');<br>
<br>
You must encode the <b>ha1</b> field. So, I believe that the correct
query would be : <br>
<br>
INSERT INTO ocp_admin_privileges
(username,password,md5(ha1),available_tools,permissions) values
('admin','admin','admin:admin','all','all');<br>
<br>
Anyway, you can always check the INSTALL file (I think the query is
located on line 102 or 103).<br>
<br>
Regards,<br>
<br>
Alex<br>
<br>
On 3/12/2010 12:41, Do Nguyen Ha wrote:
<blockquote type="cite"> step 11. INSERT INTO
ocp_admin_privileges
(username,password,ha1,available_tools,permissions) values
('admin','admin','admin:admin','all','all');</blockquote>
<br>
<br>
<pre class="moz-signature">--
Alex Ionescu
<a rel="nofollow" class="moz-txt-link-abbreviated" target="_blank" href="http://www.voice-system.ro">www.voice-system.ro</a> </pre>
<pre><fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Users mailing list
<a rel="nofollow" class="moz-txt-link-abbreviated">Users@lists.opensips.org</a>
<a rel="nofollow" class="moz-txt-link-freetext" target="_blank" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature">--
Alex Ionescu
<a rel="nofollow" class="moz-txt-link-abbreviated" target="_blank" href="http://www.voice-system.ro">www.voice-system.ro</a> </pre>
</div>
<br>
-----Inline Attachment Follows-----<br>
<br>
<div class="plainMail">_______________________________________________<br>
Users mailing list<br>
<a rel="nofollow">Users@lists.opensips.org</a><br>
<a rel="nofollow" target="_blank" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</div>
</blockquote>
</td>
</tr>
</tbody>
</table>
<br>
<pre><fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Users mailing list
<a rel="nofollow" class="moz-txt-link-abbreviated" ymailto="mailto:Users@lists.opensips.org" target="_blank" href="/mc/compose?to=Users@lists.opensips.org">Users@lists.opensips.org</a>
<a rel="nofollow" class="moz-txt-link-freetext" target="_blank" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature">--
Alex Ionescu
<a rel="nofollow" class="moz-txt-link-abbreviated" target="_blank" href="http://www.voice-system.ro">www.voice-system.ro</a> </pre>
</div><br>-----Inline Attachment Follows-----<br><br><div class="plainMail">_______________________________________________<br>Users mailing list<br><a ymailto="mailto:Users@lists.opensips.org" href="/mc/compose?to=Users@lists.opensips.org">Users@lists.opensips.org</a><br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br></div></blockquote></div></td></tr></table><br>