SQL Counters and Realms

[Ivan Kalik]

> 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