<div dir="ltr">Hi,<div>dialog CDR for failed calls can be generated enabling </div><div><a href="http://www.kamailio.org/docs/modules/devel/modules/acc.html#acc.p.cdr_on_failed">http://www.kamailio.org/docs/modules/devel/modules/acc.html#acc.p.cdr_on_failed</a><br></div><div><br></div><div>It has been some time since I last tested it, but it still should work :)</div><div><br></div><div>Cheers,</div><div><br></div><div>Federico</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Jun 14, 2019 at 3:25 PM Daniel-Constantin Mierla <<a href="mailto:miconda@gmail.com">miconda@gmail.com</a>> wrote:<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>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="gmail-m_-4127153951522883556moz-cite-prefix">On 14.06.19 14:16, Pejic, Miroslav
wrote:<br>
</div>
<blockquote type="cite">
<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" target="_blank">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_-4127153951522883556gmail-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">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_-4127153951522883556gmail-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_-4127153951522883556gmail-m_-1623064218268261766mimeAttachmentHeader"></fieldset>
<pre class="gmail-m_-4127153951522883556gmail-m_-1623064218268261766moz-quote-pre">_______________________________________________
Kamailio (SER) - Users Mailing List
<a class="gmail-m_-4127153951522883556gmail-m_-1623064218268261766moz-txt-link-abbreviated" href="mailto:sr-users@lists.kamailio.org" target="_blank">sr-users@lists.kamailio.org</a>
<a class="gmail-m_-4127153951522883556gmail-m_-1623064218268261766moz-txt-link-freetext" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<pre class="gmail-m_-4127153951522883556gmail-m_-1623064218268261766moz-signature" cols="72">--
Daniel-Constantin Mierla -- <a class="gmail-m_-4127153951522883556gmail-m_-1623064218268261766moz-txt-link-abbreviated" href="http://www.asipto.com" target="_blank">www.asipto.com</a>
<a class="gmail-m_-4127153951522883556gmail-m_-1623064218268261766moz-txt-link-abbreviated" href="http://www.twitter.com/miconda" target="_blank">www.twitter.com/miconda</a> -- <a class="gmail-m_-4127153951522883556gmail-m_-1623064218268261766moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda" target="_blank">www.linkedin.com/in/miconda</a></pre>
</div>
</blockquote>
</div>
</blockquote>
<pre class="gmail-m_-4127153951522883556moz-signature" cols="72">--
Daniel-Constantin Mierla -- <a class="gmail-m_-4127153951522883556moz-txt-link-abbreviated" href="http://www.asipto.com" target="_blank">www.asipto.com</a>
<a class="gmail-m_-4127153951522883556moz-txt-link-abbreviated" href="http://www.twitter.com/miconda" target="_blank">www.twitter.com/miconda</a> -- <a class="gmail-m_-4127153951522883556moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda" target="_blank">www.linkedin.com/in/miconda</a></pre>
</div>
_______________________________________________<br>
Kamailio (SER) - Users Mailing List<br>
<a href="mailto:sr-users@lists.kamailio.org" target="_blank">sr-users@lists.kamailio.org</a><br>
<a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><br>
</blockquote></div>