theskett + connectivity   4

Debugging Avamar connectivity - Servergraph - Rocket Software Wiki
egrep -v "^#|^$" /data01/avamar/var/mc/server_data/postgres/data/pg_hba.conf

We tried several variations of the 'trust' and 'md5' lines, eventually found that these values / this ordering provided (passwordless, presumably) access from Servergraph:

local all all trust
host mcdb all trust
host all all trust
host all all ::1/128 trust
host mcdb all md5
host mcdb all ::0/0 md5
(The pg_hba.conf lines above configure passwordless access to the mcdb database, from only the Servergraph server's IP address.)

(We saved copies of the original pg_hba.conf files, with a .2016-06-14 date suffix.)

Note that after editing pg_hba.conf , PostgreSQL must be reloaded – and it was necessary to specify the PostgreSQL data directory:

pg_ctl reload -D /data01/avamar/var/mc/server_data/postgres/data
servergraph  avamar  postgres  postgresql  connection  connectivity  debug 
8 weeks ago by theskett
BSI - CERT-Bund Reports: HOWTOs: Openly accessible MSSQL browser services
To check if an MSSQL browser service is openly accessible from the Internet, connect to the MS-SQL server using 'netcat' as follows:

$ netcat -u 1434
Then, press <Ctrl+B> followed by <Enter>.

An openly accessible MSSQL browser service will return a response like this:



Otherwise, there will be no response.
ms  sql  sequel  server  browser  microsoft  netcat  nc  test  port  open  connection  connectivity  mssql  ms-sql  connect 
december 2017 by theskett

Copy this bookmark: