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.
_______________________________________________
MonetDB-users mailing list