Starting drizzled

In the meantime, to start drizzle, you should do the following:

cd to drizzle base directory
run ./sbin/drizzled. A safe way of starting it is the following:

 ./sbin/drizzled --no-defaults  --datadir=$PWD/var >> $PWD/var/drizzle.err 2>&1 &

This will start drizzled with two protocol modules. The MySQL protocol module is the default and listens on port 3306 (the MySQL protocol port). If you want to change the mysql procotol port, you would specify --mysql-protocol.port N. The Drizzle protocol listens on port 4427 by default, but this is considered experimental and should not be relied upon yet. This protocol may change between releases. If you would like to change the port the Drizzle protocol uses, you would specify --drizzle-protocol.port N.

By default, drizzle looks for a configuration file in the following order:

/etc/drizzled.cnf 
/etc/drizzle/drizzled.cnf 
/usr/local/etc/drizzled.cnf 
~/.drizzled.cnf

You can also define configuration in

./etc/drizzled.cnf

You can specify this with --defaults-file option on the command line.

To connect to drizzled, use the 'drizzle' client:

 ./bin/drizzle

If drizzle was compiled without a $PREFIX directory, the binaries are in:

./drizzled/drizzled ./client/drizzle

in the installation directory.

Starting drizzle with server/debug console

Drizzle can be started with debug console by specifying '–console-enable' like:

 $ drizzled --datadir=/Users/eday/drizzle.data --console-enable

it starts up drizzle and give a command prompt like:

 drizzled>

where you can enter sql commands like

 drizzled>show tables in information_schema;

type 'quit', 'exit' or ctrl+D (EOF) on the prompt to stop the drizzle and come out.

Shutting down drizzle

   ./bin/drizzle --shutdown

Shutting down drizzle on certain port

   ./bin/drizzle --shutdown --port=<PORT_NUMBER>

Connecting with drizzle

Just like drizzled, the drizzle command line interface looks for /etc/drizzle.cnf, etc. for global defaults. Note that this configuration file is different from the one drizzled uses (drizzled.cnf). This is different from MySQL.

Troubleshooting

Default location for Drizzle binaries

Drizzle binaries such as drizzled and drizzle are installed by default in /usr/local/bin/. The default can be changed by using the --prefix=/some/other/path configure option, e.g. ./configure --prefix=/opt/drizzle to put the binaries into /opt/drizzle/bin.

libdrizzle.so.16 not found

If you get an error similar to /usr/local/bin/drizzle: if there is some error while loading shared libraries: libdrizzle.so.16: cannot open shared object file: No such file or directory

By default, Drizzle library files are written to /usr/local/lib. You may need to change a path or link to the libdrizzle.so.16 file. Specifying the installation directory at compile time seems to set the paths properly.

ERROR: Non-integer value supplied for port. If you are trying to enter a password please use --password instead.

The -p parameter now means port not password. For password use -P or --password.

Retrieved from "http://drizzle.org/wiki/Starting_drizzled"

Contents