How to Fix

How to Fix

Issue :
ERROR 1201 (HY000): Could not initialize master info structure for ”; more error messages can be found in the MariaDB error log

Resolution :
MariaDB [(none)]> RESET SLAVE;

And then try again run the command

Isseu :
Bagaimana cara mencari dan mencantumkan ukuran file di Linux?

Resolution :
Gunakan perintah ls -lh /Lokasi/direktori/

Example :
[root@clt2 ~]# ls -lh /opt/
total 4.0K
drwxr-xr-x. 2 root root 4.0K Mar 26 2015 rh
[root@clt2 ~]# ls -lh
total 292K
-rw-r–r– 1 root root 290K Jul 14 07:58 poweradmin-2.1.7.tgz
[root@clt2 ~]#

Issue : 
Bagaimana cara saya melihat details tentang RAM atau memory yang saya gunakan di Linux ?

Resolution :
Gunakan perintah : lshw -short -C memory

Jika perintah itu belum dikenali silahkan install dulu paketnya

Example : 
[root@VMnode1 ~]# lshw -short -C memory
H/W path Device Class Description
=====================================================
/0/1 memory 128KiB BIOS
/0/5/6 memory 256KiB L1 cache
/0/5/7 memory 1MiB L2 cache
/0/5/8 memory 8MiB L3 cache
/0/35 memory System Memory
/0/35/0 memory 8GiB DIMM DDR3 Synchronous 1333 MHz (0.8 ns)
/0/35/1 memory DIMM DDR3 Synchronous [empty]
/0/35/2 memory 8GiB DIMM DDR3 Synchronous 1333 MHz (0.8 ns)
/0/35/3 memory DIMM DDR3 Synchronous [empty]
/0/35/4 memory DIMM DDR3 Synchronous [empty]
/0/35/5 memory DIMM DDR3 Synchronous [empty]
/0/36 memory Flash Memory
/0/36/0 memory 2MiB Chip FLASH Non-volatile
/0/0 memory
/0/2 memory

Issue :

Dependent row(s) ‘smb_roles.id = 1’ isn’t found for ‘smb_users.roleId = 1’
Masalahnya terjadi karena tabel smb_roles kosong

How to Fix

Resolution :

Dump the Plesk database and smb_roles table:
[root@Node03 ~]# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -uadmin psa > /root/psa.`date +%Y%m%d.%H%M%S`.sql
[root@Node03 ~]# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -uadmin psa smb_roles > /root/psa.smb_roles.`date +%Y%m%d

Add the default Plesk smb roles:
[root@Node03 ~]# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin

MariaDB [(none)]> use psa
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [psa]> INSERT INTO `smb_roles` VALUES (1,’Admin’,1,1);
Query OK, 1 row affected (0.01 sec)

MariaDB [psa]> INSERT INTO `smb_roles` VALUES (2,’WebMaster’,0,1);
Query OK, 1 row affected (0.00 sec)

MariaDB [psa]> INSERT INTO `smb_roles` VALUES (3,’Application User’,0,1);
Query OK, 1 row affected (0.00 sec)

MariaDB [psa]> INSERT INTO `smb_roles` VALUES (4,’Accountant’,1,1);
Query OK, 1 row affected (0.00 sec)

MariaDB [psa]> INSERT INTO `smb_roles` VALUES (5,’Mail User’,0,1);
Query OK, 1 row affected (0.00 sec)

MariaDB [psa]>

Issue :

413 Request Entity Too Large

Resolution :

Change client_max_body_size for example :

client_max_body_size 2M;

And then reload the ngeinx service

[root@Node03 ~]# systemctl restart nginx.service

Add a Comment