mwpastore

CREATE TABLE [dimension].[Item]
(
  [ItemKey] BIGINT IDENTITY(1, 1) NOT NULL PRIMARY KEY,
  [SequenceNumber] BIGINT NOT NULL,
  [ItemId] UNIQUEIDENTIFIER NOT NULL,
  [HistoricalUpc] CHAR(13) NOT NULL,
  [HistoricalMfgCode] NVARCHAR(5) NOT NULL,
  [HistoricalType] INT NOT NULL,
  [HistoricalIsWeighed] BIT NOT NULL,
  [HistoricalDescription] NVARCHAR(50) NOT NULL,

mwpastore

What is this?

This guide shows how to replace the DHCP Server function in pfSense with dnsmasq. You can do this for some or all of your subnets. This addresses a 12+-years old [bug][1] in pfSense.

While it is possible to replace the DHCPv6 Server & RA and/or DNS Resolver functions in pfSense with dnsmasq as well, these are out of scope for this guide. Unbound can run in recursive mode and it has some performance advantages over dnsmasq; generally speaking pfSense seems "happier" with it enabled.

DISCLAIMER: While I have done profesionally network administration in the past, I am not per se a professional network administrator. I'm just a guy with an overly-complicated homelab who's been using dnsmasq for many years. Follow this guide at your own risk—and please take a backup before you start!

Pros

mwpastore

import { resource } from 'ember-resources';

const withState =
  ({ ...state }, fn) =>
    resource(() => Object.assign(state, fn({ ...state })));

export default { withState }; 

mwpastore

import { modifier } from 'ember-modifier';

import { isArray } from '@ember/array';
import { capitalize } from '@ember/string';
import { isEmpty, isPresent, typeOf } from '@ember/utils';

const { isInteger } = Number;

const parseKeys = arr => arr
  .filter(_ => typeOf(_) === 'string')

mwpastore

import Controller from '@ember/controller';

import { tracked } from '@glimmer/tracking';

export default class ApplicationController extends Controller {
  @tracked
  prop;
  
  @tracked
  propDidUpdate = false;

mwpastore

[tank_active]
   browsable = yes
   read only = no
   guest ok = no
   valid users = @users

   path = /tank/active
   block size = 4096
   write cache size = 131072

mwpastore

mkfs.ext4 -b 4k -C 128k -E num_backup_sb=0,packed_meta_blocks=1,root_owner=111:118 -O bigalloc,extent,flex_bg,^has_journal,mmp,sparse_super2 -L varnish-cache -N 64 -v /dev/sdc

mwpastore

#!/bin/bash
###
# PURPOSE
#
# Execute a VLAN "flop" to allow the AT&T Residential Gateway (RG) to perform
# 802.1x authentication via the Optical Network Terminal (ONT) before falling
# back to the subscriber's "own" router/gateway hardware. The RG is toggled off
# and on as needed via a remote-controlled power outlet (see below).
#
# For more information about this procedure, please see brianlan's original

mwpastore

import computed from 'ember-macro-helpers/computed';

import PromiseProxyMixin from '@ember/object/promise-proxy-mixin';

import { typeOf } from '@ember/utils';
import { all } from 'rsvp';

export default function(Proxy) {
  const PromiseProxy = Proxy.extend(PromiseProxyMixin);

mwpastore

import Ember from 'ember';

export default Ember.Component.extend({
  greeting: 'Hello',
  
  actions: {
    showAlert(message) {
      const greeting = this.get('greeting');
      
      alert(`${greeting}, ${message}!`);