<div dir="ltr">Hi Fajar<div>Thanks for the input, so if I use dailycounter instead of daily, and of course dailycounter is defined in sql/mysql/counter.conf does freeradius automatically know that it should look into sql counter.conf, or should I comment out counter without db ?</div>
<div>Regards</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Jul 15, 2014 at 1:25 PM, Fajar A. Nugraha <span dir="ltr"><<a href="mailto:list@fajar.net" target="_blank">list@fajar.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="">On Tue, Jul 15, 2014 at 5:59 PM, Ali Jawad <<a href="mailto:alijawad1@gmail.com">alijawad1@gmail.com</a>> wrote:<br>
> counter daily {<br>
><br>
> filename = ${db_dir}/db.daily<br>
<br>
<br>
</div><div class="">> rlm_counter: Failed to open file /etc/raddb/db.daily: Permission denied<br>
><br>
> /etc/raddb/modules/counter[71]: Instantiation failed for module "daily"<br>
<br>
> What strikes me as weird is why does freeradius try to look in db.daily<br>
> which does not exist, instead of the MySQL table radacct ?<br>
<br>
</div>counter -> store data in a file (gdbm)<br>
sqlcounter -> use accounting data stored in sql<br>
<div class=""><br>
<br>
> Any pointers in the right directions please?<br>
<br>
</div>Try <a href="http://wiki.freeradius.org/modules/Rlm_sqlcounter" target="_blank">http://wiki.freeradius.org/modules/Rlm_sqlcounter</a><br>
<span class="HOEnZb"><font color="#888888"><br>
--<br>
Fajar<br>
-<br>
List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/users.html" target="_blank">http://www.freeradius.org/list/users.html</a><br>
</font></span></blockquote></div><br></div>