Hi all, Using Freeradius v2 We use only PGSQL (no "users" file) and a custom schema Just an example: authorize_check_query = "SELECT * FROM f_authorize_check_query2('%{SQL-User-Name}','%{User-Password}' ...." => We play much with FUNCTIONs in PGSQL. Because of legacy application requiring exotic schema, we are obliged to play with it. The problem is I cannot have +----+----------+--------------------+----+-------+ | id | UserName | Attribute | op | Value | +----+----------+--------------------+----+-------+ | 1 | bartek | Cleartext-Password | := | 1234 | | 3 | bartek | Simultaneous-Use | := | 1 | +----+----------+--------------------+----+-------+ With our schema, but only +----+----------+--------------------+----+-------+ | id | UserName | Attribute | op | Value | +----+----------+--------------------+----+-------+ | 1 | bartek | Cleartext-Password | := | 1234 | +----+----------+--------------------+----+-------+ Where should i specify a default "Simultaneous-Use := 1" in a file, so that It wouldn't be mandatory to return it from the authorize_check_query? -- Architecte Informatique chez Blueline/Gulfsat: Administration Systeme, Recherche & Developpement +261 34 29 155 34
Because of legacy application requiring exotic schema, we are obliged to play with it.
The problem is I cannot have
+----+----------+--------------------+----+-------+ | id | UserName | Attribute | op | Value | +----+----------+--------------------+----+-------+ | 1 | bartek | Cleartext-Password | := | 1234 | | 3 | bartek | Simultaneous-Use | := | 1 | +----+----------+--------------------+----+-------+
With our schema, but only +----+----------+--------------------+----+-------+ | id | UserName | Attribute | op | Value | +----+----------+--------------------+----+-------+ | 1 | bartek | Cleartext-Password | := | 1234 | +----+----------+--------------------+----+-------+
Where should i specify a default "Simultaneous-Use := 1" in a file, so that It wouldn't be mandatory to return it from the authorize_check_query?
Just put it in users file: bartek Simultaneous-Use:=1 Ivan Kalik Kalik Informatika ISP
09/11/2009 07:02 PM, Ivan Kalik::
Because of legacy application requiring exotic schema, we are obliged to play with it. The problem is I cannot have +----+----------+--------------------+----+-------+ | id | UserName | Attribute | op | Value | +----+----------+--------------------+----+-------+ | 1 | bartek | Cleartext-Password | := | 1234 | | 3 | bartek | Simultaneous-Use | := | 1 | +----+----------+--------------------+----+-------+
With our schema, but only +----+----------+--------------------+----+-------+ | id | UserName | Attribute | op | Value | +----+----------+--------------------+----+-------+ | 1 | bartek | Cleartext-Password | := | 1234 | +----+----------+--------------------+----+-------+
Where should i specify a default "Simultaneous-Use := 1" in a file, so that It wouldn't be mandatory to return it from the authorize_check_query? Just put it in users file: bartek Simultaneous-Use:=1
"users" file attributes are merged with "from SQL" ones? Which has precedence? Does it depends on the order specified in radiusd.conf? -- Architecte Informatique chez Blueline/Gulfsat: Administration Systeme, Recherche & Developpement +261 34 29 155 34
participants (2)
-
Ivan Kalik -
Rakotomandimby Mihamina