Configuring TYPO3

Install dummy package and sources from TYPO3 as usual.

Starting from TYPO3 4.4, the process is fully automated using 1-2-3 installer. Manual process is kept as reference for TYPO3 4.3.

1-2-3 Installer

Browse http://your-website.tld/. This will redirect you to the 1-2-3 installer. The wizard is straightforward to use…

[TYPO3 4.3] Installing and Configuring ADOdb and DBAL

Edit file typo3conf/localconf.php:

  • Append adodb,dbal to $TYPO3_CONF_VARS['EXT']['extList'] and to $TYPO3_CONF_VARS['EXT']['extList_FE']
  • Add code below to end of file:
$TYPO3_CONF_VARS['EXTCONF']['dbal']['handlerCfg'] = array(
’_DEFAULT’ => array(
’type’ => ’adodb’,
’config’ => array(
’driver’ => ’oci8’,
’driverOptions’ => array(
’connectSID’ => false,
),
)
),
);

This allows you to connect to an Oracle server using a serviceName (see below). If you wish to use a SID instead, make sure to set driver’s option connectSID to true.

[TYPO3 4.3] Configuring Database Access

Edit typo3conf/localconf.php again and add these lines:

$typo_db_username = 'username';
$typo_db_password = 'password';
$typo_db_host = 'localhost';
$typo_db = 'ServiceNameOrSID';

Unlike MySQL you don’t connect to a server and select a database. You connect as a user and use the default schema. To do this you can either enter the SID or the name of the service (’XE’ when you use 10g XE). You must set the hostname and the service name in $typo_db_host and $typo_db. It’s not possible to set them in one as //hostname/servicename.

If you need to use another default port than 1521, use following syntax for $typo_db_host:

$typo_db_host = 'localhost:1234';

If you wish to use caching framework introduced with TYPO3 4.3, you have to remap very long tables names to prevent the identifier to be too long for Oracle. Update typo3conf/localconf.php:

$TYPO3_CONF_VARS['EXTCONF']['dbal']['mapping'] = array(
’cachingframework_cache_hash’ => array(
’mapTableName’ => ’cf_cache_hash’,
),
’cachingframework_cache_pages’ => array(
’mapTableName’ => ’cf_cache_pages’,
),
’cachingframework_cache_hash_tags’ => array(
’mapTableName’ => ’cf_cache_hash_tags’,
),
’cachingframework_cache_pages_tags’ => array(
’mapTableName’ => ’cf_cache_pages_tags’,
),
’cachingframework_cache_pagesection’ => array(
’mapTableName’ => ’cf_cache_ps’,
),
’cachingframework_cache_pagesection_tags’ => array(
’mapTableName’ => ’cf_cache_ps_tags’,
),
);

[TYPO3 4.3] Configuring TYPO3

Now you should be able to access the install tool (not the 1-2-3 wizard) from server/typo3/install/ and configure TYPO3 as usual.

Patching Core

As of TYPO3 4.3, DBAL system extension is now included as svn:externals into TYPO3 core. Meaning it will potentially be updated with new releases to fix bugs. If you find a bug, please report it to  DBAL bugtracker (make sure to choose subproject tx_dbal).

If you need the most up-to-date version of DBAL, then you should consider using its trunk version with a subversion check-out into typo3conf/ext/dbal (which will override the system version). SVN URL is:

https://svn.typo3.org/TYPO3v4/Extensions/dbal/trunk

You should consider then consider using trunk version of following files too, in typo3_src:

  • t3lib/class.t3lib_db.php
  • t3lib/class.t3lib_sqlparser.php

Installing TemplaVoilà

If you install TemplaVoilà without further adjustements, you will have problems with sequences that are automatically created to emulate the "auto-increment" feature of MySQL as the identifier will be too long for Oracle.

As such, before creating tables (easiest is before installing/loading extension templavoila), update typo3conf/localconf.php:

$TYPO3_CONF_VARS['EXTCONF']['dbal']['mapping'] = array(
’cachingframework_cache_hash’ => array(
’mapTableName’ => ’cf_cache_hash’,
),
’cachingframework_cache_pages’ => array(
’mapTableName’ => ’cf_cache_pages’,
),
’cachingframework_cache_hash_tags’ => array(
’mapTableName’ => ’cf_cache_hash_tags’,
),
’cachingframework_cache_pages_tags’ => array(
’mapTableName’ => ’cf_cache_pages_tags’,
),
’cachingframework_cache_pagesection’ => array(
’mapTableName’ => ’cf_cache_ps’,
),
’cachingframework_cache_pagesection_tags’ => array(
’mapTableName’ => ’cf_cache_ps_tags’,
),
’tx_templavoila_datastructure’ => array(
’mapTableName’ => ’tx_templavoila_ds’,
),
);

Then install/load extension templavoila from EM and create tables as usual.

Installing RealURL

Nothing special anymore, SQL parser is finally able to deal with length restriction on indexes and as such you just have to load RealURL and enjoy!

Installing tt_news

As of November, 3rd 2009, following patches need to be applied to extension tt_news to make it DBAL compatible:

Installing DAM

Please read my dedicated article to see how to use DBAL with extension Digital Asset Management.

Other Patches

Here are some links that have patches for DBAL. They might be useful (I try to fix DBAL itself whenever I encounter some bug):

 

 

Causal Sàrl - Development, TYPO3, Consulting
Flattr