[OpenSIPS-Users] CDRTool 9.1.1

Sun Mar 24 06:34:57 CET 2013

I think I have found the problem....

see the log:

Going to the next request
Ready to process requests.
rad_recv: Accounting-Request packet from host 127.0.0.1 port 45662, id=207,
length=327
 Acct-Status-Type = Failed
Service-Type = Sip-Session
Sip-Response-Code = 487
 Sip-Method = Invite
Event-Timestamp = "Mar 24 2013 02:26:30 BRT"
Sip-From-Tag = "2008462333"
 Sip-To-Tag = "as4a8dfb83"
Acct-Session-Id = "411815482"
User-Name = "559101999 at 187.53.208.109"
 Calling-Station-Id = "sip:559101999 at 187.53.208.109"
Called-Station-Id = "sip:05596412757 at 187.53.208.109"
 Sip-Translated-Request-URI = "sip:555596412757 at 177.126.178.106"
Canonical-URI = "sip:555596412757 at 187.53.208.109"
 User-Agent = "Linphone/3.5.2 (eXosip2/3.6.0)"
Contact = "<sip:559101999 at 192.168.10.110:5066>"
 NAS-Port = 5060
Acct-Delay-Time = 0
NAS-IP-Address = 127.0.0.1
# Executing section preacct from file /etc/freeradius/radiusd.conf
+- entering group preacct {...}
++[preprocess] returns ok
[suffix] Looking up realm "187.53.208.109" for User-Name = "
559101999 at 187.53.208.109"
[suffix] No such realm "187.53.208.109"
++[suffix] returns noop
++[files] returns noop
# Executing section accounting from file /etc/freeradius/radiusd.conf
+- entering group accounting {...}
[detail] expand:
/var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d ->
/var/log/freeradius/radacct/127.0.0.1/detail-20130324
[detail] /var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d
expands to /var/log/freeradius/radacct/127.0.0.1/detail-20130324
[detail] expand: %t -> Sun Mar 24 02:26:50 2013
++[detail] returns ok
[sql] WARNING: Unknown module "Sip-Application-Type" in string expansion
"%',                 '%{User-Agent}',                 '%{From-Header}'
            )"
[sql] expand: /var/log/freeradius/sqltrace-%Y%m%d.log ->
/var/log/freeradius/sqltrace-20130324.log
rlm_sql (sql): Reserving sql socket id: 22
rlm_sql_mysql: MYSQL check_error: 1064 received
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
rlm_sql_mysql: MYSQL check_error: 1064 received
rlm_sql_mysql: Cannot store result
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'
rlm_sql (sql): Released sql socket id: 22
++[sql] returns fail
Finished request 2.
Cleaning up request 2 ID 207 with timestamp +29
Going to the next request
Ready to process requests.

I think is a DATE/TIME problem ...

Am I right?

Willian Mazzardo
Depto TI - SYSSVOIP
www.syssvoip.com.br
55 3537 2030

2013/3/23 Willian Mazzardo - SYSSVOIP <willian at syssvoip.com.br>

> Hi Tijmen... thanks for your help... I have installed, but in mysql, the
> table radacct.201303 is not creating automatically.
>
> How can I debug this?
>
> Willian Mazzardo
> Depto TI - SYSSVOIP
> www.syssvoip.com.br
> 55 3537 2030
>
>
> 2013/3/23 Tijmen de Mes <tijmen at ag-projects.com>
>
>> Hi,
>>
>> I believe you can find everything you need in the install guide:
>> http://cdrtool.ag-projects.com/projects/cdrtool/wiki/Installation_Guide
>>
>> Best regards,
>>
>> --
>> Tijmen de Mes
>> AG Projects
>>
>> Op 24 mrt. 2013, om 02:38 heeft Willian Mazzardo - SYSSVOIP <
>> willian at syssvoip.com.br> het volgende geschreven:
>>
>> Hi... im sorry intruding this topic to talk about different, but, have
>> anyone some tutorial to install cdrtool in debian with opensips?
>>
>> Thanks
>> On Mar 23, 2013 10:31 PM, "Tijmen de Mes" <tijmen at ag-projects.com> wrote:
>>
>>> Hi,
>>>
>>> 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.
>>>
>>> The patch is here:
>>> http://cdrtool.ag-projects.com/projects/cdrtool/repository/revisions/2421
>>>
>>> Best regards,
>>>
>>> --
>>> Tijmen de Mes
>>> AG Projects
>>>
>>> Op 24 mrt. 2013, om 00:26 heeft dotnetdub <dotnetdub at gmail.com> het
>>> volgende geschreven:
>>>
>>> > On 23 March 2013 20:52, Laszlo <laszlo at voipfreak.net> wrote:
>>> >> +1 on this
>>> >>
>>> >
>>> > We will do our best to contribute a patch..
>>> >
>>> > _______________________________________________
>>> > Users mailing list
>>> > Users at lists.opensips.org
>>> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>
>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users at lists.opensips.org
>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20130324/229eb5fb/attachment.htm>