[SR-Users] 403 Forbidden

[Pejic, Miroslav]

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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20190614/c94d740e/attachment.html>