Mysql dump docker DB one-liner solution
ONE LINER docker exec CONTAINER_NAME /usr/bin/mysqldump -u root –password=PASSWORD DBNAME>FILE_NAME.sql
Read MoreLet’s encrypt (SSL) wildcard domain
Prerequisite Clone master branch from certbot Github repo here Easiest solution cd in to your cloned directory let’s say ~/certbot Set your domain as an env var DOMAIN=mimimi.fun (replace mimimi.fun with your own domain) Run this ./certbot-auto certonly –manual -d *.$DOMAIN -d $DOMAIN –agree-tos –manual-public-ip-logging-ok –preferred-challenges dns-01 –server https://acme-v02.api.letsencrypt.org/directory Follow the instruction given(add TXT record […]
Read MoreKibana create index pattern, error Forbidden
First time tries to create an index pattern in Kibana, after creating an index in elasticsearch, making sure the index name is correct, the ‘creating index pattern’ message just statys there forever. Js console in browser shows an Error: Forbidden. Googling around gives a possible reason: elasticsearch’s index is made read-only and never set back […]
Read MoreRider does not resolve generated code
If you are using protobuf and Rider is not able to resolve generated .cs files in Rider, here is a little bit help. Where is the generated .cs file ./obj/Debug/YOUR_SDK_VERSION/*.cs Why is it not resolved Rider by default does not index obj folder and bin folder so the code inspector fails to find the generated […]
Read MoreDuplicate a MySQL database
When you need to copy a production db to debug or run some tests, you need to copy template data one place to another, you will need this. Simple one liner using mysqldbcopy CLI tool mysqldbcopy –source=username:[email protected]:port –destination=username:[email protected]:port from_db_name:to_db_name –drop-first Comments are welcomed!
Read MoreCreate Linux user for CI/CD(Jenkins here)
Why You often needs to execute shell scripts on the remote machine if you are using Jenkins to do CD to a remote server from your central server. Sometimes you must prefix your command with sudo in order to complete your deployment, here the problem comes, sudo will prompt you to enter password and this […]
Read MoreEF Core missing methods in generated DbContext
Problem Methods like UseSqlServer HasColumnName are not resolved Solution With only EF Core package is not enough, you need two more. Microsoft.EntityFrameworkCore.Design Microsoft.EntityFrameworkCore.SqlServer After installing these two everything works again…
Read MoreA CLI ping statistics tool
PingStats A CLI tool to help with ping logging and simple analyze, notify user when slow connection is detected Github link: https://github.com/Meowzz95/PingStats Sample Output 64 bytes from 192.168.31.1: icmp_seq=405 ttl=64 time=1.147 ms ——————– Fast 393 96.80% [1.878, 1.163, 1.147] Ok 10 2.46% [10.869, 15.297, 15.029] Slow 2 0.49% [62.377, 117.331] SSlow 0 0.00% [] Fail […]
Read MoreMysql set default charset to utf8mb4(to support Chinese characters)
Setup Host: Ubuntu 16.04 Mysql: Ver 14.14 Distrib 5.7.22, for Linux (x86_64) using EditLine wrapper Why Somehow my default charset was set to latin1 which makes all my Chinese characters become question marks. I will have to use utf8mb4 charset to correctly store and display Chinese. Solution edit /etc/mysql/my.cnf Add or edit [mysql] default-character-set=utf8mb4 [mysqld] […]
Read MoreA quick tip on debugging ts-node in WebStorm
Use ts-node to run typescript NodeJS project ts-node saves time to build ts project to js and use node xxx.js to run, it compiles the ts files on the fly but unfortunately, WebStorm does not have an option to debug it Easiest solution I have found Edit the default config, add this in node params […]
Read More