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