FreeRadius + Postgresql newbie

[Guillermo Narvaez]

Ok, Where do I save the password for user? in the Value field?

On Thu, Aug 20, 2015 at 12:32 PM, Matt Zagrabelny <mzagrabe at d.umn.edu>
wrote:

> On Thu, Aug 20, 2015 at 10:14 AM, Guillermo Narvaez <gnrvzsix at gmail.com>
> wrote:
> > So sorry, forget that:
> >
> > radiusd: FreeRADIUS Version 2.2.6, for host x86_64-unknown-openbsd5.7,
> > built on Mar  7 2015 at 16:41:33
>
> The schema is listed in:
>
> sql/postgresql/schema.sql
>
> radcheck is the table you are looking for:
>
> CREATE TABLE radcheck (
>     id      SERIAL PRIMARY KEY,
>     UserName    VARCHAR(64) NOT NULL DEFAULT '',
>     Attribute   VARCHAR(64) NOT NULL DEFAULT '',
>     op      CHAR(2) NOT NULL DEFAULT '==',
>     Value       VARCHAR(253) NOT NULL DEFAULT ''
> );
> create index radcheck_UserName on radcheck (UserName,Attribute);
>
> You can configure the SQL lookups in a couple spots:
>
> sql.conf
>
> and
>
> sql/postgresql/dialup.conf
>
> I would try to not touch the queries in dialup.conf and just touch
> sql.conf if you need to use different table names, etc.
>
> -m
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>