Rafael Claumann Bernardes RafaelClaumann

Java developer with DevOps interest

RafaelClaumann / file.sql

Created April 3, 2025 02:51

codigo-sql

	CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
	USE `mydb` ;

	CREATE TABLE IF NOT EXISTS `fabricante` (
	`id_fabricante` INT NOT NULL AUTO_INCREMENT,
	`nome` VARCHAR(60) NULL,
	PRIMARY KEY (`id_fabricante`));

	CREATE TABLE IF NOT EXISTS `modelo` (
	`id_modelo` INT NOT NULL AUTO_INCREMENT,

RafaelClaumann / certs.sh

Last active September 1, 2023 10:37

Create self-signed certificate (rootCA.crt, rootCA.key, server.key, server.csr, server.crt)

	# https://www.shellhacks.com/create-csr-openssl-without-prompt-non-interactive/

	# create a CA to sign server certificate(server.crt), server certificate will be created in next steps.
	# generated_files: ca.crt ca.key
	openssl req -x509 -sha256 \
	-nodes \
	-newkey rsa:2048 \
	-keyout ca.key \
	-out ca.crt \
	-subj "/C=BR/ST=Santa Catarina/L=Florianopolis/O=Certificate Authority/OU=Root" \

RafaelClaumann / tibia_macro.py

Last active April 26, 2023 13:01

Script para simular ações no teclado usando Python3 e Pynput

	#### Dependency:
	#### pip install pynput
	####

	import time
	import _thread
	import datetime
	from pynput.keyboard import Key, Controller

	keyboard = Controller()

RafaelClaumann / login.php

Created April 3, 2023 03:17

simple login.php for otserv 12x

	// https://github.com/otsoft/myaac
	// https://github.com/opentibiabr/canary
	// https://github.com/dudantas/tibia-client/releases/tag/12.91.12329
	<?php

	$databaseURL = "172.18.0.1";
	$databaseUser = "forgottenserver";
	$databaseUserPassword = "noob";
	$databaseName = "forgottenserver";
	$mysqli = mysqli_connect($databaseURL,$databaseUser, $databaseUserPassword, $databaseName);

RafaelClaumann / kind-cluster.sh

Last active April 25, 2023 22:21

Kind Cluster with Cilium CNI, Nginx Ingress Controller, Kube Prometheus Stack and Metrics Server

	#! /bin/bash

	# https://github.com/RafaelClaumann/some-kubernetes-study/blob/main/kind_cluster/cluster.sh
	# options:
	# no-options -> install clean cluster
	# -c / --cni -> install cilium cni
	# -m / --metrics -> install metrics server
	# -i / --ingress -> install nginx ingress controller
	# -p / --prometheus -> install kube prometheus stack
	# -pi / --prometheus-ingress -> install ingress-nginx, kube prometheus stack and service monitor on nginx