knowagelabs / knowage-server-docker Goto Github PK

View Code? Open in Web Editor NEW

64.0 64.0 75.0 359 KB

Docker Image packaging for Knowage Server https://www.knowage-suite.com

License: GNU Affero General Public License v3.0

Shell 63.51% Dockerfile 34.62% Python 0.87% HTML 1.00%

demo docker docker-compose dockerfile knowage virtual-machine

knowage-server-docker's People

Contributors

Stargazers

Watchers

knowage-server-docker's Issues

no demo data in docker

see title!

Enhancement Request : adding jdbc sources via JNDI and volumes

At the moment beside creating a new image/Dockerfile, it is not possible to add a JDBC source at container level via environment variables or volume

** similar issue : **
#11

** Description of limitation : **
I try to use this doc to add a jdbc datasource in server.xml

docker-compose.yml

version: "3.6"
services:
  BI_knowage0:
    container_name: BI_knowage0
    image: knowagelabs/knowage-server-docker:6.3.3
    ports:
    - 8080:8080
    environment:
    - WAIT_MYSQL=true
    - DB_ENV_MYSQL_USER=dbuser
    - DB_ENV_MYSQL_DATABASE=knowagedb
    - DB_ENV_MYSQL_PASSWORD=p6ssword
    - DB_PORT_3306_TCP_ADDR=BI_mysql0
    - DB_PORT_3306_TCP_PORT=3306
    depends_on:
    - BI_mysql0
    volumes:
    - ./config/knowage.xml:/home/knowage/apache-tomcat-8.5.37/conf/server.xml
    - ./config/some-jdbc-package.jar:/home/knowage/apache-tomcat-8.5.37/lib/some-jdbc-package.jar
  BI_mysql0:
    image: mysql:5.6
    container_name: BI_mysql0
    environment:
    - MYSQL_USER=dbuser
    - MYSQL_PASSWORD=p6ssword
    - MYSQL_DATABASE=knowagedb
    - MYSQL_ROOT_PASSWORD=p6ssword

Then I run :

docker-compose up BI_knowage0

This results in infamous sed error:

BI_knowage0      | sed: cannot rename /home/knowage/apache-tomcat-8.5.37/conf/sedwHVP0f: Device or resource busy
BI_knowage0 exited with code 4

** Possible solution : adding feature in entrypoint.sh : **

Current code :
https://github.com/KnowageLabs/Knowage-Server-Docker/blob/master/entrypoint.sh#L42 :

I add a random location whereby any file will be added to server.xml after line 42

sed -i "s|${old_connection}|${new_connection}|" ${KNOWAGE_DIRECTORY}/${APACHE_TOMCAT_PACKAGE}/conf/server.xml
# Adding all content of customJNDIs folder to server.xml
sed -i '/<!-- KNOWAGE -->/r'<(cat ${KNOWAGE_DIRECTORY}/${APACHE_TOMCAT_PACKAGE}/customJNDIs/*) -i -- ${KNOWAGE_DIRECTORY}/${APACHE_TOMCAT_PACKAGE}/conf/server.xml

•• Testing solution works : **

In this case to test this is working, I added the code overwriting the entrypoint.sh and then my jdbc file according to

version: "3.6"
services:
  BI_knowage0:
    container_name: BI_knowage0
    image: knowagelabs/knowage-server-docker:6.3.3
    ports:
    - 8080:8080
    environment:
    - WAIT_MYSQL=true
    - DB_ENV_MYSQL_USER=dbuser
    - DB_ENV_MYSQL_DATABASE=knowagedb
    - DB_ENV_MYSQL_PASSWORD=p6ssword
    - DB_PORT_3306_TCP_ADDR=BI_mysql0
    - DB_PORT_3306_TCP_PORT=3306
    depends_on:
    - BI_mysql0
    volumes:
    - ./config/some-new-jdbc-datasource.xml:/home/knowage/apache-tomcat-8.5.37/customJNDIs/some-new-jdbc-datasource.xml
    - ./config/some-jdbc-package.jar:/home/knowage/apache-tomcat-8.5.37/lib/some-jdbc-package.jar
    - ./config/knowage-entrypoint.sh:/home/knowage/apache-tomcat-8.5.37/bin/entrypoint.sh
  BI_mysql0:
    image: mysql:5.6
    container_name: BI_mysql0
    environment:
    - MYSQL_USER=dbuser
    - MYSQL_PASSWORD=p6ssword
    - MYSQL_DATABASE=knowagedb
    - MYSQL_ROOT_PASSWORD=p6ssword

Then I run :

docker-compose up -d BI_knowage0 && sleep 5 && docker-compose exec BI_knowage0 more /home/knowage/apache-tomcat-8.5.37/conf/server.xml

Knowage starts without issue this shows my jdbc source which I added as JNDI source... I'm just learning through knowage so I am yet to use it (I'm automating as much as possible so will try to see if I can automate the JNDI datasource creation and a report next... I just thought maybe the enhancement request makes sense to at least provide a way to add snippet into server.xml

Knowage server can't connect to MySQL

I have installed Knowage-Server-Docker on Docker Desktop Win 10 P and Maria DB and Knowage-Python are running on their containers I have used last versions of compose file for docker server.
The Knowage server doen't want to run, it starts and after few seconds stops. The message as below.

wait-for-it.sh: waiting 15 seconds for localhost:3306
wait-for-it.sh: timeout occurred after waiting 15 seconds for localhost:3306
MySql is up!
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Where could be the problem?

Use knowage error

I define a customer server.xml config file,based on your base image, I created a custom image myself, but it failed to start after loading,I curl the 127.0.0.1:8080 500 error
My Dockerfile is:
FROM knowagelabs/knowage-server-docker:6.4.5
LABEL maintainer="Ops for zhongyuan [email protected]"
ADD server.xml /home/knowage/apache-tomcat-8.5.37/conf/server.xml

Docker tag for each released version

Please create a new Docker tag for each released version in https://github.com/KnowageLabs/Knowage-Server/releases currently is 6.2.2

Or at least in https://www.knowage-suite.com/site/knowage-download/ currently is 6.2.1

Redirect to knowage-vue doesn't work

I managed to get it to run with docker-compose up -d by making the following changes:

$ git diff
diff --git a/Knowage-Server-Docker/docker-compose.yml b/Knowage-Server-Docker/docker-compose.yml
index 1c0f791..c8916a7 100644
--- a/Knowage-Server-Docker/docker-compose.yml
+++ b/Knowage-Server-Docker/docker-compose.yml
@@ -6,7 +6,7 @@ services:
       - knowagedb
       - knowagecache
     ports:
-      - "8080:8080"
+      - "8081:8080"
     networks:
       - main
     environment:
diff --git a/Knowage-Server-Docker/server.xml b/Knowage-Server-Docker/server.xml
index c0c552f..56559f0 100644
--- a/Knowage-Server-Docker/server.xml
+++ b/Knowage-Server-Docker/server.xml
@@ -28,6 +28,7 @@
                        to authenticate users -->
                <Environment name="resource_path" type="java.lang.String" value="${catalina.home}/resources"/>
                <Environment name="service_url" type="java.lang.String" value="http://localhost:8080/knowage"/>
+               <Environment name="host_url" type="java.lang.String" value="http://my.domain.com:11081"/>
                <Environment name="sso_class" type="java.lang.String" value="it.eng.spagobi.services.common.JWTSsoService"/>
                <Environment description="HMAC key" name="hmacKey" type="java.lang.String" value="__HMAC-key__"/>
                <Environment description="File for security encryption location" name="password_encryption_secret" type="java.lang.String" value="${catalina.home}/conf/passwordEncryptionSecret"/>
@@ -88,7 +89,7 @@
                        sslProtocol="TLS" /> -->

                <!-- Define an AJP 1.3 Connector on port 8009 -->
-               <Connector port="8009" protocol="AJP/1.3" redirectPort="8443"/>
+               <Connector port="8009" protocol="AJP/1.3" redirectPort="8443" secretRequired="false"/>


                <!-- An Engine represents the entry point (within Catalina) that processes

Our external port 11081 is redirected to 8081 on this host.
The secretRequired="false" added to AJP was needed to fix this exception:

30-Apr-2021 05:58:53.721 SEVERE [main] org.apache.catalina.core.StandardService.startInternal Failed to start connector [Connector[AJP/1.3-8009]]
        Caused by: java.lang.IllegalArgumentException: The AJP Connector is configured with secretRequired="true" but the secret attribute is either null or "". This combination is not valid.

This got me to the login screen.
The host_url was an attempt to fix the problem described below, but it didn't do anything.

After I login as biadmin, I get redirected to http://my.domain.com:11081/knowage-vue and get the error:

The origin server did not find a current representation for the target resource or is not willing to disclose that one exists.

How to fix this?

HTTP Status 404 - /knowagebirtreportengine/BirtReportServlet

No engines are available in this Docker container.

root@85623567d1d8:/home/knowage/apache-tomcat-7.0.57/webapps# ls
COPYING  LICENSE.txt  ROOT  docs  examples  host-manager  knowage  manager

EDIT: Only in tag 6.1. Tag develop does have the engines.

Knowage and Keyrock

I try to use Knowage with Keyrock. In order to archieve this I followed this and this.
I extended the entrypoint.sh file as follows:

#!/bin/bash
set -e

INIT_PROP_FILE=${KNOWAGE_DIRECTORY}/${APACHE_TOMCAT_PACKAGE}/webapps/knowage/WEB-INF/classes/it/eng/spagobi/commons/initializers/metadata/config/configs.xml
INIT_PROP_FILE_TEMP=${KNOWAGE_DIRECTORY}/webapps/knowage/WEB-INF/classes/it/eng/spagobi/commons/initializers/metadata/config/configs.xml.temp
SERVER_CONF=${KNOWAGE_DIRECTORY}/conf/server.xml
WEB_XML=${KNOWAGE_DIRECTORY}/webapps/knowage/WEB-INF/web.xml
KNOWAGE_JAR=${KNOWAGE_DIRECTORY}/webapps/knowage/WEB-INF/lib/knowage-utils-7.0.0.jar
UNZIPPED_JAR=knowageJAR
KNOWAGE_CONF=${UNZIPPED_JAR}/it/eng/spagobi/security/OAuth2/configs.properties
INITIALIZER_XML=${KNOWAGE_DIRECTORY}/webapps/knowage/WEB-INF/conf/config/initializers.xml

# usage: file_env VAR [DEFAULT]
#    ie: file_env 'XYZ_DB_PASSWORD' 'example'
# (will allow for "$XYZ_DB_PASSWORD_FILE" to fill in the value of
#  "$XYZ_DB_PASSWORD" from a file, especially for Docker's secrets feature)
file_env() {
	local var="$1"
	local fileVar="${var}_FILE"
	local def="${2:-}"
	if [ "${!var:-}" ] && [ "${!fileVar:-}" ]; then
		echo >&2 "error: both $var and $fileVar are set (but are exclusive)"
		exit 1
	fi
	local val="$def"
	if [ "${!var:-}" ]; then
		val="${!var}"
	elif [ "${!fileVar:-}" ]; then
		val="$(< "${!fileVar}")"
	fi
	export "$var"="$val"
	unset "$fileVar"
}

change_value() {
	touch $INIT_PROP_FILE_TEMP
	local label="$1"
	local value_check="$2"
	tr -d '\n' < $INIT_PROP_FILE | sed 's#/>#/>\n#g' | sed 's/valueCheck=/\x00/g' | sed -E "s#(label=\"${label}\"[^\x00]*\x00)\"[^\"]*#\1\"${value_check}#g" | sed 's/\x00/valueCheck=/g' > $INIT_PROP_FILE_TEMP && mv $INIT_PROP_FILE_TEMP $INIT_PROP_FILE
}

file_env "DB_USER"
file_env "DB_PASS"
file_env "DB_DB"
file_env "DB_HOST"
file_env "DB_PORT"
file_env "HMAC_KEY"
file_env "PUBLIC_ADDRESS"

#Following the tutorial https://knowage.readthedocs.io/en/latest/admin/README/index.html#configuration-with-the-idm-keyrock
if [[ -n "$KEYROCK" ]]; then

	change_value "SPAGOBI_SSO.ACTIVE" "true"
	change_value "SPAGOBI.SECURITY.PORTAL-SECURITY-CLASS.className" "it.eng.spagobi.security.OAuth2SecurityInfoProvider"
	change_value "SPAGOBI.SECURITY.USER-PROFILE-FACTORY-CLASS.className" "it.eng.spagobi.security.OAuth2SecurityServiceSupplier"
	change_value "SPAGOBI_SSO.SECURITY_LOGOUT_URL" "https://keyrock.mydomain.de/auth/external_logout"
	
	sed -i "s/it.eng.spagobi.services.common.FakeSsoService/it.eng.spagobi.services.oauth2.Oauth2SsoService/g" $SERVER_CONF
	sed -i "s/it.eng.spagobi.commons.initializers.metadata.MetadataInitializer/it.eng.spagobi.commons.initializers.metadata.OAuth2MetadataInitializer/g" $INITIALIZER_XML
	sed -i "s/<!-- START OAUTH 2/<!-- START OAUTH 2 -->/g" $WEB_XML
	sed -i "s/END OAUTH 2 -->/<!-- END OAUTH 2 -->/g" $WEB_XML

	
	unzip $KNOWAGE_JAR -d $UNZIPPED_JAR
	sed -i "s/CLIENT_ID.*/CLIENT_ID=${KEYROCK_CLIENT_ID}/g" $KNOWAGE_CONF
	sed -i "s/SECRET.*/SECRET=${KEYROCK_SECRET}/g" $KNOWAGE_CONF
	sed -i "s#AUTHORIZE_URL.*#AUTHORIZE_URL=${KEYROCK_URL}/oauth2/authorize#g" $KNOWAGE_CONF
	sed -i "s#ACCESS_TOKEN_URL.*#ACCESS_TOKEN_URL=${KEYROCK_URL}/oauth2/token#g" $KNOWAGE_CONF
	sed -i "s#USER_INFO_URL.*#USER_INFO_URL=${KEYROCK_URL}/user#g" $KNOWAGE_CONF
	sed -i "s#REDIRECT_URI.*#REDIRECT_URI=${KEYROCK_REDIRECT_URI}#g" $KNOWAGE_CONF
	sed -i "s#TOKEN_PATH.*#TOKEN_PATH=${KEYROCK_TOKEN_PATH}#g" $KNOWAGE_CONF



	sed -i "s#REST_BASE_URL.*#REST_BASE_URL=${KEYROCK_URL}/#g" $KNOWAGE_CONF
	
	sed -i "s#APPLICATION_ID.*#APPLICATION_ID=${KEYROCK_APPLICATION_ID}#g" $KNOWAGE_CONF
	sed -i "s/ADMIN_ID.*/ADMIN_ID=${KEYROCK_ADMIN_ID}/g" $KNOWAGE_CONF
	sed -i "s/ADMIN_EMAIL.*/ADMIN_EMAIL=${KEYROCK_ADMIN_EMAIL}/g" $KNOWAGE_CONF
	sed -i "s/ADMIN_PASSWORD.*/ADMIN_PASSWORD=${KEYROCK_ADMIN_PASSWORD}/g" $KNOWAGE_CONF
	cd $UNZIPPED_JAR; zip -r $KNOWAGE_JAR *
	cd ..
	
fi

if [[ -z "$PUBLIC_ADDRESS" ]]; then
        #get the address of container
        #example : default via 172.17.42.1 dev eth0 172.17.0.0/16 dev eth0 proto kernel scope link src 172.17.0.109
        PUBLIC_ADDRESS=`ip route | grep src | awk '{print $9}'`
fi

#replace the address of container inside server.xml
#sed -i "s|http:\/\/.*:8080|http:\/\/${PUBLIC_ADDRESS}:8080|g" ${KNOWAGE_DIRECTORY}/${APACHE_TOMCAT_PACKAGE}/conf/server.xml
sed -i "s|http:\/\/.*:8080|${PUBLIC_ADDRESS}|g" ${KNOWAGE_DIRECTORY}/${APACHE_TOMCAT_PACKAGE}/conf/server.xml
sed -i "s|http:\/\/.*:8080\/knowage|http:\/\/localhost:8080\/knowage|g" ${KNOWAGE_DIRECTORY}/${APACHE_TOMCAT_PACKAGE}/conf/server.xml
sed -i "s|http:\/\/localhost:8080|http:\/\/${PUBLIC_ADDRESS}:8080|g" ${KNOWAGE_DIRECTORY}/${APACHE_TOMCAT_PACKAGE}/webapps/knowage/WEB-INF/web.xml

#wait for MySql
./wait-for-it.sh ${DB_HOST}:${DB_PORT} -- echo "MySql is up!"

#insert knowage metadata into db if it doesn't exist
result=`mysql -h${DB_HOST} -P${DB_PORT} -u${DB_USER} -p${DB_PASS} ${DB_DB} -e "SHOW TABLES LIKE '%SBI_%';"`
if [ -z "$result" ]; then
	mysql -h${DB_HOST} -P${DB_PORT} -u${DB_USER} -p${DB_PASS} ${DB_DB} --execute="source ${MYSQL_SCRIPT_DIRECTORY}/MySQL_create.sql"
        mysql -h${DB_HOST} -P${DB_PORT} -u${DB_USER} -p${DB_PASS} ${DB_DB} --execute="source ${MYSQL_SCRIPT_DIRECTORY}/MySQL_create_quartz_schema.sql"
fi

#replace in server.xml
old_connection='url="jdbc:mysql://localhost:3306/knowagedb" username="knowageuser" password="knowagepassword"'
new_connection='url="jdbc:mysql://'${DB_HOST}':'${DB_PORT}'/'${DB_DB}'" username="'${DB_USER}'" password="'${DB_PASS}'"'
sed -i "s|${old_connection}|${new_connection}|" ${KNOWAGE_DIRECTORY}/${APACHE_TOMCAT_PACKAGE}/conf/server.xml

#generate random HMAC key
sed -i "s|abc123|${HMAC_KEY}|" ${KNOWAGE_DIRECTORY}/${APACHE_TOMCAT_PACKAGE}/conf/server.xml

exec "$@"

And I had to install zip in the Dockerfile of Knowage.

I checked the files after I started the container
configs.xml:

<CONFIG label="SPAGOBI_SSO.ACTIVE" name="ACTIVE SSO FLAG" description="ACTIVE SSO FLAG" isActive="true" valueCheck="true"  valueType="STRING" category="SECURITY" />
<CONFIG label="SPAGOBI.SECURITY.PORTAL-SECURITY-CLASS.className"  name="Security Info provider" description="Security Info provider" isActive="true" valueCheck="it.eng.spagobi.security.OAuth2SecurityInfoProvider" valueType="STRING" category="SECURITY" />
<CONFIG label="SPAGOBI.SECURITY.USER-PROFILE-FACTORY-CLASS.className" name="Security Service Supplier" description="Security Service Supplier" isActive="true" valueCheck="it.eng.spagobi.security.OAuth2SecurityServiceSupplier" valueType="STRING" category="SECURITY" />
<CONFIG label="SPAGOBI_SSO.SECURITY_LOGOUT_URL" name="SECURITY LOGOUT URL" description="" isActive="true" valueCheck="https://keyrock.mydomain.de" valueType="STRING" category="SECURITY" />

server.xml:
<Environment name="sso_class" type="java.lang.String" value="it.eng.spagobi.services.oauth2.Oauth2SsoService"/>
web.xml:

<!-- START OAUTH 2 -->                                                                                                                                                                                     
        <filter-mapping>
                <filter-name>OAuthFilter</filter-name>
                <url-pattern>/servlet/AdapterHTTP</url-pattern>
        </filter-mapping>
<!-- END OAUTH 2 -->
<!-- START OAUTH 2 -->                                                                                                                                                                                     
        <filter>                                                                                                                                                                                                   
                <filter-name>OAuthFilter</filter-name>                                                                                                                                                             
                <filter-class>it.eng.spagobi.security.OAuth2.OAuth2Filter</filter-class>                                                                                                                           
        </filter>
<!-- END OAUTH 2 -->

configs.properties inside of knowage-utils-7.0.0.jar (in the tutorial its called knowageutils.jar):

# Informations about OAuth2 application
CLIENT_ID=68d6e050-6037-40a5-ba4b-9ed3570b409d
SECRET=5ee23df7-aec1-4913-a32e-994e131b36e3

# OAuth2 urls
AUTHORIZE_URL=https://keyrock.mydomain.de/oauth2/authorize
ACCESS_TOKEN_URL=https://keyrock.mydomain.de/oauth2/token
USER_INFO_URL=https://keyrock.mydomain.de/user
REDIRECT_URI=https://traefik.mydomain.de/knowage/servlet/AdapterHTTP?PAGE=LoginPage
   
# REST API urls
REST_BASE_URL=https://keyrock.mydomain.de/
TOKEN_PATH=v3/auth/tokens
ROLES_PATH = OS-ROLES/roles
#  ORGANIZATIONS_LIST_PATH = users/ADMIN_ID=admin
ORGANIZATION_INFO_PATH = projects/

APPLICATION_ID=78d6e050-6037-40a7-ba1b-9ed4570b408d

# Admin credentials
ADMIN_ID=admin
[email protected]
ADMIN_PASSWORD=1234

PROXY_URL = proxy.eng.it
PROXY_PORT = 3128
PROXY_USER = aldaniel
PROXY_PASSWORD =

docker-compose extract:

keyrock:
    image: fiware/idm:FIWARE_7.8
    restart: always
    container_name: keyrock
    user: "996:995"
    depends_on:
        - keyrock-db
        - authzforce
    expose:
      - "3005"
    environment:
        - IDM_OAUTH_EMPTY_STATE=true #Knowage is not sending a state parameter
        - IDM_DB_HOST=keyrock-db
        - IDM_DB_PASS_FILE=/run/secrets/keyrock_db_password
        - IDM_DB_USER=root
        - IDM_HOST=http://localhost:3005
        - IDM_PORT=3005
        - IDM_HTTPS_ENABLED=false
        - IDM_ADMIN_USER=keyrock
        - [email protected]
        - IDM_ADMIN_PASS=1234
        - IDM_PDP_LEVEL=advanced
        - IDM_AUTHZFORCE_ENABLED=true
        - IDM_AUTHZFORCE_HOST=authzforce
        - IDM_AUTHZFORCE_PORT=8080

    secrets:
        - keyrock_db_password

  knowage:
    image: knowagelabs/knowage-server-docker:7.0
    container_name: knowage 
    expose:
      - "8080"
    environment:
      - DB_USER=knowage
      - DB_PASS_FILE=/run/secrets/knowage_db_password
      - DB_DB=knowage
      - DB_HOST=knowagedb
      - DB_PORT=3306
      - PUBLIC_ADDRESS=https://knowage.mydomain.de
      - HMAC_KEY_FILE=/run/secrets/knowage_hmac_key
      - KEYROCK=true
      - KEYROCK_CLIENT_ID=68d6e050-6037-40a5-ba4b-9ed3570b409d
      - KEYROCK_SECRET=5ee23df7-aec1-4913-a32e-994e131b36e3
      - KEYROCK_URL=https://keyrock.mydomain.de
      - KEYROCK_TOKEN_PATH=v3/auth/tokens
      - KEYROCK_APPLICATION_ID=78d6e050-6037-40a7-ba1b-9ed4570b408d
      - KEYROCK_ADMIN_ID=admin
      - [email protected]
      - KEYROCK_ADMIN_PASSWORD=1234
      - KEYROCK_REDIRECT_URI=https://knowage.mydomain.de/knowage/servlet/AdapterHTTP?PAGE=LoginPage
    secrets:
        - knowage_db_password
        - knowage_hmac_key

If I enter the knowage site I get redirected to Keyrock and can login for the created Knowage application. Then I get redirected to:
https://knowage.mydomain.de/knowage/servlet/AdapterHTTP?PAGE=LoginPage&code=bd3a99c09742741e93b8c86e68302f3d41b441f3 and I get a 500 error.
knowage log:


[localhost-startStop-6] 20 Nov 2019 22:40:08,872 ERROR it.eng.spagobi.commons.SingletonConfigCache.<init>:41 - The table sbi_config is EMPTY
[localhost-startStop-6] 20 Nov 2019 22:40:09,203 ERROR it.eng.spagobi.security.OAuth2.OAuth2Client.getToken:63 - Error while getting access token from IdM REST API: server returned statusCode = 401
[localhost-startStop-6] 20 Nov 2019 22:40:09,203 ERROR it.eng.spagobi.security.OAuth2.OAuth2Client.getToken:66 - Server response is:
{"error":{"message":"Invalid email or password","code":401,"title":"Unauthorized"}}
[localhost-startStop-6] 20 Nov 2019 22:40:09,204 ERROR it.eng.spagobi.commons.initializers.metadata.OAuth2TenantInitializer.init:81 - Error while trying to obtain tenants' informations from OAuth2 provider
it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: Error while trying to obtain tenants' informations from OAuth2 provider
	at it.eng.spagobi.commons.initializers.metadata.OAuth2TenantInitializer.getTenants(OAuth2TenantInitializer.java:210)
	at it.eng.spagobi.commons.initializers.metadata.OAuth2TenantInitializer.init(OAuth2TenantInitializer.java:65)
	at it.eng.spagobi.commons.initializers.metadata.MetadataInitializer.init(MetadataInitializer.java:82)
	at it.eng.spagobi.commons.initializers.metadata.SpagoBIInitializer.init(SpagoBIInitializer.java:91)
	at it.eng.spagobi.commons.initializers.metadata.MetadataInitializer.init(MetadataInitializer.java:66)
	at it.eng.spago.init.InitializerManager.init(InitializerManager.java:79)
	at it.eng.spago.configuration.ConfigServlet.init(ConfigServlet.java:115)
	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1144)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1091)
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:983)
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4998)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5312)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1140)
	at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1875)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: Error while trying to get token from IdM REST API
	at it.eng.spagobi.security.OAuth2.OAuth2Client.getToken(OAuth2Client.java:73)
	at it.eng.spagobi.security.OAuth2.OAuth2Client.getAdminToken(OAuth2Client.java:84)
	at it.eng.spagobi.commons.initializers.metadata.OAuth2TenantInitializer.getTenants(OAuth2TenantInitializer.java:175)
	... 22 more
Caused by: it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: Error while getting access token from IdM REST API: server returned statusCode = 401
	at it.eng.spagobi.security.OAuth2.OAuth2Client.getToken(OAuth2Client.java:68)
	... 24 more
[localhost-startStop-6] 20 Nov 2019 22:40:09,206 ERROR it.eng.spagobi.commons.initializers.metadata.MetadataInitializer.init:87 - An unexpected error occured while initializing metadata
it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: An unexpected error occured while initializing Tenants
	at it.eng.spagobi.commons.initializers.metadata.OAuth2TenantInitializer.init(OAuth2TenantInitializer.java:82)
	at it.eng.spagobi.commons.initializers.metadata.MetadataInitializer.init(MetadataInitializer.java:82)
	at it.eng.spagobi.commons.initializers.metadata.SpagoBIInitializer.init(SpagoBIInitializer.java:91)
	at it.eng.spagobi.commons.initializers.metadata.MetadataInitializer.init(MetadataInitializer.java:66)
	at it.eng.spago.init.InitializerManager.init(InitializerManager.java:79)
	at it.eng.spago.configuration.ConfigServlet.init(ConfigServlet.java:115)
	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1144)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1091)
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:983)
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4998)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5312)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1140)
	at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1875)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: Error while trying to obtain tenants' informations from OAuth2 provider
	at it.eng.spagobi.commons.initializers.metadata.OAuth2TenantInitializer.getTenants(OAuth2TenantInitializer.java:210)
	at it.eng.spagobi.commons.initializers.metadata.OAuth2TenantInitializer.init(OAuth2TenantInitializer.java:65)
	... 21 more
Caused by: it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: Error while trying to get token from IdM REST API
	at it.eng.spagobi.security.OAuth2.OAuth2Client.getToken(OAuth2Client.java:73)
	at it.eng.spagobi.security.OAuth2.OAuth2Client.getAdminToken(OAuth2Client.java:84)
	at it.eng.spagobi.commons.initializers.metadata.OAuth2TenantInitializer.getTenants(OAuth2TenantInitializer.java:175)
	... 22 more
Caused by: it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: Error while getting access token from IdM REST API: server returned statusCode = 401
	at it.eng.spagobi.security.OAuth2.OAuth2Client.getToken(OAuth2Client.java:68)
	... 24 more
[localhost-startStop-6] 20 Nov 2019 22:40:09,283 ERROR it.eng.spagobi.commons.initializers.caching.CachingInitializer.init:59 - Cannot initialize cache
java.lang.Exception: Cannot configure cache: Data source for writing is not defined. Please select one in the data sources definition panel.
	at it.eng.spagobi.tools.dataset.cache.SpagoBICacheConfiguration.getCacheDataSource(SpagoBICacheConfiguration.java:71)
	at it.eng.spagobi.tools.dataset.cache.SpagoBICacheConfiguration.getInstance(SpagoBICacheConfiguration.java:55)
	at it.eng.spagobi.commons.initializers.caching.CachingInitializer.init(CachingInitializer.java:48)
	at it.eng.spago.init.InitializerManager.init(InitializerManager.java:79)
	at it.eng.spago.configuration.ConfigServlet.init(ConfigServlet.java:115)
	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1144)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1091)
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:983)
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4998)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5312)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1140)
	at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1875)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
[localhost-startStop-6] 20 Nov 2019 22:40:09,307 ERROR it.eng.spagobi.analiticalmodel.functionalitytree.dao.LowFunctionalityDAOHibImpl.insertLowFunctionality:720 - The Domain with value_cd=LOW_FUNCT does not exist.
[localhost-startStop-6] 20 Nov 2019 22:40:09,315 ERROR it.eng.spagobi.analiticalmodel.functionalitytree.init.TreeInitializer.initialize:135 - Error while initializing tree structure in tenant DEFAULT_TENANT
it.eng.spago.error.EMFUserError: severity [ERROR] description [Error while inserting the functionality]
	at it.eng.spagobi.analiticalmodel.functionalitytree.dao.LowFunctionalityDAOHibImpl.insertLowFunctionality(LowFunctionalityDAOHibImpl.java:721)
	at it.eng.spagobi.analiticalmodel.functionalitytree.init.TreeInitializer.initialize(TreeInitializer.java:131)
	at it.eng.spagobi.analiticalmodel.functionalitytree.init.TreeInitializer.initialize(TreeInitializer.java:79)
	at it.eng.spagobi.analiticalmodel.functionalitytree.init.TreeInitializer.init(TreeInitializer.java:61)
	at it.eng.spago.init.InitializerManager.init(InitializerManager.java:79)
	at it.eng.spago.configuration.ConfigServlet.init(ConfigServlet.java:115)
	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1144)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1091)
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:983)
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4998)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5312)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1140)
	at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1875)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
[localhost-startStop-6] 20 Nov 2019 22:40:09,315 ERROR it.eng.spagobi.analiticalmodel.functionalitytree.init.TreeInitializer.initialize:82 - Error while initializing tree structure
it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: Error while initializing tree structure in tenant DEFAULT_TENANT
	at it.eng.spagobi.analiticalmodel.functionalitytree.init.TreeInitializer.initialize(TreeInitializer.java:136)
	at it.eng.spagobi.analiticalmodel.functionalitytree.init.TreeInitializer.initialize(TreeInitializer.java:79)
	at it.eng.spagobi.analiticalmodel.functionalitytree.init.TreeInitializer.init(TreeInitializer.java:61)
	at it.eng.spago.init.InitializerManager.init(InitializerManager.java:79)
	at it.eng.spago.configuration.ConfigServlet.init(ConfigServlet.java:115)
	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1144)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1091)
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:983)
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4998)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5312)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1140)
	at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1875)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: it.eng.spago.error.EMFUserError: severity [ERROR] description [Error while inserting the functionality]
	at it.eng.spagobi.analiticalmodel.functionalitytree.dao.LowFunctionalityDAOHibImpl.insertLowFunctionality(LowFunctionalityDAOHibImpl.java:721)
	at it.eng.spagobi.analiticalmodel.functionalitytree.init.TreeInitializer.initialize(TreeInitializer.java:131)
	... 20 more
[localhost-startStop-6] 20 Nov 2019 22:40:09,409 ERROR it.eng.spagobi.security.init.InternalSecurityInitializer.initRoles:339 - An unexpected error occurred while initializieng default roles
java.lang.IllegalArgumentException: id to load is required for loading
	at org.hibernate.event.LoadEvent.<init>(LoadEvent.java:89)
	at org.hibernate.event.LoadEvent.<init>(LoadEvent.java:61)
	at org.hibernate.impl.SessionImpl.load(SessionImpl.java:982)
	at org.hibernate.impl.SessionImpl.load(SessionImpl.java:978)
	at it.eng.spagobi.commons.dao.RoleDAOHibImpl.insertRoleWithSession(RoleDAOHibImpl.java:376)
	at it.eng.spagobi.commons.dao.RoleDAOHibImpl.insertRole(RoleDAOHibImpl.java:345)
	at it.eng.spagobi.security.init.InternalSecurityInitializer.initRoles(InternalSecurityInitializer.java:326)
	at it.eng.spagobi.security.init.InternalSecurityInitializer.init(InternalSecurityInitializer.java:82)
	at it.eng.spagobi.commons.initializers.metadata.SpagoBIInitializer.init(SpagoBIInitializer.java:91)
	at it.eng.spago.init.InitializerManager.init(InitializerManager.java:79)
	at it.eng.spago.configuration.ConfigServlet.init(ConfigServlet.java:115)
	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1144)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1091)
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:983)
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4998)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5312)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1140)
	at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1875)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
[localhost-startStop-6] 20 Nov 2019 22:40:09,515 ERROR it.eng.spagobi.security.init.InternalSecurityInitializer.init:154 - An unexpected error occurred during users' initialization
java.lang.NullPointerException
	at it.eng.spagobi.profiling.bean.SbiExtUserRolesId.hashCode(SbiExtUserRolesId.java:71)
	at it.eng.spagobi.profiling.bean.SbiExtUserRoles.hashCode(SbiExtUserRoles.java:65)
	at java.lang.Object.toString(Object.java:236)
	at java.lang.String.valueOf(String.java:2994)
	at java.lang.StringBuilder.append(StringBuilder.java:131)
	at it.eng.spagobi.profiling.dao.SbiUserDAOHibImpl.updateSbiUserRoles(SbiUserDAOHibImpl.java:296)
	at it.eng.spagobi.security.init.InternalSecurityInitializer.init(InternalSecurityInitializer.java:147)
	at it.eng.spagobi.commons.initializers.metadata.SpagoBIInitializer.init(SpagoBIInitializer.java:91)
	at it.eng.spago.init.InitializerManager.init(InitializerManager.java:79)
	at it.eng.spago.configuration.ConfigServlet.init(ConfigServlet.java:115)
	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1144)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1091)
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:983)
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4998)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5312)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1140)
	at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1875)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
[localhost-startStop-6] 20 Nov 2019 22:40:09,515 ERROR it.eng.spagobi.commons.initializers.metadata.SpagoBIInitializer.init:99 - An unexpected error occured while initializing [InternalSecurity]
it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: An unexpected error occurred during users' initialization
	at it.eng.spagobi.security.init.InternalSecurityInitializer.init(InternalSecurityInitializer.java:155)
	at it.eng.spagobi.commons.initializers.metadata.SpagoBIInitializer.init(SpagoBIInitializer.java:91)
	at it.eng.spago.init.InitializerManager.init(InitializerManager.java:79)
	at it.eng.spago.configuration.ConfigServlet.init(ConfigServlet.java:115)
	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1144)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1091)
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:983)
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4998)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5312)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1140)
	at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1875)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.NullPointerException
	at it.eng.spagobi.profiling.bean.SbiExtUserRolesId.hashCode(SbiExtUserRolesId.java:71)
	at it.eng.spagobi.profiling.bean.SbiExtUserRoles.hashCode(SbiExtUserRoles.java:65)
	at java.lang.Object.toString(Object.java:236)
	at java.lang.String.valueOf(String.java:2994)
	at java.lang.StringBuilder.append(StringBuilder.java:131)
	at it.eng.spagobi.profiling.dao.SbiUserDAOHibImpl.updateSbiUserRoles(SbiUserDAOHibImpl.java:296)
	at it.eng.spagobi.security.init.InternalSecurityInitializer.init(InternalSecurityInitializer.java:147)
	... 19 more
[http-nio-8080-exec-1] 20 Nov 2019 22:40:16,951 ERROR it.eng.spagobi.commons.utilities.ChannelUtilities.getSpagoBIContextName:133 - SPAGOBI.SPAGOBI-MODE.mode IS NULL
[http-nio-8080-exec-5] 20 Nov 2019 22:40:17,598 ERROR it.eng.spagobi.commons.utilities.ChannelUtilities.getSpagoBIContextName:133 - SPAGOBI.SPAGOBI-MODE.mode IS NULL
[http-nio-8080-exec-6] 20 Nov 2019 22:40:17,646 ERROR it.eng.spagobi.commons.utilities.ChannelUtilities.isWebRunning:161 - SPAGOBI.SPAGOBI-MODE.mode IS NULL
[http-nio-8080-exec-6] 20 Nov 2019 22:40:17,649 ERROR it.eng.spagobi.commons.utilities.SpagoBIUtilities.readJndiResource:319 - java.lang.NullPointerException
[http-nio-8080-exec-6] 20 Nov 2019 22:40:17,649 ERROR it.eng.spagobi.services.common.SsoServiceFactory.createProxyService:55 - Error occurred
java.lang.NullPointerException
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:264)
	at it.eng.spagobi.services.common.SsoServiceFactory.createProxyService(SsoServiceFactory.java:52)
	at it.eng.spagobi.commons.filters.ProfileFilter.getUserIdWithSSO(ProfileFilter.java:271)
	at it.eng.spagobi.commons.filters.ProfileFilter.doFilter(ProfileFilter.java:126)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at it.eng.spagobi.security.OAuth2.OAuth2Filter.doFilter(OAuth2Filter.java:96)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at it.eng.spagobi.commons.filters.SpagoBICoreCheckSessionFilter.doFilter(SpagoBICoreCheckSessionFilter.java:94)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at it.eng.spagobi.utilities.filters.EncodingFilter.doFilter(EncodingFilter.java:54)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)
[http-nio-8080-exec-6] 20 Nov 2019 22:40:17,650 ERROR it.eng.spagobi.commons.filters.ProfileFilter.getUserIdWithSSO:275 - Authentication failed
java.lang.NullPointerException
	at it.eng.spagobi.commons.filters.ProfileFilter.getUserIdWithSSO(ProfileFilter.java:272)
	at it.eng.spagobi.commons.filters.ProfileFilter.doFilter(ProfileFilter.java:126)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at it.eng.spagobi.security.OAuth2.OAuth2Filter.doFilter(OAuth2Filter.java:96)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at it.eng.spagobi.commons.filters.SpagoBICoreCheckSessionFilter.doFilter(SpagoBICoreCheckSessionFilter.java:94)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at it.eng.spagobi.utilities.filters.EncodingFilter.doFilter(EncodingFilter.java:54)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)
[http-nio-8080-exec-6] 20 Nov 2019 22:40:17,651 ERROR it.eng.spagobi.commons.filters.ProfileFilter.doFilter:157 - Error while service execution
it.eng.spagobi.commons.filters.ProfileFilter$SilentAuthenticationFailedException
	at it.eng.spagobi.commons.filters.ProfileFilter.getUserIdWithSSO(ProfileFilter.java:276)
	at it.eng.spagobi.commons.filters.ProfileFilter.doFilter(ProfileFilter.java:126)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at it.eng.spagobi.security.OAuth2.OAuth2Filter.doFilter(OAuth2Filter.java:96)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at it.eng.spagobi.commons.filters.SpagoBICoreCheckSessionFilter.doFilter(SpagoBICoreCheckSessionFilter.java:94)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at it.eng.spagobi.utilities.filters.EncodingFilter.doFilter(EncodingFilter.java:54)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)

Can someone tell what I'm doing wrong?

I hope the initial login password can be set when docker startup, what needs to be done

There is a scenario where the initial password biadmin does not meet the requirements of the security department. How do I need to set my own Strong password?

biadmin lang to spanish not works

how solve that?

knowage-docker init too slow, need 9minutes

ENV: Amazon ubuntu20.04 2core 4G 50g HDD 100M

[root@ip-172-31-35-153 ec2-user]# docker logs knowage-server 
wait-for-it.sh: waiting 15 seconds for knowagedb:3306
wait-for-it.sh: knowagedb:3306 is available after 12 seconds
MySql is up!
wait-for-it.sh: waiting 15 seconds for knowagedb:3306
wait-for-it.sh: knowagedb:3306 is available after 0 seconds
MySql is up!
21-May-2021 01:22:46.720 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version name:   Apache Tomcat/8.5.65
21-May-2021 01:22:47.054 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built:          Mar 30 2021 12:28:40 UTC
21-May-2021 01:22:47.054 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version number: 8.5.65.0
21-May-2021 01:22:47.054 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name:               Linux
21-May-2021 01:22:47.054 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version:            4.14.231-173.361.amzn2.x86_64
21-May-2021 01:22:47.054 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture:          amd64
21-May-2021 01:22:47.054 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home:             /usr/local/openjdk-8/jre
21-May-2021 01:22:47.054 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version:           1.8.0_265-b01
21-May-2021 01:22:47.054 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor:            Oracle Corporation
21-May-2021 01:22:47.054 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE:         /home/knowage/apache-tomcat
21-May-2021 01:22:47.054 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME:         /home/knowage/apache-tomcat
21-May-2021 01:22:47.055 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/home/knowage/apache-tomcat/conf/logging.properties
21-May-2021 01:22:47.055 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
21-May-2021 01:22:47.055 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.security.manager
21-May-2021 01:22:47.055 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.security.policy=/home/knowage/apache-tomcat/conf/knowage-default.policy
21-May-2021 01:22:47.055 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:+UnlockExperimentalVMOptions
21-May-2021 01:22:47.055 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:+UseCGroupMemoryLimitForHeap
21-May-2021 01:22:47.055 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
21-May-2021 01:22:47.056 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
21-May-2021 01:22:47.056 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.catalina.security.SecurityListener.UMASK=0027
21-May-2021 01:22:47.056 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs=
21-May-2021 01:22:47.056 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/home/knowage/apache-tomcat
21-May-2021 01:22:47.056 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/home/knowage/apache-tomcat
21-May-2021 01:22:47.056 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/home/knowage/apache-tomcat/temp
21-May-2021 01:22:47.056 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The Apache Tomcat Native library which allows using OpenSSL was not found on the java.library.path: [/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib]
21-May-2021 01:22:48.569 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
21-May-2021 01:22:48.608 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
21-May-2021 01:22:48.657 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-nio-127.0.0.1-8009"]
21-May-2021 01:22:48.668 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
21-May-2021 01:22:48.671 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 5674 ms
21-May-2021 01:22:48.821 WARNING [main] org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory.getObjectInstance Name = knowage Property maxActive is not used in DBCP2, use maxTotal instead. maxTotal default value is 8. You have set value of "20" for "maxActive" property, which is being ignored.
21-May-2021 01:22:48.822 WARNING [main] org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory.getObjectInstance Name = knowage Property maxWait is not used in DBCP2 , use maxWaitMillis instead. maxWaitMillis default value is -1. You have set value of "-1" for "maxWait" property, which is being ignored.
21-May-2021 01:22:48.982 WARNING [main] org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory.getObjectInstance Name = ds_cache Property maxActive is not used in DBCP2, use maxTotal instead. maxTotal default value is 8. You have set value of "20" for "maxActive" property, which is being ignored.
21-May-2021 01:22:48.982 WARNING [main] org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory.getObjectInstance Name = ds_cache Property maxWait is not used in DBCP2 , use maxWaitMillis instead. maxWaitMillis default value is -1. You have set value of "300" for "maxWait" property, which is being ignored.
21-May-2021 01:22:49.064 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
21-May-2021 01:22:49.065 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet engine: [Apache Tomcat/8.5.65]
21-May-2021 01:22:49.093 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/home/knowage/apache-tomcat/webapps/knowage]
21-May-2021 01:23:36.398 INFO [localhost-startStop-1] org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory.getObjectInstance Name = knowageds Ignoring unknown property: value of "" for "description" property
21-May-2021 01:23:36.807 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
21-May-2021 01:23:37.285 INFO [localhost-startStop-1] com.hazelcast.config.ClasspathXmlConfig.null Configuring Hazelcast from 'hazelcast.xml'.
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
21-May-2021 01:24:09.347 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/home/knowage/apache-tomcat/webapps/knowage] has finished in [80,246] ms
21-May-2021 01:24:09.350 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/home/knowage/apache-tomcat/webapps/knowagebirtreportengine]
21-May-2021 01:25:01.423 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
21-May-2021 01:25:07.135 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/home/knowage/apache-tomcat/webapps/knowagebirtreportengine] has finished in [57,784] ms
21-May-2021 01:25:07.136 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/home/knowage/apache-tomcat/webapps/knowagecockpitengine]
21-May-2021 01:25:40.157 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
21-May-2021 01:25:41.279 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/home/knowage/apache-tomcat/webapps/knowagecockpitengine] has finished in [34,142] ms
21-May-2021 01:25:41.279 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/home/knowage/apache-tomcat/webapps/knowagecommonjengine]
21-May-2021 01:26:21.123 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
21-May-2021 01:26:22.512 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/home/knowage/apache-tomcat/webapps/knowagecommonjengine] has finished in [41,233] ms
21-May-2021 01:26:22.513 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/home/knowage/apache-tomcat/webapps/knowagegeoreportengine]
21-May-2021 01:26:59.305 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
21-May-2021 01:27:00.115 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/home/knowage/apache-tomcat/webapps/knowagegeoreportengine] has finished in [37,602] ms
21-May-2021 01:27:00.116 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/home/knowage/apache-tomcat/webapps/knowagejasperreportengine]
21-May-2021 01:27:43.482 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
21-May-2021 01:27:44.119 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/home/knowage/apache-tomcat/webapps/knowagejasperreportengine] has finished in [44,003] ms
21-May-2021 01:27:44.120 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/home/knowage/apache-tomcat/webapps/knowagekpiengine]
21-May-2021 01:28:21.627 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
21-May-2021 01:28:22.461 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/home/knowage/apache-tomcat/webapps/knowagekpiengine] has finished in [38,341] ms
21-May-2021 01:28:22.461 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/home/knowage/apache-tomcat/webapps/knowagemeta]
21-May-2021 01:29:02.338 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
21-May-2021 01:29:02.981 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/home/knowage/apache-tomcat/webapps/knowagemeta] has finished in [40,520] ms
21-May-2021 01:29:02.982 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/home/knowage/apache-tomcat/webapps/knowageqbeengine]
21-May-2021 01:29:46.693 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
21-May-2021 01:29:47.548 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/home/knowage/apache-tomcat/webapps/knowageqbeengine] has finished in [44,561] ms
21-May-2021 01:29:47.548 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/home/knowage/apache-tomcat/webapps/knowagesvgviewerengine]
21-May-2021 01:30:27.176 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
21-May-2021 01:30:27.799 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/home/knowage/apache-tomcat/webapps/knowagesvgviewerengine] has finished in [40,251] ms
21-May-2021 01:30:27.799 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/home/knowage/apache-tomcat/webapps/knowagetalendengine]
21-May-2021 01:30:56.642 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
21-May-2021 01:30:56.735 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/home/knowage/apache-tomcat/webapps/knowagetalendengine] has finished in [28,936] ms
21-May-2021 01:30:56.735 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/home/knowage/apache-tomcat/webapps/knowagewhatifengine]
21-May-2021 01:31:26.737 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
21-May-2021 01:31:27.452 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/home/knowage/apache-tomcat/webapps/knowagewhatifengine] has finished in [30,717] ms
21-May-2021 01:31:27.481 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
21-May-2021 01:31:27.513 SEVERE [main] org.apache.catalina.core.StandardService.startInternal Failed to start connector [Connector[AJP/1.3-8009]]
	org.apache.catalina.LifecycleException: Protocol handler start failed
		at org.apache.catalina.connector.Connector.startInternal(Connector.java:1101)
		at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
		at org.apache.catalina.core.StandardService.startInternal(StandardService.java:440)
		at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
		at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:766)
		at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
		at org.apache.catalina.startup.Catalina.start(Catalina.java:688)
		at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
		at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
		at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
		at java.lang.reflect.Method.invoke(Method.java:498)
		at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:342)
		at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:473)
	Caused by: java.lang.IllegalArgumentException: The AJP Connector is configured with secretRequired="true" but the secret attribute is either null or "". This combination is not valid.
		at org.apache.coyote.ajp.AbstractAjpProtocol.start(AbstractAjpProtocol.java:274)
		at org.apache.catalina.connector.Connector.startInternal(Connector.java:1099)
		... 12 more
21-May-2021 01:31:27.516 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 518844 ms

Could you help me improve this problem, thank you very much.

knowage with Docker Menu disabled

after runnig knowage in docker i can't get the menu where data provider and profile management ..
any help please

user and password for knowage server admin

In container a lock a password and user for mysql but not for knowage server !!

docker build fails to copy knowage-database-scripts-mysql.zip and war files

Hello,

I'm trying to build myself docker image using Knowage-Server-Docker/dockerfile , but it fails, because of missing knowage-database-scripts-mysql.zip here is the error :

Step 44/72 : COPY ${KNOWAGE_DATABASE_SCRIPT}.zip ./
COPY failed: stat /var/lib/docker/tmp/docker-builder043376001/knowage-database-scripts-mysql.zip: no such file or directory

How is the knowage-database-scripts-mysql.zip prepared and retrieved ?, it should be in the repo, but no ?

Most probably the zip is prepared from Knowage-Server repositor directory, knowagedatabasescripts/mysql
so I made manually a zip file and copy it...
But after no war files found :

Step 46/72 : COPY ${KNOWAGE_CORE_ENGINE}.war      ${KNOWAGE_BIRTREPORT_ENGINE}.war      ${KNOWAGE_COCKPIT_ENGINE}.war      ${KNOWAGE_COMMONJ_ENGINE}.war      
${KNOWAGE_GEOREPORT_ENGINE}.war      ${KNOWAGE_JASPERREPORT_ENGINE}.war      ${KNOWAGE_KPI_ENGINE}.war
${KNOWAGE_META_ENGINE}.war      ${KNOWAGE_QBE_ENGINE}.war      ${KNOWAGE_SVGVIEWER_ENGINE}.war      ${KNOWAGE_TALEND_ENGINE}.war      ${KNOWAGE_WHATIF_ENGINE}.war      ${TOMCAT_WEBAPPS}/
COPY failed: stat /var/lib/docker/tmp/docker-builder238311328/knowage.war: no such file or directory

Thanks in advance to give hint on how to prepare files from Knowage-server repository to build the image

Unable to start the latest server version

I cannot docker-compose the latest version. The image building process get stuck on this line

knowage_1    | 10-May-2019 15:05:58.345 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 46345 ms

I tried on two different machines (MacBook Air 2018 and a virtual server Ubuntu 18.04 with 4 cores and 16GB RAM) and remain stuck on the same line.
Tried with different versions of Knowage-Server-Docker (latest, 6.3.3, 6.3.1, 6.2.1)

If I launch docker stats the container seems to run:

> CONTAINER ID        NAME                              CPU %               MEM USAGE / LIMIT    MEM %               NET I/O             BLOCK I/O           PIDS
> 35d683625910        knowageserverdocker_knowage_1     2.75%               1.849GiB / 15.3GiB   12.09%              3.91MB / 3.16MB     0B / 20.5kB         99
> 211a441bd1e3        knowageserverdocker_knowagedb_1   0.11%               490.8MiB / 15.3GiB   3.13%               3.16MB / 3.91MB     0B / 413MB          24

If I get the ip using the command

docker inspect --format '{{ .NetworkSettings.IPAddress }}' knowage

and use the browser to access to http://resulting-ip:8080/knowage
the page cannot be loaded

If I connect to the container using the

docker exec -it <container name> /bin/bash

I get access to the bash and the top command states Java and Tomcat are currently running.

During the last part of the building there seem to be no-errors:

knowage_1    | 10-May-2019 15:28:59.291 INFO [localhost-startStop-2] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/home/knowage/apache-tomcat-8.5.37/webapps/knowagejasperreportengine] has finished in [10,238] ms
knowage_1    | 10-May-2019 15:28:59.292 INFO [localhost-startStop-2] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/home/knowage/apache-tomcat-8.5.37/webapps/knowagecockpitengine]
knowage_1    | 10-May-2019 15:29:03.240 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
knowage_1    | 10-May-2019 15:29:03.795 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/home/knowage/apache-tomcat-8.5.37/webapps/knowagegeoreportengine] has finished in [9,038] ms
knowage_1    | 10-May-2019 15:29:04.177 INFO [localhost-startStop-4] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
knowage_1    | 10-May-2019 15:29:04.828 INFO [localhost-startStop-4] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/home/knowage/apache-tomcat-8.5.37/webapps/knowagedataminingengine] has finished in [9,342] ms
knowage_1    | 10-May-2019 15:29:05.140 INFO [localhost-startStop-3] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
knowage_1    | 10-May-2019 15:29:05.400 INFO [localhost-startStop-2] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
knowage_1    | 10-May-2019 15:29:05.472 INFO [localhost-startStop-3] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/home/knowage/apache-tomcat-8.5.37/webapps/knowagecommonjengine] has finished in [7,168] ms
knowage_1    | 10-May-2019 15:29:05.760 INFO [localhost-startStop-2] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/home/knowage/apache-tomcat-8.5.37/webapps/knowagecockpitengine] has finished in [6,469] ms
knowage_1    | 10-May-2019 15:29:05.766 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
knowage_1    | 10-May-2019 15:29:05.782 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["ajp-nio-8009"]
knowage_1    | 10-May-2019 15:29:05.787 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 41966 ms

Where am I doing something wrong?
Anyone can help me?
Thanks a lot

MySQL DDL File has an error

I could not find the MySQL repo so reporting it here.
MySQL_create.sql file has repeated commas (,,) on line 252 which causes the deployment to fail.

Solution

Remove the commas in MySQL_create.sql in /home/knowage/mysql
login to mysql via cli > drop and recreate db
import SQL manually

Install Konwage 7.0 using docker-compose

does anyone succeed to install knowage server 7.0 using docker compose please ?

here is my docker-compose file

`version: "3.1"
services:
knowage:
image: knowagelabs/knowage-server-docker:7.0
depends_on:
- knowagedb
ports:
- "8080:8080"
networks:
- main
environment:
- WAIT_MYSQL=true
- DB_USER=knowageuser
- DB_PASS=knowagepassword
- DB_DB=knowagedb
- DB_HOST=localhost
- DB_PORT=3306
- HMAC_KEY=abc123
- PUBLIC_ADDRESS=localhost

knowagedb:
image: mysql:5.7
environment:
- MYSQL_USER=rabeb
- MYSQL_PASSWORD=rabeb
- MYSQL_DATABASE=noor_it
- MYSQL_ROOT_PASSWORD=
networks:
- main
volumes:
- "db:/var/lib/mysql"

volumes:
db:

networks:
main:`

can anyone help me please

Use version6.4.5 can't run

I use docker-composer run the image version 6.4.5,but the knowage can't working,here is my dockercompose and log info

infomation:
ait-for-it.sh: waiting 15 seconds for knowagedb:3306
wait-for-it.sh: knowagedb:3306 is available after 0 seconds
MySql is up!
11-Jan-2020 10:35:01.068 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version:        Apache Tomcat/8.5.37
11-Jan-2020 10:35:01.089 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built:          Dec 12 2018 12:07:02 UTC
11-Jan-2020 10:35:01.090 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number:         8.5.37.0
11-Jan-2020 10:35:01.090 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name:               Linux
11-Jan-2020 10:35:01.090 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version:            3.10.0-693.2.2.el7.x86_64
11-Jan-2020 10:35:01.090 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture:          amd64
11-Jan-2020 10:35:01.090 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home:             /usr/local/openjdk-8/jre
11-Jan-2020 10:35:01.090 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version:           1.8.0_232-b09
11-Jan-2020 10:35:01.090 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor:            Oracle Corporation
11-Jan-2020 10:35:01.090 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE:         /home/knowage/apache-tomcat-8.5.37
11-Jan-2020 10:35:01.090 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME:         /home/knowage/apache-tomcat-8.5.37
11-Jan-2020 10:35:01.091 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/home/knowage/apache-tomcat-8.5.37/conf/logging.properties
11-Jan-2020 10:35:01.091 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
11-Jan-2020 10:35:01.091 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
11-Jan-2020 10:35:01.091 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
11-Jan-2020 10:35:01.091 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.catalina.security.SecurityListener.UMASK=0027
11-Jan-2020 10:35:01.091 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs=
11-Jan-2020 10:35:01.091 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/home/knowage/apache-tomcat-8.5.37
11-Jan-2020 10:35:01.091 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/home/knowage/apache-tomcat-8.5.37
11-Jan-2020 10:35:01.091 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/home/knowage/apache-tomcat-8.5.37/temp
11-Jan-2020 10:35:01.091 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: [/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib]
11-Jan-2020 10:35:01.340 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
11-Jan-2020 10:35:01.369 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
11-Jan-2020 10:35:01.449 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-nio-8009"]
11-Jan-2020 10:35:01.451 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
11-Jan-2020 10:35:01.467 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 1396 ms
11-Jan-2020 10:35:01.529 WARNING [main] org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory.getObjectInstance Name = knowage Property maxActive is not used in DBCP2, use maxTotal instead. maxTotal default value is 8. You have set value of "20" for "maxActive" property, which is being ignored.
11-Jan-2020 10:35:01.529 WARNING [main] org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory.getObjectInstance Name = knowage Property maxWait is not used in DBCP2 , use maxWaitMillis instead. maxWaitMillis default value is -1. You have set value of "-1" for "maxWait" property, which is being ignored.
11-Jan-2020 10:35:01.669 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
11-Jan-2020 10:35:01.670 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.37
11-Jan-2020 10:35:01.764 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/home/knowage/apache-tomcat-8.5.37/webapps/docs]
11-Jan-2020 10:35:02.900 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
11-Jan-2020 10:35:03.050 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/home/knowage/apache-tomcat-8.5.37/webapps/docs] has finished in [1,284] ms
11-Jan-2020 10:35:03.050 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/home/knowage/apache-tomcat-8.5.37/webapps/examples]
11-Jan-2020 10:35:03.836 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
11-Jan-2020 10:35:03.921 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/home/knowage/apache-tomcat-8.5.37/webapps/examples] has finished in [871] ms
11-Jan-2020 10:35:03.921 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/home/knowage/apache-tomcat-8.5.37/webapps/ROOT]
11-Jan-2020 10:35:04.202 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
11-Jan-2020 10:35:04.204 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/home/knowage/apache-tomcat-8.5.37/webapps/ROOT] has finished in [283] ms
11-Jan-2020 10:35:04.204 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/home/knowage/apache-tomcat-8.5.37/webapps/manager]
11-Jan-2020 10:35:04.536 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
11-Jan-2020 10:35:04.546 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/home/knowage/apache-tomcat-8.5.37/webapps/manager] has finished in [341] ms
11-Jan-2020 10:35:04.546 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/home/knowage/apache-tomcat-8.5.37/webapps/host-manager]
11-Jan-2020 10:35:04.938 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
11-Jan-2020 10:35:04.940 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/home/knowage/apache-tomcat-8.5.37/webapps/host-manager] has finished in [393] ms
11-Jan-2020 10:35:04.945 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/home/knowage/apache-tomcat-8.5.37/webapps/knowage]
11-Jan-2020 10:35:19.130 INFO [localhost-startStop-1] org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory.getObjectInstance Name = knowageds Ignoring unknown property: value of "" for "description" property
11-Jan-2020 10:35:19.541 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
11-Jan-2020 10:35:19.930 INFO [localhost-startStop-1] com.hazelcast.config.ClasspathXmlConfig.null Configuring Hazelcast from 'hazelcast.xml'.
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
11-Jan-2020 10:35:48.178 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/home/knowage/apache-tomcat-8.5.37/webapps/knowage] has finished in [43,233] ms
11-Jan-2020 10:35:48.178 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/home/knowage/apache-tomcat-8.5.37/webapps/knowagedataminingengine]
wait-for-it.sh: waiting 15 seconds for knowagedb:3306
wait-for-it.sh: knowagedb:3306 is available after 0 seconds
MySql is up!
11-Jan-2020 10:41:00.485 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version:        Apache Tomcat/8.5.37
11-Jan-2020 10:41:00.525 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built:          Dec 12 2018 12:07:02 UTC
11-Jan-2020 10:41:00.525 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number:         8.5.37.0
11-Jan-2020 10:41:00.525 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name:               Linux
11-Jan-2020 10:41:00.525 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version:            3.10.0-693.2.2.el7.x86_64
11-Jan-2020 10:41:00.525 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture:          amd64
11-Jan-2020 10:41:00.525 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home:             /usr/local/openjdk-8/jre
11-Jan-2020 10:41:00.525 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version:           1.8.0_232-b09
11-Jan-2020 10:41:00.525 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor:            Oracle Corporation
11-Jan-2020 10:41:00.525 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE:         /home/knowage/apache-tomcat-8.5.37
11-Jan-2020 10:41:00.526 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME:         /home/knowage/apache-tomcat-8.5.37
11-Jan-2020 10:41:00.526 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/home/knowage/apache-tomcat-8.5.37/conf/logging.properties
11-Jan-2020 10:41:00.526 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
11-Jan-2020 10:41:00.526 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
11-Jan-2020 10:41:00.526 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
11-Jan-2020 10:41:00.526 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.catalina.security.SecurityListener.UMASK=0027
11-Jan-2020 10:41:00.526 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs=
11-Jan-2020 10:41:00.526 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/home/knowage/apache-tomcat-8.5.37
11-Jan-2020 10:41:00.526 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/home/knowage/apache-tomcat-8.5.37
11-Jan-2020 10:41:00.527 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/home/knowage/apache-tomcat-8.5.37/temp
11-Jan-2020 10:41:00.527 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: [/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib]
11-Jan-2020 10:41:00.789 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
11-Jan-2020 10:41:00.816 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
11-Jan-2020 10:41:00.862 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-nio-8009"]
11-Jan-2020 10:41:00.864 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
11-Jan-2020 10:41:00.867 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 1474 ms
11-Jan-2020 10:41:00.891 WARNING [main] org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory.getObjectInstance Name = knowage Property maxActive is not used in DBCP2, use maxTotal instead. maxTotal default value is 8. You have set value of "20" for "maxActive" property, which is being ignored.
11-Jan-2020 10:41:00.891 WARNING [main] org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory.getObjectInstance Name = knowage Property maxWait is not used in DBCP2 , use maxWaitMillis instead. maxWaitMillis default value is -1. You have set value of "-1" for "maxWait" property, which is being ignored.
11-Jan-2020 10:41:01.018 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
11-Jan-2020 10:41:01.018 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.37
11-Jan-2020 10:41:01.082 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/home/knowage/apache-tomcat-8.5.37/webapps/docs]
11-Jan-2020 10:41:02.147 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
11-Jan-2020 10:41:02.293 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/home/knowage/apache-tomcat-8.5.37/webapps/docs] has finished in [1,210] ms
11-Jan-2020 10:41:02.293 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/home/knowage/apache-tomcat-8.5.37/webapps/examples]
11-Jan-2020 10:41:03.360 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
11-Jan-2020 10:41:03.488 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/home/knowage/apache-tomcat-8.5.37/webapps/examples] has finished in [1,195] ms
11-Jan-2020 10:41:03.489 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/home/knowage/apache-tomcat-8.5.37/webapps/ROOT]
11-Jan-2020 10:41:03.756 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
11-Jan-2020 10:41:03.762 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/home/knowage/apache-tomcat-8.5.37/webapps/ROOT] has finished in [274] ms
11-Jan-2020 10:41:03.762 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/home/knowage/apache-tomcat-8.5.37/webapps/manager]
11-Jan-2020 10:41:04.079 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
11-Jan-2020 10:41:04.096 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/home/knowage/apache-tomcat-8.5.37/webapps/manager] has finished in [334] ms
11-Jan-2020 10:41:04.097 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/home/knowage/apache-tomcat-8.5.37/webapps/host-manager]
11-Jan-2020 10:41:04.366 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
11-Jan-2020 10:41:04.376 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/home/knowage/apache-tomcat-8.5.37/webapps/host-manager] has finished in [279] ms
11-Jan-2020 10:41:04.376 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/home/knowage/apache-tomcat-8.5.37/webapps/knowage]
11-Jan-2020 10:41:22.046 INFO [localhost-startStop-1] org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory.getObjectInstance Name = knowageds Ignoring unknown property: value of "" for "description" property
11-Jan-2020 10:41:22.374 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
11-Jan-2020 10:41:22.922 INFO [localhost-startStop-1] com.hazelcast.config.ClasspathXmlConfig.null Configuring Hazelcast from 'hazelcast.xml'.
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details

and dockercompose is:

version: "3.1"
services:
  knowage:
    image: knowagelabs/knowage-server-docker:6.4.5
    depends_on:
      - knowagedb
    ports:
      - "8080:8080"
    networks:
      - main
    environment:
      - DB_USER=knowage
      - DB_PASS=123456
      - DB_DB=knowage
      - DB_HOST=knowagedb
      - DB_PORT=3306
      - HMAC_KEY=abc123
      - PUBLIC_ADDRESS=localhost
 
  knowagedb:
    image: mysql:5.7
    environment:
      - MYSQL_USER=knowage
      - MYSQL_PASSWORD=123456
      - MYSQL_DATABASE=knowage
      - MYSQL_ROOT_PASSWORD=123456
    networks:
      - main
    volumes:
      - "db:/var/lib/mysql"

volumes:
  db:

networks:
  main:

Sample Knowage docker-compose.yml File?

Hello All,
I cannot seem to be able to startup the Knowage docker image.
The documentation seems to not have enough details to start it up or is it my problem.
Do anyone have a working docker-compose.yml file that I can use?
Thanks.

jar not loaded offending class

Related to the other issue for the Windows installer I am also getting this log (just marked as INFO):

INFO: validateJarFile(C:\Program Files\Knowage\Knowage-Server-CE\webapps\knowagemeta\WEB-INF\lib\jsp-api-2.1.jar) - jar not loaded. See Servlet Spec 3.0, section 10.7.2. Offending class: javax/el/Expression.class

Everything works though.

knowage and keyrock

Hey,
knowage and keyrock are not working for me, because knowage is not sending a state variable.

As mentioned here I set the redirect URL to https://knowage.mydomain/knowage/servlet/AdapterHTTP?PAGE=LoginPage

In my browser I go to https://knowage.mydomain/knowage and get redirected to
https://keyrock.mydomain.de/oauth2/authorize?response_type=code&client_id=68d6e050-6037-40a7-ba1b-9ed4570b409d&redirect_uri=https%3A%2F%2Fknowage.mydomain%2Fknowage%2Fservlet%2FAdapterHTTP%3FPAGE%3DLoginPage

After authorizing knowage to read my public information from keyrock, keyrock shows me an error:

OAuth2 request has failed!
error - Missing parameter: `state`

I'm using:
knowagelabs/knowage-server-docker:7.0
fiware/idm:FIWARE_7.8

Extract from configs.properties:

AUTHORIZE_URL=https://keyrock.mydomain.de/oauth2/authorize
ACCES_TOKEN_URL=https://keyrock.mydomain/oauth2/token
USER_INFO_URL=https://keyorck.mydomain/user
REDIREKT_URI=https://knowage.mydomain/knowage/servlet/AdapterHTTP?PAGE=LoginPage
REST_BASE_URL=https://keyrock.mydomain.de

500 internal server error

See the log file
https://gist.github.com/kunthar/2b8f69475ec93521e497d84960e80bf3

from tig:
version is >> 2018-05-12 17:51 Alessandro o Update develop version to 6.2.0-RC

ERROR: manifest for knowagelabs/knowage-server-docker:7.2 not found: manifest unknown: manifest unknown

#docker compose up
Creating network "knowage-server-docker_main" with the default driver
Creating volume "knowage-server-docker_db" with default driver
Pulling knowagedb (mariadb:10.3)...
10.3: Pulling from library/mariadb
d72e567cc804: Pull complete
0f3630e5ff08: Pull complete
b6a83d81d1f4: Pull complete
4bf2111ecf0e: Pull complete
9572d64978a0: Pull complete
bcc9953bffb3: Pull complete
de429570dda5: Pull complete
3652bc6ea9f9: Pull complete
6e4bf87041c8: Pull complete
d19e8769b9aa: Pull complete
7a8060bddcd6: Pull complete
ef5d7c679358: Pull complete
c1220fea18c8: Pull complete
Digest: sha256:5adbf9e5943d260914a4821c91fae0e0287d24fdb21b8c8ee7e6529a81d0b9b2
Status: Downloaded newer image for mariadb:10.3
Pulling knowage (knowagelabs/knowage-server-docker:7.2)...
ERROR: manifest for knowagelabs/knowage-server-docker:7.2 not found: manifest unknown: manifest unknown

knowage 7.3 with docker do not start

Hi
I just installed knowage with docker:

$ docker-compose up -d
WARNING: The HMAC_KEY variable is not set. Defaulting to a blank string.
WARNING: The PASSWORD_ENCRYPTION_SECRET variable is not set. Defaulting to a blank string.
Starting knowage-server-docker_knowager_1 ... done
Starting knowage-server-docker_knowagepython_1 ... done
Starting knowage-server-docker_knowagedb_1 ... done
Starting knowage-server-docker_knowage_1 ... done

But only the mariadb container remains:

$ docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
f2a0f7e1ff04 mariadb:10.3 "docker-entrypoint.s…" 20 minutes ago Up 9 minutes 3306/tcp knowage-server-docker_knowagedb_1

The other 3 containers do not start:

$ docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
1e266537d5cd knowagelabs/knowage-server-docker:7.3.0-SNAPSHOT "./entrypoint.sh ./a…" 21 minutes ago Exited (255) 10 minutes ago 1e266537d5cd_knowage-server-docker_knowage_1
16d6b602287c knowagelabs/knowage-python-docker:7.2 "./entrypoint.sh gun…" 21 minutes ago Exited (255) 10 minutes ago knowage-server-docker_knowagepython_1
f2a0f7e1ff04 mariadb:10.3 "docker-entrypoint.s…" 21 minutes ago Up 10 minutes 3306/tcp knowage-server-docker_knowagedb_1
f12a11c22d68 knowagelabs/knowage-r-docker:7.2 "./entrypoint.sh r k…" 21 minutes ago Exited (255) 10 minutes ago knowage-server-docker_knowager_1

I have not modified any settings.
Which may be due?

Regards

knowagej 7.4.x start error?

centos 7.x:

I tried to use all versions of 7.4.x with this error.

I ran it in the compose file.

Now I think there's something wrong with the mirror image.

I don't know how to deal with it. I am looking forward to your help. Thank you very much.

Docker image _manifest unknown_ error

docker-compose up command fails:

$ docker-compose up
Pulling knowage (knowagelabs/knowage-server-docker:7.2)...
ERROR: manifest for knowagelabs/knowage-server-docker:7.2 not found: manifest unknown: manifest unknown

Missing foo-commonj download

Trying to build the Docker image for 6.1.1 yields an issue where the foo-commonj download specified in the Dockerfile cannot be downloaded. It appears as though the site for downloading that library has gone down/disappeared.

Step 72/81 : RUN wget "${LIB_MYFOO_COMMONJ_URL}" &&     unzip ${LIB_MYFOO_COMMONJ_PACKAGE}.zip &&       rm ${LIB_MYFOO_COMMONJ_PACKAGE}.zip &&  cp ${LIB_MYFOO_COMMONJ_PACKAGE}/lib/${LIB_MYFOO_COMMONJ_PACKAGE}.jar . &&  rm -r ${LIB_MYFOO_COMMONJ_PACKAGE}
 ---> Running in cdf4a216e0a0
--2018-06-04 16:40:48--  http://commonj.myfoo.de/bin/foo-commonj-1.1.0.zip
Connecting to 192.168.10.15:8080... connected.
Proxy request sent, awaiting response... 503 Service Unavailable
2018-06-04 16:40:48 ERROR 503: Service Unavailable.

Is there an alternative location to download the library, or potential to replace the library with something else upstream?

support the Chinese

I hope knowage can support the Chinese,Because so many people in China want to use it。After all, this is a very good BI analysis tool. I hope it can be widely used in other countries so that more and more people can use it.

How can update changes in my docker local instance?

For example languages and other minor change in my local instance

Knowage Execution Python Function error

Dear Alessandro

I have a working instance of a docker of knowage (image: knowagelabs/knowage-server-docker:develop) and when I try to execute a simple Function defined with phyton I get the following error at tomcat logs

EVERE: Servlet.service() for servlet [it.eng.spagobi.rest.application.JAXRSApplication] in context with path [/knowagedataminingengine] threw exception
org.jboss.resteasy.spi.UnhandledException: java.lang.UnsatisfiedLinkError: Can't load library: /home/spagobi/PythonJpy/jpy/build/lib.linux-x86_64-3.4/jpy.cpython-34m.so

In folder /home does not exist the spagobi folder, in folder home exists the folder knowage how to configure python properly?

If I execute a function defined in R I get the following error at internet browser

java.lang.NullPointerException
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
java.lang.Thread.run(Thread.java:745)

Maybe I need download another different docker image

Many thanks in advance for your support

BR
Nacho

java.lang.OutOfMemoryError

Steps to reproduce: docker-compose up

Logs are attached.

logs.txt

�[36mknowage_1 |�[0m Oct 01, 2018 2:53:30 PM org.apache.catalina.startup.HostConfig deployDirectories �[36mknowage_1 |�[0m SEVERE: Error waiting for multi-thread deployment of directories to complete �[36mknowage_1 |�[0m java.util.concurrent.ExecutionException: java.lang.OutOfMemoryError: GC overhead limit exceeded �[36mknowage_1 |�[0m at java.util.concurrent.FutureTask.report(FutureTask.java:122) �[36mknowage_1 |�[0m at java.util.concurrent.FutureTask.get(FutureTask.java:192) �[36mknowage_1 |�[0m at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1148) �[36mknowage_1 |�[0m at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490) �[36mknowage_1 |�[0m at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1611) �[36mknowage_1 |�[0m at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:330) �[36mknowage_1 |�[0m at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117) �[36mknowage_1 |�[0m at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:90) �[36mknowage_1 |�[0m at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:402) �[36mknowage_1 |�[0m at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:347) �[36mknowage_1 |�[0m at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:1140) �[36mknowage_1 |�[0m at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:816) �[36mknowage_1 |�[0m at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) �[36mknowage_1 |�[0m at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1575) �[36mknowage_1 |�[0m at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1565) �[36mknowage_1 |�[0m at java.util.concurrent.FutureTask.run(FutureTask.java:266) �[36mknowage_1 |�[0m at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) �[36mknowage_1 |�[0m at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) �[36mknowage_1 |�[0m at java.lang.Thread.run(Thread.java:745)

OCB NGSIv2 - subscriptions don't work

Hi,
after the resolved issue with cockpit #5 I successed to create some graphs with a REST DataSet provided by Orion Context Broker.
Unfortunatly it seems that subscriptions doesn't work. The docs say that if I add a REST Dataset with NGSI Knowage performs a subscription to Orion Context Broker.

NGSIv2 checkbox is specific for NGSIv2 REST calls: it permits to subcribe to Context Element notifications from Orion Context Broker and to omit some of the REST fields (since the JSON format from NGSI specifications is fixed).

With the subscription the cockpit should update itself automatically when knowage detects an update to the dataset. But this doesn't happen.

If i check Orion subscriptions with

curl -X GET http://<orion ip>/v2/subscriptions

returns an empty array... so my questions are:
Is the subscription made automatically from knowage? (If the case something is wrong)
Or I miss something about how to do the subscriptions to OCB from Knowage ?

EDIT:
the dataset has idPattern in query:
http://<orion ip>/v2/entities/?idPattern=^Item[1-5]
and I flag NGSI checkbox as the docs say

EDIT2
I checked inside the container and values in web.xml seems correct
<init-param> <param-name>notifyUrl</param-name> <param-value>http://<knowage_ip>:8080/knowage/datasetNotifier</param-value> </init-param>

Knowage Dataset Python Error 401 (Linux VM)

Hi,

I am currently using the Knowage Docker Server on a linux VM and I would like to create a Python dataset but I am struggling to make it work.

Following the documentation, I modify the python variable of category PYTHON_CONFIGURATION:
python.default.environment.url, http://knowagepython:5000

The REST methode work (code 200).
I can see the Python libraries.
I have authorize Edit Python/R Scripts in configuration.

When trying to preview the python dataset I get the following : The response status is not ok: status=401, response=Unauthorized
[2021-12-09 09:30:53 +0000] [18] [DEBUG] GET /dataset/libraries
172.24.0.7 - - [09/Dec/2021:09:30:53 +0000] "GET /dataset/libraries HTTP/1.1" 200 1339 "-" "Jakarta Commons-HttpClient/3.0.1"

Here is my docker-compose file :

version: "3.1"
services:
knowage:
image: knowagelabs/knowage-server-docker:8.0.4
depends_on:
- knowagedb
- knowagecache
- hazelcast
ports:
- "8080:8080"
networks:
- main
environment:
- DB_HOST=$DB_HOST
- DB_PORT=$DB_PORT
- DB_DB=$DB_DB
- DB_USER=$DB_USER
- DB_PASS=$DB_PASS

  - CACHE_DB_HOST=$CACHE_DB_HOST
  - CACHE_DB_PORT=$CACHE_DB_PORT
  - CACHE_DB_DB=$CACHE_DB_DB
  - CACHE_DB_USER=$CACHE_DB_USER
  - CACHE_DB_PASS=$CACHE_DB_PASS

  - HMAC_KEY=$HMAC_KEY
  - PASSWORD_ENCRYPTION_SECRET=$PASSWORD_ENCRYPTION_SECRET
  - PUBLIC_ADDRESS=knowage

  - HAZELCAST_HOSTS=hazelcast
  - HAZELCAST_PORT=5701
volumes:
  - ./resources:/home/knowage/apache-tomcat/resources

hazelcast:
image: hazelcast/hazelcast:3.6.5
networks:
- main
environment:
- JAVA_OPTS=-Dhazelcast.local.publicAddress=hazelcast -Dhazelcast.config=/opt/hazelcast/hazelcast.xml
volumes:
- ./hazelcast-server.xml:/opt/hazelcast/hazelcast.xml

knowagepython:
image: knowagelabs/knowage-python-docker:8.0.4
environment:
- HMAC_KEY=$HMAC_KEY
- KNOWAGE_PUBLIC_ADDRESS=knowage
- PUBLIC_ADDRESS=knowagepython
networks:
- main
ports:
- "5000:5000"

knowager:
image: knowagelabs/knowage-r-docker:8.0.4
environment:
- HMAC_KEY=$HMAC_KEY
networks:
- main

knowagedb:
image: mariadb:10.3
environment:
- MYSQL_USER=$DB_USER
- MYSQL_PASSWORD=$DB_PASS
- MYSQL_DATABASE=$DB_DB
- MYSQL_RANDOM_ROOT_PASSWORD=yes
networks:
- main
volumes:
- "db:/var/lib/mysql"

knowagecache:
image: mariadb:10.3
environment:
- MYSQL_USER=$CACHE_DB_USER
- MYSQL_PASSWORD=$CACHE_DB_PASS
- MYSQL_DATABASE=$CACHE_DB_DB
- MYSQL_RANDOM_ROOT_PASSWORD=yes
networks:
- main
volumes:
- "cache:/var/lib/mysql"

volumes:
db:
cache:

networks:
main:

Security vulnerabilities from AWS

We use KnowageLabs/Knowage-Server-Docker, pubish konwage project on AWS.

url:https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2020-1938

Tomcat version is v8.5.37, please upgrade to Apache Tomcat 9.0.31、8.5.51.

create cockpit result in a path error

I'm using the 6.1.1 image:

knowagelabs/knowage-server-docker:6.1.1

and I was following this document:
https://knowage.readthedocs.io/en/latest/user/NGSI/README/index.html#document-definition

I successfull added a Dataset REST with Orion Context Broker but when I try to create a Cockpit with an user in Analysis section I ran into an error caused by a resource not found..
The browser downloads a file named:

ndefined&SBI_ENVIRONMENT=WORKSPACE&IS_TECHNICAL_USER=false&documentMode=EDIT

containing this:

{"service":"","errors":[{"message":"RESTEASY003210: Could not find resource for full path: http://<MYIP>:<MYPORT>/knowage/restful-services/undefined&SBI_ENVIRONMENT=WORKSPACE&IS_TECHNICAL_USER=false&documentMode=EDIT"}]}

I don't know if it related to only docker version or a general Knowage-Server. What is that undefined variable? I miss something in the configuration?

data source cache_ds is not correctly configured, cause "Unable to load data from dataset" error in widgets using REST datasets

the default cache data source (cache_ds) is configured with jndi, and is not working after installation
then it causes to have errors with REST datasets ("Unable to load data from dataset <ds name> Please check dataset & widget config" error in widgets using any REST dataset

I fixed the issue by configuring cache_ds using jdbc connection with the knowage db.

But the tomcat JNDI configuration should be aligned, with the jndi conf (java:comp/env/jdbc/cache_ds) from the database initial population

Error execute docker-compose.yml Knowage-Server-Docker 7.4

I have a problem with execute docker-compose, because return message :
"Cannot create container for service knowage: invalid volume specification: '658f544afdeacde4f48bedd5b206a2f9a34e573b2b6ea1fe96506c68dcdd44ed:[/home/knowage/apache-tomcat/resources]:rw': invalid mount config for type "volume": invalid mount path: '[/home/knowage/apache-tomcat/resources]' mount path must be absolute

ERROR: for knowage Cannot create container for service knowage: invalid volume specification: '658f544afdeacde4f48bedd5b206a2f9a34e573b2b6ea1fe96506c68dcdd44ed:[/home/knowage/apache-tomcat/resources]:rw': invalid mount config for type "volume": invalid mount path: '[/home/knowage/apache-tomcat/resources]' mount path must be absolute
ERROR: Encountered errors while bringing up the project."

My docker-compose contains:

version: "3.1"
services:
knowage:
image: knowagelabs/knowage-server-docker:7.4.0-SNAPSHOT
depends_on:
- knowagedb
- knowagecache
ports:
- "8080:8080"
networks:
- main
environment:
- 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=knowagedb
  - CACHE_DB_USER=knowageuser
  - CACHE_DB_PASS=knowagepassword

  - HMAC_KEY=abc123
  - PASSWORD_ENCRYPTION_SECRET=def456
  - PUBLIC_ADDRESS=localhost

knowagepython:
image: knowagelabs/knowage-python-docker:7.4
environment:
- HMAC_KEY=abc123
- KNOWAGE_PUBLIC_ADDRESS=knowage
- PUBLIC_ADDRESS=localhost
networks:
- main

knowager:
image: knowagelabs/knowage-r-docker:7.4
environment:
- HMAC_KEY=abc123
networks:
- main

knowagedb:
image: mariadb:10.3
environment:
- MYSQL_USER=knowageuser
- MYSQL_PASSWORD=knowagepassword
- MYSQL_DATABASE=knowagedb
- MYSQL_RANDOM_ROOT_PASSWORD=yes
networks:
- main
volumes:
- "db:/var/lib/mysql"

knowagecache:
image: mariadb:10.3
environment:
- MYSQL_USER=knowageuser
- MYSQL_PASSWORD=knowagepassword
- MYSQL_DATABASE=knowagedb
- MYSQL_RANDOM_ROOT_PASSWORD=yes
networks:
- main
volumes:
- "cache:/var/lib/mysql"

volumes:
db:
cache:

Also I work other example with volumen :

version: "3.1"
services:
knowage:
image: knowagelabs/knowage-server-docker:7.4
depends_on:
- knowagedb
- knowagecache
ports:
- "8080:8080"
networks:
- main
environment:
- 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=knowagedb
  - CACHE_DB_USER=knowageuser
  - CACHE_DB_PASS=knowagepassword

  - HMAC_KEY=abc123
  - PASSWORD_ENCRYPTION_SECRET=def456
  - PUBLIC_ADDRESS=localhost

volumes:
- "data:/home/knowage/apache-tomcat/resources"
knowagepython:
image: knowagelabs/knowage-python-docker:7.4
environment:
- HMAC_KEY=abc123
- KNOWAGE_PUBLIC_ADDRESS=knowage
- PUBLIC_ADDRESS=localhost
networks:
- main

knowager:
image: knowagelabs/knowage-r-docker:7.4
environment:
- HMAC_KEY=abc123
networks:
- main

volumes:
db:
cache:
data:
networks:
main:

networks:
main:

Any known solution ?

Healthcheck url wich works

Hello, in Dockerfile :

HEALTHCHECK --start-period=120s
--interval=10s
--timeout=5s
--retries=5
CMD wget -q --spider http://127.0.0.1:8080/ || exit 1

should be :
HEALTHCHECK --start-period=120s
--interval=10s
--timeout=5s
--retries=5
CMD wget -q --spider http://127.0.0.1:8080/knowage || exit 1

SSL+Port Issue Public Address

Hi guys,

I'm running knowage behind a reverse proxy (traefik) with SSL certificate and auto-redirect from 80 to port 443. In general that's working well, but a few links don't work any more, for example editing the fields of an imported csv-file (add dataset file type, upload, click next -> error). The error says that it wants to open an URL in the format:

http://my-domain:8080/knowage

But it should open an url in the format:

https://my-domain/knowage

The reason for that seems to be that the entrypoint.sh doesn't change the protocol and port of the public addresses in the server.xml.

https://github.com/KnowageLabs/Knowage-Server-Docker/blob/master/entrypoint.sh#L41

Adding ENV vars for protocol and port would be a small fix with a big impact I believe.

How to update knowage use docker?

How to update know use docker? I what update knowage version 6.4.5 to 7.2.6

Use docker-compose to deploy, knowagepython container Exited

Hi, I run https://github.com/KnowageLabs/Knowage-Server-Docker/blob/master/Knowage-Server-Docker/docker-compose.yml to deploy Knowage, not modify any item.

Knowage is running ok ,but knowagepython container Exited

CONTAINER ID   IMAGE                                              COMMAND                  CREATED          STATUS                    PORTS                                                 NAMES
9cd08e5e8be4   knowagelabs/knowage-server-docker:8.1.0-SNAPSHOT   "./entrypoint.sh ./a…"   11 minutes ago   Up 11 minutes (healthy)   8009/tcp, 0.0.0.0:8080->8080/tcp, :::8080->8080/tcp   knowage-server-docker-knowage-1
a5e6ad8022eb   knowagelabs/knowage-r-docker:8.1.0-SNAPSHOT        "./entrypoint.sh r k…"   11 minutes ago   Up 11 minutes (healthy)   5001/tcp                                              knowage-server-docker-knowager-1
cf83b84c4d48   mariadb:10.3                                       "docker-entrypoint.s…"   11 minutes ago   Up 11 minutes             3306/tcp                                              knowage-server-docker-knowagedb-1
3ec87031b7ec   mariadb:10.3                                       "docker-entrypoint.s…"   11 minutes ago   Up 11 minutes             3306/tcp                                              knowage-server-docker-knowagecache-1
43a4ad713297   hazelcast/hazelcast:3.6.5                          "/bin/sh -c ./server…"   11 minutes ago   Up 11 minutes             5701/tcp                                              knowage-server-docker-hazelcast-1

logs of knowagepython container

ImportError: cannot import name 'soft_unicode' from 'markupsafe' (/usr/local/lib/python3.7/site-packages/markupsafe/__init__.py)
[2022-05-25 07:17:08 +0000] [13] [INFO] Worker exiting (pid: 13)
Traceback (most recent call last):
  File "/usr/local/lib/python3.7/site-packages/gunicorn/arbiter.py", line 209, in run
    self.sleep()
  File "/usr/local/lib/python3.7/site-packages/gunicorn/arbiter.py", line 357, in sleep
    ready = select.select([self.PIPE[0]], [], [], 1.0)
  File "/usr/local/lib/python3.7/site-packages/gunicorn/arbiter.py", line 242, in handle_chld
    self.reap_workers()
  File "/usr/local/lib/python3.7/site-packages/gunicorn/arbiter.py", line 525, in reap_workers
    raise HaltServer(reason, self.WORKER_BOOT_ERROR)
gunicorn.errors.HaltServer: <HaltServer 'Worker failed to boot.' 3>

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/local/bin/gunicorn", line 8, in <module>
    sys.exit(run())
  File "/usr/local/lib/python3.7/site-packages/gunicorn/app/wsgiapp.py", line 58, in run
    WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run()
  File "/usr/local/lib/python3.7/site-packages/gunicorn/app/base.py", line 228, in run
    super().run()
  File "/usr/local/lib/python3.7/site-packages/gunicorn/app/base.py", line 72, in run
    Arbiter(self).run()
  File "/usr/local/lib/python3.7/site-packages/gunicorn/arbiter.py", line 229, in run
    self.halt(reason=inst.reason, exit_status=inst.exit_status)
  File "/usr/local/lib/python3.7/site-packages/gunicorn/arbiter.py", line 342, in halt
    self.stop()
  File "/usr/local/lib/python3.7/site-packages/gunicorn/arbiter.py", line 393, in stop
    time.sleep(0.1)
  File "/usr/local/lib/python3.7/site-packages/gunicorn/arbiter.py", line 242, in handle_chld
    self.reap_workers()
  File "/usr/local/lib/python3.7/site-packages/gunicorn/arbiter.py", line 525, in reap_workers
    raise HaltServer(reason, self.WORKER_BOOT_ERROR)
gunicorn.errors.HaltServer: <HaltServer 'Worker failed to boot.' 3>

GC overhead and jarfile validation in docker-compose

Hello guys,
I have run the docker-compose file and I am getting this error:

INFO: validateJarFile(/home/knowage/apache-tomcat-7.0.57/webapps/knowagekpiengine/WEB-INF/lib/jsp-api-2.1.jar) - jar not loaded. See Servlet Spec 3.0, section 10.7.2. Offending class: javax/el/Expression.class

When I then connect to the web admin interface, I get an out of memory error:

knowage_1    | Jun 08, 2018 4:41:17 PM org.apache.catalina.startup.HostConfig deployDirectories
knowage_1    | SEVERE: Error waiting for multi-thread deployment of directories to complete
knowage_1    | java.util.concurrent.ExecutionException: java.lang.OutOfMemoryError: GC overhead limit exceeded
knowage_1    | 	at java.util.concurrent.FutureTask.report(FutureTask.java:122)
knowage_1    | 	at java.util.concurrent.FutureTask.get(FutureTask.java:192)
knowage_1    | 	at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1148)
knowage_1    | 	at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
knowage_1    | 	at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1611)
knowage_1    | 	at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:330)
knowage_1    | 	at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
knowage_1    | 	at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:90)
knowage_1    | 	at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:402)
knowage_1    | 	at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:347)
knowage_1    | 	at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:1140)
knowage_1    | 	at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:816)
knowage_1    | 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
knowage_1    | 	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1575)
knowage_1    | 	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1565)
knowage_1    | 	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
knowage_1    | 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
knowage_1    | 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
knowage_1    | 	at java.lang.Thread.run(Thread.java:745)
knowage_1    | Caused by: java.lang.OutOfMemoryError: GC overhead limit exceeded
knowage_1    | 	at java.util.Arrays.copyOfRange(Arrays.java:3664)
knowage_1    | 	at java.lang.String.<init>(String.java:207)
knowage_1    | 	at java.io.DataInputStream.readUTF(DataInputStream.java:661)
knowage_1    | 	at org.apache.tomcat.util.bcel.classfile.FastDataInputStream.readUTF(FastDataInputStream.java:183)
knowage_1    | 	at org.apache.tomcat.util.bcel.classfile.ConstantUtf8.getInstance(ConstantUtf8.java:38)
knowage_1    | 	at org.apache.tomcat.util.bcel.classfile.Constant.readConstant(Constant.java:81)
knowage_1    | 	at org.apache.tomcat.util.bcel.classfile.ConstantPool.<init>(ConstantPool.java:55)
knowage_1    | 	at org.apache.tomcat.util.bcel.classfile.ClassParser.readConstantPool(ClassParser.java:175)
knowage_1    | 	at org.apache.tomcat.util.bcel.classfile.ClassParser.parse(ClassParser.java:83)
knowage_1    | 	at org.apache.catalina.startup.ContextConfig.processAnnotationsStream(ContextConfig.java:2071)
knowage_1    | 	at org.apache.catalina.startup.ContextConfig.processAnnotationsJar(ContextConfig.java:1947)
knowage_1    | 	at org.apache.catalina.startup.ContextConfig.processAnnotationsUrl(ContextConfig.java:1913)
knowage_1    | 	at org.apache.catalina.startup.ContextConfig.processAnnotations(ContextConfig.java:1898)
knowage_1    | 	at org.apache.catalina.startup.ContextConfig.webConfig(ContextConfig.java:1330)
knowage_1    | 	at org.apache.catalina.startup.ContextConfig.configureStart(ContextConfig.java:889)
knowage_1    | 	at org.apache.catalina.startup.ContextConfig.lifecycleEvent(ContextConfig.java:386)
knowage_1    | 	at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
knowage_1    | 	at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:90)
knowage_1    | 	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5380)
knowage_1    | 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
knowage_1    | 	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
knowage_1    | 	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
knowage_1    | 	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649)
knowage_1    | 	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1245)
knowage_1    | 	at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1895)
knowage_1    | 	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
knowage_1    | 	... 4 more

how can edit UI, css, tittle, description in a docker compose instance?

About Knowage Kubernetes deployment information, example and tutorial ?

Hello,
We have a project which uses some Fiware GEs, among them Knowage, but where containers are deployed on a Kubernetes cluster.

And we have several questions about Knowage and Kubernetes, since we didn't found any information by googling :

Have you something in your roadmap about documenting deployment with Kubernetes ?
Can you provide some advice to achieve deployment with K8S ?
We have the idea to use Kompose to transform the docker compose or stack file, is it a good solution ?

Thanks in advance for your feedback

6.2.2 http error 500

Download the 6.2.2 docker-compose.yml and run docker-compose up -d
open url shows http error 500

HTTP Status 500 -

type Status report

message

description The server encountered an internal error that prevented it from fulfilling this request.
Apache Tomcat/7.0.57

any suggestions ?

http error 500 with 8.1 Docker (on windows and macos)

I tried today to deploy last version (8.1.0), the docker version on macos, using the docker-compose.yml,

but when I try to get the login page, the tomcat send back an http 500 Error

We have the same behavior under docker on windows (WSL2)
Whenever the installation seems OK on both !

We tested on Ubuntu, no problem !

in the knowage.log we find some errors :

[http-nio-8080-exec-23] 06 Jul 2021 17:28:52,231 ERROR it.eng.spagobi.commons.filters.ProfileFilter.getUserIdWithSSO:313 - Authentication failed
java.lang.NullPointerException
....
[http-nio-8080-exec-23] 06 Jul 2021 17:28:52,231 ERROR it.eng.spagobi.commons.filters.ProfileFilter.doFilter:177 - Error while service execution
it.eng.spagobi.commons.filters.ProfileFilter$SilentAuthenticationFailedException
        at it.eng.spagobi.commons.filters.ProfileFilter.getUserIdWithSSO(ProfileFilter.java:314)
...
[http-nio-8080-exec-12] 06 Jul 2021 17:28:53,240 ERROR it.eng.spagobi.commons.MetadataDatabaseConfigurationRetriever.loadConfigurations:88 - The table sbi_config is EMPTY
[http-nio-8080-exec-12] 06 Jul 2021 17:28:53,242 ERROR it.eng.spagobi.commons.utilities.ChannelUtilities.isWebRunning:161 - SPAGOBI.SPAGOBI-MODE.mode IS NULL
[http-nio-8080-exec-12] 06 Jul 2021 17:28:53,244 ERROR it.eng.spagobi.commons.MetadataDatabaseConfigurationRetriever.loadConfigurations:88 - The table sbi_config is EMPTY
[http-nio-8080-exec-12] 06 Jul 2021 17:28:53,245 ERROR it.eng.spagobi.commons.utilities.SpagoBIUtilities.readJndiResource:320 - java.lang.NullPointerException
[http-nio-8080-exec-12] 06 Jul 2021 17:28:53,245 ERROR it.eng.spagobi.services.common.SsoServiceFactory.createProxyService:55 - Error occurred
java.lang.NullPointerException
        at java.lang.Class.forName0(Native Method)
...

any help about how to fix this problem is welcome ;O)

dockerfile 6.3.3 doesn't build due some broken apt repo

I always get an error during buildng dockerfile

tep 53/90 : RUN apt-get update && apt-get install -y wget coreutils unzip mysql-client  && rm -rf /var/lib/apt/lists/*
 ---> Running in 010830bbe9c9
Ign http://deb.debian.org jessie InRelease
Get:1 http://deb.debian.org jessie-updates InRelease [16.3 kB]
Get:2 http://security.debian.org jessie/updates InRelease [44.9 kB]
Ign http://deb.debian.org jessie-backports InRelease
Get:3 http://deb.debian.org jessie Release.gpg [1652 B]
Ign http://deb.debian.org jessie-backports Release.gpg
Get:4 http://deb.debian.org jessie Release [77.3 kB]
Ign http://deb.debian.org jessie-backports Release
Err http://deb.debian.org jessie-backports/main amd64 Packages
  
Err http://deb.debian.org jessie-backports/main amd64 Packages
  
Err http://deb.debian.org jessie-backports/main amd64 Packages
  
Get:5 http://deb.debian.org jessie-updates/main amd64 Packages [20 B]
Err http://deb.debian.org jessie-backports/main amd64 Packages
  404  Not Found
Get:6 http://deb.debian.org jessie/main amd64 Packages [9098 kB]
Get:7 http://security.debian.org jessie/updates/main amd64 Packages [886 kB]
W: There is no public key available for the following key IDs:
AA8E81B4331F7F50
W: Failed to fetch http://deb.debian.org/debian/dists/jessie-backports/main/binary-amd64/Packages  404  Not Found

E: Some index files failed to download. They have been ignored, or old ones used instead.
Fetched 10.1 MB in 1min 44s (97.1 kB/s)
ERROR: Service 'knowage' failed to build: The command '/bin/sh -c apt-get update && apt-get install -y wget coreutils unzip mysql-client  && rm -rf /var/lib/apt/lists/*' returned a non-zero code: 100

I guess this stfo answer explains the problem
And I used this stfo answer

And I ended up with this code

RUN echo "deb [check-valid-until=no] http://cdn-fastly.deb.debian.org/debian jessie main" > /etc/apt/sources.list.d/jessie.list
RUN echo "deb [check-valid-until=no] http://archive.debian.org/debian jessie-backports main" > /etc/apt/sources.list.d/jessie-backports.list
RUN sed -i '/deb http:\/\/deb.debian.org\/debian jessie-updates main/d' /etc/apt/sources.list

#install required packages and clean up to save space
RUN apt-get -o Acquire::Check-Valid-Until=false update && apt-get install -y wget coreutils unzip mysql-client  && rm -rf /var/lib/apt/lists/*

instead of RUN apt-get -o Acquire::Check-Valid-Until=false update && apt-get install -y wget coreutils unzip mysql-client && rm -rf /var/lib/apt/lists/*

I don't know the right solution for it, just popped the problem

mysql_native_password! Got packets out of order

I used docker compose to install Knowage-6.1.1 by docker pull knowagelabs/knowage-server-docker:6.1.1, server can find mysql and creat tables, but then have this error:

5.6.38(V[E'2g0��VA"';3-&xLP.mysql_native_password!��#08S01Got packets out of order

my docker-compose.yml:

version: "3"
services:
        knowage:
            image: hub.m/knowage/knowage-server:6.1.1
            links:#my docker server not support this 
                - knowagedb:db
            ports:
                - "33048:8080"
            deploy:
                restart_policy:
                        condition: on-failure
                replicas: 1
                resources:
                        limits:
                                cpus : "4"
                                memory : 6000M
                        reservations:
                                cpus : "0.5"
                                memory : 1024M
            environment:
                - WAIT_MYSQL=true
                - PUBLIC_ADDRESS=paas.m
                - DB_PORT_3306_TCP_ADDR=paas.m
                - DB_PORT_3306_TCP_PORT=30347
                - DB_ENV_MYSQL_USER=knowageuser
                - DB_ENV_MYSQL_PASSWORD=knowagepassword
                - DB_ENV_MYSQL_DATABASE=knowagedb

        knowagedb:
            image: hub.m/mysql:5.6.38
            ports:
                - "33047:3306"
            deploy:
                restart_policy:
                        condition: on-failure
                replicas: 1
                resources:
                        limits:
                                cpus : "2"
                                memory : 2000M
                        reservations:
                                cpus : "0.2"
                                memory : 512M
            environment:
                - MYSQL_USER=knowageuser
                - MYSQL_PASSWORD=knowagepassword
                - MYSQL_DATABASE=knowagedb
                - MYSQL_ROOT_PASSWORD=knowagerootpassword

docker compose with Postgresql jar driver

Hello there,
is this the correct approach to load the JAR file?
Is not working for me:

docker-compose.yaml

knowage:
build: knowage/.
links:
- knowagedb:db
ports:
- "8080:8080"
environment:
- WAIT_MYSQL=true

knowagedb:
image: mysql:5.5
environment:
- MYSQL_USER=knowageuser
- MYSQL_PASSWORD=knowagepassword
- MYSQL_DATABASE=knowagedb
- MYSQL_ROOT_PASSWORD=knowagerootpassword

knowage/Dockerfile:

FROM knowagelabs/knowage-server-docker:6.1.1

https://jdbc.postgresql.org/download.html

COPY postgresql.jar /home/knowage/apache-tomcat-7.0.57/lib/postgresql.jar

The manual says that must be copied into a folder called:
KnowageServer-/lib
however I don't see that so I presume is the apache tomcat?

When I then add the data source the Test function with driver:org.postgresql.Driver, I setup a correct URL with username and password but it goes idle and nothing shows up in the logs.

OLAP Cube custom view

Hi,

I'm trying to work with knowage 6.2.2 in docker and PostgreSQL DB. All configuration files were changed to work with new DB, I can get and save any data to DB, however, when I'm trying to create a custom view for Olap Cube getting the error

{"errors":[{"localizedMessage":"sbi.olap.subobject.save.error","message":"it.eng.spagobi.utilities.exceptions.SpagoBIRestServiceException: sbi.olap.subobject.save.error","errorService":""}]}

At the same time in container log I can see next error:

it.eng.spagobi.engines.whatif.api.SubObjectResource.save: Error saving the subobject KO - You cannot save subobjects
knowage_1  | it.eng.spagobi.engines.whatif.exception.RestExceptionMapper.toResponse: Catched error
knowage_1  | it.eng.spagobi.utilities.exceptions.SpagoBIRestServiceException: sbi.olap.subobject.save.error

Please advice...

knowagelabs / knowage-server-docker Goto Github PK

knowage-server-docker's People

Contributors

Stargazers

Watchers

Forkers

knowage-server-docker's Issues

Hello,

Recommend Projects

Recommend Topics

Recommend Org