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

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

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

 

Create secondary nameserver

Oke, setelah mengulur ngulur waktu untuk hanya posting judul diatas,

alhamdulillah sekarang bisa posting juga.

pertama tama yang harus diperhatikan dalam pembuatan secondary dns, yaitu adanya primary dns.

kita asumsi kan primary dns sudah jalan dengan benar.

selanjutnya lakukan konfigurasi named.conf pada primary dns kita dengan script dibawah.

key "TRANSFER" {
algorithm hmac-md5;
secret "N6xn0GNJsJn3MLMLMLDFAJtY7Cw==";
};
server 182.34.56.xx {
keys {
TRANSFER;
 };
};

konfigurasi diatas berfungsi sebagai alur transfer dns ke IP 182.34.56.xx dengan secret yang sudah digenerate sebelumnya.

kemudian, lakukan konfigurasi pada secondary DNS, dengan konfigurasi script sebagai berikut.

key "TRANSFER" {
 algorithm hmac-md5;
 secret "N6xn0GNJsJn3MLMLMLDFA5VJtY7Cw==";
};
server 182.34.57.xx {
 keys {
 TRANSFER;
 };
};

 

 

ldif_read_file: checksum error on zimbra 8

Oke, selamat siang semuanya,

kali ini saya mendapatkan error pada mail server zimbra 8, dengan error sebagai berikut.

55c81345 ldif_read_file: checksum error on "..."

setelah diselidiki ternyata masalah  pada system database dan logging ldap , selanjutnya saya lakukan solusi dibawah ini :

su - zimbra
zmcontrol stop
cd /opt/zimbra/data/ldap/mdb/db
/opt/zimbra/bdb/bin/db_recover
cd /opt/zimbra/data/ldap
mv mdb mdb.old
mkdir -p mdb/db
mkdir -p mdb/logs
mv mdb mdb.old
ldap start