On Feb 22, 2018, at 1:20 PM, Paco Madrid <pmadrid@stratio.com> wrote:
I ask for help because I'm unable to make freeeradius work with a database. Please help! I have a test environment in which i have deployed Freeradius and MariaDB on a single server, but I am not being able to get Freeradius to read it's clients from the MariaDB server. In fact, I think it's reading the clients correctly but it's not using the data it reads for some reason. I've searched the Internet but I have not found anyone with my specific issue...
Maybe try upgrading to 3.0.16.
But when I try to test it, the server seems not to answer the requests:
# echo "User-Password=password,User-Name=test" | radclient 127.0.0.1 auth my secret
Debug output... we don't care about "radclient" output.
Sent Access-Request Id 243 from 0.0.0.0:46566 to 127.0.0.1:1812 length 44 Sent Access-Request Id 243 from 0.0.0.0:46566 to 127.0.0.1:1812 length 44 Sent Access-Request Id 243 from 0.0.0.0:46566 to 127.0.0.1:1812 length 44 (0) No reply from server for ID 243 socket 3
From the server side, all I get are the following messages:
Ignoring request to auth address * port 1812 bound to server default from unknown client 127.0.0.1 port 50479 proto udp
That's not good.
What puzzles me are the following lines that appear in the startup, that make me think that freeradius is adding correctly the clients:
[...] rlm_sql (sql): Adding client 127.0.0.1 (127.0.0.1) to default clients list rlm_sql (127.0.0.1): Client "127.0.0.1" (sql) added rlm_sql (sql): Adding client 192.168.56.101 (192.168.56.101) to default clients list rlm_sql (192.168.56.101): Client "192.168.56.101" (sql) added [...]
Yes, that shows it's loading the clients.
Furthermore, radmin tells me the same:
That's good.
But if freeradius is adding correctly the clients, why is not answering the requests? And even more, if I add the client by the means of a clients.conf file and restart the freeradius it works correctly!
I am runnning Freeradius 3.0.13 and MariaDB 5.5.56 on a CentOS 7.4
Must be an issue with 3.0.13.
# cat /etc/centos-release CentOS Linux release 7.4.1708 (Core)
Why? The FAQ explains what information we need. I just don't understand the desire to give all kinds of irrelevant information... especially when the documentation says what we need. Alan DeKok.