[MonetDB-users] latest build cannot connect from remote client
I installed MonetDB5 using monetdb-install.sh. I d/l'ed the script today.
The binaries compiled fine but I am unable to connect from a different computer besides the host.
i.e. mserver5 running on serverA, client running on desktopB.
desktopB> MapiClient -l sql -h serverA -umonetdb
MapiClient never returns. In another window I ran netstat and can see the connection from desktopB to serverA on the correct port (50000). Using 'telnet serverA 50000' I can see mserver5 responding with:
46:avuaOb0v:mserver:7:SHA1,MD5,crypt,plain:3412
Any ideas?
Colin,
for quite a while, the default for MonetDB (IMHO both 4 & 5) is to allow only local MAPI connections.
To allow remote clients to connect to the server, you explicitely need to open the mapi port for remote connections by starting the server with
mserver5 ... --set mapi_open=true
or by adding a line
mapi_open=true
to you monetdb5.conf file before (re)starting the server.
Stefan
On Wed, May 16, 2007 at 05:03:06PM -0700, Colin Foss wrote:
I installed MonetDB5 using monetdb-install.sh. I d/l'ed the script today.
The binaries compiled fine but I am unable to connect from a different computer besides the host.
i.e. mserver5 running on serverA, client running on desktopB.
desktopB> MapiClient -l sql -h serverA -umonetdb
MapiClient never returns. In another window I ran netstat and can see the connection from desktopB to serverA on the correct port (50000). Using 'telnet serverA 50000' I can see mserver5 responding with:
46:avuaOb0v:mserver:7:SHA1,MD5,crypt,plain:3412
Any ideas?
This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
Thanks
This should be clearly reflected in the general documentation. I don't see its description in the default monetdb?.conf file.
regards, Martin
Stefan Manegold wrote:
Colin,
for quite a while, the default for MonetDB (IMHO both 4 & 5) is to allow only local MAPI connections.
To allow remote clients to connect to the server, you explicitely need to open the mapi port for remote connections by starting the server with
mserver5 ... --set mapi_open=true
or by adding a line
mapi_open=true
to you monetdb5.conf file before (re)starting the server.
Stefan
On Wed, May 16, 2007 at 05:03:06PM -0700, Colin Foss wrote:
I installed MonetDB5 using monetdb-install.sh. I d/l'ed the script today.
The binaries compiled fine but I am unable to connect from a different computer besides the host.
i.e. mserver5 running on serverA, client running on desktopB.
desktopB> MapiClient -l sql -h serverA -umonetdb
MapiClient never returns. In another window I ran netstat and can see the connection from desktopB to serverA on the correct port (50000). Using 'telnet serverA 50000' I can see mserver5 responding with:
46:avuaOb0v:mserver:7:SHA1,MD5,crypt,plain:3412
Any ideas?
This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
On Thu, May 17, 2007 at 11:22:38AM +0200, Martin Kersten wrote:
Thanks
This should be clearly reflected in the general documentation. I don't see its description in the default monetdb?.conf file.
it is in MonetDB4/conf/MonetDB.conf.in, but not in MonetDB5/conf/monetdb5.conf.in
it had been added to the former on Nov 8 2006 (i.e., before the repository split, when it was still in MonetDB/conf/MonetDB.conf.in, cf. http://monetdb.cvs.sourceforge.net/monetdb/MonetDB/conf/MonetDB.conf.in?hide... http://monetdb.cvs.sourceforge.net/monetdb/MonetDB/conf/MonetDB.conf.in?hide... ), but has apparently never been propagated to the latter.
I have no idea, to which extend MonetDB4/conf/MonetDB.conf.in and MonetDB5/conf/monetdb5.conf.in are in sync.
Stefan
regards, Martin
Stefan Manegold wrote:
Colin,
for quite a while, the default for MonetDB (IMHO both 4 & 5) is to allow only local MAPI connections.
To allow remote clients to connect to the server, you explicitely need to open the mapi port for remote connections by starting the server with
mserver5 ... --set mapi_open=true
or by adding a line
mapi_open=true
to you monetdb5.conf file before (re)starting the server.
Stefan
On Wed, May 16, 2007 at 05:03:06PM -0700, Colin Foss wrote:
I installed MonetDB5 using monetdb-install.sh. I d/l'ed the script today.
The binaries compiled fine but I am unable to connect from a different computer besides the host.
i.e. mserver5 running on serverA, client running on desktopB.
desktopB> MapiClient -l sql -h serverA -umonetdb
MapiClient never returns. In another window I ran netstat and can see the connection from desktopB to serverA on the correct port (50000). Using 'telnet serverA 50000' I can see mserver5 responding with:
46:avuaOb0v:mserver:7:SHA1,MD5,crypt,plain:3412
Any ideas?
This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
I do have mapi_open=true in my monetdb.conf file and I pass --set mapi_open=true also.
Here is the exact command I run to start the server:
/var/lib/MonetDB/bin/mserver5 --dbfarm=/db/monetdb5/dbfarm --set daemon=yes --set monet_welcome=no --dbname=history --config=/db/monetdb5/dbfarm/history/.monetdb.conf --set mapi_open=true /db/monetdb5/dbfarm/history/.mserver5.dbinit
I thought it was interesting that 'ps -fp' revealed this as the CMD though: /var/lib/MonetDB/bin/mserver5 --dbfarm=/db/monetdb5/dbfarm --set daemon yes --set monet_welcome no --dbname=history --config=/db/monetdb5/dbfarm/history/.monetdb.conf --set mapi_open true /db/monetdb5/dbfarm/history/.mserver5.dbinit
I have attached my .monetdb.conf file.
My .mserver5.dbinit contains "include sql;sql.start();"
I'm running on CentOS 64bit. uname -a : 2.6.9-22.ELsmp #1 SMP Sat Oct 8 21:32:36 BST 2005 x86_64 x86_64 x86_64 GNU/Linux
--- Stefan Manegold Stefan.Manegold@cwi.nl wrote:
Colin,
for quite a while, the default for MonetDB (IMHO both 4 & 5) is to allow only local MAPI connections.
To allow remote clients to connect to the server, you explicitely need to open the mapi port for remote connections by starting the server with
mserver5 ... --set mapi_open=true
or by adding a line
mapi_open=true
to you monetdb5.conf file before (re)starting the server.
Stefan
On Wed, May 16, 2007 at 05:03:06PM -0700, Colin Foss wrote:
I installed MonetDB5 using monetdb-install.sh. I d/l'ed the script today.
The binaries compiled fine but I am unable to
connect
from a different computer besides the host.
i.e. mserver5 running on serverA, client running
on
desktopB.
desktopB> MapiClient -l sql -h serverA -umonetdb
MapiClient never returns. In another window I ran netstat and can see the connection from desktopB
to
serverA on the correct port (50000). Using 'telnet serverA 50000' I can see mserver5 responding with:
46:avuaOb0v:mserver:7:SHA1,MD5,crypt,plain:3412
Any ideas?
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2
express and take
control of your XML. No limits. Just data. Click
to get it now.
http://sourceforge.net/powerbar/db2/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |
participants (3)
-
Colin Foss -
Martin Kersten -
Stefan Manegold