Month: August 2022
Mengatasi Masalah Zmclamdctl Is Not Running
Mengatasi Masalah Zmclamdctl Is Not Running, ini terjadi ketika restart semua service zimbra, tiba-tiba clamd tidak jalan. Jika dilakukan pengecekan pengecekan pada zimbra.log muncul seperti berikut pada log: 1 2 3 4 Mar 14 00:01:08 mail amavis[523]: (00523-01) (!)connect to /opt/zimbra/data/clamav/clamav.sock failed, attempt #1: Can't connect to a UNIX socket /opt/zimbra/data/clamav/clamav.sock:…
Getting error “Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed” when starting MySQL
Check error : /var/run/mysqld/mysqld.err Jika pesan error : Plugin 'InnoDB' registration as a STORAGE ENGINE failed Solusi : Login to server via SSH with root access. Navigate to /var/lib/mysql. If you see log files like, ib_logfile0 and ib_logfile1, rename or move them to some other folder. Stop and start the…
Mengembalikan Tabel MySQL dari file .ibd, .frm dan mysqllogbin
Saya akhirnya menemukan dan menyelesaikan masalah saya melalui banyak trial and error. Bagi mereka yang tidak memiliki file ibdata1 asli mereka, dan hanya memiliki file .frm dan .ibd, inilah cara saya memulihkan data saya. Unduh dan instal utilitas MySQL di -> http://dev.mysql.com/downloads/utilities . Pergilah ke perintah/terminal Anda untuk membuka utilitas MySQL, mysqlfrm,…
How to configure DoS protection’s quarantine/elapse/reset time Fortigate
Description This article describes how to configure DoS protection’s quarantine/elapse/reset time for thresholds based on the number of concurrent sessions. For example. Solution Default TCP source concurrent session is 5000, no timer will be set by default, and sessions will be blocked as long as they exceed 5000 concurrent sessions.…
Mengatasi Error mysqldump: Couldn’t execute ‘SHOW VARIABLES LIKE ‘gtid\_mode”: Table ‘performance_schema.session_variables’ doesn’t exist
Beberapa hari yang lalu, ketika saya sedang ada kelas dengan mata kuliah Perancangan Basis Data, diberi tugas untuk melakukan insert data ke dalam table yang ada pada database. Kemudian untuk pengumpulan tugas tersebut harus dilakukan export database menjadi sebuah file sql. Ketika melakukan export dengan mysqldump, tiba-tiba muncul error “mysqldump:…
How to mysqldump All Databases Excluding Information_Schema
If you want to back up your MySQL databases you’ll be familiar with 1 mysqldump -uroot -p --all-databases > dump.sql However this includes the information_schema, mysql and performance_schema databases. These are often not only unwanted in the dump, but can potentially cause issues on import. To exclude these databases from your dump use the…
Run Multiple PHP versions with Nginx on Ubuntu & Change Version php
First of all, we will install other PHP versions on our server. If you followed our guide on setting up Nginx with PHP-FPM on Ubuntu, you might have PHP7.2 installed on your server. CHECK THE CURRENT PHP VERSION Whatever the case is, you must know the PHP version that is…
Ubuntu – apt-get update fails “The repository no longer has a Release file”
The Issue Running sudo apt-get update or sudo apt update fails with the following or similar errors: Hit:1 http://apt.postgresql.org/pub/repos/apt eoan-pgdg InRelease Ign:2 http://archive.ubuntu.com/ubuntu eoan InRelease Ign:3 http://archive.ubuntu.com/ubuntu eoan-updates InRelease Ign:4 http://archive.ubuntu.com/ubuntu eoan-backports InRelease Ign:5 http://archive.ubuntu.com/ubuntu eoan-security InRelease Err:6 http://archive.ubuntu.com/ubuntu eoan Release 404 Not Found [IP: 91.189.88.142 80] Err:7 http://archive.ubuntu.com/ubuntu eoan-updates Release 404 Not Found…