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
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