http://marcelmsoares.blogspot.com/2013/11/excel-nao-atualiza-as-formulas.html
arduino temperatura
buzzer
https://www.satellasoft.com/?materia=beep-usando-buzzer-com-arduino
NTC 10k temperatura
http://labdegaragem.com/profiles/blogs/tutorial-como-utilizar-o-termistor-ntc-com-arduino
http://www.audioacustica.com.br/exemplos/Valores_Resistores/Calculadora_Ohms_Resistor.html
led
http://www.audioacustica.com.br/exemplos/Valores_Resistores/Calculadora_Ohms_Resistor.html
Prevent apache from serving git directory
https://serverfault.com/questions/128069/how-do-i-prevent-apache-from-serving-the-git-directory
RT-N13U
https://oldwiki.archive.openwrt.org/toh/asus/rt-n13u
https://oldwiki.archive.openwrt.org/doc/howto/firstlogin
opkg update
opkg install base-files block-mount busybox dnsmasq dropbear firewall fstools hostapd-common ip6tables iptables iw jshn jsonfilter kernel kmod-cfg80211 kmod-crypto-aes kmod-crypto-arc4 kmod-crypto-core kmod-eeprom-93cx6 kmod-fs-vfat kmod-gpio-button-hotplug kmod-ip6tables kmod-ipt-conntrack kmod-ipt-core kmod-ipt-nat kmod-ipv6 kmod-leds-gpio kmod-ledtrig-usbdev kmod-lib-crc-ccitt kmod-lib-crc-itu-t kmod-mac80211 kmod-nf-conntrack kmod-nf-conntrack6 kmod-nf-ipt kmod-nf-ipt6 kmod-nf-nat kmod-nf-nathelper kmod-nls-base kmod-nls-cp437 kmod-nls-iso8859-1 kmod-ppp kmod-pppoe kmod-pppox kmod-rt2800-lib kmod-rt2800-mmio kmod-rt2800-soc kmod-rt2x00-lib kmod-rt2x00-mmio kmod-scsi-core kmod-slhc kmod-tun kmod-usb-core kmod-usb-dwc2 kmod-usb-printer kmod-usb-storage libblkid libblobmsg-json libc libgcc libip4tc libip6tc libiwinfo libiwinfo-lua libjson-c libjson-script liblua liblzo libmount libnl-tiny libopenssl libpcap libpthread librt libubox libubus libubus-lua libuci libuci-lua libusb-1.0 libuuid libxtables lua luci luci-app-firewall luci-app-openvpn luci-app-p910nd luci-app-samba luci-base luci-i18n-base-pt-br luci-i18n-openvpn-en luci-i18n-openvpn-pt-br luci-lib-ip luci-lib-nixio luci-mod-admin-full luci-proto-ipv6 luci-proto-ppp luci-theme-bootstrap mtd netifd odhcp6c odhcpd openvpn-openssl opkg p910nd ppp ppp-mod-pppoe procd rpcd samba36-server swconfig tcpdump ubox ubus ubusd uci uhttpd uhttpd-mod-ubus usign wpad-mini zlib
Remover senha arquivo p12
https://serverfault.com/questions/515833/how-to-remove-private-key-password-from-pkcs12-container
Export to temporary pem file
openssl pkcs12 -in protected.p12 -nodes -out temp.pem
# -> Enter password
Convert pem back to p12
openssl pkcs12 -export -in temp.pem -out unprotected.p12
# -> Just press [return] twice for no password
Remove temporary certificate
rm temp.pem
delete mail from queue
To delete all email in the queue from a domain run this command as root:
postqueue -p | tail -n +2 | awk ‘BEGIN { RS = “” } /@example\.com/ { print $1 }’ | tr -d ‘*!’ | postsuper -d –
To delete all email in the queue From: a specific email address run this command as root:
postqueue -p | tail -n +2 | awk ‘BEGIN { RS = “” } /username@example\.com/ { print $1 }’ | tr -d ‘*!’ | postsuper -d –
How to reset AUTO_INCREMENT in MySQL
http://stackoverflow.com/questions/8923114/how-to-reset-auto-increment-in-mysql
How to Change Order of NICs in XenServer 6.x
http://support.citrix.com/article/CTX135809
ferramenta para gerar e testar certificados ssl
Ferramenta para gerar e testar certificados SSL
A ferramenta mais conhecida para geração de certificados no Linux é parte do toolkit OpenSSL. Este toolkit é utilizada por quase todas as aplicações que implementam SSL/TLS, como os servidores HTTP Apache e Nginx.
Normalmente a obtenção de um certificado digital, necessário para a encriptação assimétrica realizada para comunicação entre o servidor HTTP e o cliente, pode ocorrer de duas formas: Pela criação de um certificado auto-assinado, onde nenhuma entidade certificadora garante a autenticidade; Ou pela criação de um CSR, que será usado por uma entidade certificadora para gerar o certificado digital assinado, no qual terá sua autenticidade garantida pela certificadora.
Comando para criar o arquivo CSR (Certificate Signing Request)
openssl req -new -newkey rsa:2048 -sha256 -nodes -keyout chave.key -out requisicao.csr
Comando para conferir os dados digitados no CSR
openssl req -in requisicao.csr -noout -text
Comando para gerar um CSR a partir de uma chave privada já existente
openssl req -key chavePrivada.key -new -out requisicao.csr
Comando para criar um certificado auto-assinado (self-signed)
openssl req -x509 -nodes -days 365 -newkey rsa:2048 -keyout chavePrivada.key -out certificado.crt
Comando para conferir os dados de um certificado
openssl x509 -in certificado.crt -text -noout
Comando para remover a senha de uma chave privada
openssl rsa -in chave.key -out chavePrivadaSemSenha.key
Comando para conferir o MD5 das chaves, CRT e CSR
openssl x509 -noout -modulus -in certificado.crt | openssl md5
openssl rsa -noout -modulus -in chave.key | openssl md5
openssl req -noout -modulus -in requisicao.csr | openssl md5
https://phcco.com/ferramenta-para-gerar-e-testar-certificados-ssl
ispconfig DDNS-update
https://github.com/DIXINFOR/ddns-update-for-ispconfig
Crontab on local machine
*/30 * * * * wget –no-check-certificate ‘https://server.example.com:8080/ddns-update.php?username=user&password=password&hostname=intranet.example.com‘
mkdir -p ~/app/ispconfig cd app/ispconfig/ git clone https://github.com/DIXINFOR/ddns-update-for-ispconfig.git cd /usr/local/ispconfig/interface/web cp ~/app/ispconfig/ddns-update-for-ispconfig/index.php ddns-update.php cp ~/app/ispconfig/ddns-update-for-ispconfig/log.inc.php ddns-log.inc.php
--- /root/app/ddns-update-for-ispconfig/log.inc.php 2016-04-01 14:05:06.485384000 -0300 +++ /usr/local/ispconfig/interface/web/ddns-log.inc.php 2016-04-01 15:25:16.801384000 -0300 @@ -4,7 +4,7 @@ private $file; function __construct($name) { - $this->file = "log_".str_replace('.', '_', $name).".txt" ; + $this->file = "/var/log/ddns-log_".str_replace('.', '_', $name).".txt" ; } function debug($log) { @@ -22,4 +22,4 @@ } } -?> \ No newline at end of file +?>
--- /root/app/ddns-update-for-ispconfig/index.php 2016-04-01 14:05:06.485384000 -0300 +++ /usr/local/ispconfig/interface/web/ddns-update.php 2016-04-01 14:32:43.449384000 -0300 @@ -1,9 +1,9 @@ <?php -require_once('log.inc.php'); +require_once('ddns-log.inc.php'); // ISPConfig URL for REMOTE API -$soap_location = 'https://10.0.0.251:8080/remote/index.php'; -$soap_uri = 'https://10.0.0.251:8080/remote/'; +$soap_location = 'https://localhost:8080/remote/index.php'; +$soap_uri = 'https://localhost:8080/remote/'; // Exception List $exception = array('example.com','example2.com.'); @@ -136,7 +136,7 @@ $log->debug("End content"); // check if record is A IPv4 (not cname, mx, txt, ...) $log->debug("Check record type"); - if ($dns_record[0]['type']!='a'){ + if ($dns_record[0]['type']!='A'){ $log->debug("Record type is not A. You can only update a A record"); echo "dnserr"; exit; @@ -182,4 +182,4 @@ } -?> \ No newline at end of file +?>