Blake-

#!/bin/bash

INPUT=sites.txt
OLDIFS=$IFS
IFS=,
[ ! -f $INPUT ] && { echo "$INPUT file not found"; exit 99; }
while read SITE
do

Blake-

A bunch of ec2s are created with disable_api_termination true which makes it really hard to kill them all when the time comes. 
This just changes all the disable_api_termination vars from true to false so they can easily `terraform destroy` 

```
find . -type f -name "app[[:digit:]]*.tf" | xargs sed -i '' 's/disable_api_termination     = true/disable_api_termination     = false/g'
terraform apply
```

Blake-

UPDATE accession set  publish = 1;
UPDATE agent_corporate_entity set publish = 1;
UPDATE agent_family  set publish = 1;
UPDATE agent_person set publish = 1;
UPDATE agent_software set publish = 1;
update archival_object set publish = 1;
update classification set publish = 1;
update classification_term set publish = 1;
update digital_object set publish = 1;

Blake-

SELECT * FROM  accession  WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM  active_edit  WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM  agent_contact  WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM  agent_corporate_entity  WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM  agent_family  WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM  agent_person  WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM  agent_software  WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM  archival_object  WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM  aspace-dts_schema_info  WHERE user_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM  assessment  WHERE user_mtime LIKE '2020-03-08 02:00%'

Blake-

SELECT * FROM  accession  WHERE system_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM  active_edit  WHERE system_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM  agent_contact  WHERE system_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM  agent_corporate_entity  WHERE system_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM  agent_family  WHERE system_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM  agent_person  WHERE system_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM  agent_software  WHERE system_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM  archival_object  WHERE system_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM  aspace-dts_schema_info  WHERE system_mtime LIKE '2020-03-08 02:00%'
SELECT * FROM  assessment  WHERE system_mtime LIKE '2020-03-08 02:00%'

Blake-

Don't Actually Run All The Commands At Once!!!

update  accession                          set system_mtime = NOW();
update  active_edit                        set system_mtime = NOW();
update  agent_contact                      set system_mtime = NOW();
update  agent_corporate_entity             set system_mtime = NOW();
update  agent_family                       set system_mtime = NOW();
update  agent_person                       set system_mtime = NOW();
update  agent_software                     set system_mtime = NOW();
update  archival_object                    set system_mtime = NOW();

Blake-

This will force a solr reindex w/o needing to clear out the /data/ directory

UPDATE accession set  system_mtime = NOW();
UPDATE agent_contact set system_mtime = NOW();
UPDATE agent_corporate_entity set system_mtime = NOW();
UPDATE agent_family  set system_mtime = NOW();
UPDATE agent_person set system_mtime = NOW();
UPDATE agent_software set system_mtime = NOW();
update archival_object set system_mtime = NOW();
update assessment set system_mtime = NOW();

Blake-

SELECT node_counter.totalcount as count, node.title, DATE_FORMAT(FROM_UNIXTIME(node.created), '%e %b %Y') 
FROM node_counter, node WHERE node.nid = node_counter.nid and
FROM_UNIXTIME(node.created, '%Y') = 1999 order by count desc limit 20

Blake-

	

Mounting a s3ql file system to the S3 compatible file system at Softlayer on an Ubuntu 16 Xenial VSI

apt install s3ql

nano /etc/s3ql.authinfo

[softlayer-s3]
backend-login: somelogin

Blake-

find /home/ -name 'version.php' -path '*wp-includes/*' -print -exec grep '$wp_version =' {} \; -exec echo '' \; > all-wp-versions-2.txt