<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hello,<br>
<br>
iirc, Kamailio does only insert operations, therefore if you tested
and works, then should be no problem, because there is no select to
retrieve the values back in kamailio.<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<div class="moz-cite-prefix">On 21/07/15 00:07, mayamatakeshi wrote:<br>
</div>
<blockquote
cite="mid:CABaNFCYkaAyT1_xziW7xKqgOX=3sEtcUqWcRhTyyX2Vcewf+zg@mail.gmail.com"
type="cite">
<div dir="ltr"><br>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Tue, Jul 21, 2015 at 6:35 AM,
mayamatakeshi <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:mayamatakeshi@gmail.com" target="_blank">mayamatakeshi@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div dir="ltr">
<div>Hello, </div>
<div>I am planning to enable acc cdr in my kamailio 4.1
server.</div>
<div>I am testing in my lab and it is working fine.</div>
<div>However, when I check the table definition I see
this:</div>
<div><br>
</div>
<div>
<div>mysql> describe acc_cdrs;</div>
<div>+------------+------------------+------+-----+---------+----------------+</div>
<div>| Field | Type | Null | Key |
Default | Extra |</div>
<div>+------------+------------------+------+-----+---------+----------------+</div>
<div>| id | int(10) unsigned | NO | PRI |
NULL | auto_increment |</div>
<div>| start_time | varchar(32) | NO | MUL |
| |</div>
<div>| end_time | varchar(32) | NO | |
| |</div>
<div>| duration | varchar(32) | NO | |
| |</div>
<div>+------------+------------------+------+-----+---------+----------------+</div>
<div>4 rows in set (0.00 sec)</div>
<div><br>
</div>
<div><br>
</div>
<div>The *_time and duration columns are defined as
varchar.</div>
</div>
<div>Because of this, i need to perform a cast when
doing queries:</div>
<div> select * from acc_cdrs where cast(start_time as
unsigned) >= 1437120622;</div>
<div>which would cause extra processing in the db
server.</div>
<div><br>
</div>
<div>So I experimented changing these columns to "int
unsigned" and to "float unsigned" and it worked for
both without problems (records properly added to
acc_cdrs and no errors in kamailio.log):</div>
<div><br>
</div>
<div>
<div>alter table acc_cdrs modify start_time int
unsigned;</div>
<div>alter table acc_cdrs modify end_time int
unsigned;</div>
<div>alter table acc_cdrs modify duration int
unsigned;</div>
<div><br>
</div>
<div>alter table acc_cdrs modify start_time float
unsigned;</div>
<div>alter table acc_cdrs modify end_time float
unsigned;</div>
<div>alter table acc_cdrs modify duration float
unsigned;</div>
</div>
</div>
</blockquote>
<div><br>
</div>
<div>Actually, checking again, they should not be a "float
unsigned" but "double unsigned":</div>
<div><br>
</div>
<div>
<div>alter table acc_cdrs modify start_time double
unsigned;</div>
<div>alter table acc_cdrs modify end_time double unsigned;</div>
<div>alter table acc_cdrs modify duration double unsigned;</div>
</div>
<div><br>
</div>
<div> </div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div dir="ltr">
<div><br>
</div>
<div>So I am thinking in doing this in my production
server but I would like to know if there is any
potential risk of doing this (as I am not sure why it
was decided for these fields to be varchar instead of
a numeric type).<br>
</div>
<div><br>
</div>
<div>Regards,</div>
<div>Takeshi</div>
</div>
</blockquote>
</div>
<br>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a>
Book: SIP Routing With Kamailio - <a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a></pre>
</body>
</html>