search

KnowageLabs / Knowage-Server

Knowage is the professional open source suite for modern business analytics over traditional sources and big data systems.
http://www.knowage-suite.com
GNU Affero General Public License v3.0
402 stars 219 forks source link

Can u give me a method for upload test demo, same like online version #576

Closed johnfelipe closed 1 year ago

johnfelipe commented 2 years ago

im research metabase. superset and others, superset upload demos very complete, can u guide me for upload demos to knowage?

johnfelipe commented 2 years ago

Anyone?

Redjaw commented 2 years ago

Hi, can you explain us what your goal is? There are different approach we can take depending on what you are willing to do:

johnfelipe commented 2 years ago

No bro, I want demos online in my local installation, pls.

Redjaw commented 2 years ago

So the easiest way is to install knowage with the installer. There are already some foodmart DB demos in there. You can freely download it from here, you just have to register.

johnfelipe commented 2 years ago

Explain pls about upload demos I already install via clone

El vie, 10 de jun. de 2022, 8:29 a. m., Davide Vernassa < @.***> escribió:

So the easiest way is to install knowage with the installer. There are already some foodmart DB demos in there. You can freely download it from here https://www.knowage-suite.com/site/login/?redirect_to=%2Fsite%2Fknowage-download%2F, you just have to register.

— Reply to this email directly, view it on GitHub https://github.com/KnowageLabs/Knowage-Server/issues/576#issuecomment-1152363462, or unsubscribe https://github.com/notifications/unsubscribe-auth/AADIWFCNR2743Y6TDS2WJ2TVOM7MDANCNFSM5YHSYPIA . You are receiving this because you authored the thread.Message ID: @.***>

Redjaw commented 2 years ago

Which demos are you talking about? The ones available in the knowage demo environment? https://demo.knowage-suite.com/knowage

johnfelipe commented 2 years ago

Yes all of it In my local environment, help me with that Today I will upload rest of translations But need to help with demos

El vie, 10 de jun. de 2022, 11:11 a. m., Davide Vernassa < @.***> escribió:

Which demos are you talking about? The ones available in the knowage demo environment? https://demo.knowage-suite.com/knowage

— Reply to this email directly, view it on GitHub https://github.com/KnowageLabs/Knowage-Server/issues/576#issuecomment-1152522281, or unsubscribe https://github.com/notifications/unsubscribe-auth/AADIWFFK3REKTJYJC2XTYT3VONSMVANCNFSM5YHSYPIA . You are receiving this because you authored the thread.Message ID: @.***>

Redjaw commented 2 years ago

I Think you Will need a dump of our metà demo db and you should have an Oracle instance in your local env. Using the installer should be more Quick, those documents are already present there. But If you Need It I Will ask for the demo dump to our devops, It Will be available on monday I Guess.

johnfelipe commented 2 years ago

pls wich version of Oracle? im already have installed server from scratch, but will be a good collab that demo dump Pls tell me version of Oracle for install in my local server

El vie, 10 jun 2022 a las 14:07, Davide Vernassa @.***>) escribió:

I Think you Will need a dump of our metà demo db and you should have an Oracle instance in your local env. Using the installer should be more Quick, those documents are already present there. But If you Need It I Will ask for the demo dump to our devops, It Will be available on monday I Guess.

— Reply to this email directly, view it on GitHub https://github.com/KnowageLabs/Knowage-Server/issues/576#issuecomment-1152653601, or unsubscribe https://github.com/notifications/unsubscribe-auth/AADIWFDV4F7SWVFPHQFRLN3VOOG7TANCNFSM5YHSYPIA . You are receiving this because you authored the thread.Message ID: @.***>

Redjaw commented 2 years ago

I suggest you 12, but use One of the certified ones. Remember to add the JDBC driver as reported here

johnfelipe commented 2 years ago

I suggest you 12, but use One of the certified ones. Remember to add the JDBC driver as reported here

[root@felipeurrego2 sqlpad-oracle]# sqlplus system/oracle@//localhost:1521/xe

SQL*Plus: Release 12.2.0.1.0 Production on Fri Jun 10 18:23:29 2022

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production

SQL>

ready installed oracle 12, like you suggest me, but my question now is how

Remember to add the JDBC driver

johnfelipe commented 2 years ago

Ho dear pls remember dumb of oracle database and method for restore in knowage

Redjaw commented 2 years ago

Hello, at this link you will find the mysql 8 dump of the demo DB. Sorry but we had to switch from oracle for licensing and drivers issues.

Regarding the JDBC Driver you can find it here, you have to put it inside tomcat/lib folder.

Here you will find the encryption to place in your tomcat/conf folder.

Here you can find the server.xml to replace in your project, remember to change the username/password to your database connections.

For any other installation problem please refer to our:

Regards

johnfelipe commented 2 years ago

sorry dear for rookie questions, remember im new in this app, and i have all dockerized: how can restore dump, there is phpmyadmin UI or with command? where is path for tomcat/lib and tomcat/conf folder in docker enviroment? where is path of server.xml for replace?

Redjaw commented 2 years ago

Hello, for the restore I do use DBeaver, but honestly you can use the tool you do prefere. Take the dump and use the restore feature from your tool (is different for each one). In docker the tomcat folder is /opt/knowage/apache-tomcat, you will find the server.xml there too.

Watch out, to make your local changes appear (I see you are not just searching for demo data) remember that you have to create the new war packages at least for the knowage-vue project. To do so get inside the knowage-vue folder on your cloned installation and run mvn clean install. If you do have maven installed you should then see a new knowage-vue.war file. You can replace it in your docker to make it work.

Hope that helps. For docker related issues, please ask in the related repository. You will have more details there.

johnfelipe commented 2 years ago

https://drive.google.com/file/d/1EeEB4v16gSyTUscWfajGO4zLgJdijkxd/view?usp=drivesdk

sorry for rookie questions wich all credentials database?

johnfelipe commented 2 years ago 
DB_HOST=knowagedb
DB_PORT=3306
DB_DB=knowagedb
DB_USER=knowageuser
DB_PASS=knowagepassword
CACHE_DB_HOST=knowagecache
CACHE_DB_PORT=3306
CACHE_DB_DB=knowagecache
CACHE_DB_USER=knowageuser
CACHE_DB_PASS=knowagepassword
HMAC_KEY=abc123
PASSWORD_ENCRYPTION_SECRET=def456

but pls view this video:

https://drive.google.com/file/d/1n_FhlfoOx5B7WU6cnRO3boXQitHvvGor/view?usp=drivesdk

i cant connect

kerny3d commented 2 years ago

Hi @johnfelipe,

I saw your video. The knowagedb main is only available inside a Docker container. See the official documentation:

https://docs.docker.com/config/containers/container-networking/#dns-services

But to make it simple you need to link the port inside the container to a port on your PC. If you used a docker-compose.yml you can use:

version: "3.1"
services:
  ...

  knowagedb:
    image: mariadb:10.3
    environment:
      ...
    ports:
      - 3306:3306
    networks:
      - main
    volumes:
      - "db:/var/lib/mysql"

Where you can see the ports section: in this case the port 3306 (on the left of the colon character) of your PC will be linked to the port 3306 (on the right of the colon character) of your container.

johnfelipe commented 2 years ago

SNAG-1308

im using restore tool

C:\Users\GAMEMAX\AppData\Roaming\DBeaverData\drivers\clients\mysql\win\mysql.exe -u knowageuser --host=192.168.0.18 --port=3306 knowagedb
Task 'MySQL restore' started at Mon Jun 20 09:04:30 COT 2022
ERROR 1273 (HY000) at line 25: Unknown collation: 'utf8mb4_0900_ai_ci'

Task 'MySQL restore' finished at Mon Jun 20 09:04:30 COT 2022
2022-06-20 09:04:30.750 - IO error: Process failed (exit code = 1). See error log.
2022-06-20 09:04:30.751 - java.io.IOException: Process failed (exit code = 1). See error log.
    at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.validateErrorCode(AbstractNativeToolHandler.java:242)
    at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.executeProcess(AbstractNativeToolHandler.java:223)
    at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.doExecute(AbstractNativeToolHandler.java:262)
    at org.jkiss.dbeaver.ext.mysql.tasks.MySQLNativeToolHandler.doExecute(MySQLNativeToolHandler.java:47)
    at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.lambda$0(AbstractNativeToolHandler.java:83)
    at org.jkiss.dbeaver.runtime.RunnableContextDelegate.lambda$0(RunnableContextDelegate.java:39)
    at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)

verbose

C:\Users\GAMEMAX\AppData\Roaming\DBeaverData\drivers\clients\mysql\win\mysql.exe -u knowageuser --host=192.168.0.18 --port=3306 -v --init-command=SET SESSION FOREIGN_KEY_CHECKS=0; knowagedb
Task 'MySQL restore' started at Mon Jun 20 09:07:40 COT 2022
ERROR 1273 (HY000) at line 25: Unknown collation: 'utf8mb4_0900_ai_ci'

--------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */

--------------

--------------

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */

--------------

--------------

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */

--------------

--------------

/*!50503 SET NAMES utf8mb4 */

--------------

--------------

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */

--------------

--------------

/*!40103 SET TIME_ZONE='+00:00' */

--------------

--------------

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */

--------------

--------------

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */

--------------

--------------

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */

--------------

--------------

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */

--------------

--------------

DROP TABLE IF EXISTS `DATABASECHANGELOG`

--------------

--------------

/*!40101 SET @saved_cs_client     = @@character_set_client */

--------------

--------------

/*!50503 SET character_set_client = utf8mb4 */

--------------

--------------

CREATE TABLE `DATABASECHANGELOG` (

  `ID` varchar(255) NOT NULL,

  `AUTHOR` varchar(255) NOT NULL,

  `FILENAME` varchar(255) NOT NULL,

  `DATEEXECUTED` datetime NOT NULL,

  `ORDEREXECUTED` int NOT NULL,

  `EXECTYPE` varchar(10) NOT NULL,

  `MD5SUM` varchar(35) DEFAULT NULL,

  `DESCRIPTION` varchar(255) DEFAULT NULL,

  `COMMENTS` varchar(255) DEFAULT NULL,

  `TAG` varchar(255) DEFAULT NULL,

  `LIQUIBASE` varchar(20) DEFAULT NULL,

  `CONTEXTS` varchar(255) DEFAULT NULL,

  `LABELS` varchar(255) DEFAULT NULL,

  `DEPLOYMENT_ID` varchar(10) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci

--------------

Task 'MySQL restore' finished at Mon Jun 20 09:07:40 COT 2022
2022-06-20 09:07:40.877 - IO error: Process failed (exit code = 1). See error log.
2022-06-20 09:07:40.878 - java.io.IOException: Process failed (exit code = 1). See error log.
    at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.validateErrorCode(AbstractNativeToolHandler.java:242)
    at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.executeProcess(AbstractNativeToolHandler.java:223)
    at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.doExecute(AbstractNativeToolHandler.java:262)
    at org.jkiss.dbeaver.ext.mysql.tasks.MySQLNativeToolHandler.doExecute(MySQLNativeToolHandler.java:47)
    at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.lambda$0(AbstractNativeToolHandler.java:83)
    at org.jkiss.dbeaver.runtime.RunnableContextDelegate.lambda$0(RunnableContextDelegate.java:39)
    at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)
johnfelipe commented 2 years ago

pls help me with my issue

kerny3d commented 2 years ago

Hi @johnfelipe,

have you seen my previous comment?

https://github.com/KnowageLabs/Knowage-Server/issues/576#issuecomment-1160474811

You cannot use knowagedb outside a Docker container.

johnfelipe commented 2 years ago

yes dear, and works. i mean i can access with dbear, but i cant restore dumb

kerny3d commented 2 years ago

With the same error you shown yesterday?

johnfelipe commented 2 years ago

https://github.com/KnowageLabs/Knowage-Server/issues/576#issuecomment-1160491475

kerny3d commented 2 years ago

Ok, open the dump with a text editor like Notepad++, for example.

Replace "utf8mb4_0900_ai_ci" with "utf8mb4_general_ci". Our DB was created in an older version.

johnfelipe commented 2 years ago

this error show with all replacement

C:\Users\GAMEMAX\AppData\Roaming\DBeaverData\drivers\clients\mysql\win\mysql.exe -u knowageuser --host=192.168.0.18 --port=3306 -v knowagedb
Task 'MySQL restore' started at Tue Jun 21 07:47:25 COT 2022
--------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */

--------------

--------------

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */

--------------

--------------

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */

--------------

--------------

/*!50503 SET NAMES utf8mb4 */

--------------

--------------

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */

--------------

--------------

/*!40103 SET TIME_ZONE='+00:00' */

--------------

--------------

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */

--------------

--------------

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */

--------------

--------------

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */

--------------

--------------

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */

--------------

--------------

DROP TABLE IF EXISTS `DATABASECHANGELOG`

--------------

--------------

/*!40101 SET @saved_cs_client     = @@character_set_client */

--------------

--------------

/*!50503 SET character_set_client = utf8mb4 */

--------------

--------------

CREATE TABLE `DATABASECHANGELOG` (

  `ID` varchar(255) NOT NULL,

  `AUTHOR` varchar(255) NOT NULL,

  `FILENAME` varchar(255) NOT NULL,

  `DATEEXECUTED` datetime NOT NULL,

  `ORDEREXECUTED` int NOT NULL,

  `EXECTYPE` varchar(10) NOT NULL,

  `MD5SUM` varchar(35) DEFAULT NULL,

  `DESCRIPTION` varchar(255) DEFAULT NULL,

  `COMMENTS` varchar(255) DEFAULT NULL,

  `TAG` varchar(255) DEFAULT NULL,

  `LIQUIBASE` varchar(20) DEFAULT NULL,

  `CONTEXTS` varchar(255) DEFAULT NULL,

  `LABELS` varchar(255) DEFAULT NULL,

  `DEPLOYMENT_ID` varchar(10) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

--------------

--------------

/*!40101 SET character_set_client = @saved_cs_client */

--------------

--------------

LOCK TABLES `DATABASECHANGELOG` WRITE

--------------

--------------

/*!40000 ALTER TABLE `DATABASECHANGELOG` DISABLE KEYS */

--------------

--------------

/*!40000 ALTER TABLE `DATABASECHANGELOG` ENABLE KEYS */

--------------

--------------

UNLOCK TABLES

--------------

--------------

DROP TABLE IF EXISTS `DATABASECHANGELOGLOCK`

--------------

--------------

/*!40101 SET @saved_cs_client     = @@character_set_client */

--------------

--------------

/*!50503 SET character_set_client = utf8mb4 */

--------------

--------------

CREATE TABLE `DATABASECHANGELOGLOCK` (

  `ID` int NOT NULL,

  `LOCKED` bit(1) NOT NULL,

  `LOCKGRANTED` datetime DEFAULT NULL,

  `LOCKEDBY` varchar(255) DEFAULT NULL,

  PRIMARY KEY (`ID`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

--------------

--------------

/*!40101 SET character_set_client = @saved_cs_client */

--------------

--------------

LOCK TABLES `DATABASECHANGELOGLOCK` WRITE

--------------

--------------

/*!40000 ALTER TABLE `DATABASECHANGELOGLOCK` DISABLE KEYS */

--------------

--------------

INSERT INTO `DATABASECHANGELOGLOCK` VALUES (1,0x00,NULL,NULL)

--------------

--------------

/*!40000 ALTER TABLE `DATABASECHANGELOGLOCK` ENABLE KEYS */

--------------

--------------

UNLOCK TABLES

--------------

--------------

DROP TABLE IF EXISTS `QRTZ_BLOB_TRIGGERS`

--------------

--------------

/*!40101 SET @saved_cs_client     = @@character_set_client */

--------------

--------------

/*!50503 SET character_set_client = utf8mb4 */

--------------

--------------

CREATE TABLE `QRTZ_BLOB_TRIGGERS` (

  `TRIGGER_NAME` varchar(120) COLLATE utf8mb4_general_ci NOT NULL,

  `TRIGGER_GROUP` varchar(120) COLLATE utf8mb4_general_ci NOT NULL,

  `BLOB_DATA` blob,

  `SCHED_NAME` varchar(120) COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'DefaultQuartzScheduler',

  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),

  KEY `TRIGGER_NAME` (`TRIGGER_NAME`,`TRIGGER_GROUP`),

  CONSTRAINT `QRTZ_BLOB_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

-------ERROR 1005 (HY000) at line 85: Can't create table `knowagedb`.`QRTZ_BLOB_TRIGGERS` (errno: 150 "Foreign key constraint is incorrectly formed")

-------

Task 'MySQL restore' finished at Tue Jun 21 07:47:25 COT 2022
2022-06-21 07:47:25.922 - IO error: Process failed (exit code = 1). See error log.
2022-06-21 07:47:25.923 - java.io.IOException: Process failed (exit code = 1). See error log.
    at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.validateErrorCode(AbstractNativeToolHandler.java:242)
    at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.executeProcess(AbstractNativeToolHandler.java:223)
    at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.doExecute(AbstractNativeToolHandler.java:262)
    at org.jkiss.dbeaver.ext.mysql.tasks.MySQLNativeToolHandler.doExecute(MySQLNativeToolHandler.java:47)
    at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.lambda$0(AbstractNativeToolHandler.java:83)
    at org.jkiss.dbeaver.runtime.RunnableContextDelegate.lambda$0(RunnableContextDelegate.java:39)
    at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)
johnfelipe commented 2 years ago

may be if u share a new dump?

johnfelipe commented 2 years ago

dear pls help me for show to clients power of knowage with that demo data

kerny3d commented 2 years ago

Hi,

here you can find the new and fixed DB dump.

I've tested it on both MySQL and MariaDB.

johnfelipe commented 2 years ago

still error with dbeaver 22.1.0

SNAG-0009

how solve this?

kerny3d commented 2 years ago

I see a problem here: image It should be 192.168.0.18:3306 and not 192.168.0.18:3306:3306. You have to fix the hostname in your connection configuration.

johnfelipe commented 2 years ago

SNAG-0010

C:\Users\GAMEMAX\AppData\Roaming\DBeaverData\drivers\clients\mysql\win\mysql.exe -u knowageuser --host=192.168.0.18 --port=3306 -v knowagedb
Task 'MySQL restore' started at Thu Jun 23 08:27:24 COT 2022
--------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */

--------------

--------------

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */

--------------

--------------

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */

--------------

--------------

/*!50503 SET NAMES utf8mb4 */

--------------

--------------

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */

--------------

--------------

/*!40103 SET TIME_ZONE='+00:00' */

--------------

--------------

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */

--------------

--------------

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */

--------------

--------------

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */

--------------

--------------

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */

--------------

--------------

DROP TABLE IF EXISTS `DATABASECHANGELOG`

--------------

--------------

/*!40101 SET @saved_cs_client     = @@character_set_client */

--------------

--------------

/*!50503 SET character_set_client = utf8mb4 */

--------------

--------------

CREATE TABLE `DATABASECHANGELOG` (

  `ID` varchar(255) NOT NULL,

  `AUTHOR` varchar(255) NOT NULL,

  `FILENAME` varchar(255) NOT NULL,

  `DATEEXECUTED` datetime NOT NULL,

  `ORDEREXECUTED` int NOT NULL,

  `EXECTYPE` varchar(10) NOT NULL,

  `MD5SUM` varchar(35) DEFAULT NULL,

  `DESCRIPTION` varchar(255) DEFAULT NULL,

  `COMMENTS` varchar(255) DEFAULT NULL,

  `TAG` varchar(255) DEFAULT NULL,

  `LIQUIBASE` varchar(20) DEFAULT NULL,

  `CONTEXTS` varchar(255) DEFAULT NULL,

  `LABELS` varchar(255) DEFAULT NULL,

  `DEPLOYMENT_ID` varchar(10) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3

--------------

--------------

/*!40101 SET character_set_client = @saved_cs_client */

--------------

--------------

LOCK TABLES `DATABASECHANGELOG` WRITE

--------------

--------------

/*!40000 ALTER TABLE `DATABASECHANGELOG` DISABLE KEYS */

--------------

--------------

INSERT INTO `DATABASECHANGELOG` VALUES ('2022-01-13T00:00:00','mlibanor','db/changelog/db.changelog-master.xml','2022-06-21 16:58:55',1,'EXECUTED','8:ff83278e1468e4a63c6ce22d8e023d04','createTable tableName=SBI_DATA_PREP_PROCESS; createTable tableName=SBI_DATA_PREP_INSTANCE; createIndex indexName=IDX_SBI_DATA_PREP_INSTANCE_1, tableName=SBI_DATA_PREP_INSTANCE; createIndex indexName=IDX_SBI_DATA_PREP_INSTANCE_2, tableName=SBI_DATA...','',NULL,'4.3.5',NULL,NULL,'5823534638'),('2022-05-09T00:00:00','mlibanor','db/changelog/db.changelog-master.xml','2022-06-21 16:58:56',2,'EXECUTED','8:56a7ae45fe860e7c9da9435d739cd332','addColumn tableName=SBI_DATA_PREP_INSTANCE; update tableName=SBI_DATA_PREP_INSTANCE; update tableName=SBI_DATA_PREP_INSTANCE; dropIndex indexName=IDX_SBI_DATA_PREP_INSTANCE_2, tableName=SBI_DATA_PREP_INSTANCE; dropIndex indexName=IDX_SBI_DATA_PREP...','',NULL,'4.3.5',NULL,NULL,'5823534638')

--------------

--------------

/*!40000 ALTER TABLE `DATABASECHANGELOG` ENABLE KEYS */

--------------

--------------

UNLOCK TABLES

--------------

--------------

DROP TABLE IF EXISTS `DATABASECHANGELOGLOCK`

--------------

--------------

/*!40101 SET @saved_cs_client     = @@character_set_client */

--------------

--------------

/*!50503 SET character_set_client = utf8mb4 */

--------------

--------------

CREATE TABLE `DATABASECHANGELOGLOCK` (

  `ID` int NOT NULL,

  `LOCKED` bit(1) NOT NULL,

  `LOCKGRANTED` datetime DEFAULT NULL,

  `LOCKEDBY` varchar(255) DEFAULT NULL,

  PRIMARY KEY (`ID`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3

--------------

--------------

/*!40101 SET character_set_client = @saved_cs_client */

--------------

--------------

LOCK TABLES `DATABASECHANGELOGLOCK` WRITE

--------------

--------------

/*!40000 ALTER TABLE `DATABASECHANGELOGLOCK` DISABLE KEYS */

--------------

--------------

INSERT INTO `DATABASECHANGELOGLOCK` VALUES (1,_binary '\0',NULL,NULL)

--------------

--------------

/*!40000 ALTER TABLE `DATABASECHANGELOGLOCK` ENABLE KEYS */

--------------

--------------

UNLOCK TABLES

--------------

--------------ERROR 1005 (HY000) at line 86: Can't create table `knowagedb`.`QRTZ_BLOB_TRIGGERS` (errno: 150 "Foreign key constraint is incorrectly formed")

DROP TABLE IF EXISTS `QRTZ_BLOB_TRIGGERS`

--------------

--------------

/*!40101 SET @saved_cs_client     = @@character_set_client */

--------------

--------------

/*!50503 SET character_set_client = utf8mb4 */

--------------

--------------

CREATE TABLE `QRTZ_BLOB_TRIGGERS` (

  `TRIGGER_NAME` varchar(120) NOT NULL,

  `TRIGGER_GROUP` varchar(120) NOT NULL,

  `BLOB_DATA` blob,

  `SCHED_NAME` varchar(120) NOT NULL DEFAULT 'DefaultQuartzScheduler',

  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),

  KEY `TRIGGER_NAME` (`TRIGGER_NAME`,`TRIGGER_GROUP`),

  CONSTRAINT `QRTZ_BLOB_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3

--------------

Task 'MySQL restore' finished at Thu Jun 23 08:27:24 COT 2022
2022-06-23 08:27:24.935 - IO error: Process failed (exit code = 1). See error log.
2022-06-23 08:27:24.935 - java.io.IOException: Process failed (exit code = 1). See error log.
    at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.validateErrorCode(AbstractNativeToolHandler.java:242)
    at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.executeProcess(AbstractNativeToolHandler.java:223)
    at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.doExecute(AbstractNativeToolHandler.java:262)
    at org.jkiss.dbeaver.ext.mysql.tasks.MySQLNativeToolHandler.doExecute(MySQLNativeToolHandler.java:47)
    at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.lambda$0(AbstractNativeToolHandler.java:83)
    at org.jkiss.dbeaver.runtime.RunnableContextDelegate.lambda$0(RunnableContextDelegate.java:39)
    at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)

change again engine?

kerny3d commented 2 years ago

Which user are you using in DBeaver?

johnfelipe commented 2 years ago 
192.168.0.18
knowagedb
knowageuser
knowagepassword
johnfelipe commented 2 years ago

any solution dear? or may be with another tool?

johnfelipe commented 2 years ago

i bro, me again, any solution?

kerny3d commented 2 years ago

I'm looking for some solution. I need some time.

johnfelipe commented 2 years ago

I already ready setup oracle Don't worry for licence Because I want to show for my university and change cloudera and begin with a stack with, Cassandra, Hadoop, spark, airflow and metabase and change all streaming with knowage.

El lun, 27 de jun. de 2022, 8:00 a. m., Marco Libanori < @.***> escribió:

I'm looking for some solution. I need some time.

— Reply to this email directly, view it on GitHub https://github.com/KnowageLabs/Knowage-Server/issues/576#issuecomment-1167322389, or unsubscribe https://github.com/notifications/unsubscribe-auth/AADIWFFA6UVAGGLOC5WLAW3VRGQVBANCNFSM5YHSYPIA . You are receiving this because you were mentioned.Message ID: @.***>

johnfelipe commented 2 years ago

Hi dear any progress??

johnfelipe commented 2 years ago

Hi dear, nothing yet?

johnfelipe commented 2 years ago

hi my pal, any advance?

johnfelipe commented 2 years ago

@kerny3d pls tell me if u have solution tnks

kerny3d commented 2 years ago

I need some time to prepare an image of the DB with the demo resources. This is the only solution I could think of.

johnfelipe commented 2 years ago

what kind of error or information private of actual DB image? remember only i need show why this is better of superset or metabase, even cloudera, pls hurry up tnks

johnfelipe commented 2 years ago

Dear what about if you share demos in oracle like first attempt?

johnfelipe commented 2 years ago

any news dear?

johnfelipe commented 2 years ago

Nothing yet?

johnfelipe commented 2 years ago

hi dear, i need quick solution for take knowage like BI software, pls hurry up

johnfelipe commented 2 years ago

Dear, me again, pls tell me how % of completion have, share a demo of demo portal???

johnfelipe commented 2 years ago

Hi pal, nothing yet?