Hello Nancy, you can easily go ahead and achieve this but when looking at
performance and throughput, you should also consider gigabit ethernet and
better storage systems for the DB. As a simple setup, just point your
database configuration and freeradius to use the remote MySQL server.
You can provide more details if you need specific implementation details.
Regards!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Nancy, go to the FreeRADIUS directory (/etc/raddb/sql.conf in the case of
RHEL/CentOS or /usr/local/etc/raddb/sql.conf in case of Ubuntu/Debian) and
edit sql.conf. You should find a section with database credentials, change
this settings and FreeRADIUS should be able to connect to mysql. Remember
also that the host will be the IP address of Server 2 (DB).
Hope this helps.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
You don't have to change the binding address, it should listen on all
interfaces by default. What you should do instead is to create the rd
database user with the ability to accept connections from remote
clients/hosts.
Recall:
mysql -u root
create database rd;
GRANT ALL PRIVILEGES ON rd. to 'rd'@'127.0.0.1' IDENTIFIED BY 'rd';
GRANT ALL PRIVILEGES ON rd. to 'rd'@'localhost' IDENTIFIED BY 'rd';
GRANT ALL PRIVILEGES ON rd.* to 'rd'@'%' IDENTIFIED BY 'rd';
exit;
Notice the 3rd Line.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The third line is giving me trouble. I have logged in as root on mysql and the error when trying to execute the GRANT PRIVILEGES command is 'access denied'.
I'm stuck.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi DVD,
I want to separately host my RadiusDesk and Mysql Server to minimize the load and for good performance ouput,
Eg,
Server 1 - RadiusDesk
Server 2 - Mysql Database,
What major precaution I need to take, Where I need to change database setting, so my Radiusdesk smoothly connect with Mysql database.
Please help. If have some document on this please share,
How do I achieve this,
Hello Nancy, you can easily go ahead and achieve this but when looking at
performance and throughput, you should also consider gigabit ethernet and
better storage systems for the DB. As a simple setup, just point your
database configuration and freeradius to use the remote MySQL server.
You can provide more details if you need specific implementation details.
Regards!
Sir,
I have installed radius server and radiusdesk on server 1, and DB on server 2,
Where do I make changes into freeradius server so it will connect to database automatically (server 2 DB)
Nancy, go to the FreeRADIUS directory (/etc/raddb/sql.conf in the case of
RHEL/CentOS or /usr/local/etc/raddb/sql.conf in case of Ubuntu/Debian) and
edit sql.conf. You should find a section with database credentials, change
this settings and FreeRADIUS should be able to connect to mysql. Remember
also that the host will be the IP address of Server 2 (DB).
Hope this helps.
Only changing this file will sort out my problem. I think on server 2 (DB) I need to edit /etc/my.cnf
bind-address = ip address.,
Else it will connect to localhost only.
You don't have to change the binding address, it should listen on all
interfaces by default. What you should do instead is to create the rd
database user with the ability to accept connections from remote
clients/hosts.
Recall:
mysql -u root
create database rd;
GRANT ALL PRIVILEGES ON rd. to 'rd'@'127.0.0.1' IDENTIFIED BY 'rd';
GRANT ALL PRIVILEGES ON rd. to 'rd'@'localhost' IDENTIFIED BY 'rd';
GRANT ALL PRIVILEGES ON rd.* to 'rd'@'%' IDENTIFIED BY 'rd';
exit;
Notice the 3rd Line.
Yes.....3rd Line, that will allow the connection from any network.
Hi @muffycompo
The third line is giving me trouble. I have logged in as root on mysql and the error when trying to execute the GRANT PRIVILEGES command is 'access denied'.
I'm stuck.