Glenn Plas gplv2

## mysql2sqlite.sh
#!/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

## httpd.conf_spiders
# To relieve servers

##Imagine a robots.txt file like this (Google understands this format):
#User-agent: *
#Disallow: /detailed
#Disallow: /?action=detailed
#Disallow: /*/detailed
#Crawl-delay: 20
##

## .bash_logout
#!/bin/bash

##
## Commit configuration files.
##
if [ ! -d /etc/.git ]; then
	cd /etc
	git init
	git config user.name "Server Administrator"
	git config user.email "root@localhost"

## mirrorOpenEMR_sf_git
#!/bin/bash
#
# Copyright (C) 2010 Brady Miller <brady@sparmy.com>
#
# This program is free software; you can redistribute it and/or
# modify it under the terms of the GNU General Public License
# as published by the Free Software Foundation; either version 2
# of the License, or (at your option) any later version.
#
#

## parkings.mapcss
meta {
        title: "new parking features";
        description: 'Display the new parking features from "Proposed_features/parking" (see link).';
        version: "1.0_2013-02-12";
        author: "Glenn Plas";
        link: "http://wiki.openstreetmap.org/wiki/Proposed_features/parking";
}

meta[lang=en] {
        title: "New parking features";

## appserver.nginx.conf
server {

  # Listen on internal ports only. Do not expose this server directly.
  listen 127.0.0.1:80;
  listen 10.0.0.1:80; # Secure internal IP

  # Hosts
  server_name www.wieni.be;

  # Root

## downgrade.sh
cat <<EOF >> /etc/apt/sources.list
deb http://archive.ubuntu.com/ubuntu precise main restricted universe
deb http://archive.ubuntu.com/ubuntu precise-updates main restricted universe
deb http://security.ubuntu.com/ubuntu precise-security main restricted universe multiverse
EOF

apt-get update

apt-get remove \
  apache2 \

## postgres_queries_and_commands.sql
-- performance tools
-- https://www.vividcortex.com/resources/network-analyzer-for-postgresql

-- show running queries (pre 9.2)
SELECT procpid, age(query_start, clock_timestamp()), usename, current_query
FROM pg_stat_activity
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;

-- show running queries (post 9.2)

## overpass.geojson

      
              1 file
            
          
              0 forks
            
          
              1 comment
            
          
              0 stars
            
          
                gplv2
                / overpass.geojson
            
            
              Created
              February 1, 2018 11:00
                — forked from anonymous/overpass.geojson
            
              
                data exported by overpass turbo
              
          
      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## haproxy.cfg
# haproxy postgresql master check
#
# haproxy listen: 5432
# pg, instance #1 listen: 5432 (master node)
# pg, instance #2 listen: 5432 (replica node)
# external failover, promoting replica to master in case of failure
# passwordless auth for user web
# template1 database is accessible by user web
#
# haproxy will pass connection to postgresql master node:
	#!/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
	# To relieve servers

	##Imagine a robots.txt file like this (Google understands this format):
	#User-agent: *
	#Disallow: /detailed
	#Disallow: /?action=detailed
	#Disallow: /*/detailed
	#Crawl-delay: 20
	##
	#!/bin/bash

	##
	## Commit configuration files.
	##
	if [ ! -d /etc/.git ]; then
	cd /etc
	git init
	git config user.name "Server Administrator"
	git config user.email "root@localhost"
	#!/bin/bash
	#
	# Copyright (C) 2010 Brady Miller <brady@sparmy.com>
	#
	# This program is free software; you can redistribute it and/or
	# modify it under the terms of the GNU General Public License
	# as published by the Free Software Foundation; either version 2
	# of the License, or (at your option) any later version.
	#
	#
	meta {
	title: "new parking features";
	description: 'Display the new parking features from "Proposed_features/parking" (see link).';
	version: "1.0_2013-02-12";
	author: "Glenn Plas";
	link: "http://wiki.openstreetmap.org/wiki/Proposed_features/parking";
	}

	meta[lang=en] {
	title: "New parking features";
	server {

	# Listen on internal ports only. Do not expose this server directly.
	listen 127.0.0.1:80;
	listen 10.0.0.1:80; # Secure internal IP

	# Hosts
	server_name www.wieni.be;

	# Root
	cat <<EOF >> /etc/apt/sources.list
	deb http://archive.ubuntu.com/ubuntu precise main restricted universe
	deb http://archive.ubuntu.com/ubuntu precise-updates main restricted universe
	deb http://security.ubuntu.com/ubuntu precise-security main restricted universe multiverse
	EOF

	apt-get update

	apt-get remove \
	apache2 \
	-- performance tools
	-- https://www.vividcortex.com/resources/network-analyzer-for-postgresql

	-- show running queries (pre 9.2)
	SELECT procpid, age(query_start, clock_timestamp()), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (post 9.2)
	# haproxy postgresql master check
	#
	# haproxy listen: 5432
	# pg, instance #1 listen: 5432 (master node)
	# pg, instance #2 listen: 5432 (replica node)
	# external failover, promoting replica to master in case of failure
	# passwordless auth for user web
	# template1 database is accessible by user web
	#
	# haproxy will pass connection to postgresql master node: