tag:blogger.com,1999:blog-76411202783036608522024-03-12T21:32:51.862-07:00Source LinuxUma pequena abordagem Open SourceGabriel Ramos de Oliveirahttp://www.blogger.com/profile/03896389449026649309noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-7641120278303660852.post-68370705344879634002012-03-01T17:19:00.003-08:002012-03-02T08:47:39.781-08:00Contingencia automatica#!/bin/bash<br />
gw_embratel="189.2.105.49"<br />
gw_adsl="10.1.1.1"<br />
ip_google="8.8.8.8"<br />
iproute2=/sbin/ip<br />
gw_on="$("${iproute2}" route list | grep default | head -n 1 | cut -f3 -d" ")"<br />
<br />
if [ ! $gw_on = $gw_embratel ]; then<br />
/sbin/route del default<br />
/sbin/route add default gw $gw_embratel<br />
/usr/bin/logger -p user.warn -t LINK_INTERNET -s "Gateway alterado para $gw_embratel" -f /var/log/messages<br />
<br />
/bin/ping -c 1 -w 3 $ip_google<br />
if [ $? -ne 0 ]; then<br />
/sbin/route del default<br />
/sbin/route add default gw $gw_adsl<br />
/sbin/service openvpn restart<br />
/usr/bin/logger -p user.warn -t LINK_INTERNET -s "Gateway alterado para $gw_adsl" -f /var/log/messages<br />
fi<br />
fi<br />
<br />
/bin/ping -c 3 -w 5 $ip_google<br />
if [ ! $? -eq 0 ]; then<br />
/sbin/route del default gw $gw_on<br />
<br />
if [ "$gw_on" = "$gw_embratel" ]; then<br />
/sbin/route add default gw $gw_adsl<br />
/usr/bin/logger -p user.warn -t LINK_INTERNET -s "Gateway alterado para $gw_adsl" -f /var/log/messages<br />
<br />
/usr/bin/mutt -s "Falha no link Embratel SP" plantaocisuporte@positivo.com.br -c groliveira@positivo.com.br <<EOF<br />
---<br />
Falha na comunicacao com a operadora Embratel na filial SP.<br />
A contingencia foi acionada automaticamente.<br />
Favor abrir chamado junto a operadora para verificacao!<br />
---<br />
EOF<br />
<br />
else<br />
/sbin/route add default gw $gw_embratel<br />
fi<br />
fi<br />
/sbin/ip route flush cache<br />
exit<br />
<div><br />
</div>Gabriel Ramos de Oliveirahttp://www.blogger.com/profile/03896389449026649309noreply@blogger.com0tag:blogger.com,1999:blog-7641120278303660852.post-10590796693777183242012-02-17T07:50:00.002-08:002012-02-17T07:50:09.076-08:00Plugin nagios para raid por software<a href="http://koji.hep.caltech.edu/koji/buildinfo?buildID=66">http://koji.hep.caltech.edu/koji/buildinfo?buildID=66</a>Gabriel Ramos de Oliveirahttp://www.blogger.com/profile/03896389449026649309noreply@blogger.com0tag:blogger.com,1999:blog-7641120278303660852.post-19022841283229395992012-01-12T10:39:00.000-08:002012-01-12T10:39:02.088-08:00Bloqueando msn sem bloquear o hotmailacl msn url_regex "/etc/squid/msn"<br />
http_access deny msn<br />
<br />
conteúdo de /etc/squid/msn<br />
<br />
<br />
/gateway/gateway.dll<br />
.passport.com<br />
messenger.msn.com<br />
c.msn.com<br />
.passport.com<br />
https://loginnet.passport.com/<br />
.gateway.messenger.live.com:443<br />
.messenger.services.live.com:443<br />
<div><br />
</div>Gabriel Ramos de Oliveirahttp://www.blogger.com/profile/03896389449026649309noreply@blogger.com0tag:blogger.com,1999:blog-7641120278303660852.post-22779392464942580542011-12-16T03:52:00.000-08:002011-12-16T03:53:00.205-08:00mysar com mais de 1.000,000 registrosQuando os registros gerados pelo mysar na base mysql ultrapassam 1.000,000 registros e expira as queries alguns comandos úteis para gerar indices para as tabelas:<br />
<br />
<br />
Database changed<br />
mysql> EXPLAIN EXTENDED SELECT COUNT(DISTINCTROW ip) AS users FROM traffic WHERE date='2011-12-15' AND time>'09:17:08';<br />
+----+-------------+---------+-------+--------------------------------------+--------------+---------+------+---------+----------+--------------------------+<br />
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |<br />
+----+-------------+---------+-------+--------------------------------------+--------------+---------+------+---------+----------+--------------------------+<br />
| 1 | SIMPLE | traffic | range | date_ip_sitesID_usersID,traffic_idx1 | traffic_idx1 | 6 | NULL | 1881673 | 100.00 | Using where; Using index |<br />
+----+-------------+---------+-------+--------------------------------------+--------------+---------+------+---------+----------+--------------------------+<br />
1 row in set, 1 warning (0.01 sec)<br />
<br />
mysql> CREATE INDEX traffic_idx1 ON traffic (date, time, ip);Gabriel Ramos de Oliveirahttp://www.blogger.com/profile/03896389449026649309noreply@blogger.com0tag:blogger.com,1999:blog-7641120278303660852.post-11151208105460802622011-11-04T17:42:00.001-07:002011-11-04T17:42:30.877-07:00Xen 4.0http://wiki.xen.org/xenwiki/Xen4.0Gabriel Ramos de Oliveirahttp://www.blogger.com/profile/03896389449026649309noreply@blogger.com0tag:blogger.com,1999:blog-7641120278303660852.post-86377978181888690462011-10-27T07:40:00.000-07:002011-10-27T07:40:23.639-07:00Gerando Certificados para o apache<b>Passos para gerar os certificados assinados pela autoridade local</b><br />
<br />
1 - openssl genrsa -des3 -out localhost.key 1024<br />
2 - openssl req -new -key localhost.key -out localhost.csr<br />
3 - openssl x509 -req -days 365 -in localhost.csr -signkey localhost.key -out localhost.crtGabriel Ramos de Oliveirahttp://www.blogger.com/profile/03896389449026649309noreply@blogger.com0tag:blogger.com,1999:blog-7641120278303660852.post-65787694809166856322011-08-25T08:33:00.001-07:002011-08-25T08:33:50.923-07:00Tópicos para lpic-2 atualizado<a href="http://snow.nl/dist/xhtmlc/index.html">http://snow.nl/dist/xhtmlc/index.html</a>Gabriel Ramos de Oliveirahttp://www.blogger.com/profile/03896389449026649309noreply@blogger.com0tag:blogger.com,1999:blog-7641120278303660852.post-80634042975731336592011-07-25T15:15:00.001-07:002011-07-25T15:15:59.458-07:00Repositorio RPMFORGE para Centos-6rpm -Uvh http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el6.rf.i686.rpmGabriel Ramos de Oliveirahttp://www.blogger.com/profile/03896389449026649309noreply@blogger.com0tag:blogger.com,1999:blog-7641120278303660852.post-6947577629076777902011-07-25T15:13:00.001-07:002011-07-25T15:13:11.347-07:00Repositorio EPEL para Centos-6<pre>rpm -Uvh http://download.fedora.redhat.com/pub/epel/6/i386/epel-release-6-5.noarch.rpm</pre>Gabriel Ramos de Oliveirahttp://www.blogger.com/profile/03896389449026649309noreply@blogger.com0