Failed to create pair: unknown attribute "Max-All-Session"
Ben Humpert
ben at an3k.de
Sun May 10 20:17:19 CEST 2015
I guess your old FR version was 3.0.3 and the new version is 3.0.8? If
so, check the changes made with every version after 3.0.3 until
version 3.0.8 and look for Max-All-Session (the new attribute name
should be named). Then after you get to know the new attribute name
you just have to change the field name in your mysql database.
The changelog is located at http://freeradius.org/press/index.html
However, I quickly checked the changelog and couldn't find any
information about Max-All-Session so I guess you either had some
custom scripting in your old server but not your new server and thus
getting this error or you broke something.
Have you read http://wiki.freeradius.org/modules/Rlm_sqlcounter ?
You also want to check
http://lists.freeradius.org/pipermail/freeradius-users/2015-April/076858.html
because it is about the same problem. Or maybe this
http://lists.freeradius.org/pipermail/freeradius-users/2009-July/039984.html
too.
I don't use MySQL or any accounting (yet) so I can't actually help you
with the problem itself. All I can do is code validation and pointing
to (maybe) helpful URLs :)
2015-05-10 19:47 GMT+02:00 <escalanterj at gmail.com>:
> Hello Ben,
>
> Thanks, but could you tell me exactly where to look for? I'm very lost, I don’t know exactly where is the problem, is there one thing to change? More? Changelog, but exactly what...?
>
> Freundliche Grüsse
> Javier Escalante
> 00 41 78 689 85 69
> escalanterj at gmail.com
>
> -----Original Message-----
> From: Freeradius-Users [mailto:freeradius-users-bounces+escalanterj=gmail.com at lists.freeradius.org] On Behalf Of Ben Humpert
> Sent: 10 May 2015 18:18
> To: FreeRadius users mailing list
> Subject: Re: Failed to create pair: unknown attribute "Max-All-Session"
>
> It is exactly the same error as the one before with "Password". This time it's just "Max-All-Session". You should read the FreeRADIUS documentation or better the changelog to get to know what the correct attribute name is in the new FR version.
>
> 2015-05-10 17:56 GMT+02:00 <escalanterj at gmail.com>:
>> Hello,
>>
>> I have the configuration working perfectly in the old server, in the new one I get the following error. Can you give me a clue?
>>
>> Thanks
>> BR
>>
>>
>> rlm_sql: Failed to create the pair: Unknown attribute "Max-All-Session"
>> rlm_sql (sql): Error parsing user data from database result
>> (0) ERROR: sql : Error retrieving check pairs for group permanent
>>
>> # Executing section authorize from file /etc/freeradius/sites-enabled/default
>> (0) authorize {
>> (0) [preprocess] = ok
>> (0) [chap] = noop
>> (0) [mschap] = noop
>> (0) [digest] = noop
>> (0) suffix : Looking up realm "gmail.com" for User-Name = "escalanterj at gmail.com"
>> (0) suffix : No such realm "gmail.com"
>> (0) [suffix] = noop
>> (0) eap : No EAP-Message, not doing EAP
>> (0) [eap] = noop
>> (0) [files] = noop
>> (0) sql : EXPAND %{User-Name}
>> (0) sql : --> escalanterj at gmail.com
>> (0) sql : SQL-User-Name set to 'escalanterj at gmail.com'
>> rlm_sql (sql): Reserved connection (4)
>> (0) sql : EXPAND SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id
>> (0) sql : --> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'escalanterj at gmail.com' ORDER BY id
>> rlm_sql (sql): Executing query: 'SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'escalanterj at gmail.com' ORDER BY id'
>> (0) sql : User found in radcheck table
>> (0) sql : Check items matched
>> (0) sql : EXPAND SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id
>> (0) sql : --> SELECT id, username, attribute, value, op FROM radreply WHERE username = 'escalanterj at gmail.com' ORDER BY id
>> rlm_sql (sql): Executing query: 'SELECT id, username, attribute, value, op FROM radreply WHERE username = 'escalanterj at gmail.com' ORDER BY id'
>> (0) sql : EXPAND SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority
>> (0) sql : --> SELECT groupname FROM radusergroup WHERE username = 'escalanterj at gmail.com' ORDER BY priority
>> rlm_sql (sql): Executing query: 'SELECT groupname FROM radusergroup WHERE username = 'escalanterj at gmail.com' ORDER BY priority'
>> (0) sql : User found in the group table
>> (0) sql : EXPAND SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{Sql-Group}' ORDER BY id
>> (0) sql : --> SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'permanent' ORDER BY id
>> rlm_sql (sql): Executing query: 'SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'permanent' ORDER BY id'
>> rlm_sql: Failed to create the pair: Unknown attribute "Max-All-Session"
>> rlm_sql (sql): Error parsing user data from database result
>> (0) ERROR: sql : Error retrieving check pairs for group permanent
>> rlm_sql (sql): Released connection (4)
>> (0) [sql] = fail
>> (0) } # authorize = fail
>> (0) Using Post-Auth-Type Reject
>> (0) # Executing group from file /etc/freeradius/sites-enabled/default
>> (0) Post-Auth-Type REJECT {
>> (0) [sql] = noop
>> (0) attr_filter.access_reject : EXPAND %{User-Name}
>> (0) attr_filter.access_reject : --> escalanterj at gmail.com
>> (0) attr_filter.access_reject : Matched entry DEFAULT at line 11
>> (0) [attr_filter.access_reject] = updated
>> (0) eap : Request didn't contain an EAP-Message, not inserting EAP-Failure
>> (0) [eap] = noop
>> (0) remove_reply_message_if_eap remove_reply_message_if_eap {
>> (0) if (reply:EAP-Message && reply:Reply-Message)
>> (0) if (reply:EAP-Message && reply:Reply-Message) -> FALSE
>> (0) else else {
>> (0) [noop] = noop
>> (0) } # else else = noop
>> (0) } # remove_reply_message_if_eap remove_reply_message_if_eap = noop
>> (0) } # Post-Auth-Type REJECT = updated
>> (0) Delaying response for 1 seconds
>> Waking up in 0.3 seconds.
>> Waking up in 0.6 seconds.
>> (0) Sending delayed response
>> Sending Access-Reject Id 19 from 87.98.225.176:1812 to
>> 217.162.186.120:33955 Waking up in 3.9 seconds.
>> Received Access-Request Id 19 from 217.162.186.120:33955 to
>> 87.98.225.176:1812 length 218 Sending Access-Reject Id 19 from
>> 87.98.225.176:1812 to 217.162.186.120:33955 Waking up in 999994.3 seconds.
>> Received Access-Request Id 19 from 217.162.186.120:33955 to
>> 87.98.225.176:1812 length 218 Sending Access-Reject Id 19 from
>> 87.98.225.176:1812 to 217.162.186.120:33955 Waking up in 1999992.2 seconds.
>> root at dev3-64:~# freeradius -X
>> freeradius: FreeRADIUS Version 3.0.3, for host x86_64-pc-linux-gnu, built on May 20 2014 at 11:59:21
>> Copyright (C) 1999-2014 The FreeRADIUS server project and contributors
>> There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A
>> PARTICULAR PURPOSE You may redistribute copies of FreeRADIUS under the
>> terms of the GNU General Public License For more information about
>> these matters, see the file named COPYRIGHT Starting - reading
>> configuration files ...
>> including dictionary file /usr/share/freeradius/dictionary including
>> dictionary file /usr/share/freeradius/dictionary.dhcp
>> including dictionary file /usr/share/freeradius/dictionary.vqp
>> including dictionary file /etc/freeradius/dictionary including
>> configuration file /etc/freeradius/radiusd.conf including
>> configuration file /etc/freeradius/proxy.conf including configuration
>> file /etc/freeradius/clients.conf including files in directory
>> /etc/freeradius/mods-enabled/ including configuration file
>> /etc/freeradius/mods-enabled/sradutmp
>> including configuration file /etc/freeradius/mods-enabled/logintime
>> including configuration file /etc/freeradius/mods-enabled/attr_filter
>> including configuration file /etc/freeradius/mods-enabled/replicate
>> including configuration file /etc/freeradius/mods-enabled/radutmp
>> including configuration file /etc/freeradius/mods-enabled/preprocess
>> including configuration file /etc/freeradius/mods-enabled/passwd
>> including configuration file /etc/freeradius/mods-enabled/detail
>> including configuration file /etc/freeradius/mods-enabled/digest
>> including configuration file /etc/freeradius/mods-enabled/files
>> including configuration file /etc/freeradius/mods-enabled/unix
>> including configuration file /etc/freeradius/mods-enabled/mschap
>> including configuration file /etc/freeradius/mods-enabled/exec
>> including configuration file /etc/freeradius/mods-enabled/chap
>> including configuration file /etc/freeradius/mods-enabled/unpack
>> including configuration file /etc/freeradius/mods-enabled/utf8
>> including configuration file /etc/freeradius/mods-enabled/realm
>> including configuration file /etc/freeradius/mods-enabled/expr
>> including configuration file
>> /etc/freeradius/mods-enabled/dynamic_clients
>> including configuration file /etc/freeradius/mods-enabled/ntlm_auth
>> including configuration file /etc/freeradius/mods-enabled/dhcp
>> including configuration file /etc/freeradius/mods-enabled/pap
>> including configuration file /etc/freeradius/mods-enabled/always
>> including configuration file /etc/freeradius/mods-enabled/expiration
>> including configuration file /etc/freeradius/mods-enabled/echo
>> including configuration file /etc/freeradius/mods-enabled/detail.log
>> including configuration file /etc/freeradius/mods-enabled/soh
>> including configuration file /etc/freeradius/mods-enabled/cache_eap
>> including configuration file /etc/freeradius/mods-enabled/eap
>> including configuration file /etc/freeradius/mods-enabled/linelog
>> including configuration file /etc/freeradius/eap.conf including
>> configuration file /etc/freeradius/sql.conf including configuration
>> file /etc/freeradius/sql/mysql/dialup.conf
>> including files in directory /etc/freeradius/policy.d/ including
>> configuration file /etc/freeradius/policy.d/cui including
>> configuration file /etc/freeradius/policy.d/control including
>> configuration file /etc/freeradius/policy.d/canonicalization
>> including configuration file /etc/freeradius/policy.d/accounting
>> including configuration file /etc/freeradius/policy.d/filter including
>> configuration file /etc/freeradius/policy.d/operator-name
>> including configuration file /etc/freeradius/policy.d/dhcp including
>> configuration file /etc/freeradius/policy.d/eap including files in
>> directory /etc/freeradius/sites-enabled/ including configuration file
>> /etc/freeradius/sites-enabled/default
>> including configuration file
>> /etc/freeradius/sites-enabled/inner-tunnel
>> main {
>> security {
>> allow_core_dumps = no
>> }
>> }
>> main {
>> name =
>>
>>
>> -
>> List info/subscribe/unsubscribe? See
>> http://www.freeradius.org/list/users.html
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
More information about the Freeradius-Users
mailing list