![]() ![]() ![]() Your sql section should look similar to below. The Ubuntu server was set up from scratch and there are currently no manual configurations to mysql or php. My database is not huge but I am running into issues and would like to consult with an database (mysql) expert to help me fix the problem, or understand if I need to upgrade the server resources. Background: I am running a cqpweb, a corpus query interface written in PHP and connected to a mysql database, on an Apache2 webserver under Ubuntu 18.04 LTS. # sudo mysql -u root -p # CREATE DATABASE radius # mysql -u root -p radius < /etc/freeradius/3.0/mods-config/sql/main/mysql/schema.sql # sudo nano /etc/freeradius/3.0/mods-enabled/sql Once your MySQL server is up and running, you can connect to it as the superuser root with the mysql client. I am hosting this on a Ubuntu 18.04, 8 GB Dedicated RAM, 4 CPU, 140GB SSD server. Remove test database and access to it? (Press y|Y for Yes, any other key for No) : <– y Reload privilege tables now? (Press y|Y for Yes, any other key for No) : <– y ![]() # sudo apt-get -y install mysql-server mysql-client # mysql_secure_installationĮnter password for user root: <– Enter the MySQL root passwordĬhange the password for root? (Press y|Y for Yes, any other key for No): <– nĭisallow root login remotely? (Press y|Y for Yes, any other key for No) : <– y (Press CTRL + X, press Y and then press ENTER)ĭATABASE CREATION AND CONFIGURATION FOR FREERADIUS On line 314 change auth_goodpass = no to auth_goodpass = yes On line 313 change auth_badpass = no to auth_badpass = yes The Ubuntu 18.04 server, by default, contains the latest MySQL version 5.7 in the repositories. important to note that uninstalling MySQL will remove all of your databases. # sudo apt -y install freeradius freeradius-mysql freeradius-utils # sudo nano /etc/freeradius/3.0/nf Uninstalling MySQL on Ubuntu 18.04 can be done using a variety of methods. Run mysqlsecureinstallation and follow the instructions. It is fast to set up and many networking programs like OpenVPN, SotfEther, Squid proxy and wifi managing tools can be integrated with FreeRADIUS. Log into the server that will host the database, and open a terminal window. It provides AAA services namely Authorization, Authentication, and Accounting. RADIUS, which stands for “Remote Authentication Dial-In User Service“, is a network protocol used for remote user authentication and accounting. It was built in the dial-up era to manage users and keep track of the bandwidth usage by each connection for billing purposes. FreeRADIUS is an open source application that allows network to authenticate users who want to access network resources, such as the internet. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |