List sizes of MySQL databases

Do you wonder which databases are actually taking up how much space but only have one huge ibdata1 in your /var/lib/mysql and the directories inside your mysql data directory don’t represent the actual database sizes? Run from a mysql root console: mysql> SELECT table_schema AS “Database name”, SUM(data_length + index_length) / 1024 / 1024 AS … Read more

Mount Slaved Drive

Sometimes your OS needs to be reinstalled by your datacenter. This means that you need to mount the slaved drive in order to copy the data to the new OS drive. Here is a typical example: Login to the server and run the following to see whats mounted: As we can see above, there is … Read more

MySQL does not start after an Plesk update (14-March, 2017)

Note: article describes the issue caused by MySQL update from Atomic repository, make sure you have Atomic repository enabled before applying fix: After update MySQL cannot be started. In Plesk the following error message is shown: or There are no records in /var/log/mysqld.log Cause Atomic issued broken mysql package to their repositories. During updates installation … Read more

Create swap file for SAN running FreeNAS 9.3

Some instances, the iscsi connection fails. This may be due to swap space. Adding a swap file can help. How to create a swap file. Pre-9.3 NAS loses iSCSI or NFS/CIFS connectivity arbitrarily From NAS /var/log/messages: Aug 15 22:24:01 nas kernel: pid 29173 (smbd), uid 65534, was killed: out of swap space Aug 15 22:27:11 … Read more

Connecting to your Storage Volume using ISCSI

The Open-iSCSI project is a high performance, transport independent, multi-platform implementation of RFC3720 (The iSCSI specification). It consists of a minimal set of kernel modules combined with powerful userspace utilities. Once installed on a system, a daemon process iscsid can be controlled using the iscsiadm management utility. Open-iSCSI requires a Linux kernel of 2.6.16 or … Read more

Installing Microsoft CALS’s

You will need to add the Remote Desktop role first. https://support.microsoft.com/en-us/help/2833839/guidelines-for-installing-the-remote-desktop-session-host-role-service-on-a-computer-running-windows-server-2012-without-the-remote-desktop-connection-broker-role-service After doing so you can continue installing the CAL license following these steps. 1. Click on Start->Administrative Tools->Remote Desktop Services->Remote Desktop Licensing Manager 2. Click on “All Servers” and right click on the server you want to add the RDS CALs to and click … Read more

Installing R1Soft Linux Manager Server on CentOS

The first step to install the Server Backup Manager is to create a new YUM .repo file with the R1Soft repository information.  Save the file in the yum.repos.d directory (typically located in /etc/). Add the following: Verify what was written to the file by running ‘cat /etc/yum.repos.d/r1soft.repo’ Now that the repo is added, run ‘yum … Read more

Installing the R1Soft Linux Agent on CentOS

The first step required for installing the agent is to configure the YUM repository. Modify the repository as follows: Or… Add… Save the files and then run ‘yum install serverbackup-agent’: Next, restart the agent: Next, we need to get the Server Backup Manager Server key from the Manager server: NOTE: If the server manager is … Read more

R1soft-setup –get-key failed

When adding the key – Error message Note: When configuring the R1Soft Manager – http and https ports were set using the command: Thus, the following command should work when setting up the key on the agent server to the Manager server: You can manually configure the key by doing the below steps: 1) Login … Read more