HI ,
I am configuring MySQL database with Dicom server,
for that, I changed in mysql.json file in the /server/Configuration folder .below is my file .
`
{
“MySQL” : {
“EnableIndex” : true,
“EnableStorage” : true,
“Host” : “127.0.0.1”, // For TCP connections (notably Windows)
“Port” : 3306, // For TCP connections (notably Windows)
“UnixSocket” : “/var/run/mysqld/mysqld.sock”, // For UNIX on localhost
“Database” : “orthanc”,
“Username” : “orthanc”,
“Password” : “orthanc”,
“Lock” : false // See section about Locking
}
}
`
but when I am starting to sever, it’s giving below error and stopping server. but in my database tables are created please suggest some solution .
`
W1109 20:04:19.700765 main.cpp:1305] Orthanc version: 1.4.2
W1109 20:04:19.703765 OrthancInitialization.cpp:169] Scanning folder “Configuration” for configuration files
W1109 20:04:19.703765 OrthancInitialization.cpp:121] Reading the configuration from: “Configuration\dicomweb.json”
W1109 20:04:19.704765 OrthancInitialization.cpp:121] Reading the configuration from: “Configuration\mysql.json”
W1109 20:04:19.704765 OrthancInitialization.cpp:121] Reading the configuration from: “Configuration\orthanc.json”
W1109 20:04:19.705765 OrthancInitialization.cpp:121] Reading the configuration from: “Configuration\postgresql.json”
W1109 20:04:19.706765 OrthancInitialization.cpp:121] Reading the configuration from: “Configuration\serve-folders.json”
W1109 20:04:19.706765 OrthancInitialization.cpp:121] Reading the configuration from: “Configuration\webviewer.json”
W1109 20:04:19.706765 OrthancInitialization.cpp:121] Reading the configuration from: “Configuration\worklists.json”
W1109 20:04:19.873775 main.cpp:655] Loading plugin(s) from: Configuration../Plugins/
W1109 20:04:19.875775 PluginsManager.cpp:269] Registering plugin ‘worklists’ (version 1.4.2)
W1109 20:04:19.875775 PluginsManager.cpp:168] Sample worklist plugin is initializing
W1109 20:04:19.875775 PluginsManager.cpp:168] Worklist server is disabled by the configuration file
W1109 20:04:19.924778 PluginsManager.cpp:269] Registering plugin ‘dicom-web’ (version 0.5)
W1109 20:04:19.925778 PluginsManager.cpp:168] URI to the DICOMweb REST API: /dicom-web/
W1109 20:04:19.926778 PluginsManager.cpp:168] URI to the WADO-URI API: /wado
W1109 20:04:19.930778 PluginsManager.cpp:269] Registering plugin ‘mysql-index’ (version 1.0)
W1109 20:04:19.937778 PluginsManager.cpp:269] Registering plugin ‘mysql-storage’ (version 1.0)
W1109 20:04:19.946779 PluginsManager.cpp:168] Your MySQL server cannot store DICOM files larger than 4MB
W1109 20:04:19.946779 PluginsManager.cpp:168] => Consider increasing “max_allowed_packet” in “my.cnf” if this limit is insufficient for your use
W1109 20:04:19.996782 PluginsManager.cpp:269] Registering plugin ‘web-viewer’ (version 2.4)
W1109 20:04:19.996782 PluginsManager.cpp:168] Initializing the Web viewer
W1109 20:04:19.997782 PluginsManager.cpp:168] Web viewer using 1 threads for the decoding of the DICOM images
W1109 20:04:19.997782 PluginsManager.cpp:168] Storing the cache of the Web viewer in folder: C:\Orthanc\WebViewerCache
W1109 20:04:20.009783 PluginsManager.cpp:168] Web viewer using a cache of 100 MB
W1109 20:04:20.009783 PluginsManager.cpp:168] Using GDCM instead of the DICOM decoder that is built in Orthanc
W1109 20:04:20.011783 PluginsManager.cpp:269] Registering plugin ‘wsi’ (version 0.5)
W1109 20:04:20.011783 PluginsManager.cpp:168] The whole-slide imaging plugin will use at most 2 threads to transcode the tiles
W1109 20:04:20.048785 PluginsManager.cpp:269] Registering plugin ‘osimis-web-viewer’ (version 1.1.1.0-08acf7b2)
W1109 20:04:20.048785 PluginsManager.cpp:168] Initializing the Web viewer
W1109 20:04:20.049785 PluginsManager.cpp:168] Using GDCM instead of the DICOM decoder that is built in Orthanc
W1109 20:04:20.051785 PluginsManager.cpp:269] Registering plugin ‘serve-folders’ (version 1.4.2)
W1109 20:04:20.052785 PluginsManager.cpp:168] ServeFolders: Empty configuration file: No additional folder will be served!
W1109 20:04:20.052785 main.cpp:1097] Using a custom database from plugins
W1109 20:04:20.052785 main.cpp:1108] Using a custom storage area from plugins
E1109 20:04:20.078786 PluginsManager.cpp:164] PostgreSQL plugin is incompatible with database schema version: 0
W1109 20:04:20.078786 PluginsManager.cpp:168] An active MySQL transaction was dismissed
W1109 20:04:20.078786 PluginsManager.cpp:219] Unregistering plugin ‘dicom-web’ (version 0.5)
W1109 20:04:20.088787 PluginsManager.cpp:219] Unregistering plugin ‘mysql-index’ (version 1.0)
W1109 20:04:20.088787 PluginsManager.cpp:168] MySQL index is finalizing
W1109 20:04:20.089787 PluginsManager.cpp:219] Unregistering plugin ‘mysql-storage’ (version 1.0)
W1109 20:04:20.089787 PluginsManager.cpp:168] MySQL storage area is finalizing
W1109 20:04:20.090787 PluginsManager.cpp:219] Unregistering plugin ‘osimis-web-viewer’ (version 1.1.1.0-08acf7b2)
W1109 20:04:20.090787 PluginsManager.cpp:168] Finalizing the Web viewer
W1109 20:04:20.099788 PluginsManager.cpp:219] Unregistering plugin ‘serve-folders’ (version 1.4.2)
W1109 20:04:20.099788 PluginsManager.cpp:219] Unregistering plugin ‘web-viewer’ (version 2.4)
W1109 20:04:20.099788 PluginsManager.cpp:168] Finalizing the Web viewer
W1109 20:04:21.023841 PluginsManager.cpp:219] Unregistering plugin ‘worklists’ (version 1.4.2)
W1109 20:04:21.024841 PluginsManager.cpp:168] Sample worklist plugin is finalizing
W1109 20:04:21.024841 PluginsManager.cpp:219] Unregistering plugin ‘wsi’ (version 0.5)
E1109 20:04:21.024841 main.cpp:1331] Uncaught exception, stopping now: [Error with the database engine] (code 11)
W1109 20:04:21.025841 main.cpp:1364] Orthanc has stopped
`
.