On Fri, 2002-10-25 at 08:41, Alan DeKok wrote:
> "=?ISO-8859-1?Q?Mois=E9s?= David =?ISO-8859-1?Q?Rinc=F3n?= D'Hoyos"
> <[EMAIL PROTECTED]> wrote:
> > P.D. From the latest CVS version, this issue has been solved for mssql
> > and mysql but postgresql.conf still is incorrect.
>
> So submit a patch. Or find an old patch which wasn't committed, and
> post another message, saying you've tried it, and it works.
>
The patch:
--- postgresql.conf.orig Fri Oct 25 08:57:21 2002
+++ postgresql.conf Fri Oct 25 08:57:45 2002
@@ -84,8 +84,8 @@
# authorize_check_query = "SELECT id,UserName,Attribute,Value FROM
${authcheck_table} WHERE STRCMP(Username, '%{SQL-User-Name}') = 0 ORDER
BY id"
# authorize_reply_query = "SELECT id,UserName,Attribute,Value FROM
${authreply_table} WHERE STRCMP(Username, '%{SQL-User-Name}') = 0 ORDER
BY id"
- authorize_check_query = "SELECT id,UserName,Attribute,Value,Op FROM
${authcheck_table} WHERE Username = '%{SQL-User-Name}' ORDER BY id"
- authorize_reply_query = "SELECT id,UserName,Attribute,Value,Op FROM
${authreply_table} WHERE Username = '%{SQL-User-Name}' ORDER BY id"
+ authorize_check_query = "SELECT id,UserName,Attribute,Value FROM
${authcheck_table} WHERE Username = '%{SQL-User-Name}' ORDER BY id"
+ authorize_reply_query = "SELECT id,UserName,Attribute,Value FROM
${authreply_table} WHERE Username = '%{SQL-User-Name}' ORDER BY id"
# Use these for case sensitive usernames. WANRING: Slower queries!
# authorize_group_check_query = "SELECT
${groupcheck_table}.id,${groupcheck_table}.GroupName,${groupcheck_table}.Attribute,${groupcheck_table}.Value
FROM ${groupcheck_table},${usergroup_table} WHERE STRCMP(${usergroup_table}.Username,
'%{SQL-User-Name}') = 0 AND ${usergroup_table}.GroupName =
${groupcheck_table}.GroupName ORDER BY ${groupcheck_table}.id"
It just adds 'Op' to the select, to make postgresql work in the same way
mysql and mssql configurations do.
> Until then... I doubt that much will happen.
>
> Alan DeKok.
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
