さくらVPSでMDB2を入れる

*phpのバージョン
$ php -v
PHP 5.3.3 (cli) (built: Jul  3 2012 16:53:21)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies


*PEAR全アップデート
$ sudo pear upgrade-all
$ sudo pear channel-update pear.php.net


*PEARのmdb2をインストール
$ sudo pear install mdb2 MDB2_Driver_mysql

*PEARのディレクトリを調べる
$ pear config-show | grep "PEAR directory"
PEAR directory                 php_dir          /usr/share/pear


*php.iniでinclude_pathを追加する

$ sudo mkdir /var/www/carcatalog /var/www/carcatalog/php && sudo chown -R sakuragaoka /var/www/carcatalog
$ sudo cp /etc/php.ini /etc/php.ini.org && sudo vi /etc/php.ini
$ diff /etc/php.ini /etc/php.ini.org
785c785
< include_path = ".:/usr/share/pear:/usr/share/php:/php/includes:/var/www/carcatalog/php"
---
> ;include_path = ".:/php/includes"
$ sudo service httpd restart
Stopping httpd:                                            [  OK  ]
Starting httpd:                                            [  OK  ]

* MySQL接続テスト
$ php
<?php require_once("MDB2.php");
$dsn = "mysql://root@localhost/test";
$mdb2 =& MDB2::singleton($dsn);
if( MDB2::isError( $mdb2 ) ) {
    exit($mdb2->getMessage());
}else{
    print "OK";
}?>
^D
OK

つながった