ErHaWeb

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:

froemken

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

cepheiVV

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


# 2

tomasnorre

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 > downloadData.csv

froemken

# 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'

froemken

# 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

froemken

#!/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"

helhum

{
    "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",

pixelbrackets

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

helhum

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