Help error on media-dipsatcher and cdrtool

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Help error on media-dipsatcher and cdrtool

bay2x1
Anybody out there who can figure what is wrong with my configuration. Any information would be highly appreciated... thanx...


Feb 16 11:10:01 ws16 cdrtool[7363]: 58
Feb 16 11:10:01 ws16 cdrtool[7363]: Unlock opensips_radius:radacct
Feb 16 11:10:01 ws16 cdrtool[7364]: Checking user quotas for data source OpenSIPS Proxy/Registrar
Feb 16 11:10:01 ws16 cdrtool[7364]: Using database queries to block accounts
Feb 16 11:10:01 ws16 cdrtool[7364]: Normalize lock id 285 aquired for opensips_radius:radacct
Feb 16 11:10:01 ws16 cdrtool[7364]: Init quota of data source opensips_radius for all accounts
Feb 16 11:10:01 ws16 cdrtool[7364]: Database error: Invalid SQL: select UserName,#012        count(*) as calls,#012        sum(AcctSessionTime) as duration,#012        sum(Price) as cost,#012        sum(AcctInputOctets + AcctOutputOctets)/2 as traffic#012        from radacct#012        where AcctStartTime >= '2009-02-01 00:00'#012        and Normalized = '1'#012        #012        #012        group by UserName#012
Feb 16 11:10:01 ws16 cdrtool[7364]: 58
Feb 16 11:10:01 ws16 cdrtool[7364]: Unlock opensips_radius:radacct
Feb 16 11:10:02 ws16 media-dispatcher[3393]: [ManagementControlProtocol,38,127.0.0.1] Connection to Management interface client lost: Connection was closed cleanly.