<\/span><\/h2>\nFirst, you will need to install Apache web server, MariaDB server, PHP and other libraries on your server. You can install all of them with the following command:<\/p>\n
apt-get install apache2 mariadb-server php7.2 php7.2 libapache2-mod-php7.2 php7.2-common php7.2-sqlite3 php7.2-json php7.2-curl php7.2-intl php7.2-mbstring php7.2-xmlrpc php7.2-mysql php7.2-gd php7.2-xml php7.2-cli php7.2-zip php7.2-soap php7.2-imap wget unzip -y<\/pre>\nOnce all of the packages are installed, open the php.ini<\/code> file and make some changes:<\/p>\nnano \/etc\/php\/7.2\/apache2\/php.ini<\/pre>\nChange the following lines:<\/p>\n
memory_limit = 256M\r\n\r\nupload_max_filesize = 100M\r\n\r\npost_max_size = 100M\r\n\r\nmax_execution_time = 60\r\n\r\nmax_input_vars = 1500\r\n\r\ncgi.fix_pathinfo=0\r\n\r\ndate.timezone = Europe\/London\r\n#example timezone, change to your local timezone<\/pre>\nSave and close the file when you are finished.<\/p>\n
<\/span>Step 3: Configure MariaDB<\/span><\/h2>\nBy default, MariaDB is not secure. Before continuing, we recommend going through a short program that helps secure your MariaDB server. You can secure it with the following command:<\/p>\n
mysql_secure_installation<\/pre>\nAnswer all the questions as shown below:<\/p>\n
Enter current password for root (enter for none):\r\n Set root password? [Y\/n]: Y\r\n Remove anonymous users? [Y\/n]: Y\r\n Disallow root login remotely? [Y\/n]: Y\r\n Remove test database and access to it? [Y\/n]: Y\r\n Reload privilege tables now? [Y\/n]: Y<\/pre>\nOnce MariaDB has been secured, log in to the MariaDB shell with the following command:<\/p>\n
mysql -u root -p<\/pre>\nProvide your MariaDB root password that you set earlier. Then create a database and user for YetiForce with the following commands:<\/p>\n
MariaDB [(none)]> CREATE DATABASE yetiforce;\r\n\r\nMariaDB [(none)]> GRANT ALL PRIVILEGES ON yetiforce.* TO 'yetiforce'@'localhost' IDENTIFIED BY 'password<\/span>';<\/pre>\nDon’t forget to replace ‘password<\/span>‘ with an actual strong password. After running those two commands, flush the privileges and exit from the MariaDB shell with the following commands:<\/p>\nMariaDB [(none)]> FLUSH PRIVILEGES;\r\n\r\nMariaDB [(none)]> \\q<\/pre>\n