New subject: [Serusers] Error when loading the MySQL module

1 Jun 2005

      Kapil,
1) In failure_route[2] , you cannot have
t_on_failure("2"). I believe a "recursive" call does
not work. You can write a failure_route[3] and call
t_on_failure("3" from failure_route[2]
2) To add something to the usr_preferences table, you
can use the SQL INSERT command. You would launch the
mysql client, and then enter
mysql>insert into usr_preferences values (..,...,..)
--- Kapil Dhawan sersavvy@hotmail.com wrote:
...
Hi Dave
Thx for the answer. I am trying avpops module for
failure_route with serial 
forking directive with usr_preferences table. But i
am getting several 
issues with it. Here are the logs and part of my
ser.cfg
fork=yes
modparam("avpops","avp_url","mysql://root:root@localhost/ser")
...
modparam("avpops","avp_table","usr_preferences")
modparam("avpops","avp_aliases","serial_fork1=i:665")
...
modparam("avpops","uuid_column","uuid")
modparam("avpops","username_column","username")
modparam("avpops","domain_column","domain")
modparam("avpops","attribute_column","attribute")
modparam("avpops","value_column","value")
modparam("avpops","type_column","type")
route {
   ...........

    append_hf("P-hint: usrloc applied\r\n");

    avp_write("sip:101@192.168.1.1",

"$serial_fork1");
        avp_write("sip:102@192.168.1.1",
"$serial_fork1");
        avp_write("sip:103@192.168.1.1",
"$serial_fork1");
    route(1);

}
route[1]
{
        # send it out now; use stateful forwarding
as it works reliably
        # even for UDP2TCP
    # intercept failure replies
    t_on_failure("2");

    if (!t_relay()) {
            sl_reply_error();
    };

}
failure_route[2]
{
        # use the first element of the list (if any)
and delete it from list
        if (avp_pushto("$ruri", "$serial_fork1"))
        {
                append_branch();
                avp_delete("$serial_fork1");
                t_on_failure("2");
                t_relay();
        }
}
But i am getting several issues. I have three UA's
set 101,102,103. I am 
calling from some other domain on 100 which is
aliased to 101. I expect that 
if 101 is free call shud come to it. Thats not
happening. Then if 101 and 
102 are busy or some other issue. call should reach
last UA. I didn't get 
any proper example to add AVP's to usr_preferences
table. Can you give me 
some example for it.
...
From: Dave ddx66@yahoo.com
To: serusers@lists.iptel.org
Subject: Re: [Serusers] Call Hunting
Date: Tue, 31 May 2005 08:30:54 -0700 (PDT)
Yes it is. You need to use the AVPOPS module and
the
...
failure_route directive to make it happen. Look at
the
...
avpops docs and in there you will see an example
Dave
--- Kapil Dhawan sersavvy@hotmail.com wrote:
...
Hi List
Is it possible to do Call Hunting with SER.

...
...
Adore Arshad Warsi?
http://server1.msn.co.in/sp05/iifa/ Think he is
the
...
...
funniest?

Serusers mailing list
serusers@lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers

Yahoo! Mail
Stay connected, organized, and protected. Take the
tour:
...
http://tour.mail.yahoo.com/mailtour.html

Serusers mailing list
serusers@lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
_________________________________________________________________
...
Think Rani is the best?
http://server1.msn.co.in/sp05/iifa/ Make sure she 
wins the award.
__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com