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