Eric, Thanks much for the pointer. I've got it working now.
For the record, the patch is not necessary if you upgrade to freeradius v 0.4, but the mysql schema and the distribution sql.conf files have not been updated to make use of the new capabilities. I'm submitting a patch file to '[EMAIL PROTECTED]' that updates the distribution mysql schema and sql.conf files. This patch is also available at: http://www.axion-it.net/download/sql-op.patch To upgrade my existing MySQL tables, I ran the following SQL statements: ALTER TABLE `radgroupcheck` ADD `op` CHAR(2); ALTER TABLE `radcheck` ADD `op` CHAR(2); ALTER TABLE `radreply` ADD `op` CHAR(2); ALTER TABLE `radgroupreply` ADD `op` CHAR(2); UPDATE radcheck SET op='=='; UPDATE radreply SET op='=='; UPDATE radgroupcheck SET op='=='; UPDATE radgroupreply SET op='=='; Setting all of the 'op' fields to '==' simply preserved the default behavior for my existing records. After patching my sql.conf file and restarting, I was able to start using the new 'op' support. Thanks to "[EMAIL PROTECTED]" for adding this capability and thanks to Eric for pointing me in the right direction. At 08:24 PM 12/15/2001 -0600, you wrote: >Randy, > >I had the same problem, and the following links fixed it for me...best >of luck... > > http://todes.org.by/~mitry/freeradius/rlm_sql/README.patch > > http://todes.org.by/~mitry/freeradius/rlm_sql/rlm_sql.diff > >-----Original Message----- >From: Randy Moore [mailto:[EMAIL PROTECTED]] >Posted At: Saturday, December 15, 2001 6:33 PM >Posted To: FreeRADIUS >Conversation: Simultaneous-Use in SQL table? >Subject: Simultaneous-Use in SQL table? > > >Hi, > >I'm new to freeradius and am having a problem when I try to use the >"Simultaneous-Use" check item from within a MySQL table. I'm trying to >put >it in the "radgroupcheck" table, but if I do, my "authorize" block >fails. If I move the Simultanous-Use check item back into a DEFAULT >item >in my "users" file it works perfectly. > >Another list member, Gillou <[EMAIL PROTECTED]>, recently reported a >similar >problem when trying to put Simultaneous-Use in the 'radcheck' table. > >I understand that Simultaneous-Use is not a normal check item, since it >is >not intended to match an Attribute that is in the radius request >packet. So, some kind of special handling is probably required. > >So, my best guess is that the necessary special handling is taking place > >before the SQL module has been called. > >Is it possible for me to configure this so that the special handling >occurs >after the check items have been loaded from the SQL module? > >Or am a way off base here? > >Thanks for any suggestions. >Randy Moore >Axion Information Technologies, Inc. > >email [EMAIL PROTECTED] >phone 301-408-1200 >fax 301-445-3947 > > >- >List info/subscribe/unsubscribe? See >http://www.freeradius.org/list/users.html > >- >List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html Randy Moore Axion Information Technologies, Inc. email [EMAIL PROTECTED] phone 301-408-1200 fax 301-445-3947 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
