monetdb安装

windows64

安装

MonetDB-ODBC-Installer-x86_64-20180327.msi

MonetDB5-SQL-Installer-x86_64-20180327.msi

MonetDB5-Geom-Installer-x86_64-20180327.msi

运行

M5server.bat MSQLserver.bat启动服务器

温馨提示一：启动时指定数据库名

Window环境下启动monetdb通过安装目录下的MSQLserver.bat脚本完成。启动时可以输入启动参数，比如

MSQLserver.bat --dbname=my-first-db

这样启动了my-first-db数据库

温馨提示二：开放远程访问

默认设置下monetdb只能本地访问，如果想通过jdbc方式访问monetdb数据库的话除了需要monetdb的jdbc驱动之外，还需要在数据库端设定mapi_open=true

MSQLserver.bat –set “mapi_open=true”

一般情况下为了避免每次启动时都输入这些参数，可以直接修改启动脚本MSQLserver.bat。

例如

"%MONETDB%\bin\mserver5.exe" --set "prefix=%MONETDB%" --set "exec_prefix=%MONETDB%" %MONETDBFARM% %* --dbname="my-first-db" --set "mapi_open=true"

On a different machine: the default security settings prohibit access to MonetDB/XQuery from another machine. You can lift that restriction by starting Mserver with the following command:

Mserver --dbinit="module(pathfinder);" --set mapi_open=yes

ubuntu安装

# 查ubuntu版本

lsb_release -cs

# 设置

vim /etc/apt/sources.list.d/monetdb.list

deb https://dev.monetdb.org/downloads/deb/ xenial monetdb

deb-src https://dev.monetdb.org/downloads/deb/ xenial monetdb

:wq

# 下载

wget --output-document=- https://www.monetdb.org/downloads/MonetDB-GPG-KEY | sudo apt-key add -

# 安装

sudo apt update

sudo apt install monetdb5-sql monetdb-client

# 服务

sudo systemctl enable monetdbd

sudo systemctl start monetdbd

#

run monetdbd or mserver5

centos7安装

--Install the MonetDB-release-epel package:

yum install https://dev.monetdb.org/downloads/epel/MonetDB-release-epel.noarch.rpm

--

yum install MonetDB-SQL-server5 MonetDB-client

-- 设置远程访问，以

mserver5 --dbpath="module(pathfinder);" --set mapi_open=yes

建库步骤：

https://www.monetdb.org/Documentation/monetdbd

#1

monetdbd create /mnt/monetdata

monetdbd start /mnt/monetdata

monetdb create xianfeng

monetdb -p50000 status

monetdb start xianfeng

monetdb release xianfeng

--开/停机

monetdbd start /home/monet/lzsj

monetdbd stop /home/monet/lzsj

#转发

从dw转到erp

ssh -CfNgL 1433:192.168.2.46:1433 root@10.10.255.30

将云IP的54320转到localhost的54321

ssh -CfNgL 54320:114.55.92.30:54321 root@114.55.92.30

修改sshd

vim /etc/ssh/sshd_config

修改GatewayPorts no为 GatewayPorts = yes来打开它。

service sshd restart

ssh -CfNgL 54321:127.0.0.1:54321 root@114.55.92.30

ssh -g -L 54321:114.55.92.30:54321 localhost

ssh -g -L 54321:114.55.92.30:54321 114.55.92.30

dbeaver连接

[图片上传失败...(image-8428de-1528186401715)]

nl.cwi.monetdb.jdbc.MonetDriver

jdbc:monetdb://{host}[:{port}]/[{database}]

[图片上传失败...(image-971e84-1528186401715)]