rusman-plat-d

Super duper cool guide for installing MySQL (MariaDB actually) and JDBC on Ubuntu 20.04

1. Install mariadb server using: sudo apt install mariadb-server

2. Install the Java library for MariaDB using: sudo apt install libmariadb-java

3. Start the mariadb service using: sudo /etc/init.d/mysql start

4. Now you will login to the mariaDB and create a new user that does not need root a) Connect to MY-SQL using: sudo mysql -u root

rusman-plat-d

5597 2796
1677 2252
8650 5525
5342 2607
2512 5618
8016 3337
3431 9281
9952 6099
6658 7949
4365 1758

rusman-plat-d

Install the virtualbox manually

sudo apt-get update  
sudo apt-get install virtualbox-6.1  

Sign the modules for secureboot

sudo -i  
mkdir /root/module-signing  
cd /root/module-signing  

rusman-plat-d

{"version":1,"resource":"file:///c%3A/Users/RUSMAN/code/kas-warga/app/Models/Traits/ResponseTrait.php","entries":[{"id":"fZW5.php","source":"Workspace Edit","timestamp":1681680922553}]}

rusman-plat-d

sudo update-alternatives --set php /usr/bin/php8.2 git push origin devel git push gl devel

php artisan migrate:fresh --seed

php artisan ciphersweet:generate-key php artisan ciphersweet:encrypt App\Models\User cb95eac4b1e55f11f4503bb0646a9ea1d0798853260da69bbd1fb9dba290add1 php artisan ciphersweet:encrypt App\Models\User 7a5e9217f08ca6a195f76b2e4b0c95fd9c16602dc4cca4ffae21096b68ec946b

rusman-plat-d

import CryptoJS from "crypto-js";

const LaravelEncrypt = function (key) {
    this.key = key;
}

LaravelEncrypt.prototype.decrypt = function (encryptStr) {
    encryptStr = CryptoJS.enc.Base64.parse(encryptStr);
    let encryptData = encryptStr.toString(CryptoJS.enc.Utf8);
    encryptData = JSON.parse(encryptData);

rusman-plat-d

-- SUMMARY DASHBOARD
-- v_raw_summary_dashboard
select `trans_bsc_detail`.`periode` AS `period`,
    `trans_bsc_detail_perspektif`.`created_at` AS `realisasi_created_at`,
    `trans_bsc_detail_perspektif`.`updated_at` AS `realisasi_updated_at`,
    `log_sasaran_strategis`.`kp_kode` AS `kode_kategori_performansi`,
    concat(
        `log_sasaran_strategis`.`kp_nama`,
        ' (',
        `log_sasaran_strategis`.`kp_kode`,

rusman-plat-d

-- v_summary_dashboard
select `v_raw_summary_dashboard`.`period`,
    `v_raw_summary_dashboard`.`realisasi_updated_at`,
    `v_raw_summary_dashboard`.`kode_kategori_performansi`,
    `v_raw_summary_dashboard`.`kategori_performansi`,
    `v_raw_summary_dashboard`.`kode_1`,
    `v_raw_summary_dashboard`.`sasaran_strategis`,
    `v_raw_summary_dashboard`.`kode_2`,
    `v_raw_summary_dashboard`.`indikator_kinerja_utama`,
    `v_raw_summary_dashboard`.`periode_laporan`,

rusman-plat-d

<VirtualHost 127.0.1.2:80>
	ServerAdmin webmaster@localhost
	ServerName sifadu.desacimenteng.test
	# ServiceAlias sifadu.desacimenteng.test
	DocumentRoot /var/www/html/sl6/public

	<Directory "/var/www/html/sl6/public">
		Options +FollowSymLinks -Indexes
		RewriteEngine On

rusman-plat-d

<VirtualHost 127.0.1.1:80>
	ServerAdmin webmaster@localhost
	ServerName desacimenteng.test
	# ServiceAlias desacimenteng.test
	DocumentRoot /var/www/html/sf6/public

	<Directory "/var/www/html/sf6/public">
		Options +FollowSymLinks -Indexes
		RewriteEngine On