Help errors on opensips 1.4.4

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

Help errors on opensips 1.4.4

bay2x1
I have have manage to install opensips and including cdrtool, freeradius, and mediaproxy.  I am encountering problems.  Below is the error log. any information would be highly appreciated... thanx...


Feb 17 08:40:02 ws16 cdrtool[4048]: Checking user quotas for data source OpenSIPS Proxy/Registrar
Feb 17 08:40:02 ws16 cdrtool[4048]: Using database queries to block accounts
Feb 17 08:40:02 ws16 cdrtool[4048]: Normalize lock id 88 aquired for opensips_radius:radacct
Feb 17 08:40:02 ws16 cdrtool[4048]: Init quota of data source opensips_radius for all accounts
Feb 17 08:40:02 ws16 cdrtool[4048]: 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 17 08:40:02 ws16 cdrtool[4048]: 58
Feb 17 08:40:02 ws16 cdrtool[4048]: Unlock opensips_radius:radacct
Feb 17 08:40:02 ws16 cdrtool[4050]: Normalize datasource opensips_radius, database DB_radius, table radacct
Feb 17 08:40:02 ws16 cdrtool[4050]: Normalize lock id 90 aquired for opensips_radius:radacct
Feb 17 08:40:02 ws16 cdrtool[4050]: Database error: Invalid SQL: select *, UNIX_TIMESTAMP(AcctStartTime) as timestamp#012        from radacct where  (1=1)  and  Normalized = '0' and AcctStopTime != '0000-00-00 00:00:00'  and (ConnectInfo_stop is not NULL or MediaInfo is NULL or MediaInfo != '' or (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(AcctStopTime) > 20))
Feb 17 08:40:02 ws16 cdrtool[4050]: 58
Feb 17 08:40:02 ws16 cdrtool[4050]: Unlock opensips_radius:radacct
Feb 17 08:40:02 ws16 media-dispatcher[3306]: [ManagementControlProtocol,9,127.0.0.1] Connection to Management interface client lost: Connection was closed cleanly.