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 10.100.5.42/32 trust
host all all 127.0.0.1/32 trust
host all all ::1/128 trust
host mcdb all 0.0.0.0/0 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 192.168.45.67 1434
Then, press <Ctrl+B> followed by <Enter>.

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

ServerName;S16362421;InstanceName;MSSQLSERVER2012;

IsClustered;No;Version;11.0.2100.60;tcp;49511;np;

\\S16462341\pipe\MSSQL$MSSQLSERVER2012\sql\query;;
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:



description:


tags: