Windows Equivalent of Linux ‘tail’ Command
We can use ‘tail’ command feature in Windows using Powershell. Run Powershell and execute this…
Windows Equivalent of Linux ‘tail’ Command
We can use ‘tail’ command feature in Windows using Powershell. Run Powershell and execute this command: Change [filename] with your file. Number 30 means show the last 30 lines.
Linux Mint: How to Activate Night Light
Linux Mint 21.3 “Virginia” is preinstalled with Redshift application which can be used to activate night light feature. Redshift will detect your location (latitude, longitude) to activate night light. Come a question, “how to force Redshift to activate night light all the day?”. You can modify config file to achieve this. Edit or create /home/[username]/.config/redshift.conf…
Portainer: How to Fix “Unable to retrieve image details”
I cannot access container’s console in Portainer. When click Console link, it showed error message “Unable to retrieve image details”. To fix this, I remove Portainer image and pull again with portainer/portainer-ce:sts image. Use the following commands to stop then remove the current Portainer. Your other applications/containers will not be removed. # docker stop portainer…
MySQL: How to Count Duplicated Records
The following query can be used to count duplicated records in MySQL:
MySQL: How to Strip HTML Tags
The following regular expression function can be used to strip HTML tags: It is very simple.
Kdenlive: How to Fix Audio Record Device
I unable to do audio recording in Kdenlive. Audio device does not show in Settings => Configure Kdenlive => Capture => Audio tab. To fix this issue, install libqt5multimedia5-plugins. Restart Kdenlive and go to Settings => Configure Kdenlive => Capture => Audio tab. Audio device list will be shown and audio recording can be used…
XAMPP: How to Open Phpmyadmin Access
XAMPP’s Phpmyadmin folder is forbidden as default if accessed from internet. To open access this folder we have to edit /xampp/apache/conf/extra/httpd-xampp.conf file in Windows or /opt/lampp/etc/extra/httpd-xampp.conf file in Linux. Open httpd-xampp.conf file in text editor Find the following line: Change to the following line: Restart Apache and phpmyadmin can be accessed from internet.
Ubuntu: How to Install RTL8192EU Driver
First, we install all packages required for the installation of the driver using this command: Now clone the git repository: Move to the new folder created: Remove current drivers (check with dkms status or sudo lshw -C network what drivers are available): Blacklist the current driver: And finally install the driver: Reboot or load the driver by doing sudo modprobe…
MySQL: How to Fix “Field Doesn’t Have A Default Value” Error
MySQL or MariaDB install has default value of sql mode named STRICT_TRANS_TABLES. The MySQL docs for STRICT_TRANS_TABLES state: Strict mode controls how MySQL handles input values that are invalid or missing. A value can be invalid for several reasons. For example, it might have the wrong data type for the column, or it might be…
