0.9.3 > 1.1.0 sql errors

Andrew Long along at escapewire.com
Wed Jan 3 23:36:16 CET 2007

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 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

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.

More information about the Freeradius-Users mailing list