PHP dan Mariadb Acces Denied Ga Mau Konek di Almalinux

Pesan **SELinux AVC denial** ini menunjukkan bahwa **PHP-FPM** (dengan konteks `httpd_t`) diblokir oleh SELinux saat mencoba terhubung ke socket MySQL (`/var/lib/mysql/mysql.sock`). Ini terjadi karena konteks keamanan SELinux tidak mengizinkan proses PHP-FPM untuk mengakses socket MySQL. Berikut adalah langkah-langkah untuk memperbaiki masalah ini: --- ### 1. **Periksa Konteks SELinux**Periksa konteks SELinux untuk socket MySQL:```bashls -Z /var/lib/mysql/mysql.sock```Contoh output:```srwxrwxrwx ...

View More
  Dibaca 252 kali

mariadb ketika import error gini Row size too large (> 8126) solusinya ?

Solusi Ke 1 : The error message Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline. means that the row size of a table in MySQL is larger than the maximum row size of 8126 bytes. This can happen if the table has a lot of columns, or if the columns are of a data type that takes up a lot of space, such as VARCHAR or TEXT. To fix this error, you can try the following: Change some columns to TEXT or BLOB.&nb ...

View More
  Dibaca 2639 kali

MySQL Bin Files Memakan Banyak Space Hardisk Server

Disable MySQL binlogging If you are not replicating, you can disable binlogging by changing your my.ini or my.cnf file. Open your my.ini or /etc/my.cnf (/etc/mysql/my.cnf), enter:# vi /etc/my.cnfFind a line that reads “log_bin” and remove or comment it as follows: #log_bin = /var/log/mysql/mysql-bin.log You also need to remove or comment following lines: #expire_logs_days = 10 #max_binlog_size = 100M Close and save the fi ...

View More
  Dibaca 1169 kali