Re: [MonetDB-users] Trouble connecting - Invalid credentials
I found this subject in the archives, and I am having the same problem I am running on Mac OS X 10.4.11 I built MonetDB from source from MonetDB-Feb2008-SuperBall I am new to MonetDB, so please forgive any ignorance.. Here's what I did: > monetdb create foo # create the db > mserver5 --dbname=foo --dbinit="include sql;" # start the db > ./mclient -lsql sql>CREATE USER "bar" WITH PASSWORD 'password' NAME 'Foobar User' SCHEMA "sys"; sql>CREATE SCHEMA "bar" AUTHORIZATION "bar"; sql>ALTER USER "bar" SET SCHEMA "bar"; > ./mclient -lsql -ubar Password:password sql>\q > ./mclient -lsql -ubar Password:password !InvalidCredentialsException:checkCredentials:Invalid credentials for user 'ifm' Two things: 1) I am able to login as user 'monetdb' without any problem 2) If i stop and start 'mserver5', I can login ONCE I know that I probably should be using 'merovingian', but I'm still playing around. Any pointers? Anything I can do to help debug? Thanks, -kevin
On 16-04-2008 01:52:22 -0400, kykim_lists@mac.com wrote:
I found this subject in the archives, and I am having the same problem I am running on Mac OS X 10.4.11 I built MonetDB from source from MonetDB-Feb2008-SuperBall
I am new to MonetDB, so please forgive any ignorance..
Here's what I did:
monetdb create foo # create the db mserver5 --dbname=foo --dbinit="include sql;" # start the db
./mclient -lsql sql>CREATE USER "bar" WITH PASSWORD 'password' NAME 'Foobar User' SCHEMA "sys"; sql>CREATE SCHEMA "bar" AUTHORIZATION "bar"; sql>ALTER USER "bar" SET SCHEMA "bar"; ./mclient -lsql -ubar Password:password sql>\q ./mclient -lsql -ubar Password:password !InvalidCredentialsException:checkCredentials:Invalid credentials for user 'ifm'
Two things: 1) I am able to login as user 'monetdb' without any problem 2) If i stop and start 'mserver5', I can login ONCE
I know that I probably should be using 'merovingian', but I'm still playing around.
Any pointers? Anything I can do to help debug?
Well, the only thing I'm worried about here is that you mix two ways of running a server. You create the database using the `monetdb` tool, but start it manually. While this in itself is no problem, it becomes a problem when merovingian starts that database. However, you mention you don't use it. Is the above the exact sequence of commands you perform to get a database that refuses you? I do notice that the error you get back refers to a user "ifm", whereas the commandline argument suggests a user "bar".
working late, i make typos. the user i did create was called 'ifm' -- i was trying to change all the usernames to 'bar' to anonymize things. so i forgot to change the last string when i pasted it to my previous email :-) what i sent are the command i used in order. if i shutdown the 'mserver5' , and restart it, i am able to login to my database once. then it won't let me in anymore. i created the 'voc' example, and have had no problem logging in and out as use 'voc'. so i'm inclined to think i am doing something wrong in either creating the database, user or schema. -kevin On Apr 16, 2008, at 2:22 AM, Fabian Groffen wrote:
On 16-04-2008 01:52:22 -0400, kykim_lists@mac.com wrote:
I found this subject in the archives, and I am having the same problem I am running on Mac OS X 10.4.11 I built MonetDB from source from MonetDB-Feb2008-SuperBall
I am new to MonetDB, so please forgive any ignorance..
Here's what I did:
monetdb create foo # create the db mserver5 --dbname=foo --dbinit="include sql;" # start the db
./mclient -lsql sql>CREATE USER "bar" WITH PASSWORD 'password' NAME 'Foobar User' SCHEMA "sys"; sql>CREATE SCHEMA "bar" AUTHORIZATION "bar"; sql>ALTER USER "bar" SET SCHEMA "bar"; ./mclient -lsql -ubar Password:password sql>\q ./mclient -lsql -ubar Password:password !InvalidCredentialsException:checkCredentials:Invalid credentials for user 'ifm'
Two things: 1) I am able to login as user 'monetdb' without any problem 2) If i stop and start 'mserver5', I can login ONCE
I know that I probably should be using 'merovingian', but I'm still playing around.
Any pointers? Anything I can do to help debug?
Well, the only thing I'm worried about here is that you mix two ways of running a server.
You create the database using the `monetdb` tool, but start it manually. While this in itself is no problem, it becomes a problem when merovingian starts that database. However, you mention you don't use it. Is the above the exact sequence of commands you perform to get a database that refuses you? I do notice that the error you get back refers to a user "ifm", whereas the commandline argument suggests a user "bar".
---------------------------------------------------------------------- --- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http:// java.sun.com/javaone _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
On Wed, Apr 16, 2008 at 01:52:22AM -0400, kykim_lists@mac.com wrote:
I found this subject in the archives, and I am having the same problem I am running on Mac OS X 10.4.11 I built MonetDB from source from MonetDB-Feb2008-SuperBall
I am new to MonetDB, so please forgive any ignorance..
Here's what I did:
monetdb create foo # create the db mserver5 --dbname=foo --dbinit="include sql;" # start the db
./mclient -lsql sql>CREATE USER "bar" WITH PASSWORD 'password' NAME 'Foobar User' SCHEMA "sys"; sql>CREATE SCHEMA "bar" AUTHORIZATION "bar"; sql>ALTER USER "bar" SET SCHEMA "bar"; ./mclient -lsql -ubar Password:password sql>\q ./mclient -lsql -ubar Password:password !InvalidCredentialsException:checkCredentials:Invalid credentials for user 'ifm'
Two things: 1) I am able to login as user 'monetdb' without any problem 2) If i stop and start 'mserver5', I can login ONCE
I know that I probably should be using 'merovingian', but I'm still playing around.
Any pointers? Anything I can do to help debug?
I just repeated the sequence and get the same problem. Also the password is in the clear, which isn't right. ie you found a bug, would create a bug report on sourceforge (for easy tracking of the progress etc) ? Niels
Thanks, -kevin
------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao... _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl
On 16-04-2008 09:04:39 +0200, Niels Nes wrote:
Any pointers? Anything I can do to help debug?
I just repeated the sequence and get the same problem. Also the
Teach me how to do it so I can finally debug it (at last)
password is in the clear, which isn't right.
"in the clear"? How?
ie you found a bug, would create a bug report on sourceforge (for easy tracking of the progress etc) ?
+1
Request ID: 1943995 -kevin On Apr 16, 2008, at 3:42 AM, Fabian Groffen wrote:
On 16-04-2008 09:04:39 +0200, Niels Nes wrote:
Any pointers? Anything I can do to help debug?
I just repeated the sequence and get the same problem. Also the
Teach me how to do it so I can finally debug it (at last)
password is in the clear, which isn't right.
"in the clear"? How?
ie you found a bug, would create a bug report on sourceforge (for easy tracking of the progress etc) ?
+1
---------------------------------------------------------------------- --- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http:// java.sun.com/javaone _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
On 16-04-2008 09:04:39 +0200, Niels Nes wrote:
I just repeated the sequence and get the same problem. Also the password is in the clear, which isn't right. ie you found a bug, would create a bug report on sourceforge (for easy tracking of the progress etc) ?
Finally "the quarter has fallen". It's user/schema management related, probably not merovingian related.
participants (3)
-
Fabian Groffen -
kykim_lists＠mac.com -
Niels Nes