Andrew Long wrote:
rlm_sql: Failed to create the pair: Unknown value Administrative for attribute Service-Type rlm_sql (sql): Error getting data from database
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).
The problem you're running into is likely that the dictionaries have changed. Some of the older dictionaries were, quite frankly, wrong.
You'll have to update your configuration to use the new names for the attributes & values. Compare th 0.9.3 dictionaries to the new ones to see what the values mean...
Alan DeKok. --
Thanks Alan. (Sorry for the reply that went to you alone). How do you recommend I proceed when the A-V pair in question (Service-Type:Administrative-user) no longer exists in 1.1.0? The 1.1.0 dictionary only defines about 5 internal service types... VALUE Service-Type Voice 12 VALUE Service-Type Fax 13 VALUE Service-Type Modem-Relay 14 VALUE Service-Type IAPP-Register 15 VALUE Service-Type IAPP-AP-Check 16 ...whereas 0.9.3 defined many more (about 17, including Administrative-user). Would it be possible to simply use the old dictionaries (/usr/local/share/freeradius/*) on 1.1.0 as an interim solution until we have the new server built. We are trying to get this up asap. Not an elegent solution, but would it work? Or, do I need to dig deeper into some of those dictionary files to find a suitable A-V pair? Andrew