[MonetDB-users] external SQL clients
How do you configure MonetDB to allow SQL connections from clients on computers separate from the server? On linux I used to do something like this: --dbinit="module(sql_server); sql_server_start(TRUE);" but that throws an error on Windows. i.e. I get this: C:\> netstat -na | grep 50000 TCP 127.0.0.1:50000 0.0.0.0:0 LISTENING but I want: TCP 0.0.0.0:50000 0.0.0.0:0 LISTENING
Hi Colin, On 13-03-2007 22:53:28 -0700, Colin Foss wrote:
How do you configure MonetDB to allow SQL connections from clients on computers separate from the server?
On linux I used to do something like this: --dbinit="module(sql_server); sql_server_start(TRUE);"
but that throws an error on Windows.
What is the error message that is thrown?
i.e. I get this: C:\> netstat -na | grep 50000 TCP 127.0.0.1:50000 0.0.0.0:0 LISTENING
but I want: TCP 0.0.0.0:50000 0.0.0.0:0 LISTENING
On 2007-03-14 06:53, Colin Foss wrote:
How do you configure MonetDB to allow SQL connections from clients on computers separate from the server?
On linux I used to do something like this: --dbinit="module(sql_server); sql_server_start(TRUE);"
but that throws an error on Windows.
i.e. I get this: C:\> netstat -na | grep 50000 TCP 127.0.0.1:50000 0.0.0.0:0 LISTENING
but I want: TCP 0.0.0.0:50000 0.0.0.0:0 LISTENING
Mserver --set mapi_open=true --dbinit='module(sql_server);' The service gets started automatically when you load module sql_server (or mapi, for that matter), so we needed a different way to start the server in open mode. Hence the option that you need to set. -- Sjoerd Mullender
Thanks. The "--set mapi_open=true" was what I was
missing.
I can connect from any computer now.
--- Sjoerd Mullender
On 2007-03-14 06:53, Colin Foss wrote:
How do you configure MonetDB to allow SQL connections from clients on computers separate from the server?
On linux I used to do something like this: --dbinit="module(sql_server); sql_server_start(TRUE);"
but that throws an error on Windows.
i.e. I get this: C:\> netstat -na | grep 50000 TCP 127.0.0.1:50000 0.0.0.0:0 LISTENING
but I want: TCP 0.0.0.0:50000 0.0.0.0:0 LISTENING
Mserver --set mapi_open=true --dbinit='module(sql_server);'
The service gets started automatically when you load module sql_server (or mapi, for that matter), so we needed a different way to start the server in open mode. Hence the option that you need to set.
-- Sjoerd Mullender
participants (3)
-
Colin Foss -
Fabian Groffen -
Sjoerd Mullender