VIM/SED Search and replace lines that do not contain numbers

Objective: Find all lines in a file that only contain alpha characters and delete or replace.

Sample contents of file.

 Z2j2NH23
VTQnPwSS
hFbxgvFt
VSVR8v3F
GPrP4zo

The following sed command works for our objective.

sed s/[[:alpha:]]\{8\}/ALPHAONLY/g file.txt

The part in the [] tells sed to search for any alpha characters a-Z, the part in bold \{8\} tells it to search 8 spaces out (Change if needed) and ALPHAONLY is what alpha line will get substituted to.

sed s/[[:alpha:]]\{8\}/ALPHAONLY/g



Returns

Z2j2NH23
ALPHAONLY
ALPHAONLY
VSVR8v3F
GPrP4zo9

You can run the same basic syntax in VI

Search and replace

:%s/[[:alpha:]]\{8\}/ALPHAONLY/g 

Or to delete the lines

:%d/[[:alpha:]]\{8\}/d

You can also change [[:alpha:]] for [[:digit:]] if you want to search for numbers instead.

Backup Android with adb on Windows

Install SDK

Install Android Studio. This will install the SDK and tools like adb and fastboot

Download from here

To run adb, you’ll need to be in the same directory as it, so open a Command Prompt and cd to the following directory.

cd %APPDATA%..\Local\Android\Sdk\platform-tools

Full directory path is

C:\Users\UserName\AppData\Local\Android\Sdk\platform-tools

Backup Android

On your Android device you will need to enable USB debugging from the developer options. Enable the developer options if you have not already.

When you plug your phone in it should ask you to Allow USB debugging. Hit OK to enable it.

Now run the backup command from your computer. Replace UserName with your computers User Name

adb backup -apk -obb -shared -all -f \Users\UserName\Desktop\android-backup.ab

On your phone you should get a window that shows Full Backup

Add optional password for backup and hit “Back up my data on phone”

Now Wait for it to finish…

Restore Backup

adb restore C:\Users\UserName\android-backup.ab

Should get a restore window on your phone, hit restore and wait.

Errors

error: device unauthorized.
This adb server's $ADB_VENDOR_KEYS is not set
Try 'adb kill-server' if that seems wrong.
Otherwise check for a confirmation dialog on your device.

USB Debugging is not allowed for computer. Try replugging the USB cable and accepting the USB Debugging.

apt install python-pip, Unable to locate package – Ubuntu

When trying to install pip on Ubuntu with

sudo apt install python-pip

get the following error

Unable to locate package python-pip

Does the same thing for other basic packages. One of which was nasm “Dependency for Chipsec”

Issue ended up being that the Community-maintaned source was not enabled. Enabled via the Software & Updates. Should be able to search for it and it should come up.

BitLocker – Command Prompt Commands

You’ll need administrator privileges to use these command. You can also run them from a command prompt in recovery

Check Status

manage-bde -status

Turn off Encryption

manage-bde -off C:

Change C: to the drive that has BitLocker on it. Check with the status command. May not be C if your in recovery.
Also note that after the encryption is turned off it takes awhile to decrypt. Check with status command

Unlock BitLocker Encrypted Drive

manage-bde -unlock C: -recoverypassword 11111-...-99999

Replace C: with actual drive

Replace the numbers at the end to your actual recovery key.

Secure Erase Hard Drive using DD

The following commands are dangerous! Proceed with caution!

Change /dev/sdX to your drive. Make sure you get the correct drive, or you could wipe you main system.

dd if=/dev/zero of=/dev/sdX bs=1M status=progress

The status=progress part shows how much dd has writen. Helpful to gauge how far along it is.

If you want a more secure way to erase the drive, change zero to random. Makes it slower, but should be more secure.

dd if=/dev/random of=/dev/sdX bs=1M status=progres

Side note, these commands should work in macOS, but you may need to drop the status=progress option.

LibreNMS manually clean up MySQL Syslog Database

Adding the following option to the config.php file is supposed to delete anything over 30 days.

$config['syslog_purge']                                 = 30;

You can also manually delete the entries out of the MySQL database by logging into MySQL, selecting the librenms database, and running the command below.

The command deletes all entries older than 12/9/2018 at 08:00. Change the date and time as needed.

DELETE FROM syslog WHERE timestamp < '2018-12-9 08:00:00';

The following link has some more clean up options.
https://docs.librenms.org/Support/Cleanup-options/