Lik`s forum

BorgBackup (short: Borg) is a deduplicating backup program. Optionally, it supports compression and authenticated encryption.

The main goal of Borg is to provide an efficient and secure way to backup data. The data deduplication technique used makes Borg suitable for daily backups since only changes are stored. The authenticated encryption technique makes it suitable for backups to not fully trusted targets.

GitHub borgbackup/borg

Installation instructions can be found at official documentation page.
For tests we ...

Noticed strange warning recently during the work with MySql:

Code: Select all

# mysqladmin pr
Warning: Using unique option prefix pass instead of password is deprecated and will be removed in a future release. Please use the full name instead.
+-------+------+-----------+----+---------+------+-------+------------------+
| Id    | User | Host      | db | Command | Time | State | Info             |
+-------+------+-----------+----+---------+------+-------+------------------+
| 41269 | root | localhost |    | Query   | 0    |       | show processlist |
+-------+------+-----------+----+---------+------+-------+------------------+

# mysql ...

Suppose, you have Awstats available and enabled by default for all users under "WHM -> Server Configuration -> Statistics Software Configuration".
For some reason you want to exclude one account from statistics update (web service access log parsing for it) and you can do it via:

* WHM interface

"WHM -> Server Configuration -> Statistics Software Configuration -> User Permissions -> Choose Users"
Choose Specific Stats Programs for: accountname
Here you can specify which stats ...

Suppose, you need phpMyAdmin running on your server to provide simple web interface for end users for MySql databases management and perform regular updates with cron task.
First step is to create separate system user in order to enhance security:

Code: Select all

useradd phpmy

Next step is to clone STABLE branch of PhpMyAdmin from the official PhpMyAdmin SCM Git repository:

Code: Select all

sudo -u phpmy -H git clone --single-branch --depth=1 -b STABLE https://github.com/phpmyadmin/phpmyadmin.git /home/phpmy/public_html

"sudo -u" is used to ...

To view configure options of MySql server we can use handy 'mysqlbug' utility which among other information reports options MySql server was compiled with:
# mysqlbug

Finding system information for a MySQL bug report
test -x /bin/vi
Using editor /bin/vi
You can change editor by setting the environment variable VISUAL.
If your shell is a bourne shell (sh) do
VISUAL=your_editors_name; export VISUAL
If your shell is a C shell (csh) do
setenv VISUAL your_editors_name
File ...

You can install PEAR modules required for SMTP authentication using the following command syntax:

Code: Select all

pear install --alldeps Mail Net_SMTP Auth_SASL Net_Socket

If you are running several PHP installations on your server:

Code: Select all

whereis pear

Code: Select all

/usr/bin/pear install --alldeps Mail Net_SMTP Auth_SASL Net_Socket

Obtain directory/file listing of remote FTP from the CLI interface using curl:

Code: Select all

curl -X "LIST -la 9.0/*" -u anonymous:ftp@example.com --url ftp://ftp.freebsd.org/pub/FreeBSD/releases/ISO-IMAGES/

Output example:
drwxrwxr-x 2 980 100 1536 Jan 05 2012 .
drwxrwxr-x 5 980 100 512 Jul 15 03:33 ..
lrwxr-xr-x 1 980 100 45 Jan 05 2012 CHECKSUM.MD5-amd64 -> ../../amd64/amd64/ISO-IMAGES/9.0/CHECKSUM.MD5
lrwxr-xr-x 1 980 100 43 Jan 05 2012 CHECKSUM.MD5-i386 -> ../../i386/i386/ISO-IMAGES/9.0/CHECKSUM.MD5
lrwxr-xr-x 1 980 100 43 Jan 05 2012 CHECKSUM.MD5-ia64 -> ../../ia64/ia64/ISO-IMAGES/9.0/CHECKSUM.MD5
lrwxr-xr-x ...

Warning: The resulting partition is not properly aligned for best performance.

In order to align partition with parted you can use --align option. Valid alignment types are:

none - Use the minimum alignment allowed by the disk type.
cylinder - Align partitions to cylinders.
minimal - Use minimum alignment as given by the disk topology information. This and the opt value will use layout information provided by the disk to align the logical partition table ...

You can re-generate self-signed SSL certificates for cPanel services from the CLI interface with the help of the following script:

Code: Select all

/usr/local/cpanel/bin/checkallsslcerts

Example of the command output:

Self Signed SSL Certificate for ftp does not match current hostname! (srv1.example.com != srv1.newdomain.com).
Creating new Certificate and Key for ftp....Done
Self Signed SSL Certificate for exim does not match current hostname! (srv1.example.com != srv1.newdomain.com).
Creating new Certificate and Key for exim....Done
Self Signed SSL Certificate for dovecot does ...

Load Averages


CloudLinux has a modified way to calculated load averages, as processes can wait on CPU because of LVE limits, and not because of lack of CPU resources. Previously, our LA algorithm was ignoring uninterruptable processes. You can now switch to another LA algorithm that accounts for uninterruptable processes by running:

Code: Select all

echo N > /sys/module/lve/parameters/lve_unint_hack

This line can be added to /etc/rc.local to make sure it is executed on startup ...