jp1337

# vim ~/.gitconfig
# :set paste
# i for insert
# paste the following text:

[core]
	quotepath = false
[pull]
	rebase = false
[filter "lfs"]

jp1337

Old Way:

dd if=/dev/zero of=zero.small.file bs=1024 count=102400
dd if=/dev/zero of=zero.file bs=1024
rm zero.small.file
sync ; sleep 60 ; sync
rm zero.file

in a windows vm you can use sdelete:
sdelete.exe -z c::

jp1337

Update source games (CS:GO etc.) on server start/restart

you can add these params to srcds startup: -autoupdate -steam_dir steamcmd -steamcmd_script update.txt

create an "update.txt" file inside steamcmd folder with the following content:

// update.txt
//

jp1337

#!/bin/sh

# Converts a mysqldump file into a Sqlite 3 compatible file. It also extracts the MySQL `KEY xxxxx` from the
# CREATE block and create them in separate commands _after_ all the INSERTs.

# Awk is choosen because it's fast and portable. You can use gawk, original awk or even the lightning fast mawk.
# The mysqldump file is traversed only once.

# Usage: $ ./mysql2sqlite mysqldump-opts db-name | sqlite3 database.sqlite
# Example: $ ./mysql2sqlite --no-data -u root -pMySecretPassWord myDbase | sqlite3 database.sqlite

jp1337

# Debian sources.list for continuous release upgrades.
# I changed the normal release name to "stable". This means debian is updating to the next release if available.

# Stable Main
deb http://ftp.de.debian.org/debian/ stable main
deb-src http://ftp.de.debian.org/debian/ stable main

# Security Updates Stable Main
deb http://security.debian.org/ stable/updates main
deb-src http://security.debian.org/ stable/updates main

jp1337

[/script/theisle.igamesession]
ServerName=xxx
ServerPassword=
ServerSteamGroup=
ServerMOTD=Hi There :3
bFamilySharing=false
bServerDatabase=true
bServerAllowChat=true
bServerGlobalChat=true
bServerNameTags=true

jp1337

# Example File: /etc/systemd/system/owapi.service
# Use this for creating a new linux service.
# Execute `systemctl daemon-reload` after creating the file.
# remove these comments!

[Unit]
Description=OWAPI - Overwatch API server process
Wants=network-online.target
After=syslog.target time-sync.target network.target network-online.target

jp1337

#!/bin/bash

# this script works with the latest version of Check_MK. Tested using Raw 1.6.0b7 on Debian and RedHat.

# be sure that curl is installed!
# apt install -y curl
# yum install -y curl

# use the script with these steps:
# curl -Os -H 'Cache-Control: no-cache' https://gist.githubusercontent.com/jpylypiw/f55352de920b75cccbe6e50c6ad4b4cd/raw/update_check_mk_agent.sh

jp1337

Apache Configuration Examples

Generically Redirect HTTP TO HTTPS

<VirtualHost *:80>
        RewriteEngine On
        RewriteRule ^(.*)$ https://%{HTTP_HOST}$1 [R=301,L]
</VirtualHost>

jp1337

-- ----------------
-- Reorganize Index
-- ----------------
USE MYDATABASE;
GO
EXECUTE sp_msForEachTable 'SET QUOTED_IDENTIFIER ON; ALTER INDEX ALL ON ? REBUILD;'
GO
EXECUTE sp_msForEachTable 'SET QUOTED_IDENTIFIER ON; ALTER INDEX ALL ON ? REORGANIZE;'
GO