CRATER – Invoice management system (Raspberry)

Install Crater manual

1. Update & Upgrade apt-get update && upgrade -y
2. Cek Hostname lsb_release -d ; hostname ; hostname -I
3. Tambah repository ppa ondrej php add-apt-repository ppa:ondrej/php -y ; apt-get update
4. install apache2, php7.4 beserta extennsion dan mariadb server& Client
   # apt install -y apache2 build-essential mariadb-server mariadb-client php7.4 libapache2-mod-php7.4 php7.4-cli php7.4-fpm php7.4-cgi php7.4-bcmath php7.4-curl php7.4-gd php7.4-intl php7.4-json php7.4-mbstring php7.4-mysql php7.4-opcache php7.4-sqlite3 php7.4-xml php7.4-zip php7.4-snmp php7.4-imap php7.4-common php7.4-tidy php7.4-pgsql php7.4-ldap php7.4-soap php7.4-xsl php7.4-redis php7.4-xmlrpc
5. tambah timezone
   # a2enmod rewrite expires ; sed -i “s/;date.timezone./date.timezone = Asia\/\Kolkata/” /etc/php//apache2/php.ini
6. beri perintah systemct apache2 systemctl start apache2 mariadb ; systemctl enable apache2 mariadb ; mysql_secure_installation
7. Buat database dan usernamedb
   mysql -u root -p
   create database db;
   grant all on db.* to ‘dbuser’@’localhost’ identified by ‘dbpassword’;
   flush privileges;
   quit
8. download aplikasi dengan memasukkan perintah di bawah
   # wget https://craterapp.com/downloads/file/6.0.6 -O crater.zip
9. Unzip berkas dan pindahkan ke html
   # unzip crater.zip ; mv crater /var/www/html/crater
10. beri akses pada direktori html
    # chown -R www-data:www-data /var/www/html/ ; chmod -R 777 /var/www/html/
11. Buat folder yourdomain.conf nano /etc/apache2/sites-available/yourdomain.conf ====Copy kedalam file yourdomain.conf====
    ServerAdmin admin@yourdomain.com DocumentRoot /var/www/html/crater/public ServerName www.yourdomain.com Options FollowSymLinks AllowOverride All Order allow,deny allow from all ErrorLog /var/log/apache2/yourdomain.com-error_log CustomLog /var/log/apache2/yourdomain.com-access_log common
12. beri akses aplikasi dengan alamat ip/domain yang akan menjadi alamat akses
    # a2ensite yourdomain.conf ; a2dissite 000-default.conf ; apache2ctl configtest ; echo “192.168.1.80 www.yourdomain.com” >> /etc/hosts ; systemctl reload apache2

http://www.yourdomain.com/ | SNcAiM7cFLJNjCT

Ref: https://youtu.be/r7i_MzrGJOQ?si=xGIjM3S50BLJyJZL
Lainnya: https://www.youtube.com/watch?v=waheY7LHBdc | https://www.youtube.com/watch?v=i_-iOpvN3tI | https://www.domainesia.com/panduan/cara-export-dan-import-mysql/ (Export database CLI) | https://kinsta.com/knowledgebase/warning-remote-host-identification-has-changed/ (tidak bisa akses ssh cmd)

source image: https://blog.elest.io/content/images/size/w1000/2024/10/elestio-crater-thumbnail.png