[OpenSIPS-Users] CDRtool freeradius mysql error

[osiris123d]

In my radiusd.conf I have the following



accounting {
        detail
        sql
        ok                
}

So that should be good.

As for my /var/log/freeradius/radius.log I didn't see anything in the log
except for starting and stopping freeradius logs.  I did notice in the
OpenSIPS logs that there was an error because it didn't recognize something. 
I found that I needed to uncomment the following in my dictionary file on
OpenSIPS
$INCLUDE               /etc/radiusclient-ng/dictionary

Once I did that noticed the following logs in /var/log/freeradius/radius.log
Thu Dec 24 10:16:04 2009 : Error: Ignoring request from unknown client
12.*.*.218:1814
Thu Dec 24 10:16:11 2009 : Error: Rejecting request 0 due to lack of any
response from home server sip:59084
Thu Dec 24 10:16:14 2009 : Error: Ignoring request from unknown client
12.*.*.218:1814
Thu Dec 24 10:16:21 2009 : Error: Rejecting request 1 due to lack of any
response from home server sip:59084
Thu Dec 24 10:16:24 2009 : Error: Ignoring request from unknown client
12.*.*.218:1814
Thu Dec 24 10:16:31 2009 : Error: Rejecting request 2 due to lack of any
response from home server sip:59084

So I had to install radiusclient-ng on the CDRTool server and set up the
client.conf and servers file.  After that I see the following logs in
/var/log/freeradius/radius.log
Sat Dec 26 00:25:11 2009 : Proxy: marking accounting server 12.*.*.218:1813
for realm DEFAULT dead
Sat Dec 26 00:25:11 2009 : Proxy: marking accounting server 12.*.*.218:1813
for realm DEFAULT dead
Sat Dec 26 00:25:11 2009 : Proxy: marking accounting server 12.*.*.218:1813
for realm DEFAULT dead
Sat Dec 26 00:25:11 2009 : Proxy: marking accounting server 12.*.*.218:1813
for realm DEFAULT dead
Sat Dec 26 00:25:11 2009 : Proxy: marking accounting server 12.*.*.218:1813
for realm DEFAULT dead

I still have the same issue though.  The radacctYYYYMM is still not being
created.



Saul Ibarra Corretge wrote:
> 
> Hi,
> 
> On 23/12/09 11:21 PM, osiris123d wrote:
>>
>> One more bit of info.
>>
>> If I start freeradius in debug mode I see the following
>>
> 
> Can you see anything unusual in the freeradius logs when a call is 
> accounted? Check /var/log/freeradius/
> 
> Also, did you uncomment 'sql' from the accounting section in radiusd.conf?
> 
> 
> Regards,
> 
> 
> -- 
> Saúl Ibarra Corretgé
> AG Projects
> 
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> 
> 

-- 
View this message in context: http://n2.nabble.com/CDRtool-freeradius-mysql-error-tp4200490p4217530.html
Sent from the OpenSIPS - Users mailing list archive at Nabble.com.