[OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0

Christian Vo cvo at nvidia.com
Fri Mar 19 23:10:13 CET 2010


Thanks Anca,

I think that's fixed the problem with smonitor,
I still can't add users though, 

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,...

-----Original Message-----
From: Anca Vamanu [mailto:anca at opensips.org] 
Sent: Friday, March 19, 2010 2:41 PM
To: OpenSIPS users mailling list
Cc: Christian Vo
Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0

Forward from Alex:
---

Hi Christian,

Please check the following :
In the OpenSIPS config :
- if you have loaded the mi_fifo module;
loadmodule "mi_fifo.so"
- if you have declared the correct fifo parameters (if the fifo file 
name is the same as in Control Panel boxes config and if it has right 
permissions set);
- if I'm not wrong it should be something like this :
modparam("mi_fifo", "fifo_name", "/tmp/opensips_fifo")
modparam("mi_fifo", "fifo_mode", 0666)

Leave the db.inc.php commented as it was before and please check the 
stuff above and let me know.

Regards,
Alex

---

Christian Vo wrote:
>
> Forgot to add:
>
> I had smonitor's db.inc.php settings uncommented,
>
> Now getting this error instead
>
> [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: http://10.32.0.97/cp/menu.php
>
> I'm very sure I installed pear and the related parts as per the 
> install guide..
>
> *From:* Christian Vo
> *Sent:* Friday, March 19, 2010 9:57 AM
> *To:* OpenSIPS users mailling list
> *Subject:* RE: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0
>
> Thx Alex,
>
> Confirming that these are my settings:
>
> // each server is a box
>
> $box_id=0;
>
> // mi host:port pair || fifo_file
>
> // $boxes[$box_id]['mi']['conn']="127.0.0.1:8080";
>
> $boxes[$box_id]['mi']['conn']="/tmp/opensips_fifo";
>
> // monit host:port
>
> $boxes[$box_id]['monit']['conn']="127.0.0.1:2812";
>
> $boxes[$box_id]['monit']['user']="admin";
>
> $boxes[$box_id]['monit']['pass']="monit";
>
> $boxes[$box_id]['monit']['has_ssl']=0;
>
> // description (appears in mi , monit )
>
> $boxes[$box_id]['desc']="SIP server";
>
> At this point, Monit seems to be working, but Statistics Monitor 
> complains
>
> "Cannot connect to OpenSIPS Server via Management Interface 
> (127.0.0.1/8080)
>
> "
>
> *From:* users-bounces at lists.opensips.org 
> [mailto:users-bounces at lists.opensips.org] *On Behalf Of *Alex Ionescu
> *Sent:* Friday, March 19, 2010 1:42 AM
> *To:* OpenSIPS users mailling list
> *Subject:* Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0
>
> Hi Christian,
>
> Your boxes config must look like this :
>
> $box_id=0;
> // mi host:port pair || fifo_file
> //$boxes[$box_id]['mi']['conn']="127.0.0.1:8080";
> //i guess you are using fifo, not xmlrpc so :
> $boxes[$box_id]['mi']['conn']="/tmp/opensips_proxy_fifo";
>
> // monit host:port => this is for monit to work ok
> $boxes[$box_id]['monit']['conn']="127.0.0.1:2812";
> //you must take the username and password from the monit config file 
> (monitrc).
> $boxes[$box_id]['monit']['user']="username";
> $boxes[$box_id]['monit']['pass']="password";
> // if you want to enable ssl
> $boxes[$box_id]['monit']['has_ssl']=1;
>
> Please re-check your config and let me know if it works now.
>
> Regards,
> Alex
>
> On 3/19/2010 01:42, Christian Vo wrote:
>
> New problem:
>
> So under opensips-cp/config/boxes.global.inc.php
>
> I changed the following:
>
> $boxes[$box_id]['mi']['conn']="127.0.0.1:8080";
>
> (previously was $boxes[$box_id]['mi']['conn']="/tmp/opensips_fifo";"
>
> This seemed to resolve my issue with Systemà Monit
>
> However,
>
> System à Statistics Monitor , Systemà SIP Trace , System à MI 
> Commands, and System à Dispatcher all complain with the following 
> on-screen message
>
> "Cannot connect to OpenSIPS Server via Management Interface 
> (127.0.0.1/8080)"
>
> So I changed it back to
>
> $boxes[$box_id]['mi']['conn']="/tmp/opensips_fifo";
>
> But then
>
> I notice tools/monit/local.inc.php still doesn't contain any code..??
>
> *From:* users-bounces at lists.opensips.org 
> <mailto:users-bounces at lists.opensips.org> 
> [mailto:users-bounces at lists.opensips.org] *On Behalf Of *Christian Vo
> *Sent:* Thursday, March 18, 2010 10:21 AM
> *To:* OpenSIPS users mailling list
> *Subject:* Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0
>
> 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.)
>
> Not sure if I missed something, but I'm getting this error on-screen now:
>
> Under the Systemà Monit tab
>
> I see "Primary Sip Server" 192.168.0.1:2812
>
> Followed by "I can't Connect"
>
> 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
>
> And I don't know where else I'd find any entry for 192.168.0.1 related 
> to this..
>
> This part was working for me back when I had the previous 4.0 tarball. odd
>
> *From:* users-bounces at lists.opensips.org 
> <mailto:users-bounces at lists.opensips.org> 
> [mailto:users-bounces at lists.opensips.org] *On Behalf Of *Alex Ionescu
> *Sent:* Thursday, March 18, 2010 4:46 AM
> *To:* OpenSIPS users mailling list
> *Subject:* Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0
>
> Hi,
>
> 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.
>
> So, give it a try and let me know.
>
> Regards,
> Alex
>
> On 3/18/2010 13:35, ha do wrote:
>
> HI Alex
>
> did you find new issue on opensips cp
>
> Thank you
>
> Ha`
>
> --- On *Sat, 3/13/10, Alex Ionescu /<alex at opensips.org> 
> <mailto:alex at opensips.org>/* wrote:
>
>
> From: Alex Ionescu <alex at opensips.org> <mailto:alex at opensips.org>
> Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0
> To: "OpenSIPS users mailling list" <users at lists.opensips.org> 
> <mailto:users at lists.opensips.org>
> Date: Saturday, March 13, 2010, 9:21 AM
>
> Hi,
>
> I will investigate the problem and will let you know if I find any issue.
>
> Regards,
> Alex
>
> On 3/13/2010 06:39, Do Nguyen Ha wrote:
>
>
> Hi Alex
>
> here is mysql query:
> mysql> select * from ocp_admin_privileges\G;
> *************************** 1. row ***************************
> id: 58
> first_name:
> last_name:
> username: admin
> password: admin
> ha1: d2abaa37a7c3db1137d385e1d8c15fd2
> available_tools: all
> permissions: all
>
> so i am still getting the invalid username on opensips-cp version 4
> 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
>
> i dont change anything and step i do :
> step 1. cd /var/www
> step 2. delete folder opensips-cp
> step 3. download the opensips-cp_3.0.tar.gz
> step 4. untar the file opensips-cp_3.0
> step 5. chown www-data:www-data opensips-cp -R
>
> Thank you for your help
> Ha
>
> --- On *Fri, 3/12/10, Alex Ionescu /<alex at opensips.org> 
> </mc/compose?to=alex at opensips.org>/* wrote:
>
>
> From: Alex Ionescu <alex at opensips.org> </mc/compose?to=alex at opensips.org>
> Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0
> To: "OpenSIPS users mailling list" <users at lists.opensips.org> 
> </mc/compose?to=users at lists.opensips.org>
> Date: Friday, March 12, 2010, 9:02 AM
>
> Sorry,
>
> My mistake ... the MD5 should be applied on the value not on the field 
> name ... So, it is :
>
> INSERT INTO ocp_admin_privileges 
> (username,password,ha1,available_tools,permissions) values 
> ('admin','admin',md5('admin:admin'),'all','all');
>
> On 3/12/2010 13:06, Alex Ionescu wrote:
>
> Hi,
>
> The problem seems to be your "step 11" :
>
> step 11. INSERT INTO ocp_admin_privileges 
> (username,password,ha1,available_tools,permissions) values 
> ('admin','admin','admin:admin','all','all');
>
> You must encode the *ha1* field. So, I believe that the correct query 
> would be :
>
> INSERT INTO ocp_admin_privileges 
> (username,password,md5(ha1),available_tools,permissions) values 
> ('admin','admin','admin:admin','all','all');
>
> Anyway, you can always check the INSTALL file (I think the query is 
> located on line 102 or 103).
>
> Regards,
>
> Alex
>
> On 3/12/2010 12:41, Do Nguyen Ha wrote:
>
> step 11. INSERT INTO ocp_admin_privileges 
> (username,password,ha1,available_tools,permissions) values 
> ('admin','admin','admin:admin','all','all');
>
> -- 
> Alex Ionescu
> www.voice-system.ro <http://www.voice-system.ro> 
>  
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org <mailto:Users at lists.opensips.org>
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>   
>
> -- 
> Alex Ionescu
> www.voice-system.ro <http://www.voice-system.ro> 
>
>
> -----Inline Attachment Follows-----
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org <mailto:Users at lists.opensips.org>
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>  
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org </mc/compose?to=Users at lists.opensips.org>
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>   
>
> -- 
> Alex Ionescu
> www.voice-system.ro <http://www.voice-system.ro> 
>
>
> -----Inline Attachment Follows-----
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org </mc/compose?to=Users at lists.opensips.org>
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>  
>  
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org <mailto:Users at lists.opensips.org>
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>   
>
>
>
> -- 
> Alex Ionescu
> www.voice-system.ro <http://www.voice-system.ro> 
> ------------------------------------------------------------------------
>
> 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.
>
> ------------------------------------------------------------------------
>  
>  
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org <mailto:Users at lists.opensips.org>
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>   
>
>
>
> -- 
> Alex Ionescu
> www.voice-system.ro <http://www.voice-system.ro> 
> ------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>   



More information about the Users mailing list