Skip to content

Instantly share code, notes, and snippets.

View spoofedpacket's full-sized avatar

Robert Gallagher spoofedpacket

  • Dublin
  • 14:24 (UTC +01:00)
View GitHub Profile
ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR: relation "inventory_facts" does not exist
: ALTER TABLE inventory_facts DISABLE TRIGGER ALL;
2017-04-21T09:15:57 f647d4c8 [app] [I] Failed to save: Could not deactivate host on PuppetDB: SSL_connect SYSCALL returned=5 errno=0 state=SSLv3 read finished A

Keybase proof

I hereby claim:

  • I am spoofedpacket on github.
  • I am spoofedpacket (https://keybase.io/spoofedpacket) on keybase.
  • I have a public key whose fingerprint is 96B4 4051 C7EC 510D DB93 0A5C DF56 87B1 8413 86E3

To claim this, I am signing this object:

ActiveRecord::StatementInvalid
Mysql2::Error: Unknown column 'models.name' in 'where clause': SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM `reports` INNER JOIN `hosts` ON `hosts`.`id` = `reports`.`host_id` AND `hosts`.`type` IN ('Host::Managed') WHERE `reports`.`type` IN ('ConfigReport') AND (status <> 0) AND `reports`.`host_id` IN (SELECT `hosts`.`id` FROM `hosts` WHERE `hosts`.`type` IN ('Host::Managed') AND ((`hosts`.`name` LIKE '%siskin%' OR `hosts`.`comment` LIKE '%siskin%' OR `models`.`name` LIKE '%siskin%' OR `hostgroups`.`name` LIKE '%siskin%' OR `hostgroups`.`title` LIKE '%siskin%' OR `hostgroups`.`title` LIKE '%siskin%' OR `domains`.`name` LIKE '%siskin%' OR `realms`.`name` LIKE '%siskin%' OR `environments`.`name` LIKE '%siskin%' OR `architectures`.`name` LIKE '%siskin%' OR `compute_resources`.`name` LIKE '%siskin%' OR `images`.`name` LIKE '%siskin%' OR `operatingsystems`.`name` LIKE '%siskin%' OR `operatingsystems`.`description` LIKE '%siskin%' OR `operatingsystems`.`title` LIKE '
Unable to save
failed to detect boot server: ERF50-9294 [Foreman::WrappedException]: Unable to find IP address for 'currychip.heanet.ie' ([Resolv::ResolvError]: DNS result has no information for currychip.heanet.ie)
Oops, we're sorry but something went wrong ActiveRecord::RecordNotDestroyed
If you feel this is an error with Foreman itself, please open a new issue with Foreman ticketing system, You would probably need to attach the Full trace , relevant log entries, and it is highly recommended to also attach the foreman-debug output.
ActiveRecord::RecordNotDestroyed
ActiveRecord::RecordNotDestroyed
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.1.14.2/lib/active_record/persistence.rb:167:in `destroy!'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.1.14.2/lib/active_record/associations/has_many_association.rb:112:in `each'
/usr/share/foreman/vendor/ruby/2.0.0/gems/activerecord-4.1.14.2/lib/active_record/associations/has_many_association.rb:112:in `delete_records'
@spoofedpacket
spoofedpacket / keyless-hiera-hash.yaml
Created July 26, 2016 10:14
Keyless hash in hiera
vars :
'http_ssl' : 'true'
'http_vhost' : 'thingy.yokey.thingy'
'http_method' : 'GET'
'http_warn_time' : '2'
'http_critical_time' : '4'
@spoofedpacket
spoofedpacket / gist:d75d33675ff7ef716dc6ce00c62239c8
Created June 17, 2016 13:11
backuppc-out-of-order-refresh
2016-06-17 13:59:05 +0100 /Stage[main]/Backuppc::Server/File_line[backuppc_host_server1.example.com]/ensure (notice): created
2016-06-17 13:59:05 +0100 /Stage[main]/Backuppc::Server/File_line[backuppc_host_server2.example.com]/ensure (notice): created
2016-06-17 13:59:05 +0100 /Stage[main]/Backuppc::Server/File_line[backuppc_host_server3.example.com]/ensure (notice): created
2016-06-17 13:59:08 +0100 /Stage[main]/Backuppc::Server/Service[backuppc] (notice): Triggered 'refresh' from 1 events
2016-06-17 13:59:08 +0100 /Stage[main]/Backuppc::Server/File_line[backuppc_host_server4.example.com]/ensure (notice): created
2016-06-17 13:59:08 +0100 Puppet (notice): Finished catalog run in 12.99 seconds
# Add routes and routing policy entries for a specific address
# and interface. In a system with multiple interfaces in different
# networks this ensures traffic always goes in and out the same
# interface.
echo "1 $IF" >>/etc/iproute2/rt_tables
ip route add $NET dev $IF src $IP table $IF
ip route add default via $GW dev $IF table $IF
ip rule add from $IP/32 table $IF
ip rule add to $IP/32 table $IF
@spoofedpacket
spoofedpacket / thin-lvm.sh
Last active August 29, 2015 14:15
Thin LVMs/Gluster (for snapshots)
# Each gluster volume needs it's own thin storage pool.
# Stop gluster. (have to kill some gluster processes manually)
umount /gluster
lvremove /dev/vg-gluster/lv-gluster
# Create thin storage pool volume (lv-gluster-pool). Thin sub-volumes are then allocated from this.