Hi,
I am using the ACCDB with extra data. I collect the data to AVP's and set
it on the db_extra. It gets to be 37 columns…. Pretty long…
The problem I experience is that after a while (2-3 hours) with about 15
CAPS the MySQL ACC insert error appears.
And, I am loosing accounting data.
Except of narrowing the amount of columns and setting the fields (INT,CHAR
etc.), does anyone has any ideas?
The db_insert_mode set to 1 does not work (my ACC table is INNODB because I
don’t want to lose info).
BR,
Uri
Hi,
When I am trying to modify FROM field in the "failure_route" block I get an
error message:
failure_route[1]
{
...
uac_replace_from("$avp(i:204)");
append_branch();
t_relay();
}
Not starting openser: invalid configuration file!
Mar 22 10:51:39 [6457] CRITICAL:core:yyerror: parse error in config file,
line 662, column 32-33: Command cannot be used in the block
Mar 22 10:51:39 [6457] ERROR:core:main: bad config file (1 errors)
It seems "uac_replace_from()" can not be used in the "failure_route" block.
What's the correct way to modify (appending a tag) FROM field in the
"failure_route" block?
Thanks,
R
I've been playing with OpenSIPS and am willing to change over if it means
I'll get a more informed answer from this community..
I need to set up a proxy forwarding server that can listen on a port other
than 5060 I.e. 8080 and forward the registration requests to another Voip
platform we have that is running on 5060.
I've been able to do this under OpenSIPS but I'm having issues with inbound
calls. It could be a NAT issue.
Basically listen on 8080 forward any and all registrations to x:5060
which I've done using rewritehostport
Anyone have any good example configs for this? I'm a n00b at this OpenSER
stuff but have been around asterisk / freeswitch / portaone for a while.
Thanks in advance
Hi
I want to do the performance testing on the Kamailio. I found the related
document about openser 1.2.0 version at:
http://www.kamailio.org/docs/openser-performance-tests/.
But somehow, I can't make it work with Kamailio 3.1. Do you happen to know
what to do?
By following the test case at
http://www.kamailio.org/docs/openser-performance-tests/#tm-tests-c, I use
the command as below to do the test:
./sipp -sf
uac_inv.xml<http://www.kamailio.org/docs/openser-performance-tests/data/uac_inv.xml>-rsa
10.1.11.24:5060 192.10.1.11.24:5081 -m 200000 -r 7000 -d 1 -l 27
where 10.1.11.24:5060 is for Kamailio, and 10.1.11.24:5081 is for sipp uas.
In the error log, I got the error message:
*********************************************************************'.
2012-03-22 08:55:43:933 1332377743.933861: Aborting call on
unexpected message for Call-Id '77062-11425(a)172.16.220.1': while expecting
'100' (index 1), received 'SIP/2.0 403 Not relaying
Via: SIP/2.0/UDP 172.16.220.1:5060
;branch=z9hG4bK-11425-77062-0;rport=5060;received=10.1.11.197
From: sipp <sip:sipp@172.16.220.1:5060>;tag=11425SIPpTag0077062
To: sut <sip:service@10.1.1.197:5080
>;tag=b27e1a1d33761e85846fc98f5f3a7e58.489a
Call-ID: 77062-11425(a)172.16.220.1
CSeq: 1 INVITE
Server: kamailio (3.2.0 (x86_64/linux))
Content-Length: 0
'.
2012-03-22 08:55:43:933 1332377743.933965: Aborting call on
unexpected message for Call-Id '77063-11425(a)172.16.220.1': while expecting
'100' (index 1), received 'SIP/2.0 403 Not relaying
Via: SIP/2.0/UDP 172.16.220.1:5060
;branch=z9hG4bK-11425-77063-0;rport=5060;received=10.1.11.197
From: sipp <sip:sipp@172.16.220.1:5060>;tag=11425SIPpTag0077063
To: sut <sip:service@10.1.1.197:5080
>;tag=b27e1a1d33761e85846fc98f5f3a7e58.853f
Call-ID: 77063-11425(a)172.16.220.1
CSeq: 1 INVITE
Server: kamailio (3.2.0 (x86_64/linux))
Content-Length: 0
*********************************************************************
Thanks,
Josh
Hi
I've also seen this error
"ERROR: acc [acc.c:405]: failed to insert into database ".
This seem to happen when cdrs_procedure runs at the same time of acc table insert. Can also be reliably reproduced by locking the acc table, make a call (about 20 seconds or more), end the call, wait for a short while, unlock acc table. This causes this error, and Kamailio inserts duplicated INIVTE / BYE entries into acc table. The number of duplicated entries depends on how long you've locked the table for. So I think this acc insert error may have been to do with table locking when cdrs_procedure is run.
When there are duplicated entries in acc table, cdrs_procedure takes the first INVITE/BYE entires and updated the cdrs table correctly. But threw an error when it hits the next duplicated entry and stop. So for us it didn't seem to cause any trouble for cdrs records so I didn't chase it further. But would be nice if we could stop/handle the duplicated entries some how.
Not a fix at at all, just some clues that might help.
Yufei
Message: 5
Date: Wed, 21 Mar 2012 20:28:33 +0200
From: Uri Shacked <ushacked(a)gmail.com>
Subject: Re: [SR-Users] ACCDB insert issues
To: "SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) -
Users Mailing List" <sr-users(a)lists.sip-router.org>
Message-ID:
<CAMMbDhTK2h4s1y_YJ_Tp8J7eZT4cmn_w1OkDBAS+3oAaZEZpAw(a)mail.gmail.com>
Content-Type: text/plain; charset="windows-1252"
Well, after some experiments...
Two things made the difference:
1. Use only the id as Pkey and remove all other indexes (helped a little).
2. Set myisam engine to the table (i knew that but tried innodb for its
reliability)
Now we are back in order to deal with many, many CAPS.
Thanks,
If someone has another idea, and uses innodb for the ACC. please advise...
BR,
Uri
On Tue, Mar 20, 2012 at 12:22 PM, Uri Shacked <ushacked(a)gmail.com> wrote:
> > no log on the msqld for it.
> > there is the CDR server that collects the events every 5 min and deletes
> > old once... i disabled it becoase i believed it was it. but, no.... the
> > error apears again...
> > a BI specialist told me it must have something to do with the number of
> > columns and the data type...
> >
> > On Tue, Mar 20, 2012 at 12:06 PM, Daniel-Constantin Mierla <
> > miconda(a)gmail.com> wrote:
> >
>> >> Do you have error messages in mysql server logs? Is there another
>> >> application that may block the acc table?
>> >>
>> >> The error refers to unavailability of the mysql server...
>> >>
>> >> Cheers,
>> >> Daniel
>> >>
>> >>
>> >> On 3/20/12 11:03 AM, Uri Shacked wrote:
>> >>
>> >> ERROR: db_mysql [km_dbase.c:122]: driver error on query: Lost
>> >> connection to MySQL server during query
>> >> Mar 18 20:03:38 net-ivr-KamIN-J1 /usr/local/sbin/kamailio[2671]: ERROR:
>> >> <core> [db_query.c:186]: error while submitting query
>> >> Mar 18 20:03:38 net-ivr-KamIN-J1 /usr/local/sbin/kamailio[2671]: ERROR:
>> >> acc [acc.c:405]: failed to insert into database
>> >>
>> >> Whe apears, from time to time, for some of them. it can rest for 2-10
>> >> hours, then have a "glitch" of 160 sql driver errors, and rest again....
>> >>
>> >>
>> >>
>> >> On Tue, Mar 20, 2012 at 11:51 AM, Daniel-Constantin Mierla <
>> >> miconda(a)gmail.com> wrote:
>> >>
>>> >>> Hello,
>>> >>>
>>> >>>
>>> >>> On 3/20/12 10:11 AM, Uri Shacked wrote:
>>> >>>
>>> >>> Hi,
>>> >>>
>>> >>>
>>> >>>
>>> >>> I am using the ACCDB with extra data. I collect the data to AVP's and
>>> >>> set it on the db_extra. It gets to be 37 columns?. Pretty long?
>>> >>> The problem I experience is that after a while (2-3 hours) with about 15
>>> >>> CAPS the MySQL ACC insert error appears.
>>> >>> And, I am loosing accounting data.
>>> >>>
>>> >>> what are the errors? Once they appear, is it for all records or just
>>> >>> from time to time, to some of them?
>>> >>>
>>> >>> Cheers,
>>> >>> Daniel
>>> >>>
>>> >>>
>>> >>>
>>> >>> Except of narrowing the amount of columns and setting the fields
>>> >>> (INT,CHAR etc.), does anyone has any ideas?
>>> >>>
>>> >>>
>>> >>>
>>> >>> The db_insert_mode set to 1 does not work (my ACC table is INNODB
>>> >>> because I don?t want to lose info).
>>> >>>
>>> >>>
>>> >>>
>>> >>> BR,
>>> >>>
>>> >>> Uri
>>> >>>
>>> >>>
>>> >>> _______________________________________________
>>> >>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing listsr-users@lists.sip-router.orghttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>>> >>>
>>> >>>
>>> >>> --
>>> >>> Daniel-Constantin Mierla
>>> >>> Kamailio Advanced Training, April 23-26, 2012, Berlin, Germanyhttp://www.asipto.com/index.php/kamailio-advanced-training/
>>> >>>
>>> >>>
>> >>
>> >> --
>> >> Daniel-Constantin Mierla
>> >> Kamailio Advanced Training, April 23-26, 2012, Berlin, Germanyhttp://www.asipto.com/index.php/kamailio-advanced-training/
>> >>
>> >>
> >
Hi mailing,
Newbie to kamailio, I follow this tuto
http://nil.uniza.sk/sip/kamailio/adding-mysql-support-kamailio-31-debian-le…
for the registration SIP via mysql database and it works fine, but I saw
that when during the call we disconnect the called UAC from network or
turn the power off the caller UAC don't hangup.
Is there any tool for how to hangup call when the UAC on the other side
has no network connection or it isn't power on durring a call ?
I heard for mediaroxy or rtpproxy but I don't know if them can do what I
except to haveand we also use ip routing to make kamailio server to
communicate with the UAC so we don't use NAT.
Our topology is:
kamailio (with public IP address) ---> cisco switch ---> LAN ---> UAC
(with private IP address)
Thanks in advance.
--
Inutile d'imprimer ce mail
Hi, I try to run this module, but unsuccesfully.
Can you give me some advices?
How I can start the pdb_server? I compile and install it, but don´t know
how get it run. I must add loadmodule="pdb.so" in kamailio.cfg file? When
I did it, kamailio didnt start. Starting end with error. I think that
there missing bracket :
# query external service for routing information
if (!pdb_query("$rU", "$avp(i:82)"))
$avp(i:82) = 0; # default routing
}
cr_route("$avp(i:82)", "$rd", "$rU", "$rU", "call_id");
Thank you for your answer.
Have a nice day.
Hi, I try to run this module, but unsuccesfully.
Can you give me some advices?
How I can start the pdb_server? I compile and install it, but don´t know
how get it run. I must add loadmodule="pdb.so" in kamailio.cfg file? When
I did it, kamailio didnt start. Starting end with error. I think that
there missing bracket :
# query external service for routing information
if (!pdb_query("$rU", "$avp(i:82)"))
$avp(i:82) = 0; # default routing
}
cr_route("$avp(i:82)", "$rd", "$rU", "$rU", "call_id");
Thank you for your answer.
Have a nice day.
Hello,
I am trying to set simple no-answer forward scenario: Alice calls Bob and
after timeout 5s forward to Carol (and additionally Carol timeout forward to
Dave).
I am using Kamailio 3.2.2 default config. There is part of routing logic for
no-answer forwarding:
route[RELAY] {
if(is_method("INVITE")) {
t_set_fr(5000);
t_on_branch("BRANCH_ONE");
t_on_reply("REPLY_ONE");
t_on_failure("FAIL_ONE");
}
if(!t_relay()) {
sl_reply_error();
}
}
branch_route[BRANCH_ONE] {
$avp(divert) = $null;
if($rU == "bob") {
$avp(divert) = "carol";
}
# second problem
if($rU == "carol") {
$avp(divert) = "dave";
}
}
failure_route[FAIL_ONE] {
if($avp(divert) != $null) {
add_diversion("no-answer");
$rU = $avp(divert);
route(LOOKUP);
route(RELAY);
}
}
First problem I encountered is that I can't check $rU in failure_route (it is
always set to original Request-URI - bob). Is this normal behavior or am I
missing something? Because of that I have to set divert destination in branch
route.
Second problem is when Carol's no-answer forward to Dave happens. Then
add_diversion adds invalid diversion header because it uses Request-URI which
is still set to bob.
Kind Regards,
Jan
