<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:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@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:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
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;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@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 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'>Based on this thread (<a
href="http://www.pear-forum.org/topic1244.html">http://www.pear-forum.org/topic1244.html</a>)
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>, I added the following to user_management.php <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> $resultset = $link->prepare($sql);<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'>##added this <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> if (PEAR::isError($resultset)) {<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> die($resultset->getMessage() . ', ' .
$resultset->getDebugInfo());<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>
<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'> $resultset->execute();<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>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>The error I got after trying to add user was this:<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:9.0pt;font-family:"Verdana","sans-serif";
color:black'>MDB2 Error: no such field, _doQuery: [Error message: Could not
execute statement] [Last executed query: PREPARE
MDB2_STATEMENT_mysql_81a2b39d1bc2abeacb0359a975958e93 FROM 'INSERT INTO
subscriber (last_name, first_name, username,domain,password,email_address,ha1,ha1b,datetime_created)
VALUES
(\'\',\'\',\'1002\',\'10.32.0.97\',\'1002\',\'cvo@nvidia.com\',\'\',\'\',
NOW())'] [Native code: 1054] [Native message: Unknown column 'last_name' in
'field list']<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'>mysql> describe subscriber;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'>+---------------+------------------+------+-----+---------+----------------+<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'>| Field | Type | Null | Key | Default |
Extra |<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'>+---------------+------------------+------+-----+---------+----------------+<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'>| id | int(10) unsigned | NO | PRI | NULL |
auto_increment |<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'>| username | char(64) | NO | MUL |
| |<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'>| domain | char(64) | NO | |
| |<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'>| password | char(25) | NO | |
| |<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'>| email_address | char(64) | NO | |
| |<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'>| ha1 | char(64) | NO | | |
|<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'>| ha1b | char(64) | NO | |
| |<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'>| rpid | char(64) | YES | | NULL
| |<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'>+---------------+------------------+------+-----+---------+----------------+<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'>8 rows in set (0.00 sec)<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'>Not sure where last_name & first_name come in here…?? <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Verdana","sans-serif";
color:black'><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 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"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> users-bounces@lists.opensips.org
[mailto:users-bounces@lists.opensips.org] <b>On Behalf Of </b>TCB<br>
<b>Sent:</b> Sunday, March 21, 2010 9:03 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>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'>Tried running ocp and i'm
getting this error on adding users. <br>
<br>
Failed to issue query, error message : MDB2 Error: no such field<br>
I'm not getting any useful error to start tracing. <br>
<br>
TC.<o:p></o:p></p>
<div>
<p class=MsoNormal>On Sat, Mar 20, 2010 at 12:10 AM, Christian Vo <<a
href="mailto:cvo@nvidia.com">cvo@nvidia.com</a>> wrote:<o:p></o:p></p>
<p class=MsoNormal>Thanks Anca,<br>
<br>
I think that's fixed the problem with smonitor,<br>
I still can't add users though,<br>
<br>
Fatal error: Call to undefined method MDB2_Error::execute() in
/srv/www/htdocs/opensips-cp/web/tools/users/user_management/user_management.php
on line 223,...<o:p></o:p></p>
<div>
<p class=MsoNormal><br>
-----Original Message-----<br>
From: Anca Vamanu [mailto:<a href="mailto:anca@opensips.org">anca@opensips.org</a>]<br>
Sent: Friday, March 19, 2010 2:41 PM<br>
To: OpenSIPS users mailling list<o:p></o:p></p>
</div>
<div>
<div>
<p class=MsoNormal>Cc: Christian Vo<br>
Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0<br>
<br>
Forward from Alex:<br>
---<br>
<br>
Hi Christian,<br>
<br>
Please check the following :<br>
In the OpenSIPS config :<br>
- if you have loaded the mi_fifo module;<br>
loadmodule "mi_fifo.so"<br>
- if you have declared the correct fifo parameters (if the fifo file<br>
name is the same as in Control Panel boxes config and if it has right<br>
permissions set);<br>
- if I'm not wrong it should be something like this :<br>
modparam("mi_fifo", "fifo_name",
"/tmp/opensips_fifo")<br>
modparam("mi_fifo", "fifo_mode", 0666)<br>
<br>
Leave the db.inc.php commented as it was before and please check the<br>
stuff above and let me know.<br>
<br>
Regards,<br>
Alex<br>
<br>
---<br>
<br>
Christian Vo wrote:<br>
><br>
> Forgot to add:<br>
><br>
> I had smonitor's db.inc.php settings uncommented,<br>
><br>
> Now getting this error instead<br>
><br>
> [Fri Mar 19 09:59:50 2010] [error] [client 172.18.53.97] PHP Fatal<br>
> error: Call to undefined method MDB2_Error::setFetchMode() in<br>
> /srv/www/htdocs/opensips-cp/web/tools/system/smonitor/lib/db_connect.php<br>
> on line 39, referer: <a href="http://10.32.0.97/cp/menu.php"
target="_blank">http://10.32.0.97/cp/menu.php</a><br>
><br>
> I'm very sure I installed pear and the related parts as per the<br>
> install guide..<br>
><br>
> *From:* Christian Vo<br>
> *Sent:* Friday, March 19, 2010 9:57 AM<br>
> *To:* OpenSIPS users mailling list<br>
> *Subject:* RE: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0<br>
><br>
> Thx Alex,<br>
><br>
> Confirming that these are my settings:<br>
><br>
> // each server is a box<br>
><br>
> $box_id=0;<br>
><br>
> // mi host:port pair || fifo_file<br>
><br>
> // $boxes[$box_id]['mi']['conn']="<a href="http://127.0.0.1:8080"
target="_blank">127.0.0.1:8080</a>";<br>
><br>
> $boxes[$box_id]['mi']['conn']="/tmp/opensips_fifo";<br>
><br>
> // monit host:port<br>
><br>
> $boxes[$box_id]['monit']['conn']="<a href="http://127.0.0.1:2812"
target="_blank">127.0.0.1:2812</a>";<br>
><br>
> $boxes[$box_id]['monit']['user']="admin";<br>
><br>
> $boxes[$box_id]['monit']['pass']="monit";<br>
><br>
> $boxes[$box_id]['monit']['has_ssl']=0;<br>
><br>
> // description (appears in mi , monit )<br>
><br>
> $boxes[$box_id]['desc']="SIP server";<br>
><br>
> At this point, Monit seems to be working, but Statistics Monitor<br>
> complains<br>
><br>
> "Cannot connect to OpenSIPS Server via Management Interface<br>
> (<a href="http://127.0.0.1/8080" target="_blank">127.0.0.1/8080</a>)<br>
><br>
> "<br>
><br>
> *From:* <a href="mailto:users-bounces@lists.opensips.org">users-bounces@lists.opensips.org</a><br>
> [mailto:<a href="mailto:users-bounces@lists.opensips.org">users-bounces@lists.opensips.org</a>]
*On Behalf Of *Alex Ionescu<br>
> *Sent:* Friday, March 19, 2010 1:42 AM<br>
> *To:* OpenSIPS users mailling list<br>
> *Subject:* Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0<br>
><br>
> 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']="<a href="http://127.0.0.1:8080"
target="_blank">127.0.0.1:8080</a>";<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']="<a href="http://127.0.0.1:2812"
target="_blank">127.0.0.1:2812</a>";<br>
> //you must take the username and password from the monit config file<br>
> (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:<br>
><br>
> New problem:<br>
><br>
> So under opensips-cp/config/boxes.global.inc.php<br>
><br>
> I changed the following:<br>
><br>
> $boxes[$box_id]['mi']['conn']="<a href="http://127.0.0.1:8080"
target="_blank">127.0.0.1:8080</a>";<br>
><br>
> (previously was $boxes[$box_id]['mi']['conn']="/tmp/opensips_fifo";"<br>
><br>
> This seemed to resolve my issue with Systemā Monit<br>
><br>
> However,<br>
><br>
> System ā Statistics Monitor , Systemā SIP Trace , System ā MI<br>
> Commands, and System ā Dispatcher all complain with the following<br>
> on-screen message<br>
><br>
> "Cannot connect to OpenSIPS Server via Management Interface<br>
> (<a href="http://127.0.0.1/8080" target="_blank">127.0.0.1/8080</a>)"<br>
><br>
> So I changed it back to<br>
><br>
> $boxes[$box_id]['mi']['conn']="/tmp/opensips_fifo";<br>
><br>
> But then<br>
><br>
> I notice tools/monit/local.inc.php still doesn't contain any code..??<br>
><br>
> *From:* <a href="mailto:users-bounces@lists.opensips.org">users-bounces@lists.opensips.org</a><br>
> <mailto:<a href="mailto:users-bounces@lists.opensips.org">users-bounces@lists.opensips.org</a>><br>
> [mailto:<a href="mailto:users-bounces@lists.opensips.org">users-bounces@lists.opensips.org</a>]
*On Behalf Of *Christian Vo<br>
> *Sent:* Thursday, March 18, 2010 10:21 AM<br>
> *To:* OpenSIPS users mailling list<br>
> *Subject:* Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0<br>
><br>
> Thx for the notice, I've just downloaded and re-installed the lastest<br>
> 4.0 tarball.. (moved the old dir to backup, and replaced it with the<br>
> new, re-adjusting config parameters along the way.)<br>
><br>
> Not sure if I missed something, but I'm getting this error on-screen now:<br>
><br>
> Under the Systemā Monit tab<br>
><br>
> I see "Primary Sip Server" <a href="http://192.168.0.1:2812"
target="_blank">192.168.0.1:2812</a><br>
><br>
> Followed by "I can't Connect"<br>
><br>
> Something is wrong here, since I adjusted config/boxes.global.inc.php<br>
> so that my only entry (Primary SIP Server) would be using<br>
> <a href="http://127.0.0.1:2812" target="_blank">127.0.0.1:2812</a> for
monit<br>
><br>
> And I don't know where else I'd find any entry for 192.168.0.1 related<br>
> to this..<br>
><br>
> This part was working for me back when I had the previous 4.0 tarball. odd<br>
><br>
> *From:* <a href="mailto:users-bounces@lists.opensips.org">users-bounces@lists.opensips.org</a><br>
> <mailto:<a href="mailto:users-bounces@lists.opensips.org">users-bounces@lists.opensips.org</a>><br>
> [mailto:<a href="mailto:users-bounces@lists.opensips.org">users-bounces@lists.opensips.org</a>]
*On Behalf Of *Alex Ionescu<br>
> *Sent:* Thursday, March 18, 2010 4:46 AM<br>
> *To:* OpenSIPS users mailling list<br>
> *Subject:* Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0<br>
><br>
> Hi,<br>
><br>
> Actually there were a few issues that were found and solved the last<br>
> few days. I hope you won't have anymore problems if you download the<br>
> 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:<br>
><br>
> HI Alex<br>
><br>
> did you find new issue on opensips cp<br>
><br>
> Thank you<br>
><br>
> Ha`<br>
><br>
> --- On *Sat, 3/13/10, Alex Ionescu /<<a href="mailto:alex@opensips.org">alex@opensips.org</a>><br>
> <mailto:<a href="mailto:alex@opensips.org">alex@opensips.org</a>>/*
wrote:<br>
><br>
><br>
> From: Alex Ionescu <<a href="mailto:alex@opensips.org">alex@opensips.org</a>>
<mailto:<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>
> <mailto:<a href="mailto:users@lists.opensips.org">users@lists.opensips.org</a>><br>
> Date: Saturday, March 13, 2010, 9:21 AM<br>
><br>
> 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:<br>
><br>
><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<br>
> opensips-cp version 3 and now it works without problem with<br>
> 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 *Fri, 3/12/10, Alex Ionescu /<<a href="mailto:alex@opensips.org">alex@opensips.org</a>><br>
> </mc/compose?to=<a href="mailto:alex@opensips.org">alex@opensips.org</a>>/*
wrote:<br>
><br>
><br>
> From: Alex Ionescu <<a href="mailto:alex@opensips.org">alex@opensips.org</a>>
</mc/compose?to=<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>
> </mc/compose?to=<a href="mailto:users@lists.opensips.org">users@lists.opensips.org</a>><br>
> Date: Friday, March 12, 2010, 9:02 AM<br>
><br>
> Sorry,<br>
><br>
> My mistake ... the MD5 should be applied on the value not on the field<br>
> name ... So, it is :<br>
><br>
> INSERT INTO ocp_admin_privileges<br>
> (username,password,ha1,available_tools,permissions) values<br>
> ('admin','admin',md5('admin:admin'),'all','all');<br>
><br>
> On 3/12/2010 13:06, Alex Ionescu wrote:<br>
><br>
> Hi,<br>
><br>
> The problem seems to be your "step 11" :<br>
><br>
> step 11. INSERT INTO ocp_admin_privileges<br>
> (username,password,ha1,available_tools,permissions) values<br>
> ('admin','admin','admin:admin','all','all');<br>
><br>
> You must encode the *ha1* field. So, I believe that the correct query<br>
> would be :<br>
><br>
> INSERT INTO ocp_admin_privileges<br>
> (username,password,md5(ha1),available_tools,permissions) values<br>
> ('admin','admin','admin:admin','all','all');<br>
><br>
> Anyway, you can always check the INSTALL file (I think the query is<br>
> located on line 102 or 103).<br>
><br>
> Regards,<br>
><br>
> Alex<br>
><br>
> On 3/12/2010 12:41, Do Nguyen Ha wrote:<br>
><br>
> step 11. INSERT INTO ocp_admin_privileges<br>
> (username,password,ha1,available_tools,permissions) values<br>
> ('admin','admin','admin:admin','all','all');<br>
><br>
> --<br>
> Alex Ionescu<br>
> <a href="http://www.voice-system.ro" target="_blank">www.voice-system.ro</a>
<<a href="http://www.voice-system.ro" target="_blank">http://www.voice-system.ro</a>><br>
><br>
> _______________________________________________<br>
> Users mailing list<br>
> <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<mailto:<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><br>
><br>
><br>
> --<br>
> Alex Ionescu<br>
> <a href="http://www.voice-system.ro" target="_blank">www.voice-system.ro</a>
<<a href="http://www.voice-system.ro" target="_blank">http://www.voice-system.ro</a>><br>
><br>
><br>
> -----Inline Attachment Follows-----<br>
><br>
> _______________________________________________<br>
> Users mailing list<br>
> <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<mailto:<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><br>
><br>
><br>
> _______________________________________________<br>
> Users mailing list<br>
> <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
</mc/compose?to=<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><br>
><br>
><br>
> --<br>
> Alex Ionescu<br>
> <a href="http://www.voice-system.ro" target="_blank">www.voice-system.ro</a>
<<a href="http://www.voice-system.ro" target="_blank">http://www.voice-system.ro</a>><br>
><br>
><br>
> -----Inline Attachment Follows-----<br>
><br>
> _______________________________________________<br>
> Users mailing list<br>
> <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
</mc/compose?to=<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><br>
><br>
><br>
><br>
> _______________________________________________<br>
> Users mailing list<br>
> <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<mailto:<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><br>
><br>
><br>
><br>
><br>
> --<br>
> Alex Ionescu<br>
> <a href="http://www.voice-system.ro" target="_blank">www.voice-system.ro</a>
<<a href="http://www.voice-system.ro" target="_blank">http://www.voice-system.ro</a>><br>
> ------------------------------------------------------------------------<br>
><br>
> This email message is for the sole use of the intended recipient(s)<br>
> and may contain confidential information. Any unauthorized review,<br>
> use, disclosure or distribution is prohibited. If you are not the<br>
> intended recipient, please contact the sender by reply email and<br>
> destroy all copies of the original message.<br>
><br>
> ------------------------------------------------------------------------<br>
><br>
><br>
> _______________________________________________<br>
> Users mailing list<br>
> <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<mailto:<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><br>
><br>
><br>
><br>
><br>
> --<br>
> Alex Ionescu<br>
> <a href="http://www.voice-system.ro" target="_blank">www.voice-system.ro</a>
<<a href="http://www.voice-system.ro" target="_blank">http://www.voice-system.ro</a>><br>
> ------------------------------------------------------------------------<br>
><br>
> _______________________________________________<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><br>
><br>
<br>
_______________________________________________<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><o:p></o:p></p>
</div>
</div>
</div>
<p class=MsoNormal><br>
<br clear=all>
<br>
-- <br>
TC<o:p></o:p></p>
</div>
</body>
</html>