[OpenSIPS-Users] CDRtool freeradius mysql error
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.
> Saúl Ibarra Corretgé
> AG Projects
> Users mailing list
> [hidden email]
> View message @
> 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...
More information about the Users