Degree Programs in Systems Administration
Just a reminder, https://sites.google.com/site/educatingsystemsfolks/home/university-programs lists degree programs in system administration.
Author Archive: Aleksey_Tsalolikhin
Technical Resume Writing tips
I've recently read up on resume writing with an eye how I can improve my resume and job prospects. My main takeaways were: For maximum impact, tailor the resume to the position you are applying for. Keep the resume to one or two pages long – no more! Provide a compact summary of professional experience…
Making standalone network diagrams with nwdiag
nwdiag generates a network-diagram image file from a .diag text file logically describing the network http://blockdiag.com/en/nwdiag/ nwdiag is intended to generate network diagrams that are embedded in larger documents; not for generation of standalone documents. Therefore there is no provision for adding document metadata, such as Name, Author, Date. However, you can add an infobox (a…
Making graphs in the Postgres client shell
Here is an example of feeding query output into gnuplot without leaving psql: # psql -U postgres psql (8.4.15) Type “help” for help. postgres=# t Showing only tuples. postgres=# a Output format is unaligned. postgres=# f ‘ ‘ Field separator is ” “. postgres=# select * from example; 1 1 2 2 3 3 4…
Getting an strace sample programmatically (non-interactively)
Getting an strace sample programmatically (non-interactively): dynamically attaching to a running process and detaching from it 10 seconds later. May be used to check if a process is hung, or what is it doing? #!/bin/sh … rm -rf strace.out strace -o strace.out -p $PID & sleep 10 pkill -int strace # send SIGINT…
Using IRC – a write-up for my developers
[I wrote this for our developers to help them get on IRC.] You can get support from the open source community over IRC (Internet Relay Chat), live text-based group chat. I installed the “irssi” package from the RPMforge repository to get on IRC. Using IRC ======= Start irssi: irssi Connect to the Freenode IRC network,…
Postgres 9.2 allows on-the-fly insight into query performance with pg_stat_statements
Postgres 9.2 includes a very handy pg_stat_statements shared library and extension which allows immediate insight into query performance. Installation: ———— 1. Add to postgresql.conf: shared_preload_libraries = ‘pg_stat_statements’ 2. Restart PostgreSQL. 3. Run create extension pg_stat_statements; to have access to the statistics and the helper functions. Use — — reset statistics select pg_stat_statements_reset(); — which query…
Guess encoding of a file
#!/usr/bin/perl # Name: guess_encoding.pl # Author: Aleksey Tsalolikhin # Date: 19 Oct 2012 # Description: guess encoding of a file (for example, to answer # the question is the encoding UTF-8 or Latin-1?). This script # uses the "file" utility but it is more precise than just # running "file" on your input…
Little perl script to print lines containing non-ASCII characters
#!/usr/bin/perl # Name: print-non-ascii.pl # Description: print lines containing non-ASCII characters (anything # other than 000 – 127). # Could be useful when working with Western Latin / UTF8 / etc. # encoded files and troubleshooting encoding issues. while ($line=<STDIN>) { if ($line !~ /^[x00-x7F]+$/) { print $line; } }
One-liner to syntax-check and strict-mode check all your PHP code
The following command does a syntax check and a strict mode check on all PHP code under /var/www/html: find /var/www/html -name “*.php” -exec php -d display_errors=1 -d error_reporting=4095 -l {} ; 2>&1 >/dev/null #4095 means E_STRICT|E_ALL