[SR-Users] 403 Forbidden

[David Villasmil]

Try doing the acc_db_request before doing the t_reply

On Fri, 14 Jun 2019 at 11:01, Pejic, Miroslav <
miroslav.pejic at cloud.timenet.it> wrote:

> 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 at 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 <
>> miconda at 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 <
>>> miconda at 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 at 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 at lists.kamailio.org
>>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>>>
>> _______________________________________________
> Kamailio (SER) - Users Mailing List
> sr-users at lists.kamailio.org
> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>
-- 
Regards,

David Villasmil
email: david.villasmil.work at gmail.com
phone: +34669448337
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20190614/066ac2fa/attachment.html>