Andy Wits Blog

All blog posts

How to migrate a corporate website-store Wordpress + Woocommerce to October CMS + oc-Mall 7 minute read

This post shares a developer’s journey from Laravel to October CMS, and now to Winter CMS. It covers setup steps, recommended plugins and themes, and how to migrate content and blog posts from WordPress. The post also explains configuring a local dev environment, building a store, and exporting static pages with a semi-automated script.

Simple script for backup of mysql databases 1 minute read

So, we have a task: On vps-server N mysql database M is running needed: backup with a given frequency. Solution. Let's write a BASH script using mysqldump and put it in cron #!/bin/bash ### variables user=USER pass=PASS bakdir="/path/to/backups/" echo "------ start ------" echo "-----------------------&quot...

How to configure Let's Encrypt on the VestaCP admin interface (8083 port) with CA use 2 minute read

It is assumed that you have a valid domain (the so-called FQDN), which you can use to enter the admin area. In my case, OVH provided a free domain of the form ns123456.ip-x-y-z.eu, which means that I can use it to enter the admin area: https://ns123456.ip-x-y-z.eu:8083/ Step-by-step set up Let's Encrypt on the VestaCP admin panel (8083 po...

Best way to install Nginx incubator pagespeed to Ubuntu Vesta CP 9 minute read

For modesty, I must say that this is in my opinion the best practice at the moment. Step 1. Preparation: package management - dependencies for build nginx pagespeed First, you need to check that there is a string in the package sources with "deb-src" for nginx. Open (or create) target file from sources.list.d/ nano /etc/apt/sources.list.d/nginx.li...

Howto fix bug "rsync: Failed to exec ssh -p No such file or directory" 1 minute read

I installed VS Code for my PHP Programming tasks and found Sync-Rsync package in marketplace. But, option "sync-rsync.shell": "ssh -p 1234" wasn't work... Visual Studio Code with Sync-Rsync: Failed to exec ssh -p No such file or directory And console output: rsync: Failed to exec ssh -p 1234: No such file or directory (2) rsync error: error in ...

Bash script in one line to check free space in Linux 1 minute read

This task arose after the client sites were moved from the old VPS to the new one. On the new virtual server, everything is fine with the processor and the RAM, but the disk space is very close. It turned out that Vesta CP, which by default creates 3 backups, just filled the disk to zero. The client asked me that when the place becomes small - it immediately became known. So I decided to...

Why Sphinx does not work on Ubuntu / Debian? 1 minute read

If the sphinx service is started, but the search on the site does not produce anything (and an no error), the problem can be as follows: systemctl status sphinxsearch When checking the status of the service - pay attention to the line ... ... To enable sphinxsearch, edit /etc/default/sphinxsearch and set START=yes ... In this cas...

Error: mod_fcgid: HTTP request length 137536 (so far) exceeds MaxRequestLen (131072) 1 minute read

After installing the panel ISPmanager Lite 5.126.2 with a trial license for 2 weeks (this is convenient, since during this time you can safely buy and activate the license), I ran into this error. In this case, ** php is configured in FastCGI mode **. When I try to start a web application, I get (in logs or in debug): mod_fcgid: HTTP request length 132992 (so far) exceeds ...

Speed optimization of one wordpress website 2 minute read

For one client, I worked on optimization. Server configuration: CentOS + ISP Manager + Nginx. Here are the steps that helped to speed up WordPress. 1. Compression and Caching Enabled compression and caching (for 45 days) in the panel under domain settings. Effectively, these are the Nginx settings in the config file: /etc/nginx/vhosts/example.com/ex...

Where plesk 17 (onyx) store dkim public key? 1 minute read

How to find postfix public domainkey in plesk server for dkim dns settings? After plesk dkim activation any services (like opendkim) not required. The keys store in «/etc/domainkeys/», but public dkim keys do not store. We can easily generate them: # openssl rsa -in /etc/domainkeys/somedomain.tld/default -pubout -out /etc/domainkeys/somedomain.tld/public # writing...

How to change Mysql database collation for Jira on the Ubuntu + Plesk server 2 minute read

The Collation health check has failed in your system This message was showed by Jira, some time after installation. This was due to the fact that the database and user were created by the regular tools of the Plesk panel (the same would happen in many other cases), and the database with tables in it received collation "utf8_general_ci", which was used in Mysql by default....

Templates for Yii2 on Vesta CP for backend and frontend versions. 1 minute read

So, I had problems with manual editing of configs in the Vesta CP (which it constantly rewrites, when something changes or is updated), I set out to make a more or less automated solution. It did not work very nicely, because it is necessary that the backend and the frontend look in the same folder as the subfolders. This can not be achieved only by editing templates. This can be underst...

Contact me on