Welcome to Knowage Q&A, where you can ask questions and receive answers from other members of the community.
0 votes
1 view
hey guys...

I installed Knowage from Docker "knowagelabs / knowage-server-docker". I used the docker-compose.yml in the example, making the adjustments according to my needs.
But, when I try to login using the user "biadmin", there is an error "Ooooooops! User or password invalid, Retry!".
I have already changed the mysql connector to the suggested version, and even then the error remains.
The docker-compose used is this:

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

version: "3.6"

services:

  knowage:
    image: knowagelabs/knowage-server-docker:7.1
    depends_on:
      - knowagedb
    ports:
      - "8000:8080"
    networks:
      default:
        ipv4_address: 172.20.0.20
    environment:
      - DB_USER=admin
      - DB_PASS=mydb7
      - DB_DB=dbase
      - DB_HOST=172.20.0.21
      - DB_PORT=3306
 
  knowagedb:
    image: mysql:5.7.29
    ports:
      - "3306:3306"
    networks:
      default:
        ipv4_address: 172.20.0.21
    environment:
      - MYSQL_USER=admin
      - MYSQL_PASSWORD=mydb7
      - MYSQL_DATABASE=dbase
      - MYSQL_ROOT_PASSWORD=mydb777
    volumes:
      - "/mnt/knowage/db:/var/lib/mysql"

volumes:
  db:

networks:
  default:
    external:
      name: Sete

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

LOG KnowAGE

root@8e9d0aefe393:/# nano /home/knowage/apache-tomcat-8.5.37/logs/knowage.log
  GNU nano 2.7.4                       File: /home/knowage/apache-tomcat-8.5.37/logs/knowage.log

        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1132)
        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.access$000(ContainerBase.java:129)
        at org.apache.catalina.core.ContainerBase$PrivilegedAddChild.run(ContainerBase.java:150)
        at org.apache.catalina.core.ContainerBase$PrivilegedAddChild.run(ContainerBase.java:140)
        at java.security.AccessController.doPrivileged(Native Method)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)
        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)
[http-nio-8080-exec-5] 29 Mar 2020 12:33:38,215 ERROR it.eng.spagobi.commons.services.LoginModule.service:218 - userName/pwd unc$

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

If I try to create a new user using the "Sign up" option, it gives an error, but checking within MySQL, I see that the users were created. That is, the connection to the bank is correct.

What do I do to correct this problem?
Environment knowagelabs/knowage-server-docker:7.1 - MySQL 5.7.29
in Docker by (1.1k points)

1 Answer

0 votes

Dear,

you miss a mandatory environment variable on the Knowage service. Just add a random value alphanumeric value for HMAC_KEY and it should work correctly:

version: "3.6"
services:
  knowage:
    image: knowagelabs/knowage-server-docker:7.1
    depends_on:
      - knowagedb
    ports:
      - "8000:8080"
    networks:
      default:
        ipv4_address: 172.20.0.20
    environment:
      - DB_USER=admin
      - DB_PASS=mydb7
      - DB_DB=dbase
      - DB_HOST=172.20.0.21
      - DB_PORT=3306
      - HMAC_KEY=abc123
 
  knowagedb:
    image: mysql:5.7.29
    ports:
    ...

by (5.1k points)
Thanks for your response.
I managed to make it work by making a "git clone" of the docker hub folder, and running the docker-compose with the original settings.
...