WordPress : Liste des IP que j’ai bloqué

36 x served & 1 x viewed

Voici la liste des IP que j’ai complètement bloqué, trop d’attaque :

91.200.12.114 (Ukraine)
91.200.12.65 (Ukraine)
91.200.12.4 (Ukraine) 
178.89.110.135 (Kazakhstan)
122.114.251.82 (Chine)
222.86.214.132 (Chine)
192.99.63.202 (Canada)
112.78.5.70 (Vietnam)
81.177.135.161
221.2.137.143

WordPress : Attaque par injection …

19 x served & 6 x viewed

C’était le jour des attaques par injection ( Canada, Vietnam, Russian Federation) :

 Application Firewall has blocked 180 attacks over the last 10 minutes. Below is a sample of these recent attacks:

octobre 29, 2018 12:49   192.99.63.202 (Canada)     Blocked for SQL Injection in query string: lang=eo1111111111111" UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81
octobre 29, 2018 12:49   192.99.63.202 (Canada)     Blocked for SQL Injection in query string: lang=eo1111111111111" UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81
octobre 29, 2018 12:49   192.99.63.202 (Canada)     Blocked for SQL Injection in query string: lang=eo1111111111111" UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81
octobre 29, 2018 12:49   192.99.63.202 (Canada)     Blocked for SQL Injection in query string: lang=eo1111111111111" UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81
octobre 29, 2018 12:49   192.99.63.202 (Canada)     Blocked for SQL Injection in query string: lang=eo1111111111111" UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81
octobre 29, 2018 12:49   192.99.63.202 (Canada)     Blocked for SQL Injection in query string: lang=eo1111111111111" UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81
octobre 29, 2018 12:49   192.99.63.202 (Canada)     Blocked for SQL Injection in query string: lang=eo1111111111111" UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81
octobre 29, 2018 12:49   192.99.63.202 (Canada)     Blocked for SQL Injection in query string: lang=eo1111111111111" UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81
octobre 29, 2018 12:49   192.99.63.202 (Canada)     Blocked for SQL Injection in query string: lang=eo1111111111111" UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81
octobre 29, 2018 12:49   192.99.63.202 (Canada)     Blocked for SQL Injection in query string: lang=eo1111111111111" UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81

Web Application Firewall has blocked 110 attacks over the last 10 minutes. Below is a sample of these recent attacks:

octobre 29, 2018 1:02   112.78.5.70 (Vietnam)     Blocked for SQL Injection in query string: lang=eo1111111111111' UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81
octobre 29, 2018 1:02   112.78.5.70 (Vietnam)     Blocked for SQL Injection in query string: lang=eo1111111111111' UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81
octobre 29, 2018 1:02   112.78.5.70 (Vietnam)     Blocked for SQL Injection in query string: lang=eo1111111111111' UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81
octobre 29, 2018 1:02   112.78.5.70 (Vietnam)     Blocked for SQL Injection in query string: lang=eo1111111111111' UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81
octobre 29, 2018 1:02   112.78.5.70 (Vietnam)     Blocked for SQL Injection in query string: lang=eo1111111111111' UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81
octobre 29, 2018 1:02   112.78.5.70 (Vietnam)     Blocked for SQL Injection in query string: lang=eo1111111111111' UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81
octobre 29, 2018 1:02   112.78.5.70 (Vietnam)     Blocked for SQL Injection in query string: lang=eo1111111111111' UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81
octobre 29, 2018 1:02   112.78.5.70 (Vietnam)     Blocked for SQL Injection in query string: lang=eo1111111111111' UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81
octobre 29, 2018 1:01   112.78.5.70 (Vietnam)     Blocked for SQL Injection in query string: lang=eo1111111111111' UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81
octobre 29, 2018 1:01   112.78.5.70 (Vietnam)     Blocked for SQL Injection in query string: lang=eo1111111111111' UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45) -- /* order by 'as

Web Application Firewall has blocked 182 attacks over the last 10 minutes. Below is a sample of these recent attacks:

octobre 29, 2018 1:06   112.78.5.70 (Vietnam)     Blocked for SQL Injection in query string: lang=eo1111111111111" UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81
octobre 29, 2018 1:06   112.78.5.70 (Vietnam)     Blocked for SQL Injection in query string: lang=eo1111111111111" UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81
octobre 29, 2018 1:06   112.78.5.70 (Vietnam)     Blocked for SQL Injection in query string: lang=eo1111111111111" UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81
octobre 29, 2018 1:06   112.78.5.70 (Vietnam)     Blocked for SQL Injection in query string: lang=eo1111111111111" UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81
octobre 29, 2018 1:06   112.78.5.70 (Vietnam)     Blocked for SQL Injection in query string: lang=eo1111111111111" UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81
octobre 29, 2018 1:06   112.78.5.70 (Vietnam)     Blocked for SQL Injection in query string: lang=eo1111111111111" UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81
octobre 29, 2018 1:06   112.78.5.70 (Vietnam)     Blocked for SQL Injection in query string: lang=eo1111111111111" UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81
octobre 29, 2018 1:06   112.78.5.70 (Vietnam)     Blocked for SQL Injection in query string: lang=eo1111111111111" UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81
octobre 29, 2018 1:06   112.78.5.70 (Vietnam)     Blocked for SQL Injection in query string: lang=eo1111111111111" UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81
octobre 29, 2018 1:06   112.78.5.70 (Vietnam)     Blocked for SQL Injection in query string: lang=eo1111111111111" UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81

Web Application Firewall has blocked 203 attacks over the last 10 minutes. Below is a sample of these recent attacks:

octobre 29, 2018 1:17   81.177.135.161 (Russian Federation)     Blocked for SQL Injection in query string: lang=eo" or (1,2)=(select*from(select name_const(CHAR(111,108,111,108,111,115,104,101,114),1),name_const(
octobre 29, 2018 1:17   81.177.135.161 (Russian Federation)     Blocked for SQL Injection in query string: lang=eo' or (1,2)=(select*from(select name_const(CHAR(111,108,111,108,111,115,104,101,114),1),name_const(
octobre 29, 2018 1:17   81.177.135.161 (Russian Federation)     Blocked for SQL Injection in query string: lang=eo or (1,2)=(select*from(select name_const(CHAR(111,108,111,108,111,115,104,101,114),1),name_const(C
octobre 29, 2018 1:17   81.177.135.161 (Russian Federation)     Blocked for SQL Injection in query string: lang=eo' And SLeep(3) UniON SEleCT 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,2
octobre 29, 2018 1:16   81.177.135.161 (Russian Federation)     Blocked for SQL Injection in query string: lang=eo1111111111111" UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81
octobre 29, 2018 1:16   81.177.135.161 (Russian Federation)     Blocked for SQL Injection in query string: lang=eo1111111111111" UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81
octobre 29, 2018 1:16   81.177.135.161 (Russian Federation)     Blocked for SQL Injection in query string: lang=eo1111111111111" UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81
octobre 29, 2018 1:16   81.177.135.161 (Russian Federation)     Blocked for SQL Injection in query string: lang=eo1111111111111" UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81
octobre 29, 2018 1:15   81.177.135.161 (Russian Federation)     Blocked for SQL Injection in query string: lang=eo1111111111111" UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81
octobre 29, 2018 1:15   81.177.135.161 (Russian Federation)     Blocked for SQL Injection in query string: lang=eo1111111111111" UNION SELECT CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81

Misère.

WordPress : Export vers un livre en PDF

32 x served & 6 x viewed

J’ai fait une petite sélection :

J’ai donc fait un test avec celui qui me semble être le meilleur : Blog booker : https://www.blogbooker.com/export_wordpress.php .

La première étape consiste à faire un export en XML :

Le fichier fait 35 Mo pour mon blog complet.

La seconde phase, c’est pas ici :  https://www.blogbooker.com/wordpress.php :

On indique où est le fichier XML et le lien vers le blog … et on patiente.

On se retrouve avec un Livre de 934 pages, à noter qu’il y a beaucoup d’erreur mais il n’est pas possible d’avoir la liste afin de comprendre et corriger. Le PDF fait 12 Mo, donc 1/3 du fichier XML … autant dire qu’il y a du avoir quelques ratés. Normalement j’ai 1123 articles, et il en compte 291 (25%). Mais j’ai utilisé la version Free, donc c’est normal d’avoir une limite. 

L’export des tableaux HTML ne fonctionne pas :

On va dire que c’est un bon début …

A suivre.

 

PHPNET.ORG : Bye-Bye le téléchargement des dumps de base de donnée via FTP

30 x served & 6 x viewed

Sniff, maintenant il n’y a plus le répertoire Archive/ qui contenait les bases de données. Il faut passer par l’interface … Pour moi c’est une régression !

Je dois dire que je viens de m’en apercevoir un an après … je trouvais suspect ma taille de disque.

Frédéric.

Raspberry/Munin : Monitor d’un site WordPress distant ( httpresponsetime )

94 x served & 9 x viewed

Installation d’un plugin en python : https://github.com/arthur-debert/munin-httpresponse-plugin/blob/master/httpresponsetime

$ sudo vi /usr/share/munin/plugins/httpresponsetime
 -> Copie du script.
$ sudo ln -s  /usr/share/munin/plugins/httpresponsetime /etc/munin/plugins/httpresponsetime
$ sudo chmod +x  /usr/share/munin/plugins/httpresponsetime /etc/munin/plugins/httpresponsetime
$ sudo apt-get install python-setuptools python-dev build-essential
$ sudo easy_install pip
$ sudo pip install httplib2

Ajout dans le fichier :

$ sudo vi /etc/munin/plugin-conf.d/munin-node
...
[httpresponsetime]
    env.urls http://www.cyber-neurones.org
...

Et on relance :

$ sudo munin-node-configure --shell
$ sudo service munin-node restart

Et voici le résultat :