Freeradius, PostgreSQL and One-Time-Password backends

[Ivan Kalik]

> So i start by adding the section to proxy.conf
>
> --proxy.conf
> realm Safeword {
>         type = radius
>         authhost        = <ip>:1645
>         accthost        = <ip>:1646
>         secret          = <secret>
>         }
>
> realm Portwise {
>         type = radius
>         authhost        = <ip>:1645
>         accthost        = <ip>:1646
>         secret          = <secret>
>         }
>
>
> But how do i configure users file so that it does query the SQL-database?

You don't. Use unlang.

> Let´s say every user-record contains information in the table
> Authentication-Server (Safeword or Portwise).

update control {
     Proxy-To-Realm := %{sql:"SELECT...FROM Authentication-Server WHERE...}
}

Ivan Kalik
Kalik Informatika ISP