[OpenSER-Users] Re: Openser-Perl module in onreply_route - sr-users

15 Oct 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@openser.org [mailto:users-bounces@openser.org] On Behalf Of users-request@openser.org
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
    users-request@openser.org
You can reach the person managing the list at
    users-owner@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@in.ilimit.es
Subject: Re: [OpenSER-Users] Multidomain and in-dialog REFER auth
    issue
To: users@openser.org
Message-ID: 200710151013.22807.ibc@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@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@in.ilimit.es

------------------------------

Message: 2
Date: Mon, 15 Oct 2007 10:15:31 +0200
From: "Dan-Cristian Bogos" dan.bogos@gmail.com
Subject: [OpenSER-Users] Changing db table names
To: "users openser.org" users@openser.org
Message-ID:
    40e285320710150115k78aa907co56a4a7a1748bbfc2@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@collax.com
Subject: Re: [OpenSER-Users] Openser-Perl module in onreply_route
To: users@openser.org
Message-ID: 200710151019.21008.bastian.friedrich@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@gmail.com
Subject: Re: [OpenSER-Users] t_relay(), forward() and send():
    retransmissions?
To: " I?aki Baz Castillo " ibc@in.ilimit.es
Cc: users@openser.org
Message-ID:
    d18bd3a10710150211n5b0dd1e9oc75297296525c352@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@in.ilimit.es:
>
> Hi, how do forward() and send() route the messages? do they
> retransmissions as
> t_relay()?
>
> Thanks.
>
>
> --
> Iñaki Baz Castillo
> ibc@in.ilimit.es
>
> _______________________________________________
> Users mailing list
> Users@openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>