<div dir="ltr">I think I have found the problem....<div><br></div><div style>see the log:</div><div style><br></div><div style><div>Going to the next request</div><div>Ready to process requests.</div><div>rad_recv: Accounting-Request packet from host 127.0.0.1 port 45662, id=207, length=327</div>
<div><span class="" style="white-space:pre"> </span>Acct-Status-Type = Failed</div><div><span class="" style="white-space:pre"> </span>Service-Type = Sip-Session</div><div><span class="" style="white-space:pre"> </span>Sip-Response-Code = 487</div>
<div><span class="" style="white-space:pre"> </span>Sip-Method = Invite</div><div><span class="" style="white-space:pre"> </span>Event-Timestamp = "Mar 24 2013 02:26:30 BRT"</div><div><span class="" style="white-space:pre"> </span>Sip-From-Tag = "2008462333"</div>
<div><span class="" style="white-space:pre"> </span>Sip-To-Tag = "as4a8dfb83"</div><div><span class="" style="white-space:pre"> </span>Acct-Session-Id = "411815482"</div><div><span class="" style="white-space:pre"> </span>User-Name = "<a href="mailto:559101999@187.53.208.109">559101999@187.53.208.109</a>"</div>
<div><span class="" style="white-space:pre"> </span>Calling-Station-Id = "<a href="mailto:sip%3A559101999@187.53.208.109">sip:559101999@187.53.208.109</a>"</div><div><span class="" style="white-space:pre"> </span>Called-Station-Id = "<a href="mailto:sip%3A05596412757@187.53.208.109">sip:05596412757@187.53.208.109</a>"</div>
<div><span class="" style="white-space:pre"> </span>Sip-Translated-Request-URI = "<a href="mailto:sip%3A555596412757@177.126.178.106">sip:555596412757@177.126.178.106</a>"</div><div><span class="" style="white-space:pre"> </span>Canonical-URI = "<a href="mailto:sip%3A555596412757@187.53.208.109">sip:555596412757@187.53.208.109</a>"</div>
<div><span class="" style="white-space:pre"> </span>User-Agent = "Linphone/3.5.2 (eXosip2/3.6.0)"</div><div><span class="" style="white-space:pre"> </span>Contact = "<<a href="http://sip:559101999@192.168.10.110:5066">sip:559101999@192.168.10.110:5066</a>>"</div>
<div><span class="" style="white-space:pre"> </span>NAS-Port = 5060</div><div><span class="" style="white-space:pre"> </span>Acct-Delay-Time = 0</div><div><span class="" style="white-space:pre"> </span>NAS-IP-Address = 127.0.0.1</div>
<div># Executing section preacct from file /etc/freeradius/radiusd.conf</div><div>+- entering group preacct {...}</div><div>++[preprocess] returns ok</div><div>[suffix] Looking up realm "187.53.208.109" for User-Name = "<a href="mailto:559101999@187.53.208.109">559101999@187.53.208.109</a>"</div>
<div>[suffix] No such realm "187.53.208.109"</div><div>++[suffix] returns noop</div><div>++[files] returns noop</div><div># Executing section accounting from file /etc/freeradius/radiusd.conf</div><div>+- entering group accounting {...}</div>
<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-20130324">127.0.0.1/detail-20130324</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-20130324">127.0.0.1/detail-20130324</a></div><div>[detail] <span class="" style="white-space:pre"> </span>expand: %t -> Sun Mar 24 02:26:50 2013</div>
<div>++[detail] returns ok</div><div>[sql] WARNING: Unknown module "Sip-Application-Type" in string expansion "%', '%{User-Agent}', '%{From-Header}' )"</div>
<div>[sql] <span class="" style="white-space:pre"> </span>expand: /var/log/freeradius/sqltrace-%Y%m%d.log -> /var/log/freeradius/sqltrace-20130324.log</div><div>rlm_sql (sql): Reserving sql socket id: 22</div><div>rlm_sql_mysql: MYSQL check_error: 1064 received</div>
<div>rlm_sql (sql): Couldn't insert SQL accounting FAILED record - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '24 2013 02:26:30 BRT), FROM_UNIXTIME(Mar 24 2013 02:26:30 BRT), ' at line 1</div>
<div>rlm_sql_mysql: MYSQL check_error: 1064 received</div><div>rlm_sql_mysql: Cannot store result</div><div>rlm_sql_mysql: MySQL error 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '24 2013 02:26:30 BRT), FROM_UNIXTIME(Mar 24 2013 02:26:30 BRT), ' at line 1'</div>
<div>rlm_sql (sql): Released sql socket id: 22</div><div>++[sql] returns fail</div><div>Finished request 2.</div><div>Cleaning up request 2 ID 207 with timestamp +29</div><div>Going to the next request</div><div>Ready to process requests.</div>
<div><br></div><div><br></div><div style>I think is a DATE/TIME problem ...</div><div style><br></div><div style>Am I right?</div><div style><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/23 Willian Mazzardo - SYSSVOIP <span dir="ltr"><<a href="mailto:willian@syssvoip.com.br" target="_blank">willian@syssvoip.com.br</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">Hi Tijmen... thanks for your help... I have installed, but in mysql, the table radacct.201303 is not creating automatically.<div><br></div><div>How can I debug this?</div></div><div class="gmail_extra">
<br clear="all"><div>Willian Mazzardo<br>Depto TI - SYSSVOIP<br><a href="http://www.syssvoip.com.br" target="_blank">www.syssvoip.com.br</a><br><a href="tel:55%203537%202030" value="+555535372030" target="_blank">55 3537 2030</a></div>
<div><div class="h5">
<br><br><div class="gmail_quote">2013/3/23 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">
<div style="word-wrap:break-word">Hi,<div><br></div><div>I believe you can find everything you need in the install guide:</div><div><a href="http://cdrtool.ag-projects.com/projects/cdrtool/wiki/Installation_Guide" target="_blank">http://cdrtool.ag-projects.com/projects/cdrtool/wiki/Installation_Guide</a></div>
<div><div><br></div><div>Best regards,</div><div><br></div><div>--</div><div>Tijmen de Mes</div><div>AG Projects</div></div><div><br><div><div>Op 24 mrt. 2013, om 02:38 heeft Willian Mazzardo - SYSSVOIP <<a href="mailto:willian@syssvoip.com.br" target="_blank">willian@syssvoip.com.br</a>> het volgende geschreven:</div>
<div><div><br><blockquote type="cite"><p dir="ltr">Hi... im sorry intruding this topic to talk about different, but, have anyone some tutorial to install cdrtool in debian with opensips?</p><p dir="ltr">Thanks</p>
<div class="gmail_quote">On Mar 23, 2013 10:31 PM, "Tijmen de Mes" <<a href="mailto:tijmen@ag-projects.com" target="_blank">tijmen@ag-projects.com</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi,<br>
<br>
We had a bug which sneaked in due to another change and this is already fixed in trunk and will be part of the new release.<br>
<br>
The patch is here:<br>
<a href="http://cdrtool.ag-projects.com/projects/cdrtool/repository/revisions/2421" target="_blank">http://cdrtool.ag-projects.com/projects/cdrtool/repository/revisions/2421</a><br>
<br>
Best regards,<br>
<br>
--<br>
Tijmen de Mes<br>
AG Projects<br>
<br>
Op 24 mrt. 2013, om 00:26 heeft dotnetdub <<a href="mailto:dotnetdub@gmail.com" target="_blank">dotnetdub@gmail.com</a>> het volgende geschreven:<br>
<br>
> On 23 March 2013 20:52, Laszlo <<a href="mailto:laszlo@voipfreak.net" target="_blank">laszlo@voipfreak.net</a>> wrote:<br>
>> +1 on this<br>
>><br>
><br>
> We will do our best to contribute a patch..<br>
><br>
> _______________________________________________<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-bin/mailman/listinfo/users</a><br>
<br>
<br>
_______________________________________________<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-bin/mailman/listinfo/users</a><br>
</blockquote></div>
_______________________________________________<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-bin/mailman/listinfo/users</a><br>
</blockquote></div></div></div><br></div></div><br>_______________________________________________<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-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br></div></div></div>
</blockquote></div><br></div>