A simple demo of using Nginx as a reverse proxy to add basic authentication.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
error_page 500 /500.html; | |
location /500.html{ | |
return 500 '{"error": {"status_code": 500,"status": "Internal Server Error"}}'; | |
} | |
error_page 502 /502.html; | |
location /502.html{ | |
return 502 '{"error": {"status_code": 502,"status": "Bad Gateway"}}'; | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
https://stackoverflow.com/questions/33510184/change-mysql-root-password-on-centos7/34207996#34207996 | |
1. Stop mysql: | |
systemctl stop mysqld | |
2. Set the mySQL environment option | |
systemctl set-environment MYSQLD_OPTS="--skip-grant-tables" | |
3. Start mysql usig the options you just set | |
systemctl start mysqld |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
KEYCLOAK_VERSION=16.1.1 | |
PORT_KEYCLOAK=8080 | |
POSTGRESQL_USER=keycloak | |
POSTGRESQL_PASS=keycloak | |
POSTGRESQL_DB=keycloak | |
VIRTUAL_HOST=example.com | |
LETSENCRYPT_HOST=example.com | |
LETSENCRYPT_EMAIL=example@gmail.com |
The timezone of a container can be set using an environment variable in the docker container when it is created. For example:
$ docker run ubuntu:latest date
Sat Feb 27 15:58:32 UTC 2021
$ docker run -e TZ=America/Bogota ubuntu:latest date
Sat Feb 27 15:58:40 Asia 2021
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- If you want to generate a new Guid (uniqueidentifier) in SQL server the you can simply use the NEWID() function. | |
SELECT NEWID() | |
GO | |
-- This will return a new random uniqueidentifier e.g. | |
E75B92A3-3299-4407-A913-C5CA196B3CAB | |
To select this Guid in in a variable | |
--assign uniqueidentifier in a variable | |
DECLARE @EmployeeID uniqueidentifier |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
version: '3' | |
services: | |
mssql: | |
image: mcr.microsoft.com/mssql/server:2017-CU8-ubuntu | |
environment: | |
- ACCEPT_EULA=Y | |
- SA_PASSWORD=Melon40twomonkeys | |
ports: | |
- '1433:1433' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import cx_Oracle | |
def perform_query(query, bind_variables): | |
connection = db_pool.acquire() | |
cursor = connection.cursor() | |
cursor.execute(query, bind_variables) | |
result = cursor.fetchall() | |
cursor.close() | |
db_pool.release(connection) | |
return result |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
input { | |
kafka{ | |
codec => json | |
bootstrap_servers => "localhost:9092" | |
topics => ["elastic-test"] | |
} | |
} | |
filter { | |
mutate { |
NewerOlder