Advanced Search
Search Results
50 total results found
List of User
Privilege
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
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
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
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
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
Mysql Slow Query
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 remote add upstream git@gitlab.com:tmukmkd/aaa.git git checkout -b u_master --track upstream/master
Add new user
useradd <username> passwd <username> Enter password
check memory and restart service when less than X gb.
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
curl https://postmaster.mygovuc.gov.my/cgi-bin/myip
change ownership
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
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
## 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
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
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
```$ docker run --name test-mysql -e MYSQL_ROOT_PASSWORD=strong_password -d mysql```
Email relay mygovuc
# 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 update-index --no-assume-unchanged <> git update-index --assume-unchanged <>