Tried running ocp and i'm getting this error on adding users. Failed to issue query, error message : MDB2 Error: no such field I'm not getting any useful error to start tracing.
TC. On Sat, Mar 20, 2010 at 12:10 AM, Christian Vo <c...@nvidia.com> wrote: > 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 > -- TC
_______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users