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]" Calling-Station-Id = "sip:[email protected]" Called-Station-Id = "sip:[email protected]" Sip-Translated-Request-URI = "sip:[email protected]" Canonical-URI = "sip:[email protected]" User-Agent = "Linphone/3.5.2 (eXosip2/3.6.0)" Contact = "<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]" [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 <[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 > 55 3537 2030 > > > 2013/3/23 Tijmen de Mes <[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]> 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]> 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]> het >>> volgende geschreven: >>> >>> > On 23 March 2013 20:52, Laszlo <[email protected]> wrote: >>> >> +1 on this >>> >> >>> > >>> > We will do our best to contribute a patch.. >>> > >>> > _______________________________________________ >>> > 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 >>> >> _______________________________________________ >> 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 >> >> >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
