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,