I understand, to get the cdr you should have created the dialog before
replying.
Cheers,
Federico
On Fri, 14 Jun 2019, 17:05 Pejic, Miroslav, <miroslav.pe...@cloud.timenet.it>
wrote:
> [image: image.png]
>
> The call doesn't even begin, I immediately block it. :)
>
> Il giorno ven 14 giu 2019 alle ore 16:59 Pejic, Miroslav <
> miroslav.pe...@cloud.timenet.it> ha scritto:
>
>> Hi Federico,
>>
>> i tryied also with `modparam("acc", "cdr_on_failed", 1)`
>> but in my case the call is not saved at all on `acc_cdrs`,
>> with the second method i mentioned works :)
>> Thanks
>> Miro
>>
>> Il giorno ven 14 giu 2019 alle ore 16:14 Federico Cabiddu <
>> federico.cabi...@gmail.com> ha scritto:
>>
>>> Hi,
>>> dialog CDR for failed calls can be generated enabling
>>>
>>> http://www.kamailio.org/docs/modules/devel/modules/acc.html#acc.p.cdr_on_failed
>>>
>>> It has been some time since I last tested it, but it still should work :)
>>>
>>> Cheers,
>>>
>>> Federico
>>>
>>> On Fri, Jun 14, 2019 at 3:25 PM Daniel-Constantin Mierla <
>>> mico...@gmail.com> wrote:
>>>
>>>> Hello,
>>>>
>>>> it should be ok also with 2) if it gives what you want. Kamailio is
>>>> just writing to acc_cdrs, if you have extra columns, it should not be
>>>> affected.
>>>>
>>>> Cheers,
>>>> Daniel
>>>> On 14.06.19 14:16, Pejic, Miroslav wrote:
>>>>
>>>> Hi Daniel :)
>>>>
>>>> i tryied 2 methods to save it
>>>>
>>>> 1) i created a new table on kamailio_router called `acc`
>>>>
>>>> from `utils/kamctl/mysql/acc-create.sql`
>>>>
>>>> ```
>>>> CREATE TABLE `acc` (
>>>> `id` INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
>>>> `method` VARCHAR(16) DEFAULT '' NOT NULL,
>>>> `from_tag` VARCHAR(128) DEFAULT '' NOT NULL,
>>>> `to_tag` VARCHAR(128) DEFAULT '' NOT NULL,
>>>> `callid` VARCHAR(255) DEFAULT '' NOT NULL,
>>>> `sip_code` VARCHAR(3) DEFAULT '' NOT NULL,
>>>> `sip_reason` VARCHAR(128) DEFAULT '' NOT NULL,
>>>> `time` DATETIME NOT NULL
>>>> );
>>>> CREATE INDEX callid_idx ON acc (`callid`);
>>>> ```
>>>> then
>>>>
>>>> ```
>>>> route[IS_CALLER_BLACKLISTED] {
>>>>
>>>> python_exec("check_caller_blacklisted");
>>>>
>>>> if ($var(callerBlacklisted) == 1){
>>>>
>>>> t_send_reply("403", "Forbidden");
>>>>
>>>> acc_db_request("403 Forbidden", "acc");
>>>>
>>>> exit;
>>>>
>>>> }
>>>>
>>>> ```
>>>>
>>>> in `acc` i have now calls that were not answered with 200ok :)
>>>>
>>>>
>>>> 2) add new fields on exsisting acc_cdrs table used to store cdrs
>>>>
>>>> ```
>>>> ALTER TABLE `acc_cdrs` ADD COLUMN `from_tag` varchar(128) DEFAULT NULL
>>>> AFTER `dst_domain`;
>>>> ALTER TABLE `acc_cdrs` ADD COLUMN `to_tag` VARCHAR(128) DEFAULT NULL
>>>> AFTER `from_tag`;
>>>> ALTER TABLE `acc_cdrs` ADD COLUMN `sip_code` VARCHAR(3) DEFAULT NULL
>>>> AFTER `to_tag`;
>>>> ALTER TABLE `acc_cdrs` ADD COLUMN `sip_reason` varchar(128) DEFAULT
>>>> NULL AFTER `sip_code`;
>>>> ALTER TABLE `acc_cdrs` ADD COLUMN `time` datetime DEFAULT NULL AFTER
>>>> `sip_reason`;
>>>> ```
>>>>
>>>> ```
>>>> route[IS_CALLER_BLACKLISTED] {
>>>>
>>>> python_exec("check_caller_blacklisted");
>>>>
>>>> if ($var(callerBlacklisted) == 1){
>>>>
>>>> t_send_reply("403", "Forbidden");
>>>>
>>>> acc_db_request("403 Forbidden", "acc_cdrs");
>>>>
>>>> exit;
>>>>
>>>> }
>>>>
>>>> ```
>>>>
>>>> In this way i have both stored calls that were not answered with 200ok
>>>> and that were answered with 200ok.
>>>> The idea is to have all in one table `acc_cdrs`.
>>>>
>>>> Can be ok also the second solution?
>>>>
>>>> Thank you very much!
>>>> Miro
>>>>
>>>> Il giorno ven 14 giu 2019 alle ore 09:06 Daniel-Constantin Mierla <
>>>> mico...@gmail.com> ha scritto:
>>>>
>>>>> Hello,
>>>>>
>>>>> I don't think that you can get a dialog-based CDR for calls that were
>>>>> not answered with 200ok. But you can get a record in acc table, by storing
>>>>> failed transaction record (see the mod params for acc and failed
>>>>> transaction flag or use acc_db_request()).
>>>>>
>>>>> Cheers,
>>>>> Daniel
>>>>> On 13.06.19 22:45, Pejic, Miroslav wrote:
>>>>>
>>>>> Hi :)
>>>>>
>>>>>
>>>>> I'm trying to save a failed call in the kamailio_router.acc_cdrs
>>>>> database
>>>>>
>>>>> after sending the 403 Forbidden by router, using the module acc, if is
>>>>> it possible?
>>>>>
>>>>>
>>>>> https://www.kamailio.org/docs/modules/5.2.x/modules/acc.html
>>>>>
>>>>>
>>>>> Something like this:
>>>>>
>>>>>
>>>>> route[IS_CALLER_BLACKLISTED] {
>>>>>
>>>>>
>>>>> python_exec("check_caller_blacklisted");
>>>>>
>>>>>
>>>>> if ($var(callerBlacklisted) == 1){
>>>>>
>>>>>
>>>>> t_send_reply("403", "Forbidden");
>>>>>
>>>>>
>>>>> IT’S POSSIBLE HERE SAVE A CALL ON KAMAILIO_ROUTER.ACC_CDRS?
>>>>>
>>>>>
>>>>>
>>>>> exit;
>>>>>
>>>>> }
>>>>>
>>>>>
>>>>> Thanks in advance!
>>>>>
>>>>> Miro
>>>>>
>>>>> _______________________________________________
>>>>> Kamailio (SER) - Users Mailing
>>>>> Listsr-users@lists.kamailio.orghttps://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>>>>>
>>>>> --
>>>>> Daniel-Constantin Mierla -- www.asipto.comwww.twitter.com/miconda --
>>>>> www.linkedin.com/in/miconda
>>>>>
>>>>> --
>>>> Daniel-Constantin Mierla -- www.asipto.comwww.twitter.com/miconda --
>>>> www.linkedin.com/in/miconda
>>>>
>>>> _______________________________________________
>>>> Kamailio (SER) - Users Mailing List
>>>> sr-users@lists.kamailio.org
>>>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>>>>
>>>
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
