Here is how you can check certificate validity and troubleshoot TLS connection issues using OpenSSL client command-line utility:
Category: Simple about IT
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 …
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:
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 …
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(); }); |
Mar 30 2024
Cloudmin passthrough CPU information to VM
I have Rocket Chat in VM hosted in Cloudmin that relies on qemu. When I tried to update Rocket Chat to the latest version I got the following error: Your cpu does not support avx or avx2 instructions, which is required to run mongo 5.x, shipped with the next version of this snap.
Feb 08 2024
MariaDB fails to start: Aria engine is not enabled or did not start
After low space condition once happened on a server MariaDB failed to start with :
1 2 3 4 5 |
[ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables [ERROR] Aborting ... mariadb.service: main process exited, code=exited, status=1/FAILURE Failed to start MariaDB 10.3.32 database server. |
In /var/log/messages:
1 2 3 4 5 6 |
[ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables [Note] mysqld: Aria engine: starting recovery recovered pages: 0% 10% 20% 30% 40% 50% 60% 70% 80%201210 16:07:56 [ERROR] mysqld got signal 11 ; [ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'" |
Feb 02 2024
Clean and reduce size of Zabbix database
After some time you may find that you Zabbix database become enormously big and consumes significant amount of disk space. Among really usefull data there is data that may be cleaned up and optimized in Zabbix database in order to reduce size of Zabbix database.
Jan 30 2024
Vicidial access forbidden to the recordings folder
I got this upon trying to download call recording in Vicidial on the lead’s page. I have Vicibox 11 installed in virtual machine on Cloudmin with Vicidial VERSION: 2.14-899a BUILD: 231109-2027