Re: Help

14 Jul 2016

      Alan,

     You could take a look in my defaults file?

     Do you suggest something better?

###########
authorize {
         preprocess
         pap
         chap
         mschap
         digest
         eap {
                 ok = return
         }
         sql
         expiration
         logintime

         if(!control:Auth-Type){
          update control {
           Auth-Type := PAP
          }

          ok
         }
}

authenticate {

         Auth-Type PAP {
                 pap {
                        fail = 1
                     }

                     if(fail) {

                        update control {
                          Pool-Name := "mkt_pool"
                        }

                        update reply {
                          Mikrotik-Rate-Limit := "300K/2M 600K/2200K 
450K/1500K 10/10"
                        }

                        ok
                    }
         }

         Auth-Type CHAP {
                chap  {
                        invalid = 1
                     }

                     if(invalid) {

                        update control {
                          Pool-Name := "mkt_pool"
                        }

                        update reply {
                          Mikrotik-Rate-Limit := "300K/2M 600K/2200K 
450K/1500K 10/10"
                        }

                        ok
                    }

         }

         Auth-Type MS-CHAP {
                 mschap  {
                        reject = 1
                     }

                     if(reject) {

                        update control {
                          Pool-Name := "mkt_pool"
                        }

                        update reply {
                          Mikrotik-Rate-Limit := "300K/2M 600K/2200K 
450K/1500K 10/10"
                        }

                        ok
                    }

         }

         digest
         unix
         eap
}

preacct {
         preprocess
         acct_unique
}

accounting {
         detail
         unix
         radutmp
         sradutmp
         sqlippool
         sql

         if (noop){
               ok
         }

         #sql_log
         attr_filter.accounting_response
}

session {
# radutmp
  sql
}

post-auth {
  sqlippool
}

###########

Aurélio

Em 14/07/2016 10:05, Alan DeKok escreveu:
...
On Jul 14, 2016, at 8:05 AM, Aurélio de Souza Ribeiro Neto <netolistas@mpc.com.br> wrote:
...
The users normally authenticated and their connections were recorded in detail but were not updated in the MySQL database.
   I don't know of any situation where it magically stops using SQL.  If anything goes wrong, there will be messages in the log file.
Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html