[OpenSIPS-Users] Stored Procedure /usr/sr/opensips_cdrs_bk.sql does not exist
Aman
goforaman at gmail.com
Thu Jun 3 12:36:16 CEST 2010
Hi Bogdan,
Thanks for your quick reply.
I am working with accounting part of OpenSIPS. Now decided to use
Free-RADIUS instead MySQL for accounting and i think don't need any stored
Procedure for accounting with Free-RADIUS.
Thanks,
Amanpreet Singh
On Thu, Jun 3, 2010 at 3:30 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. Re: OpenXCAP and Presence with SNOM version 8.2.29 (Dan Pascu)
> 2. Re: OpenXCAP and Presence with SNOM version 8.2.29 (osiris123d)
> 3. Re: B2b module topology hiding (Douglas Lane)
> 4. Re: OpenXCAP and Presence with SNOM version 8.2.29 (Dan Pascu)
> 5. Stored Procedure /usr/sr/opensips_cdrs_bk.sql does not exist
> (Aman)
> 6. Re: Stored Procedure /usr/sr/opensips_cdrs_bk.sql does not
> exist (Bogdan-Andrei Iancu)
> 7. Re: a little help (Bogdan-Andrei Iancu)
> 8. Re: two opensips using one location table (Bogdan-Andrei Iancu)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Thu, 3 Jun 2010 00:11:08 +0300
> From: Dan Pascu <dan at ag-projects.com>
> Subject: Re: [OpenSIPS-Users] OpenXCAP and Presence with SNOM version
> 8.2.29
> To: OpenSIPS users mailling list <users at lists.opensips.org>
> Message-ID: <776E6AC4-9298-48E3-AC28-8E92D53E7157 at ag-projects.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed; delsp=yes
>
>
> On 2 Jun 2010, at 17:12, osiris123d wrote:
>
> > Sorry Saul,
> > ?
> > I got my Sniff's messed up.? It should have been the other way
> > around (Should have double checked my message).
> > ?
> > Attached is a txt file with both the Firefox and Snom sniff.? I
> > have also included a good Counterpath Bria sniff from a different
> > user.? From the looks of it the difference here for the good HTTP
> > GETS is that the GET starts with the /[hidden email]/ path for the
> > URI, whereas the SNOM phone starts with
> https://xcap.server.com:443/xcap-root@.../
> > path.
>
> It appears that openxcap has a problem in handling absolute URIs in
> the request, this is why it prepends https://server-host/ to the
> request URI and you get the double host in the error message in the log.
> We'll check it. Most likely openxcap assumes that it has to receive an
> absolute path. I'm not sure if the xcap rfc specifies otherwise, but
> at least the http rfc says that the requested resource can be an
> absolute URI or an absolute path.
>
> --
> Dan
>
>
>
>
>
>
>
>
>
> ------------------------------
>
> Message: 2
> Date: Wed, 2 Jun 2010 14:16:44 -0700 (PDT)
> From: osiris123d <duane.larson at gmail.com>
> Subject: Re: [OpenSIPS-Users] OpenXCAP and Presence with SNOM version
> 8.2.29
> To: users at lists.opensips.org
> Message-ID: <1275513404665-5132632.post at n2.nabble.com>
> Content-Type: text/plain; charset=us-ascii
>
>
> Sweet. I might have found my first bug on this forum .
>
> I went ahead and posted my findings on Snom's forum today. I will see what
> they say. Also would like to hear what you find after checking.
>
> Thanks for keeping up with this.
> --
> View this message in context:
> http://opensips-open-sip-server.1449251.n2.nabble.com/OpenXCAP-and-Presence-with-SNOM-version-8-2-29-tp5080886p5132632.html
> Sent from the OpenSIPS - Users mailing list archive at Nabble.com.
>
>
>
> ------------------------------
>
> Message: 3
> Date: Thu, 03 Jun 2010 01:27:14 +0200
> From: Douglas Lane <doug at wd.co.za>
> Subject: Re: [OpenSIPS-Users] B2b module topology hiding
> To: users at lists.opensips.org
> Message-ID: <4C06E8D2.8010805 at wd.co.za>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Hi Anca,
>
> Ok I just need some clarity here as I think what I'm trying to achieve
> with the b2b module is not possible.
>
> The topology needs to be hidden on any request between the UA <------>
> OpenSIPS SBC as well as OpenSIPS SBC <--------> OpenSIPS Router.
>
> The reason this needs to happen is that the Router will then forward
> calls onto an Asterisk server for routing - the problem I've found is if
> you have 2 proxy servers upstream from asterisk, the ACK fails to be
> transported to asterisk due to Asterisk not adding itself to the Via
> header list.
>
> So would you be able to confirm if the above is possible? The UA must
> only ever see the OpenSIPS SBC, and the Router must only ever see the
> OpenSIPS SBC - so effectively, the OpenSIPS SBC is acting as a true B2BUA.
>
> I thank you for all your assistance thus far.
>
> Thanks
> Doug
>
> On 2010/05/26 5:44 PM, Anca Vamanu wrote:
> > No! :)
> > I told you in the other mail - it is compulsory to call b2b_init_request
> > on an initial Invite.
> >
> > Anca
> >
> >
> > Douglas Lane wrote:
> >
> >> Hi Anca,
> >>
> >> Thanks so much for the assistance. So would I then only call b2b_init in
> >> the onreply_route block?
> >>
> >> This should make the concept a lot simpler.
> >>
> >> Thanks
> >> Doug
> >>
> >>
> >> On 2010/05/26 3:27 PM, Anca Vamanu wrote:
> >>
> >>
> >>> Hi Douglas,
> >>>
> >>> It seems a bit strange what you have there and I really don't believe
> >>> that it can work. If you send 403 to the b2bua, it will send the 403
> >>> back to the caller.
> >>> The normal way to do this is first to pass the request to the Router
> and
> >>> the router to pass the request back to the SBC and only at this time to
> >>> call b2b_init on the request to hide the topology.
> >>>
> >>> Regards,
> >>>
> >>>
> >>>
> >>>
> >> _______________________________________________
> >> Users mailing list
> >> Users at lists.opensips.org
> >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >>
> >>
> >>
> >
> >
>
>
>
> ------------------------------
>
> Message: 4
> Date: Thu, 3 Jun 2010 04:12:35 +0300
> From: Dan Pascu <dan at ag-projects.com>
> Subject: Re: [OpenSIPS-Users] OpenXCAP and Presence with SNOM version
> 8.2.29
> To: OpenSIPS users mailling list <users at lists.opensips.org>
> Message-ID: <57CFECFF-4A8C-48DA-BB3A-6689EAA289FA at ag-projects.com>
> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
>
>
> On 3 Jun 2010, at 00:16, osiris123d wrote:
>
> >
> > Sweet. I might have found my first bug on this forum .
> >
> > I went ahead and posted my findings on Snom's forum today. I will
> > see what
> > they say. Also would like to hear what you find after checking.
>
> Unless the xcap RFC has some particular specification about the format
> of the resource in the GET request, that overrides what the http RFC
> says, I'd say it's a bug. If so it'll be fixed.
>
> --
> Dan
>
>
>
>
>
>
>
>
>
> ------------------------------
>
> Message: 5
> Date: Thu, 3 Jun 2010 12:48:50 +0530
> From: Aman <goforaman at gmail.com>
> Subject: [OpenSIPS-Users] Stored Procedure
> /usr/sr/opensips_cdrs_bk.sql does not exist
> To: users at lists.opensips.org
> Message-ID:
> <AANLkTinNM3vDEz2OljQdicqgwuX8hsvILj7dyf8jEBGH at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Greetings,
>
> I am Working with CDRs on OpenSIPs 1.6, when tried to insert the
> stored procedure
> /usr/sr/opensips_cdrs_bk.sql, it didn't work as unable to locate the file
> 'opensips_cdrs_bk.sql' in the specified directory. I tried to find it other
> parts but didn't success ed.
>
> Please advice to insert the stored procedure to complete the CDR part, any
> suggestions.
>
>
>
> Thanks,
> Amanpreet Singh
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://lists.opensips.org/pipermail/users/attachments/20100603/42456c68/attachment.html
>
> ------------------------------
>
> Message: 6
> Date: Thu, 03 Jun 2010 11:19:33 +0300
> From: Bogdan-Andrei Iancu <bogdan at voice-system.ro>
> Subject: Re: [OpenSIPS-Users] Stored Procedure
> /usr/sr/opensips_cdrs_bk.sql does not exist
> To: OpenSIPS users mailling list <users at lists.opensips.org>
> Message-ID: <4C076595.3010709 at voice-system.ro>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Hi Aman,
>
> where have you learned about this /usr/sr/opensips_cdrs_bk.sql procedure ?
>
> I'm asking as the only CDR procedure is provided by OpenSIPS CP, by the
> CDRviewer tool - see http://opensips-cp.sourceforge.net/ ->Documentation
> -> Installation guide.
>
> Regards,
> Bogdan
>
> Aman wrote:
> > Greetings,
> >
> > I am Working with CDRs on OpenSIPs 1.6, when tried to insert the
> > stored procedure
> > /usr/sr/opensips_cdrs_bk.sql, it didn't work as unable to locate the
> > file 'opensips_cdrs_bk.sql' in the specified directory. I tried to
> > find it other parts but didn't success ed.
> >
> > Please advice to insert the stored procedure to complete the CDR part,
> > any suggestions.
> >
> >
> >
> > Thanks,
> > Amanpreet Singh
> > ------------------------------------------------------------------------
> >
> > _______________________________________________
> > Users mailing list
> > Users at lists.opensips.org
> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >
>
>
> --
> Bogdan-Andrei Iancu
> www.voice-system.ro
>
>
>
>
> ------------------------------
>
> Message: 7
> Date: Thu, 03 Jun 2010 11:24:29 +0300
> From: Bogdan-Andrei Iancu <bogdan at voice-system.ro>
> Subject: Re: [OpenSIPS-Users] a little help
> To: OpenSIPS users mailling list <users at lists.opensips.org>
> Message-ID: <4C0766BD.2050104 at voice-system.ro>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Hi Albert
>
> Albert Paijmans wrote:
> > Thanks,
> >
> > My background is old analog telephony systems and I know a little bit
> > of Asterisk.
> > With Asterisk we do not allow reinvites and it does most things we
> > want. And it is relatively easy to secure an Asterisk server.
> I wouldn't bet on it
> > Reinvites are to make sure nat issues do not show up.
> neither on this.
> >
> > What I am trying to do is set up a proxy and registrar for 100.000
> > subscribers. It's behaviour should be stateful. It should allow
> > anonymous invites for subscribers (extensions) and alias database. So
> > you could call form Ekiga.net to our domain. Our subscribers
> > (extensions) should be authenticated and allowed to dial other domains
> > and pstn. Because of nat issues every call must be send to Asterisk.
> >
> > So after an invite from subscriber 101 to subscriber 102 (usrloc)
> > dialplan rewrites to usrloc, usrloc is then translated to loadbalancer
> > and send out to an Asterisk server.
> >
> > No matter where you are dialing to you will always be forwarded to a
> > media server for rtp.
> > That's why I asked about the t_onreply function.
> but what is the actual problem you are facing (that makes you think that
> onreply() is the answer) ? - the onreply route is used only for
> inspecting the received replies, without any routing power.
> >
> > I am sorry that I am not so good in this programming language. :(
> We all learn each day :)
>
> Regards,
> Bogdan
> >
> >
> > Albert
> >
> >
> > On Wed, Jun 2, 2010 at 8:48 PM, Bogdan-Andrei Iancu
> > <bogdan at voice-system.ro <mailto:bogdan at voice-system.ro>> wrote:
> >
> > Hi Albert,
> >
> > I do not fully understand what you want to achieve - maybe
> > describing a
> > simple flow (logical point of view) will really help in helping you.
> >
> > Best regards,
> > Bogdan
> >
> > Albert Paijmans wrote:
> > > Hi,
> > >
> > > I am a bit at a loss right now, I have a script wich does dialplan
> > > translations but permission and group modules are loaded,
> > registration
> > > fails.
> > > The dialplan module and avpops should give an attribute to a
> number.
> > > Also I am wondering (since the script does not work I can''t test
> > > this) if a t_relpy route on usrloc would work.
> > > So after OpenSIPS does database lookup for extensions and db_alias
> > > sends an invite and relay both extensions to an Asterisk server via
> > > gateway list.
> > >
> > > I have send the opensips.cfg as attachement
> > >
> > > Thanks
> > >
> > > Albert
> > >
> >
>
>
> --
> Bogdan-Andrei Iancu
> www.voice-system.ro
>
>
>
>
> ------------------------------
>
> Message: 8
> Date: Thu, 03 Jun 2010 11:27:17 +0300
> From: Bogdan-Andrei Iancu <bogdan at voice-system.ro>
> Subject: Re: [OpenSIPS-Users] two opensips using one location table
> To: OpenSIPS users mailling list <users at lists.opensips.org>
> Message-ID: <4C076765.5000507 at voice-system.ro>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Jeff Pyle wrote:
> > Hi Bogdan,
> >
> > On Jun 2, 2010, at 11:22 AM, Bogdan-Andrei Iancu wrote:
> >
> >
> >> Hi Jeff,
> >>
> >> Jeff Pyle wrote:
> >>
> >>> Hello,
> >>>
> >>> There was a post a little while back where the goal was to have two
> Opensips instances instances use one location table, but have each Opensips
> instance load only its own records.
> >>>
> >>> My application is slightly different. I'd like either Opensips
> instance to load any record from any Opensips instance and use it as its
> own.
> >>>
> >>>
> >> so like multiple opensips sharing the same location content (read /
> >> write) via a single DB table ? For this use the db_mode 3 (DB_ONLY) to
> >> avoid caching.
> >>
> >
> > Yes, exactly. We've run db_mode=3 from day one with excellent success.
> Mysql cluster really shines here. :)
> >
> >
> >>> It seems this is possible using two things:
> >>> mhomed=1
> >>> force_send_socket(<local-IP>:5060);
> >>>
> >>>
> >> not really - that is for opensips running on multiple IP addresses
> >> (multiple listeners) in different networks.
> >>
> >
> > If I don't force_send_socket() won't I see the warning about the specific
> socket not being available, since it belongs to the other opensips instance?
> Or is there another to way to work around that? I'd prefer not to fill up
> my logs with warnings that would be normal in certain modes of operation.
> >
> That's an ugly and costly hack to get rid of that warning (harmless
> anyhow) - better let's move the warning to debug level, what do you say ?
>
> Regards,
> Bogdan
> >
> >
> > - Jeff
> >
> >
> >
> >> Regards,
> >> Bogdan
> >>
> >>> Is it really this simple, or am I missing something?
> >>>
> >>>
> >>>
>
>
> --
> Bogdan-Andrei Iancu
> www.voice-system.ro
>
>
>
>
> ------------------------------
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
> End of Users Digest, Vol 23, Issue 6
> ************************************
>
--
((cheers))
Amanpreet Singh
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20100603/bcb400a8/attachment-0001.htm
More information about the Users
mailing list