help! seperate database for accounting

[Matthew Newton]

On Wed, Apr 16, 2014 at 09:42:17PM +0000, Stacy Trippe wrote:
> In sites-enabled\default:
> authorize {
> ...
>         redundant {
>                 sql1
>                 sql2
>         }

OK


> accounting {
>        acct_unique
>         detail
>         unix
>         radutmp
>       sql sqlacct1 {

should be:

sqlacct1 {

>                 fail            = 1
>                 notfound        = return
>                 noop            = 2
...


> Despite this, and despite the separate connection setting in
> sqlacct1.conf vs. sql1.conf  -- radius still sending accounting
> data to radius:/radacct table for insertion.

The filenames make no difference. The definitions do:

> Sql1.conf:
> sql {

should be:

sql sql1 {

(i.e. an instantation of the "sql" module, called "sql1")

> ...
>         # Database type
>         # Current supported are: rlm_sql_mysql, rlm_sql_postgresql,
>         # rlm_sql_iodbc, rlm_sql_oracle, rlm_sql_unixodbc, rlm_sql_freetds
>         driver = "rlm_sql_mysql"
...


> Sqlacct1.conf:
> Sql {

should be:

sql sqlacct1 {

> ...
>         # Database type
>         # Current supported are: rlm_sql_mysql, rlm_sql_postgresql,
>         # rlm_sql_iodbc, rlm_sql_oracle, rlm_sql_unixodbc, rlm_sql_freetds
>         driver = "rlm_sql_mysql"
> 
>         # Connect info
>         server = "127.0.0.1"
...


Matthew


-- 
Matthew Newton, Ph.D. <mcn4 at le.ac.uk>

Systems Specialist, Infrastructure Services,
I.T. Services, University of Leicester, Leicester LE1 7RH, United Kingdom

For IT help contact helpdesk extn. 2253, <ithelp at le.ac.uk>