𝐋𝐢𝐛𝐫𝐞𝐒𝐩𝐞𝐞𝐝 - 𝐅𝐫𝐞𝐞 𝐚𝐧𝐝 𝐎𝐩𝐞𝐧𝐬𝐨𝐮𝐫𝐜𝐞 𝐒𝐩𝐞𝐞𝐝𝐭𝐞𝐬𝐭

First, we will install apache web server and php with below command.

root@ubuntu: ~# apt install apache2 php -y

After that we will download LibreSpeed Package via GitHub. In order to download, we must have ‘git’ command to type. If there was not, please install by typing “apt install git -y”.

GitHub Link - https://github.com/librespeed/speedtest.git

root@ubuntu: ~# git clone https://github.com/librespeed/speedtest.git

After downloaded, go to speedtest directory and copy the mentioned files in command to /var/www/html/

root@ubuntu: ~/speedtest# cp -R backend example-singleServer-pretty.html *.js /var/www/html/

Then go to /var/www/html and change example-singleServer-pretty.html to index.html.

root@ubuntu:/var/www/html# mv example-singleServer-pretty.html index.html

Then change the ownership to www-data from root. The command means that Apache can access that directory.

root@ubuntu:/var/www/html# chown -R www-data *

In this stage, we can call it from Web Browser. All we need to do is just type IP address in search bar.

Go back to speedtest directory and copy results directory to /var/www/html/.

root@ubuntu: ~/speedtest# cp -R results /var/www/html/

Do not miss to change ownership for results directory.

root@ubuntu:/var/www/html# chown -R www-data *

The testing results are stored under this results directory. And we need database to store test results. Here we will use MySQL database to store test results (optional, PostgreSQL and SQLite also supported). So, we will install mysql server to store data. 

root@ubuntu: ~/speedtest# apt install mysql-server -y

And also, I will install phpMyAdmin to get an interface to import database easily. (This is not necessarily for experts).

root@ubuntu: ~/speedtest# apt install phpmyadmin -y

Now we will set up root user account in mysql database.

root@ubuntu: ~/speedtest# mysql

mysql> alter user 'root'@'localhost' identified with mysql_native_password by 'p@ssw0rd';

mysql> flush privileges;

mysql> exit

Then we will configure sql settings in telemetry_mysql.sql. We need to configure credentials. Changes should be as below. 

Now it is time to import database for Libre Speedtest. Browse to browser and type IP address/phpmyadmin. Here is my demo - http://10.103.8.72/phpmyadmin

If you see this error, you are a lucky person to know the beauty of apache. This is because we haven't configured your phpmyadmin with the apache server well. Type vi /etc/apache2/apache2.conf and in the file please type below command at the end of the file. 

Include /etc/phpmyadmin/apache.conf

Then restart the apache service. “systemctl restart apache2” then refresh the browser. Now it is working. 

Then we will create database named speedtest. Go to New and type name under create database. And then create. 

 

Then we will import the pre configure sql database to newly created speedtest database. The database we will import is in the result directory. So I will download that database (telemetry_mysql.sql) to my local computer with the help of WinSCP. 

Then we will import that database to the speedtest database via phpmyadmin. 

Copy the example-singleServer-full.html  under apache’s index.html.
root@ubuntu:/var/www/html# cp ~/speedtest/example-singleServer-full.html  index.html


Now it is up! Thank you for reading.