mysql errors when running freeradius

[Ivan Kalik]

> ok added that new line to radiusd.conf, seems to go through the first
> stages
> of the authorize section, when it comes to the sql part it errors again.
>

Post the debug of the server startup as well.

> Radiusd -X Debug:
> Listening on authentication address * port 1812
> Listening on accounting address * port 1813
> Listening on proxy address * port 1814
> Ready to process requests.
> rad_recv: Access-Request packet from host 127.0.0.1 port 49731, id=252,
> length=59
> 	User-Name = "sqltest"
> 	User-Password = "testpwd"
> 	NAS-IP-Address = 127.0.0.2
> 	NAS-Port = 1812
> +- entering group authorize {...}
> ++[preprocess] returns ok
> ++[chap] returns noop
> ++[mschap] returns noop
> [suffix] No '@' in User-Name = "sqltest", looking up realm NULL
> [suffix] No such realm "NULL"
> ++[suffix] returns noop
> [eap] No EAP-Message, not doing EAP
> ++[eap] returns noop
> rlm_sql (sql): Reserving sql socket id: 4
> [sql] 	expand:  ->
> [sql] Error generating query; rejecting user
> rlm_sql (sql): Released sql socket id: 4
> ++[sql] returns fail
> Using Post-Auth-Type Reject
> +- entering group REJECT {...}
> [attr_filter.access_reject] 	expand: %{User-Name} -> sqltest
>  attr_filter: Matched entry DEFAULT at line 11
> ++[attr_filter.access_reject] returns updated
> Delaying reject of request 0 for 1 seconds
> Going to the next request
> Waking up in 0.9 seconds.
> Sending delayed reject for request 0
> Sending Access-Reject of id 252 to 127.0.0.1 port 49731
> Waking up in 4.9 seconds.

Ivan Kalik
Kalik Informatika ISP