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:a...@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-boun...@lists.opensips.org > [mailto:users-boun...@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-boun...@lists.opensips.org > <mailto:users-boun...@lists.opensips.org> > [mailto:users-boun...@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-boun...@lists.opensips.org > <mailto:users-boun...@lists.opensips.org> > [mailto:users-boun...@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 /<a...@opensips.org> > <mailto:a...@opensips.org>/* wrote: > > > From: Alex Ionescu <a...@opensips.org> <mailto:a...@opensips.org> > Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 > To: "OpenSIPS users mailling list" <users@lists.opensips.org> > <mailto:users@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 /<a...@opensips.org> > </mc/compose?to=a...@opensips.org>/* wrote: > > > From: Alex Ionescu <a...@opensips.org> </mc/compose?to=a...@opensips.org> > Subject: Re: [OpenSIPS-Users] Problem with OpenSIPS Control Panel 4.0 > To: "OpenSIPS users mailling list" <users@lists.opensips.org> > </mc/compose?to=us...@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@lists.opensips.org <mailto:Users@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@lists.opensips.org <mailto:Users@lists.opensips.org> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > _______________________________________________ > Users mailing list > Users@lists.opensips.org </mc/compose?to=us...@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@lists.opensips.org </mc/compose?to=us...@lists.opensips.org> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > _______________________________________________ > Users mailing list > Users@lists.opensips.org <mailto:Users@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@lists.opensips.org <mailto:Users@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@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > _______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users