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’ => ’mssql’, // using native driver
//’driver’ => ’odbc_mssql’, // using ODBC driver
’useNameQuote’ => TRUE,

[TYPO3 4.3] Configuring Database Access

Native MSSQL Driver

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

$typo_db_username = 'typo3';
$typo_db_password = 'typo3';
$typo_db_host = 'your-windows-server-ip';
$typo_db = 'TYPO3demo';

ODBC Driver

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

$typo_db_username = 'typo3';
$typo_db_password = 'typo3';
$typo_db_host = 'TYPO3MSSQL'; // As configured in your odbc.ini
$typo_db = 'dummy_string'; // Is configured in ODBC handler

[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:

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

Useful Tool



Causal Sàrl - Development, TYPO3, Consulting