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.
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
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.
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
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
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
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
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.-
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
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
