[Monetdb-developers] Error with MonetDB 4.12.0 for Windows
I downloaded and installed the MonetDB 4.12.0 with SQL 2.12.0 from SourceForge using the link on the MonetDB website.
http://prdownloads.sourceforge.net/monetdb/MonetDB-Installer-4.12.0.msi? download
I installed it without error but when I try to start the database with sql_server I get the following error:
C:\MonetDB>msqlserver.bat # Monet Database Server V4.12.0 # Copyright (c) 1993-2006, CWI. All rights reserved. # Compiled for i686-pc-win32/32bit with 32bit OIDs; dynamically linked. # Visit http://monetdb.cwi.nl/ for further information. !ERROR: Incompatible database version 020000, this server supports version 030001 !mvc_init: unable to create system tables !ERROR: interpret: no matching MIL operator to 'mapi_register(void)'. !MAYBE YOU MEAN: ! mapi_register(ptr) : void MonetDB>
Laptop is a Dell C800 with 512M memory and Windows 2000 Professional, version 5.0.2195 Service Pack 4 Build 2195.
I know this isn't the best platform to run MonetDB on but it will be a couple of weeks before I can free up a linux server so any help would be appreciated.
Thanks.
Jim Foley
Jim,
did you have an older version of MonetDB installed on your system prior to installing MonetDB 4.12.0 with SQL 2.12.0? If so, which version?
It looks to me, as if there is still/already an old database on your system in the default location (sorry, I'm everything but a Windows expert, hence, I don't know where that is...).
You could check this by either using an other than the default "demo" database name, e.g., msqlserver.bat --dbname=MyDB or by reqesting to place your database in an other than the default location, e.g., msqlserver.bat --dbfarm=<absolute_path_to_some_directory> ... hoping that these switches do works as expected/assumed also on Windows ...
Please let us know, whether or not this works/helps.
Stefan
On Thu, Sep 07, 2006 at 07:50:07PM -0400, Jim Foley wrote:
I downloaded and installed the MonetDB 4.12.0 with SQL 2.12.0 from SourceForge using the link on the MonetDB website.
http://prdownloads.sourceforge.net/monetdb/MonetDB-Installer-4.12.0.msi? download
I installed it without error but when I try to start the database with sql_server I get the following error:
C:\MonetDB>msqlserver.bat # Monet Database Server V4.12.0 # Copyright (c) 1993-2006, CWI. All rights reserved. # Compiled for i686-pc-win32/32bit with 32bit OIDs; dynamically linked. # Visit http://monetdb.cwi.nl/ for further information. !ERROR: Incompatible database version 020000, this server supports version 030001 !mvc_init: unable to create system tables !ERROR: interpret: no matching MIL operator to 'mapi_register(void)'. !MAYBE YOU MEAN: ! mapi_register(ptr) : void MonetDB>
Laptop is a Dell C800 with 512M memory and Windows 2000 Professional, version 5.0.2195 Service Pack 4 Build 2195.
I know this isn't the best platform to run MonetDB on but it will be a couple of weeks before I can free up a linux server so any help would be appreciated.
;-))
Thanks.
Jim Foley
Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&da... _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
The default location of MonetDB databases is something like:
C:\Documents and Settings<username>\Application Data\MonetDB\dbfarm
Make this folder empty (at least, if you accept to lose any information stored in the MonetDB databases you have created earlier).
And now I come to think of it; is actually quite confusing if you have a look at the MonetDB.conf file (in C:\Program Files\CWI\MonetDB\etc), which states:
---snap--- # Where MonetDB is installed prefix=C:\Program Files\CWI\MonetDB exec_prefix=C:\Program Files\CWI\MonetDB
# GDK Section #============
# All databases are stored as a directory under the directory # given below. Use this value to change the overall location # of your data. gdk_dbfarm=${prefix}\var\MonetDB\dbfarm ---end-snap---
you'd expect something different. Only when looking at Mserver.bat:
---snap--- set MONETDBDIR=%APPDATA%\MonetDB set MONETDBFARM="--dbfarm=%MONETDBDIR%\dbfarm" ---end-snap---
you finally understand where the dbfarm is located.
Grtz, Wouter
Jim,
did you have an older version of MonetDB installed on your system prior to installing MonetDB 4.12.0 with SQL 2.12.0? If so, which version?
It looks to me, as if there is still/already an old database on your system in the default location (sorry, I'm everything but a Windows expert, hence, I don't know where that is...).
You could check this by either using an other than the default "demo" database name, e.g., msqlserver.bat --dbname=MyDB or by reqesting to place your database in an other than the default location, e.g., msqlserver.bat --dbfarm=<absolute_path_to_some_directory> ... hoping that these switches do works as expected/assumed also on Windows ...
Please let us know, whether or not this works/helps.
Stefan
On Thu, Sep 07, 2006 at 07:50:07PM -0400, Jim Foley wrote:
I downloaded and installed the MonetDB 4.12.0 with SQL 2.12.0 from SourceForge using the link on the MonetDB website.
http://prdownloads.sourceforge.net/monetdb/MonetDB-Installer-4.12.0.msi? download
I installed it without error but when I try to start the database with sql_server I get the following error:
C:\MonetDB>msqlserver.bat # Monet Database Server V4.12.0 # Copyright (c) 1993-2006, CWI. All rights reserved. # Compiled for i686-pc-win32/32bit with 32bit OIDs; dynamically linked. # Visit http://monetdb.cwi.nl/ for further information. !ERROR: Incompatible database version 020000, this server supports version 030001 !mvc_init: unable to create system tables !ERROR: interpret: no matching MIL operator to 'mapi_register(void)'. !MAYBE YOU MEAN: ! mapi_register(ptr) : void MonetDB>
Laptop is a Dell C800 with 512M memory and Windows 2000 Professional, version 5.0.2195 Service Pack 4 Build 2195.
I know this isn't the best platform to run MonetDB on but it will be a couple of weeks before I can free up a linux server so any help would be appreciated.
;-))
Thanks.
Jim Foley
Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&da... _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |
Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&da... _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
That fixed the problem. I modified the config file so that I would have a new sandbox but didn't modify the .bat files. Cleaned out the directory and all is well. Thanks for the quick replies.
Jim Foley
-----Original Message----- From: W.Alink@cwi.nl [mailto:W.Alink@cwi.nl] Sent: 09/08/2006 1:48 PM To: Jim Foley Cc: monetdb-developers@lists.sourceforge.net Subject: Re: [Monetdb-developers] Error with MonetDB 4.12.0 for Windows
The default location of MonetDB databases is something like:
C:\Documents and Settings<username>\Application Data\MonetDB\dbfarm
Make this folder empty (at least, if you accept to lose any information stored in the MonetDB databases you have created earlier).
And now I come to think of it; is actually quite confusing if you have a look at the MonetDB.conf file (in C:\Program Files\CWI\MonetDB\etc), which states:
---snap--- # Where MonetDB is installed prefix=C:\Program Files\CWI\MonetDB exec_prefix=C:\Program Files\CWI\MonetDB
# GDK Section #============
# All databases are stored as a directory under the directory # given below. Use this value to change the overall location # of your data. gdk_dbfarm=${prefix}\var\MonetDB\dbfarm ---end-snap---
you'd expect something different. Only when looking at Mserver.bat:
---snap--- set MONETDBDIR=%APPDATA%\MonetDB set MONETDBFARM="--dbfarm=%MONETDBDIR%\dbfarm" ---end-snap---
you finally understand where the dbfarm is located.
Grtz, Wouter
Jim,
did you have an older version of MonetDB installed on your system prior to installing MonetDB 4.12.0 with SQL 2.12.0? If so, which version?
It looks to me, as if there is still/already an old database on your system in the default location (sorry, I'm everything but a Windows expert, hence, I don't know where that is...).
You could check this by either using an other than the default "demo" database name, e.g., msqlserver.bat --dbname=MyDB or by reqesting to place your database in an other than the default location, e.g., msqlserver.bat --dbfarm=<absolute_path_to_some_directory> ... hoping that these switches do works as expected/assumed also on Windows ...
Please let us know, whether or not this works/helps.
Stefan
On Thu, Sep 07, 2006 at 07:50:07PM -0400, Jim Foley wrote:
I downloaded and installed the MonetDB 4.12.0 with SQL 2.12.0 from SourceForge using the link on the MonetDB website.
http://prdownloads.sourceforge.net/monetdb/MonetDB-Installer-4.12.0.m si? download
I installed it without error but when I try to start the database with sql_server I get the following error:
C:\MonetDB>msqlserver.bat # Monet Database Server V4.12.0 # Copyright (c) 1993-2006, CWI. All rights reserved. # Compiled for i686-pc-win32/32bit with 32bit OIDs; dynamically linked. # Visit http://monetdb.cwi.nl/ for further information. !ERROR: Incompatible database version 020000, this server supports version 030001 !mvc_init: unable to create system tables !ERROR: interpret: no matching MIL operator to 'mapi_register(void)'.
!MAYBE YOU MEAN: ! mapi_register(ptr) : void MonetDB>
Laptop is a Dell C800 with 512M memory and Windows 2000 Professional,
version 5.0.2195 Service Pack 4 Build 2195.
I know this isn't the best platform to run MonetDB on but it will be a couple of weeks before I can free up a linux server so any help would be appreciated.
;-))
Thanks.
Jim Foley
Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your
job
easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&da...
Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |
Using Tomcat but need to do more? Need to support web services,
security?
Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache
Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&da...
Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
participants (3)
-
Jim Foley -
Stefan Manegold -
W.Alink＠cwi.nl