Skip to content

Instantly share code, notes, and snippets.

View bcmiller's full-sized avatar

Bill C. Miller bcmiller

13 followers · 13 following
  • emortgagelogic.om
  • arlington, tx
View GitHub Profile
@bcmiller
bcmiller / rsync etc data that changed
Created September 15, 2010 01:47
root@ip-172-19-1-6:/vol# rsync -avz /etc/* /vol/etc
sending incremental file list
fstab
mtab
cannot delete non-empty directory: pound
could not make way for new regular file: pound
resolv.conf
apparmor.d/cache/
apparmor.d/cache/sbin.dhclient3
apparmor.d/cache/usr.sbin.mysqld
@bcmiller
bcmiller / demo2 sql hanging
Created September 17, 2010 20:13
SELECT DISTINCT node.nid AS nid, node.title AS node_title, node_data_field_date.field_date_value AS node_data_field_date_field_date_value, node_data_field_date.field_date_value2 AS node_data_field_date_field_date_value2, node_data_field_date.field_date_rrule AS node_data_field_date_field_date_rrule, node_data_field_date.delta AS node_data_field_date_delta, node.type AS node_type, node.vid AS node_vid, term_data.name AS term_data_name, term_data.vid AS term_data_vid, term_data.tid AS term_data_tid FROM node node LEFT JOIN og_ancestry og_ancestry ON node.nid = og_ancestry.nid INNER JOIN node node_og_ancestry ON og_ancestry.group_nid = node_og_ancestry.nid LEFT JOIN content_field_date node_data_field_date ON node.vid = node_data_field_date.vid LEFT JOIN content_field_date node_data_field_date2 ON node.vid = node_data_field_date2.vid LEFT JOIN term_node term_node ON node.vid = term_node.vid LEFT JOIN term_data term_data ON term_node.tid = term_data.tid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.gran
@bcmiller
bcmiller / gist:594418
Created September 23, 2010 21:34
prod cal page
SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid FROM node node LEFT JOIN og_ancestry og_ancestry ON node.nid = og_ancestry.nid INNER JOIN node node_og_ancestry ON og_ancestry.group_nid = node_og_ancestry.nid LEFT JOIN content_field_date node_data_field_date ON node.vid = node_data_field_date.vid LEFT JOIN content_field_date node_data_field_date2 ON node.vid = node_data_field_date2.vid LEFT JOIN term_node term_node ON node.vid = term_node.vid LEFT JOIN term_data term_data ON term_node.tid = term_data.tid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 9735 AND na.realm = 'statusbook_friend') OR (na.gid = 9805 AND na.realm = 'statusbook_friend') OR (na.gid = 9835 AND na.realm = 'statusbook_friend') OR (na.gid = 9855 AND na.realm = 'statusbook_friend') OR (na.gid = 9865 AND na.realm = 'statusbook_friend') OR (na.gid = 9895 AND na.realm = 'statusbook_friend') OR (na.gid = 9925 AND na.realm = 'statusbook_friend') OR (na.gid = 9935 A
@bcmiller
bcmiller / harvest issues
Created October 14, 2010 02:50
Oct 13 21:44:34 stats01 crontab[6318]: (root) LIST (root)
Oct 13 21:44:46 stats01 drupal: http://www.allplayers.com|1287024286|FeedsScheduler|127.0.0.1|http://www.allplayers.com/cron.php||0||Finished processing schedule after 0 sec.
Oct 13 21:45:01 stats01 /USR/SBIN/CRON[6340]: (root) CMD (/mnt/apci/main/www/sites/scripts/feature-check 2>&1 >/dev/null)
Oct 13 21:45:01 stats01 /USR/SBIN/CRON[6341]: (root) CMD ([ -x /usr/lib/sysstat/sa1 ] && { [ -r "$DEFAULT" ] && . "$DEFAULT" ; [ "$ENABLED" = "true" ] && exec /usr/lib/sysstat/sa1 $SA1_OPTIONS 1 1 ; })
Oct 13 21:45:01 stats01 /USR/SBIN/CRON[6368]: (root) CMD (/mnt/apci/main/scripts/phpwarn.pl 2>&1 >/dev/null)
Oct 13 21:45:01 stats01 /USR/SBIN/CRON[6369]: (www-data) CMD (/mnt/apci/default_profile-grab.sh 2>&1 >/dev/null)
Oct 13 21:45:26 stats01 drupal: http://www.allplayers.com|1287024326|php|127.0.0.1|http://www.allplayers.com/cron.php||0||User warning: S3::deleteObject(): [NoSuchBucket] The specified bucket does not exist in S3::deleteObject() (line 738 of /mn
@bcmiller
bcmiller / gist:650097
Created October 27, 2010 21:55
add cloud front..
root@ip-172-19-1-3:/mnt/apci/main/www/sites/all# drush updatedb
The following updates are pending:
apci_media_mover module
6010 - Add cloudfront on media mover configs for Image node image to S3
Do you wish to run all pending updates? (y/n): y
Executing apci_media_mover_update_6010 [success]
@bcmiller
bcmiller / gist:650098
Created October 27, 2010 21:55
add cloud front..
root@ip-172-19-1-3:/mnt/apci/main/www/sites/all# drush updatedb
The following updates are pending:
apci_media_mover module
6010 - Add cloudfront on media mover configs for Image node image to S3
Do you wish to run all pending updates? (y/n): y
Executing apci_media_mover_update_6010 [success]
@bcmiller
bcmiller / gist:700335
Created November 15, 2010 13:10
fix books anon
UPDATE menu_links SET options='a:0:{}', module='book' WHERE menu_name LIKE 'book%';
@bcmiller
bcmiller / convert issue
Created November 19, 2010 16:37
convert issue stats01
root@stats01:~# ps -ef|grep convert
www-data 7371 2723 0 07:37 ? 00:00:00 sh -c /usr/bin/convert 'sites/default/files/group_content_logo/thunder.gif' -crop 720x3000+-267+-1433! -quality '75' 'sites/default/files/imagecache/spaces_photos_photo/group_content_logo/thunder.gif'
www-data 7372 7371 77 07:37 ? 02:00:54 /usr/bin/convert sites/default/files/group_content_logo/thunder.gif -crop 720x3000+-267+-1433! -quality 75 sites/default/files/imagecache/spaces_photos_photo/group_content_logo/thunder.gif
root 14838 9290 0 10:13 pts/1 00:00:00 grep convert
root@stats01:~# ps -ef|grep 2723
www-data 2723 2700 0 07:10 ? 00:00:10 /usr/sbin/apache2 -k start
www-data 7371 2723 0 07:37 ? 00:00:00 sh -c /usr/bin/convert 'sites/default/files/group_content_logo/thunder.gif' -crop 720x3000+-267+-1433! -quality '75' 'sites/default/files/imagecache/spaces_photos_photo/group_content_logo/thunder.gif'
root 14840 9290 0 10:13 pts/1 00:00:00 grep 2723
root@stats01:~#
@bcmiller
bcmiller / the group explain.txt
Created March 1, 2011 14:13
group explain
Filesort
+- TEMPORARY
table temporary(nr,n,na)
+- JOIN
+- Distinct/Not-Exists
| +- Filter with WHERE
| +- Bookmark lookup
| +- Table
| | table na
| | possible_keys PRIMARY
@bcmiller
bcmiller / gist:952812
Created May 3, 2011 04:21
aconteras sbox
ubuntu@ip-172-19-125-34:/mnt/apci/main$ git diff mainline/master --numstat1 1 bin/drush
1 1 bin/pivotalphp
7 1 www/sites/all/modules/allplayers/apci_group_operations/apci_plugin_argument_default_group_
3 1 www/sites/all/modules/allplayers/og_rap/handlers/og_rap_handler_filter_roles.inc
8 125 www/sites/all/modules/apci_features/apci_messaging_feature/apci_messaging_feature.features
0 23 www/sites/all/modules/apci_features/apci_messaging_feature/apci_messaging_feature.module
0 13 www/sites/all/modules/apci_features/apci_messaging_feature/apci_messaging_feature.rules.in
16 0 www/sites/all/modules/apci_features/apci_messaging_feature/apci_messaging_feature.views.in
0 1 www/sites/all/modules/apci_features/spaces_og_registration/spaces_og_registration.views_de
2 2 www/sites/default/default_env_settings.php