Update: updating WordOps with the command wo update appears to have solved the problem. I did not update further with wo stack upgrade and wo maintenance as things are working OK and I don’t want to risk any incompatibilities arising out of the upgrades. …………………………………………………….. This problem started with the WordOps VPS whenever I uploaded
Author: vps-guide
ERROR 1118 (42000) at line : 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.
While migrating to the new server, I had the problem ERROR 1118 (42000) at line : 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. The work-around solution, according to mariadb.com, is to open the .sql file
ERROR 1050 (42S01) at line : Table ‘user’ already exists
I set up a new VPS with WordOps using the guide. However, while inserting the mysql dump into the database, I encountered the error ERROR 1050 (42S01) at line : Table ‘user’ already exists To resolve the issue, I opened the .sql dump file with nano and inserted the following lines at the top. DROP
To run Gsutil with Cron, full path is required
When Gsutil is run manually by the shell, the full path is not required. So, the command gsutil rsync /var/www/BACKUP gs://mybucket is sufficient. However, the cron requires the full path. The path can be located with the command gsutil version -l This yields the output root@server:/var/www# gsutil version -l gsutil version: 5.21 checksum: 74f2cab932617e89e1a88b1b346339f7 (OK)
SendMail: Connection refused by [127.0.0.1]
I followed the procedure to Integrate Amazon SES with Sendmail in Ubuntu as given in the guide. The error log at /var/log/mail.log shows this error: Apr 26 18:57:42 ABC sendmail[21040]: 33QDRMnm021040: to=demo@gmail.com, ct laddr=admin@demo.com (0/0), delay=00:00:20, xdelay=00:00:00, mailer=relay, pri=30060, relay=[127.0.0.1] [127.0.0.1], dsn=4.0.0, stat=Deferred: Connection refused by [127.0.0.1] This error was caused by the wrong placement
AUTH=client, available mechanisms do not fulfill requirements, Deferred: Temporary AUTH failure
I followed the procedure to Integrate Amazon SES with Sendmail in Ubuntu as given in the guide. The error log at /var/log/mail.log shows that “AUTH=client, available mechanisms do not fulfill requirements” and “Temporary AUTH failure“. However, it also showed “Message accepted for delivery“. Apr 26 19:35:46 ABC sm-mta[24892]: 33QE5jZl024892: AUTH=client, available mechanisms do not fulfill
wordops is the best automated LEMP script at present. From the POV of ease of installation, it is much better than Centminmod and Easy Engine. The documentation and guides are also excellent. The site is https://wordops.net/ It requires Ubuntu Server 18.04/20.04/22.04 or Debian 10/11. (1) Install wordops wget -qO wo wops.cc && sudo bash wo
How To Transfer A Web-Site From One Server To Another Using SSH
Step I: Make A Back-Up Of the Old Site Files (Not Including Database) (i) Find the “root” of your site. The easiest way to do is to create a php file (called phpinfo.php) and upload it to your site containing the following: The contents of the php file should be: // Show all information, defaults
Easy to follow Guide to set up a fully functional LEMP stack with linux, nginx, MySQL & PHP to host our website(s)
Check Folder/ Directory Size With SSH + Delete Folder/ Directory With SSH
I backup my files by creating a tar folder and transporting it to a remote location. I use the simple but effective technique documented here. Recently, I was shocked to find that the tar file had bloated to several GB in size. I looked in the public_html folder but could not find any suspicious file.