I miei Films

La ragazza Danese (9)

Un ottima annata (6.5)

Martin Eden (8)

Opera senza autore (7)

Maurice (7)

Disobbedience (7)

Ammonite (7)

Il meglio deve ancora venire (7)

cosa mi lasci di te (7)

radioactive (6.9)

judy (6.9)

Le cose che non ti ho detto (7.5)

frantz (7.5)

Elisa e Marcela (7)

Dunkirk(7)

La promessa dell’alba (7)

Una vita a colori (7)

Le Pagine della nostra vita (7.5)

Lars e la ragazza tutta sua (7)

Sir (7)

where hands touch (6/7)

dalle 5 alle 7 : due ore d’amore (7.3)

I Origins(7)

Questione di tempo (7)

La persona peggiore del mondo (7.1)

500 giorni assieme (6.7)

Guida per la felicità (7)

The face of love (7.5)

Gli spiriti dell’isola (7.1)

Empire of ligth(7)

La La Land(7)

Blue Valentine (6.5)

The First Man (7.5)

Il piacere è tutto mio (7)

Sulle Ali dell’avventura (6.5)

Pietro il Fortunato (7)

Amsterdam (6.5)

IL CLUB DEL LIBRO E DELLA TORTA DI BUCCE DI PATATA DI GUERNSEY(6/7)

Il sesto senso (7)

Il lato positivo (6)

Unbreakable (6.1)

Slipt (6.1)

Get Out(6.5)

Amore a seconda vista (6.5)

Grandi Speranze(6.5)

Un Anno con Salingher(6.5)

Possession – Una storia romantica (7.5) sperando che un giorno le mie figlie siano innamorate cosi

Animali notturni (7.3)

Il segreto delle api(6/7)

C’è ancora domani(7.5)

A Beautiful life(6.5)

One Day (7)

Amore e altri rimedi (6/7)

La memoria del cuore , The vow(6.5)

Certamente, forse (6/7)

Espiazione (6.5)

Leslie (7.6)

Playing it cool (7.5)

Geisha (7.5)

Mery queen of Scots (7.6)

Il Conte di Montecristo (7/8)

Postgres system queries

check active connections

SELECT 
    pid
    ,datname as database
    ,usename as username
    ,application_name
    ,client_addr as client_address 
    ,client_hostname
    ,client_port
    ,backend_start
    ,query_start
    ,query
    ,state
FROM pg_stat_activity
WHERE state = 'active'
order by datname;

close connections

SELECT
pg_terminate_backend(pid)
FROM
pg_stat_activity
WHERE
-- don't kill my own connection!
pid <> pg_backend_pid()
-- don't kill the connections to other databases
AND datname = 'medical_center_sm'
;

 

SELECT a.datname,
l.relation::regclass,
l.transactionid,
l.mode,
l.GRANTED,
a.usename,
a.query,
a.query_start,
age(now(), a.query_start) AS “age”,
a.pid
FROM pg_stat_activity a
JOIN pg_locks l ON l.pid = a.pid
ORDER BY a.query_start;
— SELECT pg_terminate_backend(14832 );

[SOLVED] Denied DNS cache queries originating from 127.0.0.1

from here

i had thi situation:

[SOLVED] Denied DNS cache queries originating from 127.0.0.1

Hi,

recently Virtualmin complained that I needed to add 127.0.0.1 to the BIND Zones.
Since then I’ve started seeing the following entries in my /var/named/data/named.run:

13-Jan-2016 14:20:12.442 client 127.0.0.1#24778: query (cache) 'w3.org/NS/IN' denied
13-Jan-2016 14:20:12.442 client 127.0.0.1#24778: query (cache) 'comcast.net/NS/IN' denied
13-Jan-2016 14:20:12.443 client 127.0.0.1#24778: query (cache) 'akamai.com/NS/IN' denied
13-Jan-2016 14:21:03.839 client 127.0.0.1#33857: query (cache) 'cingular.com/NS/IN' denied
13-Jan-2016 14:21:03.839 client 127.0.0.1#33857: query (cache) 'kernel.org/NS/IN' denied
13-Jan-2016 14:21:03.840 client 127.0.0.1#33857: query (cache) 'gmx.net/NS/IN' denied
13-Jan-2016 19:55:38.304 client 127.0.0.1#30860: query (cache) 'sun.com/NS/IN' denied
13-Jan-2016 19:55:38.305 client 127.0.0.1#30860: query (cache) 'w3.org/NS/IN' denied
13-Jan-2016 19:55:38.307 client 127.0.0.1#30860: query (cache) 'mit.edu/NS/IN' denied

I already have the named-refused-udp and named-refused-tcp fail2ban jails activated, so I’m not worried about any such entries which originate from an external ip address.

What concerns me is those originating from 127.0.0.1.
Have I been hacked?

Thanks

i patch like this

I’ll answer my own question to help anyone else looking. To stop these entries add the following to /etc/named.conf

allow-query-cache { none; };
recursion no;
additional-from-auth no;
additional-from-cache no;
minimal-responses yes;

in this way:

options {

                listen-on port 53 { any; };

                listen-on-v6 port 53 { any; };

                directory       “/var/named”;

                dump-file       “/var/named/data/cache_dump.db”;

                statistics-file “/var/named/data/named_stats.txt”;

                memstatistics-file “/var/named/data/named_mem_stats.txt”;

                allow-query     { any; };

                allow-recursion {“none”;};

                recursion no;

                version “Not disclosed”;

                allow-query-cache { none; };

                additional-from-auth no;

                additional-from-cache no;

                minimal-responses yes;

…..