Install Drizzle On Debian Lenny

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Submitted by mezgani (Contact Author) (Forums) on Fri, 2009-07-31 19:30. :: Debian

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;


Please do not use the comment function to ask for help! If you need help, please use our forum.
Comments will be published after administrator approval.
Sponsored Links: Turn your desk phone and mobile phone into one with Sprint Mobile Integration.
www.seamlessenterprise.com

One number. One voicemail. Seize the lead. Sprint Mobile Integration.
www.seamlessenterprise.com

One Number. One Voicemail.
Make it easier for clients to reach you. Turn your desk phone and mobile phone into one with Sprint Mobile Integration.
www.seamlessenterprise.com

One number. One voicemail. Sprint Mobile Integration.
www.seamlessenterprise.com

AT&T Synaptic Compute as a Service. Boost your power on demand.

Trial: IBM Cognos Express Reporting, Analysis & Planning