jimeUWOshkosh

raspbian:DHCP on a inTRAnet

3-apr-2020

$ cat /etc/os-release
...
VERSION="10 (buster)"
...

jimeUWOshkosh

A Customer may or may not have an address, and an address is linked to a us_state table.
In theory the IO for the address and us_state will only be done until the query for the customer table is executed.
---
CREATE TABLE address (
    address_id integer NOT NULL primary key,
    street text NOT NULL,
    city text NOT NULL,
    us_state_id integer NOT NULL,
    zip_code character(5) NOT NULL,
    FOREIGN KEY(us_state_id) REFERENCES us_state(us_state_id)

jimeUWOshkosh

package TestsFor::Stuff;
use Test::Class::Moose bare => 1;
use Test2::Tools::Class;
use Test2::Tools::Compare;
use DateTime;

# $ tree t
#
#.
#└── t

jimeUWOshkosh

Create repository via GitHub
    username.github.io

$ mkdir username.github.io
$ cd username.github.io
$ echo "Under Construction" > README.txt
$ echo "Under Construction" > index.html

$ git init
$ git add --all

jimeUWOshkosh

If your running RasPBX without Internet connection most of the time
   If Internet connection is not continuously
   $ sudo apt-get install fake-hwclock
....
fake-hwclock is already the newest version (0.11+rpt1).
The following package was automatically installed and is no longer required:
  libarchive13
Use 'sudo apt autoremove' to remove it.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
---EOO---

jimeUWOshkosh

RPi3B+ Wifi Configuration

Note:
I'm doing the project at M&D's (in their 90s) on weekends and they don't
have a internet connection so I use the public library.
1. I need something to do while I'm there beside maintenance.
2. This PBX project is for their home

# Login in as root
$ sudo iwlist wlan0 scan | grep ESSID

jimeUWOshkosh

Equipment
   laptop w/ Ubuntu 18.04
   Dynex: Mini Memory Card Reader/Writer
   Cana Kit RPi 3 B+
   SanDisk: Ultra microSDXC UHS-1 Card and Adapter, 64DB

To format SD Card
  Download
     Etcher www.canakit.com/tools/etcher
        To format SD card w/ adapter and put Raspbian OS on it

jimeUWOshkosh

18-Dec-2018
Ubuntu 18.04 with system wide perlbrew

$ su - woot    # my sysadmin account
$ sudo bash    # want to use woot's home directory
$ source /opt/perlbrew/etc/bashrc

$ cpanm Mojolicious
$ cpanm Mojo::SQLite
$ sudo apt install sqlite3

jimeUWOshkosh

Ubuntu 18.04
$ su - woot    # woot is my admin account
$ sudo apt-get install build-essential

$ sudo bash
$ \curl -k -L http://install.perlbrew.pl | bash
$ /opt/perlbrew/bin/perlbrew init
$ source ~/perl5/perlbrew/etc/bashrc
Edit .bashrc. Append to end