sql sql_ipoe {
        driver = "rlm_sql_mysql"
        mysql {
                warnings = auto
        }
        dialect = "mysql"
        server = "172.19.0.5"
        port = 3306
        login = "nodeny"
        password = "A7d02N7eld8PGy7T"
        radius_db = "nodeny"
        delete_stale_sessions = yes
        pool {
                start = ${thread[pool].start_servers}
                min = ${thread[pool].min_spare_servers}
                max = ${thread[pool].max_servers}
                spare = ${thread[pool].max_spare_servers}
                uses = 0
                retry_delay = 60
                lifetime = 0
                idle_timeout = 120
        }
authorize_check_query = "call radcheck_ipoe('%{User-Name}')"
authorize_reply_query = "call radreply_ipoe('%{User-Name}','%{NAS-Identifier}')"
accounting {
  query = "call radupdate_ipoe('%{User-Name}','%{Framed-IP-Address}','nas=%{NAS-IP-Address}',\
'%{NAS-Identifier}','%{Acct-Session-Id}')"
  type {
    start { query = "call radupdate_ipoe('%{User-Name}','%{Framed-IP-Address}','nas=%{NAS-IP-Address}',\
'%{NAS-Identifier}','%{Acct-Session-Id}')"
    }
   }
  }
post-auth {
  query = "call radupdate_ipoe('%{User-Name}','%{reply:Framed-IP-Address}','nas=%{NAS-IP-Address}',\
'%{NAS-Identifier}','%{Acct-Session-Id}')"
  }
}

sql sql_pppoe {
        driver = "rlm_sql_mysql"
        mysql {
                warnings = auto
        }
        dialect = "mysql"
        server = "172.19.0.5"
        port = 3306
        login = "nodeny"
        password = "A7d02N7eld8PGy7T"
        radius_db = "nodeny"
        delete_stale_sessions = yes
        pool {
                start = ${thread[pool].start_servers}
                min = ${thread[pool].min_spare_servers}
                max = ${thread[pool].max_servers}
                spare = ${thread[pool].max_spare_servers}
                uses = 0
                retry_delay = 60
                lifetime = 0
                idle_timeout = 120
        }
authorize_check_query = "call radcheck_pppoe('%{User-Name}')"
authorize_reply_query = "call radreply_pppoe('%{User-Name}','%{NAS-Identifier}')"
accounting {
  query = "call radupdate_pppoe('%{User-Name}','%{Framed-IP-Address}','user=%{Calling-Station-Id};\
nas=%{NAS-IP-Address}','%{NAS-Identifier}','%{Acct-Session-Id}')"
  type {
    start { query = "call radupdate_pppoe('%{User-Name}','%{Framed-IP-Address}','user=%{Calling-Station-Id};\
nas=%{NAS-IP-Address}','%{NAS-Identifier}','%{Acct-Session-Id}')"
    }
   }
  }
post-auth {
  query = "call radupdate_pppoe('%{User-Name}','%{reply:Framed-IP-Address}','user=%{Calling-Station-Id};\
nas=%{NAS-IP-Address}','%{NAS-Identifier}','%{Acct-Session-Id}')"
  }
}