Installing LineageOS on Raspberry Pi B+

Posted on March 5, 2020 by admin

Download LineageOS

Download the unofficial LineageOS 16 build from the following page

https://konstakang.com/devices/rpi3/LineageOS16.0/

Unzip

Unzip the file with

unzip ~/Downloads/lineage-16.0-20200207-UNOFFICIAL-KonstaKANG-rpi3.zip

Write to SD Card

Either use the instructions on the following link to write it to the SD card

https://www.raspberrypi.org/documentation/installation/installing-images/windows.md

Or use DD

WARNING! Make sure “/dev/mmcblk0” is the correct SD Card. Refer to here if you need to locate the path for the SD Card.

sudo dd if=~/Downloads/lineage-16.0-20200207-UNOFFICIAL-KonstaKANG-rpi3.img of=/dev/mmcblk0 bs=1M status=progress

Plug you SD Card into your Pi and boot it up.

How To setup a L2TP vpn in Mikrotik

Posted on March 5, 2020 by admin

Open up PPP and select L2TP Server. Set it to Enabled, set IPsec to yes, and set the IPsec secret.

Next go to PPP -> Profiles and modify the default-encryption one. You can setup an IP Pool to use for the VPN clients when they connect.

Next go to the PPP -> Secrets and configure the user to connect.

Setup your VPN client and connect.

LibreNMS – Daily.sh failed

Posted on March 4, 2020 by admin

All the following commands are run from the “/opt/librenms” directory

$ sudo ./daily.sh 
Re-running /opt/librenms/daily.sh as librenms user
Updating to latest codebase                        FAIL
error: Your local changes to the following files would be overwritten by merge:
        html/js/lang/de.js
        html/js/lang/en.js
Please, commit your changes or stash them before you can merge.
...
$

Checking with validate.php shows that you can run githup-remove to fix it

$ sudo ./validate.php
[WARN]  Your install is over 24 hours out of date, last update: Mon, 23 Feb 2020 05:43:12 +0000
         [FIX]: 
         Make sure your daily.sh cron is running and run ./daily.sh by hand to see if there are any errors.
 [WARN]  Your local git contains modified files, this could prevent automatic updates.
         [FIX]: 
         You can fix this with ./scripts/github-remove
         Modified Files:
          html/js/lang/de.js
...
$

Run “sudo ./scripts/github-remove -d”

$ sudo ./scripts/github-remove -d
Are you sure you want to delete all modified and untracked files? [y/N] y
$

You should also be able to remove the files individually if the above command does not work.

Run validate again to make sure it checks out good.

Now run ./daily.sh

How to sum a total from a date Range – LibreCalc

Posted on February 28, 2020 by admin

Overview adding up all the items for the specified dates

You can use SUMIFS to check if a date is between two other dates and sum if it is.

The formula is as follows

=SUMIFS(RangeToAdd,DateRange,">="StartDate,SecondDateRange,"<="EndDate")

Where
RangeToAdd = Range to add, or amount of items to count up
DateRange = Date field to compare against start date
StartDate = Should be the start of the month (Can change to whatever date you need)
SecondDateRange = Same as DateRange, this is used to compare against the EndDate
EndDate = End of month date (Can change to whatever date you need)

The approx exact formula is.
=SUMIFS($C$5:$C$12,$A$5:$A$12,”>=”&E4,$A$5:$A$12,”<=”&E5)

Overview adding up all the items for the specified dates with formula

More info
https://exceljet.net/formula/sum-if-date-is-between

OpenVPN on Mikrotik Router

Posted on February 25, 2020 by admin

Create Certificate

Can look here to set a certificate up in Winbox
or here to configure from command line

Enable OpenVPN server

To setup a OpenVPN server on a router there are a few things that need to be done.

Create certificates (See top of post)
Create IP pool for clients to use
Configure default-encryption profile
Create User
Configure OpenVPN server

Create IP Pool

Create an IP pool that clients can pull and address from when they connect

Modify Profiles

Modify the default-encryptoin Profile and specify the VPN IP pool.

Create User

Create new user, specify the default-encryptio profile

Turn OVPN Server on

Enable the OVPN server. Specify the “Default Profile:” to be the default-encyption, specify the certificate to be the server-template, or whatever the name is of the certificate you created.

Create Certificate on Mikrotik – Command Line

Posted on February 25, 2020 by admin

https://wiki.mikrotik.com/wiki/Manual:Create_Certificates
https://www.medo64.com/2016/12/simple-openvpn-server-on-mikrotik/

Create Certificate Authority and Server Certificate

/certificate add name=ca-template common-name=myCa days-valid=3650 key-size=2048 key-usage=key-cert-sign,crl-sign

/certificate add name=server-template common-name=server days-valid=3650 key-size=2048 key-usage=digital-signature,key-encipherment,tls-server

Sign certificates

/certificate sign ca-template name=myCa

/certificate sign server-template ca=myCa name=server

Trust certificates

/certificate set myCa trusted=yes

/certificate set server trusted=yes

Create Certificate on Mikrotik – WinBox

Posted on February 25, 2020 by admin

Create Certificates

Open up the Certificates window by going to /System -> Certificates. Hit the + to add a new certificate

Create Certificate Authority Certificate

First we are going to create a Certificate Authority template

Specify the key usage to “crl sign” and “key cert. sign” and apply

Setup Server Certificate

Now we are going to create a server template

We need to specify “Digital signature, key encipherment, and tls server” You may need to enable/disable more depending on your use case scenario. In this case we are setting it up for OpenVPN.

Sign Templates

First we need to sign the ca-template by opening up the the Certificate and hitting Sign on the right hand side. Should get the little Sign window pop up.

Progress will show done when it is finished signing.

Next we need to sign the server-template. When Signing the server template, specify the ca-template in the CA: field. See below

Alienware fan control in Linux notes

Posted on February 19, 2020 by admin

Helpful links

https://wiki.archlinux.org/index.php/Fan_Speed_Control#Dell_laptops
https://bbs.archlinux.org/viewtopic.php?id=248106
https://www.reddit.com/r/Dell/comments/9pdgid/configuring_the_xps_to_play_nice_with_linux

You can use the following commands to “initilize” the fans so the fancontrol can read them.

 sudo modprobe dell-smm-hwmon ignore_dmi=1

sudo sensors-detect

After that is done you should be able to setup a fancontrol config with

sudo pwmconfig

After it is set up you can launch fancontrol to control the fans

sudo fancontrol

If you want to tweak the setting, modify the fancontrol config under

/etc/fancontrol

or run pwmconfig again and replace config.

Sounds like you should be able to add the following to “etc/modprobe.d/dell.conf” to get it to run on boot.

options dell-smm-hwmon ignore_dmi=1

Remove hiberfil.sys

Posted on February 19, 2020 by admin

The hiberfil.sys is created and used when hibernating in Windows. Sometimes can be needed to help shrink the space on a drive.

Launch a command prompt with administrator privileges.

You can hit Windows Key + R, type in cmd, and hit Ctrl + Shift + Enter together. It’ll ask you to verify that you want to launch it. Hit Yes.
Alternatively you can search for the Command Prompt, Right click on it and Run as Administrator

Turn Hibernate off

powercfg -h off

A reboot should remove the file. If not you should be able to delete it. It is on the root of the drive, but you’ll need to enable hidden files and disable the “Hide protected operating system files” to see it.

You can turn it back on by changing off to on

powercfg -h on

More information:

https://support.microsoft.com/en-us/help/920730/how-to-disable-and-re-enable-hibernation-on-a-computer-that-is-running

Incredigeek

Author Archives: admin

Installing LineageOS on Raspberry Pi B+

How To setup a L2TP vpn in Mikrotik

LibreNMS – Daily.sh failed

How to sum a total from a date Range – LibreCalc

OpenVPN on Mikrotik Router

Create Certificate

Enable OpenVPN server

Create IP Pool

Modify Profiles

Create User

Turn OVPN Server on

Create Certificate on Mikrotik – Command Line

Create Certificate Authority and Server Certificate

Sign certificates

Trust certificates

Create Certificate on Mikrotik – WinBox

Create Certificates

Create Certificate Authority Certificate

Setup Server Certificate

Sign Templates

Alienware fan control in Linux notes

Remove hiberfil.sys