>Hello > >I'm using freeradius 0.8.1 with Postgresql 7.3.1 on FreeBSD 4.7-RELEASE >and I have a couple of test users and groups set up in the sql >database. >However, when I do a test login (which works, but possibly by accident) >I see an entry in the log file for every check and reply pair where >rlm_sql complains that the op field value is NULL or non-existent. >Fiddling around with sql.c shows that indeed the value of the op field >is NULL, although the database has ':=' for reply pairs and '==' for >check pairs. > >Turning on debugging shows that the correct query is going to the >database, and of course running the query by hand in psql produces the >correct result. I couldn't see any mention of this in the archives, >leading me to suspect I may have broken something, but if I have, it's >not obvious. > >I'm going through the postgres driver code at the moment, but it all >seems to be Ok - has any one else seen this?
I hereby nominate myself for slaphead of the month. The problem was due to the authorize_group_check_query and authorize_group_reply_query strings in postgresql.conf not selecting the op field. Simply adding in the appropriate values to the select statement fixed it. Obvious really... -Adrian - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
