manuthu

-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

manuthu

# Install the nifty client
# pip install git+https://github.com/east36/python-nifty-client.git

import logging
from niftyclient import NiftyClient


logging.basicConfig(level=logging.DEBUG)
logger = logging.getLogger('STK')

manuthu

sudo su postgres
psql

update pg_database set datistemplate=false where datname='template1';
drop database Template1;
create database template1 with owner=postgres encoding='UTF-8' lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0;
update pg_database set datistemplate=true where datname='template1';

manuthu

# Sample Nginx config with sane caching settings for modern web development
#
# Motivation: 
# Modern web development often happens with developer tools open, e. g. the Chrome Dev Tools. 
# These tools automatically deactivate all sorts of caching for you, so you always have a fresh 
# and juicy version of your assets available.
# At some point, however, you want to show your work to testers, your boss or your client. 
# After you implemented and deployed their feedback, they reload the testing page – and report 
# the exact same issues as before! What happened? Of course, they did not have developer tools 
# open, and of course, they did not empty their caches before navigating to your site. 

manuthu

Get the user_id from the console/portal

List all the files belonging to the user . For this case, we use - 6a76bf01-dc90-4996-a846-8472cb086565

rados ls -p .rgw.buckets | grep 6a76bf01-dc90-4996-a846-8472cb086565

Save the files to a log file

manuthu

-- db=# \d order_payment
--                    Table "public.order_payment"
--      Column       |            Type             | Collation | Nullable | Default
-- -----------------+-----------------------------+-----------+----------+---------
-- id                | uuid                        |           | not null |
-- order_id          | uuid                        |           |          |
-- amount_paid       | numeric                     |           |          |
-- ...

select

manuthu

# Get all running routers. Routers in cloudstack are prefixed with `r-DIGIT`
RUNNING_VMS=$(xe vm-list | grep -A2 -B2 'r-[0-9]' | grep uuid | awk -F':' '{print $2}')
SRID=8c269040-fc42-c12d-b091-8958784ec65e

for vm_id in $RUNNING_VMS
do
  xe vbd-list vm-uuid=$vm_id | grep vdi-uuid | awk -F':' '{print $2}' | xargs -I {} xe vdi-list uuid={} | grep $SRID  && echo $vm_id
done

manuthu

Install PostgreSQL 10 on Ubuntu

This is a quick guide to install PostgreSQL 10 - tested on Ubuntu 16.04 but likely can be used for Ubuntu 14.04 and 17.04 as well, with one minor modification detailed below.

(Optional) Uninstall other versions of postgres

To make life simple, remove all other versions of Postgres. Obviously not required, but again, makes life simple.

dpkg -l | grep postgres

manuthu

References

• have fun with them
• projections
• filters
• resource-keys
• scripting-gcloud
• gcloud alpha interactive
• https://medium.com/@Joachim8675309/getting-started-with-gcloud-sdk-part-1-114924737
• https://medium.com/@Joachim8675309/getting-started-with-gcloud-sdk-part-2-4d049a656f1a
• https://gist.github.com/bborysenko/97749fe0514b819a5a87611e6aea3db8

manuthu

#!/opt/venv/ipblock/env/bin/python
__author__ = 'Mike Manuthu <muragumichael@gmail.com>'
"""
A simple script to disable the number of connections to the server.
Uses IPTables to block the IPS with more than the threshold connections.

Uses Fail2Ban as the default IP Blocker.

usage: IP Blocker ::  [-h] [-i IP] [-I IPRANGE] [-c CONNECTIONS] [-B]
                      [-f FREQUENCY]