Mercurial > hg > orthanc-databases

comparison README @ 366:cd9521e04249 attach-custom-data

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
DatabaseBackendAdapterV4: added support for customData + revision when not already done
author Alain Mazy <am@osimis.io>
date Thu, 15 Sep 2022 18:12:34 +0200
parents 8f109cfbfc5d
children
comparison
equal deleted inserted replaced
365:7671fa7f099e 366:cd9521e04249
47 Releases <= 2.1 of the PostgreSQL plugins can still be found in the 47 Releases <= 2.1 of the PostgreSQL plugins can still be found in the
48 following legacy repository: 48 following legacy repository:
49 https://hg.orthanc-server.com/orthanc-postgresql/ 49 https://hg.orthanc-server.com/orthanc-postgresql/
50 50
51 51
52 Development
53 -----------
54
55 PostgreSQL
56 ==========
57
58 To quickly start a test PG server:
59
60 docker run -p 5432:5432 --rm --env POSTGRES_HOST_AUTH_METHOD=trust postgres:13.4
61
62 And use this Orthanc configuration:
63 "PostgreSQL": {
64 "EnableIndex": true,
65 "EnableStorage": false, // DICOM files are stored in the Orthanc container in /var/lib/orthanc/db/
66 "Host": "localhost", // the name of the PostgreSQL container
67 "Database": "postgres", // default database name in PostgreSQL container (no need to create it)
68 "Username": "postgres", // default user name in PostgreSQL container (no need to create it)
69 "Password": "postgres"
70 },
71
72 MySQL
73 =====
74
75 To quickly start a test MySQL server:
76
77 docker run -p 3306:3306 --rm --env MYSQL_PASSWORD=orthanc --env MYSQL_USER=orthanc --env MYSQL_DATABASE=orthanc --env MYSQL_ROOT_PASSWORD=pwd-root mysql:8.0 mysqld --default-authentication-plugin=mysql_native_password --log-bin-trust-function-creators=1
78
79 And use this Orthanc configuration:
80 "MySQL": {
81 "EnableIndex": true,
82 "EnableStorage": false,
83 "Host": "localhost",
84 "Database": "orthanc",
85 "Username": "orthanc",
86 "Password": "orthanc",
87 "UnixSocket": ""
88 },
89
90
91 ODBC (SQL Server)
92 =================
93
94 To quickly start a test MySQL server:
95
96 docker run -e "ACCEPT_EULA=Y" --rm --env "SA_PASSWORD=yourStrong-Password" --entrypoint=bash -it -p 1433:1433 mcr.microsoft.com/mssql/server:2019-latest
97
98 Then:
99 (sleep 15s && /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P yourStrong-Password -Q 'CREATE DATABASE orthanctest') & /opt/mssql/bin/sqlservr
100
101 And use this Orthanc configuration:
102 "Odbc" : {
103 "IndexConnectionString": "Driver={ODBC Driver 17 for SQL Server};Server=tcp:localhost,1433;Database=orthanctest;Uid=sa;Pwd=yourStrong-Password;Encrypt=yes;TrustServerCertificate=yes;Connection Timeout=30;",
104 "EnableIndex": true,
105 "EnableStorage": false
106 }
107
108
109 SQLite
110 ======
111
112 To quickly test the SQLite plugin, simply run orthanc and load the plugin (no configuration required).
113
114
52 Licensing 115 Licensing
53 --------- 116 ---------
54 117
55 The database plugins for Orthanc are licensed under the AGPL license. 118 The database plugins for Orthanc are licensed under the AGPL license.
56 119