[OpenSIPS-Users] OPensips-CP Error // MDB2 Error: no such field //

Aman goforaman at gmail.com
Sat Apr 23 19:42:41 CEST 2011 

Please help me out for this.

Rgds,
Aman

On Wed, Apr 20, 2011 at 2:22 PM, <users-request at lists.opensips.org> wrote:

> Send Users mailing list submissions to
>        users at lists.opensips.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>        http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> or, via email, send a message with subject or body 'help' to
>        users-request at lists.opensips.org
>
> You can reach the person managing the list at
>        users-owner at lists.opensips.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Users digest..."
>
>
> Today's Topics:
>
>   1. Future of 1.6 and 2.0 (Simon Casa)
>   2. Re: correlating Call-IDs of top-hidden dialogs (Jeff Pyle)
>   3. Re: Future of 1.6 and 2.0 (Brett Nemeroff)
>   4. OPensips-CP Error // MDB2 Error: no such field // (Aman)
>   5. Re: Opensips crashing due to out of memory error (John Khvatov)
>   6. Fwd: opensips and RTP PRXOY (Bogdan-Andrei Iancu)
>   7. Opensips didn't take messages (Denis Putyato)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 19 Apr 2011 17:31:27 +0200
> From: Simon Casa <scasa at email.it>
> Subject: [OpenSIPS-Users] Future of 1.6 and 2.0
> To: users at lists.opensips.org
> Message-ID: <4DADAACF.9090108 at email.it>
> Content-Type: text/plain; charset="utf-8"; Format="flowed"
>
> HI all,
>
> I'm planning to develop (in the next months) a new installation based on
> OpenSIPS but I'm worried about the maintenance of this installation.
> Indeed I don't know what is the future of the 1.6.x version of opensips
> and when it will be replaced totally by the coming 2.0.
> Could I know what are the develop, full support, bug fix support last
> date and when do you suggest start using the 2.0?
>
> I don't think the configuration will be compatible for both 1.6 and 2.0,
> or I'm wrong?
> Will the 2.0 be released with the GPL license?
>
> Thank you.
>
>
> Kind regards,
> Simon
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lists.opensips.org/pipermail/users/attachments/20110419/22b482c2/attachment-0001.htm
> >
>
> ------------------------------
>
> Message: 2
> Date: Tue, 19 Apr 2011 11:43:19 -0400
> From: Jeff Pyle <jpyle at fidelityvoice.com>
> Subject: Re: [OpenSIPS-Users] correlating Call-IDs of top-hidden
>        dialogs
> To: OpenSIPS users mailling list <users at lists.opensips.org>
> Message-ID: <C9D325AF.1E7EA%jpyle at fidelityvoice.com>
> Content-Type: text/plain; charset="us-ascii"
>
> Hi Anca,
>
> That sounds quite nice.  I'll keep my eye out for it.
>
>
>
> - Jeff
>
>
> On 4/19/11 5:50 AM, "Anca Vamanu" <anca at opensips.org> wrote:
>
> >Hi Jeff,
> >
> >No, there isn't now a way to get in the script the received and
> >generated callid. But we could implement this, maybe by starting a list
> >of pseudovariables exported by the b2b modules and the first ones to be
> >- new callid, new from tag.
> >
> >Regards,
> >
> >--
> >Anca Vamanu
> >OpenSIPS Developer
> >
> >
> >
> >On 04/19/2011 04:29 AM, Jeff Pyle wrote:
> >> Hello,
> >>
> >> I see messages like this in the log:
> >>   INFO:b2b_logic:b2b_add_dlginfo: Dialog pair:
> >> [6e13029c5fd56bdf0ef2339009984cac at 74.125.91.103] - [B2B.39.5167001]
> >>
> >> I use CDRTool to examine the CDRs of the various proxies.  In my
> >> configuration I've got non-B2B Opensips instances on either side of
> >> the B2B, each generating their own CDRs.  With the Call-ID changing it
> >> becomes more of a challenge to follow the same call through all the
> >> relevant proxies.
> >>
> >> Is there some way to access this association of the two call IDs
> >> inside the script, and write it to db that I could later use to
> >> correlate the calls in a more automated fashion?
> >>
> >>
> >> - Jeff
> >
> >_______________________________________________
> >Users mailing list
> >Users at lists.opensips.org
> >http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
>
> ------------------------------
>
> Message: 3
> Date: Tue, 19 Apr 2011 16:30:51 -0500
> From: Brett Nemeroff <brett at nemeroff.com>
> Subject: Re: [OpenSIPS-Users] Future of 1.6 and 2.0
> To: OpenSIPS users mailling list <users at lists.opensips.org>
> Message-ID: <BANLkTinKzC9S8qOnGxVYbvH-p1Hfos3isA at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> On Tue, Apr 19, 2011 at 10:31 AM, Simon Casa <scasa at email.it> wrote:
>
> >  HI all,
> >
> > I'm planning to develop (in the next months) a new installation based on
> > OpenSIPS but I'm worried about the maintenance of this installation.
> > Indeed I don't know what is the future of the 1.6.x version of opensips
> and
> > when it will be replaced totally by the coming 2.0.
> > Could I know what are the develop, full support, bug fix support last
> date
> > and when do you suggest start using the 2.0?
> >
> >
> Simon,
> I think it's about a 100% bet that the 1.6 and 2.0 configs will not be
> compatible due to some pretty significant architectural changes. However, I
> wouldn't expect that the coming 2.0 release is going to obsolete 1.6
> configurations. I suspect that it will take a few iterations of 2.0
> releases
> before it becomes a preferred standard. For now, I'd plan on 1.6 configs
> unless your deployment is many months out. That's just my $0.02 from the
> perspective of a consultant supporting these systems and not designing
> them.
>
> -Brett
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lists.opensips.org/pipermail/users/attachments/20110419/bad2e5a7/attachment-0001.htm
> >
>
> ------------------------------
>
> Message: 4
> Date: Wed, 20 Apr 2011 05:38:36 +0530
> From: Aman <goforaman at gmail.com>
> Subject: [OpenSIPS-Users] OPensips-CP Error // MDB2 Error: no such
>        field //
> To: users at lists.opensips.org
> Message-ID: <BANLkTimsozyDkiwB5xqf7bk2aT5=-a2K0A at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hi Experts,
>
> I am using opensips-1.6.2-tls with opensips-cp 3.0, PHP 5.3.3 and apache2
> on
> a Dabian environment. successfully installed the CDRTool, freeradius and
> working also. When i try to see CDRS using opensips-CP and submit a search
> query, it showing me
>
> *Failed to issue query, error message : MDB2 Error: no such field*
>
>
> Remaining option on control panel are working fine, i am unable to find any
> reason why this is behaving like this as my file boxes.global.inc.php like
> configured as below,
>
> $box_id=0;
> // mi host:port pair || fifo_file
> $boxes[$box_id]['mi']['conn']="/tmp/opensips_fifo";
> // monit host:port
> $boxes[$box_id]['monit']['conn']="192.168.100.29:2812";
> $boxes[$box_id]['monit']['user']="admin";
> $boxes[$box_id]['monit']['pass']="monit";
> $boxes[$box_id]['monit']['has_ssl']=0;
>
>
>
> Please advice i am working on this from last two days searching on internet
> but no luck, thanks in advance.
>
>
>
> Rdgs,
> Aman
>
> **
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lists.opensips.org/pipermail/users/attachments/20110420/80dc32b5/attachment-0001.htm
> >
>
> ------------------------------
>
> Message: 5
> Date: Wed, 20 Apr 2011 11:18:08 +0400
> From: John Khvatov <ivaxer at gmail.com>
> Subject: Re: [OpenSIPS-Users] Opensips crashing due to out of memory
>        error
> To: OpenSIPS users mailling list <users at lists.opensips.org>
> Message-ID: <BB74F43F-B117-4BD0-9899-5AB941FE3850 at gmail.com>
> Content-Type: text/plain; charset=us-ascii
>
> Hello Anca,
>
> On 19.04.2011, at 13:21, Anca Vamanu wrote:
>
> > Hi John,
> >
> > That looks very bad...
> > Please help me investigate this.
> >
> > What you can do is to compile with memory debugging support - in
> Makefile.defs search -DDBG_QM_MALLOC line, uncomment it, move it above
> -DF_MALLOC line and comment this line with -DF_MALLOC. Then recompile and
> reinstall all. Also set mem_dump=1 in your config.
>
> I've built OpenSIPS from latest SVN head (branch 1.6) as you said.
>
> > After a couple of hours, when you see that the memory is high - you can
> either shutdown opensips or ask it to dump the memory by calling 'kill
> -SIGUSR1 lowest_pid' , where lowest_pid is the smallest pid when doing 'ps
> aux | grep opensips'. It will dump lots of info in the log file(this why is
> better to do this quite soon - maybe after 1-2 hours in the rhythm the
> memory increases for you). In the logs you will see all the chunks of memory
> and where they were allocated. Look from the end if there is a function
> repeated  many times. You can also send the part of the log with the dump to
> me ( not on the list, because it will be quite large).
>
> Done.
>
> SIGUSR1:
> http://dev.sgu.ru/pub/memdump.log.gz
>
> SIGTERM:
> http://dev.sgu.ru/pub/memdump.log.shutdown.gz
>
>
> > On 04/19/2011 10:30 AM, John Khvatov wrote:
> >> Hello Anca,
> >>
> >> Sorry, the memory leak is still here:
> >>
> >> http://dev.sgu.ru/pub/opensips_memory_usage.2.png
> >>
> >> BTW, dialog module was not used in my script. I've removed loadmodule
> before update.
> >>
> >>
> >> On 12.04.2011, at 0:00, John Khvatov wrote:
> >>
> >>> Hello Anca,
> >>>
> >>> Thank you for  the advice. I built OpenSIPS from rev7863.  BTW, rev7824
> was used in production.
> >>>
> >>> I'll let you know the result within a few days.
> >>>
> >>>
> >>> On 11.04.2011, at 17:48, Anca Vamanu wrote:
> >>>
> >>>> Hi John,
> >>>>
> >>>> Can you please take the pua and pua_usrloc and dialog modules from
> svn? There were some problems discovered in there and fixed.
> >>>> The svn version of these modules ( 1.6 branch) is stable, we are using
> it in production.
> >>>>
> >>>> Regards,
> >>>> --
> >>>> Anca Vamanu
> >>>> OpenSIPS Developer
> >>>>
> >>>>
> >>>>
> >>>> On 04/11/2011 12:45 AM, John Khvatov wrote:
> >>>>> On 10.04.2011, at 8:35, Ronald Cepres wrote:
> >>>>>
> >>>>>> Have you tried increasing the amount of allocated memory for
> OpenSIPS?
> >>>>> I have same problem with OpenSIPS since 1.6.0 release. OpenSIPS has
> huge memory leak somewhere. Increasing the amount of allocated memory helps
> only delay crash.
> >>>>>
> >>>>> Memory usage graph (1.6.4, KkB is MB):
> >>>>> http://dev.sgu.ru/pub/opensips_memory_usage.png
> >>>>>
> >>>>> I use the following modules:
> >>>>>
> >>>>> $ grep loadmodule opensips.cfg
> >>>>> loadmodule "signaling.so"
> >>>>> loadmodule "sl.so"
> >>>>> loadmodule "tm.so"
> >>>>> loadmodule "maxfwd.so"
> >>>>> loadmodule "rr.so"
> >>>>> loadmodule "textops.so"
> >>>>> loadmodule "localcache.so"
> >>>>> loadmodule "mi_fifo.so"
> >>>>> loadmodule "mi_datagram.so"
> >>>>> loadmodule "db_flatstore.so"
> >>>>> loadmodule "siptrace.so"
> >>>>> loadmodule "db_text.so"
> >>>>> loadmodule "db_postgres.so"
> >>>>> loadmodule "db_http.so"
> >>>>> loadmodule "usrloc.so"
> >>>>> loadmodule "registrar.so"
> >>>>> loadmodule "auth.so"
> >>>>> loadmodule "auth_db.so"
> >>>>> loadmodule "uri.so"
> >>>>> loadmodule "domain.so"
> >>>>> loadmodule "dialog.so"
> >>>>> loadmodule "mediaproxy.so"
> >>>>> loadmodule "nat_traversal.so"
> >>>>> loadmodule "permissions.so"
> >>>>> loadmodule "alias_db.so"
> >>>>> loadmodule "avpops.so"
> >>>>> loadmodule "mi_xmlrpc.so"
> >>>>> loadmodule "dialplan.so"
> >>>>> loadmodule "pike.so"
> >>>>> loadmodule "pua.so"
> >>>>> loadmodule "pua_usrloc.so"
> >>>>>
> >>>>> --
> >>>>> WBR, John Khvatov
> >>> --
> >>> WBR, John Khvatov
> >
> >
> > _______________________________________________
> > Users mailing list
> > Users at lists.opensips.org
> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
> --
> WBR, John Khvatov
>
>
>
>
> ------------------------------
>
> Message: 6
> Date: Wed, 20 Apr 2011 11:32:22 +0300
> From: Bogdan-Andrei Iancu <bogdan at opensips.org>
> Subject: [OpenSIPS-Users] Fwd: opensips and RTP PRXOY
> To: "users at lists.opensips.org" <users at lists.opensips.org>
> Message-ID: <4DAE9A16.2010206 at opensips.org>
> Content-Type: text/plain; charset="iso-8859-1"; Format="flowed"
>
>
>
> -------- Original Message --------
> Subject:        opensips and RTP PRXOY
> Date:   Wed, 20 Apr 2011 02:24:28 -0400
> From:   giti at dataproducts.ae
> To:     users-owner at lists.opensips.org
>
>
>
> Hi
>     I am new to opensips and i need help  . i am using fedora 14 and
> opensips-1.6.4 has been installed by yum install on the server . i
> have installed rtpproxy-1.2 also
> now
> i need a configuration ( opensips.cfg) for the rtpproxy and opensips
> integration , i have found some samples over internet but seems all
> documents and sample are about ver 1.5 and does not work on 1.6.4
> thanks
> giti
>
>
>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lists.opensips.org/pipermail/users/attachments/20110420/7890a55d/attachment-0001.htm
> >
>
> ------------------------------
>
> Message: 7
> Date: Wed, 20 Apr 2011 12:52:11 +0400
> From: "Denis Putyato" <denis7979 at mail.ru>
> Subject: [OpenSIPS-Users] Opensips didn't take messages
> To: "'OpenSIPS users mailling list'" <users at lists.opensips.org>
> Message-ID: <00a501cbff38$3cd5ff20$b681fd60$@ru>
> Content-Type: text/plain; charset="utf-8"
>
> Hello!
>
>
>
> I found a big problem with Opensips in my installation.
>
>
>
> Once I  started receive acc record in acc table which had a big duration
> (more than time conversation which is 9999).
>
> During analyzing these calls I found that Opensips didn`t take BYE which
> was send by another sip endpoints.
>
>
>
>
>
> I initiated debug 5 in log file and result of the debug you can see in
> debug.txt which I attached to the letter
>
>
>
> In debug from 08:08:39 and till 08:21:40 I have only one type of messages
> dealing with mi_fifo and nothing more.
>
> In the time range Opensips didn?t take any messages including BYE.
>
>
>
> After 08:41 everything seems began fine, because I see in log more
> information dialing with messages, parsing and so on.
>
>
>
> During problem:
>
> Opensips didn?t restart
>
> All processes running
>
>
>
>
>
> Opensips 1.6.4-2
>
>
>
> Thank you for any help
>
>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lists.opensips.org/pipermail/users/attachments/20110420/5c1fef88/attachment.htm
> >
> -------------- next part --------------
> An embedded and charset-unspecified text was scrubbed...
> Name: debug.txt
> URL: <
> http://lists.opensips.org/pipermail/users/attachments/20110420/5c1fef88/attachment.txt
> >
>
> ------------------------------
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
> End of Users Digest, Vol 33, Issue 54
> *************************************
>



-- 
*Cheers,
Amanpreet Singh *
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20110423/516401c1/attachment-0001.htm>

More information about the Users mailing list