i-amolo

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"}}';
}

i-amolo

Nginx Basic Auth

A simple demo of using Nginx as a reverse proxy to add basic authentication.

i-amolo

Title

<Additional information about your API call. Try to use verbs that match both request type (fetching vs modifying) and plurality (one vs multiple).>

• URL

  <The URL Structure (path only, no root url)>

• Method:

i-amolo

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

i-amolo

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

i-amolo

Change TimeZone in Docker containers

With Docker Engine

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

i-amolo

-- 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

i-amolo

version: '3'
services:
  mssql:
    image: mcr.microsoft.com/mssql/server:2017-CU8-ubuntu
    environment:
      - ACCEPT_EULA=Y
      - SA_PASSWORD=Melon40twomonkeys
    ports:
      - '1433:1433'

i-amolo

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

i-amolo

input {
  kafka{
    codec => json
    bootstrap_servers => "localhost:9092"
    topics => ["elastic-test"]
  }
}

filter {
    mutate {