accepting all the users

John Martins jm829580 at
Wed Jun 27 12:52:55 CEST 2018

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.



On Wed, Jun 27, 2018 at 12:27 PM, Matthew Newton <mcn at> 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 at' 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
> list/users.html

More information about the Freeradius-Users mailing list