Find FTS servers that can't talk to a myproxy

for i in `grep 2010 download-fts |grep lcgrbp01|awk -F policy '{print $2}' |sort|uniq|awk -F \" '{print $2}'`; do grep $i download-fts |tail -1|awk -F FileDownload '{print $1}';echo $i; done

VNC to work machine

I always forget how to do VNC over SSH (despite having a handy alias set up for it...), so here's how to set it up.

1. run vncon on the host (alias doing what's described on http://www.macosxhints.com/article.php?story=20080318190503111)
2. run plaguevnc on the laptop to ssh tunnel vnc traffic
3. connect to localhost:1212 in screen sharing
4. do stuff... erm...
5. run vncoff on the host

Ignore http://technotes.twosmallcoins.com/?tag=os-x-screen-sharing which sounds like it does what you want but doesn't...

rsync a directory to another destination

I wanted to sync up a directory on one machine to another, but I only wanted to transfer missing files (not updated) and to have the transferred files written to another directory (so I could easily find them and perform another action on them). The following mammoth incantation does the job:

rsync --verbose  --progress --ignore-existing --stats --compress 
--rsh=/usr/bin/ssh --size-only --compare-dest='~/Music/iTunes/iTunes\ Music/' 
--recursive ~/Music/iTunes/iTunes\ Music/* macmini.local:'~/Desktop/incoming-music'

This makes a bunch of empty directories (those that the --compare-dest contains but we don't write to), cleaning them up is as simple as:

find Desktop/incoming-music/ -type d -print0 | xargs -0 rmdir -p

Add recent items to Dock

defaults write com.apple.dock persistent-others -array-add '{ "tile-data" = { "list-type" = 1; }; "tile-type" = "recents-tile"; }'

I can't remember where I got this from, but the link in the title takes you to a page with more of the same....

As do:

• http://secrets.blacktree.com/
• http://www.macosxtips.co.uk/index_files/terminal-commands-for-hidden-settings-in-leopard.html
• http://www.macworld.com/article/132447/2008/03/leopardsurvival2.html
• http://www.ss64.com/osx/defaults.html
  

Using find to delete files

I pretty much always forget how to use find. So here's how you delete a bunch of files (handy for those of us who sync things from a mac to a linux box):

find . -type f -name ".DS_Store" -exec rm -f {} \;

[from here]

Find and replace in files

awk '{gsub(/CmdLineArgs.opts.baseUrl/, "$context.ConfigParser().get(\"setup\", \"basepath\")", $0); print > FILENAME}' *

from here and here.

Creating new tables from queries

The following is kind of handy:


create table new_table_name as select * from old_Table_name;

for instance:

create table phedex_node_cms_name_map as
select phedex_node.id as node_id, cms_name.id as CMS_NAME_ID
from phedex_node
inner join cms_name
on phedex_node.site = (select site_id from site_cms_name_map where CMS_NAME_ID=cms_name.id)

or even more awesomely:

create table phedex_node_cms_name_map as
select NODE_ID, CMS_NAME_ID from(
select phedex_node.name as node, cms_name.name as cmsname, phedex_node_cms_name_map_tmp.cms_name_id, phedex_node_cms_name_map_tmp.node_id
, regexp_substr(cms_name.name,'_[A-Z]+$',1)
from phedex_node
join phedex_node_cms_name_map_tmp on phedex_node_cms_name_map_tmp.node_id = phedex_node.id
join CMS_NAME on CMS_NAME.id = phedex_node_cms_name_map_tmp.cms_name_id
where phedex_node_cms_name_map_tmp.node_id in (
select node_id from (
select count(node_id) as count, node_id from phedex_node_cms_name_map_tmp group by node_id
) where count > 0
)
and
regexp_like (phedex_node.name,regexp_substr(cms_name.name,'_[A-Z]+$',1))
order by CMSNAME)