I edited /etc/mysql/my.cnf with the following
<br />
<br />server-id = 1
<br />log_bin = /var/log/mysql/mysql-bin.log
<br />binlog_do_db = include_database_name
<br />binlog_ignore_db = include_database_name
<br />
<br />When I restart mysql the following file is created under /var/log/mysql
<br />mysql-bin.000001
<br />
<br />But when I start up /etc/init.d/cdrtool start and /etc/init.d/freeradius start
<br />nothing shows up in the log file all that is there is
<br />CDRTool:/var/log/mysql# more mysql-bin.000001
<br />KˆN2KuK^b5.0.51a-24+lenny2-logJ2K8
<br />
<br />
<br />Thats it. :(
<br />
<br />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
<br /># Next two jobs are only used when using a central radacct table:
<br /># 0 3 1 * * root php /var/www/CDRTool/scripts/OpenSIPS/rotateTables.php >/dev/null
<br /># 0 4 * * * root php /var/www/CDRTool/scripts/purgeTables.php >/dev/null
<br />
<br />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?
<br />
<br />
<br />On Dec 23, 2009 10:24am, "Saul Ibarra Corretge [via OpenSIPS (Open SIP Server)]" <<a href="http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4209672&i=0" target="_top" rel="nofollow">[hidden email]</a>> wrote:
<div class='shrinkable-quote'><br />>
<br />>
<br />>
<br />>
<br />> On 23/12/09 4:40 PM, osiris123d wrote:
<br />>
<br />>
<br />> >
<br />>
<br />>
<br />> > It still isn't working. The radacctYYYYMM table is never created in the
<br />>
<br />>
<br />> > radius database. I have logging turned on in MySQL and I never see the
<br />>
<br />>
<br />> > radius user execute the INSERT command to create the database. Can you
<br />>
<br />>
<br />> > explain to me when exactly does the radacctYYYYMM database get created?
<br />>
<br />>
<br />> > That way I could pinput what is going on and why it's not working.
<br />>
<br />>
<br />> >
<br />>
<br />>
<br />>
<br />> The tables get created by the stored procedure. Enable binary logging of
<br />>
<br />>
<br />> stored procedures to see if you are getting an error there.
<br />>
<br />>
<br />>
<br />>
<br />> Regards,
<br />>
<br />>
<br />>
<br />> --
<br />>
<br />>
<br />> Saúl Ibarra Corretgé
<br />>
<br />>
<br />> AG Projects
<br />>
<br />>
<br />>
<br />> _______________________________________________
<br />>
<br />>
<br />> Users mailing list
<br />>
<br />>
<br />> [hidden email]
<br />>
<br />>
<br />> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
<br />>
<br />>
<br />>
<br />>
<br />>
<br />>
<br />>
<br />>
<br />>
<br />> View message @ http://n2.nabble.com/CDRtool-freeradius-mysql-error-tp4200490p4209391.html
<br />>
<br />>
<br />>
<br />>
<br />> To unsubscribe from Re: CDRtool freeradius mysql error, click here.
<br />>
<br />>
<br />>
<br />>
<br />>
<br />>
<br />></div>
<br><hr align="left" width="300">
View this message in context: <a href="http://n2.nabble.com/CDRtool-freeradius-mysql-error-tp4200490p4209672.html">Re: Re: [OpenSIPS-Users] CDRtool freeradius mysql error</a><br>
Sent from the <a href="http://n2.nabble.com/OpenSIPS-Users-f1449235.html">OpenSIPS - Users mailing list archive</a> at Nabble.com.<br>