Wolfgang Wagner wowaTYPO3

TYPO3 Auto-Installation

Since I need a TYPO3 test environment from time to time, I use these bash scripts for the automatic installation and removal of TYPO3. The installation script currently supports TYPO3 versions 10, 11, 12, 13 and dev.

Installation

I have stored the scripts under:

~/.shellscripts/typo3/

I use the following aliases:

What does it do?

This littel script fetches all packages, listed on packagist with type typo3-cms-extension, and iterates over them and collect download data for every single packages.

It will echo it as csv, so it can easily be parsed into a .csv file for better sorting etc.

How to generate csv file

$ php fetchExtensionDownloadDataFromPackagist.php &gt; downloadData.csv

tl;dr “TemplaVoila!” (https://github.com/templavoila/templavoila/) is dead, Alexander Schnitzlers Fork “TemplaVoilà” is not working (https://github.com/alexanderschnitzler/templavoila/), Pluspols Fork “TemplaVoilà Plus” (https://github.com/pluspol-interactive/templavoilaplus/) is working but migrates all code due to the new extension key

Juni 2013: Tolleiv Nietsch stellt die Weiterentwicklung von TemplaVoila ein http://blog.tolleiv.de/2013/06/templavoila-future/

Mai 2014: TYPO3 Freelancer Alexander Schnitzler übernimmt zusammen mit Wouter Wolters die Weiterentwicklung von TemplaVoila

März 2015: Mehrere Bugfix Releases für TemplaVoila, kompatibel mit TYPO3 6.2

Mai 2015: Alexander Schnitzler kündigt an, dass es keine Feature Releases für TemplaVoila mehr geben wird, sondern nur noch ein paar letzte Bugfix Releases https://gist.github.com/alexanderschnitzler/7df8576d8abbcb8745b8

Requirements for deployment

ssh (generate key and put on server)
rsync must be available on both machines (deployment host and target host)
PHP cli binary must be available on both machines (deployment host and target host)
composer must be available on deployment host

Needed info for each target system:

deploy directory

	SELECT table_name AS "Table", ROUND((data_length / 1024 / 1024), 2) AS "Data size (MB)", ROUND((index_length / 1024 / 1024), 2) AS "Index size (MB)"
	FROM information_schema.TABLES
	WHERE table_schema = "[database_name]"
	ORDER BY data_length DESC



	# 1
	# ---------------------------------------------
	#
	# Add tsconfig to load the custom RTE config:
	`RTE.default.preset = Custom`


	# 2

	# Delete all duplicate sys_file_records, where one and the same sys_file UID
	# is related to the same tt_content record
	DELETE t_orig
	FROM sys_file_reference t_orig
	INNER JOIN sys_file_reference t_copy
	WHERE t_orig.tablenames='tt_content'
	AND t_orig.fieldname='image'
	AND t_orig.deleted=0
	AND t_copy.tablenames='tt_content'
	AND t_copy.fieldname='image'

	# Move typo3temp into RAM-Disk. Do not sync vendor and TYPO3-Directory.
	# For MAC: 'nocopy' will only work correct, if nfs_mount_enabled is true
	version: '3.6'
	services:
	web:
	volumes:
	- type: tmpfs
	tmpfs:
	size: 268435456
	# TYPO3 8

	#!/bin/bash
	# Remote Server
	# If you don't use a SSH-Key you have to use format: user[:password]@jweilandXYZ.net
	# else domainname is enough
	server="jweilandXYZ.net"
	rPath="~/typo3cms/dev/"
	# Path to project root, not FE root (web)
	lPath="/Users/stefan/htdocs/kunden/project/"
	# PID of first root page. Needed to create a sys_domain record. In most cases this will be 1
	lRootPageUid="1"

	{
	"require": {
	"typo3-console/composer-auto-setup": "^0.1",
	"georgringer/news": "^6.1",
	"helhum/typo3-secure-web": "^0.2.5",
	"typo3/cms-introduction": "^3.0"
	},
	"extra": {
	"typo3/cms": {
	"cms-package-dir": "{$vendor-dir}/typo3/cms",