Re: help! seperate database for accounting

16 Apr 2014

      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@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@le.ac.uk>