Help help help....

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Help help help....

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.
Reply | Threaded
Open this post in threaded view
|

Re: Help help help....

Iñaki Baz Castillo
2009/2/17 bay2x1 <[hidden email]>:
>
> 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...

For the next question in a maillist please use a descriptive subject.
"Help help help..." is not descriptive at all.


Regards.



--
Iñaki Baz Castillo
<[hidden email]>

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users