Skip to content

Instantly share code, notes, and snippets.

View robinsmidsrod's full-sized avatar

Robin Smidsrød robinsmidsrod

View GitHub Profile
src/config/local/efi/console.h:/* Everything but DEBUG and LOG output to EFI console */
src/config/local/efi/console.h:#undef CONSOLE_EFI
src/config/local/efi/console.h://#define CONSOLE_EFI ( CONSOLE_USAGE_ALL & ~CONSOLE_USAGE_DEBUG & ~CONSOLE_USAGE_LOG )
src/config/local/efi/console.h:#define CONSOLE_EFI ( CONSOLE_USAGE_ALL & ~CONSOLE_USAGE_LOG )
src/config/local/efi/console.h:/* Everything but TUI output to syslog console */
src/config/local/efi/console.h:#undef CONSOLE_SYSLOG
src/config/local/efi/console.h:#define CONSOLE_SYSLOG ( CONSOLE_USAGE_ALL & ~CONSOLE_USAGE_TUI )
src/config/local/efi/console.h:#undef LOG_LEVEL
src/config/local/efi/console.h:#define LOG_LEVEL LOG_ALL /* Full syslog logging */
src/config/local/efi/general.h:#undef BANNER_TIMEOUT
@robinsmidsrod
robinsmidsrod / ubuntu_1804.ipxe
Last active July 4, 2023 09:11
iPXE script entries for booting Ubuntu 18.04 in different ways
# boot-url points to an nfs URL
# sanboot-url points to an http URL
# ubuntu-version contains 18.04.3
# ubuntu-release contains bionic
:ubuntu
echo Booting Ubuntu from iSCSI for ${initiator-iqn}
set root-path ${base-iscsi}:${hostname}.boot.ubuntu
sanboot ${root-path} || goto failed
goto start
@robinsmidsrod
robinsmidsrod / gist:18a559af2680f85a72134a6d3093f62f
Last active August 22, 2019 13:46
BitDefender Rescue CD iPXE boot script (non-working because missing /bin/mount.nfs in initramfs)
:bitdefender
echo Booting BitDefender Rescue ${bitdefender-version} x86 for ${initiator-iqn}
set base-url bitdefender-rescue-${bitdefender-version}/
kernel ${base-url}boot/kernel.i386-pc root=/dev/nfs nfsroot=${nfs-server}:${nfs-root}${base-url} ip=dhcp real_root=/dev/nfs loop=/rescue/livecd.squashfs looptype=squashfs livecd.nfsif=${netX/mac} initrd udev cdroot
initrd ${base-url}boot/initfs.i386-pc
boot || goto failed
goto start
@robinsmidsrod
robinsmidsrod / git-branch-sizes
Last active January 29, 2020 00:18
Output all non-merged refs in a git repo, ordered by number of changed lines in the diff output
#!/bin/bash
#
# Output all non-merged refs in a git repo, ordered by number of changed lines in the diff output
#
git for-each-ref --shell --format="ref=%(refname)" --no-merged | \
while read entry
do
eval "$entry"
size=$(git diff -U0 "master...$ref" | grep -vP '^(diff|index|@@|\-\-\-|\+\+\+)' | wc -l)
CREATE FUNCTION public.list_container_by_parent(in_parent_id uuid, in_locale text, in_sort_key text, in_custom_init_key text) RETURNS SETOF public.node
LANGUAGE sql STABLE COST 30 ROWS 20
AS $$
-- Returns the child containers of the specified parent container in the
-- sort order specified by the sort key and locale.
-- If sort key is not specified, the sort key of the parent container,
-- or default for parent container type, is used.
-- If custom_init key is specified, containers that have this key set are
-- excluded from output. The value of the custom_init key doesn't matter.
WITH
CREATE FUNCTION public.datatype_or_null(data anyelement, datatype text)
RETURNS anyelement
LANGUAGE plpgsql IMMUTABLE
AS $$
BEGIN
RETURN CAST(data AS datatype);
EXCEPTION
WHEN OTHERS THEN
RETURN CAST(NULL AS datatype);
END;
@robinsmidsrod
robinsmidsrod / file_listing.txt
Last active September 8, 2020 12:57
Saltstack formulas for deplying networkboot/dhcpd docker hub image for guest network using VLAN 6
/srv/salt/dhcpd/green/dhcpd.conf
/srv/salt/dhcpd/green/netboot.conf
/srv/salt/dhcpd/green/option-space.conf
/srv/salt/dhcpd/green.sls
/srv/salt/dhcpd/green/static.conf
/srv/salt/dhcpd/green.upstart
/srv/salt/dhcpd/guest/dhcpd.conf
/srv/salt/dhcpd/guest.sls
/srv/salt/dhcpd/guest.upstart
/srv/salt/dhcpd/init.sls
[CRITICAL] Failed to load grains defined in grain file zfs.zfs in function <function zfs at 0x7f889d1dd398>, error:
Traceback (most recent call last):
File "/usr/lib/python2.7/dist-packages/salt/loader.py", line 756, in grains
ret = funcs[key]()
File "/usr/lib/python2.7/dist-packages/salt/grains/zfs.py", line 116, in zfs
grains = salt.utils.dictupdate.update(grains, _zfs_pool_data(), merge_lists=True)
File "/usr/lib/python2.7/dist-packages/salt/grains/zfs.py", line 102, in _zfs_pool_data
grains['zpool'][zpool[0]] = _conform_value(zpool[1], True)
IndexError: list index out of range
[ERROR ] Exception raised when processing __virtual__ function for salt.loaded.int.module.zfs. Module will not be loaded: u'zfs_support'
@robinsmidsrod
robinsmidsrod / niclist_changes.diff
Last active March 21, 2018 13:45
Changes to iPXE util/niclist.pl to avoid given/when warning and allow reverse sort on columns
diff --git a/src/util/niclist.pl b/src/util/niclist.pl
index 0600c823..2668a1c0 100755
--- a/src/util/niclist.pl
+++ b/src/util/niclist.pl
@@ -19,7 +19,7 @@ use Getopt::Long qw(GetOptions);
GetOptions(
'help' => \( my $help = 0 ),
'format=s' => \( my $format = 'text' ),
- 'sort=s' => \( my $sort = 'bus,ipxe_driver,ipxe_name' ),
+ 'sort=s' => \( my $sort = 'bus-,ipxe_driver,ipxe_name' ),
@robinsmidsrod
robinsmidsrod / query.sql
Last active February 13, 2018 11:16
Trouble with large PostgreSQL statement because of unnest(ARRAY[ 'asdf', 'asdf' ])
WITH
checksums AS (
SELECT unnest(ARRAY[
-- Using quote_string_array() DBD::Pg method here
-- Example: '0000218c2a23400651a308443664d18bc0639052', ..., '000031b775731a8bbd05c873d5dfab6db49e59c7' (and 150k more of those)
$blob_ids_quoted
]) AS id
),
object_counts AS (
SELECT c.id, count(*) AS object_count