<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="es">
	<id>https://wiki.tecnicorioja.com/api.php?action=feedcontributions&amp;feedformat=atom&amp;user=Dcerdera</id>
	<title>Wiki Técnico Rioja. Administra tus sistemas. - Contribuciones del usuario [es]</title>
	<link rel="self" type="application/atom+xml" href="https://wiki.tecnicorioja.com/api.php?action=feedcontributions&amp;feedformat=atom&amp;user=Dcerdera"/>
	<link rel="alternate" type="text/html" href="https://wiki.tecnicorioja.com/index.php?title=Especial:Contribuciones/Dcerdera"/>
	<updated>2026-07-23T20:36:06Z</updated>
	<subtitle>Contribuciones del usuario</subtitle>
	<generator>MediaWiki 1.43.0</generator>
	<entry>
		<id>https://wiki.tecnicorioja.com/index.php?title=ISCSI&amp;diff=27</id>
		<title>ISCSI</title>
		<link rel="alternate" type="text/html" href="https://wiki.tecnicorioja.com/index.php?title=ISCSI&amp;diff=27"/>
		<updated>2025-02-03T21:03:41Z</updated>

		<summary type="html">&lt;p&gt;Dcerdera: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== &#039;&#039;&#039; Script para configurar ISCSI en windows con multipath. Requisito tener MPIO instalado. &#039;&#039;&#039; ==&amp;lt;br&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
[http://ISCSI%20for%20windows https://www.tecnicorioja.com/utilidades/iscsi.zip]&lt;/div&gt;</summary>
		<author><name>Dcerdera</name></author>
	</entry>
	<entry>
		<id>https://wiki.tecnicorioja.com/index.php?title=ISCSI&amp;diff=26</id>
		<title>ISCSI</title>
		<link rel="alternate" type="text/html" href="https://wiki.tecnicorioja.com/index.php?title=ISCSI&amp;diff=26"/>
		<updated>2025-02-03T21:02:52Z</updated>

		<summary type="html">&lt;p&gt;Dcerdera: Página creada con «=== Script para configurar ISCSI en windows con multipath. Requisito tener MPIO instalado. ===  [http://ISCSI%20for%20windows https://www.tecnicorioja.com/utilidades/iscsi.zip]»&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;=== Script para configurar ISCSI en windows con multipath.&lt;br /&gt;
Requisito tener MPIO instalado. ===&lt;br /&gt;
&lt;br /&gt;
[http://ISCSI%20for%20windows https://www.tecnicorioja.com/utilidades/iscsi.zip]&lt;/div&gt;</summary>
		<author><name>Dcerdera</name></author>
	</entry>
	<entry>
		<id>https://wiki.tecnicorioja.com/index.php?title=One-liners&amp;diff=25</id>
		<title>One-liners</title>
		<link rel="alternate" type="text/html" href="https://wiki.tecnicorioja.com/index.php?title=One-liners&amp;diff=25"/>
		<updated>2025-01-30T11:50:39Z</updated>

		<summary type="html">&lt;p&gt;Dcerdera: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[[Categoría: Linux]]&lt;br /&gt;
=== &#039;&#039;&#039;Apache&#039;&#039;&#039;===&lt;br /&gt;
&#039;&#039;&#039;Este solo dominios:&#039;&#039;&#039;&lt;br /&gt;
&amp;lt;pre&amp;gt;tail -n 5000 /srv/log/httpd/access_log | awk &#039;{print $1}&#039; | sort | uniq -c |sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Este es para las ip: nos saca las IP que le estan dando cera a la maquina&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;tail -n 5000 /srv/log/httpd/access_log | awk &#039;{print $2}&#039; | sort | uniq -c |sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Este te muestra ip y dominio:&#039;&#039;&#039;&lt;br /&gt;
&amp;lt;pre&amp;gt;tail -n 5000 /srv/log/httpd/access_log | awk &#039;{print $1, $2}&#039; | sort | uniq -c |sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Conexiones&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;netstat -putan | egrep &#039;:80|:443&#039; | sort -k5&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;netstat -tlna | egrep &amp;quot;(:80|:443)&amp;quot; | awk &#039;{print $5}&#039; | cut -d &amp;quot;:&amp;quot; -f 1 | sort | uniq -c | sort -n&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;watch  &amp;quot;netstat -ntlpa | egrep &#039;:80|:443&#039; | awk &#039;{print \$5}&#039; | cut -d: -f1 | sort | uniq -c | sort -n| tail -n 20&amp;quot;&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Pseudotop con CPU solo de los procesos php&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;watch &amp;quot;ps -eo pid,user,%cpu,%mem,command --sort=-%cpu | grep &#039;[p]hp-fpm&#039;&amp;quot;&amp;lt;/pre&amp;gt;&lt;br /&gt;
&#039;&#039;&#039;Conexiones a puertos 80|443&#039;&#039;&#039;&lt;br /&gt;
&amp;lt;pre&amp;gt;netstat -tlna | egrep &amp;quot;:80|:443&amp;quot; | awk {&#039;print $5&#039;} | cut -d &#039;:&#039; -f 1 | sort | uniq -c | sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Ataque a xmlrpc.php&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;cat  /srv/log/httpd/access_log | awk &#039;{print $1&amp;quot; &amp;quot; $2 &amp;quot; &amp;quot; $8}&#039; | grep xmlrpc.php | sort | uniq -c |sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Buscar errores 404|403&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;cat /srv/log/httpd/access_log | grep -E &#039;HTTP/2.0&amp;quot; (403|404)&#039; | awk &#039;{print $1, $2, $8, $10}&#039; | sort | uniq -c | sort -n | tail -n 50&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Reiniciar Apache + php-fpm + xymon&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt; systemctl restart php* httpd xymon &amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
===Mysql===&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Ver procesos interactivamente.&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;watch -d -n0.5 &#039;mysql -e &amp;quot;show processlist;&amp;quot; |grep -v Sleep | sort -k2&#039;&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Ver conexiones ( ips origen )&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;watch  &amp;quot;netstat -ntlpa | grep &#039;:3306&#039; | awk &#039;{print \$5}&#039; | cut -d: -f1 | sort | uniq -c | sort -n| tail -n 20&amp;quot;&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Matar procesos de mas de 100 segundos&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;mysql -e &#039;SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST where time&amp;gt;100 &#039; | grep -v scheduler | awk &#039;{print &amp;quot;kill &amp;quot;$1&amp;quot;;&amp;quot;}&#039;|grep -v ID |mysql&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Matar procesos de una BBDD&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;mysql -e &amp;quot;show full processlist&amp;quot; | grep qaeo957  | awk &#039;{print &amp;quot;mysql -e \&amp;quot;kill &amp;quot; $1 &amp;quot;\&amp;quot;&amp;quot;}&#039; | sh&amp;lt;/pre&amp;gt;&lt;/div&gt;</summary>
		<author><name>Dcerdera</name></author>
	</entry>
	<entry>
		<id>https://wiki.tecnicorioja.com/index.php?title=One-liners&amp;diff=24</id>
		<title>One-liners</title>
		<link rel="alternate" type="text/html" href="https://wiki.tecnicorioja.com/index.php?title=One-liners&amp;diff=24"/>
		<updated>2025-01-30T11:49:31Z</updated>

		<summary type="html">&lt;p&gt;Dcerdera: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[[Categoría: Linux]]&lt;br /&gt;
=== &#039;&#039;&#039;Apache&#039;&#039;&#039;===&lt;br /&gt;
Últimas 5000 líneas por dominio de todos los dominios&lt;br /&gt;
&amp;lt;pre&amp;gt;tail -n 5000 /srv/log/httpd/access_log | awk &#039;{print $1}&#039; | sort | uniq -c |sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Últimas 5000 líneas por ip de todos los dominios&#039;&#039;&#039;&lt;br /&gt;
&amp;lt;pre&amp;gt;tail -n 5000 /srv/log/httpd/access_log | awk &#039;{print $2}&#039; | sort | uniq -c |sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;tail -n 5000 /srv/log/httpd/access_log | awk &#039;{print $1, $2}&#039; | sort | uniq -c |sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Conexiones&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;netstat -putan | egrep &#039;:80|:443&#039; | sort -k5&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;netstat -tlna | egrep &amp;quot;(:80|:443)&amp;quot; | awk &#039;{print $5}&#039; | cut -d &amp;quot;:&amp;quot; -f 1 | sort | uniq -c | sort -n&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;watch  &amp;quot;netstat -ntlpa | egrep &#039;:80|:443&#039; | awk &#039;{print \$5}&#039; | cut -d: -f1 | sort | uniq -c | sort -n| tail -n 20&amp;quot;&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Pseudotop con CPU solo de los procesos php&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;watch &amp;quot;ps -eo pid,user,%cpu,%mem,command --sort=-%cpu | grep &#039;[p]hp-fpm&#039;&amp;quot;&amp;lt;/pre&amp;gt;&lt;br /&gt;
&#039;&#039;&#039;Conexiones a puertos 80|443&#039;&#039;&#039;&lt;br /&gt;
&amp;lt;pre&amp;gt;netstat -tlna | egrep &amp;quot;:80|:443&amp;quot; | awk {&#039;print $5&#039;} | cut -d &#039;:&#039; -f 1 | sort | uniq -c | sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Ataque a xmlrpc.php&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;cat  /srv/log/httpd/access_log | awk &#039;{print $1&amp;quot; &amp;quot; $2 &amp;quot; &amp;quot; $8}&#039; | grep xmlrpc.php | sort | uniq -c |sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Buscar errores 404|403&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;cat /srv/log/httpd/access_log | grep -E &#039;HTTP/2.0&amp;quot; (403|404)&#039; | awk &#039;{print $1, $2, $8, $10}&#039; | sort | uniq -c | sort -n | tail -n 50&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Reiniciar Apache + php-fpm + xymon&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt; systemctl restart php* httpd xymon &amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
===Mysql===&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Ver procesos interactivamente.&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;watch -d -n0.5 &#039;mysql -e &amp;quot;show processlist;&amp;quot; |grep -v Sleep | sort -k2&#039;&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Ver conexiones ( ips origen )&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;watch  &amp;quot;netstat -ntlpa | grep &#039;:3306&#039; | awk &#039;{print \$5}&#039; | cut -d: -f1 | sort | uniq -c | sort -n| tail -n 20&amp;quot;&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Matar procesos de mas de 100 segundos&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;mysql -e &#039;SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST where time&amp;gt;100 &#039; | grep -v scheduler | awk &#039;{print &amp;quot;kill &amp;quot;$1&amp;quot;;&amp;quot;}&#039;|grep -v ID |mysql&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Matar procesos de una BBDD&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;mysql -e &amp;quot;show full processlist&amp;quot; | grep qaeo957  | awk &#039;{print &amp;quot;mysql -e \&amp;quot;kill &amp;quot; $1 &amp;quot;\&amp;quot;&amp;quot;}&#039; | sh&amp;lt;/pre&amp;gt;&lt;/div&gt;</summary>
		<author><name>Dcerdera</name></author>
	</entry>
	<entry>
		<id>https://wiki.tecnicorioja.com/index.php?title=One-liners&amp;diff=23</id>
		<title>One-liners</title>
		<link rel="alternate" type="text/html" href="https://wiki.tecnicorioja.com/index.php?title=One-liners&amp;diff=23"/>
		<updated>2025-01-30T11:46:30Z</updated>

		<summary type="html">&lt;p&gt;Dcerdera: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[[Categoría: Linux]]&lt;br /&gt;
=== &#039;&#039;&#039;Apache&#039;&#039;&#039;===&lt;br /&gt;
Últimas 5000 líneas por dominio de todos los dominios&lt;br /&gt;
&amp;lt;pre&amp;gt;tail -n 5000 /srv/log/httpd/access_log | awk &#039;{print $1}&#039; | sort | uniq -c |sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Últimas 5000 líneas por ip de todos los dominios&#039;&#039;&#039;&lt;br /&gt;
&amp;lt;pre&amp;gt;tail -n 5000 /srv/log/httpd/access_log | awk &#039;{print $2}&#039; | sort | uniq -c |sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Pseudotop con CPU solo de los procesos php&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;watch &amp;quot;ps -eo pid,user,%cpu,%mem,command --sort=-%cpu | grep &#039;[p]hp-fpm&#039;&amp;quot;&amp;lt;/pre&amp;gt;&lt;br /&gt;
&#039;&#039;&#039;Conexiones a puertos 80|443&#039;&#039;&#039;&lt;br /&gt;
&amp;lt;pre&amp;gt;netstat -tlna | egrep &amp;quot;:80|:443&amp;quot; | awk {&#039;print $5&#039;} | cut -d &#039;:&#039; -f 1 | sort | uniq -c | sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Ataque a xmlrpc.php&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;cat  /srv/log/httpd/access_log | awk &#039;{print $1&amp;quot; &amp;quot; $2 &amp;quot; &amp;quot; $8}&#039; | grep xmlrpc.php | sort | uniq -c |sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Buscar errores 404|403&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;cat /srv/log/httpd/access_log | grep -E &#039;HTTP/2.0&amp;quot; (403|404)&#039; | awk &#039;{print $1, $2, $8, $10}&#039; | sort | uniq -c | sort -n | tail -n 50&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Reiniciar Apache + php-fpm + xymon&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt; systemctl restart php* httpd xymon &amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
===Mysql===&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Ver procesos interactivamente.&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;watch -d -n0.5 &#039;mysql -e &amp;quot;show processlist;&amp;quot; |grep -v Sleep | sort -k2&#039;&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Ver conexiones ( ips origen )&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;watch  &amp;quot;netstat -ntlpa | grep &#039;:3306&#039; | awk &#039;{print \$5}&#039; | cut -d: -f1 | sort | uniq -c | sort -n| tail -n 20&amp;quot;&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;netstat -putan | egrep &#039;:80|:443&#039; | sort -k5&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;netstat -tlna | egrep &amp;quot;(:80|:443)&amp;quot; | awk &#039;{print $5}&#039; | cut -d &amp;quot;:&amp;quot; -f 1 | sort | uniq -c | sort -n&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Matar procesos de mas de 100 segundos&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;mysql -e &#039;SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST where time&amp;gt;100 &#039; | grep -v scheduler | awk &#039;{print &amp;quot;kill &amp;quot;$1&amp;quot;;&amp;quot;}&#039;|grep -v ID |mysql&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Matar procesos de una BBDD&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;mysql -e &amp;quot;show full processlist&amp;quot; | grep qaeo957  | awk &#039;{print &amp;quot;mysql -e \&amp;quot;kill &amp;quot; $1 &amp;quot;\&amp;quot;&amp;quot;}&#039; | sh&amp;lt;/pre&amp;gt;&lt;/div&gt;</summary>
		<author><name>Dcerdera</name></author>
	</entry>
	<entry>
		<id>https://wiki.tecnicorioja.com/index.php?title=One-liners&amp;diff=22</id>
		<title>One-liners</title>
		<link rel="alternate" type="text/html" href="https://wiki.tecnicorioja.com/index.php?title=One-liners&amp;diff=22"/>
		<updated>2025-01-30T08:52:21Z</updated>

		<summary type="html">&lt;p&gt;Dcerdera: /* Mysql */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[[Categoría: Linux]]&lt;br /&gt;
=== &#039;&#039;&#039;Apache&#039;&#039;&#039;===&lt;br /&gt;
Últimas 5000 líneas por dominio de todos los dominios&lt;br /&gt;
&amp;lt;pre&amp;gt;tail -n 5000 /srv/log/httpd/access_log | awk &#039;{print $1}&#039; | sort | uniq -c |sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Últimas 5000 líneas por ip de todos los dominios&#039;&#039;&#039;&lt;br /&gt;
&amp;lt;pre&amp;gt;tail -n 5000 /srv/log/httpd/access_log | awk &#039;{print $2}&#039; | sort | uniq -c |sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Pseudotop con CPU solo de los procesos php&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;watch &amp;quot;ps -eo pid,user,%cpu,%mem,command --sort=-%cpu | grep &#039;[p]hp-fpm&#039;&amp;quot;&amp;lt;/pre&amp;gt;&lt;br /&gt;
&#039;&#039;&#039;Conexiones a puertos 80|443&#039;&#039;&#039;&lt;br /&gt;
&amp;lt;pre&amp;gt;netstat -tlna | egrep &amp;quot;:80|:443&amp;quot; | awk {&#039;print $5&#039;} | cut -d &#039;:&#039; -f 1 | sort | uniq -c | sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Ataque a xmlrpc.php&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;cat  /srv/log/httpd/access_log | awk &#039;{print $1&amp;quot; &amp;quot; $2 &amp;quot; &amp;quot; $8}&#039; | grep xmlrpc.php | sort | uniq -c |sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Buscar errores 404|403&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;cat /srv/log/httpd/access_log | grep -E &#039;HTTP/2.0&amp;quot; (403|404)&#039; | awk &#039;{print $1, $2, $8, $10}&#039; | sort | uniq -c | sort -n | tail -n 50&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Reiniciar Apache + php-fpm + xymon&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt; systemctl restart php* httpd xymon &amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
===Mysql===&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Ver procesos interactivamente.&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;watch -d -n0.5 &#039;mysql -e &amp;quot;show processlist;&amp;quot; |grep -v Sleep | sort -k2&#039;&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Ver conexiones ( ips origen )&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;watch  &amp;quot;netstat -ntlpa | grep &#039;:3306&#039; | awk &#039;{print \$5}&#039; | cut -d: -f1 | sort | uniq -c | sort -n| tail -n 20&amp;quot;&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Matar procesos de mas de 100 segundos&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;mysql -e &#039;SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST where time&amp;gt;100 &#039; | grep -v scheduler | awk &#039;{print &amp;quot;kill &amp;quot;$1&amp;quot;;&amp;quot;}&#039;|grep -v ID |mysql&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Matar procesos de una BBDD&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;mysql -e &amp;quot;show full processlist&amp;quot; | grep qaeo957  | awk &#039;{print &amp;quot;mysql -e \&amp;quot;kill &amp;quot; $1 &amp;quot;\&amp;quot;&amp;quot;}&#039; | sh&amp;lt;/pre&amp;gt;&lt;/div&gt;</summary>
		<author><name>Dcerdera</name></author>
	</entry>
	<entry>
		<id>https://wiki.tecnicorioja.com/index.php?title=One-liners&amp;diff=21</id>
		<title>One-liners</title>
		<link rel="alternate" type="text/html" href="https://wiki.tecnicorioja.com/index.php?title=One-liners&amp;diff=21"/>
		<updated>2025-01-30T08:38:52Z</updated>

		<summary type="html">&lt;p&gt;Dcerdera: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[[Categoría: Linux]]&lt;br /&gt;
=== &#039;&#039;&#039;Apache&#039;&#039;&#039;===&lt;br /&gt;
Últimas 5000 líneas por dominio de todos los dominios&lt;br /&gt;
&amp;lt;pre&amp;gt;tail -n 5000 /srv/log/httpd/access_log | awk &#039;{print $1}&#039; | sort | uniq -c |sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Últimas 5000 líneas por ip de todos los dominios&#039;&#039;&#039;&lt;br /&gt;
&amp;lt;pre&amp;gt;tail -n 5000 /srv/log/httpd/access_log | awk &#039;{print $2}&#039; | sort | uniq -c |sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Pseudotop con CPU solo de los procesos php&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;watch &amp;quot;ps -eo pid,user,%cpu,%mem,command --sort=-%cpu | grep &#039;[p]hp-fpm&#039;&amp;quot;&amp;lt;/pre&amp;gt;&lt;br /&gt;
&#039;&#039;&#039;Conexiones a puertos 80|443&#039;&#039;&#039;&lt;br /&gt;
&amp;lt;pre&amp;gt;netstat -tlna | egrep &amp;quot;:80|:443&amp;quot; | awk {&#039;print $5&#039;} | cut -d &#039;:&#039; -f 1 | sort | uniq -c | sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Ataque a xmlrpc.php&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;cat  /srv/log/httpd/access_log | awk &#039;{print $1&amp;quot; &amp;quot; $2 &amp;quot; &amp;quot; $8}&#039; | grep xmlrpc.php | sort | uniq -c |sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Buscar errores 404|403&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;cat /srv/log/httpd/access_log | grep -E &#039;HTTP/2.0&amp;quot; (403|404)&#039; | awk &#039;{print $1, $2, $8, $10}&#039; | sort | uniq -c | sort -n | tail -n 50&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Reiniciar Apache + php-fpm + xymon&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt; systemctl restart php* httpd xymon &amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
===Mysql===&lt;br /&gt;
&lt;br /&gt;
Ver procesos interactivamente.&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;watch -d -n0.5 &#039;mysql -e &amp;quot;show processlist;&amp;quot; |grep -v Sleep | sort -k2&#039;&amp;lt;/pre&amp;gt;&lt;/div&gt;</summary>
		<author><name>Dcerdera</name></author>
	</entry>
	<entry>
		<id>https://wiki.tecnicorioja.com/index.php?title=Limpieza&amp;diff=20</id>
		<title>Limpieza</title>
		<link rel="alternate" type="text/html" href="https://wiki.tecnicorioja.com/index.php?title=Limpieza&amp;diff=20"/>
		<updated>2025-01-30T08:06:54Z</updated>

		<summary type="html">&lt;p&gt;Dcerdera: Página creada con «== &amp;#039;&amp;#039;&amp;#039;Comandos de limpieza&amp;#039;&amp;#039;&amp;#039; ==  &amp;#039;&amp;#039;&amp;#039;Borrar ultimas 5 líneas del history&amp;#039;&amp;#039;&amp;#039;  &amp;lt;pre&amp;gt;for i in {1..5}; do history -d $(history 1 | awk &amp;#039;{print $1}&amp;#039;); done&amp;lt;/pre&amp;gt;»&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== &#039;&#039;&#039;Comandos de limpieza&#039;&#039;&#039; ==&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Borrar ultimas 5 líneas del history&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;for i in {1..5}; do history -d $(history 1 | awk &#039;{print $1}&#039;); done&amp;lt;/pre&amp;gt;&lt;/div&gt;</summary>
		<author><name>Dcerdera</name></author>
	</entry>
	<entry>
		<id>https://wiki.tecnicorioja.com/index.php?title=One-liners&amp;diff=19</id>
		<title>One-liners</title>
		<link rel="alternate" type="text/html" href="https://wiki.tecnicorioja.com/index.php?title=One-liners&amp;diff=19"/>
		<updated>2025-01-30T07:50:37Z</updated>

		<summary type="html">&lt;p&gt;Dcerdera: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[[Categoría: Linux]]&lt;br /&gt;
=== &#039;&#039;&#039;Apache&#039;&#039;&#039;===&lt;br /&gt;
Últimas 5000 líneas por dominio de todos los dominios&lt;br /&gt;
&amp;lt;pre&amp;gt;tail -n 5000 /srv/log/httpd/access_log | awk &#039;{print $1}&#039; | sort | uniq -c |sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Últimas 5000 líneas por ip de todos los dominios&#039;&#039;&#039;&lt;br /&gt;
&amp;lt;pre&amp;gt;tail -n 5000 /srv/log/httpd/access_log | awk &#039;{print $2}&#039; | sort | uniq -c |sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Pseudotop con CPU solo de los procesos php&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;watch &amp;quot;ps -eo pid,user,%cpu,%mem,command --sort=-%cpu | grep &#039;[p]hp-fpm&#039;&amp;quot;&amp;lt;/pre&amp;gt;&lt;br /&gt;
&#039;&#039;&#039;Conexiones a puertos 80|443&#039;&#039;&#039;&lt;br /&gt;
&amp;lt;pre&amp;gt;netstat -tlna | egrep &amp;quot;:80|:443&amp;quot; | awk {&#039;print $5&#039;} | cut -d &#039;:&#039; -f 1 | sort | uniq -c | sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Ataque a xmlrpc.php&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;cat  /srv/log/httpd/access_log | awk &#039;{print $1&amp;quot; &amp;quot; $2 &amp;quot; &amp;quot; $8}&#039; | grep xmlrpc.php | sort | uniq -c |sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Buscar errores 404|403&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;cat /srv/log/httpd/access_log | grep -E &#039;HTTP/2.0&amp;quot; (403|404)&#039; | awk &#039;{print $1, $2, $8, $10}&#039; | sort | uniq -c | sort -n | tail -n 50&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Reiniciar Apache + php-fpm + xymon&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt; systemctl restart php* httpd xymon &amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
===Mysql===&lt;/div&gt;</summary>
		<author><name>Dcerdera</name></author>
	</entry>
	<entry>
		<id>https://wiki.tecnicorioja.com/index.php?title=One-liners&amp;diff=18</id>
		<title>One-liners</title>
		<link rel="alternate" type="text/html" href="https://wiki.tecnicorioja.com/index.php?title=One-liners&amp;diff=18"/>
		<updated>2025-01-30T07:43:34Z</updated>

		<summary type="html">&lt;p&gt;Dcerdera: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[[Categoría: Linux]]&lt;br /&gt;
=== &#039;&#039;&#039;Apache&#039;&#039;&#039;===&lt;br /&gt;
Últimas 5000 líneas por dominio de todos los dominios&lt;br /&gt;
&amp;lt;pre&amp;gt;tail -n 5000 /srv/log/httpd/access_log | awk &#039;{print $1}&#039; | sort | uniq -c |sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Últimas 5000 líneas por ip de todos los dominios&#039;&#039;&#039;&lt;br /&gt;
&amp;lt;pre&amp;gt;tail -n 5000 /srv/log/httpd/access_log | awk &#039;{print $2}&#039; | sort | uniq -c |sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Conexiones a puertos 80|443&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;netstat -tlna | egrep &amp;quot;:80|:443&amp;quot; | awk {&#039;print $5&#039;} | cut -d &#039;:&#039; -f 1 | sort | uniq -c | sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Ataque a xmlrpc.php&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;cat  /srv/log/httpd/access_log | awk &#039;{print $1&amp;quot; &amp;quot; $2 &amp;quot; &amp;quot; $8}&#039; | grep xmlrpc.php | sort | uniq -c |sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
Buscar errores 404|403&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;cat /srv/log/httpd/access_log | grep -E &#039;HTTP/2.0&amp;quot; (403|404)&#039; | awk &#039;{print $1, $2, $8, $10}&#039; | sort | uniq -c | sort -n | tail -n 50&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Reiniciar Apache + php-fpm + xymon&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt; systemctl restart php* httpd xymon &amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
===Mysql===&lt;/div&gt;</summary>
		<author><name>Dcerdera</name></author>
	</entry>
	<entry>
		<id>https://wiki.tecnicorioja.com/index.php?title=One-liners&amp;diff=17</id>
		<title>One-liners</title>
		<link rel="alternate" type="text/html" href="https://wiki.tecnicorioja.com/index.php?title=One-liners&amp;diff=17"/>
		<updated>2025-01-30T07:32:28Z</updated>

		<summary type="html">&lt;p&gt;Dcerdera: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[[Categoría: Linux]]&lt;br /&gt;
=== Apache===&lt;br /&gt;
Últimas 5000 líneas por dominio de todos los dominios&lt;br /&gt;
&amp;lt;pre&amp;gt;tail -n 5000 /srv/log/httpd/access_log | awk &#039;{print $1}&#039; | sort | uniq -c |sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
Últimas 5000 líneas por ip de todos los dominios&lt;br /&gt;
&amp;lt;pre&amp;gt;tail -n 5000 /srv/log/httpd/access_log | awk &#039;{print $2}&#039; | sort | uniq -c |sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
Conexiones a puertos 80|443&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;netstat -tlna | egrep &amp;quot;:80|:443&amp;quot; | awk {&#039;print $5&#039;} | cut -d &#039;:&#039; -f 1 | sort | uniq -c | sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
Ataque a xmlrpc.php&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;cat  /srv/log/httpd/access_log | awk &#039;{print $1&amp;quot; &amp;quot; $2 &amp;quot; &amp;quot; $8}&#039; | grep xmlrpc.php | sort | uniq -c |sort -n | tail&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
===Mysql===&lt;/div&gt;</summary>
		<author><name>Dcerdera</name></author>
	</entry>
	<entry>
		<id>https://wiki.tecnicorioja.com/index.php?title=Plesk&amp;diff=16</id>
		<title>Plesk</title>
		<link rel="alternate" type="text/html" href="https://wiki.tecnicorioja.com/index.php?title=Plesk&amp;diff=16"/>
		<updated>2025-01-29T22:04:55Z</updated>

		<summary type="html">&lt;p&gt;Dcerdera: Página creada con « === &amp;#039;&amp;#039;&amp;#039;Detectar el ataque&amp;#039;&amp;#039;&amp;#039; ===  ===&amp;#039;&amp;#039;&amp;#039; Web &amp;#039;&amp;#039;&amp;#039;===  === &amp;#039;&amp;#039;&amp;#039;Mysql&amp;#039;&amp;#039;&amp;#039; ===  &amp;lt;pre&amp;gt; watch -n 0.5 &amp;#039;mysql -uadmin -p`cat /etc/psa/.psa.shadow` -e &amp;quot;show processlist;&amp;quot;&amp;#039; &amp;lt;/pre&amp;gt;  === &amp;#039;&amp;#039;&amp;#039;Max_children&amp;#039;&amp;#039;&amp;#039; ===   ===&amp;#039;&amp;#039;&amp;#039;Script Analisis&amp;#039;&amp;#039;&amp;#039;===  &amp;lt;pre&amp;gt;wget https://tecnicorioja.com/utilidades/menu.sh&amp;lt;/pre&amp;gt; &amp;lt;pre&amp;gt;chmod +x menu.sh&amp;lt;/pre&amp;gt;»&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;&lt;br /&gt;
=== &#039;&#039;&#039;Detectar el ataque&#039;&#039;&#039; ===&lt;br /&gt;
&lt;br /&gt;
===&#039;&#039;&#039; Web &#039;&#039;&#039;===&lt;br /&gt;
&lt;br /&gt;
=== &#039;&#039;&#039;Mysql&#039;&#039;&#039; ===&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt; watch -n 0.5 &#039;mysql -uadmin -p`cat /etc/psa/.psa.shadow` -e &amp;quot;show processlist;&amp;quot;&#039; &amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
=== &#039;&#039;&#039;Max_children&#039;&#039;&#039; ===&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
===&#039;&#039;&#039;Script Analisis&#039;&#039;&#039;===&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;wget https://tecnicorioja.com/utilidades/menu.sh&amp;lt;/pre&amp;gt;&lt;br /&gt;
&amp;lt;pre&amp;gt;chmod +x menu.sh&amp;lt;/pre&amp;gt;&lt;/div&gt;</summary>
		<author><name>Dcerdera</name></author>
	</entry>
	<entry>
		<id>https://wiki.tecnicorioja.com/index.php?title=Ddos-attack&amp;diff=15</id>
		<title>Ddos-attack</title>
		<link rel="alternate" type="text/html" href="https://wiki.tecnicorioja.com/index.php?title=Ddos-attack&amp;diff=15"/>
		<updated>2025-01-29T21:42:54Z</updated>

		<summary type="html">&lt;p&gt;Dcerdera: Página creada con «Categoría: Linux Detección del ataque  ===&amp;#039;&amp;#039;&amp;#039;SSH&amp;#039;&amp;#039;&amp;#039;=== &amp;lt;pre&amp;gt; journalctl --since &amp;quot;24 hour ago&amp;quot; | grep -i &amp;quot;Failed password for invalid user&amp;quot; | awk &amp;#039;{print $13}&amp;#039; | sort -n | uniq  &amp;lt;/pre&amp;gt;  &amp;lt;pre&amp;gt; journalctl --since &amp;quot;24 hour ago&amp;quot; | grep -i &amp;quot;Failed password for root &amp;quot; | awk &amp;#039;{print $11}&amp;#039; | sort -n | uniq &amp;lt;/pre&amp;gt;  ===&amp;#039;&amp;#039;&amp;#039;MYSQL&amp;#039;&amp;#039;&amp;#039;=== &amp;#039;&amp;#039;&amp;#039;En plesk&amp;#039;&amp;#039;&amp;#039;: &amp;lt;pre&amp;gt; watch -n 0.5 &amp;#039;mysql -uadmin -p`cat /etc/psa/.psa.shadow` -e &amp;quot;show processlist;&amp;quot;&amp;#039; &amp;lt;/pre&amp;gt;  ===&amp;#039;&amp;#039;&amp;#039;WEB&amp;#039;&amp;#039;&amp;#039;===   ===&amp;#039;&amp;#039;&amp;#039;Postfi…»&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[[Categoría: Linux]]&lt;br /&gt;
Detección del ataque&lt;br /&gt;
&lt;br /&gt;
===&#039;&#039;&#039;SSH&#039;&#039;&#039;===&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
journalctl --since &amp;quot;24 hour ago&amp;quot; | grep -i &amp;quot;Failed password for invalid user&amp;quot; | awk &#039;{print $13}&#039; | sort -n | uniq  &amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt; journalctl --since &amp;quot;24 hour ago&amp;quot; | grep -i &amp;quot;Failed password for root &amp;quot; | awk &#039;{print $11}&#039; | sort -n | uniq &amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
===&#039;&#039;&#039;MYSQL&#039;&#039;&#039;===&lt;br /&gt;
&#039;&#039;&#039;En plesk&#039;&#039;&#039;:&lt;br /&gt;
&amp;lt;pre&amp;gt; watch -n 0.5 &#039;mysql -uadmin -p`cat /etc/psa/.psa.shadow` -e &amp;quot;show processlist;&amp;quot;&#039; &amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
===&#039;&#039;&#039;WEB&#039;&#039;&#039;===&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
===&#039;&#039;&#039;Postfix&#039;&#039;&#039; ===&lt;br /&gt;
Intentos fallidos de login&lt;br /&gt;
&amp;lt;pre&amp;gt;journalctl --since &amp;quot;4 hour ago&amp;quot; | grep &amp;quot;SASL LOGIN authentication failed:&amp;quot; |  awk &#039;{print $7}&#039;| cut -d [ -f2 | cut -d ] -f1 | sort -n | uniq -c | sort -n | awk &#039;{print $2}&#039;&amp;lt;/pre&amp;gt;&lt;/div&gt;</summary>
		<author><name>Dcerdera</name></author>
	</entry>
	<entry>
		<id>https://wiki.tecnicorioja.com/index.php?title=One-liners&amp;diff=14</id>
		<title>One-liners</title>
		<link rel="alternate" type="text/html" href="https://wiki.tecnicorioja.com/index.php?title=One-liners&amp;diff=14"/>
		<updated>2025-01-29T21:42:51Z</updated>

		<summary type="html">&lt;p&gt;Dcerdera: Página reemplazada por «Categoría: Linux === Apache===     ===Mysql===»&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[[Categoría: Linux]]&lt;br /&gt;
=== Apache===&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
===Mysql===&lt;/div&gt;</summary>
		<author><name>Dcerdera</name></author>
	</entry>
	<entry>
		<id>https://wiki.tecnicorioja.com/index.php?title=One-liners&amp;diff=13</id>
		<title>One-liners</title>
		<link rel="alternate" type="text/html" href="https://wiki.tecnicorioja.com/index.php?title=One-liners&amp;diff=13"/>
		<updated>2025-01-29T21:39:10Z</updated>

		<summary type="html">&lt;p&gt;Dcerdera: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[[Categoría: Linux]]&lt;br /&gt;
=== Apache===&lt;br /&gt;
&lt;br /&gt;
===Postfix ===&lt;br /&gt;
Intentos fallidos de login&lt;br /&gt;
&amp;lt;pre&amp;gt;journalctl --since &amp;quot;4 hour ago&amp;quot; | grep &amp;quot;SASL LOGIN authentication failed:&amp;quot; |  awk &#039;{print $7}&#039;| cut -d [ -f2 | cut -d ] -f1 | sort -n | uniq -c | sort -n | awk &#039;{print $2}&#039;&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
===Mysql===&lt;br /&gt;
En plesk ver procesos corriendo&lt;br /&gt;
&amp;lt;pre&amp;gt; watch -n 0.5 &#039;mysql -uadmin -p`cat /etc/psa/.psa.shadow` -e &amp;quot;show processlist;&amp;quot;&#039;&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
===Autenticaciones ===&lt;br /&gt;
&lt;br /&gt;
Ver intentos de login a tu servidor vía SSH:&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
journalctl --since &amp;quot;24 hour ago&amp;quot; | grep -i &amp;quot;Failed password for invalid user&amp;quot; | awk &#039;{print $13}&#039; | sort -n | uniq  &amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
o &lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt; journalctl --since &amp;quot;24 hour ago&amp;quot; | grep -i &amp;quot;Failed password for root &amp;quot; | awk &#039;{print $11}&#039; | sort -n | uniq &amp;lt;/pre&amp;gt;&lt;/div&gt;</summary>
		<author><name>Dcerdera</name></author>
	</entry>
	<entry>
		<id>https://wiki.tecnicorioja.com/index.php?title=One-liners&amp;diff=12</id>
		<title>One-liners</title>
		<link rel="alternate" type="text/html" href="https://wiki.tecnicorioja.com/index.php?title=One-liners&amp;diff=12"/>
		<updated>2025-01-29T21:21:36Z</updated>

		<summary type="html">&lt;p&gt;Dcerdera: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[[Categoría: Linux]]&lt;br /&gt;
=== Apache===&lt;br /&gt;
&lt;br /&gt;
===Postfix ===&lt;br /&gt;
Intentos fallidos de login&lt;br /&gt;
&amp;lt;pre&amp;gt;journalctl --since &amp;quot;4 hour ago&amp;quot; | grep &amp;quot;SASL LOGIN authentication failed:&amp;quot; |  awk &#039;{print $7}&#039;| cut -d [ -f2 | cut -d ] -f1 | sort -n | uniq -c | sort -n | awk &#039;{print $2}&#039;&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
===Mysql===&lt;br /&gt;
&lt;br /&gt;
===Autenticaciones ===&lt;br /&gt;
&lt;br /&gt;
Ver intentos de login a tu servidor via SSH:&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
journalctl --since &amp;quot;24 hour ago&amp;quot; | grep -i &amp;quot;Failed password for invalid user&amp;quot; | awk &#039;{print $13}&#039; | sort -n | uniq  &amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
o &lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt; journalctl --since &amp;quot;24 hour ago&amp;quot; | grep -i &amp;quot;Failed password for root &amp;quot; | awk &#039;{print $11}&#039; | sort -n | uniq &amp;lt;/pre&amp;gt;&lt;/div&gt;</summary>
		<author><name>Dcerdera</name></author>
	</entry>
	<entry>
		<id>https://wiki.tecnicorioja.com/index.php?title=One-liners&amp;diff=11</id>
		<title>One-liners</title>
		<link rel="alternate" type="text/html" href="https://wiki.tecnicorioja.com/index.php?title=One-liners&amp;diff=11"/>
		<updated>2025-01-29T20:23:07Z</updated>

		<summary type="html">&lt;p&gt;Dcerdera: /* Autenticaciones */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[[Categoría: Linux]]&lt;br /&gt;
=== Apache===&lt;br /&gt;
&lt;br /&gt;
===Postfix ( envios )===&lt;br /&gt;
&lt;br /&gt;
===Mysql===&lt;br /&gt;
&lt;br /&gt;
===Autenticaciones ===&lt;br /&gt;
&lt;br /&gt;
Ver intentos de login a tu servidor via SSH:&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
journalctl --since &amp;quot;24 hour ago&amp;quot; | grep -i &amp;quot;Failed password for invalid user&amp;quot; | awk &#039;{print $13}&#039; | sort -n | uniq  &amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
o &lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt; journalctl --since &amp;quot;24 hour ago&amp;quot; | grep -i &amp;quot;Failed password for root &amp;quot; | awk &#039;{print $11}&#039; | sort -n | uniq &amp;lt;/pre&amp;gt;&lt;/div&gt;</summary>
		<author><name>Dcerdera</name></author>
	</entry>
	<entry>
		<id>https://wiki.tecnicorioja.com/index.php?title=P%C3%A1gina_principal&amp;diff=10</id>
		<title>Página principal</title>
		<link rel="alternate" type="text/html" href="https://wiki.tecnicorioja.com/index.php?title=P%C3%A1gina_principal&amp;diff=10"/>
		<updated>2025-01-29T20:02:46Z</updated>

		<summary type="html">&lt;p&gt;Dcerdera: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;&amp;lt;!--=== [[:Especial:Todas_las_páginas|Ver todas las páginas]]=== --&amp;gt;&lt;br /&gt;
=== Listado de páginas ===&lt;br /&gt;
{{Special:AllPages}}&lt;/div&gt;</summary>
		<author><name>Dcerdera</name></author>
	</entry>
	<entry>
		<id>https://wiki.tecnicorioja.com/index.php?title=Ayuda&amp;diff=9</id>
		<title>Ayuda</title>
		<link rel="alternate" type="text/html" href="https://wiki.tecnicorioja.com/index.php?title=Ayuda&amp;diff=9"/>
		<updated>2025-01-29T19:07:53Z</updated>

		<summary type="html">&lt;p&gt;Dcerdera: Página creada con « &amp;lt;strong&amp;gt;MediaWiki se ha instalado.&amp;lt;/strong&amp;gt;  Consulta la [https://www.mediawiki.org/wiki/Special:MyLanguage/Help:Contents guía] para obtener información sobre el uso del software wiki.  == Primeros pasos == * [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Configuration_settings Lista de ajustes de configuración] * [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:FAQ Preguntas frecuentes sobre MediaWiki] * [https://lists.wikimedia.org/postorius/…»&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;&lt;br /&gt;
&amp;lt;strong&amp;gt;MediaWiki se ha instalado.&amp;lt;/strong&amp;gt;&lt;br /&gt;
&lt;br /&gt;
Consulta la [https://www.mediawiki.org/wiki/Special:MyLanguage/Help:Contents guía] para obtener información sobre el uso del software wiki.&lt;br /&gt;
&lt;br /&gt;
== Primeros pasos ==&lt;br /&gt;
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Configuration_settings Lista de ajustes de configuración]&lt;br /&gt;
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:FAQ Preguntas frecuentes sobre MediaWiki]&lt;br /&gt;
* [https://lists.wikimedia.org/postorius/lists/mediawiki-announce.lists.wikimedia.org/ Lista de correo de anuncios de publicación de MediaWiki]&lt;br /&gt;
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Localisation#Translation_resources Traducir MediaWiki a tu idioma]&lt;br /&gt;
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Combating_spam Aprende a combatir el spam en tu wiki]&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
Aquí va tu código&lt;br /&gt;
y mantendrá su formato original&lt;br /&gt;
con los saltos de línea y la indentación.&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;/div&gt;</summary>
		<author><name>Dcerdera</name></author>
	</entry>
	<entry>
		<id>https://wiki.tecnicorioja.com/index.php?title=P%C3%A1gina_principal&amp;diff=8</id>
		<title>Página principal</title>
		<link rel="alternate" type="text/html" href="https://wiki.tecnicorioja.com/index.php?title=P%C3%A1gina_principal&amp;diff=8"/>
		<updated>2025-01-29T19:07:33Z</updated>

		<summary type="html">&lt;p&gt;Dcerdera: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;=== [[:Especial:Todas_las_páginas|Ver todas las páginas]]===&lt;br /&gt;
&lt;br /&gt;
=== Listado de páginas ===&lt;br /&gt;
&lt;br /&gt;
[[One-liners]]&lt;/div&gt;</summary>
		<author><name>Dcerdera</name></author>
	</entry>
	<entry>
		<id>https://wiki.tecnicorioja.com/index.php?title=P%C3%A1gina_principal&amp;diff=7</id>
		<title>Página principal</title>
		<link rel="alternate" type="text/html" href="https://wiki.tecnicorioja.com/index.php?title=P%C3%A1gina_principal&amp;diff=7"/>
		<updated>2025-01-29T19:07:11Z</updated>

		<summary type="html">&lt;p&gt;Dcerdera: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;=== [[:Especial:Todas_las_páginas|Ver todas las páginas]]===&lt;br /&gt;
&lt;br /&gt;
=== Listado de páginas ===&lt;br /&gt;
&lt;br /&gt;
[[One-liners]]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&amp;lt;strong&amp;gt;MediaWiki se ha instalado.&amp;lt;/strong&amp;gt;&lt;br /&gt;
&lt;br /&gt;
Consulta la [https://www.mediawiki.org/wiki/Special:MyLanguage/Help:Contents guía] para obtener información sobre el uso del software wiki.&lt;br /&gt;
&lt;br /&gt;
== Primeros pasos ==&lt;br /&gt;
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Configuration_settings Lista de ajustes de configuración]&lt;br /&gt;
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:FAQ Preguntas frecuentes sobre MediaWiki]&lt;br /&gt;
* [https://lists.wikimedia.org/postorius/lists/mediawiki-announce.lists.wikimedia.org/ Lista de correo de anuncios de publicación de MediaWiki]&lt;br /&gt;
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Localisation#Translation_resources Traducir MediaWiki a tu idioma]&lt;br /&gt;
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Combating_spam Aprende a combatir el spam en tu wiki]&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
Aquí va tu código&lt;br /&gt;
y mantendrá su formato original&lt;br /&gt;
con los saltos de línea y la indentación.&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;/div&gt;</summary>
		<author><name>Dcerdera</name></author>
	</entry>
	<entry>
		<id>https://wiki.tecnicorioja.com/index.php?title=P%C3%A1gina_principal&amp;diff=6</id>
		<title>Página principal</title>
		<link rel="alternate" type="text/html" href="https://wiki.tecnicorioja.com/index.php?title=P%C3%A1gina_principal&amp;diff=6"/>
		<updated>2025-01-29T18:56:42Z</updated>

		<summary type="html">&lt;p&gt;Dcerdera: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;&amp;lt;strong&amp;gt;MediaWiki se ha instalado.&amp;lt;/strong&amp;gt;&lt;br /&gt;
&lt;br /&gt;
Consulta la [https://www.mediawiki.org/wiki/Special:MyLanguage/Help:Contents guía] para obtener información sobre el uso del software wiki.&lt;br /&gt;
&lt;br /&gt;
== Primeros pasos ==&lt;br /&gt;
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Configuration_settings Lista de ajustes de configuración]&lt;br /&gt;
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:FAQ Preguntas frecuentes sobre MediaWiki]&lt;br /&gt;
* [https://lists.wikimedia.org/postorius/lists/mediawiki-announce.lists.wikimedia.org/ Lista de correo de anuncios de publicación de MediaWiki]&lt;br /&gt;
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Localisation#Translation_resources Traducir MediaWiki a tu idioma]&lt;br /&gt;
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Combating_spam Aprende a combatir el spam en tu wiki]&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
Aquí va tu código&lt;br /&gt;
y mantendrá su formato original&lt;br /&gt;
con los saltos de línea y la indentación.&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
[[Categoría: Linux]]&lt;/div&gt;</summary>
		<author><name>Dcerdera</name></author>
	</entry>
	<entry>
		<id>https://wiki.tecnicorioja.com/index.php?title=One-liners&amp;diff=5</id>
		<title>One-liners</title>
		<link rel="alternate" type="text/html" href="https://wiki.tecnicorioja.com/index.php?title=One-liners&amp;diff=5"/>
		<updated>2025-01-29T18:54:54Z</updated>

		<summary type="html">&lt;p&gt;Dcerdera: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[[Categoría: Linux]]&lt;br /&gt;
=== Apache===&lt;br /&gt;
&lt;br /&gt;
===Postfix ( envios )===&lt;br /&gt;
&lt;br /&gt;
===Mysql===&lt;br /&gt;
&lt;br /&gt;
===Autenticaciones ===&lt;/div&gt;</summary>
		<author><name>Dcerdera</name></author>
	</entry>
	<entry>
		<id>https://wiki.tecnicorioja.com/index.php?title=One-liners&amp;diff=4</id>
		<title>One-liners</title>
		<link rel="alternate" type="text/html" href="https://wiki.tecnicorioja.com/index.php?title=One-liners&amp;diff=4"/>
		<updated>2025-01-29T18:50:31Z</updated>

		<summary type="html">&lt;p&gt;Dcerdera: Página creada con «=== Apache===  ===Postfix ( envios )===  ===Mysql===  ===Autenticaciones ===»&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;=== Apache===&lt;br /&gt;
&lt;br /&gt;
===Postfix ( envios )===&lt;br /&gt;
&lt;br /&gt;
===Mysql===&lt;br /&gt;
&lt;br /&gt;
===Autenticaciones ===&lt;/div&gt;</summary>
		<author><name>Dcerdera</name></author>
	</entry>
	<entry>
		<id>https://wiki.tecnicorioja.com/index.php?title=P%C3%A1gina_principal&amp;diff=3</id>
		<title>Página principal</title>
		<link rel="alternate" type="text/html" href="https://wiki.tecnicorioja.com/index.php?title=P%C3%A1gina_principal&amp;diff=3"/>
		<updated>2025-01-29T18:45:21Z</updated>

		<summary type="html">&lt;p&gt;Dcerdera: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;&amp;lt;strong&amp;gt;MediaWiki se ha instalado.&amp;lt;/strong&amp;gt;&lt;br /&gt;
&lt;br /&gt;
Consulta la [https://www.mediawiki.org/wiki/Special:MyLanguage/Help:Contents guía] para obtener información sobre el uso del software wiki.&lt;br /&gt;
&lt;br /&gt;
== Primeros pasos ==&lt;br /&gt;
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Configuration_settings Lista de ajustes de configuración]&lt;br /&gt;
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:FAQ Preguntas frecuentes sobre MediaWiki]&lt;br /&gt;
* [https://lists.wikimedia.org/postorius/lists/mediawiki-announce.lists.wikimedia.org/ Lista de correo de anuncios de publicación de MediaWiki]&lt;br /&gt;
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Localisation#Translation_resources Traducir MediaWiki a tu idioma]&lt;br /&gt;
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Combating_spam Aprende a combatir el spam en tu wiki]&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
Aquí va tu código&lt;br /&gt;
y mantendrá su formato original&lt;br /&gt;
con los saltos de línea y la indentación.&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;/div&gt;</summary>
		<author><name>Dcerdera</name></author>
	</entry>
	<entry>
		<id>https://wiki.tecnicorioja.com/index.php?title=P%C3%A1gina_principal&amp;diff=2</id>
		<title>Página principal</title>
		<link rel="alternate" type="text/html" href="https://wiki.tecnicorioja.com/index.php?title=P%C3%A1gina_principal&amp;diff=2"/>
		<updated>2025-01-29T18:43:37Z</updated>

		<summary type="html">&lt;p&gt;Dcerdera: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;&amp;lt;strong&amp;gt;MediaWiki se ha instalado.&amp;lt;/strong&amp;gt;&lt;br /&gt;
&lt;br /&gt;
Consulta la [https://www.mediawiki.org/wiki/Special:MyLanguage/Help:Contents guía] para obtener información sobre el uso del software wiki.&lt;br /&gt;
&lt;br /&gt;
== Primeros pasos ==&lt;br /&gt;
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Configuration_settings Lista de ajustes de configuración]&lt;br /&gt;
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:FAQ Preguntas frecuentes sobre MediaWiki]&lt;br /&gt;
* [https://lists.wikimedia.org/postorius/lists/mediawiki-announce.lists.wikimedia.org/ Lista de correo de anuncios de publicación de MediaWiki]&lt;br /&gt;
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Localisation#Translation_resources Traducir MediaWiki a tu idioma]&lt;br /&gt;
* [https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Combating_spam Aprende a combatir el spam en tu wiki]&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
Aquí va tu código&lt;br /&gt;
y mantendrá su formato original&lt;br /&gt;
con los saltos de línea y la indentación.&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&amp;lt;syntaxhighlight lang=&amp;quot;python&amp;quot; line&amp;gt;&lt;br /&gt;
def quick_sort(arr):&lt;br /&gt;
	less = []&lt;br /&gt;
	pivot_list = []&lt;br /&gt;
	more = []&lt;br /&gt;
	if len(arr) &amp;lt;= 1:&lt;br /&gt;
		return arr&lt;br /&gt;
	else:&lt;br /&gt;
		pass&lt;br /&gt;
&amp;lt;/syntaxhighlight&amp;gt;&lt;/div&gt;</summary>
		<author><name>Dcerdera</name></author>
	</entry>
</feed>