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 07 2021
How to check permissions in Reporting Services programmatically
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
Mar 09 2021
Virtualmin: no Manage SSL certificate option
The problem is that you want to enable SSL certificate for virtual domain in Virtualmin but the Manage SSL certificate option is absent from the Server Configuration. By default Manage SSL option is absent and you need to enable it in Features. To do so go toEdit Virtual Server -> Enabled Features, and set “Apache SSL website enabled”
Mar 02 2021
How to Setup WebRTC on ViciDial and enable ViciPhone
This is the complete guide on configuring WebRTC on ViciBox 8 and 9. Upon completing this guide you will have WebRTC and ViciPhone enabled on ViciDial.
The WebRTC configuration on ViciDial will consists of four main steps:
1 – setup SSL for the webserver (Apache)
2 – setup TLS in Asterisk built-in webserver
3 – Configure WebRTC and enable ViciPhone in ViciDial
4 – Use of PBXWebPhone as webrtc phone (optional) Continue reading
Feb 12 2021
How to Boot Single User Mode in RedHat/CentOS
Single User Mode (sometimes known as Maintenance Mode) is a mode in Unix-like operating systems such as Linux operate, where a handful of services are started at system boot for basic functionality to enable a single superuser perform certain critical tasks.
It is runlevel 1 under system SysV init, and runlevel1.target or rescue.target in systemd. Importantly, the services, if any, started at this runlevel/target varies by distribution. It’s generally useful for maintenance or emergency repairs (since it doesn’t offer any network services at all), when a computer is not capable of normal operations.
Once you have decided to enter single user mode for maintenance or recover from crash you will need to VNC to the server or in other words emulation of physical console. Don’t worry about logging into the server at this point, since this process will need you to reboot the server.
The process is the same for both RedHat/CentOS 7 and 8
Once you issue the hard reboot, you may need to click Refresh in the top right of the VNC screen since the hard reboot will reset that connection. You need to click this refresh very quickly otherwise you will miss the boot screen where you can interrupt the boot process. Continue reading
Feb 02 2021
How to Boot Single User Mode in Ubuntu
Single User Mode (sometimes known as Maintenance Mode) is a mode in Unix-like operating systems such as Linux operate, where a handful of services are started at system boot for basic functionality to enable a single superuser perform certain critical tasks.
It is runlevel 1 under system SysV init, and runlevel1.target or rescue.target in systemd. Importantly, the services, if any, started at this runlevel/target varies by distribution. It’s generally useful for maintenance or emergency repairs (since it doesn’t offer any network services at all), when a computer is not capable of normal operations.
Once you have decided to enter single user mode for maintenance or recover from crash you will need to VNC to the server or in other words emulation of physical console. Don’t worry about logging into the server at this point, since this process will need you to reboot the server.
Once you issue the hard reboot, you may need to click Refresh in the top right of the VNC screen since the hard reboot will reset that connection. You need to click this refresh very quickly otherwise you will miss the boot screen where you can interrupt the boot process. Continue reading
Jan 28 2021
MSSQL SSISDBBackup.bak could not be accessed
If you get the error SSISDBBackup.bak could not be accessed while creating an Integration Services Catalog, it could be because you do not have Integration Services installed on your SQL Server instance. Below I am going to attempt and create an Integration Services Catalog, by right clicking the item within SSMS and choosing Create Catalog. If you are going to run/manage many SSIS packages, using a catalog makes life a lot easier. Continue reading
Jan 18 2021
Fail2ban: Found no accessible config files for ‘filter.d/sshd-ddos’
Upon enabling ssh-ddos jail in Fail2ban jail.local you may have the following errors:
Jail ‘sshd-ddos’ skipped, because of wrong configuration: Unable to read the filter ‘sshd-ddos’
and
Found no accessible config files for ‘filter.d/sshd-ddos’
The reason is that Continue reading
Stay tuned! :)
