Posts
Steps:-
1. Create a role mirthdb as password mirthdb in postgres and assign super user priviledge.
2. Open the attached sql and run the script.CREATE ROLE mirthdb LOGIN
ENCRYPTED PASSWORD 'md5ffedeac0808a4430dd3bfa01f1d02bac'
SUPERUSER INHERIT CREATEDB CREATEROLE REPLICATION;
3. Go to Mirth installe folder ex:- D:\MirthConnect2.2\conf\mirth.properties
Change the below properties :-
database = postgres
database.url = jdbc:postgresql://localhost:5432/mirthdb
database.username = mirthdb
database.password = mirthdb
4. Restart the server. ENJOY !!!!!
-- Role: mirthdb
-- DROP ROLE mirthdb;
-- CREATE ROLE mirthdb LOGIN
-- ENCRYPTED PASSWORD 'md5ffedeac0808a4430dd3bfa01f1d02bac'
-- SUPERUSER INHERIT CREATEDB CREATEROLE REPLICATION;
CREATE TABLE SCHEMA_INFO
(VERSION VARCHAR(40));
CREATE SEQUENCE EVENT_SEQUENCE START WITH 1;
CREATE TABLE EVENT
(ID INTEGER DEFAULT nextval('EVENT_SEQUENCE') NOT NULL PRIMARY KEY,
DATE_CREATED TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
NAME TEXT NOT NULL,
EVENT_LEVEL VARCHAR(40) NOT NULL,
OUTCOME VARCHAR(40) NOT NULL,
ATTRIBUTES TEXT,
USER_ID INTEGER NOT NULL,
IP_ADDRESS VARCHAR(40));
CREATE TABLE CHANNEL
(ID CHAR(36) NOT NULL PRIMARY KEY,
NAME VARCHAR(40) NOT NULL,
DESCRIPTION TEXT,
IS_ENABLED BOOLEAN NOT NULL,
VERSION VARCHAR(40),
REVISION INTEGER,
LAST_MODIFIED TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
SOURCE_CONNECTOR TEXT,
DESTINATION_CONNECTORS TEXT,
PROPERTIES TEXT,
PREPROCESSING_SCRIPT TEXT,
POSTPROCESSING_SCRIPT TEXT,
DEPLOY_SCRIPT TEXT,
SHUTDOWN_SCRIPT TEXT);
CREATE TABLE CHANNEL_STATISTICS
(SERVER_ID CHAR(36) NOT NULL,
CHANNEL_ID CHAR(36) NOT NULL REFERENCES CHANNEL(ID) ON DELETE CASCADE,
RECEIVED NUMERIC,
FILTERED NUMERIC,
SENT NUMERIC,
ERROR NUMERIC,
QUEUED NUMERIC,
ALERTED NUMERIC,
PRIMARY KEY(SERVER_ID, CHANNEL_ID));
CREATE SEQUENCE MESSAGE_SEQUENCE START WITH 1;
CREATE TABLE ATTACHMENT
(ID VARCHAR(255) NOT NULL PRIMARY KEY,
MESSAGE_ID VARCHAR(255) NOT NULL,
ATTACHMENT_DATA BYTEA,
ATTACHMENT_SIZE INTEGER,
ATTACHMENT_TYPE VARCHAR(40));
CREATE INDEX ATTACHMENT_INDEX1 ON ATTACHMENT(MESSAGE_ID);
CREATE TABLE MESSAGE
(SEQUENCE_ID INTEGER DEFAULT NEXTVAL('MESSAGE_SEQUENCE') NOT NULL PRIMARY KEY,
ID CHAR(36) NOT NULL,
SERVER_ID CHAR(36) NOT NULL,
CHANNEL_ID CHAR(36) NOT NULL REFERENCES CHANNEL(ID) ON DELETE CASCADE,
SOURCE VARCHAR(255),
TYPE VARCHAR(255),
DATE_CREATED TIMESTAMP NOT NULL,
VERSION VARCHAR(40),
IS_ENCRYPTED BOOLEAN NOT NULL,
STATUS VARCHAR(40),
RAW_DATA TEXT,
RAW_DATA_PROTOCOL VARCHAR(40),
TRANSFORMED_DATA TEXT,
TRANSFORMED_DATA_PROTOCOL VARCHAR(40),
ENCODED_DATA TEXT,
ENCODED_DATA_PROTOCOL VARCHAR(40),
CONNECTOR_MAP TEXT,
CHANNEL_MAP TEXT,
RESPONSE_MAP TEXT,
CONNECTOR_NAME VARCHAR(255),
ERRORS TEXT,
CORRELATION_ID VARCHAR(255),
ATTACHMENT BOOLEAN,
UNIQUE (ID));
CREATE INDEX MESSAGE_INDEX1 ON MESSAGE(CHANNEL_ID, DATE_CREATED);
CREATE INDEX MESSAGE_INDEX2 ON MESSAGE(CHANNEL_ID, DATE_CREATED, CONNECTOR_NAME);
CREATE INDEX MESSAGE_INDEX3 ON MESSAGE(CHANNEL_ID, DATE_CREATED, RAW_DATA_PROTOCOL);
CREATE INDEX MESSAGE_INDEX4 ON MESSAGE(CHANNEL_ID, DATE_CREATED, SOURCE);
CREATE INDEX MESSAGE_INDEX5 ON MESSAGE(CHANNEL_ID, DATE_CREATED, STATUS);
CREATE INDEX MESSAGE_INDEX6 ON MESSAGE(CHANNEL_ID, DATE_CREATED, TYPE);
CREATE INDEX MESSAGE_INDEX7 ON MESSAGE(CORRELATION_ID, CONNECTOR_NAME);
CREATE INDEX MESSAGE_INDEX8 ON MESSAGE(ATTACHMENT) WHERE (ATTACHMENT=TRUE);
CREATE TABLE SCRIPT
(GROUP_ID VARCHAR(40) NOT NULL,
ID VARCHAR(40) NOT NULL,
SCRIPT TEXT,
PRIMARY KEY(GROUP_ID, ID));
CREATE TABLE TEMPLATE
(GROUP_ID VARCHAR(255) NOT NULL,
ID VARCHAR(255) NOT NULL,
TEMPLATE TEXT,
PRIMARY KEY(GROUP_ID, ID));
CREATE SEQUENCE PERSON_SEQUENCE START WITH 1;
CREATE TABLE PERSON
(ID INTEGER DEFAULT nextval('PERSON_SEQUENCE') NOT NULL PRIMARY KEY,
USERNAME VARCHAR(40) NOT NULL,
FIRSTNAME VARCHAR(40),
LASTNAME VARCHAR(40),
ORGANIZATION VARCHAR(255),
EMAIL VARCHAR(255),
PHONENUMBER VARCHAR(40),
DESCRIPTION VARCHAR(255),
LAST_LOGIN TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
GRACE_PERIOD_START TIMESTAMP DEFAULT NULL,
LOGGED_IN BOOLEAN NOT NULL);
CREATE TABLE PERSON_PASSWORD
(PERSON_ID INTEGER NOT NULL REFERENCES PERSON(ID) ON DELETE CASCADE,
PASSWORD VARCHAR(256) NOT NULL,
PASSWORD_DATE TIMESTAMP DEFAULT CURRENT_TIMESTAMP);
CREATE TABLE ALERT
(ID CHAR(36) NOT NULL PRIMARY KEY,
NAME VARCHAR(40) NOT NULL,
IS_ENABLED BOOLEAN NOT NULL,
EXPRESSION TEXT,
TEMPLATE TEXT,
SUBJECT VARCHAR(998));
CREATE TABLE CODE_TEMPLATE
(ID VARCHAR(255) NOT NULL PRIMARY KEY,
NAME VARCHAR(40) NOT NULL,
CODE_SCOPE VARCHAR(40) NOT NULL,
CODE_TYPE VARCHAR(40) NOT NULL,
TOOLTIP VARCHAR(255),
CODE TEXT);
CREATE TABLE CHANNEL_ALERT
(CHANNEL_ID CHAR(36) NOT NULL,
ALERT_ID CHAR(36) NOT NULL REFERENCES ALERT(ID) ON DELETE CASCADE);
CREATE TABLE ALERT_EMAIL
(ALERT_ID CHAR(36) NOT NULL REFERENCES ALERT(ID) ON DELETE CASCADE,
EMAIL VARCHAR(255) NOT NULL);
CREATE SEQUENCE CONFIGURATION_SEQUENCE START WITH 1;
CREATE TABLE CONFIGURATION
(CATEGORY VARCHAR(255) NOT NULL,
NAME VARCHAR(255) NOT NULL,
VALUE TEXT);
INSERT INTO PERSON (USERNAME, LOGGED_IN) VALUES('admin', FALSE);
INSERT INTO PERSON_PASSWORD (PERSON_ID, PASSWORD) VALUES(1, 'YzKZIAnbQ5m+3llggrZvNtf5fg69yX7pAplfYg0Dngn/fESH93OktQ==');
INSERT INTO SCHEMA_INFO (VERSION) VALUES ('9');
INSERT INTO CONFIGURATION (CATEGORY, NAME, VALUE) VALUES ('core', 'update.url', 'http://updates.mirthcorp.com');
INSERT INTO CONFIGURATION (CATEGORY, NAME, VALUE) VALUES ('core', 'update.enabled', '1');
INSERT INTO CONFIGURATION (CATEGORY, NAME, VALUE) VALUES ('core', 'stats.enabled', '1');
INSERT INTO CONFIGURATION (CATEGORY, NAME, VALUE) VALUES ('core', 'firstlogin', '1');
INSERT INTO CONFIGURATION (CATEGORY, NAME, VALUE) VALUES ('core', 'server.resetglobalvariables', '1');
INSERT INTO CONFIGURATION (CATEGORY, NAME, VALUE) VALUES ('core', 'smtp.timeout', '5000');
INSERT INTO CONFIGURATION (CATEGORY, NAME, VALUE) VALUES ('core', 'smtp.auth', '0');
INSERT INTO CONFIGURATION (CATEGORY, NAME, VALUE) VALUES ('core', 'smtp.secure', '0');
INSERT INTO CONFIGURATION (CATEGORY, NAME, VALUE) VALUES ('core', 'server.maxqueuesize', '0');
