sr-users April 2005

sr-users@lists.kamailio.org

250 participants
697 discussions

[Serusers] RE: Ser Crashes
by IpTel List 05 May '05

05 May '05

Hi! Thanx for help. It writes that he can't connect to MYSQL DB now ... Output is the following ... root@ignosya:/usr/local/etc/ser# ser -E -d Listening on 127.0.0.1 [127.0.0.1]:5060 84.230.194.213 [84.230.194.213]:5060 192.168.1.1 [192.168.1.1]:5060 Aliases: 1.1.168.192.in-addr.arpa:5060 a84-230-194-213.elisa-laajakaista.fi:5060 localhost:5060 root@ignosya:/usr/local/etc/ser# stateless - initializing Maxfwd module- initializing 0(15143) connect_db(): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2) 0(15143) db_init(): Error while trying to connect database 0(15143) mod_init(): Error while connecting database 0(15143) init_mod(): Error while initializing module usrloc ERROR: error while initializing modules root@ignosya:/usr/local/etc/ser# So, it seams for me, that it's like MYSQL problem. So, i have to reconfigure it ... or check it up ... But, are there any methods selecting mysql host adres? For example, if mysql is not on local machine ... is it enough to set SQL_HOST var? Best wishes, Alexandro.

3 3

Re: [Serusers] HELP: how to get correct call duration??
by Charles Wang 04 May '05

04 May '05

Hi, I think that the ACK after INVITE is only the callee(UAC) receives my INVITE and ready to start RINGING. But this time is not the really Call Start. Generally, the start time of call should be callee hangup the phone after ringing. Do you have any idea about it? On 4/28/05, info(a)beeplove.com <info(a)beeplove.com> wrote: > > Actually, to get call duration, you need to use ACK and BYE (both should > have status 200). > INVITE sends an request to other party to initiate a call. > Other party send ACK with status 200 to receive the call. > > Original Message: > ----------------- > From: Charles Wang lazy.charles(a)gmail.com > Date: Thu, 28 Apr 2005 02:49:42 +0800 > To: serusers(a)lists.iptel.org > Subject: [Serusers] HELP: how to get correct call duration?? > > > Hi, ALL: > > I know ser can insert INVITE & BYE records to acc table. > Maybe the timestamp of BYE record is correct but the timestamp > of INVITE is not equal to the call start(after the callee answered). > Is there any method to generate a record with timestamp when the callee > answer? > I think that it should be the callee responses "200 OK" after "100 Trying". > How to do it??? > > -- > > Best Regards > Charles > > _______________________________________________ > Serusers mailing list > serusers(a)lists.iptel.org > http://lists.iptel.org/mailman/listinfo/serusers > > -------------------------------------------------------------------- > mail2web - Check your email from the web at > http://mail2web.com/ . > > -- Best Regards Charles

2 6

[Serusers] sorry -- cannot open write fifo
by Ramakrishnan_S 02 May '05

02 May '05

Hi I have installed latest version of SER. I have been getting this error message "sorry -- cannot open write fifo" . There is a permission on the FIFO for httpd process to read and write. But still I am getting error. Any pointers for to resolve this will be helpful. Can any one help please. Thanks Rama DISCLAIMER: This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.

3 2

[Serusers] strict_routing() function in rr module, where has it gone?
by reticent 30 Apr '05

30 Apr '05

I have several different UAC's that insist on doing strict routing and this is causing me some moderate issues as i can find no way to deal with the situation on SER. According to the documentation that comes with the "rr" module there is supposed to be a function called "strict_route()" that does exactly what i want (move the value from the "Route:" header into the RURI), however the module does not provide this function. I'm curious if this functionality has been folded into loose_route or if it has simply dissappeared? There is a section in the source code of rr_mod.c that allows you to enable the function "record_route_strict()" and it also talks about enabling "strict_route()" however i have had no success with it. tavis

3 4

RE: [Serusers] ACC into mysql
by Edgardo O. Gonzales II 30 Apr '05

30 Apr '05

thank you so much .. I finally made it work after I rebuild everything just to make sure my installation and compilation is clean .. With regards to call routing, can you give me an example where we can communicate with other gatekeeper thanks, ed At 09:13 PM 4/26/2005, Matt Schulte wrote: >This particular config (I don't think?) won't log to a DB, additionally >you need to setflag(1); somewhere in your config. We tried to set on >"outbound" only originally and didn't have much luck so I set it near the >top. To log to (my)sql you will additionally need to set another flag and >setup similar mod params: > > >modparam("acc", "db_url", "mysql://ser:serro@blah.mysql.haha/dbname") ># Note flag 2, you will need to setflag(1); AND setflag(2); >modparam("acc", "db_flag", 2) >#Note this one logs all failed calls from the invite response, I find it >useful >modparam("acc", "failed_transactions", 1) ># In your route config use something like the following > ># This is pretty much near the top, while ACC won't log reg's or INFO >anyway, I just thought it'd be a little cleaner to have >... >if (!method == "REGISTER" || !method == "INFO" ) { > setflag(1); > setflag(2); >} >... > ># Doing the above ensure everything gets tagged including BYE's. A good >reason why your BYE's may not get ># tagged is possibly because record-route could be relaying the call >before the flag gets set, just a thought.. >-----Original Message----- >From: Edgardo O. Gonzales II [mailto:edgardo.g@pacific.net.ph] >Sent: Tuesday, April 26, 2005 1:29 AM >To: Kofi Obiri-Yeboah >Cc: serusers(a)lists.iptel.org >Subject: RE: [Serusers] ACC into mysql >Importance: High > > >Thanks again for your help .. Here's my running ser.cfg >Hope you can help me make my accounting work.. > >thanks, >ed > >================================================================ ># ----------- global configuration parameters ------------------------ > >#debug=3 >#fork=yes >#log_stderror=no > >#debug=7 >#fork=no >#log_stderror=yes > >check_via=no >dns=no >rev_dns=no >#port=5060 >#children=4 >fifo="/tmp/ser_fifo" > ># ------------------ module loading ---------------------------------- > >loadmodule "/usr/local/ser/lib/ser/modules/mysql.so" >loadmodule "/usr/local/ser/lib/ser/modules/sl.so" >loadmodule "/usr/local/ser/lib/ser/modules/tm.so" >loadmodule "/usr/local/ser/lib/ser/modules/rr.so" >loadmodule "/usr/local/ser/lib/ser/modules/maxfwd.so" >loadmodule "/usr/local/ser/lib/ser/modules/usrloc.so" >loadmodule "/usr/local/ser/lib/ser/modules/registrar.so" >loadmodule "/usr/local/ser/lib/ser/modules/auth.so" >loadmodule "/usr/local/ser/lib/ser/modules/auth_db.so" >loadmodule "/usr/local/ser/lib/ser/modules/acc.so" > ># ----------------- setting module-specific parameters --------------- > ># -- usrloc params -- > >modparam("usrloc", "db_mode", 1) >modparam("usrloc", "db_url","mysql://ser:heslo@localhost/ser") > ># -- auth params -- > >modparam("auth_db", "calculate_ha1", yes) >modparam("auth_db", "password_column", "password") > ># -- rr params -- > >modparam("rr", "enable_full_lr", 1) > ># -- acc params -- > >modparam("acc", "log_level", 1) >modparam("acc", "log_flag", 1) >modparam("acc", "log_missed_flag", 3) > ># ------------------------- request routing logic ------------------- > >alias=abc.com.ph > ># main routing logic > >route{ > if (!mf_process_maxfwd_header("10")) { > sl_send_reply("483","Too Many Hops"); > break; > }; > if ( msg:len > max_len ) { > sl_send_reply("513", "Message too big"); > break; > }; > > record_route(); > if (loose_route()) { > t_relay(); > break; > }; > > if (uri=~"abc.com.ph") { > if (method=="REGISTER") { > if (!www_authorize("abc.com.ph", "subscriber")) { > www_challenge("abc.com.ph", "0"); > break; > }; > > save("location"); > break; > }; > > lookup("aliases"); > > if (!lookup("location")) { > sl_send_reply("404", "Not Found"); > break; > }; > }; > if (!t_relay()) { > sl_reply_error(); > }; > >} > > > > >================================================================ >At 10:55 AM 4/26/2005, Kofi Obiri-Yeboah wrote: >>I am assuming your question is if the record_route() function is a >>parameter for accounting? If that was your question then the answer is >>no. Generally you invoke record_route() to ensure acl acceptance on a >>gateway (i.e. all calls through that gateway) >>-----Original Message----- >>From: Edgardo O. Gonzales II [ mailto:edgardo.g@pacific.net.ph] >>Sent: Monday, April 25, 2005 6:22 PM >>To: Kofi Obiri-Yeboah >>Cc: serusers(a)lists.iptel.org >>Subject: RE: [Serusers] ACC into mysql >> >>Hi Kofi! >>got it.. thanks for immediate feedback .. however my accounting is not >>working. >>any parameters to be added to make it work.. >>I have the following info already on my ser.cfg >>modparam("acc", "log_level", 1) >>modparam("acc", "log_flag", 1) >>modparam("acc", "log_missed_flag", 3) >> >>record_route(); -> its this a parameter for accounting >>thanks, >>ed >> >>At 08:32 AM 4/26/2005, Kofi Obiri-Yeboah wrote: >>>I think the correct modparam statement should read as follows: >>>modparam("acc", "db_url", "mysql://ser:heslo@localhost/ser") >>> >>>please note that "my" is required in front of sql >>> >>>and not: >>>modparam("acc", "db_url", "sql://ser:heslo@localhost/ser") >>> >>>-----Original Message----- >>>From: serusers-bounces(a)iptel.org [ mailto:serusers-bounces@lists.iptel.org]On >>>Behalf Of Edgardo O. Gonzales II >>>Sent: Monday, April 25, 2005 5:20 PM >>>To: serusers(a)lists.iptel.org >>>Subject: Re: [Serusers] ACC into mysql >>> >>>Hi all! >>>Im also receiving this error message. >>>Can somebody help us on how to make accounting work using mysql. >>>thanks, >>>ed >>>At 06:01 AM 4/26/2005, Leon Sun wrote: >>>>Hi, >>>>I am using 0.8.12 in Fedora 3. I tried to log account info into Mysql >>>>followed instruction from manual. I found, first, modparam("acc", >>>>"db_url", "sql://ser:heslo@localhost/ser") coudnlt work at all in >>>>ser.cfg. If I enabled in cfg file, it showed Starting ser: ERROR: bad >>>>config file (1 errors) >>>>If I disabled it, SER worked fine but I couldnt see any record in acc >>>>table. >>>>Would anyone suggest how to put call records into Mysql? >>>>Thank you. >>>> >>>># ----------- global configuration parameters ------------------------ >>>>#debug=3 # debug level (cmd line: -dddddddddd) >>>>#fork=yes >>>>#log_stderror=no # (cmd line: -E) >>>>/* Uncomment these lines to enter debugging mode >>>>debug=7 >>>>fork=no >>>>log_stderror=yes >>>>*/ >>>>check_via=no # (cmd. line: -v) >>>>dns=no # (cmd. line: -r) >>>>rev_dns=no # (cmd. line: -R) >>>>#port=5060 >>>>#children=4 >>>>fifo="/tmp/ser_fifo" >>>># ------------------ module loading ---------------------------------- >>>># Uncomment this if you want to use SQL database >>>>loadmodule "/usr/lib/ser/modules/mysql.so" >>>>loadmodule "/usr/lib/ser/modules/acc.so" >>>>loadmodule "/usr/lib/ser/modules/sl.so" >>>>loadmodule "/usr/lib/ser/modules/tm.so" >>>>loadmodule "/usr/lib/ser/modules/rr.so" >>>>loadmodule "/usr/lib/ser/modules/maxfwd.so" >>>>loadmodule "/usr/lib/ser/modules/usrloc.so" >>>>loadmodule "/usr/lib/ser/modules/registrar.so" >>>># Uncomment this if you want digest authentication >>>># mysql.so must be loaded ! >>>>loadmodule "/usr/lib/ser/modules/auth.so" >>>>loadmodule "/usr/lib/ser/modules/auth_db.so" >>>># ----------------- setting module-specific parameters --------------- >>>>#modparam("acc", "db_url", "sql://ser:heslo@localhost/ser") >>>># -- usrloc params -- >>>>#modparam("usrloc", "db_mode", 0) >>>># Uncomment this if you want to use SQL database >>>># for persistent storage and comment the previous line >>>>modparam("usrloc", "db_mode", 2) >>>># -- auth params -- >>>># Uncomment if you are using auth module >>>># >>>>modparam("auth_db", "calculate_ha1", yes) >>>># >>>># If you set "calculate_ha1" parameter to yes (which true in this config), >>>># uncomment also the following parameter) >>>># >>>>modparam("auth_db", "password_column", "password") >>>># -- rr params -- >>>># add value to ;lr param to make some broken UAs happy >>>>modparam("rr", "enable_full_lr", 1) >>>>modparam("acc","log_level",1) >>>>modparam("acc","log_flag",1) >>>># ------------------------- request routing logic ------------------- >>>># main routing logic >>>>route{ >>>> # initial sanity checks -- messages with >>>> # max_forwards==0, or excessively long requests >>>> if (!mf_process_maxfwd_header("10")) { >>>> sl_send_reply("483","Too Many Hops"); >>>> break; >>>> }; >>>> if ( msg:len > max_len ) { >>>> sl_send_reply("513", "Message too big"); >>>> break; >>>> }; >>>> # we record-route all messages -- to make sure that >>>> # subsequent messages will go through our proxy; that's >>>> # particularly good if upstream and downstream entities >>>> # use different transport protocol >>>> record_route(); >>>> # loose-route processing >>>> if (loose_route()) { >>>> if (method=="BYE") { >>>> setflag(1); >>>> setflag(2); >>>> } >>>> t_relay(); >>>> break; >>>> }; >>>> #labeled all transaction for accounting >>>> setflag(1); >>>> setflag(2); >>>> if (method=="CANCEL"){ >>>> t_relay(); >>>> }; >>>> # (in case, it does not work, use the following command >>>> # with proper names and addresses in it) >>>> if (uri==myself) { >>>> # This for PSTN destination >>>> if (uri=~"^sip:1") >>>> { rewritehost("10.10.10.10"); >>>> forward(10.10.10.10,5060); >>>> break; >>>> } >>>> if (method=="REGISTER") { >>>> # Uncomment this if you want to use digest authentication >>>> if (!www_authorize("sip.mycommunications.com", >>>> "subscriber")) { >>>> >>>>www_challenge("sip.mycommunications.com", "0"); >>>> break; >>>> }; >>>> save("location"); >>>> break; >>>> }; >>>> # native SIP destinations are handled using our USRLOC DB >>>> if (!lookup("location")) { >>>> sl_send_reply("404", "Not Found"); >>>> break; >>>> }; >>>> }; >>>> # forward to current uri now; use stateful forwarding; that >>>> # works reliably even if we forward from TCP to UDP >>>> if (!t_relay()) { >>>> sl_reply_error(); >>>> }; >>>>} >>>>_______________________________________________ >>>>Serusers mailing list >>>>serusers(a)lists.iptel.org >>>>http://lists.iptel.org/mailman/listinfo/serusers

2 1

[Serusers] sems and asterisk problem
by ooo ooo 30 Apr '05

30 Apr '05

I want to know who is batter in sems and asteisk. I want to let my ser support voicemail. http://sip800.8866.org thanks a lot . B.D. Rose. _________________________________________________________________ 与联机的朋友进行交流，请使用 MSN Messenger: http://messenger.msn.com/cn

2 1

[Serusers] Ser+serweb
by Tomek 30 Apr '05

30 Apr '05

Helo I've two questions: 1. When I log in user account on serweb i see this red messege: "sorry - cannot open write fifo". Fifo patch is /tmp/ser_fifo. I think that is a problem with apache and DocumentRoot but what do I do? :) 2. I wanted to add a new subscriber on serweb but without send e-mail and confirm but only confirm and add to mysql. Is that possible and where can I find information how ? Thanks for any help- sorry for my english. TS

2 1

[Serusers] check_ser plugin for nagios.
by Ricardo Martinez 30 Apr '05

30 Apr '05

Hello list. I'm trying to use nagios to check my ser status, so far i found a script in : http://lists.iptel.org/pipermail/serusers/2004-January/005195.html and i tested it without any luck. Does someone have any check_ser that works ok?. I will really appreciate. Thanks Ricardo Martinez.-

4 3

[Serusers] Query the MySQL database from SER?
by Jose Gonzalez 29 Apr '05

29 Apr '05

Hello all, I'm using SER 0.9.0 and I have almost everything up and running perfectly. The last thing I would like to do is query the MySQL database for a field in the subscriber table to set as the Caller ID (SIP From). I already have the UAC module up and running fine to rewrite the info, I just need to know how to query that info from the DB. I looked everywhere and can't find anything. Is this possible? Thanks, Jose Gonzalez

1 0

[Serusers] account from an end-device
by "Sebastian Kühner" 29 Apr '05

29 Apr '05

Hello, In the documentation of acc is written: "If a UA fails in middle of conversation, a proxy will never learn it. In general, a better practice is to account from an end-device (such as PSTN gateway), which best knows about call status (including media status and PSTN status in case of the gateway)." Has anyone an idea how to make this? How can I get this informations from a PSTN Gateway? What I want to have is a server on which are connected my "users". A user can enter a "uri". If this uri begins with "sip:00", I want to connect them to a pstn gateway. Thanks! Sebastian -- +++ GMX - die erste Adresse f�r Mail, Message, More +++ 10 GB Mailbox, 100 FreeSMS http://www.gmx.net/de/go/topmail

1 0

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

sr-users April 2005