Colek Colek

How to Save Apache Access Log into MySQL Database Using libapache2-mod-log-sql on Debian Squeeze

kumkum14 years ago14 years ago22 mins

The purpose of saving Apache access log into MySQL database is to make it easier to parse website’s visitor information. First of all, we do repository update: Install libapache2-mod-log-sql Create apachelogs and scoreboard table: Modify /etc/apache2/sites-available/default: If you have other virtual hosts, you can put LogSQLTransferLogTable directive into each virtual host tag. Create mod_log_sql-preserve file:…

Read / Write NTFS on Mac OSX

kumkum15 years ago15 years ago01 mins

Open Disk Utility: Applications => Utilities => Disk Utility Right click partition, and click Information. Take note the value on Universal Unique Identifier. Open Terminal: Applications => Utilities => Terminal Edit /etc/fstab: $ sudo nano /etc/fstab Type in this line into /etc/fstab: UUID=[type in UUID from disk utility] none ntfs rw Save the file. Reboot.

True Type Fonts in FreeBSD

kumkum18 years ago15 years ago01 mins

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…

How to Setup Github Actions

kumkum7 hours ago7 hours ago02 mins

Here is a concise guide to Setup Github Actions. 1. Generating SSH Keys for GitHub Login to your server which hosting your application. ed25519 is the recommended algorithm (faster and more secure than RSA). Save location: Press Enter to use the default (/root/.ssh/id_ed25519). Passphrase: Press Enter twice to leave it empty (required for automated deployments)….

How to Fix “PHP Warning: PHP Startup: mcrypt: Unable to initialize module” on Centos 5

kumkum14 years ago01 mins

I found this error message after upgrading PHP 5.1.6 to 5.2.14 The problem happens when there is a mismatch version of php-mcrypt module with php installed in the server. You can check the version using this command line: To fix this error, we have to update php-mcrypt module:

Ubuntu: How to Fix “Key is stored in legacy trusted.gpg keyring (/etc/apt/trusted.gpg)”

kumkum4 years ago4 years ago02 mins

To resolve this issue, we have to export GPG key from deprecated keyring. Get list of existing keys Export the key Key BE1229CF is the last 8 digit taken from key list. The following message will appear: Now we can update our apt source file for the repository (e.g., /etc/apt/sources.list.d/microsoft.list), adding a signed-by tag: Update apt to make…

How to Change Root Password on Ubuntu

kumkum14 years ago14 years ago01 mins

If you are tired of using ‘sudo‘ to execute command line activities, you can switch to root user (super user). First of all, we assign a root password: After assign password for root user, you can switch to root user using ‘su’ command and type in the password:

Install FreeBSD 7.0 on BENQ Laptop

kumkum18 years ago15 years ago01 mins

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…

How to Replace Old Domain URL in wp_posts Table

kumkum14 years ago10 years ago21 mins

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:

Web-based MTR Script

kumkum17 years ago14 years ago11 mins

Few days ago I helped my friend to write a web-based MTR, and here is the script: The script will execute shell command similar to:

Colek Colek

How to Disable SSH Root Login in Linux

How to Fix WordPress Error “Briefly unavailable for scheduled maintenance. Check back in a minute”

True Type Fonts in FreeBSD

Play .rmvb file on Kubuntu 8.10

How to Convert .dmg to .iso Using Windows

Moving Averages and Stochastic: Simple Indicators for a Simple Trading Strategy

Enable / Disable Xserver Restart

Coldfusion 7 (32bit) on Windows 64 bit

Using OpenBSD to Connect to WiFi

Select Case Sensitive in MySQL

How to Save Apache Access Log into MySQL Database Using libapache2-mod-log-sql on Debian Squeeze

Read / Write NTFS on Mac OSX

True Type Fonts in FreeBSD

How to Setup Github Actions

How to Fix “PHP Warning: PHP Startup: mcrypt: Unable to initialize module” on Centos 5

Ubuntu: How to Fix “Key is stored in legacy trusted.gpg keyring (/etc/apt/trusted.gpg)”

How to Change Root Password on Ubuntu

Install FreeBSD 7.0 on BENQ Laptop

How to Replace Old Domain URL in wp_posts Table

Web-based MTR Script