RE: Passing mapi_open Param to mserver5 via monetdbd (Syed M Raza)
Hi Everyone
Any help or pointer on starting monetdb server to accept remote connections? Original message attached below.
Regards
Raza
-----Original Message-----
Message: 1
Date: Wed, 11 May 2016 13:28:51 +0000
From: Syed M Raza
Hi Syed,
When i look at my normally configured running mserver5's i can see them
listening on all interfaces.
netstat -anpp | grep 50000
tcp 0 0 0.0.0.0:50000 0.0.0.0:* LISTEN
31/monetdbd
udp 768 0 0.0.0.0:50000 0.0.0.0:*
31/monetdbd
Can't find anything regarding the binding of interface or listening in the
mserver5 page either anyone ?
Regards,
Brian Hood
On Mon, May 16, 2016 at 6:54 PM, Syed M Raza
Hi Everyone Any help or pointer on starting monetdb server to accept remote connections? Original message attached below.
Regards Raza
-----Original Message-----
Message: 1 Date: Wed, 11 May 2016 13:28:51 +0000 From: Syed M Raza
To: "users-list@monetdb.org" Subject: Passing mapi_open Param to mserver5 via monetdbd Message-ID: < BY1PR0401MB1429201171375B1BD9BB46258E720@BY1PR0401MB1429.namprd04.prod.outlook.com Content-Type: text/plain; charset="us-ascii"
Hi All
Is there a way to pass config params to mserver5 via monetdbd daemon? I am trying to open database for remote connections. After started the dbfarm using monetdbd I see entries in log file that calls mserver5 are made with mapi_open=false. I couldn't figure out how to pass mapi_open=open instead, or for that matter, other params to mserver5.
What I understand from documentation that mserver5 should be managed via monetdbd daemon. Or should I try to start mserver5 separately, for each database in the dbfarm? How would those instances then attach to the monetdbd daemon?
For what it worth, I did try
- creating a monetdb.conf file in /path/to/dbfarm directory
- setting map_open using monetdbd set name=value
MonetDB v11.21.19 ( Jul2015-SP4) OS - Ubuntu 14.04 LTS
Thanks for your help in advance.
Regards Raza
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
There was a posting a while ago where someone renamed mserver5 to mserver5.bin and then created a shell script named mserver5 to add the missing parameters to the server startup command.
-----Original Message-----
From: Brian Hood [brianh6854@googlemail.commailto:brianh6854@googlemail.com]
Sent: Monday, May 16, 2016 04:08 PM Eastern Standard Time
To: Communication channel for MonetDB users
Subject: Re: Passing mapi_open Param to mserver5 via monetdbd (Syed M Raza)
Hi Syed,
When i look at my normally configured running mserver5's i can see them listening on all interfaces.
netstat -anpp | grep 50000
tcp 0 0 0.0.0.0:50000https://urldefense.proofpoint.com/v2/url?u=http-3A__0.0.0.0-3A50000&d=CwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=8_GYjk1edsyLJlNaxMxYxBJsviF3JXYvwDK42uy5KWU&m=KFOWWtJxlnR5rQeyyk8rrbMdU3kTydJvmF9INWyxfi0&s=LAb5-gwqDZ5r_tZ4F0jwXW83IQjF1ciM6E1iXnw8rwE&e= 0.0.0.0:* LISTEN 31/monetdbd
udp 768 0 0.0.0.0:50000https://urldefense.proofpoint.com/v2/url?u=http-3A__0.0.0.0-3A50000&d=CwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=8_GYjk1edsyLJlNaxMxYxBJsviF3JXYvwDK42uy5KWU&m=KFOWWtJxlnR5rQeyyk8rrbMdU3kTydJvmF9INWyxfi0&s=LAb5-gwqDZ5r_tZ4F0jwXW83IQjF1ciM6E1iXnw8rwE&e= 0.0.0.0:* 31/monetdbd
Can't find anything regarding the binding of interface or listening in the mserver5 page either anyone ?
Regards,
Brian Hood
On Mon, May 16, 2016 at 6:54 PM, Syed M Raza
Hello all, There was a recent change in the connection parameters, that changes what interfaces are bound by default when monetdbd starts. This change affects the *default* and the *Jun2016* branches, and as such will be part of the *next* release. With this change by default monetdbd binds the interface 127.0.0.1. In order to be able to connect to it remotely you will need to set the property listenaddr to 0.0.0.0 with the set subcommand of monetdbd: $ monetdbd set listenaddr=0.0.0.0 <dbfarm> I would like to repeat that this change affects the default and the Jun2016 branches. It will be part of the next official release, so if you are using the current release this should not affect you. Best regards, Panos. Brian Hood @ 2016-05-16 22:07 CEST:
Hi Syed,
When i look at my normally configured running mserver5's i can see them listening on all interfaces.
netstat -anpp | grep 50000 tcp 0 0 0.0.0.0:50000 0.0.0.0:* LISTEN 31/monetdbd udp 768 0 0.0.0.0:50000 0.0.0.0:* 31/monetdbd
Can't find anything regarding the binding of interface or listening in the mserver5 page either anyone ?
Regards,
Brian Hood
On Mon, May 16, 2016 at 6:54 PM, Syed M Raza
wrote: Hi Everyone Any help or pointer on starting monetdb server to accept remote connections? Original message attached below.
Regards Raza
-----Original Message-----
Message: 1 Date: Wed, 11 May 2016 13:28:51 +0000 From: Syed M Raza
To: "users-list@monetdb.org" Subject: Passing mapi_open Param to mserver5 via monetdbd Message-ID: < BY1PR0401MB1429201171375B1BD9BB46258E720@BY1PR0401MB1429.namprd04.prod.outlook.com Content-Type: text/plain; charset="us-ascii"
Hi All
Is there a way to pass config params to mserver5 via monetdbd daemon? I am trying to open database for remote connections. After started the dbfarm using monetdbd I see entries in log file that calls mserver5 are made with mapi_open=false. I couldn't figure out how to pass mapi_open=open instead, or for that matter, other params to mserver5.
What I understand from documentation that mserver5 should be managed via monetdbd daemon. Or should I try to start mserver5 separately, for each database in the dbfarm? How would those instances then attach to the monetdbd daemon?
For what it worth, I did try
- creating a monetdb.conf file in /path/to/dbfarm directory
- setting map_open using monetdbd set name=value
MonetDB v11.21.19 ( Jul2015-SP4) OS - Ubuntu 14.04 LTS
Thanks for your help in advance.
Regards Raza
_______________________________________________ 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 (4)
-
Anderson, David B
-
Brian Hood
-
Panagiotis Koutsourakis
-
Syed M Raza