FreeRadius + Postgresql newbie

[Matt Zagrabelny]

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