Tuesday, March 27, 2012

Sudo xxx complaining command not found

Just installed doctrine. I found if I use command "doctrine" straight away it works but not working with sudo. When I typed in
sudo doctrine
it complains
sudo: doctrine: Command not found
Then I tried to use full path of doctrine with sudo which worked. So I think this should be caused by that sudo command does not use the personal path environment.

Using full qualified path every time is annoying.

Create a file at
with content
alias sudo='sudo env PATH=$PATH $@'
Logout and login again.

Sunday, March 25, 2012

phpunit with Netbeans on Ubuntu

As a newbie to PHP I got lots of headache on setting up phpunit. It is a little tricky to setup phpunit on Ubuntu since the documentation about this is not accurate. Make some notes here for the future references.

To install phpunit, the only way is to use PEAR. However I got annoying errors during the process.

1. apt-get does not install latest Pear, it only install the PEAR up to verision 1.9.2 which will be complained then when you are installing phpunit. Use this,
$ wget http://pear.php.net/go-pear.phar
$ php go-pear.phar
2. Then install phpunit
pear channel-discover pear.phpunit.de
pear install phpunit/PHPUnit
3. Setup netbeans for phpunit
The right path of phpunit is /home/xxx/pear/bin/phpunit not /usr/lib/php/PHPUnit as documented on neatbeans official website.

Thursday, March 8, 2012

Remote access MySQL

Recently I come cross MySQL which I have not used much before. To connect it on localhost is without any issue till I want to move the MySQL to my EC2 instance.

To make the magic happen, 2 things need to check.

1. mysql only allows localhost to access by default.
If this step is missing the error below will happen.
ERROR 2003 (HY000): Can't connect to MySQL server on 'xxx.xxx.xxx.xxx'

open mysql config file by    sudo nano /etc/mysql/my.cnf comment out the line    bind-address= and
skip-networking if existing
Or we can specify a ip say for bind-address as a result only this ip can access mysql. And only one ip can be bound!

2. Root user can not be used to log in remotely by default.
If this step is missing the error below will happen.
ERROR 1130 (HY000): Host 'xxx.xxx.xxx.xxx' is not allowed to connect to this MySQL server

Make sure to modify root user's privileges to allow remote user login mysql as root user. Don't recommend this way for security reasons. A better is to create another user and enable it to access mysql remotely.

Monday, March 5, 2012

Apache Virtual Hosts - permissions

See this article

HOWTO: Install xdebug for PHP5

Here is a mini-howto in how to install the xdebug extension with PHP5 in Ubuntu 7.04

This will install xdebug 2.0 (or whatever is latest version in PEAR repository when you try this).

It is assumed you have Apache2 + PHP5 working already.

sudo apt-get install php5-dev php-pear

Now install xdebug thru PECL.

sudo pecl install xdebug

Now we need to find where xdebug.so went (the compiled module)

martin@martin-dev:/$ find / -name 'xdebug.so' /dev/null /usr/lib/php5/20060613/xdebug.so

Then edit php.ini:

sudo gedit /etc/php/apache2/php.ini

Add the following line:


Then restart apache for changes to take effect

sudo /etc/init.d/apache2 restart

Check phpinfo() to make sure the extension is loaded correctly. The following line should have been appended to the copyright lines:

with Xdebug v2.0.0, Copyright (c) 2002, 2003, 2004, 2005, 2006, 2007, by Derick Rethans

For more information about xdebug configuration and usage, please read the official documentation, found here: http://xdebug.org/docs/

check http://ubuntuforums.org/showthread.php?t=525257