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 mysql-bin.000001 But when I start up /etc/init.d/cdrtool start and /etc/init.d/freeradius start nothing shows up in the log file all that is there is CDRTool:/var/log/mysql# more mysql-bin.000001 KˆN2KuK^b5.0.51a-24+lenny2-logJ2K8 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 >/dev/null # 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-434944...@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.
_______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users