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@fokus.fraunhofer.de To: "Kevin Chu" kevin.chu@viditec.com Cc: "SER Users" serusers@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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers

---

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

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