[pmacct-discussion] Updating Timestamps without historical accounting
Hi, I want to do accounting in which timestamp is updated at sql_refresh interval. (No historical accounting) Following is the pmacctd configuration, --- interface: ens32 debug: true snaplen: 1500 plugins: mysql[in], mysql[out] aggregate[in]: dst_host aggregate[out]: src_host plugin_buffer_size: 20480 plugin_pipe_size: 2048000 ! My SQL sql_optimize_clauses: true sql_db: pmacct sql_refresh_time: 6 sql_passwd: tmfsr82 sql_user: root sql_table[in]: acct_in sql_table[out]: acct_out --- I have gone through the README.timestamp document. But, I haven't found any configuration to do that. Can anyone help me on this ? Regards, Mehul ___ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
[pmacct-discussion] Traffic accounting of BGP Subnets and Hosts
Hi, My requirement is to do accounting of BGP Subnets which are logged by BGP daemon in PMacct. Also, I want to do accounting of individual hosts with the BGP subnet associations. I have configured BGP deamon in PMacct and it is logging BGP routes in a json file. I need a configuration to do accounting of the logged BGP routes and other hosts associated with this subnet. Is this possible ? Regards, Mehul ___ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
[pmacct-discussion] PMacct with RADIUS Client
Hi, I have configured PMacct to dump BGP routes in a text file (i.e. Json format). My requirement is to send RADIUS requests like RADIUS Access Request, RADIUS Accounting Start etc. from PMacct when any BGP routes are added / deleted. How can I integrate RADIUS client to achieve the same? Is this configuration available in PMacct? Regards, Mehul ___ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
Re: [pmacct-discussion] Configure with MySQL / MariaDB support
Hi, In my Ubuntu machine where pmacct is working with MySQL /usr/lib/x86_64-linux-gnu/libmysqlclient.so -> libmysqlclient.so.18 /usr/lib/x86_64-linux-gnu/libmysqlclient.so.18 -> libmysqlclient.so.18.0.0 /usr/lib/x86_64-linux-gnu/libmysqlclient.so.18.0.0 In your machine, libmysqlclient.so (libc6,x86-64) => /lib64/libmysqlclient.so Can you check soft links, whether it's pointing to proper .so file ? -Original Message- From: pmacct-discussion [mailto:pmacct-discussion-boun...@pmacct.net] On Behalf Of Yann Belin Sent: Tuesday, December 13, 2016 3:07 PM To: pmacct-discussion@pmacct.net Subject: Re: [pmacct-discussion] Configure with MySQL / MariaDB support Hi Mehul, It didn't help. could it be a mysql-specific issue (e.g. version)? For instance ./configure is able to find the pcap libraries under the same location (/usr/lib64/) with no problems. [root@ pmacct-1.6.1]# export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib64/ [root@ pmacct-1.6.1]# echo $LD_LIBRARY_PATH :/usr/lib64/ [root@ pmacct-1.6.1]# ./configure --enable-mysql (...) checking default locations for pcap.h... found in /usr/include checking default locations for libpcap... no checking for pcap_dispatch in -lpcap... yes checking for pcap_setnonblock in -lpcap... yes checking for bpf_filter in -lpcap... yes checking packet capture type... linux checking whether to enable MySQL support... yes checking for mysql_config... mysql_config checking for mysql_init in -lmysqlclient... no configure: error: ERROR: missing MySQL client library [root@ pmacct-1.6.1]# Kind regards, Yann On Tue, Dec 13, 2016 at 10:22 AM, Mehul Prajapati <mehul.prajap...@mobileinternet.com> wrote: > Hi, > > I think your environment variable LD_LIBRARY_PATH is not pointing to > /usr/lib64/ directory. > > Please run following command and try. > > $ export LD_LIBRARY_PATH=$LD_LIBRARY_PATH: /usr/lib64/ > > -Original Message- > From: pmacct-discussion [mailto:pmacct-discussion-boun...@pmacct.net] > On Behalf Of Yann Belin > Sent: Tuesday, December 13, 2016 2:47 PM > To: pmacct-discussion@pmacct.net > Subject: [pmacct-discussion] Configure with MySQL / MariaDB support > > Hello, > > I am trying to install pmacct with MySQL / MariaDB support but [./configure > --enable-mysql] fails with the message below. > > *-*-*-*-* > (...) > checking for mysql_init in -lmysqlclient... no > configure: error: ERROR: missing MySQL client library > *-*-*-*-* > > I have proper libraries and devel packages installed, any idea what may be > causing this? > > [root@ pmacct-1.6.1]# locate libmysqlclient > /usr/lib64/libmysqlclient.so > /usr/lib64/libmysqlclient.so.15 > /usr/lib64/libmysqlclient.so.15.0.0 > /usr/lib64/libmysqlclient.so.16 > /usr/lib64/libmysqlclient.so.16.0.0 > /usr/lib64/libmysqlclient.so.18 > /usr/lib64/libmysqlclient.so.18.0.0 > /usr/lib64/libmysqlclient_r.so > /usr/lib64/libmysqlclient_r.so.15 > /usr/lib64/libmysqlclient_r.so.15.0.0 > /usr/lib64/libmysqlclient_r.so.16 > /usr/lib64/libmysqlclient_r.so.16.0.0 > /usr/lib64/libmysqlclient_r.so.18 > /usr/lib64/libmysqlclient_r.so.18.0.0 > > [root@ pmacct-1.6.1]# ldconfig -p | grep mysqlclient > libmysqlclient_r.so.16 (libc6,x86-64) => /lib64/libmysqlclient_r.so.16 > libmysqlclient_r.so.15 (libc6,x86-64) => /lib64/libmysqlclient_r.so.15 > libmysqlclient.so.18 (libc6,x86-64) => /lib64/libmysqlclient.so.18 > libmysqlclient.so.16 (libc6,x86-64) => /lib64/libmysqlclient.so.16 > libmysqlclient.so.15 (libc6,x86-64) => /lib64/libmysqlclient.so.15 > libmysqlclient.so (libc6,x86-64) => /lib64/libmysqlclient.so > > [root@ pmacct-1.6.1]# rpm -qa | grep -i maria > MariaDB-devel-10.0.28-1.el7.centos.x86_64 > MariaDB-client-10.0.27-1.el7.centos.x86_64 > MariaDB-compat-10.0.27-1.el7.centos.x86_64 > MariaDB-connect-engine-10.0.28-1.el7.centos.x86_64 > MariaDB-common-10.0.27-1.el7.centos.x86_64 > MariaDB-server-10.0.27-1.el7.centos.x86_64 > MariaDB-shared-10.0.27-1.el7.centos.x86_64 > [root@scrutinizer01 pmacct-1.6.1]# > > Thanks in advance! > > > Yann > > ___ > 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 ___ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
Re: [pmacct-discussion] Configure with MySQL / MariaDB support
Hi, I think your environment variable LD_LIBRARY_PATH is not pointing to /usr/lib64/ directory. Please run following command and try. $ export LD_LIBRARY_PATH=$LD_LIBRARY_PATH: /usr/lib64/ -Original Message- From: pmacct-discussion [mailto:pmacct-discussion-boun...@pmacct.net] On Behalf Of Yann Belin Sent: Tuesday, December 13, 2016 2:47 PM To: pmacct-discussion@pmacct.net Subject: [pmacct-discussion] Configure with MySQL / MariaDB support Hello, I am trying to install pmacct with MySQL / MariaDB support but [./configure --enable-mysql] fails with the message below. *-*-*-*-* (...) checking for mysql_init in -lmysqlclient... no configure: error: ERROR: missing MySQL client library *-*-*-*-* I have proper libraries and devel packages installed, any idea what may be causing this? [root@ pmacct-1.6.1]# locate libmysqlclient /usr/lib64/libmysqlclient.so /usr/lib64/libmysqlclient.so.15 /usr/lib64/libmysqlclient.so.15.0.0 /usr/lib64/libmysqlclient.so.16 /usr/lib64/libmysqlclient.so.16.0.0 /usr/lib64/libmysqlclient.so.18 /usr/lib64/libmysqlclient.so.18.0.0 /usr/lib64/libmysqlclient_r.so /usr/lib64/libmysqlclient_r.so.15 /usr/lib64/libmysqlclient_r.so.15.0.0 /usr/lib64/libmysqlclient_r.so.16 /usr/lib64/libmysqlclient_r.so.16.0.0 /usr/lib64/libmysqlclient_r.so.18 /usr/lib64/libmysqlclient_r.so.18.0.0 [root@ pmacct-1.6.1]# ldconfig -p | grep mysqlclient libmysqlclient_r.so.16 (libc6,x86-64) => /lib64/libmysqlclient_r.so.16 libmysqlclient_r.so.15 (libc6,x86-64) => /lib64/libmysqlclient_r.so.15 libmysqlclient.so.18 (libc6,x86-64) => /lib64/libmysqlclient.so.18 libmysqlclient.so.16 (libc6,x86-64) => /lib64/libmysqlclient.so.16 libmysqlclient.so.15 (libc6,x86-64) => /lib64/libmysqlclient.so.15 libmysqlclient.so (libc6,x86-64) => /lib64/libmysqlclient.so [root@ pmacct-1.6.1]# rpm -qa | grep -i maria MariaDB-devel-10.0.28-1.el7.centos.x86_64 MariaDB-client-10.0.27-1.el7.centos.x86_64 MariaDB-compat-10.0.27-1.el7.centos.x86_64 MariaDB-connect-engine-10.0.28-1.el7.centos.x86_64 MariaDB-common-10.0.27-1.el7.centos.x86_64 MariaDB-server-10.0.27-1.el7.centos.x86_64 MariaDB-shared-10.0.27-1.el7.centos.x86_64 [root@scrutinizer01 pmacct-1.6.1]# Thanks in advance! Yann ___ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists ___ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
[pmacct-discussion] Historical accounting for 6 seconds
Hi, I want to do real time accounting. I can see that sql_history parameter governs the time-bins. I am getting error when configuring it to 6. However, for value 60 it is working fine. My requirement is to get accounting entry in MySQL every 6 seconds. Is there any configuration to achieve it ? Regards, Mehul Mehul Prajapati ___ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
Re: [pmacct-discussion] Dynamic filtering of packets
Hi Mario, I want to make configuration in PMacct for my requirement. Let me reframe this question. -I get triggering message in PMacct (e.g. from TCP/UDP port). -I decode the message. -I get an IP address and database logging on/off information. If I get logging ON for an IP address then I want to make its entry in MySQL and start accounting. If I get logging OFF for an IP address then I want to stop accounting for that IP. I will ignore accounting for all other packets for which logging ON information is not received. Is there any configuration to start/stop accounting at run time ? From: pmacct-discussion [mailto:pmacct-discussion-boun...@pmacct.net] On Behalf Of Jentsch, Mario Sent: Tuesday, July 26, 2016 8:46 PM To: pmacct-discussion@pmacct.net Subject: Re: [pmacct-discussion] Dynamic filtering of packets The mentioned user groups need to be build when the user authenticates and get the IP address assigned. This is most probably done in your Radius configuration and not in pmacct. Regards, Mario From: pmacct-discussion [mailto:pmacct-discussion-boun...@pmacct.net] On Behalf Of Mehul Prajapati Sent: Tuesday, July 26, 2016 3:21 PM To: pmacct-discussion@pmacct.net<mailto:pmacct-discussion@pmacct.net> Subject: Re: [pmacct-discussion] Dynamic filtering of packets Hi, RADIUS packets are received on port 1812 & 1813. I am decoding RADIUS packet in core process and then I get Accounting ON/OFF information in payload of packet. I like your suggestion of user groups. How can I configure user groups in PMacct ? Is there any provision such that this Accounting ON/OFF requests configuration can be changes at run time ? From: pmacct-discussion [mailto:pmacct-discussion-boun...@pmacct.net] On Behalf Of Jentsch, Mario Sent: Tuesday, July 26, 2016 6:18 PM To: pmacct-discussion@pmacct.net<mailto:pmacct-discussion@pmacct.net> Subject: Re: [pmacct-discussion] Dynamic filtering of packets Hi Mehul. the way you detect "Accounting ON/OFF" in pmacct affects possible recommendations. Same applies to other preconditions/requirements you may have. If we don't need to care about them I would think you can filter out all IPs that you don't want accounting enabled for - this assumes there is no dynamic assignment from users to IP addresses. With such a dynamic assignment a solution could be: assign the user groups ("accounting on" vs "accounting off") different IP blocks and have pmacct collect the data only for the IP block for users with "accounting on". In case your situation is more complicated and you can't take one of these ways it is helpful to know how you "receive some event i.e. Accounting ON in PMacct" and process it. Depending on if you're allowed to keep data about users with "accounting off" you also may solve it on MySQL side (presuming this is your data store). Receiving an "accounting on" you put the user/IP address for it in table1. Accounting data for this IP address is only stored in table2 if an appropriate entry in table1 is there. Receiving an "accounting off" you remove user/IP address for it in table1 and if required all appropriate entries from table2. This behavior should be possible with DB triggers / helper table. Regards, Mario From: pmacct-discussion [mailto:pmacct-discussion-boun...@pmacct.net] On Behalf Of Mehul Prajapati Sent: Tuesday, July 26, 2016 11:48 AM To: pmacct-discussion@pmacct.net<mailto:pmacct-discussion@pmacct.net> Subject: Re: [pmacct-discussion] Dynamic filtering of packets Hi Mario, Remote Authentication Dial-In User Service (RADIUS) is a networking protocol<https://en.wikipedia.org/wiki/Communications_protocol> that provides centralized Authentication, Authorization, and Accounting (AAA<https://en.wikipedia.org/wiki/AAA_protocol>) management for users who connect and use a network service. You can ignore the RADIUS decoding part. Requirement: I want to do accounting for only selective users/IP addresses. Let say, I receive some event i.e. Accounting ON in PMacct. Now, processing this event, I want to start accounting for only this IP address/user. After some time, I receive Accounting OFF event in PMacct. Now, processing this event, I want to stop accounting for only this IP address/user. Is there any mechanism to achieve it ? From: pmacct-discussion [mailto:pmacct-discussion-boun...@pmacct.net] On Behalf Of Jentsch, Mario Sent: Tuesday, July 26, 2016 2:55 PM To: pmacct-discussion@pmacct.net<mailto:pmacct-discussion@pmacct.net> Subject: Re: [pmacct-discussion] Dynamic filtering of packets Hi Mehul, > I have explored about "refresh_maps" config key. > If I use it, then I need to make changes in map file at run time. that is working fine in one of our setups. We detect changes in the network, re-create the map file and have the daemon reload it without restart. > But, I want
Re: [pmacct-discussion] Dynamic filtering of packets
Hi, RADIUS packets are received on port 1812 & 1813. I am decoding RADIUS packet in core process and then I get Accounting ON/OFF information in payload of packet. I like your suggestion of user groups. How can I configure user groups in PMacct ? Is there any provision such that this Accounting ON/OFF requests configuration can be changes at run time ? From: pmacct-discussion [mailto:pmacct-discussion-boun...@pmacct.net] On Behalf Of Jentsch, Mario Sent: Tuesday, July 26, 2016 6:18 PM To: pmacct-discussion@pmacct.net Subject: Re: [pmacct-discussion] Dynamic filtering of packets Hi Mehul. the way you detect "Accounting ON/OFF" in pmacct affects possible recommendations. Same applies to other preconditions/requirements you may have. If we don't need to care about them I would think you can filter out all IPs that you don't want accounting enabled for - this assumes there is no dynamic assignment from users to IP addresses. With such a dynamic assignment a solution could be: assign the user groups ("accounting on" vs "accounting off") different IP blocks and have pmacct collect the data only for the IP block for users with "accounting on". In case your situation is more complicated and you can't take one of these ways it is helpful to know how you "receive some event i.e. Accounting ON in PMacct" and process it. Depending on if you're allowed to keep data about users with "accounting off" you also may solve it on MySQL side (presuming this is your data store). Receiving an "accounting on" you put the user/IP address for it in table1. Accounting data for this IP address is only stored in table2 if an appropriate entry in table1 is there. Receiving an "accounting off" you remove user/IP address for it in table1 and if required all appropriate entries from table2. This behavior should be possible with DB triggers / helper table. Regards, Mario From: pmacct-discussion [mailto:pmacct-discussion-boun...@pmacct.net] On Behalf Of Mehul Prajapati Sent: Tuesday, July 26, 2016 11:48 AM To: pmacct-discussion@pmacct.net<mailto:pmacct-discussion@pmacct.net> Subject: Re: [pmacct-discussion] Dynamic filtering of packets Hi Mario, Remote Authentication Dial-In User Service (RADIUS) is a networking protocol<https://en.wikipedia.org/wiki/Communications_protocol> that provides centralized Authentication, Authorization, and Accounting (AAA<https://en.wikipedia.org/wiki/AAA_protocol>) management for users who connect and use a network service. You can ignore the RADIUS decoding part. Requirement: I want to do accounting for only selective users/IP addresses. Let say, I receive some event i.e. Accounting ON in PMacct. Now, processing this event, I want to start accounting for only this IP address/user. After some time, I receive Accounting OFF event in PMacct. Now, processing this event, I want to stop accounting for only this IP address/user. Is there any mechanism to achieve it ? From: pmacct-discussion [mailto:pmacct-discussion-boun...@pmacct.net] On Behalf Of Jentsch, Mario Sent: Tuesday, July 26, 2016 2:55 PM To: pmacct-discussion@pmacct.net<mailto:pmacct-discussion@pmacct.net> Subject: Re: [pmacct-discussion] Dynamic filtering of packets Hi Mehul, > I have explored about "refresh_maps" config key. > If I use it, then I need to make changes in map file at run time. that is working fine in one of our setups. We detect changes in the network, re-create the map file and have the daemon reload it without restart. > But, I want to make filtering such that changes reside in memory only. That sounds like you need to patch pmacct what IMHO is the least best solution. > I am decoding RADIUS packet in PMacct at run-time. Therefore, I > want to make account filtering after decoding RADIUS packet data. Can you show us your configuration for that? > I have looked into code and there is not handler for DELETE query in mysql. > I want to delete records from code itself when Accounting OFF is received. I think you need to create your own plugin for such actions based on collected data. > Would you suggest any other suitable way? Right now I can't - have to admit that I don't understand your use case and what your RADIUS packets are :\ Regards, Mario From: pmacct-discussion [mailto:pmacct-discussion-boun...@pmacct.net] On Behalf Of Mehul Prajapati Sent: Tuesday, July 26, 2016 10:27 AM To: pmacct-discussion@pmacct.net<mailto:pmacct-discussion@pmacct.net> Subject: Re: [pmacct-discussion] Dynamic filtering of packets Hi, Thanks for your inputs. 1) I have explored about "refresh_maps" config key. If I use it, then I need to make changes in map file at run time. But, I want to make filtering such that changes reside in memory only. I am decoding RADIUS packet in PMacct at run-time. Therefore, I want to make accoun
Re: [pmacct-discussion] Dynamic filtering of packets
Hi Mario, Remote Authentication Dial-In User Service (RADIUS) is a networking protocol<https://en.wikipedia.org/wiki/Communications_protocol> that provides centralized Authentication, Authorization, and Accounting (AAA<https://en.wikipedia.org/wiki/AAA_protocol>) management for users who connect and use a network service. You can ignore the RADIUS decoding part. Requirement: I want to do accounting for only selective users/IP addresses. Let say, I receive some event i.e. Accounting ON in PMacct. Now, processing this event, I want to start accounting for only this IP address/user. After some time, I receive Accounting OFF event in PMacct. Now, processing this event, I want to stop accounting for only this IP address/user. Is there any mechanism to achieve it ? From: pmacct-discussion [mailto:pmacct-discussion-boun...@pmacct.net] On Behalf Of Jentsch, Mario Sent: Tuesday, July 26, 2016 2:55 PM To: pmacct-discussion@pmacct.net Subject: Re: [pmacct-discussion] Dynamic filtering of packets Hi Mehul, > I have explored about "refresh_maps" config key. > If I use it, then I need to make changes in map file at run time. that is working fine in one of our setups. We detect changes in the network, re-create the map file and have the daemon reload it without restart. > But, I want to make filtering such that changes reside in memory only. That sounds like you need to patch pmacct what IMHO is the least best solution. > I am decoding RADIUS packet in PMacct at run-time. Therefore, I > want to make account filtering after decoding RADIUS packet data. Can you show us your configuration for that? > I have looked into code and there is not handler for DELETE query in mysql. > I want to delete records from code itself when Accounting OFF is received. I think you need to create your own plugin for such actions based on collected data. > Would you suggest any other suitable way? Right now I can't - have to admit that I don't understand your use case and what your RADIUS packets are :\ Regards, Mario From: pmacct-discussion [mailto:pmacct-discussion-boun...@pmacct.net] On Behalf Of Mehul Prajapati Sent: Tuesday, July 26, 2016 10:27 AM To: pmacct-discussion@pmacct.net<mailto:pmacct-discussion@pmacct.net> Subject: Re: [pmacct-discussion] Dynamic filtering of packets Hi, Thanks for your inputs. 1) I have explored about "refresh_maps" config key. If I use it, then I need to make changes in map file at run time. But, I want to make filtering such that changes reside in memory only. I am decoding RADIUS packet in PMacct at run-time. Therefore, I want to make account filtering after decoding RADIUS packet data. 2) I have looked into code and there is not handler for DELETE query in mysql. I want to delete records from code itself when Accounting OFF is received. Would you suggest any other suitable way? From: pmacct-discussion [mailto:pmacct-discussion-boun...@pmacct.net] On Behalf Of Jentsch, Mario Sent: Tuesday, July 26, 2016 12:46 PM To: pmacct-discussion@pmacct.net<mailto:pmacct-discussion@pmacct.net> Subject: Re: [pmacct-discussion] Dynamic filtering of packets Hi Mehul, > Is there any mechanism available such that I can apply tagging and > filtering at run time after decoding of RADIUS packet ? Have a look at the "refresh_maps" config key. You can update your map at run time and have pmacct reload it by sending SIGUSR2. > After decoding, is there any way to remove records from database > at run time ? Depends on the used database. With an SQL one you can, with a memory table not. I would consider to evaluate the "Accounting ON/OFF" flag when creating the report. Regards, Mario From: pmacct-discussion [mailto:pmacct-discussion-boun...@pmacct.net] On Behalf Of Mehul Prajapati Sent: Tuesday, July 26, 2016 8:43 AM To: pmacct-discussion@pmacct.net<mailto:pmacct-discussion@pmacct.net> Subject: [pmacct-discussion] Dynamic filtering of packets Hi, I have one Query regarding to Dynamic filtering and aggregation Requirements: 1) Account for only those IP addresses/users for which Accounting ON request is received in RADIUS packet 2) Purge records from database for which Accounting OFF request is received in RADIUS packet I have explored pre-tagging section of PMacct. According to my understanding, it takes filtering from configuration file once and afterwards filtering remains same at run time. I am decoding and processing RADIUS packet at run time. 1. Is there any mechanism available such that I can apply tagging and filtering at run time after decoding of RADIUS packet ? 2. After decoding, is there any way to remove records from database at run time ? Regards, Mehul Mehul Prajapati Mehul Prajapati Mehul Prajapati ___ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
Re: [pmacct-discussion] Dynamic filtering of packets
Hi, Thanks for your inputs. 1) I have explored about "refresh_maps" config key. If I use it, then I need to make changes in map file at run time. But, I want to make filtering such that changes reside in memory only. I am decoding RADIUS packet in PMacct at run-time. Therefore, I want to make account filtering after decoding RADIUS packet data. 2) I have looked into code and there is not handler for DELETE query in mysql. I want to delete records from code itself when Accounting OFF is received. Would you suggest any other suitable way? From: pmacct-discussion [mailto:pmacct-discussion-boun...@pmacct.net] On Behalf Of Jentsch, Mario Sent: Tuesday, July 26, 2016 12:46 PM To: pmacct-discussion@pmacct.net Subject: Re: [pmacct-discussion] Dynamic filtering of packets Hi Mehul, > Is there any mechanism available such that I can apply tagging and > filtering at run time after decoding of RADIUS packet ? Have a look at the "refresh_maps" config key. You can update your map at run time and have pmacct reload it by sending SIGUSR2. > After decoding, is there any way to remove records from database > at run time ? Depends on the used database. With an SQL one you can, with a memory table not. I would consider to evaluate the "Accounting ON/OFF" flag when creating the report. Regards, Mario From: pmacct-discussion [mailto:pmacct-discussion-boun...@pmacct.net] On Behalf Of Mehul Prajapati Sent: Tuesday, July 26, 2016 8:43 AM To: pmacct-discussion@pmacct.net<mailto:pmacct-discussion@pmacct.net> Subject: [pmacct-discussion] Dynamic filtering of packets Hi, I have one Query regarding to Dynamic filtering and aggregation Requirements: 1) Account for only those IP addresses/users for which Accounting ON request is received in RADIUS packet 2) Purge records from database for which Accounting OFF request is received in RADIUS packet I have explored pre-tagging section of PMacct. According to my understanding, it takes filtering from configuration file once and afterwards filtering remains same at run time. I am decoding and processing RADIUS packet at run time. 1. Is there any mechanism available such that I can apply tagging and filtering at run time after decoding of RADIUS packet ? 2. After decoding, is there any way to remove records from database at run time ? Regards, Mehul Mehul Prajapati Mehul Prajapati ___ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
[pmacct-discussion] Dynamic filtering of packets
Hi, I have one Query regarding to Dynamic filtering and aggregation Requirements: 1) Account for only those IP addresses/users for which Accounting ON request is received in RADIUS packet 2) Purge records from database for which Accounting OFF request is received in RADIUS packet I have explored pre-tagging section of PMacct. According to my understanding, it takes filtering from configuration file once and afterwards filtering remains same at run time. I am decoding and processing RADIUS packet at run time. 1. Is there any mechanism available such that I can apply tagging and filtering at run time after decoding of RADIUS packet ? 2. After decoding, is there any way to remove records from database at run time ? Regards, Mehul Mehul Prajapati ___ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists