[Serusers] configuration examples for using "dbtext" and "pa"

[Jiri Kuthan]

At 08:53 PM 7/22/2003, Director General: NEFACOMP wrote:
>Does this store accounting information in a database? Does it store missed
>calls?
>Does it solve the alias problem?
>The documentation lacks a lot of information. For example what does the
>lookup("aliases") do? I used it but it gives no results!!!

The information is included in documentation, reading it would certainly
help you very much. http://www.iptel.org/ser/doc/prerelease/x830.html#AEN852
In general, I think you really want to read it before posting questions
to serusers community.

>Maybe a nice guy should send a ser.cfg file that will help me use aliases
>and store accounting information in the MySQL database. 

I feel so flattered, that I'm sending few config fragments:

# set DB access
modparam("acc", "db_url", "sql://foo:bar@dbhost/ser")
..
# set DB-accoutning for missed calls
modparam("acc", "db_missed_flag", 3 )
...
# if user not found....handle it in route(4)
    if (!lookup("location")) {
        # handle user which was not found ...
        route(4);
        break;
    };
# if user found, relay; set up repoting on failures if negative
# reply came from downstream
   setflag(3);
   t_relay();
....
route[3] {
    # non-Voip -- just send "off-line"
    if (!(method=="INVITE" || method=="ACK" || method=="CANCEL")) {
        sl_send_reply("404", "Not Found");
        break;
    };
    if (t_newtran()) {
            t_reply("404", "Not Found");
            acc_db_request("404 missed call", "missed_calls");

    };
}


>The documentation I
>downloaded from the SER website says that MySQL logging and accounting is
>experimental but they don't show how you can experiment it.

If they shown, they would not be experimental.

-jiri



>Thanks
>Emery
>----- Original Message -----
>From: "Daniel-Constantin Mierla" <mierla at fokus.fraunhofer.de>
>To: "Kevin Chu" <kevin.chu at viditec.com>
>Cc: "SER Users" <serusers at lists.iptel.org>
>Sent: Tuesday, July 22, 2003 21:35
>Subject: Re: [Serusers] configuration examples for using "dbtext" and "pa"
>
>
>> Hello,
>> what exactly do you want to do?
>> dbtext replaces mysql module and pa is a presence agent designed to work
>> with jabber gateway or with user location module. If you want to use
>> dbtext you have to create the afferent databases.
>> See
>>
>http://cvs.berlios.de/cgi-bin/viewcvs.cgi/ser/sip_router/modules/dbtext/READ
>ME?rev=1.4&content-type=text/vnd.viewcvs-markup
>> to learn the format of dbtext database.
>>
>> I recommend to use the latest cvs stable version (see
>> http://www.iptel.org/ser/cvs), there were some fixes since pre29.
>>
>> Best regards,
>> Daniel
>>
>>
>> On 7/22/2003 8:19 PM, Kevin Chu wrote:
>>
>> >Hi,
>> >
>> >I tried to use the "dbtext" and "pa" modules included in SER
>> >0.8.11pre29 package. However, I can not figure out the correct
>> >configuration to make them work.
>> >
>> >Is there any configuration examples for using those modules?
>> >
>> >Thanks,
>> >Kevin
>> >
>> >_______________________________________________
>> >Serusers mailing list
>> >serusers at lists.iptel.org
>> >http://lists.iptel.org/mailman/listinfo/serusers
>> >
>> >
>> >
>>
>> _______________________________________________
>> Serusers mailing list
>> serusers at lists.iptel.org
>> http://lists.iptel.org/mailman/listinfo/serusers
>>
>>

--
Jiri Kuthan            http://iptel.org/~jiri/