Installation and configuration on Windows 8
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. 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. 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" Clearly I haven't set it up MonetDB correctly, I can only guess, but what are the correct steps? Is there any other guide or tutorial on installation and configuration on Windows 8? Thanks, Mark
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
require(MonetDB.R) db <- dbConnect( MonetDB.R() , "monetdb://127.0.0.1:50000/demo") str(db)
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: 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<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
participants (2)
-
Hannes Mühleisen -
m- dev