Hannes,

Thank you, I think the issue is resolved now, with reference to a these scripts on installation, database creation and accessing MonetDB via R:

https://github.com/ajdamico/usgsd/tree/master/MonetDB

On advice, the steps I took were to:

1. Uninstall all MonetDB components to return to original state

2. Install MonetDB SQL server 64-bit (not ODBC and Geom components unless required)

3. Install MonetDB.R, from R console or using Notepadd++ with NpptoR (not RStudio which may complicate matters)

4. Open MonetDB SQL Server, note 'database' and 'mapi' value, but leave it alone.

5. Check connection to the server in R, using the database and mapi values, e.g. in my case:

> require(MonetDB.R)

> db <- dbConnect( MonetDB.R() , "monetdb://127.0.0.1:50000/demo")

> str(db)

6. Run through the 2 remaining scripts to complete set-up and test access. (creating a batfile didn't seem to work 1st time, until I'd set-up an empty 'C:\My Directory\' first.)

In the remainder of those scripts, the connections, updating, and querying all work now, so I'll pause there. :)

Regards,

Mark

On Thu, Aug 22, 2013 at 1:51 PM, Hannes Mühleisen <Hannes.Muehleisen@cwi.nl> wrote:

Hello Mark,

On 08/21/2013 07:39 PM, m- dev wrote:

I'm not familiar with database administration, but I guess I'm
having similar problems to this Windows user:
http://mail.monetdb.org/pipermail/users-list/2013-June/006078.html

I installed DB5-SQL, Geom and ODBC 32 and 64bit, default options for
all. After that it's not clear to me which steps are for Linux or
Windows, or both. Or how to set up the configuration file.

The first one should be enough.

In Windows 8 I start 'MonetDB SQL Server'. I can also start 'MonetDB SQL
Client'.

i) I added PATH in Environment variable to the installation folder (that
defaults to 32-bit Program files):

;C:\Program Files\MonetDB\MonetDB5

But I couldn't set up a configuration file, either from within the Server:

cat ~/.monetdb

SyntaxException:parseError:cat ~/.monetdb
SyntaxException:parseError: ^,';' expected

Or the Client:

sql>cat ~/.monetdb
more>name=####
more>password=#########
more>language=SQL
more>
Creating that as a text file renamed config.monetdb in the installation
folder doesn't work either.

Using a text editor is a much better idea. On Windows, the .monetdb file needs to be placed in the "etc" folder in the MonetDB installation directory, or the path in the DOTMONETDBFILE environment variable.

ii) I've extracted the voc_dump.sql file, but the Guide doesn't specify
the location of mclient.exe and when I found it in C:\Program
Files\MonetDB\MonetDB5\bin but it won't open because:
"libmapi.dll is missing...Try reinstalling the program to fix this problem"

Use mclient.bat in the "MonetDB5" installation directory to start the client. It should correctly set the environment variables for mclient.exe.

If you problem persists, please let us know.

Best,

Hannes

_______________________________________________
users-list mailing list
users-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list