Connect to Wireless Network (WPA) in Ubuntu 11.04 using Command Line

Install wpa supplicant package: $ sudo apt-get install wpasupplicant Configure network ESSID and passphrase. In this example I use ESSID ‘yantoknuk-singtel’ and passphrase ‘ngumbahkucing’. $ wpa_passphrase yantoknuk-singtel # reading passphrase from stdin After that, type in your passphrase right below the text ‘# reading passphrase from stdin’. # reading passphrase from stdin ngumbahkucing network={ ssid=”yantoknuk-singtel”…

Read More

Select Case Sensitive in MySQL

Today I found bug on my website while using MySQL query. I just realized that the search function works in case insensitive. If I execute this query: SELECT filename FROM data_ebook WHERE filename = ‘Manasik_Haji_dan_Umroh.pdf’ the results will be: — Manasik_Haji_dan_Umroh.pdf Manasik_Haji_Dan_Umroh.pdf — By using keyword ‘LIKE BINARY’ it can make the result case sensitive:…

Read More

Setup Squid MRTG on Ubuntu 10.10

Update Feb 23: to install only MRTG and SNMP please read this article.   Install MRTG, Apache2, Squid and SNMP $ sudo apt-get install apache2 snmpd mrtg snmp-mibs-downloader squid Configure SNMP Backup /etc/snmp/snmpd.conf $ sudo mv /etc/snmp/snmpd.conf /etc/snmp/snmpd.conf.bak Create new /etc/snmp/snmpd.conf $ sudo nano /etc/snmp/snmpd.conf and key in these lines: rocommunity  public syslocation  “Bukit Batok”…

Read More

True Type Fonts in FreeBSD

This is tutorial how to install true type font in FreeBSD. Load  freetype module in  /etc/X11/xorg.conf file inside “Module” section: Load “freetype” And then, create folder for True Type Font (.ttf). It has default location in /usr/local/lib/X11/fonts/TTF. Copy all .ttf files to this folder (some files have Microsoft license, it is not legal to copy). Create fonts.dir…

Read More