Hi, You can review the following section of the QUICKSTART document on how to configured pmbmpd to collect BMP data and send it to a Kafka broker:
https://github.com/pmacct/pmacct/blob/1.7.4/QUICKSTART#L2226-#L2378 Once data is in Kafka in JSON format you can choose what to do with it: you can Google how to import it in MySQL via a connector; or you can use perhaps more suited Big Data tools for the task, like ElasticSearch or Apache Druid. Alternatively to Kafka, should you not be familiar with the tool, you can save data in JSON format to files. Paolo On Mon, Mar 30, 2020 at 03:04:39PM +0200, Abdul Rahim barry wrote: > Hello everyone > I am working on my end of study project, I would like to collect BMP > (Protocol Monnitoring BGP) data > Here is the content of my pmbmp.conf file > > ! > daemonize: true > pidfile: /var/pmbmpd.pid > syslog:daemon > aggregate: src_host, as_path, peer_src_ip, peer_dst_ip, peer_src_as, > peer_dst_as, local_pref, sum_net, sum_as > pcap_filter: net 10.75.9.4 > interface: lo > plugins: mysql > sql_host: localhost > sql_passwd: <pmacct-create-db_bgp_v1.mysql > sql_refresh_time:60 > sql_history: 1h > sql_history_roundoff: mhd > sql_table_version: 1 > ! > > I would like to know: > 1- how to recover BMP data > 2- how to feed the database (mysql) with BMP data > > thank you in advance for your help > I am in a hurry so that I can move forward thank you. > > Le jeu. 26 mars 2020 à 14:05, Paolo Lucente <pa...@pmacct.net> a écrit : > > > > > Hi, > > > > You need to compile pmacct with MySQL support, --enable-mysql. You may > > profit from the following section of the QUICKSTART document: > > > > https://github.com/pmacct/pmacct/blob/1.7.4/QUICKSTART#L109-#L167 > > > > Bu perhaps the whole chapter I and II are good readings to start. > > > > Paolo > > > > On Wed, Mar 25, 2020 at 04:25:14PM +0100, Abdul Rahim barry wrote: > > > Bonjour tout le monde > > > Je travail sur mon projet de stage de fin cycle, le but est de collecté > > les > > > routes bgp et de les stocké dans une base de donnée mysql. > > > Selon mes recherches pmacct peut le faire, j’ai installé pmacct sur un > > > sever Ubuntu, j’ai configuré le fichier nfacct.conf. > > > En compilant: pmacctd -f /etc/pmacct/pmacctd.com . > > > J’ai cette erreur : > > > ERROR: (/etc/pmacctd/pmacctd.conf) Unknown plug-in type: mysql. Ignoring. > > > WARN: (/etc/pmacctd/pmacctd.conf) No plug-in has been activated; > > > defaulting to in memory table. > > > Je besoin de votre aide, je sais pas quoi faire. > > > Merci d’avance pour votre aide > > > > > _______________________________________________ > > > pmacct-discussion mailing list > > > http://www.pmacct.net/#mailinglists > > > > > > _______________________________________________ > > pmacct-discussion mailing list > > http://www.pmacct.net/#mailinglists _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
