<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:inherit;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
color:black;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle22
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle23
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor=white lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Forgot to add:<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>I had smonitor’s db.inc.php settings uncommented,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Now getting this error instead<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>[Fri Mar 19 09:59:50 2010] [error] [client 172.18.53.97] PHP
Fatal error: Call to undefined method MDB2_Error::setFetchMode() in
/srv/www/htdocs/opensips-cp/web/tools/system/smonitor/lib/db_connect.php on
line 39, referer: <a href="http://10.32.0.97/cp/menu.php">http://10.32.0.97/cp/menu.php</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>I’m very sure I installed pear and the related parts as per the
install guide.. <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:windowtext'>From:</span></b><span style='font-size:10.0pt;font-family:
"Tahoma","sans-serif";color:windowtext'> Christian Vo <br>
<b>Sent:</b> Friday, March 19, 2010 9:57 AM<br>
<b>To:</b> OpenSIPS users mailling list<br>
<b>Subject:</b> RE: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Thx Alex, <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Confirming that these are my settings:<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>// each server is a box<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>$box_id=0;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>// mi host:port pair || fifo_file<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>// $boxes[$box_id]['mi']['conn']="127.0.0.1:8080";<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>$boxes[$box_id]['mi']['conn']="/tmp/opensips_fifo";<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>// monit host:port<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>$boxes[$box_id]['monit']['conn']="127.0.0.1:2812";<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>$boxes[$box_id]['monit']['user']="admin";<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>$boxes[$box_id]['monit']['pass']="monit";<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>$boxes[$box_id]['monit']['has_ssl']=0;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>// description (appears in mi , monit )<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>$boxes[$box_id]['desc']="SIP server";<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>At this point, Monit seems to be working, but
Statistics Monitor complains <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div align=center>
<table class=MsoNormalTable border=0 cellspacing=5 cellpadding=0 width=705
style='width:528.75pt'>
<tr style='height:15.0pt'>
<td valign=top style='padding:3.75pt 3.75pt 3.75pt 3.75pt;height:15.0pt'>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width="100%"
style='width:100.0%'>
<tr>
<td style='padding:0in 0in 0in 0in'>
<p class=MsoNormal align=right style='text-align:right'><span
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>“</span><span
style='color:windowtext'>Cannot connect to OpenSIPS Server via Management
Interface (127.0.0.1/8080)</span><span style='font-size:9.0pt;font-family:
"Verdana","sans-serif";color:#0969B5'><o:p></o:p></span></p>
</td>
</tr>
</table>
</td>
</tr>
</table>
</div>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>“<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:windowtext'>From:</span></b><span style='font-size:10.0pt;font-family:
"Tahoma","sans-serif";color:windowtext'> users-bounces@lists.opensips.org
[mailto:users-bounces@lists.opensips.org] <b>On Behalf Of </b>Alex Ionescu<br>
<b>Sent:</b> Friday, March 19, 2010 1:42 AM<br>
<b>To:</b> OpenSIPS users mailling list<br>
<b>Subject:</b> Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Hi Christian,<br>
<br>
Your boxes config must look like this :<br>
<br>
$box_id=0;<br>
// mi host:port pair || fifo_file<br>
//$boxes[$box_id]['mi']['conn']="127.0.0.1:8080";<br>
//i guess you are using fifo, not xmlrpc so : <br>
$boxes[$box_id]['mi']['conn']="/tmp/opensips_proxy_fifo";<br>
<br>
// monit host:port => this is for monit to work ok<br>
$boxes[$box_id]['monit']['conn']="127.0.0.1:2812";<br>
//you must take the username and password from the monit config file (monitrc).<br>
$boxes[$box_id]['monit']['user']="username"; <br>
$boxes[$box_id]['monit']['pass']="password";<br>
// if you want to enable ssl<br>
$boxes[$box_id]['monit']['has_ssl']=1;<br>
<br>
Please re-check your config and let me know if it works now.<br>
<br>
Regards,<br>
Alex<br>
<br>
On 3/19/2010 01:42, Christian Vo wrote: <o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>New problem:</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> </span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>So under opensips-cp/config/boxes.global.inc.php</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>I changed the following:</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> </span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>$boxes[$box_id]['mi']['conn']="127.0.0.1:8080";</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>(previously was
$boxes[$box_id]['mi']['conn']="/tmp/opensips_fifo";”</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> </span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>This seemed to resolve my issue with System</span><span
style='font-size:11.0pt;font-family:Wingdings;color:#1F497D'>à</span><span
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>
Monit</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> </span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>However, </span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> System </span><span style='font-size:11.0pt;font-family:
Wingdings;color:#1F497D'>à</span><span style='font-size:11.0pt;font-family:
"Calibri","sans-serif";color:#1F497D'> Statistics Monitor , System</span><span
style='font-size:11.0pt;font-family:Wingdings;color:#1F497D'>à</span><span
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> SIP Trace
, System </span><span style='font-size:11.0pt;font-family:Wingdings;
color:#1F497D'>à</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> MI Commands, and System </span><span style='font-size:11.0pt;
font-family:Wingdings;color:#1F497D'>à</span><span style='font-size:11.0pt;
font-family:"Calibri","sans-serif";color:#1F497D'> Dispatcher all
complain with the following on-screen message</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> </span><o:p></o:p></p>
<p class=MsoNormal>“Cannot connect to OpenSIPS Server via Management Interface
(127.0.0.1/8080)”<o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal>So I changed it back to <o:p></o:p></p>
<p class=MsoNormal>$boxes[$box_id]['mi']['conn']="/tmp/opensips_fifo";<o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal>But then<o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal>I notice tools/monit/local.inc.php still doesn’t contain any
code….?? <o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> </span><o:p></o:p></p>
<div>
<div style='border:none;border-top:solid windowtext 1.0pt;padding:3.0pt 0in 0in 0in;
border-color:-moz-use-text-color -moz-use-text-color'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:windowtext'>From:</span></b><span style='font-size:10.0pt;font-family:
"Tahoma","sans-serif";color:windowtext'> <a
href="mailto:users-bounces@lists.opensips.org">users-bounces@lists.opensips.org</a>
[<a href="mailto:users-bounces@lists.opensips.org">mailto:users-bounces@lists.opensips.org</a>]
<b>On Behalf Of </b>Christian Vo<br>
<b>Sent:</b> Thursday, March 18, 2010 10:21 AM<br>
<b>To:</b> OpenSIPS users mailling list<br>
<b>Subject:</b> Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0</span><o:p></o:p></p>
</div>
</div>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Thx for the notice, I’ve just downloaded and re-installed the
lastest 4.0 tarball…. (moved the old dir to backup, and replaced it with
the new, re-adjusting config parameters along the way…)</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> </span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Not sure if I missed something, but I’m getting this error
on-screen now:</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> </span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Under the System</span><span style='font-size:11.0pt;font-family:
Wingdings;color:#1F497D'>à</span><span style='font-size:11.0pt;font-family:
"Calibri","sans-serif";color:#1F497D'> Monit tab</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>I see “Primary Sip Server” 192.168.0.1:2812</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> </span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Followed by “I can’t Connect”</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> </span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> </span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Something is wrong here, since I adjusted
config/boxes.global.inc.php so that my only entry (Primary SIP Server) would be
using 127.0.0.1:2812 for monit</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>And I don’t know where else I’d find any entry for 192.168.0.1
related to this.. </span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> </span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>This part was working for me back when I had the previous 4.0
tarball… odd</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> </span><o:p></o:p></p>
<div>
<div style='border:none;border-top:solid windowtext 1.0pt;padding:3.0pt 0in 0in 0in;
border-color:-moz-use-text-color -moz-use-text-color'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:windowtext'>From:</span></b><span style='font-size:10.0pt;font-family:
"Tahoma","sans-serif";color:windowtext'> <a
href="mailto:users-bounces@lists.opensips.org">users-bounces@lists.opensips.org</a>
[<a href="mailto:users-bounces@lists.opensips.org">mailto:users-bounces@lists.opensips.org</a>]
<b>On Behalf Of </b>Alex Ionescu<br>
<b>Sent:</b> Thursday, March 18, 2010 4:46 AM<br>
<b>To:</b> OpenSIPS users mailling list<br>
<b>Subject:</b> Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0</span><o:p></o:p></p>
</div>
</div>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal>Hi,<br>
<br>
Actually there were a few issues that were found and solved the last few days.
I hope you won't have anymore problems if you download the new 4.0 tarball. <br>
<br>
So, give it a try and let me know.<br>
<br>
Regards,<br>
Alex<br>
<br>
On 3/18/2010 13:35, ha do wrote: <o:p></o:p></p>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0>
<tr>
<td valign=top style='padding:0in 0in 0in 0in;font-style:inherit;font-variant:
inherit;font-weight:inherit;font-size:inherit;line-height:inherit;font-size-adjust: inherit;
font-stretch: inherit'>
<p class=MsoNormal><span style='font-family:inherit'>HI Alex </span><o:p></o:p></p>
<div>
<p class=MsoNormal><span style='font-family:inherit'> </span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-family:inherit'>did you find new issue
on opensips cp</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-family:inherit'> </span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-family:inherit'>Thank you</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-family:inherit'>Ha`<br>
<br>
--- On <b>Sat, 3/13/10, Alex Ionescu <i><a href="mailto:alex@opensips.org"><alex@opensips.org></a></i></b>
wrote:</span><o:p></o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-family:
inherit'><br>
From: Alex Ionescu <a href="mailto: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
href="mailto:users@lists.opensips.org"><users@lists.opensips.org></a><br>
Date: Saturday, March 13, 2010, 9:21 AM</span><o:p></o:p></p>
<div id=yiv1183892935>
<p class=MsoNormal><span style='font-family:inherit'>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: </span><o:p></o:p></p>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0>
<tr>
<td valign=top style='padding:0in 0in 0in 0in;font-style:inherit;
font-variant:inherit;font-weight:inherit;font-size:inherit;line-height:
inherit;font-size-adjust: inherit;font-stretch: inherit'>
<p class=MsoNormal><span style='font-family:inherit'><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
href="/mc/compose?to=alex@opensips.org" target="_blank"><alex@opensips.org></a></i></b>
wrote:</span><o:p></o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-family:
inherit'><br>
From: Alex Ionescu <a href="/mc/compose?to=alex@opensips.org"
target="_blank"><alex@opensips.org></a><br>
Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0<br>
To: "OpenSIPS users mailling list" <a
href="/mc/compose?to=users@lists.opensips.org" target="_blank"><users@lists.opensips.org></a><br>
Date: Friday, March 12, 2010, 9:02 AM</span><o:p></o:p></p>
<div id=yiv1014184499>
<p class=MsoNormal><span style='font-family:inherit'>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: </span><o:p></o:p></p>
<p class=MsoNormal><span style='font-family:inherit'>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: </span><o:p></o:p></p>
<p class=MsoNormal><span style='font-family:inherit'> step 11. INSERT
INTO ocp_admin_privileges (username,password,ha1,available_tools,permissions)
values ('admin','admin','admin:admin','all','all');</span><o:p></o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-family:
inherit'> </span><o:p></o:p></p>
<pre>-- <o:p></o:p></pre><pre>Alex Ionescu<o:p></o:p></pre><pre><a
href="http://www.voice-system.ro" target="_blank">www.voice-system.ro</a> <o:p></o:p></pre><pre> <o:p></o:p></pre><pre>_______________________________________________<o:p></o:p></pre><pre>Users mailing list<o:p></o:p></pre><pre><a
href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><o:p></o:p></pre><pre><a
href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users"
target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><o:p></o:p></pre><pre> <o:p></o:p></pre>
<p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-family:
inherit'> </span><o:p></o:p></p>
<pre>-- <o:p></o:p></pre><pre>Alex Ionescu<o:p></o:p></pre><pre><a
href="http://www.voice-system.ro" target="_blank">www.voice-system.ro</a> <o:p></o:p></pre></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-family:
inherit'><br>
-----Inline Attachment Follows-----</span><o:p></o:p></p>
<div>
<p class=MsoNormal><span style='font-family:inherit'>_______________________________________________<br>
Users mailing list<br>
<a href="mailto: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></span><o:p></o:p></p>
</div>
</td>
</tr>
</table>
<p class=MsoNormal><span style='font-family:inherit'> </span><o:p></o:p></p>
<pre> <o:p></o:p></pre><pre>_______________________________________________<o:p></o:p></pre><pre>Users mailing list<o:p></o:p></pre><pre><a
href="/mc/compose?to=Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><o:p></o:p></pre><pre><a
href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users"
target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><o:p></o:p></pre><pre> <o:p></o:p></pre>
<p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-family:
inherit'> </span><o:p></o:p></p>
<pre>-- <o:p></o:p></pre><pre>Alex Ionescu<o:p></o:p></pre><pre><a
href="http://www.voice-system.ro" target="_blank">www.voice-system.ro</a> <o:p></o:p></pre></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-family:
inherit'><br>
-----Inline Attachment Follows-----</span><o:p></o:p></p>
<div>
<p class=MsoNormal><span style='font-family:inherit'>_______________________________________________<br>
Users mailing list<br>
<a 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></span><o:p></o:p></p>
</div>
</div>
</td>
</tr>
</table>
<p class=MsoNormal style='margin-bottom:12.0pt'> <o:p></o:p></p>
<pre> <o:p></o:p></pre><pre> <o:p></o:p></pre><pre>_______________________________________________<o:p></o:p></pre><pre>Users mailing list<o:p></o:p></pre><pre><a
href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><o:p></o:p></pre><pre><a
href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><o:p></o:p></pre><pre> <o:p></o:p></pre>
<p class=MsoNormal style='margin-bottom:12.0pt'><br>
<br>
<o:p></o:p></p>
<pre>-- <o:p></o:p></pre><pre>Alex Ionescu<o:p></o:p></pre><pre><a
href="http://www.voice-system.ro">www.voice-system.ro</a> <o:p></o:p></pre>
<div>
<div class=MsoNormal align=center style='text-align:center'><span
style='color:windowtext'>
<hr size=2 width="100%" align=center>
</span></div>
</div>
<div>
<p class=MsoNormal><span style='color:windowtext'>This email message is for the
sole use of the intended recipient(s) and may contain confidential
information. Any unauthorized review, use, disclosure or distribution is
prohibited. If you are not the intended recipient, please contact the
sender by reply email and destroy all copies of the original message. </span><o:p></o:p></p>
</div>
<div>
<div class=MsoNormal align=center style='text-align:center'><span
style='color:windowtext'>
<hr size=2 width="100%" align=center>
</span></div>
</div>
<pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre>_______________________________________________<o:p></o:p></pre><pre>Users mailing list<o:p></o:p></pre><pre><a
href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><o:p></o:p></pre><pre><a
href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><o:p></o:p></pre><pre> <o:p></o:p></pre>
<p class=MsoNormal style='margin-bottom:12.0pt'><br>
<br>
<o:p></o:p></p>
<pre>-- <o:p></o:p></pre><pre>Alex Ionescu<o:p></o:p></pre><pre><a
href="http://www.voice-system.ro">www.voice-system.ro</a> <o:p></o:p></pre></div>
</body>
</html>