Cisco enable authentication on freeradius and mysql

mkr1e at mkr1e at
Fri Feb 16 16:53:49 CET 2007

I am trying to authenticate Cisco enable password requests via freeradius (1.1.3.) on a mysql
(5.0.26) database.

As per, the router tries to authenticate user $enab15$ but it
doesn't get matched on mysql query because '$' gets escaped to '=24'

radius_xlat:  '$enab15$'
rlm_sql (sql): sql_set_user escaped user --> '$enab15$'
radius_xlat:  'SELECT id, UserName, Attribute, Value, op           FROM radcheck           WHERE
Username = '=24enab15=24'           ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 1
rlm_sql (sql): User $enab15$ not found in radcheck

Is there any solution to this?

Have a burning question?  
Go to and get answers from real people who know.

More information about the Freeradius-Users mailing list