Hi,
Please check sql.conf in freeradius. The event timestamp should be a
timeststamp not a datetime.
What do you have configured there? It should be like
FROM_UNIXTIME(%{Event-Timestamp}), \
--
Tijmen de Mes
AG Projects
On 03/24/2013 06:34 AM, Willian Mazzardo - SYSSVOIP wrote:
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 = "[email protected] <mailto:[email protected]>"
Calling-Station-Id = "sip:[email protected]
<mailto:sip%[email protected]>"
Called-Station-Id = "sip:[email protected]
<mailto:sip%[email protected]>"
Sip-Translated-Request-URI = "sip:[email protected]
<mailto:sip%[email protected]>"
Canonical-URI = "sip:[email protected]
<mailto:sip%[email protected]>"
User-Agent = "Linphone/3.5.2 (eXosip2/3.6.0)"
Contact = "<sip:[email protected]:5066
<http://sip:[email protected]: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 =
"[email protected] <mailto:[email protected]>"
[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
<http://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
<http://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 <http://www.syssvoip.com.br>
55 3537 2030
2013/3/23 Willian Mazzardo - SYSSVOIP <[email protected]
<mailto:[email protected]>>
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 <http://www.syssvoip.com.br>
55 3537 2030 <tel:55%203537%202030>
2013/3/23 Tijmen de Mes <[email protected]
<mailto:[email protected]>>
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
<[email protected] <mailto:[email protected]>> 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"
<[email protected] <mailto:[email protected]>> 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
<[email protected] <mailto:[email protected]>> het
volgende geschreven:
> On 23 March 2013 20:52, Laszlo <[email protected]
<mailto:[email protected]>> wrote:
>> +1 on this
>>
>
> We will do our best to contribute a patch..
>
> _______________________________________________
> Users mailing list
> [email protected] <mailto:[email protected]>
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected] <mailto:[email protected]>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected] <mailto:[email protected]>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected] <mailto:[email protected]>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
