[Fiware-tech-help] Unable to run Cygnus with MySQL agent

José Ignacio Carretero joseignacio.carretero at fiware.org
Fri May 4 10:48:53 CEST 2018


I've answered the Stackoverflow question.

Regards,
José Ignacio


El 03/05/18 a las 15:37, Krishan Babbar escribió:
>
> + pablo.coellovillalba at telefonica.com 
> <mailto:pablo.coellovillalba at telefonica.com>
>
> + fermin.galanmarquez at telefonica.com 
> <mailto:fermin.galanmarquez at telefonica.com>
>
> +francisco.romerobueno at telefonica.com 
> <mailto:francisco.romerobueno at telefonica.com>
>
> + german.torodelvalle at telefonica.com 
> <mailto:german.torodelvalle at telefonica.com>
>
> + ivan.ariasleon at telefonica.com <mailto:ivan.ariasleon at telefonica.com>
>
> Looking forward for your guidance.
>
> Asked the same question on 
> https://ask.fiware.org/question/989/unable-to-run-cygnus-with-mysql-agent/ 
> and 
> https://stackoverflow.com/questions/50102920/unable-to-run-cygnus-with-mysql-agent 
> also.
>
> Regards,
>
> Krishan
>
> *From:* Krishan Babbar
> *Sent:* Monday, April 30, 2018 7:59 PM
> *To:* fiware-tech-help at lists.fiware.org; José Ignacio Carretero 
> <joseignacio.carretero at fiware.org>; herman.junge at telefonica.com
> *Cc:* Yugal Kishor Mullick <YM00106030 at TechMahindra.com>
> *Subject:* Unable to run Cygnus with MySQL agent
>
> Hi All,
>
> I am trying to setup and understand Cygnus. But I am facing issue 
> during installation.
>
> I followed below given steps.
>
> 1.Install Cygnus using Docker (docker run -d -p 5050:5050 -p 8081:8081 
> fiware/cygnus-common)
>
> 2.Executed version command (curl http://172.17.0.2:8081/v1/version 
> <http://172.17.0.2:8081/v1/version>) which gave following response
>
> a.{"success":"true","version":"1.8.0_SNAPSHOT.39b2aa4789c61fa92fe6edc905410f1ddeb33490"}
>
> 3.Login into Cygnus container using command docker exec -it 
> <ContainerId> /bin/bash
>
> 4.Created new file named “agent_mysql.conf” in 
> “/opt/apache-flume/conf/” folder. Please see attached file for 
> configuration details.
>
> 5.Changed "cygnus-entrypoint.sh" file in / (root) folder and added 
> following command by removing existing one.
>
> a.${FLUME_HOME}/bin/cygnus-flume-ng agent --conf ${CYGNUS_CONF_PATH} 
> -f ${CYGNUS_CONF_PATH}/agent_mysql.conf -n cygnus-ngsi -p 
> ${CYGNUS_API_PORT} 
> -Dflume.root.logger=${CYGNUS_LOG_LEVEL},${CYGNUS_LOG_APPENDER} 
> -Dfile.encoding=UTF-8
>
> 6.Exited Docker container and came back to Ubuntu.
>
> 7.Stop and restart Docker container.
>
> 8.And I am getting following errors in logs
>
> Please check and let me know what am I doing wrong? Appreciate your help.
>
> n$AgentConfiguration[1016] : Processing:mysql-sink
>
> time=2018-04-30T14:24:00.807Z | lvl=INFO | corr=N/A | trans=N/A | 
> srv=N/A | subsrv=N/A | comp=cygnus-ngsi | op=validateConfiguration | 
> msg=org.apache.flume.conf.FlumeConfiguration[140] : Post-validation 
> flume configuration contains configuration for agents: [cygnus-ngsi]
>
> time=2018-04-30T14:24:00.808Z | lvl=INFO | corr=N/A | trans=N/A | 
> srv=N/A | subsrv=N/A | comp=cygnus-ngsi | op=loadChannels | 
> msg=org.apache.flume.node.AbstractConfigurationProvider[150] : 
> Creating channels
>
> time=2018-04-30T14:24:00.816Z | lvl=INFO | corr=N/A | trans=N/A | 
> srv=N/A | subsrv=N/A | comp=cygnus-ngsi | op=create | 
> msg=org.apache.flume.channel.DefaultChannelFactory[40] : Creating 
> instance of channel mysql-channel type memory
>
> time=2018-04-30T14:24:00.825Z | lvl=INFO | corr=N/A | trans=N/A | 
> srv=N/A | subsrv=N/A | comp=cygnus-ngsi | op=loadChannels | 
> msg=org.apache.flume.node.AbstractConfigurationProvider[205] : Created 
> channel mysql-channel
>
> time=2018-04-30T14:24:00.832Z | lvl=INFO | corr=N/A | trans=N/A | 
> srv=N/A | subsrv=N/A | comp=cygnus-ngsi | op=create | 
> msg=org.apache.flume.source.DefaultSourceFactory[39] : Creating 
> instance of source http-source, type 
> org.apache.flume.source.http.HTTPSource
>
> time=2018-04-30T14:24:00.836Z | lvl=ERROR | corr=N/A | trans=N/A | 
> srv=N/A | subsrv=N/A | comp=cygnus-ngsi | op=configure | 
> msg=org.apache.flume.source.http.HTTPSource[113] : Error while 
> configuring HTTPSource. Exception follows.
>
> java.lang.ClassNotFoundException: 
> com.telefonica.iot.cygnus.handlers.NGSIRestHandler
>
>         at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
>
>         at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
>
>         at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:338)
>
>         at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
>
>         at java.lang.Class.forName0(Native Method)
>
>         at java.lang.Class.forName(Class.java:264)
>
>         at 
> org.apache.flume.source.http.HTTPSource.configure(HTTPSource.java:102)
>
>         at 
> org.apache.flume.conf.Configurables.configure(Configurables.java:41)
>
>         at 
> org.apache.flume.node.AbstractConfigurationProvider.loadSources(AbstractConfigurationProvider.java:331)
>
>         at 
> org.apache.flume.node.AbstractConfigurationProvider.getConfiguration(AbstractConfigurationProvider.java:102)
>
>         at 
> org.apache.flume.node.PollingPropertiesFileConfigurationProvider$FileWatcherRunnable.run(PollingPropertiesFileConfigurationProvider.java:140)
>
>         at 
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
>
>         at 
> java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
>
>         at 
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
>
>         at 
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
>
>         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)
>
> time=2018-04-30T14:24:00.840Z | lvl=ERROR | corr=N/A | trans=N/A | 
> srv=N/A | subsrv=N/A | comp=cygnus-ngsi | op=loadSources | 
> msg=org.apache.flume.node.AbstractConfigurationProvider[366] : Source 
> http-source has been removed due to an error during configuration
>
> java.lang.RuntimeException: java.lang.ClassNotFoundException: 
> com.telefonica.iot.cygnus.handlers.NGSIRestHandler
>
>         at 
> com.google.common.base.Throwables.propagate(Throwables.java:156)
>
>         at 
> org.apache.flume.source.http.HTTPSource.configure(HTTPSource.java:114)
>
>         at 
> org.apache.flume.conf.Configurables.configure(Configurables.java:41)
>
>         at 
> org.apache.flume.node.AbstractConfigurationProvider.loadSources(AbstractConfigurationProvider.java:331)
>
>         at 
> org.apache.flume.node.AbstractConfigurationProvider.getConfiguration(AbstractConfigurationProvider.java:102)
>
>         at 
> org.apache.flume.node.PollingPropertiesFileConfigurationProvider$FileWatcherRunnable.run(PollingPropertiesFileConfigurationProvider.java:140)
>
>         at 
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
>
>         at 
> java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
>
>         at 
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
>
>         at 
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
>
>         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.ClassNotFoundException: 
> com.telefonica.iot.cygnus.handlers.NGSIRestHandler
>
>         at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
>
>         at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
>
>         at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:338)
>
>         at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
>
>         at java.lang.Class.forName0(Native Method)
>
>         at java.lang.Class.forName(Class.java:264)
>
>         at 
> org.apache.flume.source.http.HTTPSource.configure(HTTPSource.java:102)
>
>         ... 11 more
>
> time=2018-04-30T14:24:00.841Z | lvl=INFO | corr=N/A | trans=N/A | 
> srv=N/A | subsrv=N/A | comp=cygnus-ngsi | op=create | 
> msg=org.apache.flume.sink.DefaultSinkFactory[40] : Creating instance 
> of sink: mysql-sink, type: com.telefonica.iot.cygnus.sinks.NGSIMySQLSink
>
> time=2018-04-30T14:24:00.842Z | lvl=ERROR | corr=N/A | trans=N/A | 
> srv=N/A | subsrv=N/A | comp=cygnus-ngsi | op=run | 
> msg=org.apache.flume.node.PollingPropertiesFileConfigurationProvider$FileWatcherRunnable[142] 
> : Failed to load configuration data. Exception follows.
>
> org.apache.flume.FlumeException: Unable to load sink type: 
> com.telefonica.iot.cygnus.sinks.NGSIMySQLSink, class: 
> com.telefonica.iot.cygnus.sinks.NGSIMySQLSink
>
>         at 
> org.apache.flume.sink.DefaultSinkFactory.getClass(DefaultSinkFactory.java:69)
>
>         at 
> org.apache.flume.sink.DefaultSinkFactory.create(DefaultSinkFactory.java:41)
>
>         at 
> org.apache.flume.node.AbstractConfigurationProvider.loadSinks(AbstractConfigurationProvider.java:415)
>
>         at 
> org.apache.flume.node.AbstractConfigurationProvider.getConfiguration(AbstractConfigurationProvider.java:103)
>
>         at 
> org.apache.flume.node.PollingPropertiesFileConfigurationProvider$FileWatcherRunnable.run(PollingPropertiesFileConfigurationProvider.java:140)
>
>         at 
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
>
>         at 
> java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
>
>         at 
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
>
>         at 
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
>
>         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.ClassNotFoundException: 
> com.telefonica.iot.cygnus.sinks.NGSIMySQLSink
>
>         at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
>
>         at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
>
>         at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:338)
>
>         at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
>
>         at java.lang.Class.forName0(Native Method)
>
>         at java.lang.Class.forName(Class.java:264)
>
>         at 
> org.apache.flume.sink.DefaultSinkFactory.getClass(DefaultSinkFactory.java:67)
>
>         ... 11 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.
> ===========================================================================================================================
>
> ============================================================================================================================
>
> 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.
>
> ============================================================================================================================
>

-- 
−−−
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/20180504/1636ae72/attachment-0001.html>
-------------- 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/20180504/1636ae72/attachment-0001.png>


More information about the Fiware-tech-help mailing list

You can get more information about our cookies and privacy policies clicking on the following links: Privacy policy   Cookies policy