How to change mysql time zone Edit /etc/my.cnf and change your time zone. root@box1 [/var/lib/mysql]# cat /etc/my.cnf [mysqld_safe] timezone = Europe/London ~ [mysqld] set-variable = max_connections=500 safe-show-database Login to mysql and check the time now. root@box1 [/var/lib/mysql]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 369 [...]
Setting up the Tunnel The most common methods of setting up a tunnel are through putty or through command-line SSH. To open an SSH tunnel via the command line, run: ssh -L3307:127.0.0.1:3306 -p 22 -N -t -x user@myhost.com Connecting with MySQL You can connect to the MySQL server! You want to choose 3307 for your [...]
How to configure to use RPMforge ? Reference: http://dag.wieers.com/rpm/FAQ.php#B2 It’s very easy. Just install the latest rpmforge-release package for your distribution and architecture. This will automatically install the configuration and GPG keys that are for safely installing RPMforge packages. The configuration of Yum is inside the rpmforge-release package. You need to install it yourself. If [...]
How to change the time zone within a php script You can change the time zone within a php script. Here is a sample code: You can set the timezone in .htaccess as well. Add the line: SetEnv TZ America/Indianapolis List of timezones is here: http://us.php.net/manual/en/timezones.php
Rsync your old files to your new server. From your new server run the following commands: rsync -vrplogDtH –progress -e ssh root@192.168.0.1:/home/ss/public_html/ /home/ss/public_html/
Adding opera repository to Ubuntu Installing Opera. echo “deb http://archive.canonical.com/ jaunty partner” >> /etc/apt/sources.list wget -O – http://deb.opera.com/archive.key | sudo apt-key add – sudo apt-get install debian-archive-keyring sudo apt-get update sudo apt-get install opera
Ubuntu /etc/network/interfaces DHCP setup To setup eth0 to dhcp in /etc/network/interfaces auto eth0 iface eth0 inet dhcp
/etc/network/interfaces Ubuntu Static Network setup Following example setup eth0 with 192.168.1.1 IP address and gateway (router) to 192.168.1.2 iface eth0 inet static address 192.168.1.1 netmask 255.255.255.0 gateway 192.168.1.2 With IPtables auto eth0 iface eth0 inet dhcp pre-up iptables-restore < /etc/iptables.rules post-down iptables-restore < /etc/iptables.downrules Another Example – auto lo iface lo inet loopback auto eth1 [...]
alfresco-community open source enterprise content management solution $ sudo apt-cache search alfresco alfresco-pdf2swf – a PDF to SWF converter alfresco-community – open source enterprise content management solution How to install $ sudo apt-get install alfresco-community Reading package lists… Done Building dependency tree Reading state information… Done The following extra packages will be installed: alfresco-pdf2swf dbconfig-common [...]
To configure your Ethernet device with a static IP address and custom configuration, some more information will be required. Suppose you want to assign the IP address 192.168.0.2 to the device eth1, with the typical netmask of 255.255.255.0. Your default gateway’s IP address is 192.168.0.1. You would enter something like this into /etc/network/interfaces: iface eth1 [...]