Using tshark to Decrypt SSL/TLS Packets

I’m going to walk you through the process of decoding SSL/TLS traffic from a pcap file with the server’s private key using tshark (command-line version of Wireshark). You can, of course, always use ssldump for the same purpose. I assume you know how SSL/TLS works, and basic understanding of how Wireshark works, and why we […]

Making SQL Queries

This article is to summarize how do we make SQL queries using different languages and their methods. Making connection to the database will not be covered here. In the examples, we will be querying “SELECT * FROM employees where eid =and dept =” It is not recommended to use SQL statements without placeholders in order […]

KDE 4.8, Google Chrome and the Proxy

My KDE was just upgraded to v4.8 from v4.7.x. Privoxy was also configured on the same PC, just to strip some codes. Google Chrome is configured to use the Privoxy proxy on port 8118. After the upgrade, Google Chrome has failed to connect to internet. At the same time, Firefox was working perfectly with or […]

YQL, Python, and Yahoo Finance

YQL is the way to get information from Web Services using SQL-like queries. It also provides us a console where we can test our queries and generate the REST query. To see how it works, just go to the console page, and enter the following as the YQL statement:

And set the output to […]

SSL and HTTP Basic Authentication

In general, when I want to force the browser to access certain part of my website via https if the request is made with http, I would put a .htaccess inside that web directory.

But when I want to protect the directory with HTTP Basic Auth, it creates double authentication. I’ll expand this section […]