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-errors-on-opensips-1.4.4-tp2343951p2343951.html Sent from the OpenSIPS - Users mailing list archive at Nabble.com. _______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
