As said earlier, if that other ("old"?) database was created with a MonetDB build without GIS/GEOM support than simply accessing that database with a new MonetDB build with GIS/GEOM support does (and can) not add GIS/GEOM functionality to that database. You need to - dump your data from the old database - create a new database with the new MonetDB build with GIS/GEOM support, - loaad your dump into that new database. Best, Stefan ----- On Dec 1, 2016, at 1:14 PM, Joweria Nakibuuka joweria.nakibuuka@unitn.it wrote:

But when i try to reach another database as shown below, the module is not loaded joweria@ubuntu:~$ mserver5 --dbpath=/home/joweria/Spartial/mydbfarm/Gisbase !FATAL: GDKlockHome: Database lock '.gdk_lock' denied

joweria@ubuntu:~$ sudo su [sudo] password for joweria: root@ubuntu:/home/joweria# mserver5 --dbpath=/home/joweria/Spartial/mydbfarm/Gisbase # MonetDB 5 server v11.24.0 # This is an unreleased version # Serving database 'Gisbase', using 2 threads # Compiled for x86_64-unknown-linux-gnu/64bit with 128bit integers # Found 1.470 GiB available main-memory. # Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008-2016 MonetDB B.V., all rights reserved # Visit http://www.monetdb.org/ for further information # Listening for connection requests on mapi:monetdb:// 127.0.0.1:50000/ # MonetDB/SQL module loaded

...

2016-12-01 14:09 GMT+02:00 Joweria Nakibuuka < joweria.nakibuuka@unitn.it > :

joweria@ubuntu:~$ mserver5 --dbpath=/tmp/MyDBfarm/MyDB

# MonetDB 5 server v11.24.0

# This is an unreleased version

# Serving database 'MyDB', using 2 threads

# Compiled for x86_64-unknown-linux-gnu/64bit with 128bit integers

# Found 1.470 GiB available main-memory.

# Copyright (c) 1993-July 2008 CWI.

# Copyright (c) August 2008-2016 MonetDB B.V., all rights reserved

# Visit http://www.monetdb.org/ for further information

# Listening for connection requests on mapi:monetdb:// 127.0.0.1:50000/

# MonetDB/GIS module loaded

# MonetDB/SQL module loaded

2016-12-01 13:00 GMT+02:00 < developers-list-request@monetdb.org > :

Send developers-list mailing list submissions to developers-list@monetdb.org

To subscribe or unsubscribe via the World Wide Web, visit https://www.monetdb.org/mailman/listinfo/developers-list or, via email, send a message with subject or body 'help' to developers-list-request@monetdb.org

You can reach the person managing the list at developers-list-owner@monetdb.org

When replying, please edit your Subject line so it is more specific than "Re: Contents of developers-list digest..."

Today's Topics:

1. RE: Need Help on enabling GIS (MonetDB/GIS) module in MonetDB (Joweria Nakibuuka) 2. Re: Need Help on enabling GIS (MonetDB/GIS) module in MonetDB (Stefan Manegold)

----------------------------------------------------------------------

Message: 1 Date: Thu, 1 Dec 2016 12:11:49 +0200 From: Joweria Nakibuuka < joweria.nakibuuka@unitn.it > To: developers-list@monetdb.org Subject: RE: Need Help on enabling GIS (MonetDB/GIS) module in MonetDB Message-ID: <CANbNUqbw+N3= tb929XArQ8q+AiCG-o5DYNR9Ndk2POChHpdi1g@mail.gmail.com > Content-Type: text/plain; charset="utf-8"

Dear Admin, I am running Ubuntu linux 14.04 LTS, x86_64-Ubuntu-linux-gnu/64bit with 128bit integers. i recently installed MonetDB5 default branch from the mercurial repository.

I tried to rebuild and enable geom module but to no avail, it shows no error, after compilation it shows that the module is enabled,However when i run the mserver the monetDB/GIS module is not loaded as expected. I am stuck and i don't seem to know how to proceed forward in order to run my spatial queries

Are there any setting i need to do explicitly to load this module?

the command i used: ./configure --prefix=/home/joweria/MonetDB-Nov2016-SP4 --enable-geom=yes --enable-pyintegration=yes --with-geos=yes

and then after compilation under the LDFLAGS-enabled componets geom is one of the enabled componet but when i run the mserver5 the module is not loaded as expected.

I rebuild monetDB again and for first time i run the mserver5 commans and the GIS module was successfully loaded ie (MonetDB/SQL/GIS module is loaded) but when i closed the session (\q) and ran the same command again the module was not loaded. i tried exporting paths to no avail. what could be the problem? please i need your kind help.

Thank you

Regards, Joweria nakibuuka