How to Disable MySQL Strict Mode
To Disable MySQL Strict Mode, edit vi /etc/my.cnf Add under [mysqld] section sql_mode = “” Verify MySQL Strict Mode To check if…
Blog
Backup Webite to Amazon S3
Create file mkdir /usr/serverok/ vi /usr/serverok/backup-daily.sh Add #!/bin/bash BACKUP_FILE=”backup-`date +%Y-%m-%d`.tgz” /bin/tar –exclude-tag-under=no-backup -zcvhf /backup/$BACKUP_FILE /var/www/html/ aws s3 cp /backup/$BACKUP_FILE s3://S3_BUCKET_NAME/ rm -f…
ModSecurity Web Application Firewall
ModSecurity is a Web Application Firewall. Protect sites from SQL injection and Application level hacking. To install ModSecurity on Ubuntu/Debian with Apache,…
Docker detach container
Docker container stop once the main program it started with stop running. If you start a docker container with console using -ti…
exiqgrep
exiqgrep allows you to search the exim mail queue. To search for a particular recipient, run To search for all emails from…
FreeBSD ports Sucks
During 2004, i used to use FreeBSD 4 and 5 servers. During this time Cpanel Control panel supported FreeBSD. After cpanel stopped…
Installing Software with FreeBSD ports
FreeBSD ports allows installing software from source. Update the tree. This will create /usr/ports if missing. portsnap fetch update portsnap extract Updating…
FreeBSD
Installing Software in FreeBSD with pkg Installing Software with FreeBSD ports Install MySQL 8 on FreeBSD Install Apache/PHP/MySQL on FreeBSD FreeBSD /usr/ports:…
Installing Software in FreeBSD with pkg
pkg command is used to install software in FreeBSD. To update package repo, run pkg update -f Example root@ok-vm:~ # pkg update…
exim
eximrm exiwhat exiqgrep Flush exim mail queue Cpanel Server Block Incoming SPF Failed Mails PHP script to monitor exim mail queue Cpanel…
exiwhat
exiwhat commands shows what exim mail server is doing. [root@server78 ~]# exiwhat 6415 delivering 1emCxq-0001f7-61: waiting for a remote delivery subprocess to…
Find all MySQL databases using InnoDB engine
To find all MySQL database using InnoDB MySQL engine, run mysql -N mysql -e “SELECT table_schema FROM INFORMATION_SCHEMA.TABLES WHERE engine = ‘innodb’;”…