Re: how to change the user "monetdb" password?

2 Mar 2016

      Thanks very much!

From: users-list mailto:users-list-bounces+lcj34=cornell.edu@monetdb.org> on behalf of Pierre-Adrien Coustillas mailto:pcoustillas@1g6.biz>
Reply-To: Communication channel for MonetDB users mailto:users-list@monetdb.org>
Date: Tuesday, March 1, 2016 at 2:18 PM
To: Communication channel for MonetDB users mailto: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" mailto:lcj34@cornell.edu>
À: "Communication channel for MonetDB users" mailto: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