Apr 07 2021

How to check permissions in Reporting Services programmatically

get-all-permissions-SQL-reporting-servicesOne 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-logoWebmin 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:

Continue reading

Mar 11 2021

Vicidial Wrong Statistics in realtime report

Vicidial-realtime-report-wrong-dataThe 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

webmin-logoThe 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”

Continue reading

Mar 02 2021

How to Setup WebRTC on ViciDial and enable ViciPhone

VicidialThis 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

Edit Grub Boot OptionsSingle 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

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’

Fail2banUpon 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

Load more