Hi, I'm installing FreeRadius with Postgresql after a couple of years of using plain text files, all the SQL thing was created but I can't realize where is the Users table. Can anyone help me? Thanks!
On Thu, Aug 20, 2015 at 10:01 AM, Guillermo Narvaez <gnrvzsix@gmail.com> wrote:
Hi, I'm installing FreeRadius with Postgresql after a couple of years of using plain text files, all the SQL thing was created but I can't realize where is the Users table.
Can anyone help me?
What version of FR are you using? -m
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 On Thu, Aug 20, 2015 at 12:09 PM, Matt Zagrabelny <mzagrabe@d.umn.edu> wrote:
On Thu, Aug 20, 2015 at 10:01 AM, Guillermo Narvaez <gnrvzsix@gmail.com> wrote:
Hi, I'm installing FreeRadius with Postgresql after a couple of years of using plain text files, all the SQL thing was created but I can't realize where is the Users table.
Can anyone help me?
What version of FR are you using?
-m - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On Thu, Aug 20, 2015 at 10:14 AM, Guillermo Narvaez <gnrvzsix@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
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@d.umn.edu> wrote:
On Thu, Aug 20, 2015 at 10:14 AM, Guillermo Narvaez <gnrvzsix@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
On Thu, Aug 20, 2015 at 10:40 AM, Guillermo Narvaez <gnrvzsix@gmail.com> wrote:
Ok, Where do I save the password for user? in the Value field?
Here is a contrived example from our dataset: # SELECT * from radius_check limit 2; id | username | attribute | op | value ----+----------+----------------+----+------------------------------------ 0 | alice | Crypt-Password | := | $1$SALT$HASH 0 | bob | Crypt-Password | := | $1$SALT$HASH -m
I'll try that. Thank you Matt. On Thu, Aug 20, 2015 at 12:47 PM, Matt Zagrabelny <mzagrabe@d.umn.edu> wrote:
On Thu, Aug 20, 2015 at 10:40 AM, Guillermo Narvaez <gnrvzsix@gmail.com> wrote:
Ok, Where do I save the password for user? in the Value field?
Here is a contrived example from our dataset:
# SELECT * from radius_check limit 2; id | username | attribute | op | value ----+----------+----------------+----+------------------------------------ 0 | alice | Crypt-Password | := | $1$SALT$HASH 0 | bob | Crypt-Password | := | $1$SALT$HASH
-m - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (3)
-
A.L.M.Buxey＠lboro.ac.uk -
Guillermo Narvaez -
Matt Zagrabelny