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 <[email protected]> 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 < > [email protected]> 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 >> [email protected]https://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 > [email protected] > https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >
_______________________________________________ Kamailio (SER) - Users Mailing List [email protected] https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
