Skip to content

Instantly share code, notes, and snippets.

Robin Smidsrød robinsmidsrod

Block or report user

Report or block robinsmidsrod

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View list_container_by_parent.sql
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
View datatype_or_null.sql
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 Aug 4, 2018
Saltstack formulas for deplying networkboot/dhcpd docker hub image for guest network using VLAN 6
View file_listing.txt
/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
View gist:bd7fa6f19db694a5a4b7bbd5e500937a
[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 Mar 21, 2018
Changes to iPXE util/niclist.pl to avoid given/when warning and allow reverse sort on columns
View niclist_changes.diff
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 Feb 13, 2018
Trouble with large PostgreSQL statement because of unnest(ARRAY[ 'asdf', 'asdf' ])
View query.sql
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
@robinsmidsrod
robinsmidsrod / remove_given_when_util_niclist.diff
Created Feb 13, 2018
Fix issue with given/when experimental in newer Perl versions
View remove_given_when_util_niclist.diff
diff --git a/src/util/niclist.pl b/src/util/niclist.pl
index 0600c823..f6e70e5b 100755
--- a/src/util/niclist.pl
+++ b/src/util/niclist.pl
@@ -50,23 +50,20 @@ Column names (default order):
EOM
# Only load runtime requirements if actually in use
-given($format) {
- when( /csv/ ) {
@robinsmidsrod
robinsmidsrod / proc_pidof_telegraf_limits.txt
Created Oct 31, 2017
Process limits for telegraf process which is having issues spawning processes (inputs.exec)
View proc_pidof_telegraf_limits.txt
# cat /proc/$(pidof telegraf)/limits
Limit Soft Limit Hard Limit Units
Max cpu time unlimited unlimited seconds
Max file size unlimited unlimited bytes
Max data size unlimited unlimited bytes
Max stack size 8388608 unlimited bytes
Max core file size 0 unlimited bytes
Max resident set unlimited unlimited bytes
Max processes 15796 15796 processes
Max open files 65536 65536 files
@robinsmidsrod
robinsmidsrod / vbox_named_config.diff
Last active Sep 27, 2017
Updated VirtualBox named configuration that works with iPXE commit 74d90b33 (almost everything is disabled now)
View vbox_named_config.diff
diff --git a/src/config/vbox/general.h b/src/config/vbox/general.h
index 06b45f1a..aceae74f 100644
--- a/src/config/vbox/general.h
+++ b/src/config/vbox/general.h
@@ -1,12 +1,17 @@
/* Disabled from config/defaults/pcbios.h */
+#undef IMAGE_ELF
+#undef IMAGE_MULTIBOOT
+#undef IMAGE_BZIMAGE
@robinsmidsrod
robinsmidsrod / console.h
Created Jun 5, 2017
iPXE console.h customization for useful logging to syslog
View console.h
/* Everything but LOG output to BIOS console */
#undef CONSOLE_PCBIOS
#define CONSOLE_PCBIOS ( CONSOLE_USAGE_ALL & ~CONSOLE_USAGE_LOG )
#define CONSOLE_VESAFB
/* Everything but TUI output to syslog console */
#undef CONSOLE_SYSLOG
#define CONSOLE_SYSLOG ( CONSOLE_USAGE_ALL & ~CONSOLE_USAGE_TUI )
#undef LOG_LEVEL
You can’t perform that action at this time.