I am trying to get a second server (ver. 1.1.0) running mostly on the configs from an older (0.9.3). The sql tables are identical (except for some ip changes) and the radiusd.conf, sql.conf, etc are identical except for small details particular to system (I hope).
When I point an NAS (Colubris CN3000) to the new server, it authenticates, but we get error: radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'hawth_cn3000' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id' rlm_sql: Failed to create the pair: Unknown value Administrative for attribute Service-Type rlm_sql (sql): Error getting data from database And... only one A-V pair is sent along... Sending Access-Accept of id 187 to 204.95.127.xxx port 2048 Colubris-AVPair = "login-url=http://64.69.121.xxx/hotspots/hawthorn/login.html?loginurl=%l"; with this in the colubris log... At least one required internal page was not retrieved - Keeping previous set of internal pages. I have run the query on the old server and the results are the identical set. When authenticating to the old server, no errors result and all A-V pairs are sent along... Any hints? Andrew -- Regards, Andrew Long Network Support Specialist EscapeWire Solutions, LLC 617 Dingens Street Buffalo, NY 14206 Office: (716) 893-4984 Mobile: (716) 830-5169 Fax: (716) 891-4288 ****** CONFIDENTIALITY NOTICE ****** NOTICE: This e-mail message and all attachments transmitted with it may contain legally privileged and confidential information intended solely for the use of the addressee. If the reader of this message is not the intended recipient, you are hereby notified that any reading, dissemination, distribution, copying, or other use of this message or its attachments is strictly prohibited. If you have received this message in error, please notify the sender immediately and delete this message from your system. Thank you. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
