JM Knowledge Base
https://www.kb.jmerari.com/
2026-06-06T13:17:44+00:00JM Knowledge Base
https://www.kb.jmerari.com/
https://www.kb.jmerari.com/_media/wiki/dokuwiki.svgtext/html2020-07-20T10:36:35+00:00Anonymous (anonymous@undisclosed.example.com)hexpallete
https://www.kb.jmerari.com/hexpallete?rev=1595241395&do=diff
Hex Pallete Web Safe Color
Color code are always triple twin hex number, e.g. #ff0000 (pure red). So it can also written as #f00. These colors are considered safe to be rendered in all web browsers.
[ Hex Pallete]text/html2020-09-28T11:55:27+00:00Anonymous (anonymous@undisclosed.example.com)howto-docker-mssql
https://www.kb.jmerari.com/howto-docker-mssql?rev=1601294127&do=diff
How to run MSSQL on Linux using Docker
# Pull MSSQL image (version 2017-CU20-ubuntu-16.04)
docker pull mcr.microsoft.com/mssql/server:2017-CU20-ubuntu-16.04
# see list of image in current local repo
docker image ls
# see list of container in current local repo (both runnning and exited)
docker container ls -atext/html2020-07-20T10:36:35+00:00Anonymous (anonymous@undisclosed.example.com)howto-liquibase
https://www.kb.jmerari.com/howto-liquibase?rev=1595241395&do=diff
How to use liquibase
CREATE SNAPSHOT OF CURRENT STATE
1. Edit liquibase.properties, set the following property :
changeLogFile: 20200327.egovprod02.pidsgbt.xml
driver: org.postgresql.Driver
url: jdbc:postgresql://localhost:5432/pidsgbt_egovprod02
username: panasonic
password: panasonictext/html2022-01-08T07:41:18+00:00Anonymous (anonymous@undisclosed.example.com)redash
https://www.kb.jmerari.com/redash?rev=1641627678&do=diff
Install Redash without docker on Centos
* enable Remi repo
* install redis
* install python3
* create redash installation folder, python env, environment variables
* clone redash source code from github
* pull python dependencies in venvtext/html2020-07-20T10:36:35+00:00Anonymous (anonymous@undisclosed.example.com)sidebar
https://www.kb.jmerari.com/sidebar?rev=1595241395&do=diff
* Liquibasetext/html2021-10-18T17:40:31+00:00Anonymous (anonymous@undisclosed.example.com)ssh
https://www.kb.jmerari.com/ssh?rev=1634578831&do=diff
OpenSSH
The following slide is the most essential snippet to understand SSH public/private key. For more comprehensive information, refer to the book SSH Mastery.
<html>
<iframe src=“<https://docs.google.com/presentation/d/e/2PACX-1vT4Eq9iXe-W1GJ82npXVXk5fn2CDfkVyfeMSgAUhyEehflYMiAeRvI7nxXZBjIvGtjD0AyUYfM3iwYm/embed?start=false&loop=false&delayms=3000>” frameborder=“0” width=“1058” height=“624” allowfullscreen=text/html2022-01-08T07:34:05+00:00Anonymous (anonymous@undisclosed.example.com)start
https://www.kb.jmerari.com/start?rev=1641627245&do=diff
START
This is the starting page to the whole unorganized content in this wiki.
* How to use Liquibase
* MSSQL on Linux using Docker
* Java Platform Licensing
* Linux Cheat Sheet
* Git Cheat Sheet
* SQL Cheat Sheet
* Backup & Restore
* Data Type
* Data Definition Language
* Data Manipulation Language
* Java Persistence API
* paginated query
* native query with JPA
* Tomcat & Jetty
* JNDI setup
* JAAS setup
* Struts MVC Framework
* CDI
* convent…