<?xml version="1.0" encoding="UTF-8"?>
<!-- generator="FeedCreator 1.8" -->
<?xml-stylesheet href="https://kb.jmerari.com/lib/exe/css.php?s=feed" type="text/css"?>
<rdf:RDF
    xmlns="http://purl.org/rss/1.0/"
    xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
    xmlns:slash="http://purl.org/rss/1.0/modules/slash/"
    xmlns:dc="http://purl.org/dc/elements/1.1/">
    <channel rdf:about="https://kb.jmerari.com/feed.php">
        <title>JM Knowledge Base</title>
        <description></description>
        <link>https://kb.jmerari.com/</link>
        <image rdf:resource="https://kb.jmerari.com/_media/wiki/dokuwiki.svg" />
       <dc:date>2026-10-06T13:49:10+00:00</dc:date>
        <items>
            <rdf:Seq>
                <rdf:li rdf:resource="https://kb.jmerari.com/git/cloud-repo-sync?rev=1655912779&amp;do=diff"/>
                <rdf:li rdf:resource="https://kb.jmerari.com/redash?rev=1641627678&amp;do=diff"/>
                <rdf:li rdf:resource="https://kb.jmerari.com/start?rev=1641627245&amp;do=diff"/>
                <rdf:li rdf:resource="https://kb.jmerari.com/linux/index?rev=1635049041&amp;do=diff"/>
                <rdf:li rdf:resource="https://kb.jmerari.com/403.shtml?rev=1635048991&amp;do=diff"/>
                <rdf:li rdf:resource="https://kb.jmerari.com/git/start?rev=1634608473&amp;do=diff"/>
                <rdf:li rdf:resource="https://kb.jmerari.com/ssh?rev=1634578831&amp;do=diff"/>
                <rdf:li rdf:resource="https://kb.jmerari.com/android/start?rev=1620807703&amp;do=diff"/>
                <rdf:li rdf:resource="https://kb.jmerari.com/sql/ddl?rev=1620125792&amp;do=diff"/>
                <rdf:li rdf:resource="https://kb.jmerari.com/alfresco/sitestore?rev=1618652019&amp;do=diff"/>
                <rdf:li rdf:resource="https://kb.jmerari.com/?image=alfresco%3Aaspect.png&amp;ns=alfresco&amp;rev=1614501157&amp;tab_details=history&amp;media_do=diff&amp;do=media"/>
                <rdf:li rdf:resource="https://kb.jmerari.com/?image=alfresco%3Acontenttype.png&amp;ns=alfresco&amp;rev=1614501131&amp;tab_details=history&amp;media_do=diff&amp;do=media"/>
                <rdf:li rdf:resource="https://kb.jmerari.com/?image=wiki%3Aopenjdk.jpg&amp;ns=wiki&amp;rev=1613617412&amp;tab_details=history&amp;media_do=diff&amp;do=media"/>
                <rdf:li rdf:resource="https://kb.jmerari.com/?image=hexpalette.gif&amp;ns=&amp;rev=1595193574&amp;tab_details=history&amp;media_do=diff&amp;do=media"/>
            </rdf:Seq>
        </items>
    </channel>
    <image rdf:about="https://kb.jmerari.com/_media/wiki/dokuwiki.svg">
        <title>JM Knowledge Base</title>
        <link>https://kb.jmerari.com/</link>
        <url>https://kb.jmerari.com/_media/wiki/dokuwiki.svg</url>
    </image>
    <item rdf:about="https://kb.jmerari.com/git/cloud-repo-sync?rev=1655912779&amp;do=diff">
        <dc:format>text/html</dc:format>
        <dc:date>2022-06-22T15:46:19+00:00</dc:date>
        <dc:creator>jmerari (jmerari@undisclosed.example.com)</dc:creator>
        <title>cloud-repo-sync</title>
        <link>https://kb.jmerari.com/git/cloud-repo-sync?rev=1655912779&amp;do=diff</link>
        <description>Sync Git Repo across Cloud Provider

Based on this article. Updated with latest Github requirement of key pair.

On Github Side

	*  Create repo designated as mirror of Bitbucket
	*  Create ssh-ed25519 Keypair for that account, see here
	*  Hold the private and public ready</description>
    </item>
    <item rdf:about="https://kb.jmerari.com/redash?rev=1641627678&amp;do=diff">
        <dc:format>text/html</dc:format>
        <dc:date>2022-01-08T07:41:18+00:00</dc:date>
        <dc:creator>jmerari (jmerari@undisclosed.example.com)</dc:creator>
        <title>redash - created</title>
        <link>https://kb.jmerari.com/redash?rev=1641627678&amp;do=diff</link>
        <description>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 venv</description>
    </item>
    <item rdf:about="https://kb.jmerari.com/start?rev=1641627245&amp;do=diff">
        <dc:format>text/html</dc:format>
        <dc:date>2022-01-08T07:34:05+00:00</dc:date>
        <dc:creator>jmerari (jmerari@undisclosed.example.com)</dc:creator>
        <title>start</title>
        <link>https://kb.jmerari.com/start?rev=1641627245&amp;do=diff</link>
        <description>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 &amp; Restore
		*  Data Type
		*  Data Definition Language
		*  Data Manipulation Language

	*  Java Persistence API
		*  paginated query
		*  native query with JPA

	*  Tomcat &amp; Jetty
		*  JNDI setup
		*  JAAS setup

	*  Struts MVC Framework
		*  CDI
		*  convent…</description>
    </item>
    <item rdf:about="https://kb.jmerari.com/linux/index?rev=1635049041&amp;do=diff">
        <dc:format>text/html</dc:format>
        <dc:date>2021-10-24T04:17:21+00:00</dc:date>
        <dc:creator>jmerari (jmerari@undisclosed.example.com)</dc:creator>
        <title>index - created</title>
        <link>https://kb.jmerari.com/linux/index?rev=1635049041&amp;do=diff</link>
        <description>Check openSUSE version</description>
    </item>
    <item rdf:about="https://kb.jmerari.com/403.shtml?rev=1635048991&amp;do=diff">
        <dc:format>text/html</dc:format>
        <dc:date>2021-10-24T04:16:31+00:00</dc:date>
        <dc:creator>admin (admin@undisclosed.example.com)</dc:creator>
        <title>403.shtml - removed</title>
        <link>https://kb.jmerari.com/403.shtml?rev=1635048991&amp;do=diff</link>
        <description></description>
    </item>
    <item rdf:about="https://kb.jmerari.com/git/start?rev=1634608473&amp;do=diff">
        <dc:format>text/html</dc:format>
        <dc:date>2021-10-19T01:54:33+00:00</dc:date>
        <dc:creator>jmerari (jmerari@undisclosed.example.com)</dc:creator>
        <title>start</title>
        <link>https://kb.jmerari.com/git/start?rev=1634608473&amp;do=diff</link>
        <description>Git Cheat Sheet

Merge Unrelated Histories

Usually happens when just create new repo in Bitbucket and auto create .gitignore. It will conflict with our local repo which hasn't been registered in any external repo.

The error is resolved by toggling the allow-unrelated-histories switch. After a git pull or git merge command, run the following command:</description>
    </item>
    <item rdf:about="https://kb.jmerari.com/ssh?rev=1634578831&amp;do=diff">
        <dc:format>text/html</dc:format>
        <dc:date>2021-10-18T17:40:31+00:00</dc:date>
        <dc:creator>admin (admin@undisclosed.example.com)</dc:creator>
        <title>ssh</title>
        <link>https://kb.jmerari.com/ssh?rev=1634578831&amp;do=diff</link>
        <description>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.

&lt;html&gt;
&lt;iframe src=“&lt;https://docs.google.com/presentation/d/e/2PACX-1vT4Eq9iXe-W1GJ82npXVXk5fn2CDfkVyfeMSgAUhyEehflYMiAeRvI7nxXZBjIvGtjD0AyUYfM3iwYm/embed?start=false&amp;loop=false&amp;delayms=3000&gt;” frameborder=“0” width=“1058” height=“624” allowfullscreen=</description>
    </item>
    <item rdf:about="https://kb.jmerari.com/android/start?rev=1620807703&amp;do=diff">
        <dc:format>text/html</dc:format>
        <dc:date>2021-05-12T08:21:43+00:00</dc:date>
        <dc:creator>jmerari (jmerari@undisclosed.example.com)</dc:creator>
        <title>start</title>
        <link>https://kb.jmerari.com/android/start?rev=1620807703&amp;do=diff</link>
        <description>Android Hacking Notes

Android Service

A Service is an application component that can perform long-running operations in the background. It does not provide a user interface. 
There are 3 kind of service:

	*  Foreground Service. A foreground service performs some operation that is noticeable to the user.</description>
    </item>
    <item rdf:about="https://kb.jmerari.com/sql/ddl?rev=1620125792&amp;do=diff">
        <dc:format>text/html</dc:format>
        <dc:date>2021-05-04T10:56:32+00:00</dc:date>
        <dc:creator>jmerari (jmerari@undisclosed.example.com)</dc:creator>
        <title>ddl - [PostgreSQL] </title>
        <link>https://kb.jmerari.com/sql/ddl?rev=1620125792&amp;do=diff</link>
        <description>SQL Cheat Sheet :: Data Definition Language

Create New Table Structure

MySQL

PostgreSQL

MSSQL

Oracle

Add New Column to Existing Table

MySQL

PostgreSQL

MSSQL


ALTER TABLE table-name ADD column-name
    { type_name [ ( prec [, scale] ) ] [COLLATE &lt;collation name&gt; ]
    [ NULL | NOT NULL ] }</description>
    </item>
    <item rdf:about="https://kb.jmerari.com/alfresco/sitestore?rev=1618652019&amp;do=diff">
        <dc:format>text/html</dc:format>
        <dc:date>2021-04-17T09:33:39+00:00</dc:date>
        <dc:creator>jmerari (jmerari@undisclosed.example.com)</dc:creator>
        <title>sitestore - [Preparation] </title>
        <link>https://kb.jmerari.com/alfresco/sitestore?rev=1618652019&amp;do=diff</link>
        <description>Alfresco :: Separate Store for Each Site

&lt;https://github.com/Acosix/alfresco-simple-content-stores&gt;

Preparation

	*  Shutdown Alfresco service
	*  Create database backup and alf_data folder backup
	*  Create backup of alfresco.global.properties
	*  Create backup of all egov servlet context configuration  (&lt;tomcat&gt;/conf/Catalina/localhost/*.xml)</description>
    </item>
    <item rdf:about="https://kb.jmerari.com/?image=alfresco%3Aaspect.png&amp;ns=alfresco&amp;rev=1614501157&amp;tab_details=history&amp;media_do=diff&amp;do=media">
        <dc:format>text/html</dc:format>
        <dc:date>2021-02-28T08:32:37+00:00</dc:date>
        <dc:creator>jmerari (jmerari@undisclosed.example.com)</dc:creator>
        <title>aspect.png - created</title>
        <link>https://kb.jmerari.com/?image=alfresco%3Aaspect.png&amp;ns=alfresco&amp;rev=1614501157&amp;tab_details=history&amp;media_do=diff&amp;do=media</link>
        <description>&lt;img src=&quot;https://kb.jmerari.com/_media/alfresco/aspect.png?w=500&amp;amp;h=500&amp;amp;tok=a165a6&quot; alt=&quot;aspect.png&quot; loading=&quot;lazy&quot; width=&quot;500&quot; height=&quot;500&quot; /&gt;</description>
    </item>
    <item rdf:about="https://kb.jmerari.com/?image=alfresco%3Acontenttype.png&amp;ns=alfresco&amp;rev=1614501131&amp;tab_details=history&amp;media_do=diff&amp;do=media">
        <dc:format>text/html</dc:format>
        <dc:date>2021-02-28T08:32:11+00:00</dc:date>
        <dc:creator>jmerari (jmerari@undisclosed.example.com)</dc:creator>
        <title>contenttype.png - created</title>
        <link>https://kb.jmerari.com/?image=alfresco%3Acontenttype.png&amp;ns=alfresco&amp;rev=1614501131&amp;tab_details=history&amp;media_do=diff&amp;do=media</link>
        <description>&lt;img src=&quot;https://kb.jmerari.com/_media/alfresco/contenttype.png?w=500&amp;amp;h=500&amp;amp;tok=1d81c8&quot; alt=&quot;contenttype.png&quot; loading=&quot;lazy&quot; width=&quot;500&quot; height=&quot;500&quot; /&gt;</description>
    </item>
    <item rdf:about="https://kb.jmerari.com/?image=wiki%3Aopenjdk.jpg&amp;ns=wiki&amp;rev=1613617412&amp;tab_details=history&amp;media_do=diff&amp;do=media">
        <dc:format>text/html</dc:format>
        <dc:date>2021-02-18T03:03:32+00:00</dc:date>
        <dc:creator>jmerari (jmerari@undisclosed.example.com)</dc:creator>
        <title>openjdk.jpg - created</title>
        <link>https://kb.jmerari.com/?image=wiki%3Aopenjdk.jpg&amp;ns=wiki&amp;rev=1613617412&amp;tab_details=history&amp;media_do=diff&amp;do=media</link>
        <description>&lt;img src=&quot;https://kb.jmerari.com/_media/wiki/openjdk.jpg?w=500&amp;amp;h=500&amp;amp;tok=1d6d7d&quot; alt=&quot;openjdk.jpg&quot; loading=&quot;lazy&quot; width=&quot;500&quot; height=&quot;500&quot; /&gt;</description>
    </item>
    <item rdf:about="https://kb.jmerari.com/?image=hexpalette.gif&amp;ns=&amp;rev=1595193574&amp;tab_details=history&amp;media_do=diff&amp;do=media">
        <dc:format>text/html</dc:format>
        <dc:date>2020-07-19T21:19:34+00:00</dc:date>
        <dc:creator>jmerari (jmerari@undisclosed.example.com)</dc:creator>
        <title>hexpalette.gif - created</title>
        <link>https://kb.jmerari.com/?image=hexpalette.gif&amp;ns=&amp;rev=1595193574&amp;tab_details=history&amp;media_do=diff&amp;do=media</link>
        <description>&lt;img src=&quot;https://kb.jmerari.com/_media/hexpalette.gif?w=500&amp;amp;h=500&amp;amp;tok=87874f&quot; alt=&quot;hexpalette.gif&quot; loading=&quot;lazy&quot; width=&quot;500&quot; height=&quot;500&quot; /&gt;</description>
    </item>
</rdf:RDF>
