hobbit-project / platform

HOBBIT benchmarking platform
GNU General Public License v2.0
23 stars 9 forks source link

Setup problem with VOS - Bad Login - Error 28000 #434

Open bushranz opened 5 years ago

bushranz commented 5 years ago

I am trying to run the local instance of Hobbit platform. All services are up and running (after docker-compose up -d). But storage initialization fails. Have cloned the latest version of the platform. Running command make setup-virtuoso gives the following error:

Creating vos ... done
./run-storage-init.sh; true
Waiting for port to open...

*** Error 28000: [Virtuoso Driver]CL034: Bad login
at line 0 of Top-Level:
*** Error 28000: [Virtuoso Driver]CL034: Bad login
at line 0 of Top-Level:
*** Error 28000: [Virtuoso Driver]CL034: Bad login
at line 0 of Top-Level:
*** Error 28000: [Virtuoso Driver]CL034: Bad login
at line 0 of Top-Level:
*** Error 28000: [Virtuoso Driver]CL034: Bad login
at line 0 of Top-Level:
*** Error 28000: [Virtuoso Driver]CL034: Bad login
at line 0 of Top-Level:
*** Error 28000: [Virtuoso Driver]CL034: Bad login
at line 0 of Top-Level:
*** Error 28000: [Virtuoso Driver]CL034: Bad login
at line 0 of Top-Level:
*** Error 28000: [Virtuoso Driver]CL034: Bad login
at line 0 of Top-Level:

docker-compose stop vos
Stopping vos ... done
docker rm vos
vos
bushranz commented 5 years ago

Update: initialization script for vos

Checked into the storage-init.sh script. The script tries run statements with dba and tries to change the password in the end, but actually it authorizes only those statements to run which use Password as a password. So I changed the password used in each isql statement from ´dba´ to ´Password´. And the script ran successfully.

denkv commented 5 years ago

It looks like the storage-init.sh was executed twice and the first run actually did change the password. Usually it is enough to run it once.

Maybe we should add set -e to that script so it will not proceed in case of any problems encountered.