Re: [pmacct-discussion] Besoin d’aide: Unknown plug-in type: mysql. Ignoring, No plug-in has been activated; defaulting to in memory table.

2020-03-31 Thread Paolo Lucente

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

Re: [pmacct-discussion] Besoin d’aide: Unknown plug-in type: mysql. Ignoring, No plug-in has been activated; defaulting to in memory table.

2020-03-30 Thread Abdul Rahim barry
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:  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

Re: [pmacct-discussion] Besoin d’aide: Unknown plug-in type: mysql. Ignoring, No plug-in has been activated; defaulting to in memory table.

2020-03-26 Thread Paolo Lucente

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