I've created a new shard in a vmware Ubuntu 18.04.1 environment using postgresql 10. I've run into the following problem when I try to launch the server:
osboxes@osboxes:~$ cd /opt/dirtsand
osboxes@osboxes:/opt/dirtsand$ bin/dirtsand dirtsand.ini
ds-918> [Status] Running on 127.0.0.1/8080
[Lobby] Running on 127.0.0.1/14617
Postgres SELECT error: ERROR: permission denied for schema vault
LINE 1: SELECT "idx" FROM vault."Nodes" WHERE "NodeType"=$1
[Auth] Vault failed to initialize
Does anyone know what the problem is and the solution? I suspect that dirtsand tries to initialize the progresql database rather than dirtsand and that the dirtsand user has insufficient privileges to be able to succeed. It may be that the version of dirtsand that I use tries to open the wrong database.
I've checked that dirtsand.ini has the right settings for db.username and db.password and that the dirtsand user can access progresql with those credentials.