<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}
@font-face
{font-family:"Times New Roman \, serif";}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
pre
{mso-style-priority:99;
mso-style-link:"Preformattato HTML Carattere";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Testo fumetto Carattere";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";
color:black;}
span.PreformattatoHTMLCarattere
{mso-style-name:"Preformattato HTML Carattere";
mso-style-priority:99;
mso-style-link:"Preformattato HTML";
font-family:Consolas;
color:black;}
span.StileMessaggioDiPostaElettronica20
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.StileMessaggioDiPostaElettronica21
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#44546A;}
span.StileMessaggioDiPostaElettronica22
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#44546A;}
span.TestofumettoCarattere
{mso-style-name:"Testo fumetto Carattere";
mso-style-priority:99;
mso-style-link:"Testo fumetto";
font-family:"Tahoma","sans-serif";
color:black;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 2.0cm 2.0cm 2.0cm;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body bgcolor=white lang=IT link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal><span style='color:#44546A'>Hi, these are all the param fora cc module:<o:p></o:p></span></p><p class=MsoNormal><span style='color:#44546A'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#44546A'>modparam("acc", "db_flag", FLAG_ACC_CALL)<o:p></o:p></span></p><p class=MsoNormal><span style='color:#44546A'>modparam("acc", "db_missed_flag", FLAG_ACC_MISSED_CALL)<o:p></o:p></span></p><p class=MsoNormal><span style='color:#44546A'>modparam("acc", "failed_transaction_flag", FLAG_ACC_FAILED_CALL)<o:p></o:p></span></p><p class=MsoNormal><span style='color:#44546A'>modparam("acc", "db_table_acc", "acc")<o:p></o:p></span></p><p class=MsoNormal><span style='color:#44546A'>modparam("acc", "db_table_missed_calls", "missed_calls")<o:p></o:p></span></p><p class=MsoNormal><span style='color:#44546A'>modparam("acc", "db_extra", "src_user=$fU;src_ip=$si;src_domain=$fd;src_port=$sp;dst_user=$rU;dst_domain=$rd;<o:p></o:p></span></p><p class=MsoNormal><span style='color:#44546A'> invite_time=$dlg_var(invite_time);c_time=$dlg_var(c_time);hangup_time=$avp(s:hangup);<o:p></o:p></span></p><p class=MsoNormal><span style='color:#44546A'> duration=$dlg_var(duration);uniqueid=$dlg_var(uniqueid);a_id_operator=$dlg_var(a_id_operator);b_id_operator=$dlg_var(b_id_operator);<o:p></o:p></span></p><p class=MsoNormal><span style='color:#44546A'> alert_time=$dlg_var(alert_time);progress_time=$dlg_var(progress_time);techprefix_len=$dlg_var(lenprefix);<o:p></o:p></span></p><p class=MsoNormal><span style='color:#44546A'> parameters=$avp(s:parameters)")<o:p></o:p></span></p><p class=MsoNormal><span style='color:#44546A'>modparam("acc", "detect_direction", 1) <o:p></o:p></span></p><p class=MsoNormal><span style='color:#44546A'>modparam("acc", "report_cancels", 1)<o:p></o:p></span></p><p class=MsoNormal><span style='color:#44546A'>modparam("acc", "early_media", 0)<o:p></o:p></span></p><p class=MsoNormal><span style='color:#44546A'>modparam("acc", "time_mode", 2)<o:p></o:p></span></p><p class=MsoNormal><span style='color:#44546A'>modparam("acc", "time_attr", "seconds")<o:p></o:p></span></p><p class=MsoNormal><span style='color:#44546A'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#44546A'>Thanks<o:p></o:p></span></p><p class=MsoNormal><span style='color:#44546A'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Segoe UI","sans-serif";color:windowtext'>Da:</span></b><span style='font-size:10.0pt;font-family:"Segoe UI","sans-serif";color:windowtext'> Daniel-Constantin Mierla [mailto:miconda@gmail.com] <br><b>Inviato:</b> mercoledì 22 giugno 2016 19:28<br><b>A:</b> pars3c; 'Kamailio (SER) - Users Mailing List'<br><b>Oggetto:</b> Re: R: [SR-Users] acc time mode 2 wrong timestamp<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p>Hello,<o:p></o:p></p><p>what are the parameters you set for acc module? Paste all modparams for acc here.<o:p></o:p></p><p>Cheers,<br>Daniel<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>On 22/06/16 10:31, pars3c wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal><span style='color:#44546A'>Hi Daniel,</span><o:p></o:p></p><p class=MsoNormal><span style='color:#44546A'>thanks for your support, each instance has your own database.In each table the coloumn is double. </span><o:p></o:p></p><p class=MsoNormal><span style='color:#44546A'>I tried to enable the log , in debug level , but i havent found any accounting record, only this type:</span><o:p></o:p></p><p class=MsoNormal><span style='color:#44546A'> </span><o:p></o:p></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt;font-family:Consolas;color:windowtext'>DEBUG: acc [acc_logic.c:644]: tmcb_func(): acc callback called for t(0x979e5af8) event type 2, reply code 200 </span><o:p></o:p></p><p class=MsoNormal><span style='color:#44546A'>May be , i don’t know where to find it.</span><o:p></o:p></p><p class=MsoNormal><span style='color:#44546A'> </span><o:p></o:p></p><p class=MsoNormal><span style='color:#44546A'>The server where i ‘ve this problem use Centos5.4 386</span><o:p></o:p></p><p class=MsoNormal><span style='color:#44546A'> </span><o:p></o:p></p><p class=MsoNormal><span style='color:#44546A'>Thanks</span><o:p></o:p></p><p class=MsoNormal><span style='color:#44546A'> </span><o:p></o:p></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span style='font-size:10.0pt'>Da:</span></b><span style='font-size:10.0pt'> sr-users [<a href="mailto:sr-users-bounces@lists.sip-router.org">mailto:sr-users-bounces@lists.sip-router.org</a>] <b>Per conto di </b>Daniel-Constantin Mierla<br><b>Inviato:</b> mercoledì 22 giugno 2016 07:27<br><b>A:</b> Kamailio (SER) - Users Mailing List<br><b>Oggetto:</b> Re: [SR-Users] acc time mode 2 wrong timestamp</span><o:p></o:p></p></div></div><p class=MsoNormal> <o:p></o:p></p><p>Hello,<o:p></o:p></p><p>is the same database server used for both kamailio instances or each kamailio instance has its own kamailio server?<o:p></o:p></p><p>Can you enable logging to syslog the accounting record and see if the values are likes in the database? I am trying to isolate if the issue is in code or somehow in the database column type.<o:p></o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'>Cheers,<br>Daniel<o:p></o:p></p><div><p class=MsoNormal>On 21/06/16 10:19, pars3c wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal>Hello,<o:p></o:p></p><p class=MsoNormal>i’ve installled the new version of kamailio 4.4.1 . in 2 different server , with acc module and these parameters:<o:p></o:p></p><p class=MsoNormal>modparam("acc", "time_mode", 2)<o:p></o:p></p><p class=MsoNormal>modparam("acc", "time_attr", "seconds") should be seconds.millisec<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal>On the first server in acc table , in field seconds i have values like this 1466493457.85, this is correct timestamp ( this server have centos 86_64)<o:p></o:p></p><p class=MsoNormal>In the other server , i have values like 1913113.702 , that is wrong timestamp . (this is old centos 32 bit )<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal>What can be the problem? The different version 32,64 bit ? or some compiler option ?<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal>Thanks<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman , serif","serif"'><br><br><br><br></span><o:p></o:p></p><pre>_______________________________________________<o:p></o:p></pre><pre>SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<o:p></o:p></pre><pre><a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><o:p></o:p></pre><pre><a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><o:p></o:p></pre></blockquote><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman , serif","serif"'><br><br><br></span><o:p></o:p></p><pre>-- <o:p></o:p></pre><pre>Daniel-Constantin Mierla<o:p></o:p></pre><pre><a href="http://www.asipto.com">http://www.asipto.com</a> - <a href="http://www.kamailio.org">http://www.kamailio.org</a><o:p></o:p></pre><pre><a href="http://twitter.com/#%21/miconda">http://twitter.com/#!/miconda</a> - <a href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a><o:p></o:p></pre></blockquote><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><br><br><o:p></o:p></span></p><pre>-- <o:p></o:p></pre><pre>Daniel-Constantin Mierla<o:p></o:p></pre><pre><a href="http://www.asipto.com">http://www.asipto.com</a> - <a href="http://www.kamailio.org">http://www.kamailio.org</a><o:p></o:p></pre><pre><a href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a><o:p></o:p></pre></div></body></html>