Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

monetdb commands don't work with -h -P -p options (locally and remotely) #3545

Closed
monetdb-team opened this issue Nov 30, 2020 · 0 comments
Closed
Labels
bug Something isn't working normal Server Tools

Comments

@monetdb-team
Copy link

Date: 2014-08-18 16:03:32 +0200
From: @bartscheers
To: Merovingian devs <>
Version: 11.21.19 (Jul2015-SP4)
CC: anand.chirag, dennis, @kutsurak, @swingbit

Last updated: 2017-07-17 16:07:36 +0200

Comment 20051

Date: 2014-08-18 16:03:32 +0200
From: @bartscheers

User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:30.0) Gecko/20100101 Firefox/30.0
Build Identifier:

The monetdb status/create/start etc commands do not work when the -h -p -P options are provided. This is the case either locally and remotely; and for SP2 and SP3.

Reproducible: Always

Steps to Reproduce:

  1. Run db on server
  2. "monetdb status" issued from server works, "monetdb -hlocalhost -Pmypassphrase -p50000 status" does not work
  3. "monetdb -hmydbserver.com -Pmypassphrase -p50000 status" issued from client does not work.

Actual Results:

status: =OK

Expected Results:

In the case of status option the list of available dbs.

Comment 20052

Date: 2014-08-18 16:06:31 +0200
From: @bartscheers

Correction:
This works for SP2 and client, but not for SP2 server and SP3 client and not for SP3 server and client.

Comment 20053

Date: 2014-08-18 16:12:59 +0200
From: @bartscheers

This was introduced in the latest version

Comment 20880

Date: 2015-05-21 15:13:25 +0200
From: Dennis Pallett <>

I can confirm this bug. I get the exact same results with the Oct2014-SP3 version.

For example:

monetdb@test:/$ monetdb status
name state health remarks
onderwijs_dwh R 5m 100% 11m mapi:monetdb://test:50000/onderwijs_dwh
fred R 5m 100% 13m mapi:monetdb://test:50000/fred
finance_poc R 5m 100% 13m mapi:monetdb://test:50000/finance_poc

monetdb@test:/$ monetdb -h localhost -P test status
status: =OK

At present this makes remote management of MonetDB impossible.

Comment 22158

Date: 2016-05-23 10:29:42 +0200
From: @bartscheers

It does not work for all Jul2015 releases. It used to work in the past.
Really annoying no remote management can be done.

Comment 22206

Date: 2016-06-14 07:00:03 +0200
From: Chirag Anand <<anand.chirag>>

I am also facing this issue. On the same machine, it works using sudo but not when hostname and passphrase are provided.

$ sudo monetdb status
demodb R 17h 100% 8m mapi:monetdb://xxxx:50000/demodb

$ monetdb -h localhost -P monetdb status
status: =OK

I have compiled the latest branch: MonetDB-6c4407fe078d.

Comment 25141

Date: 2017-03-09 10:56:48 +0100
From: @swingbit

+1

The issue is still there on Dec2016.

Comment 25359

Date: 2017-05-31 13:55:12 +0200
From: MonetDB Mercurial Repository <>

Changeset e00fb765660d made by Panagiotis Koutsourakis kutsurak@monetdbsolutions.com in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=e00fb765660d

Changeset description:

Daemon was sending wrong answer for authorization request

When the password was correct, the server would send one extra new line that
confused the client. This commit fixes bug #3545

Comment 25368

Date: 2017-06-01 10:46:56 +0200
From: MonetDB Mercurial Repository <>

Changeset b6c67fa1be4d made by Panagiotis Koutsourakis kutsurak@monetdbsolutions.com in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=b6c67fa1be4d

Changeset description:

A better fix for bug #3545

Instead of changing the response of the server, change what the client accepts.
This way new clients can talk to old servers.
@monetdb-team monetdb-team added bug Something isn't working normal Server Tools labels Nov 30, 2020
@sjoerdmullender sjoerdmullender added this to the Ancient Release milestone Feb 7, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working normal Server Tools
Projects
None yet
Development

No branches or pull requests

2 participants