Install Drizzle On Debian Lenny

Drizzle is a Free Software/Open Source database management system (DBMS) that was forked from version 6.0 of the MySQL DBMS. Like MySQL, Drizzle has a client/server architecture and uses SQL as its primary command language. Drizzle is distributed under version 2 of the GNU General Public License.

Drizzle is written in the C++ programming language, and stores its string data in an UTF-8 format. It is being developed for modern Unix-like operating systems, including Linux, Mac OS X, and Solaris – in general, any OS that conforms to POSIX.

Well, i decided to try to get drizzle up on my Debian Lenny. So if you need to install Drizzle on a Debian, make sure that all build dependencies are met:

protobuf : Protocol Buffers - Google's data interchange format
Protocol Buffers are a way of encoding structured data in an efficient yet extensible format.
libdrizzle : is the client and protocol library that is required to build Drizzle.
libuuid : generates and parses 128-bit universally unique ids (UUIDs).
See RFC 4122 for more information.
libreadline5 : The GNU readline library aids in the consistency of user interface across discrete programs that need to provide a command line interface.
libpcre3 : This is a library of functions to support regular expressions whose syntax
and semantics are as close as possible to those of the Perl 5 language.

You can get them with aptitude like:

$ sudo aptitude install libprotobuf-dev protobuf-compiler uuid-dev libdrizzle0 libdrizzle-dev libreadline5-dev libpcre3-dev

Download the last source code archives for the Drizzle database server:

$ wget http://launchpad.net/drizzle/trunk/aloha/+download/drizzle-2009.07.1088.tar.gz
$ tar xzf drizzle-2009.07.1088.tar.gz
$ cd drizzle-2009.07.1088
$ ./configure --with-libprotobuf-prefix=/usr/local/drizzle
$ make
$ sudo make install

Create a non-privileged group and user for the database server, as below:

$ sudo groupadd drizzle
$ sudo useradd -g drizzle drizzle

Create data directory and set the right permission on it:

$ sudo mkdir /usr/local/drizzle/data
$ sudo chown -R drizzle:drizzle /usr/local/drizzle

Then, start up the Drizzle server by this command:

$ sudo ./usr/local/drizzle/sbin/drizzled --user=drizzle --datadir=/usr/local/drizzle/data/ &

Run the drizzle client, which is very similar to the MySQL client. Start it up and access the Drizzle server as below:

$ ./usr/local/drizzle/bin/drizzle

Welcome to the Drizzle client.. Commands end with ; or \g. 
Your Drizzle connection id is 2 
Server version: 2009.07.1088 Source distribution (trunk) 
Type 'help;' or '\h' for help. Type '\c' to clear the buffer. 
drizzle> select version(); 
+--------------+ 
| version() | 
+--------------+ 
| 2009.07.1088 | 
+--------------+ 
1 row in set (0 sec) 
drizzle> exit;