[Serusers] ser AAA with freeradius and mysql backend example

[Gerard]

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 at 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 at bubus.com

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20050610/abf7d069/attachment.htm>