Author: admin

Uncategorized

Installing BearExtender for Mac on Mac OSX 10.11(El Capitan)

These instructions are a mix of what I got from: https://blog.alfa.com.tw/2016/03/01/using-alfa-network-awus036nh-awus036neh-awus036nf-awus051nh-v2-awus052nh-on-osx-10-11-el-capitan/ https://www.bearifi.com/pages/bearextender-1200-support Run the following instructions: Create a new directory for the downloads mkdir ~/BearExtender Put the following download in the directory called ~/BearExtender Download the BearExtender Kernel Extension from here: http://107.170.140.210/s/8aa1Wf38QGi7R7v Get the BearExtender software Put the following download in the directory called ~/BearExtender …

MAC OS X

Disabling Apple SIP Protection

Introduction: SIP protection defined by Apple as “technology in OS X El Capitan and later that’s designed to help prevent potentially malicious software from modifying protected files and folders.” It locks down the system extensions folder which makes it so driver applications like ours cannot write to that folder unless you disable SIP protection. For …

Uncategorized

Decrypting Jotform encrypted CVS Files

Description:When the encryption is been activated for the JotForms, exports of the forms in CSV format are saved with almost all fields in RSA encrypted format. This script below allows to decrypt such CSV files. Problem:Since the private key is only saved at the JotForm user’s side, the JotForm server has no way of decrypting …

Uncategorized

FTPS on command line using LFTP

# In Debian/Ubuntu, install LFTPapt-get install lftp # Create the configuration file in home directory of the user# eg. admin user will be running the program: cd /home/admintouch .lftprc (Content)set ftp:ssl-auth TLSset ftp:ssl-force trueset ftp:ssl-protect-list yesset ftp:ssl-protect-data yesset ftp:ssl-protect-fxp yesset ssl:verify-certificate no Command line to upload 2 files: software.txt and software2.txt cd /DATA/files/lftp user:PASSWORD@servername <<EOFput …

Uncategorized

Solution for MySQL/MariaDB Field ‘xxx’ doesn’t have a default value

Situation:Using PhpMyAdmin I was trying to add a user and this error kept on coming up and I could not add the user. After some research here are 2 solutions: The following articles are so good and helpful that as soon as I saw them in Internet I wanted to copy them here. The first …

Linux, Systemd

GRUB on EUFI capable System

Introduction:New PCs are often equipped of the UEFI(Universal EFI) capable booting. Some SSD drives will even not boot in Linux the Legacy MBR mode. So in order to make the PC boot properly we need to:– Create an EFI Partition– Install GRUB(Boot loader) on it Create the EFI Partition:Create an EFI capable Boot partition of …

Uncategorized

Unassign a software RAID member volume to become again a normal volume.

Situation:I had assigned the drive partition (/dev/sdb1) to a Linux Software RAID disk group. Now I want to take out this drive from the software RAID group and use it as a normal drive. Since the drive has been assigned to a group simply trying to use it as a normal drive by re-partitioning and …

Uncategorized

Solving the Running /scripts/local-block loop while booting in linux

Problem: Linux booting and taking a long time while looping with the script: /scripts/local-block Reason: Linux boot needs to know the UUID of the Swap file it tries to mount. Solution:Run the command:blkidand get the UUID of the Swap file.Run the command:nano /etc/initramfs-tools/conf.d/resumeThis file doesn’t exist. It will then be created.Add the following line as …

Email, Linux, Mailman

Minimize the Digests shown Headers in Mailman 2.1.xx

Problem: Digests in Mailman are composed of a lots of unneeded headers which clutter the messages. Solution: Edit the Mailman configuration file manually as follows: WARNING !!!: These headers are part of a the ‘RFC 1153’ which if changed can have unpredictable or unwanted effects. So here I kept the headers: Date:, From:, Subject:, Keywords(if …

Email, Linux, Postfix

Configuring Domain Relaying with ISPConfig 3.1.xx

Intention: Redirect (reroute) specific email addresses via, for example, an SMTP service: Steps: – Enter the destination domain in the Advanced Routing Table (Email ==> Email Accounts/Email Routing) – Enter the same destination domain in the (Email ==> Global Filters / Relay Recipients) as @domain Example: eg. rerouting all emails of destination domain mydomain.com via …

Email, Linux, Postfix

No Type list in ISPConfig 3.1.11

Problem: The brand new version of ISPConfig 3.1.11 when I add or modify an email transport, no value is displayed anymore on “type”. Solution: Ref: https://git.ispconfig.org/ispconfig/ispconfig3/issues/4924 Edit /usr/local/ispconfig/interface/web/mail/mail_transport_edit.php Change this line: $app->tpl->setVar($rec, null, true); to this: $app->tpl->setVar($rec); and should work again.

Linux, MySQL, Security

Resetting MySQL/MariaDB root password in Ubuntu 16.04/18.04

Introduction: In case you have forgotten the ‘root’ password in MySQL/MariaDB(10.0.x) you can reset the password as follows: Ref: https://kofler.info/root-login-problem-mit-mariadb/ STEPS: Stop the currently running MySQL/MariaDB service mysql stop Start MySQL/MariaDB in non-protected mode: mysqld_safe –skip-grant-tables –skip-networking & Login as root in MySQL/MariaDB mysql -u root Set the new root password: For MySQL Previous to …

Apache, Linux, Wordpress

Installing the missing mcrypt module for PHP 7.2

Inroduction: Because of the module mcrypt for PHP neot being maintained since a bout 10 years the PHP team has decided to drop it from the PHP version 7.2 on. For PHP applications that need this module here are the instructions to compile and install it for PHP 7.2. Reference: https://lukasmestan.com/install-mcrypt-extension-in-php7-2/ STEPS: We need to …

Uncategorized

Listing all subscribers in mailman mailing list

Intro: As far as my experience with mailman is concerned, if I create a list of all subscribers of a mailing list using the web interface I get the list with the word ‘at’ instead of ‘@’ in each email address. In order to get a normal list of all addresses of subscribers a mailing …

Email, Mailman

Changing the mailman subscribers ‘moderation’ bit on the command line

Intro: In my mailman installation with over 3K subscribers I could not find why the web interface didn’t allow me to change the ‘moderation’ bit of subscribers, or any other property. So I found this tool which allows me to the ‘moderation’ bit for any subscriber using the command line. Sinc ethe Python module for …