Aleksandar Babic aleksandar-babic

Cloud-Native Solutions Architect

aleksandar-babic / create.sql

Created January 29, 2018 12:23

Vivify Ideas - Vezba 4

	-- Create table users with all needed fields
	CREATE TABLE IF NOT EXISTS users (
	id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
	email VARCHAR(50) UNIQUE,
	password VARCHAR(50),
	firstname VARCHAR(30),
	lastname VARCHAR(30),
	company VARCHAR(30),
	country VARCHAR(30)
	);

aleksandar-babic / gitPush.sh

Created January 7, 2018 10:13

aleksandar-babic / 301Generator.py

Last active December 8, 2017 16:50

301 Generator from CSV file

	import csv
	import sys

	def parseLinks(fileName):
	redirectsList = []
	with open(fileName, 'rb') as f:
	reader = csv.reader(f)
	next(reader, None) # Skip CSV file headers
	for row in reader:
	destination = row[3].split(' ')[0]

aleksandar-babic / error502.html

Created August 25, 2017 16:10

Custom 502 error

	<!doctype html>
	<html>
	<head>
	<title>Error\|DeployHandler</title>

	<meta charset="utf-8" />
	<meta http-equiv="Content-type" content="text/html; charset=utf-8" />
	<meta name="viewport" content="width=device-width, initial-scale=1" />

	<link href="https://fonts.googleapis.com/css?family=Montserrat" rel="stylesheet">

aleksandar-babic / forceHttps.ps1

Created August 21, 2017 23:28

Azure App Gateway Force HTTPS

	# Get the application gateway
	$gw = Get-AzureRmApplicationGateway -Name DHProductionGatewayFE -ResourceGroupName DeployHandler

	# Get the existing HTTPS listener
	$httpslistener = Get-AzureRmApplicationGatewayHttpListener -Name appgatewayhttplistener -ApplicationGateway $gw

	# Get the existing front end IP configuration
	$fipconfig = Get-AzureRmApplicationGatewayFrontendIPConfig -Name appgatewayfrontendip -ApplicationGateway $gw

	# Add a new front end port to support HTTP traffic

aleksandar-babic / cannotGatherStats.php

Created August 18, 2017 15:06

mage2 cannot gather stats product

	<?php
	if($argc == 2){
	$db['db_host'] = '127.0.0.1';
	$db['db_username'] = 'username';
	$db['db_password'] = 'password';
	$db['db_databaseName'] = 'db';
	$db['db_port'] = '3306'; // This is default MySql port, you can change it if needed
	foreach ($db as $key => $value) {
	define(strtoupper($key), $value);
	}

aleksandar-babic / backup.sh

Created August 15, 2017 18:11

Quick backup script

	#!/bin/bash


	#VARS
	now=$(date)
	nowDate="$(date +'%d-%m-%Y')"
	nowTime="$(date +'%H%M')"
	workDir="/root/backups/"
	fileName="backup_wp_$nowTime.tar.gz"
	fileNameOffSite="backup_wp_$nowTime_$nowDate.tar.gz"

aleksandar-babic / checkIfNesteggIsInstalled.yml

Created July 19, 2017 22:40

	---
	- hosts:
	- containers
	tasks:

	#Check if nestegg3.py main script file exists
	- stat:
	path: /usr/local/sbin/nestegg3.py
	register: resultPy