Thomas Ayissi thomas-ayissi

🐛 TechnoFutur - Problèmes Rencontrés

Présentation 📌

Problème	Solution proposée	Autres infos / liens / notes
LinQ	[Exos LinQ Session 25 et 28 Nov 2022] (https://github.com/SamBstorm/Net-Secu-LinQ-Corrections)

UPDATE (March 2020, thanks @ic): I don't know the exact AMI version but yum install docker now works on the latest Amazon Linux 2. The instructions below may still be relevant depending on the vintage AMI you are using.

Amazon changed the install in Linux 2. One no-longer using 'yum' See: https://aws.amazon.com/amazon-linux-2/release-notes/

Docker CE Install

sudo amazon-linux-extras install docker
sudo service docker start

TSQL Example

USE master;
GO

DECLARE @nvcmaxVariable nvarchar(max);
SET @nvcmaxVariable = CONVERT(nvarchar(max), N'ಠ russian anomaly ЯЁЪ ಠ ') + N'something else' + N'another';
SELECT @nvcmaxVariable;

On MS SQL Server

to Accurately calcutalte the age of something this works for most situations

SELECT
  FLOOR( --floor function returns age in years
    CAST( DATEDIFF( DAY, /*StartDate*/ , /*EndDate*/ ) AS DEC(38,16) ) / CAST(365.2425 AS DEC(38,16)) 
  ) As AgeInYears

FROM SomeTable

SQL

T-SQL

Comparison

Dates

Query comparing dates in SQL

How to harden WordPress install

Note: paths below assume subdirectory install in wordpress subdirectory and WordPress multi-environment configuration.

Prevent full path disclosure

See: Why are there path disclosures when directly loading certain files?

Add the following to .user.ini (or similar):

	#
	# yii fant configuration file template for MySQL, Galera Cluster, MariaDB and Percona Server
	# Location: /etc/my.cnf or /etc/mysql/my.cnf
	# This template is intended to work with MySQL 5.6 and newer and MariaDB 10.0 and newer
	# Get most recent updated from here:
	# 本配置文件将所有character set都设置为utf8
	#

	[client]


	.
	..
	........
	@
	*
	.
	..*
	ðŸŽ


	.
	..
	........
	@
	*
	.
	..*
	ðŸŽ

	$ErrorActionPreference = "Stop"
	Set-StrictMode -Version 3.0

	<#--------------------------------------------------------------------------
	https://gallery.technet.microsoft.com/scriptcenter/The-PowerShell-script-for-2a2456c4


	.SYNOPSIS
	Script for running T-SQL files in MS SQL Server
	Andy Mishechkin