Skip to content

Instantly share code, notes, and snippets.

View hgc81538's full-sized avatar

hgc81538

View GitHub Profile
@hgc81538
hgc81538 / gist:c6c9a016c525e0d979cc8bd8b91c166d
Created August 10, 2023 08:50
Accessibility
https://www.magentaa11y.com/
https://userway.org/audit/ (JAWS + Chrome, NVDA + Firefox, VoiceOver + iOS)
@hgc81538
hgc81538 / README.md
Last active June 23, 2023 04:28
fortify issue
@hgc81538
hgc81538 / git copy commited files to location
Last active April 3, 2023 08:42
# 1 commit
cp --parents `git diff-tree -r --no-commit-id --name-only --diff-filter=ACMRT $commit_id` ../output
# between commits
cp --parents `git diff-tree -r --no-commit-id --name-only --diff-filter=ACMRT $commit_id_start $commit_id_end` ../output
# reference
https://stackoverflow.com/questions/4541300/export-only-modified-and-added-files-with-folder-structure-in-git
https://stackoverflow.com/questions/29300910/how-to-send-output-of-ls-l-to-cp-command-using-pipes
@hgc81538
hgc81538 / bash.sh
Created June 28, 2019 05:18
Bash batch processing
for file in *.png; do convert $file -rotate 90 rotated-$file; done
# ref: https://www.howtogeek.com/109369/how-to-quickly-resize-convert-modify-images-from-the-linux-terminal/
@hgc81538
hgc81538 / setup_pc_steps.txt
Created June 7, 2018 07:24
PC setup steps
- install windows
- show file extension
- install chrome, classic shell, office, dropbox, firefox, thunderbird, filezilla (no bundle), libreoffice, notepad++, 7-zip (assign all archive extensions)
- show delete confirmation of rubbish bin
- power to high, no sleep
- remove microsoft store, mail in quick launch
- show all icons in tray
- disable onedrive
- use traditional photo viewer
- add outlook shortcut in desktop
@hgc81538
hgc81538 / gist:d54e0938d4a6274e6fca39e5a79cda23
Last active January 4, 2018 04:51
Server log sample for exceptions

linux

shutdown

Jan  4 11:05:44 HIDDEN kernel: hv_utils: Shutdown request received - graceful shutdown initiated

windows

shutdown

@hgc81538
hgc81538 / gist:7e20c0badae7db7bae2696201216b7fa
Last active April 17, 2018 07:23
ubuntu 16.04 high concurrent connection
/etc/sysctl.conf
net.core.somaxconn = 8192
net.ipv4.tcp_max_syn_backlog = 8192
// mysql
Connection failed: SQLSTATE[HY000] [1040] Too many connections
Connection failed: SQLSTATE[HY000] [2002] Resource temporarily unavailable
fix:
/etc/systemd/system/mysql.service
@hgc81538
hgc81538 / gist:ced674849971790f8d3b
Last active March 19, 2024 07:13
MySQL create database and user in command line
# mysql 8 / mariadb 10.11
mysql -u root
CREATE DATABASE <database_name> CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
CREATE DATABASE <database_name> CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
CREATE USER '<username>'@'localhost' IDENTIFIED BY '<password>';
GRANT ALL PRIVILEGES ON <database_name>.* TO '<username>'@'localhost';
flush privileges;
@hgc81538
hgc81538 / gist:b3f71475ad0b5297d897
Created June 15, 2015 10:47
Wordpress manually set 404
<?php
global $wp_query;
$wp_query->set_404();
status_header(404);
include '404.php';
exit;
@hgc81538
hgc81538 / gist:1566cabd816bb27bb254
Last active August 29, 2015 14:06
ERROR: While executing gem ... (ArgumentError) invalid byte sequence in UTF-8
In Windows environment, the error is occured when executing "gem install compass" in cygwin.
$ gem install compass
ERROR: While executing gem ... (ArgumentError)
invalid byte sequence in UTF-8
How to solve:
1) open C:\cygwin\usr\share\ruby\2.0.0\win32\registry.rb
(change to your version when necessary)
2) comment out line 172 and change "\r" to "\r\n" in line 173 (line numbers may vary)