Install SIMRS Khanza di server Ubuntu 20.04

Persiapan server

apt update
apt install apache2 mariadb-server php phpmyadmin
systemctl enable apache2
systemctl enable mariadb
systemctl start apache2
systemctl enable mariadb

Persiapan database

mysql_secure_installation
Enter current password for root (enter for none): 
Set root password? [Y/n] y
New password: 
Re-enter new password: 
Remove anonymous users? [Y/n] y
Disallow root login remotely? [Y/n] y
Remove test database and access to it? [Y/n] y
Reload privilege tables now? [Y/n] y

Setting database supaya bisa diakses dari komputer lain

nano /etc/mysql/mariadb.conf.d/50-server.cnf
Disable bind-address = 127.0.0.1 dengan cara tambah tanda # di depan barisnya
Kemudian disimpan

Atur user database

mysql -uroot -p
USE mysql
GRANT ALL PRIVILEGES ON *.* TO 'client' IDENTIFIED BY '123456' WITH GRANT OPTION;
FLUSH PRIVILEGES;
exit

Buat database sik

mysql -uroot -p
CREATE DATABASE sik;
exit

Download database dan install di mysql

wget -c https://github.com/mas-elkhanza/SIMRS-Khanza/blob/master/sik.sql
mysql -uroot -p sik < sik.sql

Download webapps simrs khanza

https://github.com/mas-elkhanza/SIMRS-Khanza/tree/master/webapps
pindahkan folder webapps ke /var/www/html
kemudian setting configurasi databasenya
nano /var/www/html/webapps/conf/conf.php
db_hostname = "localhost"
db_username = "client"
db_password = "123456"