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 assumption here is that apache web server already installed in system. Below is guide on how to install MRTG and SNMP packages. 1. Install MRTG and SNMP 2. Configure SNMP Backup configuration file: Create new configuration file: And replace the current content with these lines: Edit /etc/default/snmpd And make sure the file contains these…
Memcached is free & open source, high-performance, distributed memory object caching system, generic in nature, but intended for use in speeding up dynamic web applications by alleviating database load. First of all, install memcached dan php5-memcached packages: and then make sure memcached is running with this command: Restart apache web server: Check php5-memcached module using…
VNC is a protocol that allows a desktop to be viewed and controlled remotely over the Internet. This is how to create VNC tunnel via SSH. Requirements: Ubuntu system (as VNC Server) Windows system (as VNC Viewer) PuTTY for Windows TightVNC Viewer or RealVNC for Windows In Ubuntu PC, install x11vnc and openssh-server: $ sudo…
Hardware specification: BENQ Joybook 2000 1.5 Ghz; RAM 512 MB First of all, download .iso file from http://freebsd.org. There are 3 files to download: disk1 disk2 disk3 Burn all .iso files into CD, and then start installation using disk1. Step by step installation can be read on FreeBSD website. After finished with sysintall, we do…
This tutorial applies for Grub version 1. Using Ubuntu Live CD, here are the steps: 1. Open terminal, run grub $ sudo grub 2. On grub command prompt, find boot record grub> find /boot/grub/stage1 or, if result an error, change to: grub> find /grub/stage1 3. Make root. Change X,Y with the number of partition from…
Virtualbox Open Source Edition can be installed using Software Manager in Linux Mint. But if you want to use USB feature in Virtualbox, you have to install the non-free version of Virtualbox. Below is step by step guide how to install Virtualbox 4.1 non-free version on Linux Mint: 1. Edit /etc/apt/sources.list 2. Add this repository…
We can use ‘tail’ command feature in Windows using Powershell. Run Powershell and execute this command: Change [filename] with your file. Number 30 means show the last 30 lines.
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….
I’m new to Virtualmin hosting control panel and I got this error message when login to webmail via https://domain.com:20000 This problem happens when Dovecot IMAP and POP3 service is not started. So I start the service and problem solved.