MySQL

Skip to end of metadata
Go to start of metadata

JDBC Driver

The MySQL JDBC driver is one of the ones included with the dcm4chee distributions. Feel free to update it if you need/want to.

Create the database

Initiate the pacsdb database instance using the DDL in dcm4chee-mysql-2.14.8/sql/create.mysql.

> mysql -uroot
mysql> create database pacsdb;
mysql> grant all on pacsdb.* to 'pacs'@'localhost' identified by 'pacs';
mysql> \q
> mysql -upacs -ppacs pacsdb < dcm4chee-mysql-2.14.8/sql/create.mysql

Now we should create the audit record repository (ARR) database. No need to run a create script here because the tables will be created automatically when the application starts up.

> mysql -uroot
mysql> create database arrdb;
mysql> grant all on arrdb.* to 'arr'@'localhost' identified by 'arr';
mysql> \q

Adjust DB configuration if necessary

The database configuration information is contained within dcm4chee-mysql-2.14.8/server/default/deploy/pacs-mysql-ds.xml. If you're using a different database name, user name, etc., you'll need to update this file.

Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.