P
P
petrovkazanksvu2021-02-11 12:04:32
MySQL
petrovkazanksvu, 2021-02-11 12:04:32

How to connect mysql database to freeradius on ubuntu 18?

Good day to all! I'm trying to connect the mariaddb database to freeradius. I do everything step by step and according to this instruction https://infoit.com.ua/linux/ubuntu/kak-ustanovit-f... .
after setting the config file /etc/freeradius/3.0/mods-enabled/sql:

sql {
driver = "rlm_sql_mysql"
dialect = "mysql"

# Connection info:
server = "localhost"
port = 3306
login = "radius"
password = "radiuspassword"

# Database table configuration for everything except Oracle
radius_db = "radius"
}

# Set to ‘yes’ to read radius clients from the database (‘nas’ table)
# Clients will ONLY be read on server startup.
read_clients = yes

# Table to keep radius client info
client_table = "nas"

after I start the freeradius service in the debug mode "freeradius -X"
and get a number of errors

rlm_sql (sql): Opening additional connection (0), 1 of 32 pending slots used
rlm_sql_mysql: Starting connect to MySQL server
rlm_sql_mysql: Couldn't connect to MySQL server [email protected]:radius
rlm_sql_mysql: MySQL error: Access denied for user 'radius'@'localhost'
rlm_sql_mysql: Socket destructor called, closing socket
rlm_sql (sql): Opening connection failed (0)
rlm_sql (sql): Removing connection pool
/etc/freeradius/3.0/mods-enabled/sql[20]: Instantiation failed for module "sql"


Has anyone encountered this problem? Or can you suggest how to solve this issue?
Thank you in advance!

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question