Printah penggunaanya : keluarga debian vim contoh_file.txt centos/rocky vi contoh_file.txt Setelah terbuka untuk bisa mengubah teksnya ketikan atau tekan i pada keyboard Sedangkan untuk Perintah menyimpan dan keluar gunakan perintah tekan ESC pada keyboard lalu tekan :wq pada keyboard ...
View MoreSolusi 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 MoreUse “df -i” command to view inodes usage: Filesystem Inodes IUsed IFree IUse% Mounted on /dev/sda2 1310720 1310720 0 100% / That means you ran out of inodes! Most probably PHP sessions are the issue. A quick command to delete all sess_* files on /var/lib/php/sessions is this: find /var/lib/php/sessions -type f -cmin +24 -name "sess_*" -exec rm -f {} \; But I would recommend you to use a bash script, keep reading below: On your PHP.ini file ...
View MoreOn any server, the logs can start to add up and take considerable amount of disk space. Systemd conveniently stores these in /var/log/journal and has a systemctl command to help clear them. Take this example: $ du -hs /var/log/journal/ 4.1G /var/log/journal/ 4.1GB worth of journal files, with the oldest dating back over 2 months. $ ls -lath /var/log/journal/*/ | tail -n 2 -rw-r-x---+ 1 root systemd-journal 8.0M Dec 24 05:15 user-xxx.journal On this server, I really don't ne ...
View MoreDisable 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 MoreSo, open a terminal and use this command: sudo apt-get install software-properties-commonand then sudo apt-get update ...
View MoreSo in order to to change the plugin back to mysql_native_password: Login with sudo: sudo mysql -u root Change the plugin and set a password with a single command: ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'test'; note test is your password OR ALTER USER root@localhost IDENTIFIED VIA mysql_native_password USING PASSWORD("verysecret") ...
View MoreI managed to sort it myself. As I was using the server provided by my university I had no access to install the required module (HTML::Entities). I decided to then set up the required module on my own Apache web server on a virtual machine and managed to get it working this way after sorting out some syntax/spelling errors. The way I installed the HTML::Entities module was through the synaptic package manager, just by searching libhtml-parser-perl the module was found and installed. I r ...
View More
