MySql doesn’t work in the mysql.pid file under Proxmox LXC

agaprasetya Leave a comment

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

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

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

finally found a solution, because the host under LXC Proxmox, I suspect the mysql.pid 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, mysql.pid is running normally.

PERMIT LOGIN SQLPLUS WITH PASSWORD ON ORACLE DB #REDHAT

agaprasetya Leave a comment

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

vim SQLNET.ORA

add the script below

SQLNET.AUTHENTICATION_SERVICES= (none)

save, run the command reload oracle database

lsnrctl reload

 

Tertipu dan habiskan waktu dengan Media Online

agaprasetya Leave a comment

Di era digital seperti saat ini, kita begitu kepo dengan dunia luar, selalu ingin tahu dan mencari tahu, semakin banyak media online bertebaran bebas di dunia maya, sangat mudah dijangkau dengan hanya mempunyai kuota internet sebesar biji jagung, bandwith sebesar biji jagung saja sudah bisa pergi ke Amerika Serikat melalui bantuan Instagram, melihat keindahan kota disana, mengurusi sikap dan sifat orang orang disana, empati dan sugesti terhadap orang yang belum pernah berjabat tangan dengan kita semakin tinggi.