Knowage-Server
Knowage-Server copied to clipboard
KnowageLabs
Can u give me a method for upload test demo, same like online version
im research metabase. superset and others, superset upload demos very complete, can u guide me for upload demos to knowage?
Hi, can you explain us what your goal is? There are different approach we can take depending on what you are willing to do:
- You can use the installer that will create you all the needed stack (DB, tomcat).
- You can build yourself locally the application from the github code or with docker
- You can PR the changes and test them on one of our updated environments
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.
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: @.***>
Which demos are you talking about? The ones available in the knowage demo environment? https://demo.knowage-suite.com/knowage
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: @.***>
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.
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: @.***>
I suggest you 12, but use One of the certified ones. Remember to add the JDBC driver as reported here
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
Ho dear pls remember dumb of oracle database and method for restore in knowage
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
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?
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.
https://drive.google.com/file/d/1EeEB4v16gSyTUscWfajGO4zLgJdijkxd/view?usp=drivesdk
sorry for rookie questions wich all credentials database?
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
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.
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)
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.
yes dear, and works. i mean i can access with dbear, but i cant restore dumb
https://github.com/KnowageLabs/Knowage-Server/issues/576#issuecomment-1160491475
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.
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)
dear pls help me for show to clients power of knowage with that demo data
