From 3d62236919c2a537580fc711f27dd7bf0610b690 Mon Sep 17 00:00:00 2001 From: Niranjana Date: Fri, 30 Jul 2021 12:32:33 +0000 Subject: Fix dmaap message insertion into database error Issue-ID: DCAEGEN2-2875 Signed-off-by: Niranjana Change-Id: I7543901a2436e65f3ca197536690112befe4f8da --- .../feeder/src/assembly/init_db/db_scripts/init_db_data.sql | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) (limited to 'components/datalake-handler/feeder/src/assembly/init_db/db_scripts') diff --git a/components/datalake-handler/feeder/src/assembly/init_db/db_scripts/init_db_data.sql b/components/datalake-handler/feeder/src/assembly/init_db/db_scripts/init_db_data.sql index 498230a9..f34fbbaf 100644 --- a/components/datalake-handler/feeder/src/assembly/init_db/db_scripts/init_db_data.sql +++ b/components/datalake-handler/feeder/src/assembly/init_db/db_scripts/init_db_data.sql @@ -58,12 +58,12 @@ insert into db_type (id, name, tool) values ('KIBANA', 'Kibana', true); insert into db_type (id, name, tool) values ('SUPERSET', 'Apache Superset', true); insert into db (id, db_type_id, enabled, encrypt, name,host,login,pass,database_name) values (1, 'CB', true, true, 'Couchbase 1','dl-couchbase','dl','dl1234','datalake'); -insert into db (id, db_type_id, enabled, encrypt, name,host) values (2, 'ES', true, true, 'Elasticsearch','dl-es'); -insert into db (id, db_type_id, enabled, encrypt, name,host,port,database_name) values (3, 'MONGO', true, true, 'MongoDB 1','dl-mongodb',27017,'datalake'); -insert into db (id, db_type_id, enabled, encrypt, name,host) values (4, 'DRUID', true, true, 'Druid','dl-druid'); -insert into db (id, db_type_id, enabled, encrypt, name,host,login) values (5, 'HDFS', true, true, 'Hadoop Cluster','dl-hdfs','dl'); -insert into db (id, db_type_id, enabled, encrypt, name,host) values (6, 'KIBANA', true, false, 'Kibana demo','dl-es'); -insert into db (id, db_type_id, enabled, encrypt, name,host) values (7, 'SUPERSET', true, false, 'Superset demo','dl-druid'); +insert into db (id, db_type_id, enabled, encrypt, name,host,port,database_name) values (2, 'MONGO', true, true, 'MongoDB 1','dl-mongodb',27017,'datalake'); +insert into db (id, db_type_id, enabled, encrypt, name,host) values (3, 'DRUID', true, true, 'Druid','dl-druid'); +insert into db (id, db_type_id, enabled, encrypt, name,host,login) values (4, 'HDFS', true, true, 'Hadoop Cluster','dl-hdfs','dl'); +insert into db (id, db_type_id, enabled, encrypt, name,host) values (5, 'KIBANA', true, false, 'Kibana demo','dl-es'); +insert into db (id, db_type_id, enabled, encrypt, name,host) values (6, 'SUPERSET', true, false, 'Superset demo','dl-druid'); +-- (execute this query if Elasticsearch is needed) insert into db (id, db_type_id, enabled, encrypt, name,host) values (7, 'ES', true, true, 'Elasticsearch','dl-es'); insert into topic_name (id) values ('_DL_DEFAULT_'); insert into topic_name (id) values ('unauthenticated.SEC_FAULT_OUTPUT'); -- cgit 1.2.3-korg