Skip to main content
Advanced Search
Search Terms
Content Type

Exact Matches
Tag Searches
Date Options
Updated after
Updated before
Created after
Created before

Search Results

50 total results found

List of User

MyIPO SPHI Database

Privilege

MyIPO SPHI Database

PTO_IT Role Privilege SELECT * FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'PTO_IT'; GRANTEE GRANTED_ROLE ADMIN_OPTION DELEGATE_OPTION DEFAULT_ROLE COMMON INHERITED PTO_IT PTO_IT_ROLE NO NO YES NO NO   System Privilege SELECT * FROM ...

NGINX Cheat Sheet

Web Server NGINX

Server Block Structure # Define a server block (listens on port 80 by default for HTTP) server { listen [port]; # Optional, default is 80 server_name example.com www.example.com; root /path/to/root; index index.html; } Location Block # Define ...

psql Command

Postgresql Database

General \copyright show PostgreSQL usage and distribution terms \crosstabview [COLUMNS] execute query and display results in crosstab \errverbose show most recent error message at maximum verbosity \g [FILE] or ; exec...

Embed Dashboard to External Application Using JWT

Tableau Embed Dashboard

Install PHP dependency composer require firebase/php-jwt Controller (For Yii2 Framework) use Firebase\JWT\JWT; // Tableau Server configuration $tableauServer = "https://YOUR_TABLEAU_SERVER"; $clientId = "YOUR_CLIENT_ID"; // From the Connected App $s...

Pre Development Template

Template

Requirement Gethering Template Requirement Gathering Template.docx Requirement Gathering Template [SAMPLE].docx User Requirement Specification User Requirement Specification Template.docx User Requirement Specification Template [SAMPLE].docx Sist...

Post Development Template

Template

Mysql Slow Query

MySQL

vi /etc/my.cnf slow_query_log = 1slow-query-log-file = /var/log/mysql-slow.loglong_query_time = 2 touch /var/log/mysql-slow.log chown mysql:mysql /var/log/mysql-slow.log systemctl restart mysqld

add upstream git channel

Git

git remote add upstream git@gitlab.com:tmukmkd/aaa.git git checkout -b u_master --track upstream/master

Add new user

Linux

useradd <username> passwd <username> Enter password

check memory and restart service when less than X gb.

Linux

bash#!/bin/bash # Get the available memory in KBfree_mem_kb=$(free -k | grep Mem | awk '{print $4}') # Convert to GB (divide by 1024^2)# without bcfree_mem_gb=$((free_mem_kb / 1024 / 1024))# with bc# free_mem_gb=$(echo "scale=2; $free_mem_kb / (1024 * 1024)"...

check server dah lepas pada postmaster

Mail

curl https://postmaster.mygovuc.gov.my/cgi-bin/myip

change ownership

Linux

basic chown <user>:<group> <option> <path> chown www-data:wheel -R /var/www/html/project_name   -R = recursive change own from one of the user or group only chown -R --from=root nginx /var/www/html/cms chown -R --from=:root :nginx /var/www/html/cms

ckeditor 5

Javascript

https://www.jsdelivr.com/package/npm/ckeditor5-classic-free-full-feature https://cdn.jsdelivr.net/npm/ckeditor5-classic-free-full-feature@35.4.1/build/ckeditor.min.js  ClassicEditor.create(document.querySelector('#editor'))            .then(editor => {      ...

composer 1 memory limit

PHP

## issuecomposer will run into memory limit due to memory leak when checking lot of package. ## solution: ### temporary usage unlimited memory php -d memory\_limit=-1 /usr/local/bin/composer require prettus/l5-repository /usr/bin/composer php -d memory\_l...

Connection Refused MySQL

MySQL

https://chatgpt.com/share/67b548c2-8cc8-8013-ab45-89a4457eed65 1. sudo nano /etc/my.cnf>     ensure bind address = 0.0.0.0 >     sudo systemctl restart mysql ensure # skip-networking is commentedensure #block_encryption_mode and check ssl version compatible ...

Curl

Linux

simple curl GET ``shcurl "https://api.onesignal.com"`` simple curl POST ``shcurl -X "POST" "https://api.onesignal.com"`` curl with json request and header ``shcurl -X "POST" "https://iems.kpdn.gov.my/oauth/token" \     -H 'Content-Type: application/json; ...

Docker

MySQL

```$ docker run --name test-mysql -e MYSQL_ROOT_PASSWORD=strong_password -d mysql```

Email relay mygovuc

Mail

# check ip tu ada akses atau tak ```curl https://postmaster.mygovuc.gov.my/cgi-bin/myip``` # telnet (windows / linux) using CMD * ``telnet postmaster.mygovuc.gov.my 25``* ``EHLO bmt.mampu.gov.my``* ``MAIL FROM: shaiful@mampu.gov.my``* ``RCPT TO: mampu2288@...

git assume unchange

Git

git update-index --no-assume-unchanged <> git update-index --assume-unchanged <>