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

Check wireless adapter: $ iwconfig You will see wireless adapter as wlan0 or ath0 which depends on what driver is installed. Execute the following command to apply ESSID, network key, channel, and mode: $ sudo iwconfig wlan0 essid yantoknuk-singtel $ sudo iwconfig wlan0 channel 6 $ sudo iwconfig wlan0 key ngumbahkucing $ sudo iwconfig wlan0…

Read More

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