A docker container that combines Octo with the VEHU version of VistA
10K+
Both of these can be done in one step like this. Pass port 1338, as that's what's used to connect to Octo. If you wish, you can add 8089-8092 which are used for the YottaDB GUI. http://localost:8089/ will take you to an HTTP version, and https://localhost:8091 will take you to an HTTPS version.
docker run -d -p 2222:22 -p 1338:1338 -p 8089-8092:8089-8092 -p 9430:9430 --name=octo-vehu download.yottadb.com/yottadb/octo-vehu:latest-master
You can use psql from your Linux host, the octo executable inside the docker container, or our supported GUI client Squirrel SQL. If you use psql, its host:port is localhost:1338; username/password admin/admin. Here's an example:
$ psql -h localhost -U admin -p 1338
Password for user admin: admin
psql (10.17, server 9.6.5)
Type "help" for help.
admin=# select NAME,AGE from PATIENT where AGE > 60 LIMIT 5;
name | age
------------------------------+-----
ZZZRETFIVEFIFTYONE,PATIENT | 86
ZZZRETFIVEFORTYSEVEN,PATIENT | 86
EIGHT,PATIENT | 86
ZZZRETIREDZERO,PATIENT | 86
ZZZRETIREDFIFTYSEVEN,PATIENT | 86
(5 rows)
If you want to use Octo inside the container, you can do it like this:
$ docker exec -it octo-vehu su - vehu
Last login: Fri Jan 28 19:03:05 UTC 2022 on pts/0
[vehu@ad2008bb18cf ~]$ octo
OCTO> select NAME,AGE from PATIENT where AGE > 60 LIMIT 5;
NAME|AGE
ZZZRETFIVEFIFTYONE,PATIENT|86
ZZZRETFIVEFORTYSEVEN,PATIENT|86
EIGHT,PATIENT|86
ZZZRETIREDZERO,PATIENT|86
ZZZRETIREDFIFTYSEVEN,PATIENT|86
(5 rows)
OCTO>
If you want a GUI, you can use Squirrel SQL. Detailed instructions here: https://docs.yottadb.com/Octo/rocto.html#connecting-using-squirrel-sql. You need to connect host:port localhost:1338; username/password admin/admin.
Yes, it's docker exec -it octo-vehu su - vehu. You can run yottadb -dir, octo, mupip, and everything else.
$ docker exec -it octo-vehu su - vehu -c 'yottadb -dir'
VEHU>
You can also just log-in first and then run yottadb -dir
Content type
Image
Digest
sha256:28f65c3be…
Size
1.8 GB
Last updated
about 7 hours ago
docker pull yottadb/octo-vehu:latest-master