PostgreSQL 7.2 + OE2 1.8.0 + authorization plugin 0.9.0

Releases
1

Hi everyone,

Here are a few new releases:

The Orthanc Explorer 2 plugin has been updated to version 1.8.0 adding support, amongst others, for custom buttons.

PostgreSQL 7.2 is out with a few small optimizations and fixes.

This version comes with an updated DB schema so check the Orthanc book .

The Authorization plugin has been updated to version 0.9.0.

All these releases are available

Enjoy !

Alain

4 Likes
2

When will this be pushed to Docker hub? As of the morning of March 2, it is not on https://hub.docker.com/r/orthancteam/orthanc/tags

3

Hi @ddrucker

Sorry, I did not notice that the built had been interrupted. The images are now available.

Alain

1 Like
4

Hi Alain and others,

Orthanc (running fine on linux server - LSB all updated except PGSQL index plugin) will refuse to start when I use this plugin (but would start if I replace the plugin by its former version). I suspect this could be due to the DB schema update required by the new plugin but I’m not sure. I tried to fix looking on the PGSQL side but couldn’t find a solution.

Log error is below:

E0611 09:03:19.999654 MAIN postgresql-index:/PostgreSQLDatabase.cpp:187] PostgreSQL error: ERROR: must be owner of table resources
CONTEXT: SQL statement “CREATE INDEX IF NOT EXISTS ChildrenIndex2 ON Resources USING btree (parentId ASC NULLS LAST) INCLUDE (publicId, internalId)”
PL/pgSQL function inline_code_block line 11 at EXECUTE

Should I upgrade the DB schema manually before? I don’t want to do any critical mistake so I haven’t yet.

Thanks for any input regarding this!

Nicolas

5

Hi @NAA

Orthanc should take care of the update by itself.

Here, it seems that the user orthanc is using to connect to PG does not have the right to modify the table structure.

So you can either upgrade the user rights or run the update procedure manually.

HTH,

Alain

6

Hi Alain and thanks a lot for your fast answer!
I’ll keep you posted if I can’t fix it following your advices.

Best regards

Nicolas

7

Hi,

I unfortunately have another error after a manual upgrade of the DB and while using PGSQL plugin 8.0:

DICOM-4 postgresql-index:/PostgreSQLStatement.cpp:194] PostgreSQL error: ERROR: INSERT has more expressions than target columns
LINE 1: …ttachedFiles VALUES($1, $2, $3, $4, $5, $6, $7, $8, $9, $10)

Does it ring a bell to you?

Thanks for any answer regarding this issue!

Nicolas

8

Hi again,

I restarted the server and the problem seems now solved, sorry for the disturbance!

Have a good WE

Nicolas