Fix libwacom9 dependency issue when upgrade Debian

The following packages have unmet dependencies: libwacom9 : Depends: libwacom-common (= 2.1.0-2) but 1.12-1 is to be installed This should fix the issue on most cases: # apt install libwacom9 libwacom-common=2.1.0-2 If the command above returns error: E: Version ‘2.1.0-2’ for ‘libwacom-common’ was not found Try this: # apt remove libwacom2 When run the command … Read more

Node.js – Convert PDF base64 to PNG base64 on Lambda

I recently developed an application running on Lambda Node.js 14.x, lost lots of time on this part. So I think this post may help someone to save their time. Don’t hesitate to leave a comment below if you found this post is hard to understand or if you have any questions. 1. NPM package I … Read more

How to get Salesforce Sfdx Auth Url

1. Install SFDX Refs: The easiest way is to install via npm: npm install sfdx-cli –global To check if the sfdx is installed or not: sfdx –version 2. Authorize an org with the OAuth 2.0 webserver In this step, you will need to login via a web browser to authorize the CLI application. sfdx … Read more

Install Docker & docker-compose on Ubuntu 20.04

Install with one command: curl -sL | bash Or follow the below steps. 1. Install Docker on Ubuntu 20.04 sudo apt-get update sudo apt install sudo systemctl enable –now docker sudo usermod -aG docker $USER newgrp docker 2. Install docker-compose on Ubuntu 20.04 sudo apt-get install curl sudo curl -L “$(uname -s)-$(uname -m)” … Read more

Use OpenVPN for server but keep incoming connections

I need to fake IP of current webserver using OpenVPN that installed on another server. The problem is it will block all incoming connections to my webserver ( 80, 443, and 22 for example). First, I need to force the incoming packets to be routed over its public interface: sudo ip rule add from $(ip … Read more

Magento 2 log rotation with logrotate

Why? Log rotation is an automated process to remove or archive old and big log files. More information here. Magento 2 log files get bigger every day, it may take too much space and slow down your server. In fact, you can backup and delete Magento log files, but it’s better if there’s an automated … Read more

Fix Magento 2 cron_schedule catalog_product_attribute_value_synchronize error

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`magento2`.`catalog_product_entity_datetime`, CONSTRAINT `CAT_PRD_ENTT_DTIME_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CAS), query was: INSERT INTO catalog_product_entity_datetime(attribute_id, store_id, entity_id, `value`) VALUES (:attribute_id0,:store_id0,:entity_id0,:value0) ON duplicate KEY UPDATE `value` = VALUES(`value`) The problem Cron schedule return status error when processing … Read more