Re: Passing mapi_open Param to mserver5 via monetdbd (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