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.<br><br><div class="gmail_quote">
On Sat, Mar 20, 2010 at 12:10 AM, Christian Vo <span dir="ltr"><<a href="mailto:cvo@nvidia.com">cvo@nvidia.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
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,...<br>
<div class="im"><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<br>
</div><div><div></div><div class="h5">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><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>TC<br>