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 at TechMahindra.com>
Inviato: lunedì 28 maggio 2018 10:03:13
A: José Ignacio Carretero; Portosa Alessandro; Juanjo Hierro; fiware-tech-help at 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 at 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 at fiware.org>; 'Portosa Alessandro' <Alessandro.Portosa at eng.it>; 'Juanjo Hierro' <juanjose.hierro at fiware.org>; 'fiware-tech-help at lists.fiware.org' <fiware-tech-help at lists.fiware.org>; 'Fernando López Aguilar' <fernando.lopez at fiware.org>
Cc: 'Prashant Chauhan1' <PC00474884 at TechMahindra.com>; Yugal Kishor Mullick <YM00106030 at TechMahindra.com>; 'Álvaro Arranz' <aarranz at ficodes.com>; 'Francisco de la Vega' <fdelavega at ficodes.com>; 'Zerbetto Davide' <davide.zerbetto at 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
1.
sudo apt-get install mysql-server
2.
Modified /etc/mysql/mysql.conf.d/mysqld.cnf and changed
from
bind-address = 127.0.0.1
to
bind-address = *
3.
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 at 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.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)
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)
at java.lang.Thread.run(Thread.java:748)
[localhost-startStop-1] 25 May 2018 12:35:44,229 ERROR it.eng.spagobi.commons.initializers.metadata.MetadataInitializer.init:87 - An unexpected error occured while initializing metadata
it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: Ab unexpected error occured while initializing Product Types
at it.eng.spagobi.commons.initializers.metadata.ProductTypesInitializer.init(ProductTypesInitializer.java:64)
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)
…
.
.
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'knowage_ce.SBI_PRODUCT_TYPE' doesn't exist
.
.
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'knowage_ce.SBI_DATA_SOURCE' doesn't exist
And many more…..
Thanks & Regards,
Krishan Babbar
Technical Architect
IES Internet of Things | Tech Mahindra
============================================================================================================================
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.
============================================================================================================================
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.fiware.org/private/fiware-tech-help/attachments/20180528/94a14fe8/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 12595 bytes
Desc: image001.png
URL: <https://lists.fiware.org/private/fiware-tech-help/attachments/20180528/94a14fe8/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Outlook-1513603850.png
Type: image/png
Size: 3338 bytes
Desc: Outlook-1513603850.png
URL: <https://lists.fiware.org/private/fiware-tech-help/attachments/20180528/94a14fe8/attachment-0003.png>
You can get more information about our cookies and privacy policies clicking on the following links: Privacy policy Cookies policy