Skip to content

Instantly share code, notes, and snippets.

View haisum's full-sized avatar

Haisum Mussawir haisum

View GitHub Profile
@haisum
haisum / gist:bb2136e83489edaaf3e83e0fca968979
Created July 21, 2017 14:52
Forward unexposed docker ports
ssh -N -T -L *:8001:localhost:8000 dockerhost.local
@haisum
haisum / firewalld enable logs
Created July 13, 2017 06:57
enable logs on firewalld via firewall-cmd
sudo firewall-cmd --set-log-denied=all
@haisum
haisum / instructions.txt
Created May 9, 2017 13:05
Selecting specific yum package version
To see what particular versions are available to you via yum you can use the --showduplicates switch.
$ yum --showduplicates list httpd | expand
Loaded plugins: fastestmirror, langpacks, refresh-packagekit
Loading mirror speeds from cached hostfile
* fedora: mirror.steadfast.net
* rpmfusion-free: csc.mcs.sdsmt.edu
* rpmfusion-free-updates: csc.mcs.sdsmt.edu
* rpmfusion-nonfree: csc.mcs.sdsmt.edu
* rpmfusion-nonfree-updates: csc.mcs.sdsmt.edu
@haisum
haisum / releases.sh
Created November 2, 2016 22:46
Create and upload github releases
go get github.com/aktau/github-release
echo "export GITHUB_TOKEN=$1" >> ~/.bash_profile;
git tag v0.0
git push --tags
github-release.exe -v release --repo focusedu --user haisum -t v0.0 -d "Static file server"
github-release.exe -v upload --repo focusedu --user haisum -t v0.0 -n focusedu.exe -f focusedu.exe
@haisum
haisum / goget.sh
Last active November 2, 2016 21:56
go sublime settings
go get -v github.com/golang/lint/golint
go get golang.org/x/tools/cmd/goimports
go get -v golang.org/x/tools/cmd/guru
go get -v github.com/rogpeppe/godef
@haisum
haisum / dropuser.sql
Created October 10, 2016 08:26
Dropping connected users in oracle
select 'alter system kill session ''' || sid || ',' || serial# || ''';' from v$session where username = 'SCHEMANAME'
alter system kill session '1977,12013';
drop user 'SCHEMANAME';
@haisum
haisum / first_swagger.json
Created September 3, 2016 00:12
first swagger
{
"swagger": "2.0",
"info": {
"description": "This is API documentation for SMS gateway.",
"version": "1.0.0",
"title": "SMS Gateway",
"contact": {
"email": "haisumbhatti@gmail.com"
}
},
@haisum
haisum / backup-steps.sh
Last active August 17, 2016 08:50
Backing up and migrating mysql between servers
/bin/bash -c "innobackupex --stream=tar ./ | gzip -c -1 > /backup/mysql-master-17-08-2016.tar.gz" 2>/backup/mybkp.log
scp backup.tar.gz remoteuser@remotehost:/backup/
cd backup
mkdir mysql-backup
cd mysql-backup
tar -xzif backup.tar.gz
innobackupex --apply-log --use-memory=2G /backup/mysql-backup
service mysql stop
mv /var/lib/mysql /var/lib/mysql-old
mkdir /var/lib/msyql
@haisum
haisum / example_receiver.sh
Last active May 26, 2016 08:44
example receiver script
#!/bin/bash
SRC=$1
DST=$2
MSG=$3
CONN=$4
GROUP=$5
# Example of saving received sms to a file as csv
@haisum
haisum / oracle_all_fk_references_of_table.sql
Created May 19, 2016 11:04
Find all foreign key reference to a table in oracle
select
src_cc.owner as src_owner,
src_cc.table_name as src_table,
src_cc.column_name as src_column,
dest_cc.owner as dest_owner,
dest_cc.table_name as dest_table,
dest_cc.column_name as dest_column,
c.constraint_name
from
all_constraints c