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>
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> 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