Skip to the content
Documentation
Help Start
Reading in:
  • German: 9,059 of 9,059 pages
About the help in other languages
All help pages

datatable.ini [ConnectionSettings]

The settings of [ConnectionSettings] in datatable.ini: Engines, SQLiteDirectories, AllowedHosts, ConnectTimeout

Download as PDF

Address: https://doc.exponential.earth/learninminutes/exphelp/viewer/examples/ini-settings/datatable/ConnectionSettings.md

On this page

datatable.ini [ConnectionSettings]

The block [ConnectionSettings] of settings/datatable.ini, with 4 setting(s).

Never edit settings/datatable.ini itself: an update replaces it. Put the settings you change in an override, which wins over the shipped file:

  • settings/override/datatable.ini.append.php for every siteaccess,
  • settings/siteaccess/<siteaccess>/datatable.ini.append.php for one siteaccess,
  • extension/<extension>/settings/datatable.ini.append.php in an extension (read when the extension is active).

Engines

The engines that may be used for a connection (sqlite, mysql, postgresql, oracle, sqlserver, mongodb)

Default: a list of 6: sqlite, mysql, postgresql, oracle, sqlserver, mongodb.

<?php /* #?ini charset="utf-8"?
# settings/override/datatable.ini.append.php
[ConnectionSettings]
# an empty "Engines[]" first replaces the shipped list; without it the items are added
Engines[]
Engines[]=sqlite
Engines[]=mysql
Engines[]=postgresql
Engines[]=oracle
Engines[]=sqlserver
Engines[]=mongodb
*/ ?>

SQLiteDirectories

The directories a SQLite connection's file may be in, relative to the installation; the file is created there
when it does not exist yet. A path outside them is refused.

Default: a list of 1: var/datatable.

<?php /* #?ini charset="utf-8"?
# settings/override/datatable.ini.append.php
[ConnectionSettings]
# an empty "SQLiteDirectories[]" first replaces the shipped list; without it the items are added
SQLiteDirectories[]
SQLiteDirectories[]=var/datatable
*/ ?>

AllowedHosts

Hosts a server connection may reach, besides any when the list is empty (host names or addresses; * for any)

Default: an empty list.

<?php /* #?ini charset="utf-8"?
# settings/override/datatable.ini.append.php
[ConnectionSettings]
# an empty "AllowedHosts[]" first replaces the shipped list; without it the items are added
AllowedHosts[]
*/ ?>

ConnectTimeout

Seconds a connection test waits for the server

Default: 5.

<?php /* #?ini charset="utf-8"?
# settings/override/datatable.ini.append.php
[ConnectionSettings]
ConnectTimeout=5
*/ ?>

Generated by ./console exp:help:examples from settings/datatable.ini. Do not edit this page: change the source and generate again (how). Free documentation: GFDL 1.3 or later.

Something wrong on this page? Report an error

Documentation license

This documentation is free documentation, licensed under the GNU Free Documentation License 1.3 or later.

Exponential Copyright © 1998-2026 Exponential Foundation and 7x