How to Convert Text File From UTF-8 to ISO-8859-1 Encoding

Posted on January 29, 2009 by Raymond

$ iconv --from-code=ISO-8859-1 --to-code=UTF-8 latin1.txt > utf8.txt

or simply

$ iconv -f ISO-8859-1 -t UTF-8 latin1.txt > utf8.txt

$ iconv -t ISO-8859-1 -f UTF-8 inputfile > outputfile

Posted in Linux | Tagged , , | Leave a comment

How to redirect pages to a new domain

Posted on January 5, 2009 by Raymond

RedirectMatch 301 (.*)$ http://www.newdomainhere.com$1

Save this into .htaccess and upload on the root directory on your old domain.

Posted in Apache2, Linux, Linux Administration | Tagged | Leave a comment

How to set a MySQL Table AUTO_INCREMENT

Posted on November 18, 2008 by Raymond

To start with an AUTO_INCREMENT value other than 1, you can set that value with CREATE TABLE or ALTER TABLE, like this:

mysql> ALTER TABLE tbl AUTO_INCREMENT = 100;

Posted in MySQL, SQL | Tagged | Leave a comment

Find a string in files under Subversion

Posted on September 5, 2008 by Raymond

As a programmer, I’ve been using find to locate string in my source code.  Issuing a find would include svn files too which is not my intension.  Here’s the command:

$ find . -not -regex '.*svn.*' -exec grep "$1" '{}' \; -print

Add multiple files to svn repository

$ svn st | grep ^? | cut -b7- | xargs svn add

Posted in subversion | Tagged , , | Leave a comment

How to Remove a MySQL Table constraint

Posted on August 26, 2008 by Raymond

ALTER TABLE `attributes` DROP FOREIGN KEY `attributes_ibfk_1`;

MySQL ERROR 1005 (HY000): Can’t create table ‘Table.frm’ (errno: 150).  Here’s the solution.

Example:
ALTER TABLE `race` DROP FOREIGN KEY `race_ibfk_1`;

ALTER TABLE `race`
ADD CONSTRAINT `race_ibfk_1` FOREIGN KEY (`specieId`) REFERENCES `specie` (`specieId`) ON DELETE CASCADE;

Posted in MySQL, SQL | Tagged , | Leave a comment

How to mount an .iso image file?

Posted on August 25, 2008 by Raymond

$ sudo mount -o loop /path/to/feisty-desktop-i386.iso /tmp/ubuntu-livecd

Posted in Linux, Linux Administration | Tagged , , | Leave a comment

How to Find and Replace a String on the command line?

Posted on August 25, 2008 by Raymond

This command will replace all instances of ‘replaceme’ with ‘newstring’ in files ‘*.php’ on /home/mysite/httpdocs.

find /home/mysite/httpdocs -name '*.php' | xargs replace 'replaceme' 'newstring' --

Posted in Linux, Linux Administration | Tagged , | Leave a comment

How to Refresh my DNS cached record?

Posted on August 24, 2008 by Raymond
  1. Use OpenDNS free services by adding 208.67.222.222 and 208.67.220.220 on your /etc/resolv.conf.
  2. Go to http://www.opendns.com/support/cache/ then enter the website address.
Posted in Linux | Tagged , , | Leave a comment

How to list all users on a Linux machine?

Posted on August 16, 2008 by Raymond

 cat /etc/passwd | cut -d":" -f1

Posted in Linux, Linux Administration | Tagged , | Leave a comment

Multiple SSL Certificate on Single IP

Posted on August 6, 2008 by Raymond

Follow the links:

Virtual host examples from Apache website.

http://httpd.apache.org/docs/2.0/vhosts/examples.html

Turns out that it is possible to have multiple VirtualHosts on port 80 (Default http), but because of a limitation of SSL, we can’t have multiple VirtualHosts on port 443 (Default https).
I solved the problem as follows. I created the two VirtualHosts on port 80, one on port 443 and one on port 444.

Shared IP, multiple vhosts and multiple SSL certificates on Apache

The process is only 2 steps and involves modifying your Apache configuration.
1.  Create virtual hosts “map file”.
2.  Modify existing SSL vhost.

Caveat: The SSL certificate used will be common to all SSL vhosts.

Hosting multiple SSL vhosts on a single IP/Port/Certificate with Apache2

The following article discusses the following:
Basics Of Virtual Hosts, Name-Based Virtual Hosts, IP-Based Virtual Hosts, Configuring IP Aliasing, Virtual Hosts with IPs, Multiple Instances of Apache, Example for name based virtual hosts, Example for IP based virtual hosts.

Creating Name Based and IP Based Virtual hosts in Apache

Posted in Apache2, Linux, Linux Administration | Tagged , , | Leave a comment