Hi Vishal,

Please try the following: separate the sources, build and installation directories, to avoid any overwriting files.

Delete the old sources, build and installation directories and unpack the sources again. Once the sources and unpacked, make a directory called 'BUILD' in the sources dir. Go in the BUILD directory and run the configure script from there, also setting an installation location using the '--prefix' option, e.g.: ../configure --prefix=$HOME/monetdb-install --enable-optimize --enable-rintegratioin=yes

Then go to '$HOME/monetdb-install' and run monetdbd from there: bin/monetdbd create dbfarm bin/monetdbd start dbfarm ...

Do the same for the rest of the monetdb setup.

I am asking you to do this, since I just tired the exact same setup on a clean Ubuntu Server 14.04.2 on VBox without any issues.

Best regards, Dimitar

On 2015-May-15, at 12:00 , Vishal Virmani virmani.vishal@gmail.com wrote:

Hi Dimitar

I enabled R integration explicitly using monetdb set embed_r=true testdb1.

Please find attached merovingian.log file generated for your reference, Dimitar i ran the following commands to check if monetdbd, monetdb and mclient are installed properly.

The console output is generated are mentioned for your reference

sudo monetdbd –version

      MonetDB Database Server v1.7 (Oct2014-SP3)

sudo monetdb –version

      MonetDB Database Server Toolkit v1.1 (Oct2014-SP3)

sudo mclient –version

mclient, the MonetDB interactive terminal (Oct2014-SP3) support for command-line editing compiled-in character encoding UTF-8

I think these are properly installed as can be seen from console outputs i mentioned for each of them.

Kindly guide me to do the needful

Regards Vishal Virmani +91 99108 47231 @poisoncreed

On Fri, May 15, 2015 at 5:07 AM, Vishal Virmani virmani.vishal@gmail.com wrote: Hi Dimitar

I enabled R integration explicitly using monetdb set embed_r=true testdb1.

I have attached the log file for your reference, Dimitar i ran the following commands to check if monetdbd, monetdb and mclient are installed properly.

The console output is generated are mentioned for your reference

sudo monetdbd –version

      MonetDB Database Server v1.7 (Oct2014-SP3)

sudo monetdb –version

      MonetDB Database Server Toolkit v1.1 (Oct2014-SP3)

sudo mclient –version

mclient, the MonetDB interactive terminal (Oct2014-SP3) support for command-line editing compiled-in character encoding UTF-8

I think these are properly installed as can be seen from console outputs i mentioned for each of them.

Kindly guide me to do the needful

Regards Vishal Virmani +91 99108 47231 @poisoncreed

On Thu, May 14, 2015 at 12:23 PM, Dimitar Nedev dimitar.nedev@monetdbsolutions.com wrote: Hi Vishal,

Can you please attach the 'merovingian.log' file from the dbfarm directory?

After step 11, you must enable the R integration for the newly created database, before starting it: monetdb set embedr=true testdb1 This in unlikely to be the cause of the "failed to open up a communication channel" error, but is needed to actually enable the R integration.

Also, it is not necessary to configure, make, install, create dbfarms and start databases with sudo. A regular user should also be able to do that, as long as he has sufficient write access permissions for the target directories. Please try that as well.

A side note: If you want to get better performance from your database (and not planning to attach a debugger to your it), it's recommended to set the '--enable-optimize' option when configuring the build at step 6.

Best regards, Dimitar

...

On 2015-May-14, at 01:49 , Vishal Virmani virmani.vishal@gmail.com wrote:

Hi Hannes

As you suggested i checked, i am not having any multiple installation of MonetDB.

Further i have done a fresh installation. I am including the messages in the merovingian file as well for your reference.

Steps followed were

Step 1 : I created a clean VM with Ubuntu 14.04 server.

Step 2: Installed R-3.2.0 from source files. I checked the R environment it is working fine.

Step 3: Downloaded MonetDB source files from http://dev.monetdb.org/downloads/sources/Oct2014-SP3/MonetDB-11.19.11.tar.xz http://dev.monetdb.org/downloads/sources/Oct2014-SP3/MonetDB-11.19.11.tar.xz

Step 4: Created an empty directory sourcefiles in which i downloaded MonetDB-11.19.11-tar.xz

Step 5: Unpacked the source files

Step 6: Executed the command sudo ./configure --enable-rintegratioin=yes

       The result of executing the above command generated the following output:

        Output of running configure command

             Enabled/disabled build options:

                   strict                                         is disabled (by default)
                   assert                                       is disabled (by default)
                   debug                                       is disabled (by default)
                   optimize                                    is disabled (by default)
                   developer                                  is disabled (by default)
                   instrument                                is disabled (by default)
                   profile                                       is disabled (by default)


            Enabled/disabled components:

                   gdk                                           is enabled
                   monetdb5                                  is enabled
                   sql                                            is enabled
                   geom                                        is disabled (geos library required for geom library)
                   gsim                                         is disabled (gsl library not found)
                   fits                                           is disabled (cfitsio library not found)
                   jsonstore                                  is disabled (by default)
                   microhttpd                                is disabled (by default)
                   rdf                                            is disabled (by default)
                   rintegration                                is enabled
                   datacell                                     is disabled (by default)
                   odbc                                         is disbaled (unixODBC library required for ODBC driver)
                   jdbc                                          is disabled (ant is required to build MonetDB JDBC)
                   control                                      is disabled (ant is required to build merovingian control library)
                   testing                                      is enabled

Step 7 : Executed sudo make and make install respectively. They are working fine.

Step 8 : Checked sudo mserver5 --version , it gave the the desired output

Step 9: Created a dbfarm using the command sudo monetdbd create /mydbfarm

Step 10 Started the dbfarm by running sudo monetdbd start /mydbfarm, this also get executed successfully

Step 11. Created a sample database testdb1 using command : sudo monetdb create testdb1. This also gets executed fine.

Step 12 Upon execution of command sudo monetdb start testdb1, it fails showing me an error in merovingian file and on console i am generating following output

              starting database 'testdb1'...FAILED
              start: starting 'testdb1' failed: datbase 'testdb1' started up, but failed to open up a communication channel.

Looking forward to your suggestion

Regards Vishal Virmani +91 99108 47231

Regards Vishal Virmani +91 99108 47231 @poisoncreed

On Tue, May 12, 2015 at 3:30 PM, <users-list-request@monetdb.org mailto:users-list-request@monetdb.org> wrote: Send users-list mailing list submissions to users-list@monetdb.org mailto:users-list@monetdb.org

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

You can reach the person managing the list at users-list-owner@monetdb.org mailto:users-list-owner@monetdb.org

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

Today's Topics:

1. Facing issues in implementing Embedded R in MonetDB-11.19.11 (Vishal Virmani)
2. Re: Facing issues in implementing Embedded R in MonetDB-11.19.11 (Hannes M?hleisen)

---

Message: 1 Date: Tue, 12 May 2015 05:29:13 +0530 From: Vishal Virmani <virmani.vishal@gmail.com mailto:virmani.vishal@gmail.com> To: users-list@monetdb.org mailto:users-list@monetdb.org Subject: Facing issues in implementing Embedded R in MonetDB-11.19.11 Message-ID: <CA+dsbSFzWfqd=GEuAP17rqVPCfVWySShJa+rnyUPHkNbvrjbLw@mail.gmail.com mailto:GEuAP17rqVPCfVWySShJa%2BrnyUPHkNbvrjbLw@mail.gmail.com> Content-Type: text/plain; charset="utf-8"

Hi

I am implementing Embedded R in MonetDB version 11.19.11. My environment is VM with Ubuntu 14.04 Server. I have build MonetDB from source and R as well as from source. Running the command sudo mserver5 --version shows me the desired output.

When i try to invoke a database using sudo monetdb start testdb1 command, where testdb1 is a database i successfully created, it repeatedly throws up an error...database 'testdb1' started up, but failed to open up a communication channel.

Upon checking the associated merovingian log file i see further messages saying the object code to rapi.prelude missing.

Any way to resolve this...?

Regards Vishal Virmani @poisoncreed