[OpenSIPS-Users] Help help help....

bay2x1 rod at racequeen.ph
Tue Feb 17 01:53:54 CET 2009


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.

-- 
View this message in context: http://n2.nabble.com/Help-help-help....-tp2338335p2338335.html
Sent from the OpenSIPS - Users mailing list archive at Nabble.com.




More information about the Users mailing list