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(a)openser.org [mailto:users-bounces@openser.org] On Behalf Of
users-request(a)openser.org
Sent: segunda-feira, 15 de outubro de 2007 08:04
To: users(a)openser.org
Subject: Users Digest, Vol 29, Issue 47
Send Users mailing list submissions to
users(a)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(a)openser.org
You can reach the person managing the list at
users-owner(a)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(a)in.ilimit.es>
Subject: Re: [OpenSER-Users] Multidomain and in-dialog REFER auth
issue
To: users(a)openser.org
Message-ID: <200710151013.22807.ibc(a)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@80.98.123.23:5060) and getting the username and domain of this?
Anyway this solution wouldn't be secure since userA(a)domainA.com could hack
its "From" header in the REFER and appears as "(a)domainB.com".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(a)in.ilimit.es
------------------------------
Message: 2
Date: Mon, 15 Oct 2007 10:15:31 +0200
From: "Dan-Cristian Bogos" <dan.bogos(a)gmail.com>
Subject: [OpenSER-Users] Changing db table names
To: "users openser.org" <users(a)openser.org>
Message-ID:
<40e285320710150115k78aa907co56a4a7a1748bbfc2(a)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(a)collax.com>
Subject: Re: [OpenSER-Users] Openser-Perl module in onreply_route
To: users(a)openser.org
Message-ID: <200710151019.21008.bastian.friedrich(a)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(a)gmail.com>
Subject: Re: [OpenSER-Users] t_relay(), forward() and send():
retransmissions?
To: " I?aki Baz Castillo " <ibc(a)in.ilimit.es>
Cc: users(a)openser.org
Message-ID:
<d18bd3a10710150211n5b0dd1e9oc75297296525c352(a)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(a)in.ilimit.es>es>:
Hi, how do forward() and send() route the messages? do they
retransmissions as
t_relay()?
Thanks.
--
Iñaki Baz Castillo
ibc(a)in.ilimit.es
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users