MySql doesn’t work in the file under Proxmox LXC

This problem occurs when mysql doesn’t work in the file
on CentOS 7 with LVM storage under LXC,

User access rights and permissions are not defined in the file.

when giving access to chown and chmod it can’t be solved the server responds to “permission denied”

finally found a solution, because the host under LXC Proxmox, I suspect the file is corrupt.

I did “fsck” on centos and the result is blank there is no feedback when I run fsck.

because centos runs under LXC then I do fsck in proxmox by pointing it based on the Centos ID.

and then, I am successful, is running normally.


Database security is very important to us as a database system administrator.

when the install feels easy indeed, but we need to note what will happen after the database system is installed and ready for production by the user.

In this case I will share only additional knowledge in oracle database security.

by default oracle open the login permissions without a password on the server, with like let’s add the settings when login sqlplus must with password, do it like this.

The first thing to do is go to the directory


cd $ORACLE_HOME/network/admin

open file SQLNET.ORA


add the script below


save, run the command reload oracle database

lsnrctl reload


Reverse proxy Nginx to Apache

On one day I was baffled by the previous become Backend apache web server, then an error occurs on the java code as the gateway of the Nginx web server,

that where apache and nginx is located on a different port,

therefore I added the following scheme, assuming that the server nginx forward the packet to the Apache web server:

location / {
   proxy_set_header X-Forwarded-Host $host;
   proxy_set_header X-Forwarded-Server $host;
   proxy_set_header X-Forwarded-For 
   proxy_pass; #apache port

Then reload or restart the service Nginx

service nginx restart

Build and Redirect Vhost to mobile version #Nginx

Kali ini saya akan sharing sekedar pengalaman setelah memakai web server Nginx.

Dimana yang diminta adalah ketika user akses suatu website atau root website, user tersebut akan dialihkan ke website versi mobile dengan catatan mereka akses via gadget atau device mobile.

web server yang saya terapkan disini adalah Nginx, skema sebagai berikut :

  • Skema pertama kita buat terlebih dahulu virtual host sebagai root domain.
  • skema kedua siapkanlah subdomain sebagai nama domain/web versi mobile
  • skema ketiga setup kondisi dalam virtual host root domain agar dia mendeteksi device yang akan meng akses root domain/web.
  • skema ke empat lakukan redirect permanent dalam root domain menuju ke subdomain versi mobile.

Demikian skema diatas, untuk lebih jelasnya bisa langsung tanyakan melalui kolom komentar atau via email di .