Ubuntu Setup

install mysql-server
create user 'hub'@'localhost' IDENTIFIED BY 'The-Best-WAY-2024';
create user 'hub'@'localhost' IDENTIFIED BY 'The-Best-PROD-2024';
grant all privileges on *.* to 'hub'@'localhost';
FLUSH PRIVILEGES;

apt install ca-certificates apt-transport-https software-properties-common
add-apt-repository ppa:ondrej/php
apt update
apt install php8.3 php8.3-common php8.3-xml php8.3-intl php8.3-mysql php8.3-zip php8.3-curl 

php -r "copy('https://getcomposer.org/installer', 'composer-setup.php');"
php composer-setup.php
php -r "unlink('composer-setup.php');"
mv composer.phar /usr/bin/composer <-- 2204 guna usr bin. 2004 guna usr local bin
composer install

php8.3-common 
php8.3-mysql 
php8.3-xml 
php8.3-xmlrpc 
php8.3-curl 
php8.3-gd 
php8.3-imagick 
php8.3-cli 
php8.3-mbstring 
php8.3-opcache 
php8.3-zip 
php8.3-redis 
php8.3-intl
php8.3-fpm
 -y
 
 -- nginx
 
 server {
    listen 80;
    server_name server_domain_or_IP;
    root /var/www/travellist/public;

    add_header X-Frame-Options "SAMEORIGIN";
    add_header X-XSS-Protection "1; mode=block";
    add_header X-Content-Type-Options "nosniff";

    index index.html index.htm index.php;

    charset utf-8;

    location / {
        try_files $uri $uri/ /index.php?$query_string;
    }

    location = /favicon.ico { access_log off; log_not_found off; }
    location = /robots.txt  { access_log off; log_not_found off; }

    error_page 404 /index.php;

    location ~ \.php$ {
        fastcgi_pass unix:/var/run/php/php8.1-fpm.sock;
        fastcgi_index index.php;
        fastcgi_param SCRIPT_FILENAME $realpath_root$fastcgi_script_name;
        include fastcgi_params;
    }

    location ~ /\.(?!well-known).* {
        deny all;
    }
}

-- local git
[core]
        repositoryformatversion = 0
        filemode = true
        bare = false
        logallrefupdates = true
        ignorecase = true
        precomposeunicode = true
[remote "origin"]
        url = git@gitlab.com:myopensoft/sprm-pesalah-rasuah.git
        fetch = +refs/heads/*:refs/remotes/origin/*
[branch "main"]
".git/config" 13L, 315B
[core]
        repositoryformatversion = 0
        filemode = true
        bare = false
        logallrefupdates = true
        ignorecase = true
        precomposeunicode = true
[remote "origin"]
        url = git@gitlab.com:myopensoft/sprm-pesalah-rasuah.git
        fetch = +refs/heads/*:refs/remotes/origin/*
[branch "main"]
        remote = origin
        merge = refs/heads/main
~