This is my note on installing Huawei E220 modem on FreeBSD 7.0. Requirements: 1. Download kernel patch here. 2. Patch kernel: # cd /sys/dev/usb/ # patch < /root/e220-usb.diff 3. Rebuild and install kernel. Don’t forget to unload umass kernel. 4. Load module ubsa and umass by add in this line into /boot/loader.conf file. ubsa_load=”YES” umass_load=”YES” 5. Reboot….
The following tutorial can be used as dictionary for beginner on SQL syntax. SQL syntaxes are used to manipulate data which are select, insert, update, and delete on database. 1. Select Select command is used to get rows of data from table. Syntax: Example: 2. Insert Insert command is used to insert row to table….
Guide on this article can be used to post Twitter using PHP. First of all, download source code from http://phpfashion.com/twitter-for-php. Extract downloaded file to your folder. Example: /public_html/twitter-php/. Then we create index.php file with the following code: The first line is to setup variables: username, password, and message. And the next part is to setup…
There are two approaches to change Grub boot order: command line and GUI. For command line method: Run this command to edit /etc/default/grub: $ sudo nano /etc/default/grub Change the number in GRUB_DEFAULT line. First boot menu is numbered 0. If it is 6th boot menu, type in GRUB_DEFAULT=5. Press CTRL-X, press Y, press Enter (save…
Sudo is a program that allows users to run programs with the security privileges of another user (normally the superuser, or root). The /etc/sudoers file controls who can run what commands as what users on what machines and can also control special things such as whether you need a password for particular commands. To add…
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:…
The Alternative PHP Cache (APC) is a free and open opcode cache for PHP. Its goal is to provide a free, open, and robust framework for caching and optimizing PHP intermediate code. To install APC, do the following commands: Update Feb 25, 2012: I found one liner APC installation from php.net:
Below is guide how to remote backup using rsync. 1. Install rsync on both client and remote computer: 2. Create config file /etc/rsyncd.conf on remote computer: And put these lines into the file: Press Ctrl-X, Y, and Enter to exit from nano. 3. Activate rsync Find RSYNC_ENABLE=false line, and change to RSYNC_ENABLE=true 4. Execute rsync 5….
To enable IIS 6.0 to run 32-bit applications on 64-bit Windows: 1. Open a command prompt and navigate to the %systemdrive%\Inetpub\AdminScripts directory. 2. Type the following command: cscript.exe adsutil.vbs set W3SVC/AppPools/Enable32BitAppOnWin64 true 3. Press ENTER.
I migrated my WordPress website to new domain, so I need to update all image URLs in wp_posts, wp_postmeta, and wp_options table which are still pointing to old domain. These are the SQL syntaxs to update the tables: