SQL Counters and Realms

[liran tal]

You're correct, I haven't noticed this parameter and it's default
'sql' is a different
database setup indeed.
Thanks,
Liran.


On Wed, May 6, 2009 at 11:16 PM, Ivan Kalik <tnt at kalik.net> wrote:

> > Hey,
> >
> > In my FR1.1.7 setup, I have different realms for the same machine using
> > different databases for each.
> > The login part is ok, as well as the accounting, which has entries in the
> > radacct table for "account".
> >
> > I enabled one of the sql counters modules which, as it seems, isn't
> > returning any results, because I am
> > suspecting that it's running the query on another realm's database. I
> have
> > several of the sql.conf config
> > files for each realm, so what I'm basically doing is having in accounting
> > {}
> > section something like this:
> >    Acct-Type SQL_EXAMPLE {
> >     sql_example
> >    }
> >
> > What do you think is happening?
>
> sqlcounter module has a config item sqlmod-inst which selects sql instance
> (database connection) that counter should use. Are you using the correct
> instance for that counter?
>
> Ivan Kalik
> Kalik Informatika ISP
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20090506/29f33cba/attachment.html>