Here is how you can check certificate validity and troubleshoot TLS connection issues using OpenSSL client command-line utility: Continue reading
Jan 06 2025
Microsoft SQL Server Reporting Services (SQLRS): how to get a list of permissions for each report
To retrieve a list of all reports on a Microsoft SQL Server Reporting Services (SSRS) instance along with the security principals that have permissions on each report, you can query the SSRS database. SSRS uses a database (commonly named ReportServer
) to store metadata about reports and their security settings.
Use the following query to get the list of reports and their associated security principals:
Continue reading
Oct 25 2024
Microphone not working, privacy setting off, “managed by your organization”
Windows don’t let to turn a microphone on because of “some settings are hidden or managed by your organization” . A PC is a personal PC on home network. There are a few reasons for this: Continue reading
Oct 01 2024
Connection timeout to sts.amazonaws.com: pecularity of AWS STS PrivateLink Integration Issue with Lambda & Boto3
I have a Python-based Lambda function in VPC with an VPC endpoint creates for Amazon STS. However I could not connect to STS with timeout error:
Jul 19 2024
FreePBX Letsencrypt certificate expired
Recently Letsencrypt certificate expired on one of my FreePBX servers. It supposed to update itself automatically as it is set in cron file for “asterisk” user. Continue reading
Jun 28 2024
TypeError: Argument 1 passed to Carbon\CarbonInterval::setLocalTranslator()
You may encounter the following error after updating through WHMCS v8.0:
1 |
TypeError: Argument 1 passed to Carbon\CarbonInterval::setLocalTranslator() must implement interface Symfony\Component\Translation\TranslatorInterface |
May 21 2024
PowerShell List Memory Usage by IIS Application Pools
If you need quick overview on RAM usage of you IIS application pools you can use the following Powershell command to retrieve the information: Continue reading
May 16 2024
Zabbix Agent: Active vs. Passive Modes
When it comes to Zabbix agent modes, there is a choice between the active and the passive modes. Each time new items or hosts are added in the front end, you need to choose the item type.
This is mandatory as the item type determines how the item will work and collect data. For the Zabbix agent, there is a choice between ‘Zabbix agent (passive)’ and ‘Zabbix agent (active)’. Continue reading
May 14 2024
Laravel Relation “Attempt to read property on null”
It usually means that the related record is NULL or soft-deleted. There are multiple ways to gracefully handle such a situation, without showing the error to the user.
A practical example would be a list of Posts with belongs To relation to Categories.
Migration file for Posts:
1 2 3 |
Schema::table('posts', function (Blueprint $table) { $table->foreignId('category_id')->nullable()->constrained(); }); |
Apr 30 2024
SQL Reporting Services. HTTP Error 503 The service is unavailable
After I installed new certificate using SQL RS Configuration Manager upon opening any report I see the following:
In comparison to this case the root cause is the same: when binding a certificate Configuration Manager creates shitty URL bindings like Continue reading