rc9000

 $ cat /data/postgres/bin/nd_poller_perf.sql
with cte as (
select
    (select count(*) from device where last_macsuck > (current_timestamp - interval '1 minute')) as macsuck_last1min,
    (select count(*) from device where last_arpnip > (current_timestamp - interval '1 minute')) as arpnip_last1min,
    (select count(*) from device where last_macsuck > (current_timestamp - interval '5 minutes')) as macsuck_last5min,
    (select count(*) from device where last_arpnip > (current_timestamp - interval '5 minutes')) as arpnip_last5min
)
select
    c.macsuck_last1min,

rc9000

device_auth:
  - auth:
      pass: jhiK34KahT20
      proto: MD5
    only: 10.28.15.1
    priv:
      pass: ncTzu28VVndL
      proto: DES
    read: true

rc9000

package App::Netdisco::SSHCollector::Platform::Aruba;

=head1 NAME

App::Netdisco::SSHCollector::Platform::Aruba

=head1 DESCRIPTION

=cut

rc9000

Postgres fail2ban configuration, custom actions

Needs fail2ban 0.10+. See https://github.com/fail2ban/fail2ban/wiki/How-to-ban-something-other-as-host-(IP-address),-like-user-or-mail,-etc. for more information.

Motivated by this discussion on pgsql-general: https://www.postgresql.org/message-id/61463e206b7c4c0ca17b03a59e890b78%40lmco.com

/etc/fail2ban/jail.d/postgres.conf

[postgres-lockuser]

rc9000

$ diff  nd2/lib/perl5/App/Netdisco/Util/Node.pm  nd2/lib/perl5/App/Netdisco/Util/Node.pm.dist
105,106c105,107
<       debug sprintf ' [%s] check_mac - VRRP mac [%s] - still including', $devip, $node;
<       #return 0;
---
>       debug sprintf ' [%s] check_mac - VRRP mac [%s] - skipping',
>         $devip, $node;
>       return 0;

rc9000

#!/bin/bash

# best to use a dedicated IAM user, see http://cantina.co/automated-dns-for-aws-instances-using-route-53/
# for a guide
export AWS_ACCESS_KEY_ID="your access key"
export AWS_SECRET_ACCESS_KEY="your secret access key"
export ZONE="delegated-to-route53.example.com"
export TTL="600"

rc9000

     1  hostname: cx-core-10070
     2  ipaddress: 192.168.2.70
     3  tables:
     4      - [ ifDescr, ifInUcastPkts, ifInErrors  ]  
     5  pollrules:
     6      - rulename: BasicCheck
     7        selector: unique
     8        continueif: clear
     9      - rulename: IfInErrors
    10        selector: ifDescr.%