how to change the user "monetdb" password?
Hi all -
I've been googling to try and find a method of changing the default password for user monetdb. The links I've found are all 8-9 years old (e.g. Thishttps://www.monetdb.org/pipermail/users-list/2007-December/001345.html one)
My commands: 1. monetdbd stop <mydbfarm> 2. cd /Usr/local/monetdb/bin 3. ./mserver5
Then execute a change password command and get these results, which look similar to the email exchange noted in the 8 year old link above:
rs-btlcj34lt:bin lcj34$ ./mserver5
# MonetDB 5 server v11.21.11 "Jul2015-SP1"
# Serving database 'demo', using 8 threads
# Compiled for x86_64-apple-darwin14/64bit with 64bit OIDs and 128bit integers dynamically linked
# Found 16.000 GiB available main-memory.
# Copyright (c) 1993-July 2008 CWI.
# Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved
# Visit http://www.monetdb.org/ for further information
# Listening for connection requests on mapi:monetdb://127.0.0.1:50000/
# MonetDB/GIS module loaded
# Start processing logs sql/sql_logs version 52200
# Finished processing logs sql/sql_logs
# MonetDB/SQL module loaded
changePassword("monetdb","bucklerLab");
!TypeException:user.main[1]:'user.changePassword' undefined in: user.changePassword("monetdb":str,"bucklerLab":str);
We are opening up our database to some outside folks. I've successfully created a read-only user/pwd for them, but want to protect the db by changing the default monetdb user password. I'm practicing on my own local copy before messing with our "real" db, but can't get this to work. Is there some other way I should be going about this?
One additional question: What is the "passphrase" parameter I see when I run "monetdbd get all <mydbfarm>"? I tried playing with that but have not found what it effects.
Thanks - Lynn
Hi,
https://www.monetdb.org/Documentation/SQLreference/Users
sample : ALTER USER SET UNENCRYPTED PASSWORD 'xxxxxx' USING OLD PASSWORD 'monetdb';
Pierre
De: "Lynn Carol Johnson" lcj34@cornell.edu À: "Communication channel for MonetDB users" users-list@monetdb.org Envoyé: Mardi 1 Mars 2016 19:52:26 Objet: how to change the user "monetdb" password?
Hi all -
I’ve been googling to try and find a method of changing the default password for user monetdb. The links I’ve found are all 8-9 years old (e.g. This one)
My commands: 1. monetdbd stop <mydbfarm> 2. cd /Usr/local/monetdb/bin 3. ./mserver5
Then execute a change password command and get these results, which look similar to the email exchange noted in the 8 year old link above:
rs-btlcj34lt:bin lcj34$ ./mserver5
# MonetDB 5 server v11.21.11 "Jul2015-SP1"
# Serving database 'demo', using 8 threads
# Compiled for x86_64-apple-darwin14/64bit with 64bit OIDs and 128bit integers dynamically linked
# Found 16.000 GiB available main-memory.
# Copyright (c) 1993-July 2008 CWI.
# Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved
# Visit http://www.monetdb.org/ for further information
# Listening for connection requests on mapi:monetdb://127.0.0.1:50000/
# MonetDB/GIS module loaded
# Start processing logs sql/sql_logs version 52200
# Finished processing logs sql/sql_logs
# MonetDB/SQL module loaded
changePassword("monetdb","bucklerLab");
!TypeException:user.main[1]:'user.changePassword' undefined in: user.changePassword("monetdb":str,"bucklerLab":str);
We are opening up our database to some outside folks. I’ve successfully created a read-only user/pwd for them, but want to protect the db by changing the default monetdb user password. I’m practicing on my own local copy before messing with our “real” db, but can’t get this to work. Is there some other way I should be going about this?
One additional question: What is the “passphrase” parameter I see when I run “monetdbd get all <mydbfarm>”? I tried playing with that but have not found what it effects.
Thanks - Lynn
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Thanks very much!
From: users-list <users-list-bounces+lcj34=cornell.edu@monetdb.orgmailto:users-list-bounces+lcj34=cornell.edu@monetdb.org> on behalf of Pierre-Adrien Coustillas <pcoustillas@1g6.bizmailto:pcoustillas@1g6.biz> Reply-To: Communication channel for MonetDB users <users-list@monetdb.orgmailto:users-list@monetdb.org> Date: Tuesday, March 1, 2016 at 2:18 PM To: Communication channel for MonetDB users <users-list@monetdb.orgmailto:users-list@monetdb.org> Subject: Re: how to change the user "monetdb" password?
Hi,
https://www.monetdb.org/Documentation/SQLreference/Users
sample : ALTER USER SET UNENCRYPTED PASSWORD 'xxxxxx' USING OLD PASSWORD 'monetdb';
Pierre
________________________________ De: "Lynn Carol Johnson" <lcj34@cornell.edumailto:lcj34@cornell.edu> À: "Communication channel for MonetDB users" <users-list@monetdb.orgmailto:users-list@monetdb.org> Envoyé: Mardi 1 Mars 2016 19:52:26 Objet: how to change the user "monetdb" password?
Hi all -
I've been googling to try and find a method of changing the default password for user monetdb. The links I've found are all 8-9 years old (e.g. Thishttps://www.monetdb.org/pipermail/users-list/2007-December/001345.html one)
My commands: 1. monetdbd stop <mydbfarm> 2. cd /Usr/local/monetdb/bin 3. ./mserver5
Then execute a change password command and get these results, which look similar to the email exchange noted in the 8 year old link above:
rs-btlcj34lt:bin lcj34$ ./mserver5
# MonetDB 5 server v11.21.11 "Jul2015-SP1"
# Serving database 'demo', using 8 threads
# Compiled for x86_64-apple-darwin14/64bit with 64bit OIDs and 128bit integers dynamically linked
# Found 16.000 GiB available main-memory.
# Copyright (c) 1993-July 2008 CWI.
# Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved
# Visit http://www.monetdb.org/ for further information
# Listening for connection requests on mapi:monetdb://127.0.0.1:50000/
# MonetDB/GIS module loaded
# Start processing logs sql/sql_logs version 52200
# Finished processing logs sql/sql_logs
# MonetDB/SQL module loaded
changePassword("monetdb","bucklerLab");
!TypeException:user.main[1]:'user.changePassword' undefined in: user.changePassword("monetdb":str,"bucklerLab":str);
We are opening up our database to some outside folks. I've successfully created a read-only user/pwd for them, but want to protect the db by changing the default monetdb user password. I'm practicing on my own local copy before messing with our "real" db, but can't get this to work. Is there some other way I should be going about this?
One additional question: What is the "passphrase" parameter I see when I run "monetdbd get all <mydbfarm>"? I tried playing with that but have not found what it effects.
Thanks - Lynn
_______________________________________________ users-list mailing list users-list@monetdb.orgmailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Lynn Carol Johnson -
Pierre-Adrien Coustillas