Konfigurasi Server Ubuntu 18.40 untuk Codeigniter 3 php7.2

sudo apt update -y
sudo apt install nginx mariadb-server mariadb-client php-fpm php-cgi php-common php-pear php-mbstring phpmyadmin php-gettext -y

sudo mysql_secure_installation

sudo nano /etc/nginx/sites-available/default

server {
        listen 80 default_server;
        listen [::]:80 default_server;
        root /var/www/html;
        index index.php index.html index.htm index.nginx-debian.html;

        server_name example.com www.example.com;
        location ~ \.php$ {
                include snippets/fastcgi-php.conf;
                fastcgi_pass unix:/var/run/php/php7.2-fpm.sock;
        }
}

Web server <ok>
dbconfig-common? <no>


sudo systemctl restart nginx.service

sudo ln -s /usr/share/phpmyadmin /var/www/html


If you get error #1698 – Access denied for user ‘root’@’localhost’

sudo mysql -u root

use mysql;
update user set plugin='' where User='root';
flush privileges;
exit;

sudo systemctl restart mariadb.service




phpmyadmin warning libraries/sql.lib.php#613

sudo cp /usr/share/phpmyadmin/libraries/sql.lib.php /usr/share/phpmyadmin/libraries/sql.lib.php.bak
sudo nano /usr/share/phpmyadmin/libraries/sql.lib.php

Press CTRL + W and search for (count($analyzed_sql_results['select_expr'] == 1)

Replace it with ((count($analyzed_sql_results['select_expr']) == 1)

Save file and exit. (Press CTRL + X, press Y and then press ENTER)



function PMA_isRememberSortingOrder($analyzed_sql_results)
{
    return $GLOBALS['cfg']['RememberSorting']
        && ! ($analyzed_sql_results['is_count']
            || $analyzed_sql_results['is_export']
            || $analyzed_sql_results['is_func']
            || $analyzed_sql_results['is_analyse'])
        && $analyzed_sql_results['select_from']
        && ((empty($analyzed_sql_results['select_expr'])) ||
        (count($analyzed_sql_results['select_expr']) == 1)
                    && ($analyzed_sql_results['select_expr'][0] == '*'))
        && count($analyzed_sql_results['select_tables']) == 1;
}


Warning in ./libraries/plugin_interface.lib.php#551

sudo cp /usr/share/phpmyadmin/libraries/plugin_interface.lib.php /usr/share/phpmyadmin/libraries/plugin_interface.lib.php.bak
sudo nano /usr/share/phpmyadmin/libraries/plugin_interface.lib.php

Press CTRL + W and search for if (! is_null($options) && count($options) > 0) {

If not found, try search for if ($options != null && count($options) > 0)

Replace with if (! is_null($options) && count((array)$options) > 0) {



sudo apt install curl vsftpd ufw -y

sudo service vsftpd status

sudo ufw allow OpenSSH
sudo ufw allow 20/tcp
sudo ufw allow 21/tcp
sudo ufw allow 80/tcp
sudo ufw allow 'Nginx HTTP'
sudo ufw allow 40000:50000/tcp
sudo ufw allow 990/tcp
sudo ufw enable
sudo ufw status

chown -R www-data:www-data /var/www/html/

optional==================================================
sudo adduser vps1
sudo nano /etc/ssh/sshd_config
DenyUsers vps1
sudo service sshd restart

chown -R www-data:www-data /var/www/html/

sudo chown vps1:vps1 /var/www/html

sudo usermod -d /var/www/html vps1
sudo mkdir /home/vps1/ftp
sudo chown nobody:nogroup /home/vps1/ftp


sudo cp /etc/vsftpd.conf /etc/vsftpd.conf.bak
sudo nano /etc/vsftpd.conf
write_enable=YES
sudo systemctl restart vsftpd

try_files $uri $uri/ /index.php?$args;

===========================================================


nano /etc/php/7.2/cli/php.ini
nano /etc/php/7.2/fpm/php.ini

upload_max_filesize = 32M
post_max_size = 48M
memory_limit = 512M
max_execution_time = 600
max_input_time = 1000
max_input_vars = 3000

php-fpm7.2 -t
service php7.2-fpm restart