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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: segunda-feira, 15 de outubro de 2007 08:04
To: users@openser.org
Subject: Users Digest, Vol 29, Issue 47
Send Users mailing list submissions to
users@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
[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: 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 <[EMAIL PROTECTED]>
Subject: Re: [OpenSER-Users] Multidomain and in-dialog REFER auth
issue
To: users@openser.org
Message-ID: <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]:5060) and getting the username and domain of this?
Anyway this solution wouldn't be secure since [EMAIL PROTECTED] 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
[EMAIL PROTECTED]
------------------------------
Message: 2
Date: Mon, 15 Oct 2007 10:15:31 +0200
From: "Dan-Cristian Bogos" <[EMAIL PROTECTED]>
Subject: [OpenSER-Users] Changing db table names
To: "users openser.org" <users@openser.org>
Message-ID:
<[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]>
Subject: Re: [OpenSER-Users] Openser-Perl module in onreply_route
To: users@openser.org
Message-ID: <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]>
Subject: Re: [OpenSER-Users] t_relay(), forward() and send():
retransmissions?
To: " I?aki Baz Castillo " <[EMAIL PROTECTED]>
Cc: users@openser.org
Message-ID:
<[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]>:
>
> Hi, how do forward() and send() route the messages? do they
> retransmissions as
> t_relay()?
>
> Thanks.
>
>
> --
> Iñaki Baz Castillo
> [EMAIL PROTECTED]
>
> _______________________________________________
> Users mailing list
> Users@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 <[EMAIL PROTECTED]>
Subject: Re: [OpenSER-Users] t_relay(), forward() and send():
retransmissions?
To: users@openser.org
Message-ID: <[EMAIL PROTECTED]>
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
[EMAIL PROTECTED]
------------------------------
Message: 6
Date: Mon, 15 Oct 2007 11:21:40 +0200
From: Klaus Darilion <[EMAIL PROTECTED]>
Subject: Re: [OpenSER-Users] t_relay(), forward() and send():
retransmissions?
To: I?aki Baz Castillo <[EMAIL PROTECTED]>
Cc: users@openser.org
Message-ID: <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]>
Subject: Re: [OpenSER-Users] Multidomain and in-dialog REFER auth
issue
To: I?aki Baz Castillo <[EMAIL PROTECTED]>
Cc: users@openser.org
Message-ID: <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]>
Subject: Re: [OpenSER-Users] Multidomain and in-dialog REFER auth
issue
To: I?aki Baz Castillo <[EMAIL PROTECTED]>
Cc: users@openser.org
Message-ID: <[EMAIL PROTECTED]>
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:
>
> - [EMAIL PROTECTED] INVITE's [EMAIL PROTECTED]
> - During the call [EMAIL PROTECTED] does an in-dialog REFER.
>
> Because the REFER is in-dialog the message is like:
>
> --------------------
> REFER sip:[EMAIL PROTECTED]:5060 SIP/2.0
> From: sip:[EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> 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:[EMAIL PROTECTED]: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 <[EMAIL PROTECTED]>
Subject: Re: [OpenSER-Users] Multidomain and in-dialog REFER auth
issue
To: users@openser.org
Message-ID: <[EMAIL PROTECTED]>
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
[EMAIL PROTECTED]
------------------------------
Message: 10
Date: Mon, 15 Oct 2007 11:36:03 +0200
From: I?aki Baz Castillo <[EMAIL PROTECTED]>
Subject: Re: [OpenSER-Users] Multidomain and in-dialog REFER auth
issue
To: users@openser.org
Message-ID: <[EMAIL PROTECTED]>
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
[EMAIL PROTECTED]
------------------------------
Message: 11
Date: Mon, 15 Oct 2007 11:37:11 +0200
From: I?aki Baz Castillo <[EMAIL PROTECTED]>
Subject: Re: [OpenSER-Users] Multidomain and in-dialog REFER auth
issue
To: users@openser.org
Message-ID: <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]:5060) and getting the username and domain of
> > this?
>
> Anyway this solution wouldn't be secure since [EMAIL PROTECTED] 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
[EMAIL PROTECTED]
------------------------------
Message: 12
Date: Mon, 15 Oct 2007 12:03:31 +0200
From: Cseke Tamas <[EMAIL PROTECTED]>
Subject: [OpenSER-Users] change status code in reply
To: users@openser.org
Message-ID: <[EMAIL PROTECTED]>
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@openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
End of Users Digest, Vol 29, Issue 47
*************************************
_______________________________________________
Users mailing list
Users@openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
