<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hello,</p>
<p>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.</p>
<p>Cheers,<br>
Daniel<br>
</p>
<div class="moz-cite-prefix">On 14.06.19 14:16, Pejic, Miroslav
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAGXmshk2RF6DrPss8ZLgvE7ddPNgHnzkzMqKvpBm8XHpx08hPA@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">Hi Daniel :)<br>
<br>
i tryied 2 methods to save it<br>
<br>
1) i created a new table on kamailio_router called `acc`<br>
<br>
from `utils/kamctl/mysql/acc-create.sql`<br>
<br>
```<br>
CREATE TABLE `acc` (<br>
`id` INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,<br>
`method` VARCHAR(16) DEFAULT '' NOT NULL,<br>
`from_tag` VARCHAR(128) DEFAULT '' NOT NULL,<br>
`to_tag` VARCHAR(128) DEFAULT '' NOT NULL,<br>
`callid` VARCHAR(255) DEFAULT '' NOT NULL,<br>
`sip_code` VARCHAR(3) DEFAULT '' NOT NULL,<br>
`sip_reason` VARCHAR(128) DEFAULT '' NOT NULL,<br>
`time` DATETIME NOT NULL<br>
);<br>
CREATE INDEX callid_idx ON acc (`callid`);<br>
```<br>
then <br>
<br>
```<br>
route[IS_CALLER_BLACKLISTED] {<br>
<br>
python_exec("check_caller_blacklisted");<br>
<br>
if ($var(callerBlacklisted) == 1){<br>
<br>
t_send_reply("403", "Forbidden");<br>
<br>
acc_db_request("403 Forbidden", "acc");<br>
<br>
exit;<br>
<br>
}<br>
<br>
```<br>
<br>
in `acc` i have now calls that were not answered with 200ok :)<br>
<br>
<br>
2) add new fields on exsisting acc_cdrs table used to store cdrs
<br>
<br>
```<br>
ALTER TABLE `acc_cdrs` ADD COLUMN `from_tag` varchar(128)
DEFAULT NULL AFTER `dst_domain`;<br>
ALTER TABLE `acc_cdrs` ADD COLUMN `to_tag` VARCHAR(128) DEFAULT
NULL AFTER `from_tag`;<br>
ALTER TABLE `acc_cdrs` ADD COLUMN `sip_code` VARCHAR(3) DEFAULT
NULL AFTER `to_tag`;<br>
ALTER TABLE `acc_cdrs` ADD COLUMN `sip_reason` varchar(128)
DEFAULT NULL AFTER `sip_code`;<br>
ALTER TABLE `acc_cdrs` ADD COLUMN `time` datetime DEFAULT NULL
AFTER `sip_reason`;<br>
```<br>
<br>
```<br>
route[IS_CALLER_BLACKLISTED] {
<div><br>
python_exec("check_caller_blacklisted");</div>
<div><br>
if ($var(callerBlacklisted) == 1){<br>
<br>
t_send_reply("403", "Forbidden");<br>
<br>
acc_db_request("403 Forbidden", "acc_cdrs");<br>
<br>
exit;<br>
<br>
}<br>
<br>
```<br>
<br>
In this way i have both stored calls that were not answered
with 200ok and that were answered with 200ok.<br>
The idea is to have all in one table `acc_cdrs`.<br>
<br>
Can be ok also the second solution?<br>
<br>
Thank you very much!<br>
Miro<br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">Il giorno ven 14 giu 2019 alle
ore 09:06 Daniel-Constantin Mierla <<a
href="mailto:miconda@gmail.com" moz-do-not-send="true">miconda@gmail.com</a>>
ha scritto:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div bgcolor="#FFFFFF">
<p>Hello,</p>
<p>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()).</p>
<p>Cheers,<br>
Daniel<br>
</p>
<div class="gmail-m_-1623064218268261766moz-cite-prefix">On
13.06.19 22:45, Pejic, Miroslav wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<p
style="margin:0px;font-stretch:normal;font-size:12px;line-height:normal;font-family:Courier;color:rgb(18,31,60);background-color:rgb(241,242,245)"><span>Hi
:)</span></p>
<p
style="margin:0px;font-stretch:normal;font-size:12px;line-height:normal;font-family:Courier;color:rgb(18,31,60);background-color:rgb(241,242,245);min-height:14px"><span></span><br>
</p>
<p
style="margin:0px;font-stretch:normal;font-size:12px;line-height:normal;font-family:Courier;color:rgb(18,31,60);background-color:rgb(241,242,245)"><span>I'm
trying to save a failed call in the
kamailio_router.acc_cdrs database </span></p>
<p
style="margin:0px;font-stretch:normal;font-size:12px;line-height:normal;font-family:Courier;color:rgb(18,31,60);background-color:rgb(241,242,245)"><span>after
sending the 403 Forbidden by router, using the
module acc, if is it possible?</span></p>
<p
style="margin:0px;font-stretch:normal;font-size:12px;line-height:normal;font-family:Courier;color:rgb(18,31,60);background-color:rgb(241,242,245)"><span><br>
</span></p>
<p
style="margin:0px;font-stretch:normal;font-size:12px;line-height:normal;font-family:Courier;color:rgb(18,31,60);background-color:rgb(241,242,245)"><span><a
href="https://www.kamailio.org/docs/modules/5.2.x/modules/acc.html"
target="_blank" moz-do-not-send="true">https://www.kamailio.org/docs/modules/5.2.x/modules/acc.html</a></span></p>
<p
style="margin:0px;font-stretch:normal;font-size:12px;line-height:normal;font-family:Courier;color:rgb(18,31,60);background-color:rgb(241,242,245);min-height:14px"><span></span><br>
</p>
<p
style="margin:0px;font-stretch:normal;font-size:12px;line-height:normal;font-family:Courier;color:rgb(18,31,60);background-color:rgb(241,242,245)"><span>Something
like this:</span></p>
<p
style="margin:0px;font-stretch:normal;font-size:12px;line-height:normal;font-family:Courier;color:rgb(18,31,60);background-color:rgb(241,242,245);min-height:14px"><span></span><br>
</p>
<p
style="margin:0px;font-stretch:normal;font-size:12px;line-height:normal;font-family:Courier;color:rgb(18,31,60);background-color:rgb(241,242,245)"><span>route[IS_CALLER_BLACKLISTED]
{</span></p>
<p
style="margin:0px;font-stretch:normal;font-size:12px;line-height:normal;font-family:Courier;color:rgb(18,31,60);background-color:rgb(241,242,245);min-height:14px"><span></span><br>
</p>
<p
style="margin:0px;font-stretch:normal;font-size:12px;line-height:normal;font-family:Courier;color:rgb(18,31,60);background-color:rgb(241,242,245)"><span>
python_exec("check_caller_blacklisted");</span></p>
<p
style="margin:0px;font-stretch:normal;font-size:12px;line-height:normal;font-family:Courier;color:rgb(18,31,60);background-color:rgb(241,242,245);min-height:14px"><span></span><br>
</p>
<p
style="margin:0px;font-stretch:normal;font-size:12px;line-height:normal;font-family:Courier;color:rgb(18,31,60);background-color:rgb(241,242,245)"><span>
if ($var(callerBlacklisted) == 1){</span></p>
<p
style="margin:0px;font-stretch:normal;font-size:12px;line-height:normal;font-family:Courier;color:rgb(18,31,60);background-color:rgb(241,242,245);min-height:14px"><span></span><br>
</p>
<p
style="margin:0px;font-stretch:normal;font-size:12px;line-height:normal;font-family:Courier;color:rgb(18,31,60);background-color:rgb(241,242,245)"><span>
t_send_reply("403", "Forbidden");</span></p>
<p
style="margin:0px;font-stretch:normal;font-size:12px;line-height:normal;font-family:Courier;color:rgb(18,31,60);background-color:rgb(241,242,245);min-height:14px"><span></span><br>
</p>
<p
style="margin:0px;font-stretch:normal;font-size:12px;line-height:normal;font-family:Courier;color:rgb(18,31,60);background-color:rgb(241,242,245)"><span><span style="white-space:pre-wrap"> </span>IT’S
POSSIBLE HERE SAVE A CALL ON
KAMAILIO_ROUTER.ACC_CDRS?</span></p>
<p
style="margin:0px;font-stretch:normal;font-size:12px;line-height:normal;font-family:Courier;color:rgb(18,31,60);background-color:rgb(241,242,245);min-height:14px"><span><span class="gmail-m_-1623064218268261766gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>
</span></p>
<p
style="margin:0px;font-stretch:normal;font-size:12px;line-height:normal;font-family:Courier;color:rgb(18,31,60);background-color:rgb(241,242,245)"><span><span style="white-space:pre-wrap"> </span>exit;</span></p>
<p
style="margin:0px;font-stretch:normal;font-size:12px;line-height:normal;font-family:Courier;color:rgb(18,31,60);background-color:rgb(241,242,245)"><span>
}</span></p>
<p
style="margin:0px;font-stretch:normal;font-size:12px;line-height:normal;font-family:Courier;color:rgb(18,31,60);background-color:rgb(241,242,245);min-height:14px"><span></span><br>
</p>
<p
style="margin:0px;font-stretch:normal;font-size:12px;line-height:normal;font-family:Courier;color:rgb(18,31,60);background-color:rgb(241,242,245)"><span>Thanks
in advance!</span></p>
<p
style="margin:0px;font-stretch:normal;font-size:12px;line-height:normal;font-family:Courier;color:rgb(18,31,60);background-color:rgb(241,242,245)"><span>Miro</span></p>
</div>
</div>
</div>
<br>
<fieldset
class="gmail-m_-1623064218268261766mimeAttachmentHeader"></fieldset>
<pre class="gmail-m_-1623064218268261766moz-quote-pre">_______________________________________________
Kamailio (SER) - Users Mailing List
<a class="gmail-m_-1623064218268261766moz-txt-link-abbreviated" href="mailto:sr-users@lists.kamailio.org" target="_blank" moz-do-not-send="true">sr-users@lists.kamailio.org</a>
<a class="gmail-m_-1623064218268261766moz-txt-link-freetext" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" target="_blank" moz-do-not-send="true">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<pre class="gmail-m_-1623064218268261766moz-signature" cols="72">--
Daniel-Constantin Mierla -- <a class="gmail-m_-1623064218268261766moz-txt-link-abbreviated" href="http://www.asipto.com" target="_blank" moz-do-not-send="true">www.asipto.com</a>
<a class="gmail-m_-1623064218268261766moz-txt-link-abbreviated" href="http://www.twitter.com/miconda" target="_blank" moz-do-not-send="true">www.twitter.com/miconda</a> -- <a class="gmail-m_-1623064218268261766moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda" target="_blank" moz-do-not-send="true">www.linkedin.com/in/miconda</a></pre>
</div>
</blockquote>
</div>
</blockquote>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla -- <a class="moz-txt-link-abbreviated" href="http://www.asipto.com">www.asipto.com</a>
<a class="moz-txt-link-abbreviated" href="http://www.twitter.com/miconda">www.twitter.com/miconda</a> -- <a class="moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda">www.linkedin.com/in/miconda</a></pre>
</body>
</html>