Drizzle as database server whith PHP under Debian 5.0
In this tutorial I will use libdrizzle-0.4 and drizzle-2009.10.1192.
You can download these packages in the right menu.
Start with a new fresh package update
apt-get update
Get some required packages
apt-get install libpcre3-dev libevent-dev autoconf automake bison libtool ncurses-dev libreadline-dev libz-dev g++ libssl-dev uuid-dev libpam0g libpam0g-dev gperf
apt-get install libdrizzle-dev libprotobuf-dev protobuf-compiler
apt-get install bzrtools meld uuid-devf
First you will need install libdrizzle
cd /usr/local/src
wget http://launchpad.net/libdrizzle/trunk/0.4/+download/libdrizzle-0.4.tar.gz
tar zxvf libdrizzle-0.4
cd libdrizzle-0.4
./configure
make
make install
Now install drizzle
cd /usr/local/src
wget http://launchpad.net/drizzle/trunk/bell/+download/drizzle-2009.11.1208.tar.gz
tar zxvf drizzle-2009.10.1192
cd drizzle-2009.10.1192
./configure --with-libprotobuf-prefix=/usr/local/drizzle
make
make install
Make some preparation
groupadd drizzle
useradd -g drizzle drizzle
mkdir /usr/local/drizzle
mkdir /usr/local/drizzle/data
cd /usr/local/drizzle
chown -R drizzle .
makechgrp -R drizzle .
Start your drizzle server
/usr/local/sbin/drizzled --user=drizzle --basedir=/usr/local/drizzle/ --datadir=/usr/local/drizzle/data/ &
Start the drizzle client
/usr/local/bin/drizzle
Test a simple SQL statement
drizzle> SELECT VERSION();
Install drizzle PHP support via PECL
pecl install drizzle-beta
Add "extension=drizzle.so" to your php.ini
nano /etc/php/php.ini
extension=drizzle.so
#Restart php, in my case
/etc/init.d/php-fpm restart