However.... despite of creating bigger VMs, you also have the option to create some swap space on a file --- As root user you can exec these four commands dd if=/dev/zero of=/swapfile bs=((1024*1024)) count=4096 ### This is slow. It has to write 4Gb of data chmod 600 /swapfile mkswap /swapfile swapon /swapfile This is the same approach windows uses for its swap memory. Swap memory most times improves OS Performance. Regards, José Ignacio El 17/05/18 a las 15:46, Portosa Alessandro escribió: > > The error is pretty clear. Not enough memory. You didn't miss any step. > > By default Knowage wants to get 2Gb of memory. You can tune this > configuration in bin/setenv.sh but be aware that it is not recommended > to go below 2Gb. > > > *Alessandro Portosa* > Technical Consultant > > > 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:* giovedì 17 maggio 2018 15:40:21 > *A:* Portosa Alessandro; Juanjo Hierro; Jose Ignacio Carretero; > 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: [Fiware-tech-help] How to fetch historical data? > > Hi Alessandro, > > Thanks Again. > > After adding host and MySQL Datasource in conf/server.xml, when I > started Knowage server it is giving memory error as shown below. > > INFO: Deploying web application archive > /home/ubuntu/knowage/destination/Knowage-Server-CE/webapps/knowagewhatifengine.war > > May 17, 2018 12:51:02 PM org.apache.catalina.loader.WebappClassLoader > validateJarFile > > INFO: > validateJarFile(/home/ubuntu/knowage/destination/Knowage-Server-CE/webapps/knowagewhatifengine/WEB-INF/lib/servlet-api-2.4.jar) > - jar not loaded. See Servlet Spec 3.0, section 10.7.2. Offending > class: javax/servlet/Servlet.class > > Java HotSpot(TM) 64-Bit Server VM warning: INFO: > os::commit_memory(0x00000000f5200000, 133169152, 0) failed; > error='Cannot allocate memory' (errno=12) > > # > > # There is insufficient memory for the Java Runtime Environment to > continue. > > # Native memory allocation (mmap) failed to map 133169152 bytes for > committing reserved memory. > > # An error report file with more information is saved as: > > # > /home/ubuntu/knowage/destination/Knowage-Server-CE/bin/hs_err_pid7651.log > > My Instance is having 4 GB of RAM. Is it not sufficient? > > Below is the result of “top” command > > Do let me know if I am missing any step? > > 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:*Portosa Alessandro <Alessandro.Portosa at eng.it> > *Sent:* Thursday, May 17, 2018 3:34 PM > *To:* Krishan Babbar <KB00449283 at TechMahindra.com>; Juanjo Hierro > <juanjose.hierro at fiware.org>; Jose Ignacio Carretero > <joseignacio.carretero at 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:* Re: [Fiware-tech-help] How to fetch historical data? > > Please add ubuntucustomfiware to your /etc/hosts and try again > > https://stackoverflow.com/a/43570800 > > *Alessandro Portosa* > Technical Consultant > > 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 > <mailto:KB00449283 at TechMahindra.com>> > *Inviato:* giovedì 17 maggio 2018 11:44:29 > *A:* Portosa Alessandro; Juanjo Hierro; Jose Ignacio Carretero; > fiware-tech-help at lists.fiware.org > <mailto: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: [Fiware-tech-help] How to fetch historical data? > > Hi, > > JAVA_HOME error was fixed by adding forward slash > (JAVA_HOME="/usr/lib/jvm/java-8-oracle/"). My Bad. > > Now when I am starting Knowage server, I can see errors in logs and > http://<MyIPAddress>:8080/knowage/ > <http://%3cMyIPAddress%3e:8080/knowage/> is not working. > > I followed > https://www.knowage-suite.com/qa/548/not-able-to-start-knowage-server > and tried changing hazelcast port but still same error. > > *catalina.out* > > INFO: Configuring Hazelcast from 'hazelcast.xml'. > > May 17, 2018 7:40:31 AM org.apache.catalina.core.StandardContext > startInternal > > SEVERE: Error listenerStart > > May 17, 2018 7:40:31 AM org.apache.catalina.core.StandardContext > startInternal > > SEVERE: Context [/knowage] startup failed due to previous errors > > 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. > > May 17, 2018 7:40:31 AM org.apache.catalina.loader.WebappClassLoader > clearReferencesThreads > > SEVERE: The web application [/knowage] appears to have started a > thread named [DefaultQuartzScheduler_Worker-1] but has failed to stop > it. This is very likely to create a memory leak. > > *knowage.log* > > [localhost-startStop-1] 17 May 2018 07:40:31,604 ERROR > it.eng.spagobi.commons.utilities.SpagoBIUtilities.getCurrentHostName:777 > - Error in retrieving host name > > java.net.UnknownHostException: ubuntucustomfiware: ubuntucustomfiware: > Name or service not known > > at java.net.InetAddress.getLocalHost(InetAddress.java:1505) > > at > it.eng.spagobi.commons.utilities.SpagoBIUtilities.getCurrentHostName(SpagoBIUtilities.java:773) > > at > it.eng.spagobi.utilities.locks.listeners.HazelcastContextListener.contextInitialized(HazelcastContextListener.java:34) > > at > org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4961) > > at > org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5455) > > 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) > > Caused by: java.net.UnknownHostException: ubuntucustomfiware: Name or > service not known > > at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method) > > at java.net.InetAddress$2.lookupAllHostAddr(InetAddress.java:928) > > at > java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1323) > > at java.net.InetAddress.getLocalHost(InetAddress.java:1500) > > ... 15 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:* Thursday, May 17, 2018 11:27 AM > *To:* 'Portosa Alessandro' <Alessandro.Portosa at eng.it > <mailto:Alessandro.Portosa at eng.it>>; Juanjo Hierro > <juanjose.hierro at fiware.org <mailto:juanjose.hierro at fiware.org>>; Jose > Ignacio Carretero <joseignacio.carretero at fiware.org > <mailto:joseignacio.carretero at fiware.org>>; > fiware-tech-help at lists.fiware.org > <mailto:fiware-tech-help at lists.fiware.org>; Fernando López Aguilar > <fernando.lopez at fiware.org <mailto:fernando.lopez at fiware.org>> > *Cc:* Prashant Chauhan1 <PC00474884 at TechMahindra.com > <mailto:PC00474884 at TechMahindra.com>>; Yugal Kishor Mullick > <YM00106030 at TechMahindra.com <mailto:YM00106030 at TechMahindra.com>>; > Álvaro Arranz <aarranz at ficodes.com <mailto:aarranz at ficodes.com>>; > Francisco de la Vega <fdelavega at ficodes.com > <mailto:fdelavega at ficodes.com>>; Zerbetto Davide > <davide.zerbetto at eng.it <mailto:davide.zerbetto at eng.it>> > *Subject:* RE: [Fiware-tech-help] How to fetch historical data? > > Thanks Alessandro, > > I downloaded “Knowage-6_2_0-RC-CE-Installer-Unix-20180509.zip” and ran > following command. > > sh Knowage-6_2_0-RC-CE-Installer-Unix-20180509.sh –c > > But getting following error. > > In action "Check JAVA_HOME [Run script]" (screen "Display text"), > property "Script": > > java.lang.NullPointerException > > at > com.install4j.script.I4jScript_Internal_4.eval(I4jScript_Internal_4.java:1) > > at > com.install4j.script.I4jScript_Internal_4.evaluate(I4jScript_Internal_4.java:*26) > > at > com.install4j.runtime.installer.helper.Script.evaluate(Script.java:33) > > at > com.install4j.runtime.installer.ContextImpl.runScript(ContextImpl.java:188) > > at > com.install4j.runtime.installer.ContextImpl.runScript(ContextImpl.java:182) > > at > com.install4j.runtime.beans.actions.control.RunScriptAction.execute(RunScriptAction.java:34) > > at > com.install4j.runtime.beans.actions.SystemInstallOrUninstallAction.install(SystemInstallOrUninstallAction.java:29) > > at > com.install4j.runtime.installer.ContextImpl$7.executeAction(ContextImpl.java:1668) > > at > com.install4j.runtime.installer.ContextImpl$7.fetchValue(ContextImpl.java:1659) > > at > com.install4j.runtime.installer.ContextImpl$7.fetchValue(ContextImpl.java:1656) > > at > com.install4j.runtime.installer.helper.comm.actions.FetchObjectAction.execute(FetchObjectAction.java:14) > > at > com.install4j.runtime.installer.helper.comm.HelperCommunication.executeActionDirect(HelperCommunication.java:274) > > at > com.install4j.runtime.installer.helper.comm.HelperCommunication.executeActionInt(HelperCommunication.java:249) > > at > com.install4j.runtime.installer.helper.comm.HelperCommunication.executeActionChecked(HelperCommunication.java:187) > > at > com.install4j.runtime.installer.helper.comm.HelperCommunication.fetchObjectChecked(HelperCommunication.java:170) > > at > com.install4j.runtime.installer.ContextImpl.performActionIntStatic(ContextImpl.java:1656) > > at > com.install4j.runtime.installer.InstallerContextImpl.performActionInt(InstallerContextImpl.java:151) > > at > com.install4j.runtime.installer.ContextImpl.performAction(ContextImpl.java:1103) > > at > com.install4j.runtime.installer.controller.Controller.executeAction(Controller.java:368) > > at > com.install4j.runtime.installer.controller.Controller.executeActions(Controller.java:334) > > at > com.install4j.runtime.installer.controller.Controller.handleCommand(Controller.java:195) > > at > com.install4j.runtime.installer.controller.Controller.start(Controller.java:94) > > at > com.install4j.runtime.installer.Installer.runInProcess(Installer.java:59) > > at > com.install4j.runtime.installer.Installer.main(Installer.java:46) > > 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 com.exe4j.runtime.LauncherEngine.launch(LauncherEngine.java:65) > > at > com.install4j.runtime.launcher.UnixLauncher.main(UnixLauncher.java:57) > > Unable to find environment variable JAVA_HOME, please set it and > restart installer > > My JAVA_HOME already set as shown below. > > Please guide. > > 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:*Portosa Alessandro <Alessandro.Portosa at eng.it > <mailto:Alessandro.Portosa at eng.it>> > *Sent:* Wednesday, May 16, 2018 8:16 PM > *To:* Krishan Babbar <KB00449283 at TechMahindra.com > <mailto:KB00449283 at TechMahindra.com>>; Juanjo Hierro > <juanjose.hierro at fiware.org <mailto:juanjose.hierro at fiware.org>>; Jose > Ignacio Carretero <joseignacio.carretero at fiware.org > <mailto:joseignacio.carretero at fiware.org>>; > fiware-tech-help at lists.fiware.org > <mailto:fiware-tech-help at lists.fiware.org>; Fernando López Aguilar > <fernando.lopez at fiware.org <mailto:fernando.lopez at fiware.org>> > *Cc:* Prashant Chauhan1 <PC00474884 at TechMahindra.com > <mailto:PC00474884 at TechMahindra.com>>; Yugal Kishor Mullick > <YM00106030 at TechMahindra.com <mailto:YM00106030 at TechMahindra.com>>; > Álvaro Arranz <aarranz at ficodes.com <mailto:aarranz at ficodes.com>>; > Francisco de la Vega <fdelavega at ficodes.com > <mailto:fdelavega at ficodes.com>>; Zerbetto Davide > <davide.zerbetto at eng.it <mailto:davide.zerbetto at eng.it>> > *Subject:* Re: [Fiware-tech-help] How to fetch historical data? > > Hi, > > first of all you could use the latest release, which is 6.2.0-RC that > we just released. > > Also, to install it without the GUI, please use the -c option: sh > Knowage-6_1_1-CE-Installer-Unix-20171213.sh *-c* > > *Alessandro Portosa* > Technical Consultant > > 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 > <mailto:KB00449283 at TechMahindra.com>> > *Inviato:* mercoledì 16 maggio 2018 16:39:44 > *A:* Portosa Alessandro; Juanjo Hierro; Jose Ignacio Carretero; > fiware-tech-help at lists.fiware.org > <mailto: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: [Fiware-tech-help] How to fetch historical data? > > Thanks Alessandro, > > Need your guidance for installation and setup of Knowage with MySQL. > > I am using Ubuntu 16.04 (Linux ubuntucustomfiware 4.4.0-119-generic > #143-Ubuntu SMP Mon Apr 2 16:08:24 UTC 2018 x86_64 x86_64 x86_64 > GNU/Linux). > > I have already installed MySQL. > > For Knowage, I downloaded zip file from > http://download.forge.ow2.org/knowage/Knowage-6_1_1-CE-Installer-Unix-20171213.zip > > After unzipping it, there is a .sh file. > > On running this .sh file I am getting following error. > > sh Knowage-6_1_1-CE-Installer-Unix-20171213.sh > > Starting Installer ... > > java.lang.RuntimeException: java.lang.reflect.InvocationTargetException > > at > com.install4j.runtime.installer.Installer.getScreenExecutor(Installer.java:105) > > at > com.install4j.runtime.installer.Installer.runInProcess(Installer.java:58) > > at > com.install4j.runtime.installer.Installer.main(Installer.java:46) > > 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 com.exe4j.runtime.LauncherEngine.launch(LauncherEngine.java:65) > > at > com.install4j.runtime.launcher.UnixLauncher.main(UnixLauncher.java:57) > > Caused by: java.lang.reflect.InvocationTargetException > > at java.awt.EventQueue.invokeAndWait(EventQueue.java:1321) > > at java.awt.EventQueue.invokeAndWait(EventQueue.java:1296) > > at > javax.swing.SwingUtilities.invokeAndWait(SwingUtilities.java:1348) > > at > com.install4j.runtime.installer.Installer.getScreenExecutor(Installer.java:96) > > ... 8 more > > Caused by: java.awt.HeadlessException: > > No X11 DISPLAY variable was set, but this program performed an > operation which requires it. > > at > java.awt.GraphicsEnvironment.checkHeadless(GraphicsEnvironment.java:204) > > at java.awt.Button.<init>(Button.java:152) > > at java.awt.Button.<init>(Button.java:139) > > at > com.install4j.runtime.installer.frontend.WizardScreenExecutor.initAWT(WizardScreenExecutor.java:462) > > at > com.install4j.runtime.installer.frontend.WizardScreenExecutor.<init>(WizardScreenExecutor.java:42) > > at > com.install4j.runtime.installer.frontend.InstallerWizardScreenExecutor.<init>(InstallerWizardScreenExecutor.java:18) > > at > com.install4j.runtime.installer.Installer$2.run(Installer.java:99) > > at > java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:301) > > at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756) > > at java.awt.EventQueue.access$500(EventQueue.java:97) > > at java.awt.EventQueue$3.run(EventQueue.java:709) > > at java.awt.EventQueue$3.run(EventQueue.java:703) > > at java.security.AccessController.doPrivileged(Native Method) > > at > java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80) > > at java.awt.EventQueue.dispatchEvent(EventQueue.java:726) > > at > java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201) > > at > java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116) > > at > java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105) > > at > java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) > > at > java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93) > > at java.awt.EventDispatchThread.run(EventDispatchThread.java:82) > > Could not display the GUI. This application needs access to an X Server. > > ******************************************************************* > > You can also run this application in console mode without > > access to an X server by passing the argument -c > > ******************************************************************* > > Kindly let me know what am I doing wrong? > > Also, how to use existing MySQL server? > > I downloaded “Knowage_6.x_CE_Manual.pdf” file but could not find steps > for installation. > > 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:*Portosa Alessandro <Alessandro.Portosa at eng.it > <mailto:Alessandro.Portosa at eng.it>> > *Sent:* Wednesday, May 16, 2018 1:37 PM > *To:* Krishan Babbar <KB00449283 at TechMahindra.com > <mailto:KB00449283 at TechMahindra.com>>; Juanjo Hierro > <juanjose.hierro at fiware.org <mailto:juanjose.hierro at fiware.org>>; Jose > Ignacio Carretero <joseignacio.carretero at fiware.org > <mailto:joseignacio.carretero at fiware.org>>; > fiware-tech-help at lists.fiware.org > <mailto:fiware-tech-help at lists.fiware.org>; Fernando López Aguilar > <fernando.lopez at fiware.org <mailto:fernando.lopez at fiware.org>> > *Cc:* Prashant Chauhan1 <PC00474884 at TechMahindra.com > <mailto:PC00474884 at TechMahindra.com>>; Yugal Kishor Mullick > <YM00106030 at TechMahindra.com <mailto:YM00106030 at TechMahindra.com>>; > Álvaro Arranz <aarranz at ficodes.com <mailto:aarranz at ficodes.com>>; > Francisco de la Vega <fdelavega at ficodes.com > <mailto:fdelavega at ficodes.com>>; Zerbetto Davide > <davide.zerbetto at eng.it <mailto:davide.zerbetto at eng.it>> > *Subject:* Re: [Fiware-tech-help] How to fetch historical data? > > Dear Krishan, > > you can exploit Knowage with MySQL, CKAN, and several other > datasources: Oracle, SQL Server, HSQL, MySQL, PostgreSQL, Ingres, DB2, > AS400, Impala, Hive, Cassandra, SparkSQL. > > You can also exploit data directly from the Context Broker as well as > with a REST service or a simply CSV/XLS file. > > You can have a look at the PDF version of our community documentation, > which BTW I'm happy to say that will be published also on > readthedocs in a really short time. > > *Alessandro Portosa* > Technical Consultant > > 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 > <mailto:KB00449283 at TechMahindra.com>> > *Inviato:* mercoledì 16 maggio 2018 08:00:52 > *A:* Juanjo Hierro; Jose Ignacio Carretero; > fiware-tech-help at lists.fiware.org > <mailto:fiware-tech-help at lists.fiware.org>; Fernando López Aguilar > *Cc:* Prashant Chauhan1; Yugal Kishor Mullick; Álvaro Arranz; > Francisco de la Vega; Portosa Alessandro; Zerbetto Davide > *Oggetto:* RE: [Fiware-tech-help] How to fetch historical data? > > Hi Juanjo, > > In initial understanding of ‘Knowage’, it seems it works with CKAN. Am > I right? > > Actually, I was using MySQL with Cygnus, so is it possible to use > Knowage MySQL? > > I tried using CKAN with Cygnus but on installing CKAN > (http://docs.ckan.org/en/ckan-2.7.3/maintaining/installing/install-from-source.html#install-the-required-packages) > I am getting following issue. > > Please suggest. > > Thanks & Regards, > > *_Krishan Babbar_* > > ============================================================================================================================ > 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:*Juanjo Hierro <juanjose.hierro at fiware.org > <mailto:juanjose.hierro at fiware.org>> > *Sent:* Monday, May 14, 2018 1:30 PM > *To:* Krishan Babbar <KB00449283 at TechMahindra.com > <mailto:KB00449283 at TechMahindra.com>>; Jose Ignacio Carretero > <joseignacio.carretero at fiware.org > <mailto:joseignacio.carretero at fiware.org>>; > fiware-tech-help at lists.fiware.org > <mailto:fiware-tech-help at lists.fiware.org>; Fernando López Aguilar > <fernando.lopez at fiware.org <mailto:fernando.lopez at fiware.org>> > *Cc:* Prashant Chauhan1 <PC00474884 at TechMahindra.com > <mailto:PC00474884 at TechMahindra.com>>; Yugal Kishor Mullick > <YM00106030 at TechMahindra.com <mailto:YM00106030 at TechMahindra.com>>; > Álvaro Arranz <aarranz at ficodes.com <mailto:aarranz at ficodes.com>>; > Francisco de la Vega <fdelavega at ficodes.com > <mailto:fdelavega at ficodes.com>>; Alessandro Portosa > <alessandro.portosa at eng.it <mailto:alessandro.portosa at eng.it>>; Davide > Zerbetto <davide.zerbetto at eng.it <mailto:davide.zerbetto at eng.it>> > *Subject:* Re: [Fiware-tech-help] How to fetch historical data? > > Dear Krishan, > > GUIs of applications tend to be tailor-made. Nevertheless, I will > try to give you some hints that I hope can be useful: > > * Knowage <https://github.com/KnowageLabs/Knowage-Server> is a very > complete business intelligence tool that comprises many functions > including those for producing reports on historic data which has > beeen stored in data-sinks using Cygnus. It also include some > functions for creating dashboards. > * Operational dashboards which query directly on the Orion Context > Broker or some other data services can also be based on Wirecloud > <https://github.com/Wirecloud/wirecloud>. > * STH-Comet <https://github.com/telefonicaid/fiware-sth-comet> can > be used to store raw and aggregated time series context > information in MongoDB which then you can get access to using an API > * You can also use QuantumLeap > <https://smartsdk.github.io/ngsi-timeseries-api/> for transferring > historic data into time series databases and then use some GUI > tools for visualizing data (e.g., Grafana). This is useful is > some use cases. > > I add people from the Eng and FICodes teams in case they want to add > something regarding Knowage and Wirecloud. > > Let us know if these hints bring answer to your questions. > > I would like to take advantage of this mail to let you know that we > have re-structure contents of the FIWARE developers' page > <https://developer.fiware.org/> and the FIWARE Catalogue > <https://www.fiware.org/developers/catalogue/>. We will continue > working on improving it based on feedback. > > Cheers, > > Juanjo > > On 14/05/2018 08:45, Krishan Babbar wrote: > > Any input? > > 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 11, 2018 2:40 PM > *To:* Jose Ignacio Carretero <joseignacio.carretero at fiware.org> > <mailto:joseignacio.carretero at fiware.org> > *Cc:* fiware-tech-help at lists.fiware.org > <mailto:fiware-tech-help at lists.fiware.org>; Fernando López Aguilar > <fernando.lopez at fiware.org> <mailto:fernando.lopez at fiware.org>; > Yugal Kishor Mullick <YM00106030 at TechMahindra.com> > <mailto:YM00106030 at TechMahindra.com>; PC00474884 at TechMahindra.com > <mailto:PC00474884 at TechMahindra.com> > *Subject:* How to fetch historical data? > > Hi Jose, > > Thanks for all your support so far. > > I have setup Cygnus with MySQL agent and now data is storing into > MySQL. > > As a next step, we need to show reports of historical data (Saved > in Cygnus_MySQL) in GUI. It may be based upon some filters like > data for today, last week/month, area wise etc. > > My questions are > > 1.Do we need to create our own APIs for fetching data from MySQL > and returning to GUI application? > > 2.Or is there any GUI component (WireCloud or any other) in which > we can directly fetch Cygnus Data? Or we need to create our custom > GUI ourselves? > > 3.I found a component STH-Comet > (https://github.com/telefonicaid/fiware-sth-comet), will it fit in > our requirements for fetching Cygnus_MySQL data? > > 4.Do let me know if Fiware have any other components matching with > our requirement. > > 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. > =========================================================================================================================== > > ============================================================================================================================ > > 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. > > ============================================================================================================================ > > __________________________________________________________________________________________ > > > > You can get more information about our cookies and privacy policies on the following links: > > -http://forge.fiware.org/plugins/mediawiki/wiki/fiware/index.php/FIWARE_Privacy_Policy > > -http://forge.fiware.org/plugins/mediawiki/wiki/fiware/index.php/Cookies_Policy_FIWARE > > > > Fiware-tech-help mailing list > > Fiware-tech-help at lists.fiware.org > <mailto:Fiware-tech-help at lists.fiware.org> > > https://lists.fiware.org/listinfo/fiware-tech-help > > > -- −−− José Ignacio Carretero FIWARE Cloud and Platform Expert FIWARE Foundation FIWARE Foundation Franklinstrasse 13A 10587 Berlin email: joseignacio.carretero at fiware.org <mailto:joseignacio.carretero at fiware.org> www: http://fiware.org twitter: @jicarreterogu @FIWARE skype: jicarretero -------------- next part -------------- An HTML attachment was scrubbed... URL: <https://lists.fiware.org/private/fiware-tech-help/attachments/20180517/6baf84d2/attachment-0001.html> -------------- next part -------------- A non-text attachment was scrubbed... Name: Outlook-1513603850.png Type: image/png Size: 3338 bytes Desc: not available URL: <https://lists.fiware.org/private/fiware-tech-help/attachments/20180517/6baf84d2/attachment-0007.png> -------------- next part -------------- A non-text attachment was scrubbed... Name: image001.png Type: image/png Size: 29109 bytes Desc: not available URL: <https://lists.fiware.org/private/fiware-tech-help/attachments/20180517/6baf84d2/attachment-0008.png> -------------- next part -------------- A non-text attachment was scrubbed... Name: image003.png Type: image/png Size: 38475 bytes Desc: not available URL: <https://lists.fiware.org/private/fiware-tech-help/attachments/20180517/6baf84d2/attachment-0009.png> -------------- next part -------------- A non-text attachment was scrubbed... Name: image002.png Type: image/png Size: 3338 bytes Desc: not available URL: <https://lists.fiware.org/private/fiware-tech-help/attachments/20180517/6baf84d2/attachment-0010.png> -------------- next part -------------- A non-text attachment was scrubbed... Name: image004.png Type: image/png Size: 10434 bytes Desc: not available URL: <https://lists.fiware.org/private/fiware-tech-help/attachments/20180517/6baf84d2/attachment-0011.png> -------------- next part -------------- A non-text attachment was scrubbed... Name: image005.png Type: image/png Size: 19913 bytes Desc: not available URL: <https://lists.fiware.org/private/fiware-tech-help/attachments/20180517/6baf84d2/attachment-0012.png> -------------- next part -------------- A non-text attachment was scrubbed... Name: Foundation-31B.png Type: image/png Size: 251283 bytes Desc: not available URL: <https://lists.fiware.org/private/fiware-tech-help/attachments/20180517/6baf84d2/attachment-0013.png>
You can get more information about our cookies and privacy policies clicking on the following links: Privacy policy Cookies policy