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, <[email protected]> wrote: > Send Users mailing list submissions to > [email protected] > > 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 > [email protected] > > You can reach the person managing the list at > [email protected] > > 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 <[email protected]> > Subject: Re: [OpenSIPS-Users] OpenXCAP and Presence with SNOM version > 8.2.29 > To: OpenSIPS users mailling list <[email protected]> > Message-ID: <[email protected]> > 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-r...@.../ > > 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 <[email protected]> > Subject: Re: [OpenSIPS-Users] OpenXCAP and Presence with SNOM version > 8.2.29 > To: [email protected] > Message-ID: <[email protected]> > 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 <[email protected]> > Subject: Re: [OpenSIPS-Users] B2b module topology hiding > To: [email protected] > Message-ID: <[email protected]> > 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 > >> [email protected] > >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users > >> > >> > >> > > > > > > > > ------------------------------ > > Message: 4 > Date: Thu, 3 Jun 2010 04:12:35 +0300 > From: Dan Pascu <[email protected]> > Subject: Re: [OpenSIPS-Users] OpenXCAP and Presence with SNOM version > 8.2.29 > To: OpenSIPS users mailling list <[email protected]> > Message-ID: <[email protected]> > 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 <[email protected]> > Subject: [OpenSIPS-Users] Stored Procedure > /usr/sr/opensips_cdrs_bk.sql does not exist > To: [email protected] > Message-ID: > <[email protected]> > 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 <[email protected]> > Subject: Re: [OpenSIPS-Users] Stored Procedure > /usr/sr/opensips_cdrs_bk.sql does not exist > To: OpenSIPS users mailling list <[email protected]> > Message-ID: <[email protected]> > 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 > > [email protected] > > 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 <[email protected]> > Subject: Re: [OpenSIPS-Users] a little help > To: OpenSIPS users mailling list <[email protected]> > Message-ID: <[email protected]> > 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 > > <[email protected] <mailto:[email protected]>> 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 <[email protected]> > Subject: Re: [OpenSIPS-Users] two opensips using one location table > To: OpenSIPS users mailling list <[email protected]> > Message-ID: <[email protected]> > 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 > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > End of Users Digest, Vol 23, Issue 6 > ************************************ > -- ((cheers)) Amanpreet Singh
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
