Provide --password option for msqldump tool
Hello Team,
We were trying to dump multiple tables through 'msqldump' tool, and restoring it in different monetdb instance in a programatic way. But the difficulty here is, I do not see an option to pass the --password to 'msqldump' tool, where as it prompts for the password and accepts input from STDIN. Due to this, we are not able achieve our requirement programatically.
And it would be good if -t(--table) option accepts multiple table names, through which we can dump the selected tables in a single shot.
Regards, Aravind.S
Hi Aravind,
providing a (plain-text) password on the command line is dangerous, and other users might then see your password in the process table. Hence, MonetDB tool do not offer that option.
Instead, you can provide the password in the .monetdb file (keeping it readble only for yourself!) as described for mclient; cf., https://www.monetdb.org/Documentation/mclient-man-page
Though admittedly not documented properly, Msqldump should use the .monetdb files just as mclient does.
Best, Stefan
----- On Jul 14, 2015, at 4:01 PM, Aravind S Reddy aravind.reddy@altair.com wrote:
Hello Team,
We were trying to dump multiple tables through 'msqldump' tool, and restoring it in different monetdb instance in a programatic way.
But the difficulty here is, I do not see an option to pass the --password to 'msqldump' tool, where as it prompts for the password and accepts input from STDIN. Due to this, we are not able achieve our requirement programatically.
And it would be good if -t(--table) option accepts multiple table names, through which we can dump the selected tables in a single shot.
Regards,
Aravind.S
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Stefan,
Thank you for the quick reply. I have set the ENVIRONMENT variable as follows in my WINDOWS7 system and trying to run the mclient
> set DOTMONETDBFILE="c:\Program Files\MonetDB\MonetDB5\etc.monetdb"
where ".monetdb" have the following entries user=<username> password=<pwd>
After this, while launching mclient i'm seeing error as below
>mclient failed to open file '(null)': Invalid argument user(win32):
Any idea, whats going wrong here?
Regards, Aravind.S
-----Original Message----- From: users-list [mailto:users-list-bounces+aravind.reddy=altair.com@monetdb.org] On Behalf Of Stefan Manegold Sent: 14 July 2015 19:37 To: Communication channel for MonetDB users Subject: Re: Provide --password option for msqldump tool
Hi Aravind,
providing a (plain-text) password on the command line is dangerous, and other users might then see your password in the process table. Hence, MonetDB tool do not offer that option.
Instead, you can provide the password in the .monetdb file (keeping it readble only for yourself!) as described for mclient; cf., https://www.monetdb.org/Documentation/mclient-man-page
Though admittedly not documented properly, Msqldump should use the .monetdb files just as mclient does.
Best, Stefan
----- On Jul 14, 2015, at 4:01 PM, Aravind S Reddy aravind.reddy@altair.com wrote:
Hello Team,
We were trying to dump multiple tables through 'msqldump' tool, and restoring it in different monetdb instance in a programatic way.
But the difficulty here is, I do not see an option to pass the --password to 'msqldump' tool, where as it prompts for the password and accepts input from STDIN. Due to this, we are not able achieve our requirement programatically.
And it would be good if -t(--table) option accepts multiple table names, through which we can dump the selected tables in a single shot.
Regards,
Aravind.S
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Looks there is problem with the file, i'm pointing to. When i created a new .monetdb file and setting it to the path, fixed the issue.
Thank you.
Regards, Aravind.S
-----Original Message----- From: users-list [mailto:users-list-bounces+aravind.reddy=altair.com@monetdb.org] On Behalf Of Aravind S Reddy Sent: 14 July 2015 20:03 To: Communication channel for MonetDB users Subject: RE: Provide --password option for msqldump tool
Stefan,
Thank you for the quick reply. I have set the ENVIRONMENT variable as follows in my WINDOWS7 system and trying to run the mclient
> set DOTMONETDBFILE="c:\Program Files\MonetDB\MonetDB5\etc.monetdb"
where ".monetdb" have the following entries user=<username> password=<pwd>
After this, while launching mclient i'm seeing error as below
>mclient failed to open file '(null)': Invalid argument user(win32):
Any idea, whats going wrong here?
Regards, Aravind.S
-----Original Message----- From: users-list [mailto:users-list-bounces+aravind.reddy=altair.com@monetdb.org] On Behalf Of Stefan Manegold Sent: 14 July 2015 19:37 To: Communication channel for MonetDB users Subject: Re: Provide --password option for msqldump tool
Hi Aravind,
providing a (plain-text) password on the command line is dangerous, and other users might then see your password in the process table. Hence, MonetDB tool do not offer that option.
Instead, you can provide the password in the .monetdb file (keeping it readble only for yourself!) as described for mclient; cf., https://www.monetdb.org/Documentation/mclient-man-page
Though admittedly not documented properly, Msqldump should use the .monetdb files just as mclient does.
Best, Stefan
----- On Jul 14, 2015, at 4:01 PM, Aravind S Reddy aravind.reddy@altair.com wrote:
Hello Team,
We were trying to dump multiple tables through 'msqldump' tool, and restoring it in different monetdb instance in a programatic way.
But the difficulty here is, I do not see an option to pass the --password to 'msqldump' tool, where as it prompts for the password and accepts input from STDIN. Due to this, we are not able achieve our requirement programatically.
And it would be good if -t(--table) option accepts multiple table names, through which we can dump the selected tables in a single shot.
Regards,
Aravind.S
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
https://www.monetdb.org/Documentation/mclient-man-page
I wonder, haven't tried it with the dump utility, could you get away with creating a textfile called .monetdb within the directory that you are using the utility to restore the dumps. Perhaps it, like mclient, would just read credentials and move along.
Please let me know if this works with the dumps. We use the file all the time with mclient.
On Tue, Jul 14, 2015 at 9:01 AM, Aravind S Reddy aravind.reddy@altair.com wrote:
Hello Team,
We were trying to dump multiple tables through 'msqldump' tool, and restoring it in different monetdb instance in a programatic way.
But the difficulty here is, I do not see an option to pass the --password to 'msqldump' tool, where as it prompts for the password and accepts input from STDIN. Due to this, we are not able achieve our requirement programatically.
And it would be good if -t(--table) option accepts multiple table names, through which we can dump the selected tables in a single shot.
Regards,
Aravind.S
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256
msqldump's usage of .monetdb is the same as mclient's. There are just fewer parameters that it regards (just user and password). For the next release I'll adapt the man page.
On 15/07/15 22:30, Brandon Jackson wrote:
https://www.monetdb.org/Documentation/mclient-man-page
I wonder, haven't tried it with the dump utility, could you get away with creating a textfile called .monetdb within the directory that you are using the utility to restore the dumps. Perhaps it, like mclient, would just read credentials and move along.
Please let me know if this works with the dumps. We use the file all the time with mclient.
On Tue, Jul 14, 2015 at 9:01 AM, Aravind S Reddy <aravind.reddy@altair.com mailto:aravind.reddy@altair.com> wrote:
Hello Team,____
We were trying to dump multiple tables through 'msqldump' tool, and restoring it in different monetdb instance in a programatic way.____
But the difficulty here is, I do not see an option to pass the --password to 'msqldump' tool, where as it prompts for the password and accepts input from STDIN. Due to this, we are not able achieve our requirement programatically.____
And it would be good if -t(--table) option accepts multiple table names, through which we can dump the selected tables in a single shot.____
Regards, ____
Aravind.S____
_______________________________________________ users-list mailing list users-list@monetdb.org mailto: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
- -- Sjoerd Mullender
participants (4)
-
Aravind S Reddy -
Brandon Jackson -
Sjoerd Mullender -
Stefan Manegold