Skip to content

Instantly share code, notes, and snippets.

View MisterDaniels's full-sized avatar

Daniel Silva MisterDaniels

65 followers · 76 following
View GitHub Profile
@MisterDaniels
MisterDaniels / reload-table-dms.sh
Last active February 15, 2022 17:46
#!/usr/bin/env bash
set -e
declare -a tables=("project" "photo_project");
for table in "${tables[@]}"
do
aws dms reload-tables \
--replication-task-arn "arn:aws:dms:sa-east-1:563887512369:task:XGPXOQJKUOT2I5P4HXSB3LQFAVH6XG6WAFDHENY" \
--tables-to-reload "SchemaName=photobook,TableName=$table" \
@MisterDaniels
MisterDaniels / QueriesKilled.log
Last active May 3, 2022 14:13
Kill expensive and duplicated queries of a MySQL process
Executed in 2022-05-03 10:33:21.410481
Connected to MySQL Server version 5.5.5-10.1.30-MariaDB-1~jessie
Catching query: select benchmark(10000000000, md5('when will it end 3?'))
Pokecess: [254, 251, 248, 244, 242, 240, 237, 234, 230]
- Catched pokecess 254
- Catched pokecess 251
- Catched pokecess 248
- Catched pokecess 244
- Catched pokecess 242
- Catched pokecess 240
@MisterDaniels
MisterDaniels / .env
Last active September 15, 2022 20:19
Wordpress Environment
SERVER_HTTP_PORT=80
SERVER_HTTPS_PORT=443
MYSQL_ROOT_PASSWORD=test
AWS_ACCESS_KEY=test
AWS_SECRET_ACCESS_KEY=test
@MisterDaniels
MisterDaniels / task.md
Last active May 19, 2022 13:37
  • Entrar na maquina dos Wordpress dos clientes (44.201.155.192);
  • Entre com sudo su;
  • Entre na pasta do teu usario cd /home/TEU_USUARIO Ex: cd /home/silva
  • Extrair .sql do Wordpress do cliente mysqldump -pqu46pbwTz8tBcWzN -uroot BANCO_DO_CLIENTE > DOMINIO_DO_CLIENTE.sql; Ex: mysqldump -pqu46pbwTz8tBcWzN -uroot blog-albumgraf-novo > albumgraf.com.br.sql
  • Gerar .zip do Wordpress do cliente zip -r DOMINIO_DO_CLIENTE.zip /var/www/WORDPRESS_DO_CLIENTE; Ex: zip -r albumgraf.com.br.zip /var/www/blog-albumgraf-novo
  • Gerar .zip do certificado do Wordpress do cliente zip -r DOMINIO_DO_CLIENTE-certificados.zip /etc/letsencrypt/live/DOMINIO_DO_CLIENTE; Ex: zip -r albumgraf.com.br-certificados.zip /etc/letsencrypt/live/albumgraf.com.br
@MisterDaniels
MisterDaniels / Dockerfile
Last active September 18, 2022 00:12
Wordpress security malwares
FROM python:3
WORKDIR /usr/src/app
ENV CHECKSUM_RSA_KEY_FILE /usr/src/app/rsa_key
COPY requirements.txt ./
RUN pip install --no-cache-dir -r requirements.txt
RUN apt update
@MisterDaniels
MisterDaniels / HOW_TO_USE.md
Last active April 24, 2024 16:52
Verify what image is not in dropbox folder 
python verifier.py TOKEN FILE.CSV

Ex:

python verifier.py sl.alldutoken project_images_path.csv
@MisterDaniels
MisterDaniels / concatenated_queries_validator.php
Created June 21, 2024 13:57
<?php
$CONCATENATED_QUERIES_REGEX = '/(SELECT|UPDATE|INSERT\s+INTO|DELETE\s+FROM)\s+[^;|\)]*[\'"]\s*\.\s*\$[a-zA-Z_]\w*/';
function scanDirectory($dir) {
$files = [];
$iterator = new RecursiveIteratorIterator(new RecursiveDirectoryIterator($dir));
foreach($iterator as $file) {
if ($file->isFile() && $file->getExtension() === 'php') {
@MisterDaniels
MisterDaniels / api.py
Last active August 15, 2024 20:11
Jenkins blueocean api average test package time
import requests
jenkins_url = ""
pipeline_name = ""
username = ""
token = ""
base_url = f"{ jenkins_url }/blue/rest/organizations/jenkins/pipelines/{ pipeline_name }/branches/"
auth = (username, token)