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