[Serusers] ser AAA with freeradius and mysql backend example - sr-users

10 Jun 2005

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 = &quot;laptop(a)mars.sol&quot; 

        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(a)bubus.com