Enabling the Slow Query Log for MySQL or MariaDB can be a useful tool to diagnose performance and efficiency issues affecting your server such as MySQL high CPU load. By identifying queries that are particularly slow in their execution, you can address them by restructuring the application that triggers your queries. You can also rebuild the queries themselves to ensure that they are constructed as efficiently as possible. Continue reading
Jun 23 2021
LetsEncrypt certificates automatic renewal in Azure Application Gateway
I can bet almost any IT technician have heard of Letsencrypt certificates. They are completely free and fully supported by big corps such as Google, Facebook, Microsoft, and many others, to have a more secure and privacy-respecting Web. A lot of public websites are using those certificates. Of course, as for any free stuff, there are some limitations. For example how many certificates you can generate. Pay attention that Let’s Encrypt certificates are valid for 90 days. So setting up automatic renewal of Letsencrypt certificates is absolutely necessary.
When using an Azure Application Gateway, one of the things you need to do is to install the SSL certificate on the gateway to secure resources behind.
In this article I’ll show you how to set up Letsencrypt certificates automatic renewal in Azure Key Vault and Azure Application Gateway. Continue reading
May 05 2021
Goautodial Logging in to your phone. Please wait
The Gotodial was installed from ISO and agent had issue logging in. The login screen was hanging with the
Logging in to your phone. Please wait…
message.
At that moment I did not have Letsencrypt certificate on Gotodial installed so it operated with default, self-signed certificate.
In /var/log/messages
there was the following: Continue reading
May 05 2021
Goautodial Login to Dialer button doesnt work
After I set up Letsencrypt certificate in Goautodial box, pointed Apache and Kamalio to it (edited /etc/httpd/conf.d/ssl.conf
and /etc/kamalio/tls.conf
respectively), restarted the services with
1 2 |
service httpd restart service kamalio restart |
I tried to log in to dialer but when I clicked Login to Dialer absolutely nothing happens. No error, the button doesnt work so an agent cannot login to dialer.
Continue reading
May 05 2021
Letsencrypt Unable to find a virtual host listening on port 80
I installed Goautodial where access via HTTPS was configured “out-of-the-box” with self-signed certificate. HTTP access was configured through like default website in Apache without using VirtualHost
directive.
I tried to get a certificate from Letsencrypt and got the following error:
Unable to find a virtual host listening on port 80 which is currently needed for Certbot to prove to the CA that you control your domain. Please add a virtual host for port 80. Continue reading
Apr 30 2021
Failed to add /run/systemd/ask-password to directory watch: No space left on device
Upon installing Azure log collecting agent on Ubuntu machine I encountered the following error:
Failed to add /run/systemd/ask-password to directory watch: No space left on device
df
command showed a lot of space so it’s not about a space itself but about inodes. Continue reading
Apr 07 2021
How to check permissions in Reporting Services programmatically
One day we found that we need to check users and groups permissions on SQL Reporting Services to understand who has access to what. So the next question is how to get all permissions in SQL Reporting Services programmatically and possibly export them to Excel for future analysis. After some time searching I ended up with the following SQL query: Continue reading
Apr 05 2021
Virtualmin upgrade MariaDB 5.5 to 10.2
Webmin hosts on CentOS 7 come with MariaDB 5.5 by default. If you need to upgrade it MariadDB the following guide will help you to do this step-by-step. Prior to start an upgrade MariaDB 5.5 to 10.2 on the Webmin host there will be a few preliminary but very important steps.
Before you do anything make a backup of your current databases: Continue reading
Mar 26 2021
RPC failed; curl 55 OpenSSL SSL_write: Connection was aborted, errno 10053
When tried to execute git push
I got the following error:
RPC failed; curl 55 OpenSSL SSL_write: Connection was aborted, errno 10053
The full error message:
1 2 3 4 5 6 7 8 9 10 |
Enumerating objects: 17, done. Counting objects: 100% (17/17), done. Delta compression using up to 4 threads Compressing objects: 100% (6/6), done. error: RPC failed; curl 55 OpenSSL SSL_write: Connection was aborted, errno 10053 send-pack: unexpected disconnect while reading sideband packet Writing objects: 100% (9/9), 11.03 MiB | 540.00 KiB/s, done. Total 9 (delta 1), reused 0 (delta 0), pack-reused 0 fatal: the remote end hung up unexpectedly Everything up-to-date |
Mar 11 2021
Vicidial Wrong Statistics in realtime report
The symptom is that Vicidial shows incorrect data in Realtime Reports: minutes and seconds are zeros and there are no other colors except for “Agent waiting for call”.
To fix this check the following: Continue reading