Category: Uncategorized

  • Extracting private key and certificate from pfx file

    To extract private key: To extract certificate: To do the opposite openssl pkcs12 -export -in certificate.crt -inkey certificate.key -out certificate.pfx

  • Making SQL Server Express listen for TCP connections

    Start Configuration Manager (separate program with that name), go to “SQL server network configuration”, choose “Protocols” bellow that – right click TCP/IP and click enable if not enabled already. Right click it again – choose properties this time, choose no for “listen all” unless you are exposing service to other machines, then on next tab…

  • Basic linux firewall configuration (iptables)

    Linux firewall divides all traffic into 3 groups First two are obvious, third group I guess also covers nat and similar features. Traffic is controlled by adding accept or reject rules to appropriate group – compared to OpenBSD’s pf iptables seems to be missing tables (weird choice for name, he he), all rules seem to…

  • How to install deb file on linux

    dpkg -i filename.deb

  • IPsec based VPN using FreeBSD

    Since I wasn’t really able to find information how to set this up on one place here is short recipe. Prerequisites: After this some introduction to entire problem comes handy. Most important thing to understand here is how IPsec actually works within operating system – you can get some help here from setkey (8) with…

  • How to create pdfs from man pages

    man -t page_name | ps2pdf – page_name.pdf Sometimes this pdf actually looses some formatting (I don’t have any idea why), so it might make more sense to create plain ps fileman -t page_name > page_name.ps Note: You might want to change page size in /usr/share/groff_font/devps/DESC (by default it is set to letter there)