MonetDBInstallationUbuntu

Not much to say here just some cautionary notes.

Installed Libraries

The package configure scripts fails to inform the developer if the following packages are not installed:

• libreadline5-dev
• libxml2-dev
• libgeos-dev

You should be sure they are installed before attempting to build the package from source.

There may be other packages that should be installed that I may have had installed, so didn't notice them missing, or may be required for certain features to be enabled. With what I added above everything compiled and installed properly.

Compilation

If you prefer a checkout from the CVS Trunk you will need to have a lot more packages installed. See Expert Documentation. The one thing they don't mention is that the autogen Python path needs to be added to your PYTHONPATH environment. It is located here: path/to/buildtools/autogen/build/lib.

Press Enter when prompted for a password to create an anonymous login.

$ cvs -d:pserver:anonymous@monetdb.cvs.sourceforge.net:/cvsroot/monetdb login
$ cvs -z3 -d:pserver:anonymous@monetdb.cvs.sourceforge.net:/cvsroot/monetdb co -P packagename

To find the packages go to the MonetDB ViewVC link: CVS Trunk

To determine which packages from CVS you will need use this link: Package Dependencies

I prefer to cd to each directory and run the configure command then do a make then make install, in this way you can easily check if you have all the packages installed then try again. The MonetDB build instructions recommends you run the monetdb-install.sh script, however this script will fail at the first sign of trouble then you need to do the entire build again since it does it's build from /var/tmp using a uniquely generated path for each build attempt. Also this script needs to be run as root if you are doing the install globally to your system, whereas you can just do only the install as root if built from the individual directories.

The following options are recommended in the MonetDB build instructions, but you have to search for them.

$ ./configure --prefix='/usr/local/MonetDB/' --enable-debug=no --enable-assert=no --enable-optimize=yes
$ make
$ sudo make install

When running configure in the MonetDB5 directory you may need to add the argument --disable-strict to get it to compile.

Account Setup

Be sure you create user and group accounts for monet and assign them to the /usr/local/MonetDB or whatever the path you have chosen.

Run pwgen which will dump to the screen a bunch of arbitrary strings, grab a few of them removing any spaces and put them in a new file named /usr/local/MonetDB/etc/monetdb.secret.

Starting MonetDB

I have created a startup script. If run without arguments you will get a list of all possible arguments.

monetdb.sh

$ ./monetdb
Usage: ./monetdb {start|stop|restart|status|create "database"|import "database user file"}

• start -- Starts the merovingian daemon. This controls the starting and stopping of the actual database servers.

• stop -- Stops the merovingian daemon.

• restart -- Restarts the merovingian daemon.

• status -- Prints to the screen the PID of the merovingian daemon.

• create "database" -- Creates the database passed as the second argument.
• import "database user file" -- Imports the SQL file with specified database, database user and the SQL file.

Normally you will need to run this script as the root user as in the example below:

$ sudo ./monetdb start