Linux open port iptables -I INPUT -p tcp -m tcp --dport PORTNUMBER -j ACCEPT
Symbolic Link ln -s {/path/to/file-name} {link-name}
SCP Example scp your_username@remotehost.edu:foobar.txt /some/local/directory
TAR tar xvzf file-1.0.tar.gz - to uncompress a gzip tar file (.tgz or .tar.gz)
tar xvjf file-1.0.tar.bz2 - to uncompress a bzip2 tar file (.tbz or .tar.bz2)
tar xvf file-1.0.tar - to uncompressed tar file (.tar)
Call adapter from URL
curl -v -XGET -g http://localhost:8080/invoke?adapter=Test\&procedure=getStories\¶meters=[]
Download Files from web directory
wget -r --no-parent --reject "index.html*" http://url.com
View all ports being listened to on OSX
lsof -i -P | grep -i "listen"
/Applications/Google\ Chrome.app/Contents/MacOS/Google\ Chrome --disable-web-security
for i in *.jar;do echo "" && echo $i && jar -tf $i|grep EventFactoryContext;done |less
Adatper example:
/**********************************************************************************
* Sync
**********************************************************************************/
function sync(){
var invocationData = {
adapter : 'MQTT_Adapter',
procedure : 'sync',
parameters : []
};
WL.Client.invokeProcedure(invocationData, {
onSuccess : syncSuccess,
onFailure : syncFailure
});
}
function syncSuccess(response){
console.log("sync Success");
console.log(response);
var returnedItems = response.invocationResult.items;
for(var i=0; i<returnedItems.length; i++){
addItemToList('#item_list', returnedItems[i]);
}
}
function syncFailure(response){
console.log("sync Failure");
console.log(response);
}
Get size of DB
SELECT table_schema "Data Base Name", SUM( data_length + index_length) / 1024 / 1024
"Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema ;
Get size of DB
SELECT
table_schema, count(*) TABLES,
concat(round(sum(table_rows)/1000000,2),'M')
rows,concat(round(sum(data_length)/(1024*1024*1024),2),'G')
DATA,concat(round(sum(index_length)/(1024*1024*1024),2),'G')
idx,concat(round(sum(data_length+index_length)/(1024*1024*1024),2),'G')
total_size,round(sum(index_length)/sum(data_length),2) idxfrac
FROM
information_schema.TABLES group by table_schema;
Get row size in bytes
select
device_id,
sum(length(device_id) + length(friendly_name) + length(user_id) + length(device_os) + length(device_model)+ length(last_accessed_time)+ length(status)) as bytes
from DEVICES
where device_id = "00009304-A35B-3F8C-BB96-7FFCA1840C0C";
Amazon EC2
sudo yum install gcc-c++ make
sudo yum install openssl-devel
sudo yum install git
git clone git://github.com/joyent/node.git
cd node
git checkout v0.8.1
./configure
make
sudo make install
xcrun -sdk iphoneos lipo -info
Javascript closure
downloadLogsBtn.on("click", function(deviceId){
return function(){
Utility.downloadData(page, "downloadLogs/"+ deviceId);
};
}(data.deviceId));