Posted inHowto

How To Delete All WordPress Pending Comments Using MySQL

In some of WordPress based blogs, I get more than 10000 (10k) comments, which all of them spams. Using WordPress UI to delete comment is not an easy task, because we’re limited to delete 20 comment per actions. Instead of installing random plugin, let’s do it via SQL (MariaDB/MySQL) query. Inside the WordPress database it […]

Posted inHowto

Nginx Warning http2 directive is deprecated

After upgrade to the nginx 1.26 on Debian 12, sudo nginx -t throw some warning issue in the nginx config $ sudo nginx -t nginx: [warn] the "listen … http2" directive is deprecated, use the "http2" directive instead in /etc/nginx/sites-enable/atetux.conf:7 for now that not a issue, just a warning. But it’s better to fix it […]

Posted inHowto

How To Use pip on read-only System

Many of the Kubernetes cluster and Docker on production, have a policy to run on read-only system for all the directory except certain explicit folder that customizable by user. In read-only file system, not all of the application can run smooth by default, but trivial to fix as well. For this tutorial lets take pip […]

Posted inHowto

Update Keycloak Password Using kcadm.sh

kcadm.sh is the admin CLI for Keycloak, we can do most of the operation using this script. Download the Keycloak file, kcadm.sh are inside that file. wget https://github.com/keycloak/keycloak/releases/download/24.0.1/keycloak-24.0.1.tar.gz extract the keycloak-24.0.1.tar.gz tar zxvf keycloak-24.0.1.tar.gz Move to the folder bin cd keycloak-24.0.1/bin run the kcadm.sh Optional: Run Keycloak on Docker If you didn’t have a Keycloak […]

Posted inHowto

Setup Superset 3 with Keycloak 24 SSO

Superset is a powerfull analytic web-based tools, that had support many databases, it’s good for data exploration and visualization. In this tutorial we’ll start from scratch to install Keycloak and Superset Superset version 3.1.1 Keycloak version 24.0.1 The configuration should work for any environment, docker, kubernetes or VPS. But keep in mind on the PATH […]

Posted inHowto

How to Setup Vault on Kubernetes

Vault is one of the most used secret solution in the Kubernetes, it’s used by big player. Vault is application that store, and tightly control access to tokens, passwords, certificates, encryption keys for protecting secrets, and other sensitive data using a UI, CLI, or HTTP API. We can use Vault for different use case, but […]

Posted inHowto

How To Setup Read-Only Kubernetes Dashboard

Kubernetes Dashboard it’s really helpfull for sharing the URL with team mate or anyone, because by share the URL we can see the same thing. We don’t need to ask people to open their terminal and poking around looking for logs. prerequisite: – Kubernetes cluster – helm – kubectl Create a namespace monitoring for a […]

Posted inHowto

How To Update Docker Image UID/GID User

Many companies with dedicated security team, requires the UID user used by docker images greater than 1000 to avoid conflict with host id. By default, Linux will assign 1000 UID for the first non-root non-system user account. For docker images that use ENTRYPOINT we need to use the command # command is command line that […]