MySQL show connections with MyTOP

mytopMyTOP is an utility for tracking performance and connections to MySQL/MariDB servers. The interface is very similar to top utility. Further examples is performed in CentOS 6 x64 operating system.

First of all we need to plug Epel repository:

Continue reading

How To Set Up SSH Keys

SSH keys provide a more secure way of logging into a virtual private server with SSH than using a password alone. While a password can eventually be cracked with a brute force attack, SSH keys are nearly impossible to decipher by brute force alone. Generating a key pair provides you with two long string of characters: a public and a private key. You can place the public key on any server, and then unlock it by connecting to it with a client that already has the private key. When the two match up, the system unlocks without the need for a password. You can increase security even more by protecting the private key with a passphrase. Continue reading

Install Bash-Shell in favour of Ash-Shell on Padavan’s firmware

,RT-N14UThe thing I needed is an amazing Dropbox-Uploader script from Andrea Fabrizi be installed on my Asus RT-N14U router with Padavan’s firmware. Dropbox-Uploader needs Bash shell to run so i had to install it. I assume Entware is already enabled in your router in Advanced Settings –> USB Apllication –> Allow Run Optware? as on the screenshot below:

Continue reading

You Do Not Appear to Have the Sources for Kernel Installed

If you get the following error “You Do Not Appear to Have the Sources for Kernel Installed” (or similar) when trying to build Asterisk or DAHDI you have to install the kernel devel / kernel headers. This post covers kernel headers and kernel source installation for Debian, Ubuntu, Red Hat/Fedora/CentOS systems.
Asterisk Build Errors Related to Kernel Headers / Devel: Continue reading

Password Protect with .htaccess and .htpasswd

With .htaccess and .htpasswd we can protect even individual page or file on webserver. To password protect an individual file: Continue reading

MariaDB(MySQL) Master-Master Replication

MariaDB_Master-Master_Replication

I’m going to develop my cluster further and create MariaDB(MySQL) geo-cluster by enabling MariaDB(MySQL) Master-Master Replication. I’ve already deployed MariaDB cluster in the second datacenter (nodes 4, 5 and 6) and now I need to configure Master-Master replication between two MariaDB clusters. The replication will take place between node 1 (first datacenter, we will name it Master1) and node 4 (second datacenter, we will name it Master2).

First of all we need to check a couple of variables that may impact or break replication.  Continue reading

MariaDB Galera three nodes cluster on CentOS 6

mariadb-galera-cluster-centos-6

Let’s build MariaDB Galera cluster with three nodes on CentOS x64 6.7 Minimal.
On all nodes static IP adresses have been configured.
Node1- 10.20.20.11
Node2 – 10.20.20.12
Node3 – 10.20.20.13

On all nodes we need to install necessary packages: Continue reading

Cloned Hyper-V CentOS6 Server error “device eth0 does not seem to be present, delaying initialization”

In order to have 3 identical nodes for my MariaDB Galera cluster, I cloned a hyper-v install of CentOS6 and after firing up the clone and trying to start networking received the error: “device eth0 does not seem to be present, delaying initialization

We need to get the list of current eth devices:

Continue reading

Failed to sync data for Routing group {8EC325CB-B512-587D-9D03-E940E7CC1490} from backup store

After a fresh deployment of Skype for Business Server 2015  on a Windows Server 2012  the Lync Server Front-End service fails to start:

image

Reviewing the Skype for Business Server 2015 event logs show the following events: Continue reading

Lync Server 2013 Event ID 14649 Error 0x800B0109(CERT_E_UNTRUSTEDROOT)

After the December update Windows Server 2012 no longer trust the certificate that is trusted before. Certificate from RapidSSL is fully in order. In Lync Deployment Wizard certificate is also displayed correctly and without errors. First stop service Lync Server Access Edge was recorded on December 18. Immediately after applying the latest updates for Windows Server 2012 .:) Continue reading

Load more