<div dir="ltr">Ok .. changed and freeradius is UP.<div><br></div><div style>But, when I do some call, this is the trace:</div><div style><br></div><div style><div>[detail] <span class="" style="white-space:pre"> </span>expand: /var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d -> /var/log/freeradius/radacct/<a href="http://127.0.0.1/detail-20130325">127.0.0.1/detail-20130325</a></div>
<div>[detail] /var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to /var/log/freeradius/radacct/<a href="http://127.0.0.1/detail-20130325">127.0.0.1/detail-20130325</a></div><div>[detail] <span class="" style="white-space:pre"> </span>expand: %t -> Mon Mar 25 10:50:02 2013</div>
<div>++[detail] returns ok</div><div>[sql] <span class="" style="white-space:pre"> </span>expand: <span class="" style="white-space:pre"> </span> CALL update_radacct_record( 'radius', <span class="" style="white-space:pre"> </span>FROM_UNIXTIME(%{Event-Timestamp}), UNIX_TIMESTAMP('%S') - '%{Event-Timestamp}', '', '%{X-RTP-Stat}', <span class="" style="white-space:pre"> </span>'%{Acct-Session-Id}', '%{Sip-To-Tag}', '%{Sip-From-Tag}' ) -> <span class="" style="white-space:pre"> </span> CALL update_radacct_record( 'radius', <span class="" style="white-space:pre"> </span>FROM_UNIXTIME(), UNIX_TIMESTAMP('2013-03-25 10:50:02') - '', '', '', <span class="" style="white-space:pre"> </span>'<a href="http://280e1cb527443026017094174eee1d7c@187.53.208.106:5060">280e1cb527443026017094174eee1d7c@187.53.208.106:5060</a>', '9309094362166693758', 'as18ead01f' )</div>
<div>[sql] <span class="" style="white-space:pre"> </span>expand: /var/log/freeradius/sqltrace-%Y%m%d.log -> /var/log/freeradius/sqltrace-20130325.log</div><div>rlm_sql (sql): Reserving sql socket id: 13</div><div>rlm_sql_mysql: MYSQL check_error: 2006, returning SQL_DOWN</div>
<div>rlm_sql (sql): Attempting to connect rlm_sql_mysql #13</div><div>rlm_sql_mysql: Starting connect to MySQL server for #13</div><div>rlm_sql (sql): Connected new DB handle, #13</div><div>rlm_sql_mysql: MYSQL check_error: 1582 received</div>
<div>rlm_sql (sql): failed after re-connect</div><div>[sql] Couldn't update SQL accounting STOP record - Incorrect parameter count in the call to native function 'FROM_UNIXTIME'</div><div>rlm_sql_mysql: MYSQL check_error: 1582 received</div>
<div>rlm_sql_mysql: Cannot store result</div><div>rlm_sql_mysql: MySQL error 'Incorrect parameter count in the call to native function 'FROM_UNIXTIME''</div><div>rlm_sql (sql): Released sql socket id: 13</div>
<div>++[sql] returns fail</div><div><br></div></div></div><div class="gmail_extra"><br clear="all"><div>Willian Mazzardo<br>Depto TI - SYSSVOIP<br><a href="http://www.syssvoip.com.br">www.syssvoip.com.br</a><br>55 3537 2030</div>
<br><br><div class="gmail_quote">2013/3/25 Tijmen de Mes <span dir="ltr"><<a href="mailto:tijmen@ag-projects.com" target="_blank">tijmen@ag-projects.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi,<br>
<br>
Yes I noticed the sample provided by CDRTool is outdated. I will update it.<br>
<br>
It should be:<div class="im"><br>
<br>
### Attributes added by AG Projects ###<br>
ATTRIBUTE Source-IP 214 string<br>
ATTRIBUTE Source-Port 215 string<br>
ATTRIBUTE Canonical-URI 216 string<br>
ATTRIBUTE Delay-Time 217 string<br>
ATTRIBUTE Divert-Reason 219 string<br>
ATTRIBUTE X-RTP-Stat 220 string<br>
ATTRIBUTE From-Header 221 string<br>
ATTRIBUTE User-Agent 222 string<br>
ATTRIBUTE Contact 223 string<br>
ATTRIBUTE Event 224 string<br>
ATTRIBUTE Event-Timestamp 230 integer<br>
ATTRIBUTE SIP-Proxy-IP 231 string<br>
ATTRIBUTE ENUM-TLD 232 string<br></div>
ATTRIBUTE SIP-Application-Type 237 string<br>
<br>
So including the timestamp and Application type. Also event-timestamp should be integer.<div class="im"><br>
<br>
Best regards,<br>
<br>
-- <br>
Tijmen de Mes<br>
AG Projects<br>
<br>
<br></div><div class="im">
On 03/25/2013 02:43 PM, Willian Mazzardo - SYSSVOIP wrote:<br>
</div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">
Damn it!!<br>
<br>
#ATTRIBUTE Event-Timestamp 230 string<br>
<br>
Its commented !!<br>
<br>
I will try comment this out and make a test.<br>
<br>
<br>
<br>
<br>
Willian Mazzardo<br>
Depto TI - SYSSVOIP<br>
</div><a href="http://www.syssvoip.com.br" target="_blank">www.syssvoip.com.br</a> <<a href="http://www.syssvoip.com.br" target="_blank">http://www.syssvoip.com.br</a>><br>
<a href="tel:55%203537%202030" value="+555535372030" target="_blank">55 3537 2030</a><br>
<br>
<br>
2013/3/25 Tijmen de Mes <<a href="mailto:tijmen@ag-projects.com" target="_blank">tijmen@ag-projects.com</a> <mailto:<a href="mailto:tijmen@ag-projects.com" target="_blank">tijmen@ag-projects.com</a><u></u>>><div>
<div class="h5"><br>
<br>
Hi,<br>
<br>
Please check if the following is present in the OpenSIPS dictionary:<br>
<br>
### Attributes added by AG Projects ###<br>
ATTRIBUTE Source-IP 214 string<br>
ATTRIBUTE Source-Port 215 string<br>
ATTRIBUTE Canonical-URI 216 string<br>
ATTRIBUTE Delay-Time 217 string<br>
ATTRIBUTE Divert-Reason 219 string<br>
ATTRIBUTE X-RTP-Stat 220 string<br>
ATTRIBUTE From-Header 221 string<br>
ATTRIBUTE User-Agent 222 string<br>
ATTRIBUTE Contact 223 string<br>
ATTRIBUTE Event 224 string<br>
ATTRIBUTE Event-Timestamp 230 integer<br>
ATTRIBUTE SIP-Proxy-IP 231 string<br>
ATTRIBUTE ENUM-TLD 232 string<br>
<br>
<br>
Best regards,<br>
<br>
-- Tijmen de Mes<br>
AG Projects<br>
<br>
On 03/25/2013 02:26 PM, Willian Mazzardo - SYSSVOIP wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5">
Hi ..<br>
<br>
about date/time issue, what can I do to test? because the %S is<br>
"working" and give me the right duration time of a call.<br>
<br>
My freeradius is FreeRADIUS Version 2.1.10, for host<br>
x86_64-pc-linux-gnu, built on Jan 7 2013 at 17:11:42<br>
<br>
the dictionaries loaded are:<br>
<br>
$INCLUDE/usr/share/freeradius/<u></u>dictionary<br>
<br>
# OpenSER dictionary<br>
$INCLUDE /etc/freeradius/dictionary.<u></u>opensips<br>
<br>
# MediaProxy dictionary<br>
$INCLUDE /etc/freeradius/dictionary.<u></u>mediaproxy<br>
<br>
<br>
<br>
<br>
Willian Mazzardo<br>
Depto TI - SYSSVOIP<br></div></div>
<a href="http://www.syssvoip.com.br" target="_blank">www.syssvoip.com.br</a> <<a href="http://www.syssvoip.com.br" target="_blank">http://www.syssvoip.com.br</a>><br>
<a href="tel:55%203537%202030" value="+555535372030" target="_blank">55 3537 2030</a> <tel:55%203537%202030><br>
<br>
</blockquote></blockquote><div class="HOEnZb"><div class="h5">
<br>
______________________________<u></u>_________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-<u></u>bin/mailman/listinfo/users</a><br>
</div></div></blockquote></div><br></div>