Jesus Suarez jesussuarz

Update Passbolt user permissions via MySQL

This SQL snippet provides a simple way to manage Passbolt user permissions directly from the MySQL database, It can be used by system administrators who need to adjust resource access (passwords, folders, or shared secrets) without using the web interface, for example, when a user has left the organization or needs elevated privileges on multiple entries,

By using these queries, you can, identify a user’s internal Passbolt UUID (id) using their email address, bulk update their access level (type) in the permissions table, convert all “update” permissions (editable) to “owner” permissions (full control), or any combination you require,

Hide the “Optimized by Seraphinite Accelerator” badge in Wordprress. The snippet does two things:

Replies f to the plugin’s ?seraph_accel_gbnr probe so the badge removes itself.
As a fallback, strips any remaining banner markup from the final HTML.

Easiest way: MU-plugin (loads automatically)

Create the folder if it doesn’t exist:

Guide: Increase phpMyAdmin Upload Limit for All PHP Versions in CyberPanel

When importing large databases using phpMyAdmin in CyberPanel, you may encounter upload size restrictions due to PHP's default configuration. This guide provides a ready-to-use bash script to massively increase the upload limits (upload_max_filesize and post_max_size) for all PHP (lsphp) versions used by CyberPanel, ensuring seamless database imports up to the size you set.

Why Change the Upload Limit?

phpMyAdmin relies on PHP settings to determine the maximum allowed upload size. By default, this limit is often set very low (2MB or 8MB). Increasing these limits is essential if you plan to import large database dumps.

🚫 Blocking Wappalyzer like a Ninja

Welcome, guardians of digital anonymity! 🕵️‍♂️ If you're here, it's because you want to prevent Wappalyzer (that nosy tool 👀) from snooping around your website and discovering what technologies you use.

🎯 What does this script do?

This stealthy code:

🔥 Removes any script injected by Wappalyzer.

Guide to Install VMware Tools on Linux and Windows

For Linux (Ubuntu/Debian-based Distributions)

Update the system repositories:

sudo apt update

Install Open VMware Tools:

Install ISO VMWare ESXi 8 U3 via KVM in OVH Servers

I hope this helps you all!

I’m the only one who has managed to solve this issue, and so far, no one else has posted about it. That’s why I’ll be the first to share the correct solution because I’ve successfully done it.

To keep using ESXi, the first thing you need is an ISO that includes the correct drivers. I’ve prepared an ISO specifically optimized for OVH servers.

The ISO is: ESXi-8.0U3sb-24262298-nvme-usbnic

Migration Guide for Koha 16.05 from Ubuntu 14.04.6 LTS to Ubuntu 22.04 LTS

This guide will help you migrate a Koha 16.05 instance from an older Ubuntu 14.04.6 LTS server to a new Ubuntu 22.04 LTS server. The instance will be named "koha16".

Prerequisites:

Ensure you have a backup of your Koha database and configuration files.
Verify the availability of all required dependencies and packages on the new server.
Have root or sudo access on both the old and new servers.

Step 1: Prepare the Old Server

Guide to Migrating Passbolt Server to a New Server

This guide covers two important aspects:

Migrating a Passbolt server from an old server to a new one, even if the new server has a more updated operating system.
Converting a Passbolt Pro installation to a Community (CE) version.

The process described is applicable both for a new installation and for an update on the existing server. In my case, I migrated from CentOS 7 to AlmaLinux 9.4.

Old Server

First, create a backup of the files and database of your old Passbolt server. To do this, execute:

	<?php
	/**
	* Exportar todos los correos de clientes desde PrestaShop 8.1
	* Autor: soporteserver.com
	* Uso: subir al directorio raíz de la tienda y abrir en el navegador.
	*/

	$parametersFile = __DIR__ . '/app/config/parameters.php';
	if (!file_exists($parametersFile)) {
	die('No se encontró el archivo app/config/parameters.php');

	function Get-WindowsKey {
	$Path = "HKLM:\SOFTWARE\Microsoft\Windows NT\CurrentVersion"
	$DigitalProductId = (Get-ItemProperty -Path $Path).DigitalProductId
	$ProductKey = ""
	$KeyOffset = 52
	$Chars = "BCDFGHJKMPQRTVWXY2346789"
	for ($i = 0; $i -lt 25; $i++) {
	$Current = 0
	for ($j = 14; $j -ge 0; $j--) {
	$Current = $Current * 256 -bxor $DigitalProductId[$KeyOffset + $j]