Bugs item #2794792, was opened at 2009-05-21 14:29
Message generated for change (Comment added) made by skinkie
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2794792&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Core
Group: SQL "stable"
>Status: Open
Resolution: Fixed
Priority: 5
Private: No
Submitted By: Stefan de Konink (skinkie)
Assigned to: Fabian (mr-meltdown)
Summary: Changing 'monetdb' password; very undocumented
Initial Comment:
1) A user wants to change his monetdb password
2) The default case doesn't work:
alter user monetdb with password 'nietveilig';
!InvalidCredentialsException:setPassword:The administrator cannot set its own
password, use changePassword instead
3) At this point a person must Google for the correct syntax, finding out that
the documented mentioned in a mailinglist returns:
clients.changePassword("monetdb", "nietveilig");
!syntax error, unexpected IDENT in: "clients"
4) Another way pointed out using mclient -lmal returns
mal>clients.changePassword("monetdb", "nietveilig");
MAPI = mone...@localhost:50000
QUERY = clients.changePassword("monetdb", "nietveilig");
ERROR = !MALException:verifyPassword:password is not 128 chars long, is it a
hex representation of a SHA-2 512-bits password hash?
#function user.main():void;
# clients.changePassword("monetdb","nietveilig");
#end main;
Since the following doesn't work:
explain alter user rullzer with password 'test';
and...
MAPI = mone...@localhost:50000
QUERY = auth.AUTHSHA2Sum("test", 4, 512);
ERROR = !TypeException:user.main[1]:'auth.AUTHSHA2Sum' undefined in: _1:any :=
auth.AUTHSHA2Sum(_2:str, _3:int, _4:int)
mal>AUTHSHA2Sum("test", 512);
MAPI = mone...@localhost:50000
QUERY = AUTHSHA2Sum("test", 512);
ERROR = !TypeException:user.main[1]:'user.AUTHSHA2Sum' undefined in: _1:any :=
user.AUTHSHA2Sum(_2:str, _3:int)
mal>sha2sum("test", 512);
MAPI = mone...@localhost:50000
QUERY = sha2sum("test", 512);
ERROR = !TypeException:user.main[1]:'user.sha2sum' undefined in: _1:any :=
user.sha2sum(_2:str, _3:int)
mal>authorize.sha2sum("test", 512);
MAPI = mone...@localhost:50000
QUERY = authorize.sha2sum("test", 512);
ERROR = !TypeException:user.main[1]:'authorize.sha2sum' undefined in: _1:any :=
authorize.sha2sum(_2:str, _3:int)
I wonder what is expected from the user to gets its password from inside
MonetDB, without using external tools.
----------------------------------------------------------------------
>Comment By: Stefan de Konink (skinkie)
Date: 2009-05-21 17:16
Message:
You're welcome :)
Could you add this very deep 'expert knowledge' also to
<http://monetdb.cwi.nl/projects/monetdb/SQL/Documentation/Client-Authorization.html>
?
----------------------------------------------------------------------
Comment By: Fabian (mr-meltdown)
Date: 2009-05-21 17:12
Message:
thanks for the report!
how about this? I agree the error message that comes from the backend
isn't too clear. I'll see if I can trap it.
(pegasus:stable/sql/src) fabian% $INSTALL_DIR/bin/mclient -lsql -dcapesea
sql>alter user monetdb with password 'nietveilig';
!InvalidCredentialsException:setPassword:The administrator cannot set its
own password, use changePassword instead
0 tuples
sql>alter user set password 'nietveilig' using old password 'monetdb';
0 tuples
sql>
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2794792&group_id=56967
------------------------------------------------------------------------------
Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT
is a gathering of tech-side developers & brand creativity professionals. Meet
the minds behind Google Creative Lab, Visual Complexity, Processing, &
iPhoneDevCamp asthey present alongside digital heavyweights like Barbarian
Group, R/GA, & Big Spaceship. http://www.creativitycat.com
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
