From alexandre.abreu@redt.com.br Thu Mar 17 17:45:16 2011
From: Alexandre Abreu <alexandre.abreu@redt.com.br>
To: sr-users@lists.kamailio.org
Subject: [SR-Users] event_route and acc_db_request().
Date: Thu, 17 Mar 2011 13:45:06 -0300
Message-ID: <014401cbe4c2$adcc8040$096580c0$@redt.com.br>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============1527376562=="

--===============1527376562==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit

Hello.

 

Why acc_db_request() doesn't work on event_route?

 

Mar 17 13:15:44 devel kamailio[25209]: INFO: <script>: Routing locally
generated BYE to <sip:2000000(a)192.168.200.114:9297>

Mar 17 13:15:44 devel kamailio[25209]: ERROR: <core> [db.c:421]: invalid
parameter value

Mar 17 13:15:44 devel kamailio[25209]: ERROR: acc [acc.c:391]: error in
use_table

Mar 17 13:15:44 devel kamailio[25209]: INFO: <script>: Routing locally
generated BYE to <sip:2000001(a)192.168.200.149:7335>

Mar 17 13:15:44 devel kamailio[25209]: ERROR: <core> [db.c:421]: invalid
parameter value

Mar 17 13:15:44 devel kamailio[25209]: ERROR: acc [acc.c:391]: error in
use_table

 

event_route[tm:local-request] {

 

        xlog("L_INFO", "Routing locally generated $rm to <$ru>\n");

 

        if (is_method("BYE"))

                acc_db_request("rtp-timeout", "acc");

}

 

If I change acc_db_request() to acc_log_request() everything works fine, but
this BYE should go to database for accounting purposes.

 

I am using GIT version from Kamailio branch 3.1.

 

>From 2008 there is a thread that also demonstrate this problem: 

 

http://www.mail-archive.com/users(a)lists.kamailio.org/msg01411.html

 

Unfortunately, in the archives, there's no solution for that.

 

Regards,

Alexandre




--===============1527376562==
Content-Type: text/html
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="attachment.html"
MIME-Version: 1.0

PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVy
bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6dz0idXJuOnNjaGVt
YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6bT0iaHR0cDovL3NjaGVtYXMubWlj
cm9zb2Z0LmNvbS9vZmZpY2UvMjAwNC8xMi9vbW1sIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcv
VFIvUkVDLWh0bWw0MCI+PGhlYWQ+PG1ldGEgaHR0cC1lcXVpdj1Db250ZW50LVR5cGUgY29udGVu
dD0idGV4dC9odG1sOyBjaGFyc2V0PXVzLWFzY2lpIj48bWV0YSBuYW1lPUdlbmVyYXRvciBjb250
ZW50PSJNaWNyb3NvZnQgV29yZCAxNCAoZmlsdGVyZWQgbWVkaXVtKSI+PHN0eWxlPjwhLS0KLyog
Rm9udCBEZWZpbml0aW9ucyAqLwpAZm9udC1mYWNlCgl7Zm9udC1mYW1pbHk6IkNhbWJyaWEgTWF0
aCI7CglwYW5vc2UtMToyIDQgNSAzIDUgNCA2IDMgMiA0O30KQGZvbnQtZmFjZQoJe2ZvbnQtZmFt
aWx5OkNhbGlicmk7CglwYW5vc2UtMToyIDE1IDUgMiAyIDIgNCAzIDIgNDt9Ci8qIFN0eWxlIERl
ZmluaXRpb25zICovCnAuTXNvTm9ybWFsLCBsaS5Nc29Ob3JtYWwsIGRpdi5Nc29Ob3JtYWwKCXtt
YXJnaW46MGNtOwoJbWFyZ2luLWJvdHRvbTouMDAwMXB0OwoJZm9udC1zaXplOjExLjBwdDsKCWZv
bnQtZmFtaWx5OiJDYWxpYnJpIiwic2Fucy1zZXJpZiI7Cgltc28tZmFyZWFzdC1sYW5ndWFnZTpF
Ti1VUzt9CmE6bGluaywgc3Bhbi5Nc29IeXBlcmxpbmsKCXttc28tc3R5bGUtcHJpb3JpdHk6OTk7
Cgljb2xvcjpibHVlOwoJdGV4dC1kZWNvcmF0aW9uOnVuZGVybGluZTt9CmE6dmlzaXRlZCwgc3Bh
bi5Nc29IeXBlcmxpbmtGb2xsb3dlZAoJe21zby1zdHlsZS1wcmlvcml0eTo5OTsKCWNvbG9yOnB1
cnBsZTsKCXRleHQtZGVjb3JhdGlvbjp1bmRlcmxpbmU7fQpzcGFuLkVzdGlsb0RlRW1haWwxNwoJ
e21zby1zdHlsZS10eXBlOnBlcnNvbmFsLWNvbXBvc2U7Cglmb250LWZhbWlseToiQ2FsaWJyaSIs
InNhbnMtc2VyaWYiOwoJY29sb3I6d2luZG93dGV4dDt9Ci5Nc29DaHBEZWZhdWx0Cgl7bXNvLXN0
eWxlLXR5cGU6ZXhwb3J0LW9ubHk7Cglmb250LWZhbWlseToiQ2FsaWJyaSIsInNhbnMtc2VyaWYi
OwoJbXNvLWZhcmVhc3QtbGFuZ3VhZ2U6RU4tVVM7fQpAcGFnZSBXb3JkU2VjdGlvbjEKCXtzaXpl
OjYxMi4wcHQgNzkyLjBwdDsKCW1hcmdpbjo3MC44NXB0IDMuMGNtIDcwLjg1cHQgMy4wY207fQpk
aXYuV29yZFNlY3Rpb24xCgl7cGFnZTpXb3JkU2VjdGlvbjE7fQotLT48L3N0eWxlPjwhLS1baWYg
Z3RlIG1zbyA5XT48eG1sPgo8bzpzaGFwZWRlZmF1bHRzIHY6ZXh0PSJlZGl0IiBzcGlkbWF4PSIx
MDI2IiAvPgo8L3htbD48IVtlbmRpZl0tLT48IS0tW2lmIGd0ZSBtc28gOV0+PHhtbD4KPG86c2hh
cGVsYXlvdXQgdjpleHQ9ImVkaXQiPgo8bzppZG1hcCB2OmV4dD0iZWRpdCIgZGF0YT0iMSIgLz4K
PC9vOnNoYXBlbGF5b3V0PjwveG1sPjwhW2VuZGlmXS0tPjwvaGVhZD48Ym9keSBsYW5nPVBULUJS
IGxpbms9Ymx1ZSB2bGluaz1wdXJwbGU+PGRpdiBjbGFzcz1Xb3JkU2VjdGlvbjE+PHAgY2xhc3M9
TXNvTm9ybWFsPjxzcGFuIGxhbmc9RU4tVVM+SGVsbG8uPG86cD48L286cD48L3NwYW4+PC9wPjxw
IGNsYXNzPU1zb05vcm1hbD48c3BhbiBsYW5nPUVOLVVTPjxvOnA+Jm5ic3A7PC9vOnA+PC9zcGFu
PjwvcD48cCBjbGFzcz1Nc29Ob3JtYWw+PHNwYW4gbGFuZz1FTi1VUz5XaHkgYWNjX2RiX3JlcXVl
c3QoKSBkb2VzbiYjODIxNzt0IHdvcmsgb24gZXZlbnRfcm91dGU/PG86cD48L286cD48L3NwYW4+
PC9wPjxwIGNsYXNzPU1zb05vcm1hbD48c3BhbiBsYW5nPUVOLVVTPjxvOnA+Jm5ic3A7PC9vOnA+
PC9zcGFuPjwvcD48cCBjbGFzcz1Nc29Ob3JtYWw+PHNwYW4gbGFuZz1FTi1VUz5NYXIgMTcgMTM6
MTU6NDQgZGV2ZWwga2FtYWlsaW9bMjUyMDldOiBJTkZPOiAmbHQ7c2NyaXB0Jmd0OzogUm91dGlu
ZyBsb2NhbGx5IGdlbmVyYXRlZCBCWUUgdG8gJmx0O3NpcDoyMDAwMDAwQDE5Mi4xNjguMjAwLjEx
NDo5Mjk3Jmd0OzxvOnA+PC9vOnA+PC9zcGFuPjwvcD48cCBjbGFzcz1Nc29Ob3JtYWw+PHNwYW4g
bGFuZz1FTi1VUz5NYXIgMTcgMTM6MTU6NDQgZGV2ZWwga2FtYWlsaW9bMjUyMDldOiBFUlJPUjog
Jmx0O2NvcmUmZ3Q7IFtkYi5jOjQyMV06IGludmFsaWQgcGFyYW1ldGVyIHZhbHVlPG86cD48L286
cD48L3NwYW4+PC9wPjxwIGNsYXNzPU1zb05vcm1hbD48c3BhbiBsYW5nPUVOLVVTPk1hciAxNyAx
MzoxNTo0NCBkZXZlbCBrYW1haWxpb1syNTIwOV06IEVSUk9SOiBhY2MgW2FjYy5jOjM5MV06IGVy
cm9yIGluIHVzZV90YWJsZTxvOnA+PC9vOnA+PC9zcGFuPjwvcD48cCBjbGFzcz1Nc29Ob3JtYWw+
PHNwYW4gbGFuZz1FTi1VUz5NYXIgMTcgMTM6MTU6NDQgZGV2ZWwga2FtYWlsaW9bMjUyMDldOiBJ
TkZPOiAmbHQ7c2NyaXB0Jmd0OzogUm91dGluZyBsb2NhbGx5IGdlbmVyYXRlZCBCWUUgdG8gJmx0
O3NpcDoyMDAwMDAxQDE5Mi4xNjguMjAwLjE0OTo3MzM1Jmd0OzxvOnA+PC9vOnA+PC9zcGFuPjwv
cD48cCBjbGFzcz1Nc29Ob3JtYWw+PHNwYW4gbGFuZz1FTi1VUz5NYXIgMTcgMTM6MTU6NDQgZGV2
ZWwga2FtYWlsaW9bMjUyMDldOiBFUlJPUjogJmx0O2NvcmUmZ3Q7IFtkYi5jOjQyMV06IGludmFs
aWQgcGFyYW1ldGVyIHZhbHVlPG86cD48L286cD48L3NwYW4+PC9wPjxwIGNsYXNzPU1zb05vcm1h
bD48c3BhbiBsYW5nPUVOLVVTPk1hciAxNyAxMzoxNTo0NCBkZXZlbCBrYW1haWxpb1syNTIwOV06
IEVSUk9SOiBhY2MgW2FjYy5jOjM5MV06IGVycm9yIGluIHVzZV90YWJsZTxvOnA+PC9vOnA+PC9z
cGFuPjwvcD48cCBjbGFzcz1Nc29Ob3JtYWw+PHNwYW4gbGFuZz1FTi1VUz48bzpwPiZuYnNwOzwv
bzpwPjwvc3Bhbj48L3A+PHAgY2xhc3M9TXNvTm9ybWFsPjxzcGFuIGxhbmc9RU4tVVM+ZXZlbnRf
cm91dGVbdG06bG9jYWwtcmVxdWVzdF0gezxvOnA+PC9vOnA+PC9zcGFuPjwvcD48cCBjbGFzcz1N
c29Ob3JtYWw+PHNwYW4gbGFuZz1FTi1VUz48bzpwPiZuYnNwOzwvbzpwPjwvc3Bhbj48L3A+PHAg
Y2xhc3M9TXNvTm9ybWFsPjxzcGFuIGxhbmc9RU4tVVM+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7
Jm5ic3A7Jm5ic3A7Jm5ic3A7IHhsb2coJnF1b3Q7TF9JTkZPJnF1b3Q7LCAmcXVvdDtSb3V0aW5n
IGxvY2FsbHkgZ2VuZXJhdGVkICRybSB0byAmbHQ7JHJ1Jmd0O1xuJnF1b3Q7KTs8bzpwPjwvbzpw
Pjwvc3Bhbj48L3A+PHAgY2xhc3M9TXNvTm9ybWFsPjxzcGFuIGxhbmc9RU4tVVM+PG86cD4mbmJz
cDs8L286cD48L3NwYW4+PC9wPjxwIGNsYXNzPU1zb05vcm1hbD48c3BhbiBsYW5nPUVOLVVTPiZu
YnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyBpZiAoaXNfbWV0aG9kKCZx
dW90O0JZRSZxdW90OykpPG86cD48L286cD48L3NwYW4+PC9wPjxwIGNsYXNzPU1zb05vcm1hbD48
c3BhbiBsYW5nPUVOLVVTPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNw
OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyBhY2NfZGJf
cmVxdWVzdCgmcXVvdDtydHAtdGltZW91dCZxdW90OywgJiM4MjIwO2FjYyYjODIyMTspOzxvOnA+
PC9vOnA+PC9zcGFuPjwvcD48cCBjbGFzcz1Nc29Ob3JtYWw+PHNwYW4gbGFuZz1FTi1VUz59PG86
cD48L286cD48L3NwYW4+PC9wPjxwIGNsYXNzPU1zb05vcm1hbD48c3BhbiBsYW5nPUVOLVVTPjxv
OnA+Jm5ic3A7PC9vOnA+PC9zcGFuPjwvcD48cCBjbGFzcz1Nc29Ob3JtYWw+PHNwYW4gbGFuZz1F
Ti1VUz5JZiBJIGNoYW5nZSBhY2NfZGJfcmVxdWVzdCgpIHRvIGFjY19sb2dfcmVxdWVzdCgpIGV2
ZXJ5dGhpbmcgd29ya3MgZmluZSwgYnV0IHRoaXMgQllFIHNob3VsZCBnbyB0byBkYXRhYmFzZSBm
b3IgYWNjb3VudGluZyBwdXJwb3Nlcy48bzpwPjwvbzpwPjwvc3Bhbj48L3A+PHAgY2xhc3M9TXNv
Tm9ybWFsPjxzcGFuIGxhbmc9RU4tVVM+PG86cD4mbmJzcDs8L286cD48L3NwYW4+PC9wPjxwIGNs
YXNzPU1zb05vcm1hbD48c3BhbiBsYW5nPUVOLVVTPkkgYW0gdXNpbmcgR0lUIHZlcnNpb24gZnJv
bSBLYW1haWxpbyBicmFuY2ggMy4xLjxvOnA+PC9vOnA+PC9zcGFuPjwvcD48cCBjbGFzcz1Nc29O
b3JtYWw+PHNwYW4gbGFuZz1FTi1VUz48bzpwPiZuYnNwOzwvbzpwPjwvc3Bhbj48L3A+PHAgY2xh
c3M9TXNvTm9ybWFsPjxzcGFuIGxhbmc9RU4tVVM+RnJvbSAyMDA4IHRoZXJlIGlzIGEgdGhyZWFk
IHRoYXQgYWxzbyBkZW1vbnN0cmF0ZSB0aGlzIHByb2JsZW06IDxvOnA+PC9vOnA+PC9zcGFuPjwv
cD48cCBjbGFzcz1Nc29Ob3JtYWw+PHNwYW4gbGFuZz1FTi1VUz48bzpwPiZuYnNwOzwvbzpwPjwv
c3Bhbj48L3A+PHAgY2xhc3M9TXNvTm9ybWFsPjxzcGFuIGxhbmc9RU4tVVM+aHR0cDovL3d3dy5t
YWlsLWFyY2hpdmUuY29tL3VzZXJzQGxpc3RzLmthbWFpbGlvLm9yZy9tc2cwMTQxMS5odG1sPG86
cD48L286cD48L3NwYW4+PC9wPjxwIGNsYXNzPU1zb05vcm1hbD48c3BhbiBsYW5nPUVOLVVTPjxv
OnA+Jm5ic3A7PC9vOnA+PC9zcGFuPjwvcD48cCBjbGFzcz1Nc29Ob3JtYWw+PHNwYW4gbGFuZz1F
Ti1VUz5VbmZvcnR1bmF0ZWx5LCBpbiB0aGUgYXJjaGl2ZXMsIHRoZXJlJiM4MjE3O3Mgbm8gc29s
dXRpb24gZm9yIHRoYXQuPG86cD48L286cD48L3NwYW4+PC9wPjxwIGNsYXNzPU1zb05vcm1hbD48
c3BhbiBsYW5nPUVOLVVTPjxvOnA+Jm5ic3A7PC9vOnA+PC9zcGFuPjwvcD48cCBjbGFzcz1Nc29O
b3JtYWw+PHNwYW4gbGFuZz1FTi1VUz5SZWdhcmRzLDxvOnA+PC9vOnA+PC9zcGFuPjwvcD48cCBj
bGFzcz1Nc29Ob3JtYWw+PHNwYW4gbGFuZz1FTi1VUz5BbGV4YW5kcmU8bzpwPjwvbzpwPjwvc3Bh
bj48L3A+PC9kaXY+PC9ib2R5PjwvaHRtbD4=

--===============1527376562==--


From miconda@gmail.com Wed Mar 23 08:55:03 2011
From: Daniel-Constantin Mierla <miconda@gmail.com>
To: sr-users@lists.kamailio.org
Subject: Re: [SR-Users] event_route and acc_db_request().
Date: Wed, 23 Mar 2011 08:54:56 +0100
Message-ID: <4D89A750.6050700@gmail.com>
In-Reply-To: <014401cbe4c2$adcc8040$096580c0$@redt.com.br>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============0578522239=="

--===============0578522239==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit

Hello,

On 3/17/11 5:45 PM, Alexandre Abreu wrote:
>
> Hello.
>
> Why acc_db_request() doesn't work on event_route?
>

I will take a look.

Is the BYE generated by dialog timeout or you trigger it by kamctl/xmlrpc?

Cheers,
Daniel

> Mar 17 13:15:44 devel kamailio[25209]: INFO: <script>: Routing locally 
> generated BYE to <sip:2000000(a)192.168.200.114:9297>
>
> Mar 17 13:15:44 devel kamailio[25209]: ERROR: <core> [db.c:421]: 
> invalid parameter value
>
> Mar 17 13:15:44 devel kamailio[25209]: ERROR: acc [acc.c:391]: error 
> in use_table
>
> Mar 17 13:15:44 devel kamailio[25209]: INFO: <script>: Routing locally 
> generated BYE to <sip:2000001(a)192.168.200.149:7335>
>
> Mar 17 13:15:44 devel kamailio[25209]: ERROR: <core> [db.c:421]: 
> invalid parameter value
>
> Mar 17 13:15:44 devel kamailio[25209]: ERROR: acc [acc.c:391]: error 
> in use_table
>
> event_route[tm:local-request] {
>
>         xlog("L_INFO", "Routing locally generated $rm to <$ru>\n");
>
>         if (is_method("BYE"))
>
>                 acc_db_request("rtp-timeout", "acc");
>
> }
>
> If I change acc_db_request() to acc_log_request() everything works 
> fine, but this BYE should go to database for accounting purposes.
>
> I am using GIT version from Kamailio branch 3.1.
>
> From 2008 there is a thread that also demonstrate this problem:
>
> http://www.mail-archive.com/users(a)lists.kamailio.org/msg01411.html
>
> Unfortunately, in the archives, there's no solution for that.
>
> Regards,
>
> Alexandre
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users(a)lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla
http://www.asipto.com




--===============0578522239==
Content-Type: text/html
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="attachment.html"
MIME-Version: 1.0

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMDEgVHJhbnNpdGlvbmFs
Ly9FTiI+CjxodG1sPgogIDxoZWFkPgogICAgPG1ldGEgY29udGVudD0idGV4dC9odG1sOyBjaGFy
c2V0PUlTTy04ODU5LTEiCiAgICAgIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSI+CiAgPC9oZWFk
PgogIDxib2R5IGJnY29sb3I9IiNmZmZmZmYiIHRleHQ9IiMwMDAwMDAiPgogICAgSGVsbG8sPGJy
PgogICAgPGJyPgogICAgT24gMy8xNy8xMSA1OjQ1IFBNLCBBbGV4YW5kcmUgQWJyZXUgd3JvdGU6
CiAgICA8YmxvY2txdW90ZSBjaXRlPSJtaWQ6MDE0NDAxY2JlNGMyJGFkY2M4MDQwJDA5NjU4MGMw
JEByZWR0LmNvbS5iciIKICAgICAgdHlwZT0iY2l0ZSI+CiAgICAgIDxtZXRhIGh0dHAtZXF1aXY9
IkNvbnRlbnQtVHlwZSIgY29udGVudD0idGV4dC9odG1sOwogICAgICAgIGNoYXJzZXQ9SVNPLTg4
NTktMSI+CiAgICAgIDxtZXRhIG5hbWU9IkdlbmVyYXRvciIgY29udGVudD0iTWljcm9zb2Z0IFdv
cmQgMTQgKGZpbHRlcmVkCiAgICAgICAgbWVkaXVtKSI+CiAgICAgIDxzdHlsZT48IS0tCi8qIEZv
bnQgRGVmaW5pdGlvbnMgKi8KQGZvbnQtZmFjZQoJe2ZvbnQtZmFtaWx5OiJDYW1icmlhIE1hdGgi
OwoJcGFub3NlLTE6MiA0IDUgMyA1IDQgNiAzIDIgNDt9CkBmb250LWZhY2UKCXtmb250LWZhbWls
eTpDYWxpYnJpOwoJcGFub3NlLTE6MiAxNSA1IDIgMiAyIDQgMyAyIDQ7fQovKiBTdHlsZSBEZWZp
bml0aW9ucyAqLwpwLk1zb05vcm1hbCwgbGkuTXNvTm9ybWFsLCBkaXYuTXNvTm9ybWFsCgl7bWFy
Z2luOjBjbTsKCW1hcmdpbi1ib3R0b206LjAwMDFwdDsKCWZvbnQtc2l6ZToxMS4wcHQ7Cglmb250
LWZhbWlseToiQ2FsaWJyaSIsInNhbnMtc2VyaWYiOwoJbXNvLWZhcmVhc3QtbGFuZ3VhZ2U6RU4t
VVM7fQphOmxpbmssIHNwYW4uTXNvSHlwZXJsaW5rCgl7bXNvLXN0eWxlLXByaW9yaXR5Ojk5OwoJ
Y29sb3I6Ymx1ZTsKCXRleHQtZGVjb3JhdGlvbjp1bmRlcmxpbmU7fQphOnZpc2l0ZWQsIHNwYW4u
TXNvSHlwZXJsaW5rRm9sbG93ZWQKCXttc28tc3R5bGUtcHJpb3JpdHk6OTk7Cgljb2xvcjpwdXJw
bGU7Cgl0ZXh0LWRlY29yYXRpb246dW5kZXJsaW5lO30Kc3Bhbi5Fc3RpbG9EZUVtYWlsMTcKCXtt
c28tc3R5bGUtdHlwZTpwZXJzb25hbC1jb21wb3NlOwoJZm9udC1mYW1pbHk6IkNhbGlicmkiLCJz
YW5zLXNlcmlmIjsKCWNvbG9yOndpbmRvd3RleHQ7fQouTXNvQ2hwRGVmYXVsdAoJe21zby1zdHls
ZS10eXBlOmV4cG9ydC1vbmx5OwoJZm9udC1mYW1pbHk6IkNhbGlicmkiLCJzYW5zLXNlcmlmIjsK
CW1zby1mYXJlYXN0LWxhbmd1YWdlOkVOLVVTO30KQHBhZ2UgV29yZFNlY3Rpb24xCgl7c2l6ZTo2
MTIuMHB0IDc5Mi4wcHQ7CgltYXJnaW46NzAuODVwdCAzLjBjbSA3MC44NXB0IDMuMGNtO30KZGl2
LldvcmRTZWN0aW9uMQoJe3BhZ2U6V29yZFNlY3Rpb24xO30KLS0+PC9zdHlsZT48IS0tW2lmIGd0
ZSBtc28gOV0+PHhtbD4KPG86c2hhcGVkZWZhdWx0cyB2OmV4dD0iZWRpdCIgc3BpZG1heD0iMTAy
NiIgLz4KPC94bWw+PCFbZW5kaWZdLS0+PCEtLVtpZiBndGUgbXNvIDldPjx4bWw+CjxvOnNoYXBl
bGF5b3V0IHY6ZXh0PSJlZGl0Ij4KPG86aWRtYXAgdjpleHQ9ImVkaXQiIGRhdGE9IjEiIC8+Cjwv
bzpzaGFwZWxheW91dD48L3htbD48IVtlbmRpZl0tLT4KICAgICAgPGRpdiBjbGFzcz0iV29yZFNl
Y3Rpb24xIj4KICAgICAgICA8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBsYW5nPSJFTi1VUyI+
SGVsbG8uPG86cD48L286cD48L3NwYW4+PC9wPgogICAgICAgIDxwIGNsYXNzPSJNc29Ob3JtYWwi
PjxzcGFuIGxhbmc9IkVOLVVTIj48bzpwPiZuYnNwOzwvbzpwPjwvc3Bhbj48L3A+CiAgICAgICAg
PHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gbGFuZz0iRU4tVVMiPldoeSBhY2NfZGJfcmVxdWVz
dCgpCiAgICAgICAgICAgIGRvZXNuJiM4MjE3O3Qgd29yayBvbiBldmVudF9yb3V0ZT88L3NwYW4+
PC9wPgogICAgICA8L2Rpdj4KICAgIDwvYmxvY2txdW90ZT4KICAgIDxicj4KICAgIEkgd2lsbCB0
YWtlIGEgbG9vay48YnI+CiAgICA8YnI+CiAgICBJcyB0aGUgQllFIGdlbmVyYXRlZCBieSBkaWFs
b2cgdGltZW91dCBvciB5b3UgdHJpZ2dlciBpdCBieQogICAga2FtY3RsL3htbHJwYz88YnI+CiAg
ICA8YnI+CiAgICBDaGVlcnMsPGJyPgogICAgRGFuaWVsPGJyPgogICAgPGJyPgogICAgPGJsb2Nr
cXVvdGUgY2l0ZT0ibWlkOjAxNDQwMWNiZTRjMiRhZGNjODA0MCQwOTY1ODBjMCRAcmVkdC5jb20u
YnIiCiAgICAgIHR5cGU9ImNpdGUiPgogICAgICA8ZGl2IGNsYXNzPSJXb3JkU2VjdGlvbjEiPgog
ICAgICAgIDxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIGxhbmc9IkVOLVVTIj48bzpwPjwvbzpw
Pjwvc3Bhbj48L3A+CiAgICAgICAgPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gbGFuZz0iRU4t
VVMiPjxvOnA+Jm5ic3A7PC9vOnA+PC9zcGFuPjwvcD4KICAgICAgICA8cCBjbGFzcz0iTXNvTm9y
bWFsIj48c3BhbiBsYW5nPSJFTi1VUyI+TWFyIDE3IDEzOjE1OjQ0IGRldmVsCiAgICAgICAgICAg
IGthbWFpbGlvWzI1MjA5XTogSU5GTzogJmx0O3NjcmlwdCZndDs6IFJvdXRpbmcgbG9jYWxseQog
ICAgICAgICAgICBnZW5lcmF0ZWQgQllFIHRvIDxhIGNsYXNzPSJtb3otdHh0LWxpbmstcmZjMjM5
NkUiIGhyZWY9InNpcDoyMDAwMDAwQDE5Mi4xNjguMjAwLjExNDo5Mjk3Ij4mbHQ7c2lwOjIwMDAw
MDBAMTkyLjE2OC4yMDAuMTE0OjkyOTcmZ3Q7PC9hPjxvOnA+PC9vOnA+PC9zcGFuPjwvcD4KICAg
ICAgICA8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBsYW5nPSJFTi1VUyI+TWFyIDE3IDEzOjE1
OjQ0IGRldmVsCiAgICAgICAgICAgIGthbWFpbGlvWzI1MjA5XTogRVJST1I6ICZsdDtjb3JlJmd0
OyBbZGIuYzo0MjFdOiBpbnZhbGlkCiAgICAgICAgICAgIHBhcmFtZXRlciB2YWx1ZTxvOnA+PC9v
OnA+PC9zcGFuPjwvcD4KICAgICAgICA8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBsYW5nPSJF
Ti1VUyI+TWFyIDE3IDEzOjE1OjQ0IGRldmVsCiAgICAgICAgICAgIGthbWFpbGlvWzI1MjA5XTog
RVJST1I6IGFjYyBbYWNjLmM6MzkxXTogZXJyb3IgaW4gdXNlX3RhYmxlPG86cD48L286cD48L3Nw
YW4+PC9wPgogICAgICAgIDxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIGxhbmc9IkVOLVVTIj5N
YXIgMTcgMTM6MTU6NDQgZGV2ZWwKICAgICAgICAgICAga2FtYWlsaW9bMjUyMDldOiBJTkZPOiAm
bHQ7c2NyaXB0Jmd0OzogUm91dGluZyBsb2NhbGx5CiAgICAgICAgICAgIGdlbmVyYXRlZCBCWUUg
dG8gPGEgY2xhc3M9Im1vei10eHQtbGluay1yZmMyMzk2RSIgaHJlZj0ic2lwOjIwMDAwMDFAMTky
LjE2OC4yMDAuMTQ5OjczMzUiPiZsdDtzaXA6MjAwMDAwMUAxOTIuMTY4LjIwMC4xNDk6NzMzNSZn
dDs8L2E+PG86cD48L286cD48L3NwYW4+PC9wPgogICAgICAgIDxwIGNsYXNzPSJNc29Ob3JtYWwi
PjxzcGFuIGxhbmc9IkVOLVVTIj5NYXIgMTcgMTM6MTU6NDQgZGV2ZWwKICAgICAgICAgICAga2Ft
YWlsaW9bMjUyMDldOiBFUlJPUjogJmx0O2NvcmUmZ3Q7IFtkYi5jOjQyMV06IGludmFsaWQKICAg
ICAgICAgICAgcGFyYW1ldGVyIHZhbHVlPG86cD48L286cD48L3NwYW4+PC9wPgogICAgICAgIDxw
IGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIGxhbmc9IkVOLVVTIj5NYXIgMTcgMTM6MTU6NDQgZGV2
ZWwKICAgICAgICAgICAga2FtYWlsaW9bMjUyMDldOiBFUlJPUjogYWNjIFthY2MuYzozOTFdOiBl
cnJvciBpbiB1c2VfdGFibGU8bzpwPjwvbzpwPjwvc3Bhbj48L3A+CiAgICAgICAgPHAgY2xhc3M9
Ik1zb05vcm1hbCI+PHNwYW4gbGFuZz0iRU4tVVMiPjxvOnA+Jm5ic3A7PC9vOnA+PC9zcGFuPjwv
cD4KICAgICAgICA8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBsYW5nPSJFTi1VUyI+ZXZlbnRf
cm91dGVbdG06bG9jYWwtcmVxdWVzdF0KICAgICAgICAgICAgezxvOnA+PC9vOnA+PC9zcGFuPjwv
cD4KICAgICAgICA8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBsYW5nPSJFTi1VUyI+PG86cD4m
bmJzcDs8L286cD48L3NwYW4+PC9wPgogICAgICAgIDxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFu
IGxhbmc9IkVOLVVTIj4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsg
eGxvZygiTF9JTkZPIiwKICAgICAgICAgICAgIlJvdXRpbmcgbG9jYWxseSBnZW5lcmF0ZWQgJHJt
IHRvICZsdDskcnUmZ3Q7XG4iKTs8bzpwPjwvbzpwPjwvc3Bhbj48L3A+CiAgICAgICAgPHAgY2xh
c3M9Ik1zb05vcm1hbCI+PHNwYW4gbGFuZz0iRU4tVVMiPjxvOnA+Jm5ic3A7PC9vOnA+PC9zcGFu
PjwvcD4KICAgICAgICA8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBsYW5nPSJFTi1VUyI+Jm5i
c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IGlmCiAgICAgICAgICAgIChp
c19tZXRob2QoIkJZRSIpKTxvOnA+PC9vOnA+PC9zcGFuPjwvcD4KICAgICAgICA8cCBjbGFzcz0i
TXNvTm9ybWFsIj48c3BhbiBsYW5nPSJFTi1VUyI+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i
c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7
Jm5ic3A7CiAgICAgICAgICAgIGFjY19kYl9yZXF1ZXN0KCJydHAtdGltZW91dCIsICYjODIyMDth
Y2MmIzgyMjE7KTs8bzpwPjwvbzpwPjwvc3Bhbj48L3A+CiAgICAgICAgPHAgY2xhc3M9Ik1zb05v
cm1hbCI+PHNwYW4gbGFuZz0iRU4tVVMiPn08bzpwPjwvbzpwPjwvc3Bhbj48L3A+CiAgICAgICAg
PHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gbGFuZz0iRU4tVVMiPjxvOnA+Jm5ic3A7PC9vOnA+
PC9zcGFuPjwvcD4KICAgICAgICA8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBsYW5nPSJFTi1V
UyI+SWYgSSBjaGFuZ2UKICAgICAgICAgICAgYWNjX2RiX3JlcXVlc3QoKSB0byBhY2NfbG9nX3Jl
cXVlc3QoKSBldmVyeXRoaW5nIHdvcmtzIGZpbmUsCiAgICAgICAgICAgIGJ1dCB0aGlzIEJZRSBz
aG91bGQgZ28gdG8gZGF0YWJhc2UgZm9yIGFjY291bnRpbmcgcHVycG9zZXMuPG86cD48L286cD48
L3NwYW4+PC9wPgogICAgICAgIDxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIGxhbmc9IkVOLVVT
Ij48bzpwPiZuYnNwOzwvbzpwPjwvc3Bhbj48L3A+CiAgICAgICAgPHAgY2xhc3M9Ik1zb05vcm1h
bCI+PHNwYW4gbGFuZz0iRU4tVVMiPkkgYW0gdXNpbmcgR0lUIHZlcnNpb24KICAgICAgICAgICAg
ZnJvbSBLYW1haWxpbyBicmFuY2ggMy4xLjxvOnA+PC9vOnA+PC9zcGFuPjwvcD4KICAgICAgICA8
cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBsYW5nPSJFTi1VUyI+PG86cD4mbmJzcDs8L286cD48
L3NwYW4+PC9wPgogICAgICAgIDxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIGxhbmc9IkVOLVVT
Ij5Gcm9tIDIwMDggdGhlcmUgaXMgYQogICAgICAgICAgICB0aHJlYWQgdGhhdCBhbHNvIGRlbW9u
c3RyYXRlIHRoaXMgcHJvYmxlbTogPG86cD48L286cD48L3NwYW4+PC9wPgogICAgICAgIDxwIGNs
YXNzPSJNc29Ob3JtYWwiPjxzcGFuIGxhbmc9IkVOLVVTIj48bzpwPiZuYnNwOzwvbzpwPjwvc3Bh
bj48L3A+CiAgICAgICAgPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gbGFuZz0iRU4tVVMiPjxh
IGNsYXNzPSJtb3otdHh0LWxpbmstZnJlZXRleHQiIGhyZWY9Imh0dHA6Ly93d3cubWFpbC1hcmNo
aXZlLmNvbS91c2Vyc0BsaXN0cy5rYW1haWxpby5vcmcvbXNnMDE0MTEuaHRtbCI+aHR0cDovL3d3
dy5tYWlsLWFyY2hpdmUuY29tL3VzZXJzQGxpc3RzLmthbWFpbGlvLm9yZy9tc2cwMTQxMS5odG1s
PC9hPjxvOnA+PC9vOnA+PC9zcGFuPjwvcD4KICAgICAgICA8cCBjbGFzcz0iTXNvTm9ybWFsIj48
c3BhbiBsYW5nPSJFTi1VUyI+PG86cD4mbmJzcDs8L286cD48L3NwYW4+PC9wPgogICAgICAgIDxw
IGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIGxhbmc9IkVOLVVTIj5VbmZvcnR1bmF0ZWx5LCBpbiB0
aGUKICAgICAgICAgICAgYXJjaGl2ZXMsIHRoZXJlJiM4MjE3O3Mgbm8gc29sdXRpb24gZm9yIHRo
YXQuPG86cD48L286cD48L3NwYW4+PC9wPgogICAgICAgIDxwIGNsYXNzPSJNc29Ob3JtYWwiPjxz
cGFuIGxhbmc9IkVOLVVTIj48bzpwPiZuYnNwOzwvbzpwPjwvc3Bhbj48L3A+CiAgICAgICAgPHAg
Y2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gbGFuZz0iRU4tVVMiPlJlZ2FyZHMsPG86cD48L286cD48
L3NwYW4+PC9wPgogICAgICAgIDxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIGxhbmc9IkVOLVVT
Ij5BbGV4YW5kcmU8bzpwPjwvbzpwPjwvc3Bhbj48L3A+CiAgICAgIDwvZGl2PgogICAgICA8cHJl
IHdyYXA9IiI+CjxmaWVsZHNldCBjbGFzcz0ibWltZUF0dGFjaG1lbnRIZWFkZXIiPjwvZmllbGRz
ZXQ+Cl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fClNJUCBF
eHByZXNzIFJvdXRlciAoU0VSKSBhbmQgS2FtYWlsaW8gKE9wZW5TRVIpIC0gc3ItdXNlcnMgbWFp
bGluZyBsaXN0CjxhIGNsYXNzPSJtb3otdHh0LWxpbmstYWJicmV2aWF0ZWQiIGhyZWY9Im1haWx0
bzpzci11c2Vyc0BsaXN0cy5zaXAtcm91dGVyLm9yZyI+c3ItdXNlcnNAbGlzdHMuc2lwLXJvdXRl
ci5vcmc8L2E+CjxhIGNsYXNzPSJtb3otdHh0LWxpbmstZnJlZXRleHQiIGhyZWY9Imh0dHA6Ly9s
aXN0cy5zaXAtcm91dGVyLm9yZy9jZ2ktYmluL21haWxtYW4vbGlzdGluZm8vc3ItdXNlcnMiPmh0
dHA6Ly9saXN0cy5zaXAtcm91dGVyLm9yZy9jZ2ktYmluL21haWxtYW4vbGlzdGluZm8vc3ItdXNl
cnM8L2E+CjwvcHJlPgogICAgPC9ibG9ja3F1b3RlPgogICAgPGJyPgogICAgPHByZSBjbGFzcz0i
bW96LXNpZ25hdHVyZSIgY29scz0iNzIiPi0tIApEYW5pZWwtQ29uc3RhbnRpbiBNaWVybGEKPGEg
Y2xhc3M9Im1vei10eHQtbGluay1mcmVldGV4dCIgaHJlZj0iaHR0cDovL3d3dy5hc2lwdG8uY29t
Ij5odHRwOi8vd3d3LmFzaXB0by5jb208L2E+PC9wcmU+CiAgPC9ib2R5Pgo8L2h0bWw+Cg==

--===============0578522239==--


From alexandre.abreu@redt.com.br Wed Mar 23 13:44:49 2011
From: Alexandre Abreu <alexandre.abreu@redt.com.br>
To: sr-users@lists.kamailio.org
Subject: [SR-Users] RES:  event_route and acc_db_request().
Date: Wed, 23 Mar 2011 09:44:39 -0300
Message-ID: <008501cbe958$15128440$3f378cc0$@redt.com.br>
In-Reply-To: <4D89A750.6050700@gmail.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============0025955746=="

--===============0025955746==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 8bit

Hello Daniel.

The BYE is generated by kamctl/xmlrpc (dlg_terminate_dlg).

Alexandre

De: Daniel-Constantin Mierla [mailto:miconda(a)gmail.com] 
Enviada em: quarta-feira, 23 de março de 2011 04:55
Para: SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - Users
Mailing List
Cc: Alexandre Abreu
Assunto: Re: [SR-Users] event_route and acc_db_request().

Hello,

On 3/17/11 5:45 PM, Alexandre Abreu wrote: 
Hello.
 
Why acc_db_request() doesn’t work on event_route?

I will take a look.

Is the BYE generated by dialog timeout or you trigger it by kamctl/xmlrpc?

Cheers,
Daniel


 
Mar 17 13:15:44 devel kamailio[25209]: INFO: <script>: Routing locally
generated BYE to <sip:2000000(a)192.168.200.114:9297>
Mar 17 13:15:44 devel kamailio[25209]: ERROR: <core> [db.c:421]: invalid
parameter value
Mar 17 13:15:44 devel kamailio[25209]: ERROR: acc [acc.c:391]: error in
use_table
Mar 17 13:15:44 devel kamailio[25209]: INFO: <script>: Routing locally
generated BYE to <sip:2000001(a)192.168.200.149:7335>
Mar 17 13:15:44 devel kamailio[25209]: ERROR: <core> [db.c:421]: invalid
parameter value
Mar 17 13:15:44 devel kamailio[25209]: ERROR: acc [acc.c:391]: error in
use_table
 
event_route[tm:local-request] {
 
        xlog("L_INFO", "Routing locally generated $rm to <$ru>\n");
 
        if (is_method("BYE"))
                acc_db_request("rtp-timeout", “acc”);
}
 
If I change acc_db_request() to acc_log_request() everything works fine, but
this BYE should go to database for accounting purposes.
 
I am using GIT version from Kamailio branch 3.1.
 
>From 2008 there is a thread that also demonstrate this problem: 
 
http://www.mail-archive.com/users(a)lists.kamailio.org/msg01411.html
 
Unfortunately, in the archives, there’s no solution for that.
 
Regards,
Alexandre


_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users


-- 
Daniel-Constantin Mierla
http://www.asipto.com



--===============0025955746==--


From miconda@gmail.com Wed Mar 23 14:17:00 2011
From: Daniel-Constantin Mierla <miconda@gmail.com>
To: sr-users@lists.kamailio.org
Subject: Re: [SR-Users] RES:  event_route and acc_db_request().
Date: Wed, 23 Mar 2011 14:16:51 +0100
Message-ID: <4D89F2C3.2080504@gmail.com>
In-Reply-To: <008501cbe958$15128440$3f378cc0$@redt.com.br>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============1608753129=="

--===============1608753129==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 8bit

Hello,

On 3/23/11 1:44 PM, Alexandre Abreu wrote:
> Hello Daniel.
>
> The BYE is generated by kamctl/xmlrpc (dlg_terminate_dlg).

is xmlrpc via mi_xmlrpc or via xmlrpc module?

I have to double check, but looks very likely to be the fact that acc db 
connection was not initialized for MI/RPC children processes.

Thanks,
Daniel

> Alexandre
>
> De: Daniel-Constantin Mierla [mailto:miconda(a)gmail.com]
> Enviada em: quarta-feira, 23 de março de 2011 04:55
> Para: SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - Users
> Mailing List
> Cc: Alexandre Abreu
> Assunto: Re: [SR-Users] event_route and acc_db_request().
>
> Hello,
>
> On 3/17/11 5:45 PM, Alexandre Abreu wrote:
> Hello.
>
> Why acc_db_request() doesn’t work on event_route?
>
> I will take a look.
>
> Is the BYE generated by dialog timeout or you trigger it by kamctl/xmlrpc?
>
> Cheers,
> Daniel
>
>
>
> Mar 17 13:15:44 devel kamailio[25209]: INFO:<script>: Routing locally
> generated BYE to<sip:2000000(a)192.168.200.114:9297>
> Mar 17 13:15:44 devel kamailio[25209]: ERROR:<core>  [db.c:421]: invalid
> parameter value
> Mar 17 13:15:44 devel kamailio[25209]: ERROR: acc [acc.c:391]: error in
> use_table
> Mar 17 13:15:44 devel kamailio[25209]: INFO:<script>: Routing locally
> generated BYE to<sip:2000001(a)192.168.200.149:7335>
> Mar 17 13:15:44 devel kamailio[25209]: ERROR:<core>  [db.c:421]: invalid
> parameter value
> Mar 17 13:15:44 devel kamailio[25209]: ERROR: acc [acc.c:391]: error in
> use_table
>
> event_route[tm:local-request] {
>
>          xlog("L_INFO", "Routing locally generated $rm to<$ru>\n");
>
>          if (is_method("BYE"))
>                  acc_db_request("rtp-timeout", “acc”);
> }
>
> If I change acc_db_request() to acc_log_request() everything works fine, but
> this BYE should go to database for accounting purposes.
>
> I am using GIT version from Kamailio branch 3.1.
>
>  From 2008 there is a thread that also demonstrate this problem:
>
> http://www.mail-archive.com/users(a)lists.kamailio.org/msg01411.html
>
> Unfortunately, in the archives, there’s no solution for that.
>
> Regards,
> Alexandre
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users(a)lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>

-- 
Daniel-Constantin Mierla
http://www.asipto.com



--===============1608753129==--