[HELP-14224] FIWARE.Request.Tech.Re: Knowage Installation Problem..... - JIRA

Details

Type: extRequest
Status: Closed
Priority: Major
Resolution: Dismissed
Fix Version/s: 2021
Component/s: FIWARE-TECH-HELP
Labels:
None

HD-Enabler:
Knowage

Description

Dear Kristan,

I'm not sure what is happening in your installation. The installer is meant to be used as all-in-one solution to install Knowage. There should be no need to execute DDL manually and so on. Also, from the error above, I see that your server.xml in Knowage-Server-CE/logs is not well configured.

Some configs are missing, and you can try to recover the situation looking at https://knowage.readthedocs.io/en/latest/admin/README/index.html#installation-from-released-package

Anyway, for a clean installation with Ubuntu and Knowage installer via command line, you can have a look at this webinar: https://youtu.be/0TTe-TZodok

Please let me know if you find it useful.

Alessandro Portosa
Technical Consultant

[X][1513603850060_logotipo_knowage_150px.png]

Knowage Labs
Engineering Group
Via G. Marconi, 10 - 40131 Bologna - Italy
Tel. + 39 051 0435090
Skype alessandro.portosa
www.knowage-suite.com<http://www.knowage-suite.com/> - www.eng.it<http://www.eng.it/web/eng_en/home>

The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.

________________________________
Da: Krishan Babbar <KB00449283@TechMahindra.com>
Inviato: lunedì 28 maggio 2018 10:03:13
A: José Ignacio Carretero; Portosa Alessandro; Juanjo Hierro; fiware-tech-help@lists.fiware.org; Fernando López Aguilar
Cc: Prashant Chauhan1; Yugal Kishor Mullick; Álvaro Arranz; Francisco de la Vega; Zerbetto Davide
Oggetto: RE: Knowage Installation Problem....

After downloading “mysql-dbscripts-6_2_0-RC_20180509.zip<https://forge.ow2.org/project/download.php?group_id=442&file_id=22143>” from https://forge.ow2.org/project/showfiles.php?group_id=442 and executing SQL scripts for missing tables, I could start Knowage.

On startup it is having below error in “knowage.log” file.

[localhost-startStop-1] 28 May 2018 07:55:06,898 ERROR it.eng.spagobi.commons.utilities.SpagoBIUtilities.readJndiResource:317 - javax.naming.NameNotFoundException: Name [resource_path] is not bound in this Context. Unable to find [resource_path].

I opened login page in browser and when submitting with credentials “biadmin/biadmin”, I am getting following errors.

Any idea what is wrong or what setting is left?

Knowage.log

root@AzureFiwareInstance:/home/babbarkrishan/knowage/Knowage-Server-CE/logs# vi knowage.log

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at it.eng.spagobi.commons.filters.SpagoBICoreCheckSessionFilter.doFilter(SpagoBICoreCheckSessionFilter.java:94)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at it.eng.spagobi.utilities.filters.EncodingFilter.doFilter(EncodingFilter.java:54)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:409)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1044)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)

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.ExceptionInInitializerError

at it.eng.spagobi.security.InternalSecurityServiceSupplierImpl.checkAuthentication(InternalSecurityServiceSupplierImpl.java:76)

at it.eng.spagobi.security.InternalSecurityServiceSupplierImpl.checkAuthentication(InternalSecurityServiceSupplierImpl.java:110)

at it.eng.spagobi.commons.services.LoginModule.service(LoginModule.java:257)

at it.eng.spago.dispatching.module.DefaultPage.invokeServiceBusiness(DefaultPage.java:352)

at it.eng.spago.dispatching.module.DefaultPage.nextStep(DefaultPage.java:302)

at it.eng.spago.dispatching.module.DefaultPage.service(DefaultPage.java:202)

at it.eng.spago.dispatching.module.ModuleCoordinator.service(ModuleCoordinator.java:102)

at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:436)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

... 30 more

Caused by: it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: Cannot initialize JWT algorithm

at it.eng.spagobi.services.common.JWTSsoService.<clinit>(JWTSsoService.java:59)

... 40 more

Caused by: java.lang.IllegalArgumentException: The Secret cannot be null

at com.auth0.jwt.algorithms.HMACAlgorithm.getSecretBytes(HMACAlgorithm.java:40)

at com.auth0.jwt.algorithms.HMACAlgorithm.<init>(HMACAlgorithm.java:34)

at com.auth0.jwt.algorithms.Algorithm.HMAC256(Algorithm.java:144)

at it.eng.spagobi.services.common.JWTSsoService.<clinit>(JWTSsoService.java:56)

... 40 more

Thanks & Regards,

Krishan Babbar

Technical Architect

IES Internet of Things | Tech Mahindra

Rajiv Gandhi Chandigarh Technology Park, Plot No. 23, Phase 2, Kishangarh, Chandigarh 160101, INDIA

• Office: +91 172 666 8400 Ext. 8352 | Mobile: +91 946 303 0996

============================================================================================================================
Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at http://www.techmahindra.com/Disclaimer.html externally http://tim.techmahindra.com/tim/disclaimer.html internally within TechMahindra.
===========================================================================================================================

From: Krishan Babbar
Sent: Friday, May 25, 2018 6:22 PM
To: 'José Ignacio Carretero' <joseignacio.carretero@fiware.org>; 'Portosa Alessandro' <Alessandro.Portosa@eng.it>; 'Juanjo Hierro' <juanjose.hierro@fiware.org>; 'fiware-tech-help@lists.fiware.org' <fiware-tech-help@lists.fiware.org>; 'Fernando López Aguilar' <fernando.lopez@fiware.org>
Cc: 'Prashant Chauhan1' <PC00474884@TechMahindra.com>; Yugal Kishor Mullick <YM00106030@TechMahindra.com>; 'Álvaro Arranz' <aarranz@ficodes.com>; 'Francisco de la Vega' <fdelavega@ficodes.com>; 'Zerbetto Davide' <davide.zerbetto@eng.it>
Subject: Knowage Installation Problem....

Today, I took an Ubuntu instance on Azure Cloud and followed below steps for setting up Knowage but getting DB errors given below.

Please guide what am I doing wrong? Why are some tables does not exists in DB? Or do we need to create missing tables manually?

This is delaying our POC which we need to show our prospective clients and management.

Kindly help.

Install MySQL

sudo apt-get install mysql-server

Modified /etc/mysql/mysql.conf.d/mysqld.cnf and changed

from

bind-address = 127.0.0.1

bind-address = *

mysql -u root -p

ALTER USER 'root'@'%' IDENTIFIED BY ''mypswd ';

GRANT ALL PRIVILEGES ON * . * TO 'root'@'%' IDENTIFIED BY ''mypswd';

FLUSH PRIVILEGES;

select version();

5.7.22-0ubuntu0.16.04.1

exit;

service mysql restart

Install Java

sudo update-java-alternatives -l

sudo add-apt-repository ppa:webupd8team/java

sudo apt-get update

sudo apt-get install oracle-java8-installer

sudo apt-get install oracle-java8-set-default

export JAVA_HOME=/usr/lib/jvm/java-8-oracle

export PATH=$JAVA_HOME/bin:$PATH

java -version

java version "1.8.0_171"

Java(TM) SE Runtime Environment (build 1.8.0_171-b11)

Java HotSpot(TM) 64-Bit Server VM (build 25.171-b11, mixed mode)

Install Knowage

1. Download Knowage

wget http://download.forge.ow2.org/knowage/Knowage-6_2_0-RC-CE-Installer-Unix-20180509.zip

unzip Knowage-6_2_0-RC-CE-Installer-Unix-20180509.zip

2. Create Swap Memory (https://www.digitalocean.com/community/tutorials/how-to-add-swap-space-on-ubuntu-16-04)

sudo swapon --show

free -h

df -h

sudo fallocate -l 4G /swapfile

ls -lh /swapfile

sudo chmod 600 /swapfile

ls -lh /swapfile

sudo mkswap /swapfile

sudo swapon /swapfile

sudo swapon --show

free -h

3. Setup Knowage

sh Knowage-6_2_0-RC-CE-Installer-Unix-20180509.sh -c

Used existing MySQL DB and it created knowage_ce with following tables.

[cid:image001.png@01D3F687.D14D7A90]

4. Add Database Source in conf/server.xml

<Resource name="jdbc/knowage" auth="Container"

type="javax.sql.DataSource"

driverClassName="com.mysql.jdbc.Driver"

url="jdbc:mysql://localhost:3306/knowage_ce"

username="root"

password="mypswd"

maxActive="20" maxIdle="10"

maxWait="-1"/>

5. Download MySQL Connector and copy to lib dir

cp mysql-connector-java-5.1.46.jar /home/babbarkrishan/knowage/Knowage-Server-CE/lib/

6. start the knowage server in /bin

sh startup.sh

Now getting following errors in knowage.log file

[localhost-startStop-1] 25 May 2018 12:35:37,244 ERROR it.eng.spagobi.commons.dao.ConfigDAOHibImpl.loadAllConfigParameters:77 - HibernateException during query

org.hibernate.exception.SQLGrammarException: could not execute query

at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)

at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

at org.hibernate.loader.Loader.doList(Loader.java:2536)

at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)

at org.hibernate.loader.Loader.list(Loader.java:2271)

at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)

at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)

at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)

at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)

at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)

at it.eng.spagobi.commons.dao.ConfigDAOHibImpl.loadAllConfigParameters(ConfigDAOHibImpl.java:66)

at it.eng.spagobi.commons.SingletonConfigCache.<init>(SingletonConfigCache.java:40)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

at java.lang.Class.newInstance(Class.java:442)

at it.eng.spagobi.commons.SingletonConfig.<init>(SingletonConfig.java:53)

at it.eng.spagobi.commons.SingletonConfig.getInstance(SingletonConfig.java:43)

at it.eng.spago.dbaccess.Configurator.<init>(Configurator.java:104)

at it.eng.spago.dbaccess.Configurator.getInstance(Configurator.java:117)

at it.eng.spago.dbaccess.DataConnectionManager.<init>(DataConnectionManager.java:74)

at it.eng.spago.dbaccess.DataConnectionManager.getInstance(DataConnectionManager.java:192)

at it.eng.spago.dbaccess.DataAccessInitializer.init(DataAccessInitializer.java:42)

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:1280)

at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1193)

at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1088)

at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5198)

at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5481)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:634)

at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1074)

at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1858)

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)

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'knowage_ce.SBI_CONFIG' doesn't exist

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)

at com.mysql.jdbc.Util.getInstance(Util.java:408)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)

at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)

at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)

at org.hibernate.loader.Loader.doQuery(Loader.java:802)

at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)

at org.hibernate.loader.Loader.doList(Loader.java:2533)

... 39 more

[localhost-startStop-1] 25 May 2018 12:35:37,257 ERROR it.eng.spagobi.commons.SingletonConfigCache.<init>:48 - Impossible to load configuration for report engine

it.eng.spago.error.EMFUserError: severity [ERROR] description [100]

at it.eng.spagobi.commons.dao.ConfigDAOHibImpl.loadAllConfigParameters(ConfigDAOHibImpl.java:82)