[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.
Thanks. The "--set mapi_open=true" was what I was missing.
I can connect from any computer now.
--- Sjoerd Mullender sjoerd@acm.org wrote:
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