Terima Kasih
Telah Berkunjung, Semoga Website ini bermanfaat
How to Install MySQL 5.7 on Ubuntu 20.04 LTS
Introduction MySQL is the world’s most popular open source relational database management system. It is widely used with web server like apache2,Nginx,IIS,etc. MySQL has client/Server architecture , supports InnoDB storage engine,can be installed on various operating system like Ubuntu,Debian,CentOS,Windows.,etc. Step #1: Add MySQL APT Repository in Ubuntu Ubuntu comes with…
Cannot open the disk Reason: The parent virtual disk has been modified since the child was created.
mismatch, modified, parent CID, snapshot, virtual machine, vmware, vsphere If you get the following error when starting a virtual machine you can try the solution given below: “Message on VMName: Cannot open the disk ‘/vmfs/volumes/Volume-ID/VM Name/VMName-000001.vmdk’ or one of the snapshot disks it depends on. Reason: The parent virtual disk has been modified since the child…
Secure Connection Failed An error occurred during a connection to xxx Peer using unsupported version of security protocol. Error code: SSL_ERROR_UNSUPPORTED_VERSION
Browser FIrefox I was having that same issue in Firefox, after checking the answer of Brando Zhang, I try only changing the "security.tls.version.enable-deprecated" to true (in about:config) and it worked! That way, you don't have to lower the TLS security version
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…
Set Up MariaDB Master-Slave Replication with Galera Cluster on Ubuntu
Previously, we discussed how to set up MariaDB Galera cluster on Ubuntu and how to encrypt replication traffic in Galera cluster. In this tutorial, we will be learning how to add an asynchronous replication slave to Galera cluster, which means the Galera cluster will be acting as a master. Galera Cluster As a…