LAMP How To - Open Source At Work

Basic GIT tutorial: centralised and decentralised model

bpeh — Wed, 01 Sep 2010 01:49:34 +0000

Git is fast becoming the most popular versioning control system in the market today. It is open sourced and offers a number of significant advantages over svn. SVN will probably still be around for a while because a lot of people and software are still dependent on it or don’t see a need for change. [...]

sending data via url securely

bpeh — Sat, 31 Jul 2010 04:08:58 +0000

Depending on your situation, sometimes it is quicker to append form data to urls. To do this securely, we need to encrypt it and decrypt it later. One good solution is to use mcrypt. We can create a class like so: class Encryption { var $skey = "your own key"; public function safe_b64encode($string) { $data = base64_encode($string); $data = [...]

php curl proxy settings

bpeh — Thu, 29 Jul 2010 01:40:58 +0000

It can be daunting to get proxy to work in curl. If it is not working for you, try changing the auth to ntlm. $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, ‘http://yoururl.com’); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch,CURLOPT_PROXY , “your_proxy_ip:proxy_port”); curl_setopt($ch, CURLOPT_PROXYAUTH, CURLAUTH_NTLM); curl_setopt($ch, CURLOPT_PROXYTYPE, CURLPROXY_HTTP); curl_setopt($ch,CURLOPT_PROXYUSERPWD,”user:pass”); curl_exec ($ch); if(curl_errno($ch)) { echo ‘Curl error: ‘ . curl_error($ch); exit; } curl_close ($ch);

Preserving HTML in XML

bpeh — Thu, 06 May 2010 22:41:49 +0000

Characters like “<” and “&” are illegal in XML elements. “<” will generate an error because the parser interprets it as the start of a new element. “&” will generate an error because the parser interprets it as the start of an character entity. Some text, like JavaScript code, contains a lot of “<” or [...]

Eclipse Proxy Fix

bpeh — Thu, 06 May 2010 03:14:24 +0000

If you are behind a proxy server, you may get annoying proxy popups after installing eclipse. The trick is to manually setup the proxies in windows->preferences->general->networking This works for galileo, the version that I am using.

Advance SVN post-commit hook script for System Administrators

bpeh — Fri, 16 Apr 2010 02:11:39 +0000

Everyone knows how cool svn post-commit feature is. Instead of using the basic post-commit script provided by svn, we can do alot more with a bit of server side scripting. Here, I like to share a simple script that I wrote to automate the process of updating different server system files using svn post-commit. It [...]

SVN over HTTP

bpeh — Mon, 29 Mar 2010 05:46:31 +0000

Objective I want to be able to browse the svn dir from a website like http://zeus.dev/svn.php and at the same time, be able to checkout from the repository via http://zeus.dev/svn/projectname How First of all, install mod_dav_svn Then in the apache config, I am using vhost for example <VirtualHost *:80> DocumentRoot /home/data/zeus.dev/apps/ ServerName zeus.dev # this is for [...]

Quick tips for setting up Eclipse and Monkey

bpeh — Mon, 29 Mar 2010 02:50:23 +0000

eclipse-pdtis a php integrated eclipse IDE – good for rapid web development. download eclipse-pdt from above. setup subclipse (for svn) if you intend to use svn within eclipse. In eclipse->help->software updates->available software->add site, enter URL: http://subclipse.tigris.org/update_1.6.x Another good software to install is beyond cvs. In eclipse->help->software updates->available software->add site, enter URL: http://beyondcvs.sourceforge.net/update/0.8.x/ install subeclipse and javaHL adapter. setup eclipse monkey [...]

Quick SVN Tutorial

bpeh — Mon, 29 Mar 2010 02:43:13 +0000

Create New Repo svnadmin create /home/data/svn/[dir-name] chown apache:developer -R /home/data/svn/[dir-name] chown 2770 /home/data/svn/[dir-name] Import New Site ssh into server to import new site to the trunk, svn import [your-site] file:///home/data/svn/[your-site-name] -m "[import comments]" View Available Sites In Trunk svn ls file:///home/svn/trunk/ Checking Out a Site Create a directory to checkout and use ’svn co’ cd ~ mkdir [my-site] svn co file:///home/svn/trunk/[site-name] [my-site] Updating a [...]

Implementing SSL Certificates in Apache

bpeh — Mon, 29 Mar 2010 02:36:22 +0000

Creating a Private Key To create a private key without triple des encryption, use the following command: openssl genrsa -out ssl.key 1024 Creating a Certificate Signing Request To obtain a certificate signed by a certificate authority, you will need to create a Certificate Signing Request (CSR). The purpose is to send the certificate authority enough information to create the [...]

Quick Mysql Tips

bpeh — Mon, 29 Mar 2010 02:25:33 +0000

Logging slow queries To enable the slow query log, start mysqld with the –log-slow-queries[=file_name] option. Use the mysqldumpslow command to summarize the queries that appear in the log. For example: mysqldumpslow /path/to/your/mysql-slow-queries.log -t 10 shows you top 10 performance killers. Lost Password shutdown mysql, then mysqld –skip-grant-tables –u root mysql -u root mysql> use mysql; mysql> UPDATE [...]

synchronising system clock manually

bpeh — Thu, 25 Mar 2010 04:38:28 +0000

if there is a need to synchronise the system clock manually, it can be a straight forward thing service ntpd stop ntpdate 0.rhel.pool.ntp.org service ntpd start some of the files of interest: /etc/sysconfig/clock /usr/share/zoneinfo

init: Id “co” respawning too fast: disabled for 5 minutes

bpeh — Thu, 25 Mar 2010 02:57:25 +0000

If you are getting this message, it means that you are in run level 3 and most likely you dont have the GUI installed. inittab is trying to create too many terminals at a go. Have a look at the /etc/inittab file, and commented off the extra gettys lines. # Run gettys in standard runlevels co:2345:respawn:/sbin/agetty xvc0 [...]

system-config-securitylevel – Love or hatred?

bpeh — Mon, 22 Mar 2010 03:59:30 +0000

system-config-securitylevel provides the user an easy interface to edit firewall rules. If you only need to open up certain tcp and udp ports, this tool may prove handy. For more complex routing rules, you are tempted to edit /etc/sysconfig/iptables directly. If you have used system-config-securitylevel before, check out the iptables file and you will see this [...]

Getting or reverting back to an old version in svn

bpeh — Thu, 18 Mar 2010 01:07:36 +0000

people might think svn revert is the answer but it is actually not. To check out an old version of svn, svn co -r xxx url where -r is whatever version to checkout. To update the existing version to an old version svn update -r xxx url

Installing phpunit

bpeh — Sat, 27 Feb 2010 06:57:41 +0000

this is very simple, firstly install pear http://www.azhowto.com/2009/08/14/php-manual-install-of-pear/ then from the pear manual, ie http://www.phpunit.de/manual/3.4/en/installation.html pear channel-discover pear.phpunit.de pear channel-discover pear.symfony-project.com pear install --alldeps phpunit/PHPUnit getting the latest phpunit will need php 5.2 and above. To get php 5.2, see http://www.azhowto.com/2009/08/07/getting-new-packages-from-centos-dev-repo/

Highly available load Balancer + web server in centos

bpeh — Wed, 10 Feb 2010 10:38:57 +0000

This tutorial is about creating a highly available HTTP load balancer using HAProxy. The setup can be slightly complicated but you will appreciate the result – you will get a load-balanced + highly available web service in your network. Basic linux skill is assumed. Scenario: Imagine we have 2 physical machines. In each machine, I have 2 [...]

submitting a form using hyperlinks

bpeh — Wed, 10 Feb 2010 03:08:36 +0000

If using hyperlink to submit form, remember to return false in “onclick” so that it is backward compatible with IE6, ie <a class=”button_next” href=”javascript:;” onclick=”$(‘#form_wizard’).submit();return false;”> <span>Update</span> </a>

resolving jquery conflict with other javascript libraries

bpeh — Thu, 04 Feb 2010 00:23:31 +0000

It is good to know that jquery can work with other js libraries… Just need to know how to resolve the conflict http://api.jquery.com/jQuery.noConflict

syncing date and time in command line

bpeh — Fri, 22 Jan 2010 23:25:23 +0000

having the wrong date and time in the system can be disastrous as many applications will be using the system date and time. It is therefore very important to have the right date and time. In linux, yum install ntp chkconfig ntp on ntpdate pool.ntp.org service ntpd start You can add the ntpdate command to cron to automate the syncing process. [...]