SocksCap 32bit v2.40 download

I need this for a project, but finding this software is real pain. Since the original developer (Permeo) is not around anymore, neither their site. Trying “sockscap download”, “sc32r240.exe download” on Google got me to dead end [sigh]. Anyway, here is the working download link. Here is

Read More »

How to: create SSH tunnel with PuTTY

Why do we want to do this? Because we do not want people to sniff / logging our activity. So, we would want to encrypt what we are sending and receiving over the net. This is the most easy and cheap way to set up proxy using SSH connection, provided you already have SSH access to a server / host….

Read More »

How to fix buggy Venus VT-12 CDMA USB modem driver

Venus VT-12 is a CDMA USB wireless modem. Modem specifications: [*] CDMA 2000 1x with RUIM, 800 MHz Frequency band. [*] Using Qualcomm Chipset. [*] Up to 230.4 Kbps (average 60-100 Kbps). [*] Compatible with USB 1.0/1.1/2.0 Symtoms: [*]Random disconnect. [*]Once disconnected, unable to reconnect again until the computer restarted. [*]Sometimes, error about svchost pop’d up. Fix: [*]Unplug the USB…

Read More »

How to: run Opera Mini from your computer

Why do we want to do this? Only one thing I can think of (at the moment), you are on a slow connection. We will be using Kwyshell Midp2Exe to convert the Opera Mini jar file to Win32 executable file. Steps: [*] Download Midp2Exe from Kwyshell. Download link can be seen on top of the page. [*] Download runtime library…

Read More »

How to configure Venus VT-12 CDMA USB modem with TelkomFlexi

TelkomFlexi is a fixed wireless CDMA provider. We will be using their FlexiNet Unlimited package. If you haven’t installed the modem, see this link before proceed with the following steps. Steps: [*] Edit the wvdial configuration file: nano /etc/wvdial.conf [*] You’ll see something like these: [Dialer Defaults] Modem = /dev/ttyUSB0 Baud = 460800 Init1 = ATZ Init2 = ATQ0 V1…

Read More »

Move rows between tables, avoid duplicate and update auto increment value.

Table “books” and “books_tmp” is identical. “books” table is production state.“books_tmp” is sandbox/testing/pre-production state. Data comes in csv files >> dumped to “books_tmp” >> checked, sorted, etc. >> good data moved to “books”, row by row. Before moved, “books_tmp” data is checked for duplicates in “books”, using ISBN (unique).Upon inserted into “books”, (auto increment) id is checked for duplicate, if…

Read More »