Notes on installation on varsdemo

[hohonuuli]

varsdemo is a temporary server for the upcoming Marine Imaging Workshop. Here's some notes on doing a clean install on the server to help improve the documentation

[hohonuuli]

On clean install, all micro services started fine except for https://github.com/mbari-org/beholder . The temp/beholder/cache directory was not writable by the docker daemon. I opened the permissions up to fix that.

[hohonuuli]

Conda set up:

curl https://repo.anaconda.com/miniconda/Miniconda3-py39_4.12.0-Linux-x86_64.sh -o Minconda3.sh
./Miniconda3.sh
# Logout and login to new shell
conda config --set auto_activate_base false
# Logout and login to new shell
conda activate base
cd m3-quickstart
pip install -r bin/etc/python/requirements.txt

[hohonuuli]

Scala-cli needs to be installed. This is not mentioned in the README.

[hohonuuli]

Raziel is returning the raw endpoints, not the ones via the API gateway. They should all be proxied. This is just a misconfiguration in the docker-env.sh. This needs to be addressed in the future. For this demo though, I'm submitting a request to open the following ports:

• 8081
• 8082
• 8083
• 8084
• 8085
• 8086
• 8088
• 8400

[hohonuuli]

Raziel docs at http://varsdemo.mbari.org:8400/docs/

[hohonuuli]

I had to edit docker-env.sh to change the lines:

-export HOST_IP=$(ifconfig | grep -Eo 'inet (addr:)?([0-9]*\.){3}[0-9]*' | grep -Eo '([0-9]*\.){3}[0-9]*' | grep -v '127.0.0.1' | head -1)
+export HOST_IP="varsdemo.mbari.org"

[hohonuuli]

Getting an error when trying to update and observation:

PostgreSQL Database directory appears to contain a database; Skipping initialization

2022-09-28 00:22:09.862 UTC [1] LOG:  starting PostgreSQL 14.5 (Debian 14.5-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
2022-09-28 00:22:09.862 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2022-09-28 00:22:09.862 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2022-09-28 00:22:09.866 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2022-09-28 00:22:09.879 UTC [26] LOG:  database system was shut down at 2022-09-28 00:22:02 UTC
2022-09-28 00:22:09.883 UTC [1] LOG:  database system is ready to accept connections
2022-09-28 00:22:39.563 UTC [38] ERROR:  operator does not exist: uuid = character varying at character 60
2022-09-28 00:22:39.563 UTC [38] HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
2022-09-28 00:22:39.563 UTC [38] STATEMENT:  UPDATE observations SET imaged_moment_uuid = $1 WHERE uuid = $2
2022-09-28 00:22:39.566 UTC [38] ERROR:  current transaction is aborted, commands ignored until end of transaction block
2022-09-28 00:22:39.566 UTC [38] STATEMENT:  SELECT 1

[hohonuuli]

The above error is related to the postgres:14 image. It pulled Postgres 14.5. DARC is running 14.2 and not running into that issue. Modifying docker-compose.yml as follows addressed it:

-    image: postgres:14
+    image: postgres:14.2

I think the long term fix is to run this against SQL Server and avoid posgres' quirks

[hohonuuli]

Had to modify the CreateUser.sc script and add:

+Class.forName("org.postgresql.Driver")

That was not the case previously. May need to look into Scala-cli to see if it had changes in when libraries are included in scripts.

[hohonuuli]

Note that gradle does not yet support Java 19. Building the VARS Query app will fail on 19, use 17 (LTS) instead.

[hohonuuli]

Ran the following and it worked AOK:

 ./vars_register_medias_on_web.sh Ventana "Ventana 4003" "http://varsdemo.mbari.org/media/M3/proxy/Ventana/2017/03/4003/"
 ./vars_register_medias_on_web.sh Ventana "Ventana 4003" "http://varsdemo.mbari.org/media/M3/mezzanine/Ventana/2017/03/4003/"

[hohonuuli]

There's no vars_build.bat file in the project to build the windows versions of vars-query and vars-kb. doh!