[OpenSER-Users] Re: Openser-Perl module in onreply_route
Murilo Lacerda Yoshida
murilo.yoshida at voxage.com.br
Mon Oct 15 16:33:11 CEST 2007
Hi Mik,
When I faced these problems with openser and DBI, I did a research, and if I remember it correctly, DBD::Sybase does not work correctly with output parameters.
So one solution I guess would be you rewrite your procedure so that the parameter is only input and return the same parameter in a result set inside the procedure.
That was one thing I had to do when I switched from DBD::ODBC to DBD::Sybase, as I had also some procedures with output parameters. After I rewrote the procedures and returned the output parameters as result sets I had no problems with this.
HTH,
Murilo
-----Original Message-----
From: users-bounces at openser.org [mailto:users-bounces at openser.org] On Behalf Of users-request at openser.org
Sent: segunda-feira, 15 de outubro de 2007 08:04
To: users at openser.org
Subject: Users Digest, Vol 29, Issue 47
Send Users mailing list submissions to
users at openser.org
To subscribe or unsubscribe via the World Wide Web, visit
http://openser.org/cgi-bin/mailman/listinfo/users
or, via email, send a message with subject or body 'help' to
users-request at openser.org
You can reach the person managing the list at
users-owner at openser.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Users digest..."
Today's Topics:
1. Re: Multidomain and in-dialog REFER auth issue
(I?aki Baz Castillo)
2. Changing db table names (Dan-Cristian Bogos)
3. Re: Openser-Perl module in onreply_route (Bastian Friedrich)
4. Re: t_relay(), forward() and send(): retransmissions? (samuel)
5. Re: t_relay(), forward() and send(): retransmissions?
(I?aki Baz Castillo)
6. Re: t_relay(), forward() and send(): retransmissions?
(Klaus Darilion)
7. Re: Multidomain and in-dialog REFER auth issue (Klaus Darilion)
8. Re: Multidomain and in-dialog REFER auth issue (Klaus Darilion)
9. Re: Multidomain and in-dialog REFER auth issue
(I?aki Baz Castillo)
10. Re: Multidomain and in-dialog REFER auth issue
(I?aki Baz Castillo)
11. Re: Multidomain and in-dialog REFER auth issue
(I?aki Baz Castillo)
12. change status code in reply (Cseke Tamas)
----------------------------------------------------------------------
Message: 1
Date: Mon, 15 Oct 2007 10:13:22 +0200
From: I?aki Baz Castillo <ibc at in.ilimit.es>
Subject: Re: [OpenSER-Users] Multidomain and in-dialog REFER auth
issue
To: users at openser.org
Message-ID: <200710151013.22807.ibc at in.ilimit.es>
Content-Type: text/plain; charset="iso-8859-1"
El Monday 15 October 2007 09:58:36 Iñaki Baz Castillo escribió:
> How can my OpenSer know which domain this REFER goes? of course the "To"
> header is not valid at all.
>
> Could be a solution a SQL query to "location" table looking for the URI
> (sip:userB at 80.98.123.23:5060) and getting the username and domain of this?
Anyway this solution wouldn't be secure since userA at domainA.com could hack
its "From" header in the REFER and appears as "@domainB.com".
So I think I need to store dialog info in a table (in the 200-OK), with those
info:
- "From" header domain
- RURI domain
- fromtag
- totag
- "Call-ID" header
and query this table in REFER amtching fromtag, totag and Call-ID, and just
allow the REFER is "From" header and RURI domain are the same.
"Dialog" module is not valid for me since it doesn't store RURI.
Any suggestion about it? Thanks a lot.
--
Iñaki Baz Castillo
ibc at in.ilimit.es
------------------------------
Message: 2
Date: Mon, 15 Oct 2007 10:15:31 +0200
From: "Dan-Cristian Bogos" <dan.bogos at gmail.com>
Subject: [OpenSER-Users] Changing db table names
To: "users openser.org" <users at openser.org>
Message-ID:
<40e285320710150115k78aa907co56a4a7a1748bbfc2 at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
Hi All,
I came to a situation where I need to use openser together with other
apps on the same database, therefore I will need to change the table
names. I know that most of the modules permit that on through config,
but my concern is the table version, and the data which should be
inside.
Can anybody give me any hints on this issue?
Ta,
DanB
------------------------------
Message: 3
Date: Mon, 15 Oct 2007 10:19:20 +0200
From: Bastian Friedrich <bastian.friedrich at collax.com>
Subject: Re: [OpenSER-Users] Openser-Perl module in onreply_route
To: users at openser.org
Message-ID: <200710151019.21008.bastian.friedrich at collax.com>
Content-Type: text/plain; charset="iso-8859-1"
Hi Mik,
On Friday 12 October 2007, Mik Cheez wrote:
> I had been using 'perl_exec' in my scripts with great success until I
> decided to try using it in the onreply_route. The strangest thing now
> happens; I use my perl script to write information to a database, and it
> seems like the failure would have to be in DBI, but it only occurs in
> Openser.
a few weeks ago, someone else experienced problems when using DBI in OpenSER
Perl scripts:
http://openser.org/pipermail/users/2007-September/013388.html
We currently do not have a proper solution for the problem, as the problems
are created by DBI rather than by OpenSER. You might consider trying to
establish some kind of OpenSER-internal locking mechanism for the DBI
functions.
Have you tried running your Perl script with only a single OpenSER instance
(i.e. turning of forking)?
Bastian
--
Collax GmbH . Burkheimer Straße 3 . 79111 Freiburg . Germany
p: +49 (0) 761-45684-24
f: +49 (0) 761-45684-10 www.collax.com
Geschäftsführer: William K. Hite / Boris Nalbach
AG München HRB 158898 . Ust.-IdNr: DE 814464942
\ Smash forehead on keyboard to continue.
------------------------------
Message: 4
Date: Mon, 15 Oct 2007 11:11:03 +0200
From: samuel <samu60 at gmail.com>
Subject: Re: [OpenSER-Users] t_relay(), forward() and send():
retransmissions?
To: " I?aki Baz Castillo " <ibc at in.ilimit.es>
Cc: users at openser.org
Message-ID:
<d18bd3a10710150211n5b0dd1e9oc75297296525c352 at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
forward() and send() are the stateless functions, which basically means they
just send the message and forget the transaction.
t_relay() is the statefull routing function, so whenever you use this
function openSER will take care of the transaction FSM.
hope it helps,
sam
2007/10/15, Iñaki Baz Castillo <ibc at in.ilimit.es>:
>
> Hi, how do forward() and send() route the messages? do they
> retransmissions as
> t_relay()?
>
> Thanks.
>
>
> --
> Iñaki Baz Castillo
> ibc at in.ilimit.es
>
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://openser.org/pipermail/users/attachments/20071015/7bafc398/attachment-0001.htm
------------------------------
Message: 5
Date: Mon, 15 Oct 2007 11:22:12 +0200
From: I?aki Baz Castillo <ibc at in.ilimit.es>
Subject: Re: [OpenSER-Users] t_relay(), forward() and send():
retransmissions?
To: users at openser.org
Message-ID: <200710151122.13017.ibc at in.ilimit.es>
Content-Type: text/plain; charset="ISO-8859-1"
El Monday 15 October 2007 11:11:03 samuel escribió:
> forward() and send() are the stateless functions, which basically means
> they just send the message and forget the transaction.
> t_relay() is the statefull routing function, so whenever you use this
> function openSER will take care of the transaction FSM.
Thanks. So I understand if better using t_relay() in order to route INVITE to
a PBX or media server.
> hope it helps,
Sure, I will notate about the stateless of forward() and send() in the wiki.
Best regards.
--
Iñaki Baz Castillo
ibc at in.ilimit.es
------------------------------
Message: 6
Date: Mon, 15 Oct 2007 11:21:40 +0200
From: Klaus Darilion <klaus.mailinglists at pernau.at>
Subject: Re: [OpenSER-Users] t_relay(), forward() and send():
retransmissions?
To: I?aki Baz Castillo <ibc at in.ilimit.es>
Cc: users at openser.org
Message-ID: <47133124.5090408 at pernau.at>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
forward() does stateless routing (apply changes to the message, add Via
header ...)
send() is also steless but forwards the original message without any changes
klaus
Iñaki Baz Castillo schrieb:
> Hi, how do forward() and send() route the messages? do they retransmissions as
> t_relay()?
>
> Thanks.
>
>
------------------------------
Message: 7
Date: Mon, 15 Oct 2007 11:25:50 +0200
From: Klaus Darilion <klaus.mailinglists at pernau.at>
Subject: Re: [OpenSER-Users] Multidomain and in-dialog REFER auth
issue
To: I?aki Baz Castillo <ibc at in.ilimit.es>
Cc: users at openser.org
Message-ID: <4713321E.7000002 at pernau.at>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Iñaki Baz Castillo schrieb:
> "Dialog" module is not valid for me since it doesn't store RURI.
really? I wonder how the dialog module can fake BYEs without storing the
RURIs (learned from contact headers) - or do you mean the original RURI?
klaus
------------------------------
Message: 8
Date: Mon, 15 Oct 2007 11:26:16 +0200
From: Klaus Darilion <klaus.mailinglists at pernau.at>
Subject: Re: [OpenSER-Users] Multidomain and in-dialog REFER auth
issue
To: I?aki Baz Castillo <ibc at in.ilimit.es>
Cc: users at openser.org
Message-ID: <47133238.7000107 at pernau.at>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Authentication of in-dialog requests in SIP is borken - you can not rely
on the From/To headers.
klaus
Iñaki Baz Castillo schrieb:
> Hi, I've a multidomain OpenSer and I want to allow REFER (with authenticacion
> before) just in calls between users of same domain, but it's quite complex:
>
> - userA at domainA.com INVITE's userB at domainB.com.
> - During the call userA at domainA.com does an in-dialog REFER.
>
> Because the REFER is in-dialog the message is like:
>
> --------------------
> REFER sip:userB at 80.98.123.23:5060 SIP/2.0
> From: sip:userA at domainA.com
> To: userB at domainB.com
> Refer-To: ...
> ...
> --------------------
>
>
> How can my OpenSer know which domain this REFER goes? of course the "To"
> header is not valid at all.
>
> Could be a solution a SQL query to "location" table looking for the URI
> (sip:userB at 80.98.123.23:5060) and getting the username and domain of this?
>
> Any other option?
>
>
> Thanks a lot.
>
>
------------------------------
Message: 9
Date: Mon, 15 Oct 2007 11:32:23 +0200
From: I?aki Baz Castillo <ibc at in.ilimit.es>
Subject: Re: [OpenSER-Users] Multidomain and in-dialog REFER auth
issue
To: users at openser.org
Message-ID: <200710151132.23775.ibc at in.ilimit.es>
Content-Type: text/plain; charset="iso-8859-1"
El Monday 15 October 2007 11:25:50 Klaus Darilion escribió:
> Iñaki Baz Castillo schrieb:
> > "Dialog" module is not valid for me since it doesn't store RURI.
>
> really? I wonder how the dialog module can fake BYEs without storing the
> RURIs (learned from contact headers) -
> or do you mean the original RURI?
Yes, I meen the original RURI (the only way to know the called domain).
--
Iñaki Baz Castillo
ibc at in.ilimit.es
------------------------------
Message: 10
Date: Mon, 15 Oct 2007 11:36:03 +0200
From: I?aki Baz Castillo <ibc at in.ilimit.es>
Subject: Re: [OpenSER-Users] Multidomain and in-dialog REFER auth
issue
To: users at openser.org
Message-ID: <200710151136.03604.ibc at in.ilimit.es>
Content-Type: text/plain; charset="iso-8859-1"
El Monday 15 October 2007 11:26:16 Klaus Darilion escribió:
> Authentication of in-dialog requests in SIP is broken - you can not rely
> on the From/To headers.
I can rely on "From" since if I authenticate a caller and do "check_from()" I
can be sure there is not spoof.
But I need to know the dialog original URI domain in order to allow or not a
REFER.
Because of this issue I need to store dialog info with original URI.
--
Iñaki Baz Castillo
ibc at in.ilimit.es
------------------------------
Message: 11
Date: Mon, 15 Oct 2007 11:37:11 +0200
From: I?aki Baz Castillo <ibc at in.ilimit.es>
Subject: Re: [OpenSER-Users] Multidomain and in-dialog REFER auth
issue
To: users at openser.org
Message-ID: <200710151137.11613.ibc at in.ilimit.es>
Content-Type: text/plain; charset="iso-8859-1"
El Monday 15 October 2007 10:13:22 Iñaki Baz Castillo escribió:
> El Monday 15 October 2007 09:58:36 Iñaki Baz Castillo escribió:
> > How can my OpenSer know which domain this REFER goes? of course the "To"
> > header is not valid at all.
> >
> > Could be a solution a SQL query to "location" table looking for the URI
> > (sip:userB at 80.98.123.23:5060) and getting the username and domain of
> > this?
>
> Anyway this solution wouldn't be secure since userA at domainA.com could hack
> its "From" header in the REFER and appears as "@domainB.com".
Ops, there is no this issue since the "From" is checked against the auth
username in "check_from()".
Then the only I need is to store dialog original URI domain.
--
Iñaki Baz Castillo
ibc at in.ilimit.es
------------------------------
Message: 12
Date: Mon, 15 Oct 2007 12:03:31 +0200
From: Cseke Tamas <cseke.tamas at eworldcom.hu>
Subject: [OpenSER-Users] change status code in reply
To: users at openser.org
Message-ID: <47133AF3.4060302 at eworldcom.hu>
Content-Type: text/plain; charset=ISO-8859-2; format=flowed
Hello,
I have the same problem what discussed in this thread:
http://www.nabble.com/SF.net-SVN:-openser:--2835--trunk-modules-sl-t4533872.html
I'd like to change the status code, is it still inpossible with 1.2?
I tried t_reply, sl_send_reply, replace functions but they don't work?
Could you tell me any solution for this, if it is possible?
Thanks any help,
Tamas
------------------------------
_______________________________________________
Users mailing list
Users at openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
End of Users Digest, Vol 29, Issue 47
*************************************
More information about the Users
mailing list