How to brute-force password protected zip file?
Imagine a situation when you need to unzip a password protected zip file. So, how do we do it?
Get a password file (file that will contain possible passwords one per line)
Write a bash script, total 8 lines of code
Run the script and wait… (depends on processing power, password file size, etc)
synack@deimos $ cat crack.sh#!/bin/bash# Author: [...]
Leopard upgrade
Well, it was 26th when I went to our local (read nearest) Mac shop, I knew that I’m not gonna be purchasing Leopard, it was more of to see what is gonna happen… Basically, when I reach the shop, the doors were half closed, and some sort of crowd was outside.
Next day onwards I’ve read [...]
Read/write activity on tables – PostgreSQL
If you ever wanted to know which tables are actively being hit on your database, please pay attention to: http://www.postgresql.org/docs/8.1/static/monitoring-stats.html
postgres@server:~$ psql testdb -c “select relname, idx_tup_fetch as seeks, n_tup_ins + n_tup_upd + n_tup_del as writes from pg_stat_user_tables order by writes desc limit 5;”
relname | seeks | writes
——————+———+——–
user [...]
How big is PostgreSQL database size?
Today found another very useful info from http://www.planetpostgresql.org/
tempdb=# SELECT pg_database.datname,
pg_size_pretty(pg_database_size(pg_database.datname)) AS size
FROM pg_database;
And this is what it shows:
datname | size
——————+———
postgres | 3480 kB
jasperserver | 82 MB
testdb | 3480 kB
template1 | 3537 kB
template0 | 3480 kB
tempdb | 127 MB
(6 rows)
Time: 143.405 ms