comparison Sphinx/source/plugins/mysql.rst @ 465:5bb6bc85f99f

mysql new options
author Alain Mazy <alain@mazy.be>
date Mon, 13 Jul 2020 12:08:46 +0200
parents 5d6d593bceb6
children 411e82bb3a9f
comparison
equal deleted inserted replaced
464:5ea70331c0be 465:5bb6bc85f99f
97 "Port" : 3306, // For TCP connections (notably Windows) 97 "Port" : 3306, // For TCP connections (notably Windows)
98 "UnixSocket" : "/var/run/mysqld/mysqld.sock", // For UNIX on localhost 98 "UnixSocket" : "/var/run/mysqld/mysqld.sock", // For UNIX on localhost
99 "Database" : "orthanc", 99 "Database" : "orthanc",
100 "Username" : "orthanc", 100 "Username" : "orthanc",
101 "Password" : "orthanc", 101 "Password" : "orthanc",
102 "EnableSsl" : false, // force SSL connections
103 "SslVerifyServerCertificates": true, // verify server certificates if EnableSsl is true
104 "SslCACertificates": "", // path to CA certificates to validate servers
102 "Lock" : true // See section about Locking 105 "Lock" : true // See section about Locking
103 }, 106 },
104 "Plugins" : [ 107 "Plugins" : [
105 "/home/user/orthanc-databases/BuildMySQL/libOrthancMySQLIndex.so", 108 "/home/user/orthanc-databases/BuildMySQL/libOrthancMySQLIndex.so",
106 "/home/user/orthanc-databases/BuildMySQL/libOrthancMySQLStorage.so" 109 "/home/user/orthanc-databases/BuildMySQL/libOrthancMySQLStorage.so"
112 its default SQLite back-end and the filesystem storage area. 115 its default SQLite back-end and the filesystem storage area.
113 116
114 **Important 2:** To force a TCP connection on the ``localhost`` in 117 **Important 2:** To force a TCP connection on the ``localhost`` in
115 UNIX (i.e. to instruct Orthanc not to use UNIX socket), the 118 UNIX (i.e. to instruct Orthanc not to use UNIX socket), the
116 ``UnixSocket`` can be set to the empty string. 119 ``UnixSocket`` can be set to the empty string.
120
121 **Remark:** To force using a TLS connection, you must set ``EnableSsl``
122 to ``true``. Once ``EnableSsl`` is ``true``, the ``SslVerifyServerCertificates``
123 enables the check of server certificates (``true`` by default).
124 The CA certificates used to verify the server certificate can be defined
125 through ``SslCACertificates``; if not defined or empty, the value of the global
126 Orthanc configuration ``HttpsCACertificates`` is used. These options have been
127 introduced in the mainline in July 2020 and have not yet been released.
117 128
118 **Remark:** When using the ``Storage`` MySQL plugin, the DICOM files 129 **Remark:** When using the ``Storage`` MySQL plugin, the DICOM files
119 are stored as blobs in the database. This might actually consume more 130 are stored as blobs in the database. This might actually consume more
120 space than the DICOM file itself. 131 space than the DICOM file itself.
121 132