[OpenSIPS-Users] CDRtool freeradius mysql error

osiris123d duane.larson at gmail.com
Wed Dec 23 18:25:15 CET 2009

I edited /etc/mysql/my.cnf with the following

server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
binlog_do_db = include_database_name
binlog_ignore_db = include_database_name

When I restart mysql the following file is created under /var/log/mysql

But when I start up /etc/init.d/cdrtool start and /etc/init.d/freeradius  
nothing shows up in the log file all that is there is
CDRTool:/var/log/mysql# more mysql-bin.000001

Thats it. :(

When is the radacctYYYYMM created? Is it when cdrtool is started or when  
freeradius is started?? I see in the /etc/cron.d/cdrtool file that the  
following are commented out
# Next two jobs are only used when using a central radacct table:
# 0 3 1 * * root php /var/www/CDRTool/scripts/OpenSIPS/rotateTables.php  
# 0 4 * * * root php /var/www/CDRTool/scripts/purgeTables.php >/dev/null

but the rotateTables looks like it would only create the new months table  
on the first of the month. So that can't be my issue, but I am guessing  
that this does need to be uncommented for future table creations correct?

On Dec 23, 2009 10:24am, "Saul Ibarra Corretge [via OpenSIPS (Open SIP  
Server)]" <ml-node+4209391-434944227 at n2.nabble.com> wrote:

> On 23/12/09 4:40 PM, osiris123d wrote:

> >

> > It still isn't working. The radacctYYYYMM table is never created in the

> > radius database. I have logging turned on in MySQL and I never see the

> > radius user execute the INSERT command to create the database. Can you

> > explain to me when exactly does the radacctYYYYMM database get created?

> > That way I could pinput what is going on and why it's not working.

> >

> The tables get created by the stored procedure. Enable binary logging of

> stored procedures to see if you are getting an error there.

> Regards,

> --

> Saúl Ibarra Corretgé

> AG Projects

> _______________________________________________

> Users mailing list

> [hidden email]

> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

> View message @  
> http://n2.nabble.com/CDRtool-freeradius-mysql-error-tp4200490p4209391.html

> To unsubscribe from Re: CDRtool freeradius mysql error, click here.

View this message in context: http://n2.nabble.com/CDRtool-freeradius-mysql-error-tp4200490p4209672.html
Sent from the OpenSIPS - Users mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20091223/b176455e/attachment-0001.htm 

More information about the Users mailing list