monetdb to remote monetdbd makes fun of me
I'm running a dbfarm on a remote server serverX The dbfarm has been created this way (passphrase changed): monetdbd create /var/lib/monetdb/dbfarm monetdbd set control=yes /var/lib/monetdb/dbfarm monetdbd set port=50000 /var/lib/monetdb/dbfarm monetdbd set listenaddr=0.0.0.0 /var/lib/monetdb/dbfarm monetdbd set passphrase=roberto /var/lib/monetdb/dbfarm Port 50000 is open.
From another machine on the same subnet, I request a status:
$ monetdb -hserverX -p50000 -Proberto status status: =OK It does connect (using a different port gives a connection refused). However, it just acknowledges the command, without performing it. Whatever command I try, it behaves the same: $ monetdb -hserverX -p50000 -Proberto create x create: =OK $ monetdb -hserverX -p50000 -Proberto create x create: =OK Notice that the second one should have failed. This confirms that the commands are not executed at all. I have had this issue for a long time, it's nothing new. I just never asked before, because I normally solve it with ssh tunneling a port and using it locally. In this case, I cannot use this. Am I missing something, or is it a bug? Roberto
It's a bug and has been for quite a while now. See https://www.monetdb.org/bugzilla/show_bug.cgi?id=3545 Best regards, Dennis On Wed, Mar 8, 2017 at 4:50 PM, Roberto Cornacchia < roberto.cornacchia@gmail.com> wrote:
I'm running a dbfarm on a remote server serverX
The dbfarm has been created this way (passphrase changed):
monetdbd create /var/lib/monetdb/dbfarm monetdbd set control=yes /var/lib/monetdb/dbfarm monetdbd set port=50000 /var/lib/monetdb/dbfarm monetdbd set listenaddr=0.0.0.0 /var/lib/monetdb/dbfarm monetdbd set passphrase=roberto /var/lib/monetdb/dbfarm
Port 50000 is open.
From another machine on the same subnet, I request a status:
$ monetdb -hserverX -p50000 -Proberto status status: =OK
It does connect (using a different port gives a connection refused). However, it just acknowledges the command, without performing it.
Whatever command I try, it behaves the same:
$ monetdb -hserverX -p50000 -Proberto create x create: =OK
$ monetdb -hserverX -p50000 -Proberto create x create: =OK
Notice that the second one should have failed. This confirms that the commands are not executed at all.
I have had this issue for a long time, it's nothing new. I just never asked before, because I normally solve it with ssh tunneling a port and using it locally. In this case, I cannot use this.
Am I missing something, or is it a bug?
Roberto
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Ah, thanks. I couldn't find it.
On 9 March 2017 at 10:42, Dennis Pallett
It's a bug and has been for quite a while now. See https://www.monetdb.org/bugzilla/show_bug.cgi?id=3545
Best regards, Dennis
On Wed, Mar 8, 2017 at 4:50 PM, Roberto Cornacchia < roberto.cornacchia@gmail.com> wrote:
I'm running a dbfarm on a remote server serverX
The dbfarm has been created this way (passphrase changed):
monetdbd create /var/lib/monetdb/dbfarm monetdbd set control=yes /var/lib/monetdb/dbfarm monetdbd set port=50000 /var/lib/monetdb/dbfarm monetdbd set listenaddr=0.0.0.0 /var/lib/monetdb/dbfarm monetdbd set passphrase=roberto /var/lib/monetdb/dbfarm
Port 50000 is open.
From another machine on the same subnet, I request a status:
$ monetdb -hserverX -p50000 -Proberto status status: =OK
It does connect (using a different port gives a connection refused). However, it just acknowledges the command, without performing it.
Whatever command I try, it behaves the same:
$ monetdb -hserverX -p50000 -Proberto create x create: =OK
$ monetdb -hserverX -p50000 -Proberto create x create: =OK
Notice that the second one should have failed. This confirms that the commands are not executed at all.
I have had this issue for a long time, it's nothing new. I just never asked before, because I normally solve it with ssh tunneling a port and using it locally. In this case, I cannot use this.
Am I missing something, or is it a bug?
Roberto
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Dennis Pallett -
Roberto Cornacchia