Menu

freeradius rlm_sql Error generating query

Help
Lalit
2013-12-04
2013-12-08
  • Lalit

    Lalit - 2013-12-04

    Hi All,

    I installed freeradius server with mysql DB,but getting error while receiving request from mikrotik device.

    freeradius -X

    getting following error

    Executing section authorize from file /etc/freeradius/radiusd.conf

    +- entering group authorize {...}
    [chap] Setting 'Auth-Type := CHAP'
    ++[chap] returns ok
    rlm_sql (sql): Reserving sql socket id: 2
    [sql] expand: ->
    [sql] Error generating query; rejecting user
    rlm_sql (sql): Released sql socket id: 2
    ++[sql] returns fail
    Using Post-Auth-Type Reject
    WARNING: Unknown value specified for Post-Auth-Type. Cannot perform requested action.

    i checked All SQL tables created and sql.conf file included in radiusd.conf.

    Also please suggest links for freeradius installation and configuration

     

    Last edit: Lalit 2013-12-04
  • Dirk van der Walt

    Hi,

    It looks like you use CHAP on the Mikrotik. Although it should also work fine, can you perhaps try by only selecting PAP and see if it then works fine.

    Let us know about your findings.

    Kind regards

     

Log in to post a comment.