in each database dir in the dbfarm, there is a file (*.secret I think) that stores the secret, which is exactly the argument that merovingian passes to mserver5.
Thank you! That is what I've been trying to figure out. And so it passes the value in the .secret file as the password that it should expect? However I am not seeing any such .secret files in there. Here is what I have for the demo: under dbfarm/demo there is just a bat and box dir. ls -l /usr/var/MonetDB5/dbfarm/demo/bat total 84 drwx------ 2 root root 4096 Jun 13 15:18 01 drwx------ 2 root root 4096 Jun 13 15:18 02 drwx------ 2 root root 4096 Jun 13 15:18 03 drwx------ 2 root root 4096 Jun 13 15:18 04 drwx------ 2 root root 4096 Jun 13 15:18 05 drwx------ 2 root root 4096 Jun 13 15:18 10 drwx------ 2 root root 4096 Jun 13 15:18 11 -rw------- 1 root root 268 Jun 13 15:17 2.desc -rw------- 1 root root 4 Jun 13 15:17 2.head -rw------- 1 root root 4 Jun 13 15:17 2.tail -rw------- 1 root root 4108 Jun 13 15:17 2.theap -rw------- 1 root root 268 Jun 13 15:17 3.desc -rw------- 1 root root 4 Jun 13 15:17 3.head -rw------- 1 root root 4 Jun 13 15:17 3.tail -rw------- 1 root root 4108 Jun 13 15:17 3.theap -rw------- 1 root root 268 Jun 13 15:17 4.desc -rw------- 1 root root 0 Jun 13 15:17 4.head -rw------- 1 root root 0 Jun 13 15:17 4.tail -rw------- 1 root root 4096 Jun 13 15:17 4.theap drwxr-xr-x 2 root root 4096 Jun 13 15:21 BACKUP drwxr-xr-x 2 root root 4096 Jun 13 15:21 LEFTOVERS ls -l /usr/var/MonetDB5/dbfarm/demo/box total 0
I really don't care about using merovngian or not. I just need the db to start automatically at boot as a dameon.
If you don't care, from my point of view you're on your own.
Sorry I think you misunderstood. I do not mean that I don't care about your product. I mean that I am not committed to using merovangian and am fine not using it. But my understand is that if I want my db to start up at boot time and jdbc to access it then that is what I have to do?
You seem to walk a lot of paths that actually seem illogical to me as well.
Here's all I'm trying to do: 1) create a db and schemas. I can do this successfully with mclient. 2) make monetdb start up at boot time and listen for connections using meroviangian. if there is another way please let me know. 3) use jdbc to access the db. I cannot do this because monetdb/monetdb gives an invalid credientials response using my jdbc as well as your jdbcclient. I am quite certain there is a bug here because if I use the RELEASE build than everything works great with regards to this!!! However I cannot use that build because of the other bugs I've reported which the latest nightly fixes - but then it introduces this problem. Unfortunately I cannot wait a couple weeks until the release as by then I will be forced to go with mysql which is dog-slow compared to monetdb. Please help!! Thank you very much!!