By default, the database is in the %APPDATA% folder. To be precise, it is %APPDATA%\MonetDB5\dbfarm\demo

On 01/05/2019 22.14, Corbit, Dann wrote:

Mdblaunch.bat seems to work:

C:\Program Files\MonetDB\MonetDB5>mserver5 --dbpath=dbfarm\voc\ --set mapi_port=50000

# MonetDB 5 server v11.33.3 (Apr2019)

# Serving database 'voc', using 12 threads

# Compiled for x86_64-pc-winnt/64bit

# Found 31.927 GiB available main-memory.

# Copyright (c) 1993 - July 2008 CWI.

# Copyright (c) August 2008 - 2019 MonetDB B.V., all rights reserved

# Visit https://www.monetdb.org/ for further information

# Listening for connection requests on mapi:monetdb://127.0.0.1:50000/

# MonetDB/GIS module loaded

# MonetDB/SQL module loaded

...

But neither of these batch files work.

C:\Program Files\MonetDB\MonetDB5>*MSQLserver.bat*

MonetDB/Python Disabled: Python 3.7 installation not found.

*!FATAL: BBPinit: incompatible BBP version: expected 061041, got 061033.*

*This database was probably created by a too old version of MonetDB.*

Press any key to continue . . .

C:\Program Files\MonetDB\MonetDB5>*M5server.bat*

MonetDB/Python Disabled: Python 3.7 installation not found.

*!FATAL: BBPinit: incompatible BBP version: expected 061041, got 061033.*

*This database was probably created by a too old version of MonetDB.*

Press any key to continue . . .

They complain about the server version.

I tried deleting the database folder and restarting.

The database was rebuilt.  But I still get the errors.

How do I fix this error?

I do not have real database systems.  I only have the voc sample data.

---

users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

It should be possible to start mserver5 without having python installed. The msi installer checks if python2 and/or python3 are installed and if so enables the installation of the dlls needed to interface with python2 and/or python3. You can also manually configure this when you choose the custom install option when running the msi installer.

Based on your output log:

MonetDB/Python Disabled: Python 3.7 installation not found.

I looks as it cannot find the installed Python 3.7 Therefore it should start mserver5 without python3 interface enabled. To check this, turn on echo (edit M5server.bat on the top change echo=off into echo=on) Next rerun M5server.bat

Now you should see more information including environment settings and whether mserver5.exe is started with or without --set embedded_py=3 enabled.

Note: you only need to enable python if you intend to create and run User Defined Functions (or Aggrgates or Loader functions) written in python language. See documentation: https://www.monetdb.org/Documentation/Manuals/SQLreference/SQLSyntaxOverview...

On 02-05-19 02:14, Corbit, Dann wrote:

Fixed the BPP version problem (by removing the appdata folder so that it would rebuild), but got " ImportError: No module named site"

One example: C:\Program Files\MonetDB\MonetDB5>M5server.bat MonetDB/Python Disabled: Python 3.7 installation not found. # MonetDB 5 server v11.33.3 (Apr2019) # Serving database 'demo', using 12 threads # Compiled for x86_64-pc-winnt/64bit # Found 31.927 GiB available main-memory. # Copyright (c) 1993 - July 2008 CWI. # Copyright (c) August 2008 - 2019 MonetDB B.V., all rights reserved # Visit https://www.monetdb.org/ for further information # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ # MonetDB/GIS module loaded # MonetDB/SQL module loaded ImportError: No module named site Press any key to continue . . .

Turns out the current server will not run without Python37 installed (that's a python error message).

I installed Python37, but monetdb can't find the module site.py, even though it exists on my system.

Directory of f:\Python37\Lib 2019-03-25 09:21 PM 22,289 site.py

I have these settings for PYTHONHOME and PYTHONPATH PYTHONHOME=F:\Python37 PYTHONPATH=F:\Python37\lib I also have %PYTHONHOME% in the front of my path.

It seems odd to me that python is required. I don't understand why site.py is not being found

-----Original Message----- From: users-list [mailto:users-list-bounces+dann.corbit=softwareag.com@monetdb.org] On Behalf Of Sjoerd Mullender Sent: Wednesday, May 1, 2019 1:37 PM To: users-list@monetdb.org Subject: Re: BPP version problem

By default, the database is in the %APPDATA% folder. To be precise, it is %APPDATA%\MonetDB5\dbfarm\demo

---

users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list