[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.pejic(a)cloud.timenet.it&gt; 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.cabiddu(a)gmail.com&gt; 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_fa… >> >> 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 < >> miconda(a)gmail.com&gt; 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 < >>> miconda(a)gmail.com&gt; 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(a)lists.kamailio.org >>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >>> >>