Fabian, I can create this behaviour at will;
!InvalidCredentialsException:checkCredentials:Invalid credentials for user 'monetdb'
++++++++++++++++++=
# run startup script for merovingian as root, the script starts merovingian as user monetdb
amd64:/monetdb/bin # /etc/init.d/monetdb start
Using configuration at /monetdb/etc/monetdb5.conf
Using path to daemon /monetdb/bin/merovingian
Starting MonetDB Merovingian daemon, port:50050 done
Done.
# su to user monetdb and connect to the database
amd64:/monetdb/bin # su monetdb
monetdb@amd64:/monetdb/bin> ./mclient --database=DPAINSTANCE --user=monetdb --passwd=monetdb -lsql;
sql>select * from db_user_info;
+---------+--------------+---------------+
| name |fullname |default_schema |
+=========+==============+===============+
| monetdb |MonetDB Admin | 980 |
+---------+--------------+---------------+
sql>select * from auths;
+----+---------+--------+
| id |name |grantor |
+====+=========+========+
| 1 |public | 0 |
| 2 |sysadmin | 0 |
| 3 |monetdb | 0 |
+----+---------+--------+
sql>select * from privileges;
+--------+--------+-----------+--------+----------+
| obj_id |auth_id |privileges |grantor |grantable |
+========+========+===========+========+==========+
| 981 | 1 | 1 | 0 | 0 |
| 986 | 1 | 1 | 0 | 0 |
| 995 | 1 | 1 | 0 | 0 |
| 1004 | 1 | 1 | 0 | 0 |
| 1012 | 1 | 1 | 0 | 0 |
| 1035 | 1 | 1 | 0 | 0 |
| 1043 | 1 | 1 | 0 | 0 |
| 1053 | 1 | 1 | 0 | 0 |
| 1060 | 1 | 1 | 0 | 0 |
| 1065 | 1 | 1 | 0 | 0 |
| 1076 | 1 | 1 | 0 | 0 |
| 3791 | 1 | 1 | 0 | 0 |
| 3800 | 1 | 1 | 0 | 0 |
| 3838 | 1 | 1 | 0 | 0 |
+--------+--------+-----------+--------+----------+
# drop the connection
sql>\q;
# attempt to reconnect again
monetdb@amd64:/monetdb/bin> ./mclient --database=DPAINSTANCE --user=monetdb --passwd=monetdb -lsql;
!InvalidCredentialsException:checkCredentials:Invalid credentials for user 'monetdb'
# check status
monetdb@amd64:/monetdb/bin> ./monetdb status
name state uptime crashes
DPAINSTANCE running 1m 3s 1 2008-03-08 22:39:58
monetdb@amd64:/monetdb/bin>
++++++++++++++++++++++
If there is some logging you want me to turn on to try and figure this out, let me know
Environment is
# MonetDB server v5.4.1, based on kernel v1.22.1
# Compiled for i686-pc-linux-gnu/32bit with 32bit OIDs dynamically linked
Linux OpenSuse 10.3,
Kernel 2.6.22.17-0.1-bigsmp
AMD Athlon64 4GB RAM
Fri 14 Mar 2008 12:00:08 PM EDT from Fabian Groffen to monetdb-users@lists.sourceforge.net
Subject: Re: [MonetDB-users] Trouble connecting
Hi Richard,
On 14-03-2008 12:06:11 -0300, Richard Eckart wrote:
> I start the merovingian process which seems to run fine.
> After that the only time I can connect successfully to a database
> using mclient (or any other client) is the first time I try to
> connect (if it works at all). For example
>
> ./mclient -lsql --database demo
> !InvalidCredentialsException:checkCredentials:Invalid credentials for
> user 'monetdb'
I've seen this too, and I'm out of clues as to why actually. It is the
mserver5 process that denies you access, but it is inconsistent as in
why, and our testing environment isn't affected by it either...
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
a href=http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ TARGET=webcit01http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01//A
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users
--
Matthew McKennirey
mmckennirey@dpfuture.biz
home office 301 841 7690
cell 703 868 8234