Unable to monitor Redis, Mongo and Postgres in my On-prem

Help
1

Unable to monitor redis mongo and postgres in my on-prem instance
I have configured the respective collectors but unable to monitor

Redis.conf

update_every: 1

autodetection_retry: 0

priority: 70000

jobs:

  • name: cnRedis
    address: ‘redis://@127.0.0.1:6379’

Mongodb.conf

update_every: 1

autodetection_retry: 0

priority: 70000

jobs:

  • name: cnMongo
    uri: ‘mongodb://netdata:netdata@localhost:27017’
    timeout: 2

Postgres.conf

jobs:

  • name: cnPostgres
    dsn: ‘postgres://postgres:postgres@127.0.0.1:5432/postgres’
    #collect_databases_matching: ‘*’
  • name: local
    dsn: ‘host=/var/run/postgresql dbname=postgres user=postgres’
    #collect_databases_matching: ‘*’

Troubleshooting steps:
Redis

netdata@cnmaestro:/usr/libexec/netdata/plugins.d$ ./go.d.plugin -d -m redis
[ DEBUG ] main[main] main.go:113 plugin: name=go.d, version=v0.49.2
[ DEBUG ] main[main] main.go:115 current user: name=netdata, uid=120
[ INFO ] main[main] agent.go:136 instance is started
[ INFO ] main[main] setup.go:42 loading config file
[ INFO ] main[main] setup.go:50 looking for ‘go.d.conf’ in [/etc/netdata /usr/lib/netdata/conf.d]
[ INFO ] main[main] setup.go:57 found ‘/etc/netdata/go.d.conf
[ INFO ] main[main] setup.go:64 config successfully loaded
[ INFO ] main[main] agent.go:140 using config: enabled ‘true’, default_run ‘true’, max_procs ‘0’
[ INFO ] main[main] setup.go:69 loading modules
[ INFO ] main[main] setup.go:88 enabled/registered modules: 1/79
[ INFO ] main[main] setup.go:93 building discovery config
[ INFO ] main[main] setup.go:123 looking for ‘redis.conf’ in [/etc/netdata/go.d /usr/lib/netdata/conf.d/go.d]
[ INFO ] main[main] setup.go:139 found ‘/etc/netdata/go.d/redis.conf
[ INFO ] main[main] setup.go:144 dummy/read/watch paths: 0/1/0
[ INFO ] discovery[manager] manager.go:92 registered discoverers: [file discovery: [file reader]]
[ INFO ] discovery[manager] manager.go:97 instance is started
[ INFO ] run[manager] run.go:32 instance is started
[ INFO ] build[manager] build.go:107 instance is started
[ INFO ] discovery[file manager] discovery.go:73 instance is started
[ INFO ] discovery[file reader] read.go:41 instance is started
[ INFO ] discovery[file reader] read.go:42 instance is stopped
[ DEBUG ] build[manager] build.go:154 received config group (’/etc/netdata/go.d/redis.conf’): 0 jobs (added: 0, removed: 0)
[ DEBUG ] run[manager] run.go:43 tick 0
[ DEBUG ] run[manager] run.go:43 tick 1
[ DEBUG ] run[manager] run.go:43 tick 2
^C[ INFO ] main[main] agent.go:104 received interrupt signal (2). Terminating…
[ INFO ] run[manager] run.go:33 instance is stopped
[ INFO ] build[manager] build.go:108 instance is stopped
[ INFO ] discovery[manager] manager.go:98 instance is stopped
[ INFO ] main[main] agent.go:137 instance is stopped
netdata@cnmaestro:/usr/libexec/netdata/plugins.d$ ./go.d.plugin -d -m mongodb
[ DEBUG ] main[main] main.go:113 plugin: name=go.d, version=v0.49.2
[ DEBUG ] main[main] main.go:115 current user: name=netdata, uid=120
[ INFO ] main[main] agent.go:136 instance is started
[ INFO ] main[main] setup.go:42 loading config file
[ INFO ] main[main] setup.go:50 looking for ‘go.d.conf’ in [/etc/netdata /usr/lib/netdata/conf.d]
[ INFO ] main[main] setup.go:57 found ‘/etc/netdata/go.d.conf
[ INFO ] main[main] setup.go:64 config successfully loaded
[ INFO ] main[main] agent.go:140 using config: enabled ‘true’, default_run ‘true’, max_procs ‘0’
[ INFO ] main[main] setup.go:69 loading modules
[ INFO ] main[main] setup.go:88 enabled/registered modules: 1/79
[ INFO ] main[main] setup.go:93 building discovery config
[ INFO ] main[main] setup.go:123 looking for ‘mongodb.conf’ in [/etc/netdata/go.d /usr/lib/netdata/conf.d/go.d]
[ INFO ] main[main] setup.go:139 found ‘/etc/netdata/go.d/mongodb.conf
[ INFO ] main[main] setup.go:144 dummy/read/watch paths: 0/1/0
[ INFO ] discovery[manager] manager.go:92 registered discoverers: [file discovery: [file reader]]
[ INFO ] discovery[manager] manager.go:97 instance is started
[ INFO ] build[manager] build.go:107 instance is started
[ INFO ] run[manager] run.go:32 instance is started
[ INFO ] discovery[file manager] discovery.go:73 instance is started
[ INFO ] discovery[file reader] read.go:41 instance is started
[ INFO ] discovery[file reader] read.go:42 instance is stopped
[ DEBUG ] build[manager] build.go:154 received config group (’/etc/netdata/go.d/mongodb.conf’): 0 jobs (added: 0, removed: 0)
[ DEBUG ] run[manager] run.go:43 tick 0
[ DEBUG ] run[manager] run.go:43 tick 1
[ DEBUG ] run[manager] run.go:43 tick 2
^C[ INFO ] main[main] agent.go:104 received interrupt signal (2). Terminating…
[ INFO ] build[manager] build.go:108 instance is stopped
[ INFO ] run[manager] run.go:33 instance is stopped
[ INFO ] discovery[manager] manager.go:98 instance is stopped
[ INFO ] main[main] agent.go:137 instance is stopped
netdata@cnmaestro:/usr/libexec/netdata/plugins.d$ ./go.d.plugin -d -m postgres
[ DEBUG ] main[main] main.go:113 plugin: name=go.d, version=v0.49.2
[ DEBUG ] main[main] main.go:115 current user: name=netdata, uid=120
[ INFO ] main[main] agent.go:136 instance is started
[ INFO ] main[main] setup.go:42 loading config file
[ INFO ] main[main] setup.go:50 looking for ‘go.d.conf’ in [/etc/netdata /usr/lib/netdata/conf.d]
[ INFO ] main[main] setup.go:57 found ‘/etc/netdata/go.d.conf
[ INFO ] main[main] setup.go:64 config successfully loaded
[ INFO ] main[main] agent.go:140 using config: enabled ‘true’, default_run ‘true’, max_procs ‘0’
[ INFO ] main[main] setup.go:69 loading modules
[ INFO ] main[main] setup.go:88 enabled/registered modules: 1/79
[ INFO ] main[main] setup.go:93 building discovery config
[ INFO ] main[main] setup.go:123 looking for ‘postgres.conf’ in [/etc/netdata/go.d /usr/lib/netdata/conf.d/go.d]
[ INFO ] main[main] setup.go:139 found ‘/etc/netdata/go.d/postgres.conf
[ INFO ] main[main] setup.go:144 dummy/read/watch paths: 0/1/0
[ INFO ] discovery[manager] manager.go:92 registered discoverers: [file discovery: [file reader]]
[ INFO ] discovery[manager] manager.go:97 instance is started
[ INFO ] run[manager] run.go:32 instance is started
[ INFO ] build[manager] build.go:107 instance is started
[ INFO ] discovery[file manager] discovery.go:73 instance is started
[ INFO ] discovery[file reader] read.go:41 instance is started
[ INFO ] discovery[file reader] read.go:42 instance is stopped
[ DEBUG ] build[manager] build.go:154 received config group (’/etc/netdata/go.d/postgres.conf’): 2 jobs (added: 2, removed: 0)
[ DEBUG ] build[manager] build.go:303 building postgres[cnPostgres] job, config: map[provider:file reader source:/etc/netdata/go.d/postgres.conf autodetection_retry:0 dsn:postgres://postgres:postgres@127.0.0.1:5432/postgres module:postgres name:cnPostgres priority:70000 update_every:1]
[ ERROR ] postgres[cnPostgres] postgres.go:120 error on pinging the Postgres database [postgres://postgres:postgres@127.0.0.1:5432/postgres]: failed to connect to host=127.0.0.1 user=postgres database=postgres: dial error (dial tcp 127.0.0.1:5432: connect: connection refused)
[ ERROR ] postgres[cnPostgres] job.go:191 check failed
[ DEBUG ] build[manager] build.go:303 building postgres[local] job, config: map[provider:file reader source:/etc/netdata/go.d/postgres.conf autodetection_retry:0 dsn:host=/var/run/postgresql dbname=postgres user=postgres module:postgres name:local priority:70000 update_every:1]
[ ERROR ] postgres[local] postgres.go:120 error on pinging the Postgres database [host=/var/run/postgresql dbname=postgres user=postgres]: failed to connect to host=/var/run/postgresql user=postgres database=postgres: server error (FATAL: password authentication failed for user “postgres” (SQLSTATE 28P01))
[ ERROR ] postgres[local] job.go:191 check failed
[ DEBUG ] run[manager] run.go:43 tick 0
[ DEBUG ] run[manager] run.go:43 tick 1
[ DEBUG ] run[manager] run.go:43 tick 2
[ DEBUG ] run[manager] run.go:43 tick 3
[ DEBUG ] run[manager] run.go:43 tick 4

Kindly help

2

Hi, @balajis.

  • redist, mongodb

I think there is a syntax error or some other problem in your configuration file. I see go.d.plugin couldn’t find any data collection jobs:

[ DEBUG ] build[manager] build.go:154 received config group (’/etc/netdata/go.d/redis.conf’): 0 jobs (added: 0, removed: 0)
[ DEBUG ] build[manager] build.go:154 received config group (’/etc/netdata/go.d/mongodb.conf’): 0 jobs (added: 0, removed: 0)

You shared your config, but it is hard to find a problem because you didn’t use proper formatting. Can you try it again but use “Preformatted text” this time?

  • postgres

It is password authentication problem, see:

[ ERROR ] postgres[local] postgres.go:120 error on pinging the Postgres database [host=/var/run/postgresql dbname=postgres user=postgres]: failed to connect to host=/var/run/postgresql user=postgres database=postgres : server error (FATAL: password authentication failed for user “postgres” (SQLSTATE 28P01))

3

Redis.conf


# netdata go.d.plugin configuration for redis
#
# This file is in YAML format. Generally the format is:
#
# name: value
#
# There are 2 sections:
#  - GLOBAL
#  - JOBS
#
#
# [ GLOBAL ]
# These variables set the defaults for all JOBs, however each JOB may define its own, overriding the defaults.
#
# The GLOBAL section format:
# param1: value1
# param2: value2
#
# Currently supported global parameters:
#  - update_every
#    Data collection frequency in seconds. Default: 1.
#
#  - autodetection_retry
#    Re-check interval in seconds. Attempts to start the job are made once every interval.
#    Zero means not to schedule re-check. Default: 0.
#
#  - priority
#    Priority is the relative priority of the charts as rendered on the web page,
#    lower numbers make the charts appear before the ones with higher numbers. Default: 70000.
#
#
# [ JOBS ]
# JOBS allow you to collect values from multiple sources.
# Each source will have its own set of charts.
#
# IMPORTANT:
#  - Parameter 'name' is mandatory.
#  - Jobs with the same name are mutually exclusive. Only one of them will be allowed running at any time.
#
# This allows autodetection to try several alternatives and pick the one that works.
# Any number of jobs is supported.
#
# The JOBS section format:
#
# jobs:
#   - name: job1
#     param1: value1
#     param2: value2
#
#   - name: job2
#     param1: value1
#     param2: value2
#
#   - name: job2
#     param1: value1
#
#
# [ List of JOB specific parameters ]:
#  - address
#    Redis server address.
#    There are two connection types: by tcp socket and by unix socket.
#    Tcp connection:
#               redis://<user>:<password>@<host>:<port>/<db_number>
#    Unix connection:
#               unix://<user>:<password>@</path/to/redis.sock>?db=<db_number>
#
#  - username
#    The username used for authentication.
#    Syntax:
#      username: user
#
#  - password
#    The password used for authentication.
#    Syntax:
#      password: password
#
#  - timeout
#    Dial (establishing new connections), read (socket reads) and write (socket writes) timeout in seconds.
#    Syntax:
#      timeout: 1
#
#  - tls_skip_verify
#    Whether to skip verifying server's certificate chain and hostname.
#    Syntax:
#      tls_skip_verify: yes/no
#
#  - tls_ca
#    Certificate authority that client use when verifying server certificates.
#    Syntax:
#      tls_ca: path/to/ca.pem
#
#  - tls_cert
#    Client tls certificate.
#    Syntax:
#      tls_cert: path/to/cert.pem
#
#  - tls_key
#    Client tls key.
#    Syntax:
#      tls_key: path/to/key.pem
#
#
# [ JOB defaults ]:
#  address: 'redis://@127.0.0.1:6379'
#  timeout: 1
#
#
# [ JOB mandatory parameters ]:
#  - name
#  - address
# ------------------------------------------------MODULE-CONFIGURATION--------------------------------------------------

update_every: 1
# autodetection_retry: 0
# priority: 70000

jobs:
  - name: cnRedis
    address: 'redis://@127.0.0.1:6379'

MongoDb.conf

# netdata go.d.plugin configuration for mongodb
#
# This file is in YAML format. Generally the format is:
#
# name: value
#
# There are 2 sections:
#  - GLOBAL
#  - JOBS
#
#
# [ GLOBAL ]
# These variables set the defaults for all JOBs, however each JOB may define its own, overriding the defaults.
#
# The GLOBAL section format:
# param1: value1
# param2: value2
#
# Currently supported global parameters:
#  - update_every
#    Data collection frequency in seconds. Default: 1.
#
#  - autodetection_retry
#    Re-check interval in seconds. Attempts to start the job are made once every interval.
#    Zero means not to schedule re-check. Default: 0.
#
#  - priority
#    Priority is the relative priority of the charts as rendered on the web page,
#    lower numbers make the charts appear before the ones with higher numbers. Default: 70000.
#
#
# [ JOBS ]
# JOBS allow you to collect values from multiple sources.
# Each source will have its own set of charts.
#
# IMPORTANT:
#  - Parameter 'name' is mandatory.
#  - Jobs with the same name are mutually exclusive. Only one of them will be allowed running at any time.
#
# This allows autodetection to try several alternatives and pick the one that works.
# Any number of jobs is supported.
#
# The JOBS section format:
#
# jobs:
#   - name: job1
#     param1: value1
#     param2: value2
#
#   - name: job2
#     param1: value1
#     param2: value2
#
#   - name: job2
#     param1: value1
#
#
# [ List of JOB specific parameters ]:
#  - uri
#    MongoDB connection string.
#    Syntax:
#               mongodb://user:password@mongodb0.example.com:27017/?authSource=admin
#
#  - databases
#    Database statistics filter. Module will collect database statistics if filter matches the database name.
#    Filter logic: (pattern1 OR pattern2) AND !(pattern3 or pattern4)
#    Pattern syntax: https://github.com/netdata/go.d.plugin/tree/master/pkg/matcher#supported-format
#    Syntax:
#      databases:
#        includes:
#          - pattern1
#          - pattern2
#        excludes:
#          - pattern3
#          - pattern4
#
# [ JOB defaults ]:
#  uri: 'mongodb://localhost:27017'

# [ JOB mandatory parameters ]:
#  - uri
# ------------------------------------------------MODULE-CONFIGURATION--------------------------------------------------

update_every: 1
# autodetection_retry: 0
# priority: 70000

jobs:
  - name: cnMongo
    uri: 'mongodb://netdata:netdata@127.0.0.1:27017'
    timeout: 2
#     databases:
#       include:
#         - "* *"

Postgres.conf

# netdata go.d.plugin configuration for postgres
#
# This file is in YAML format. Generally the format is:
#
# name: value
#
# There are 2 sections:
#  - GLOBAL
#  - JOBS
#
#
# [ GLOBAL ]
# These variables set the defaults for all JOBs, however each JOB may define its own, overriding the defaults.
#
# The GLOBAL section format:
# param1: value1
# param2: value2
#
# Currently supported global parameters:
#  - update_every
#    Data collection frequency in seconds. Default: 1.
#
#  - autodetection_retry
#    Re-check interval in seconds. Attempts to start the job are made once every interval.
#    Zero means not to schedule re-check. Default: 0.
#
#  - priority
#    Priority is the relative priority of the charts as rendered on the web page,
#    lower numbers make the charts appear before the ones with higher numbers. Default: 70000.
#
#
# [ JOBS ]
# JOBS allow you to collect values from multiple sources.
# Each source will have its own set of charts.
#
# IMPORTANT:
#  - Parameter 'name' is mandatory.
#  - Jobs with the same name are mutually exclusive. Only one of them will be allowed running at any time.
#
# This allows autodetection to try several alternatives and pick the one that works.
# Any number of jobs is supported.
#
# The JOBS section format:
#
# jobs:
#   - name: job1
#     param1: value1
#     param2: value2
#
#   - name: job2
#     param1: value1
#     param2: value2
#
#   - name: job2
#     param1: value1
#
#
# [ List of JOB specific parameters ]:
#  - dsn
#    Data Source Name.
#    Format: postgres://[username[:password]]@host:port[/dbname]?sslmode=[disable|verify-ca|verify-full]
#    Syntax:
#     dsn: postgres://postgres:postgres@127.0.0.1:5432/postgres
#
#
# [ JOB defaults ]:
#  No parameters
#
#
# [ JOB mandatory parameters ]:
#  - name
#  - dsn
# ------------------------------------------------MODULE-CONFIGURATION--------------------------------------------------

# update_every: 1
# autodetection_retry: 0
# priority: 70000

jobs:
  - name: cnPostgres
    dsn: 'postgres://netdata:netdata@127.0.0.1:5432/cnmaestro_server'
    #collect_databases_matching: '*'
  #- name: local
   # dsn: 'host=/var/run/postgresql dbname=postgres user=postgres'
    #collect_databases_matching: '*'

Errors now:

Mongo

[ DEBUG ] build[manager] build.go:303 building mongodb[cnMongo] job, config: map[provider:file reader source:/etc/netdata/go.d/mongodb.conf autodetection_retry:0 module:mongodb name:cnMongo priority:70000 timeout:2 update_every:1 uri:mongodb://netdata:netdata@127.0.0.1:27017]
[ DEBUG ] run[manager] run.go:43 tick 0
[ DEBUG ] run[manager] run.go:43 tick 1
[ ERROR ] mongodb[cnMongo] mongodb.go:91 init mongo conn: server selection error: context deadline exceeded, current topology: { Type: Unknown, Servers: [{ Addr: 127.0.0.1:27017, Type: Unknown, Last error: dial tcp 127.0.0.1:27017: connect: connection refused }, ] }
[ WARN ] mongodb[cnMongo] mongodb.go:95 no values collected
[ ERROR ] mongodb[cnMongo] job.go:191 check failed

Postgres
[ DEBUG ] build[manager] build.go:154 received config group (‘/etc/netdata/go.d/postgres.conf’): 1 jobs (added: 1, removed: 0)
[ DEBUG ] build[manager] build.go:303 building postgres[cnPostgres] job, config: map[provider:file reader source:/etc/netdata/go.d/postgres.conf autodetection_retry:0 dsn:postgres://netdata:netdata@127.0.0.1:5432/cnmaestro_server module:postgres name:cnPostgres priority:70000 update_every:1]
[ ERROR ] postgres[cnPostgres] postgres.go:120 error on pinging the Postgres database [postgres://netdata:netdata@127.0.0.1:5432/cnmaestro_server]: failed to connect to host=127.0.0.1 user=netdata database=cnmaestro_server: dial error (dial tcp 127.0.0.1:5432: connect: connection refused)
[ ERROR ] postgres[cnPostgres] job.go:191 check failed

Redis
[ DEBUG ] build[manager] build.go:154 received config group (‘/etc/netdata/go.d/redis.conf’): 1 jobs (added: 1, removed: 0)
[ DEBUG ] build[manager] build.go:303 building redis[cnRedis] job, config: map[provider:file reader source:/etc/netdata/go.d/redis.conf address:redis://@127.0.0.1:6379 autodetection_retry:0 module:rediname:cnRedis priority:70000 update_every:1]
[ ERROR ] redis[cnRedis] redis.go:112 dial tcp 127.0.0.1:6379: connect: connection refused
[ ERROR ] redis[cnRedis] job.go:191 check failed

@ilyam8 , can you please help now?

4

Configs are ok now, all 3 collectors fail with the same error: connection refused

[ ERROR ] mongodb[cnMongo] mongodb.go:91 init mongo conn: server selection error: context deadline exceeded, current topology: { Type: Unknown, Servers: [{ Addr: 127.0.0.1:27017, Type: Unknown, Last error: dial tcp 127.0.0.1:27017: connect: connection refused }, ] }

[ ERROR ] postgres[cnPostgres] postgres.go:120 error on pinging the Postgres database [postgres://netdata:netdata@127.0.0.1:5432/cnmaestro_server]: failed to connect to host=127.0.0.1 user=netdata database=cnmaestro_server : dial error (dial tcp 127.0.0.1:5432: connect: connection refused)

[ ERROR ] redis[cnRedis] redis.go:112 dial tcp 127.0.0.1:6379: connect: connection refused

Netdata tries to connect but has no luck.

Are you sure you have Postgres, MongoDB, and Redis running on the same instance?

Can you sudo ss -ntlp and share the output?

5

Yes, all are running in the same On-Prem instance

root@cnmaestro:/home/cambium# sudo ss -nltp
State          Recv-Q         Send-Q                 Local Address:Port                    Peer Address:Port         Process
LISTEN         0              512                        127.0.0.1:8090                         0.0.0.0:*             users:(("mon8zn-service",pid=2548,fd=16))
LISTEN         0              511                          0.0.0.0:443                          0.0.0.0:*             users:(("nginx",pid=2241,fd=27),("nginx",pid=2240,fd=27),("nginx",pid=2239,fd=27))
LISTEN         0              511                          0.0.0.0:443                          0.0.0.0:*             users:(("nginx",pid=2241,fd=17),("nginx",pid=2240,fd=17),("nginx",pid=2239,fd=17))
LISTEN         0              512                        127.0.0.1:8123                         0.0.0.0:*             users:(("clickhouse-serv",pid=1797,fd=162))
LISTEN         0              512                        127.0.0.1:2812                         0.0.0.0:*             users:(("monit",pid=3559,fd=6))
LISTEN         0              512                        127.0.0.1:8125                         0.0.0.0:*             users:(("netdata",pid=55239,fd=91))
LISTEN         0              512                        127.0.0.1:3005                         0.0.0.0:*             users:(("aurora-ctlr",pid=3857,fd=12))
LISTEN         0              512                          0.0.0.0:19999                        0.0.0.0:*             users:(("netdata",pid=55239,fd=6))
LISTEN         0              511                        127.0.0.1:9443                         0.0.0.0:*             users:(("CnsReportingSer",pid=3396,fd=37))
LISTEN         0              511                        127.0.0.1:5443                         0.0.0.0:*             users:(("CnsRouterWebSer",pid=2694,fd=19))
LISTEN         0              511                          0.0.0.0:1443                         0.0.0.0:*             users:(("nginx",pid=2241,fd=29),("nginx",pid=2240,fd=29),("nginx",pid=2239,fd=29))
LISTEN         0              511                          0.0.0.0:1443                         0.0.0.0:*             users:(("nginx",pid=2241,fd=19),("nginx",pid=2240,fd=19),("nginx",pid=2239,fd=19))
LISTEN         0              511                          0.0.0.0:1444                         0.0.0.0:*             users:(("nginx",pid=2241,fd=31),("nginx",pid=2240,fd=31),("nginx",pid=2239,fd=31))
LISTEN         0              511                          0.0.0.0:1444                         0.0.0.0:*             users:(("nginx",pid=2241,fd=21),("nginx",pid=2240,fd=21),("nginx",pid=2239,fd=21))
LISTEN         0              128                        127.0.0.1:5672                         0.0.0.0:*             users:(("beam.smp",pid=2188,fd=33))
LISTEN         0              128                        127.0.0.1:25672                        0.0.0.0:*             users:(("beam.smp",pid=2188,fd=18))
LISTEN         0              512                        127.0.0.1:27017                        0.0.0.0:*             users:(("mongod",pid=2185,fd=11))
LISTEN         0              512                        127.0.0.1:9001                         0.0.0.0:*             users:(("clickhouse-serv",pid=1797,fd=163))
LISTEN         0              511                        127.0.0.1:6443                         0.0.0.0:*             users:(("CnsWebServer W0",pid=2916,fd=19))
LISTEN         0              511                        127.0.0.1:6379                         0.0.0.0:*             users:(("redis-server",pid=2196,fd=6))
LISTEN         0              511                        127.0.0.1:6444                         0.0.0.0:*             users:(("CnsApiServer",pid=3018,fd=19))
LISTEN         0              512                        127.0.0.1:9004                         0.0.0.0:*             users:(("clickhouse-serv",pid=1797,fd=165))
LISTEN         0              512                        127.0.0.1:9005                         0.0.0.0:*             users:(("clickhouse-serv",pid=1797,fd=166))
LISTEN         0              511                          0.0.0.0:80                           0.0.0.0:*             users:(("nginx",pid=2241,fd=23),("nginx",pid=2240,fd=23),("nginx",pid=2239,fd=23))
LISTEN         0              512                        127.0.0.1:4369                         0.0.0.0:*             users:(("epmd",pid=2287,fd=3))
LISTEN         0              512                        127.0.0.1:9009                         0.0.0.0:*             users:(("clickhouse-serv",pid=1797,fd=164))
LISTEN         0              511                        127.0.0.2:7443                         0.0.0.0:*             users:(("CnsDeviceServer",pid=2944,fd=39))
LISTEN         0              511                        127.0.0.1:7443                         0.0.0.0:*             users:(("CnsDeviceServer",pid=2979,fd=38))
LISTEN         0              512                    127.0.0.53%lo:53                           0.0.0.0:*             users:(("systemd-resolve",pid=721,fd=13))
LISTEN         0              128                          0.0.0.0:22                           0.0.0.0:*             users:(("sshd",pid=1737,fd=3))
LISTEN         0              511                        127.0.0.1:3000                         0.0.0.0:*             users:(("aurora-guest",pid=748,fd=21))
LISTEN         0              511                          0.0.0.0:1080                         0.0.0.0:*             users:(("nginx",pid=2241,fd=25),("nginx",pid=2240,fd=25),("nginx",pid=2239,fd=25))
LISTEN         0              444                        127.0.0.1:5432                         0.0.0.0:*             users:(("postgres",pid=2224,fd=3))
LISTEN         0              512                            [::1]:8123                            [::]:*             users:(("clickhouse-serv",pid=1797,fd=29))
LISTEN         0              511                             [::]:443                             [::]:*             users:(("nginx",pid=2241,fd=18),("nginx",pid=2240,fd=18),("nginx",pid=2239,fd=18))
LISTEN         0              511                             [::]:443                             [::]:*             users:(("nginx",pid=2241,fd=28),("nginx",pid=2240,fd=28),("nginx",pid=2239,fd=28))
LISTEN         0              512                            [::1]:2812                            [::]:*             users:(("monit",pid=3559,fd=7))
LISTEN         0              512                            [::1]:8125                            [::]:*             users:(("netdata",pid=55239,fd=90))
LISTEN         0              511                             [::]:1443                            [::]:*             users:(("nginx",pid=2241,fd=20),("nginx",pid=2240,fd=20),("nginx",pid=2239,fd=20))
LISTEN         0              511                             [::]:1443                            [::]:*             users:(("nginx",pid=2241,fd=30),("nginx",pid=2240,fd=30),("nginx",pid=2239,fd=30))
LISTEN         0              511                             [::]:1444                            [::]:*             users:(("nginx",pid=2241,fd=22),("nginx",pid=2240,fd=22),("nginx",pid=2239,fd=22))
LISTEN         0              511                             [::]:1444                            [::]:*             users:(("nginx",pid=2241,fd=32),("nginx",pid=2240,fd=32),("nginx",pid=2239,fd=32))
LISTEN         0              512                            [::1]:9001                            [::]:*             users:(("clickhouse-serv",pid=1797,fd=30))
LISTEN         0              512                            [::1]:9004                            [::]:*             users:(("clickhouse-serv",pid=1797,fd=32))
LISTEN         0              512                            [::1]:9005                            [::]:*             users:(("clickhouse-serv",pid=1797,fd=161))
LISTEN         0              511                             [::]:80                              [::]:*             users:(("nginx",pid=2241,fd=24),("nginx",pid=2240,fd=24),("nginx",pid=2239,fd=24))
LISTEN         0              512                            [::1]:4369                            [::]:*             users:(("epmd",pid=2287,fd=4))
LISTEN         0              512                            [::1]:9009                            [::]:*             users:(("clickhouse-serv",pid=1797,fd=31))
LISTEN         0              511                             [::]:1080                            [::]:*             users:(("nginx",pid=2241,fd=26),("nginx",pid=2240,fd=26),("nginx",pid=2239,fd=26))

Firewall settings

root@cnmaestro:/home/cambium# iptables -L
Chain INPUT (policy DROP)
target     prot opt source               destination
ACCEPT     all  --  anywhere             anywhere
DROP       tcp  --  anywhere             anywhere             tcp flags:FIN,SYN,RST,PSH,ACK,URG/NONE
DROP       tcp  --  anywhere             anywhere             tcp flags:!FIN,SYN,RST,ACK/SYN state NEW
DROP       tcp  --  anywhere             anywhere             tcp flags:FIN,SYN,RST,PSH,ACK,URG/FIN,SYN,RST,PSH,ACK,URG
ACCEPT     all  --  anywhere             anywhere             state RELATED,ESTABLISHED
DROP       all  --  anywhere             anywhere             ctstate INVALID
ACCEPT     icmp --  anywhere             anywhere             icmp echo-request state NEW,RELATED,ESTABLISHED
ACCEPT     udp  --  anywhere             anywhere             udp dpt:3799
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:ssh
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:http
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:https
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:8300
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:8301
ACCEPT     udp  --  anywhere             anywhere             udp dpt:8301
ACCEPT     udp  --  anywhere             anywhere             udp dpt:snmp
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:18301
ACCEPT     udp  --  anywhere             anywhere             udp dpt:18301
ACCEPT     gre  --  anywhere             anywhere
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:19999

Chain FORWARD (policy DROP)
target     prot opt source               destination

Chain OUTPUT (policy ACCEPT)
target     prot opt source               destination
ACCEPT     tcp  --  anywhere             anywhere             state ESTABLISHED
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:27017 owner UID match mongodb
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:27017 owner UID match cnmaestro
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:27017 owner UID match ha-tunnel
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:27017 owner UID match root
LOGREJECT  tcp  --  anywhere             anywhere             tcp dpt:27017
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:postgresql owner UID match postgres
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:postgresql owner UID match cnmaestro
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:postgresql owner UID match ha-tunnel
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:postgresql owner UID match root
LOGREJECT  tcp  --  anywhere             anywhere             tcp dpt:postgresql
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:6379 owner UID match redis
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:6379 owner UID match cnmaestro
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:6379 owner UID match ha-tunnel
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:6379 owner UID match root
LOGREJECT  tcp  --  anywhere             anywhere             tcp dpt:6379
ACCEPT     tcp  --  anywhere             anywhere             multiport dports 8123,9001:9009 owner UID match clickhouse
ACCEPT     tcp  --  anywhere             anywhere             multiport dports 8123,9001:9009 owner UID match cnmaestro
ACCEPT     tcp  --  anywhere             anywhere             multiport dports 8123,9001:9009 owner UID match root
LOGREJECT  tcp  --  anywhere             anywhere             multiport dports 8123,9001:9009
ACCEPT     tcp  --  anywhere             anywhere             multiport dports 3000,3005,5443,6443,sge-qmaster,7443,9443 owner UID match nginx
ACCEPT     tcp  --  anywhere             anywhere             multiport dports 3000,3005,5443,6443,sge-qmaster,7443,9443 owner UID match cnmaestro
ACCEPT     tcp  --  anywhere             anywhere             multiport dports 3000,3005,5443,6443,sge-qmaster,7443,9443 owner UID match root
LOGREJECT  tcp  --  anywhere             anywhere             multiport dports 3000,3005,5443,6443,sge-qmaster,7443,9443
ACCEPT     tcp  --  anywhere             anywhere             multiport dports amqp,25672 owner UID match rabbitmq
ACCEPT     tcp  --  anywhere             anywhere             multiport dports amqp,25672 owner UID match cnmaestro
ACCEPT     tcp  --  anywhere             anywhere             multiport dports amqp,25672 owner UID match root
LOGREJECT  tcp  --  anywhere             anywhere             multiport dports amqp,25672
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:6379 owner UID match netdata
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:postgresql owner UID match netdata
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:27017 owner UID match netdata

Chain LOGREJECT (6 references)
target     prot opt source               destination
LOG        all  --  anywhere             anywhere             LOG level warning prefix "iptables-rejected-user: "
REJECT     all  --  anywhere             anywhere             reject-with icmp-port-unreachable
root@cnmaestro:/home/cambium#
6

I think you need to allow connections to 27017, 5432, and 6379 ports (TCP). I don’t see it is allowed and the default policy for the INPUT chain is DROP (Chain INPUT (policy DROP)).

7

I have added the iptables entry. Even after that it is not working

root@cnmaestro:/etc/netdata# iptables -L
Chain INPUT (policy DROP)
target     prot opt source               destination
ACCEPT     all  --  anywhere             anywhere
DROP       tcp  --  anywhere             anywhere             tcp flags:FIN,SYN,RST,PSH,ACK,URG/NONE
DROP       tcp  --  anywhere             anywhere             tcp flags:!FIN,SYN,RST,ACK/SYN state NEW
DROP       tcp  --  anywhere             anywhere             tcp flags:FIN,SYN,RST,PSH,ACK,URG/FIN,SYN,RST,PSH,ACK,URG
ACCEPT     all  --  anywhere             anywhere             state RELATED,ESTABLISHED
DROP       all  --  anywhere             anywhere             ctstate INVALID
ACCEPT     icmp --  anywhere             anywhere             icmp echo-request state NEW,RELATED,ESTABLISHED
ACCEPT     udp  --  anywhere             anywhere             udp dpt:3799
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:ssh
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:http
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:https
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:8300
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:8301
ACCEPT     udp  --  anywhere             anywhere             udp dpt:8301
ACCEPT     udp  --  anywhere             anywhere             udp dpt:snmp
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:18301
ACCEPT     udp  --  anywhere             anywhere             udp dpt:18301
ACCEPT     gre  --  anywhere             anywhere
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:19999
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:6379
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:postgresql
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:27017

Chain FORWARD (policy DROP)
target     prot opt source               destination

Chain OUTPUT (policy ACCEPT)
target     prot opt source               destination
ACCEPT     tcp  --  anywhere             anywhere             state ESTABLISHED
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:27017 owner UID match mongodb
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:27017 owner UID match cnmaestro
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:27017 owner UID match ha-tunnel
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:27017 owner UID match root
LOGREJECT  tcp  --  anywhere             anywhere             tcp dpt:27017
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:postgresql owner UID match postgres
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:postgresql owner UID match cnmaestro
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:postgresql owner UID match ha-tunnel
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:postgresql owner UID match root
LOGREJECT  tcp  --  anywhere             anywhere             tcp dpt:postgresql
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:6379 owner UID match redis
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:6379 owner UID match cnmaestro
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:6379 owner UID match ha-tunnel
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:6379 owner UID match root
LOGREJECT  tcp  --  anywhere             anywhere             tcp dpt:6379
ACCEPT     tcp  --  anywhere             anywhere             multiport dports 8123,9001:9009 owner UID match clickhouse
ACCEPT     tcp  --  anywhere             anywhere             multiport dports 8123,9001:9009 owner UID match cnmaestro
ACCEPT     tcp  --  anywhere             anywhere             multiport dports 8123,9001:9009 owner UID match root
LOGREJECT  tcp  --  anywhere             anywhere             multiport dports 8123,9001:9009
ACCEPT     tcp  --  anywhere             anywhere             multiport dports 3000,3005,5443,6443,sge-qmaster,7443,9443 owner UID match nginx
ACCEPT     tcp  --  anywhere             anywhere             multiport dports 3000,3005,5443,6443,sge-qmaster,7443,9443 owner UID match cnmaestro
ACCEPT     tcp  --  anywhere             anywhere             multiport dports 3000,3005,5443,6443,sge-qmaster,7443,9443 owner UID match root
LOGREJECT  tcp  --  anywhere             anywhere             multiport dports 3000,3005,5443,6443,sge-qmaster,7443,9443
ACCEPT     tcp  --  anywhere             anywhere             multiport dports amqp,25672 owner UID match rabbitmq
ACCEPT     tcp  --  anywhere             anywhere             multiport dports amqp,25672 owner UID match cnmaestro
ACCEPT     tcp  --  anywhere             anywhere             multiport dports amqp,25672 owner UID match root
LOGREJECT  tcp  --  anywhere             anywhere             multiport dports amqp,25672
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:6379 owner UID match netdata
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:postgresql owner UID match netdata
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:27017 owner UID match netdata

Chain LOGREJECT (6 references)
target     prot opt source               destination
LOG        all  --  anywhere             anywhere             LOG level warning prefix "iptables-rejected-user: "
REJECT     all  --  anywhere             anywhere             reject-with icmp-port-unreachable
root@cnmaestro:/etc/netdata# 

root@cnmaestro:/etc/netdata# sudo systemctl restart netdata
root@cnmaestro:/etc/netdata# sudo -u netdata -s
netdata@cnmaestro:/etc/netdata$ /usr/libexec/netdata/plugins.d/go.d.plugin -d -m redis
[ DEBUG ] main[main] main.go:113 plugin: name=go.d, version=v0.49.2
[ DEBUG ] main[main] main.go:115 current user: name=netdata, uid=120
[ INFO  ] main[main] agent.go:136 instance is started
[ INFO  ] main[main] setup.go:42 loading config file
[ INFO  ] main[main] setup.go:50 looking for 'go.d.conf' in [/etc/netdata /usr/lib/netdata/conf.d]
[ INFO  ] main[main] setup.go:57 found '/etc/netdata/go.d.conf
[ INFO  ] main[main] setup.go:64 config successfully loaded
[ INFO  ] main[main] agent.go:140 using config: enabled 'true', default_run 'true', max_procs '0'
[ INFO  ] main[main] setup.go:69 loading modules
[ INFO  ] main[main] setup.go:88 enabled/registered modules: 1/79
[ INFO  ] main[main] setup.go:93 building discovery config
[ INFO  ] main[main] setup.go:123 looking for 'redis.conf' in [/etc/netdata/go.d /usr/lib/netdata/conf.d/go.d]
[ INFO  ] main[main] setup.go:139 found '/etc/netdata/go.d/redis.conf
[ INFO  ] main[main] setup.go:144 dummy/read/watch paths: 0/1/0
[ INFO  ] discovery[manager] manager.go:92 registered discoverers: [file discovery: [file reader]]
[ INFO  ] discovery[manager] manager.go:97 instance is started
[ INFO  ] build[manager] build.go:107 instance is started
[ INFO  ] run[manager] run.go:32 instance is started
[ INFO  ] discovery[file manager] discovery.go:73 instance is started
[ INFO  ] discovery[file reader] read.go:41 instance is started
[ INFO  ] discovery[file reader] read.go:42 instance is stopped
[ DEBUG ] build[manager] build.go:154 received config group ('/etc/netdata/go.d/redis.conf'): 1 jobs (added: 1, removed: 0)
[ DEBUG ] build[manager] build.go:303 building redis[cnRedis] job, config: map[__provider__:file reader __source__:/etc/netdata/go.d/redis.conf address:redis://@127.0.0.1:6379 autodetection_retry:0 module:redis name:cnRedis priority:70000 update_every:1]
[ ERROR ] redis[cnRedis] redis.go:112 dial tcp 127.0.0.1:6379: connect: connection refused
[ ERROR ] redis[cnRedis] job.go:191 check failed
[ DEBUG ] run[manager] run.go:43 tick 0
[ DEBUG ] run[manager] run.go:43 tick 1
[ DEBUG ] run[manager] run.go:43 tick 2
^C[ INFO  ] main[main] agent.go:104 received interrupt signal (2). Terminating...
[ INFO  ] run[manager] run.go:33 instance is stopped
[ INFO  ] build[manager] build.go:108 instance is stopped
[ INFO  ] discovery[manager] manager.go:98 instance is stopped
[ INFO  ] main[main] agent.go:137 instance is stopped
netdata@cnmaestro:/etc/netdata$ /usr/libexec/netdata/plugins.d/go.d.plugin -d -m mongodb
[ DEBUG ] main[main] main.go:113 plugin: name=go.d, version=v0.49.2
[ DEBUG ] main[main] main.go:115 current user: name=netdata, uid=120
[ INFO  ] main[main] agent.go:136 instance is started
[ INFO  ] main[main] setup.go:42 loading config file
[ INFO  ] main[main] setup.go:50 looking for 'go.d.conf' in [/etc/netdata /usr/lib/netdata/conf.d]
[ INFO  ] main[main] setup.go:57 found '/etc/netdata/go.d.conf
[ INFO  ] main[main] setup.go:64 config successfully loaded
[ INFO  ] main[main] agent.go:140 using config: enabled 'true', default_run 'true', max_procs '0'
[ INFO  ] main[main] setup.go:69 loading modules
[ INFO  ] main[main] setup.go:88 enabled/registered modules: 1/79
[ INFO  ] main[main] setup.go:93 building discovery config
[ INFO  ] main[main] setup.go:123 looking for 'mongodb.conf' in [/etc/netdata/go.d /usr/lib/netdata/conf.d/go.d]
[ INFO  ] main[main] setup.go:139 found '/etc/netdata/go.d/mongodb.conf
[ INFO  ] main[main] setup.go:144 dummy/read/watch paths: 0/1/0
[ INFO  ] discovery[manager] manager.go:92 registered discoverers: [file discovery: [file reader]]
[ INFO  ] discovery[manager] manager.go:97 instance is started
[ INFO  ] run[manager] run.go:32 instance is started
[ INFO  ] build[manager] build.go:107 instance is started
[ INFO  ] discovery[file manager] discovery.go:73 instance is started
[ INFO  ] discovery[file reader] read.go:41 instance is started
[ INFO  ] discovery[file reader] read.go:42 instance is stopped
[ DEBUG ] build[manager] build.go:154 received config group ('/etc/netdata/go.d/mongodb.conf'): 1 jobs (added: 1, removed: 0)
[ DEBUG ] build[manager] build.go:303 building mongodb[cnMongo] job, config: map[__provider__:file reader __source__:/etc/netdata/go.d/mongodb.conf autodetection_retry:0 module:mongodb name:cnMongo priority:70000 timeout:2 update_every:1 uri:mongodb://netdata:netdata@127.0.0.1:27017]
[ DEBUG ] run[manager] run.go:43 tick 0
[ DEBUG ] run[manager] run.go:43 tick 1
[ ERROR ] mongodb[cnMongo] mongodb.go:91 init mongo conn: server selection error: context deadline exceeded, current topology: { Type: Unknown, Servers: [{ Addr: 127.0.0.1:27017, Type: Unknown, Last error: dial tcp 127.0.0.1:27017: connect: connection refused }, ] }
[ WARN  ] mongodb[cnMongo] mongodb.go:95 no values collected
[ ERROR ] mongodb[cnMongo] job.go:191 check failed
[ DEBUG ] run[manager] run.go:43 tick 2
^C[ INFO  ] main[main] agent.go:104 received interrupt signal (2). Terminating...
[ INFO  ] discovery[manager] manager.go:98 instance is stopped
[ INFO  ] discovery[file manager] discovery.go:74 instance is stopped
[ INFO  ] run[manager] run.go:33 instance is stopped
[ INFO  ] build[manager] build.go:108 instance is stopped
[ INFO  ] main[main] agent.go:137 instance is stopped
netdata@cnmaestro:/etc/netdata$ /usr/libexec/netdata/plugins.d/go.d.plugin -d -m postgres
[ DEBUG ] main[main] main.go:113 plugin: name=go.d, version=v0.49.2
[ DEBUG ] main[main] main.go:115 current user: name=netdata, uid=120
[ INFO  ] main[main] agent.go:136 instance is started
[ INFO  ] main[main] setup.go:42 loading config file
[ INFO  ] main[main] setup.go:50 looking for 'go.d.conf' in [/etc/netdata /usr/lib/netdata/conf.d]
[ INFO  ] main[main] setup.go:57 found '/etc/netdata/go.d.conf
[ INFO  ] main[main] setup.go:64 config successfully loaded
[ INFO  ] main[main] agent.go:140 using config: enabled 'true', default_run 'true', max_procs '0'
[ INFO  ] main[main] setup.go:69 loading modules
[ INFO  ] main[main] setup.go:88 enabled/registered modules: 1/79
[ INFO  ] main[main] setup.go:93 building discovery config
[ INFO  ] main[main] setup.go:123 looking for 'postgres.conf' in [/etc/netdata/go.d /usr/lib/netdata/conf.d/go.d]
[ INFO  ] main[main] setup.go:139 found '/etc/netdata/go.d/postgres.conf
[ INFO  ] main[main] setup.go:144 dummy/read/watch paths: 0/1/0
[ INFO  ] discovery[manager] manager.go:92 registered discoverers: [file discovery: [file reader]]
[ INFO  ] discovery[manager] manager.go:97 instance is started
[ INFO  ] run[manager] run.go:32 instance is started
[ INFO  ] build[manager] build.go:107 instance is started
[ INFO  ] discovery[file manager] discovery.go:73 instance is started
[ INFO  ] discovery[file reader] read.go:41 instance is started
[ INFO  ] discovery[file reader] read.go:42 instance is stopped
[ DEBUG ] build[manager] build.go:154 received config group ('/etc/netdata/go.d/postgres.conf'): 1 jobs (added: 1, removed: 0)
[ DEBUG ] build[manager] build.go:303 building postgres[cnPostgres] job, config: map[__provider__:file reader __source__:/etc/netdata/go.d/postgres.conf autodetection_retry:0 dsn:postgres://netdata:netdata@127.0.0.1:5432/cnmaestro_server module:postgres name:cnPostgres priority:70000 update_every:1]
[ ERROR ] postgres[cnPostgres] postgres.go:120 error on pinging the Postgres database [postgres://netdata:netdata@127.0.0.1:5432/cnmaestro_server]: failed to connect to `host=127.0.0.1 user=netdata database=cnmaestro_server`: dial error (dial tcp 127.0.0.1:5432: connect: connection refused)
[ ERROR ] postgres[cnPostgres] job.go:191 check failed
[ DEBUG ] run[manager] run.go:43 tick 0
[ DEBUG ] run[manager] run.go:43 tick 1
[ DEBUG ] run[manager] run.go:43 tick 2
[ DEBUG ] run[manager] run.go:43 tick 3
[ DEBUG ] run[manager] run.go:43 tick 4
^C[ INFO  ] main[main] agent.go:104 received interrupt signal (2). Terminating...
[ INFO  ] run[manager] run.go:33 instance is stopped
[ INFO  ] discovery[file manager] discovery.go:74 instance is stopped
[ INFO  ] build[manager] build.go:108 instance is stopped
[ INFO  ] discovery[manager] manager.go:98 instance is stopped
[ INFO  ] main[main] agent.go:137 instance is stopped
netdata@cnmaestro:/etc/netdata$
8

Still, the “connection refused” error. I am not sure what is happening. Try to relax your iptables rules (e.g. withour owner UID match netdata part) while testing, ensure that packets get to that chain (you see counters get increased).