Hello Matthew , Thanks for your help. I have been using Password in my 2.x radius since ages. despite in the past someone told me the same, it was working perfectly, plus we use PAP authentication method. Can it be Cleartext-Password with PAP? I changed it to clear text password and the result is the one shown below. sql: ERROR: Failed to create the pair: Unknown name "Max-All-Session" (17) sql: ERROR: Error parsing user data from database result (17) sql: ERROR: Error retrieving check pairs for group unlimited Sorry for my ignorance, but could you tell me how to execute the SQL statement manually? I know that when 3 years ago I configured my 2.x radius, I had exactly the same problems, and I know that I had to modify some files. What I don't remember is what was it. My fault for not documenting. thanks! Best On Wed, Jun 27, 2018 at 12:27 PM, Matthew Newton <mcn@freeradius.org> wrote:
On Wed, 2018-06-27 at 12:19 +0200, John Martins wrote:
Having setup freeradius 3.0.16, I get this error when I try to authenticate with a user which was working properly in freeradius 2 for ages.
(12) sql: Executing select query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'frederic@gmail.com' ORDER BY id (12) sql: ERROR: Failed to create the pair: Invalid vendor name in attribute name "Password"
What does this SQL statement return if you execute it manually?
I'm guessing you have the attribute field as "Password", which isn't a valid RADIUS attribute (it existed in the dictionary a long time ago). It needs to be "Cleartext-Password".
-- Matthew
- List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html