Radius Error on form submit about pfsense-cp-auth-onestep

[Milo-81]

After research i juste find what is wrong in the code.
In the ozy-captive.php on the line 281
if (!$statement = $db->prepare("INSERT INTO radcheck (username, attribute, value) VALUES (?, 'Password', ?)"))

The password value is wrong, now, freeradius use Cleartext-Password. And now freeradius use the value := in the op column.

So i replace this line by
if (!$statement = $db->prepare("INSERT INTO radcheck (username, attribute, op, value) VALUES (?, 'Cleartext-Password', ':=', ?)"))

and it's work !

[deajan]

Thank you for your help.
Did you have to modify anything else ? Also, what FreeRADIUS version do you run so I can update the script to run with newer pfSense builds.

[Milo-81]

No i dont have modify anything else.
For FreeRadius, I use the freeradius3-3.0.17 version.

And after some checks, i think it will be better to modify the sql script to change the attribute and op default value than the php script itself ;)

[deajan]

Thank you. I will update the docs accordingly.