Dear Jan,

 

I’ve tried but the freeradius doen’t look like connecting ok with the mySQL.

This is the message it gives me when I try auth.:

 

rad_recv: Access-Request packet from host 127.0.0.1:32854, id=99, length=195

        User-Name = "laptop@mars.sol"

        Digest-Attributes = "\n\010laptop"

        Digest-Attributes = "\001\nmars.sol"

        Digest-Attributes =

"\002*42adc7dfc79504c6f4aae461eb995f8889b49658"

        Digest-Attributes = "\004\022sip:sip.mars.sol"

        Digest-Attributes = "\003\nREGISTER"

        Digest-Response = "4fcfd64bf5b67211395a084e4c978eba"

        Service-Type = Sip-Session

        Sip-Uri-User = "laptop"

        NAS-IP-Address = 127.0.0.1

        NAS-Port = 5060

rlm_eap: EAP-Message not found

    rlm_digest: Converting Digest-Attributes to something sane...

        Digest-User-Name = "laptop"

        Digest-Realm = "mars.sol"

        Digest-Nonce =

"42adc7dfc79504c6f4aae461eb995f8889b49658"

        Digest-URI = "sip:sip.mars.sol"

        Digest-Method = "REGISTER"

rlm_digest: Adding Auth-Type = DIGEST

rlm_sql (sql): Reserving sql socket id: 1

rlm_sql_mysql: MYSQL check_error: 1146 received

rlm_sql_getvpdata: database query error rlm_sql (sql): SQL query error; rejecting user rlm_sql (sql): Released sql socket id: 1

 

Have a nice day,

gerard@bubus.com