Difference between revisions of "PowerDNS OpenDBX Backend/Configuration/Database specific"
(back link) |
(links to table definitions) |
||
| Line 2: | Line 2: | ||
Supported without changes since OpenDBX 1.0.0 | Supported without changes since OpenDBX 1.0.0 | ||
| + | |||
| + | [http://www.linuxnetworks.de/pdnsodbx/download/tables-mysql.sql MySQL table definitions] | ||
== PostgreSQL == | == PostgreSQL == | ||
Supported without changes since OpenDBX 1.0.0 | Supported without changes since OpenDBX 1.0.0 | ||
| + | |||
| + | [http://www.linuxnetworks.de/pdnsodbx/download/tables-pgsql.sql PostgreSQL table definitions] | ||
== SQLite and SQLite3 == | == SQLite and SQLite3 == | ||
| Line 14: | Line 18: | ||
opendbx-host-write = /path/to/file/ | opendbx-host-write = /path/to/file/ | ||
opendbx-database = powerdns.sqlite | opendbx-database = powerdns.sqlite | ||
| + | |||
| + | [http://www.linuxnetworks.de/pdnsodbx/download/tables-sqlite.sql SQLite table definitions] | ||
== MS SQL Server == | == MS SQL Server == | ||
| Line 22: | Line 28: | ||
opendbx-host-write = MSSQL2k | opendbx-host-write = MSSQL2k | ||
opendbx-sql-transactbegin = BEGIN TRANSACTION | opendbx-sql-transactbegin = BEGIN TRANSACTION | ||
| + | |||
| + | [http://www.linuxnetworks.de/pdnsodbx/download/tables-sybase.sql MS SQL Server table definitions] | ||
== Sybase ASE == | == Sybase ASE == | ||
| Line 30: | Line 38: | ||
opendbx-host-write = SYBASE | opendbx-host-write = SYBASE | ||
opendbx-sql-transactbegin = BEGIN TRANSACTION | opendbx-sql-transactbegin = BEGIN TRANSACTION | ||
| + | |||
| + | [http://www.linuxnetworks.de/pdnsodbx/download/tables-sybase.sql Sybase table definitions] | ||
== Oracle == | == Oracle == | ||
| Line 36: | Line 46: | ||
opendbx-sql-transactbegin = SET TRANSACTION NAME 'AXFR' | opendbx-sql-transactbegin = SET TRANSACTION NAME 'AXFR' | ||
| + | |||
| + | [http://www.linuxnetworks.de/pdnsodbx/download/tables-oracle.sql Oracle table definitions] | ||
---- | ---- | ||
Back to [[PowerDNS_OpenDBX_Backend|Overview]] | Back to [[PowerDNS_OpenDBX_Backend|Overview]] | ||
Revision as of 16:17, 18 November 2007
MySQL
Supported without changes since OpenDBX 1.0.0
PostgreSQL
Supported without changes since OpenDBX 1.0.0
SQLite and SQLite3
Supported without changes since OpenDBX 1.0.0 but requires to set opendbx-host to the path of the SQLite file (including the trailing slash or backslash, depending on your operating system) and opendbx-database to the name of the file, e.g.
opendbx-host-read = /path/to/file/ opendbx-host-write = /path/to/file/ opendbx-database = powerdns.sqlite
MS SQL Server
Supported by PowerDNS 2.9.20 (with latest patch) and OpenDBX 1.1.4 by using the FreeTDS library. It uses a different scheme for host configuration (requires the name of the host section in the configuration file of the dblib client library) and doesn't support the default statement for starting transactions. Please add the following lines to your pdns.conf:
opendbx-host-read = MSSQL2k opendbx-host-write = MSSQL2k opendbx-sql-transactbegin = BEGIN TRANSACTION
MS SQL Server table definitions
Sybase ASE
Supported by PowerDNS 2.9.20 (with latest patch) and OpenDBX 1.1.5 by using the native Sybase ctlib or the FreeTDS library. It uses a different scheme for host configuration (requires the name of the host section in the configuration file of the ctlib client library) and doesn't support the default statement for starting transactions. Please add the following lines to your pdns.conf:
opendbx-host-read = SYBASE opendbx-host-write = SYBASE opendbx-sql-transactbegin = BEGIN TRANSACTION
Oracle
Supported by PowerDNS 2.9.20 (with latest patch) and OpenDBX 1.1.6. It uses a different syntax for transactions and requires the following additional line in your pdns.conf:
opendbx-sql-transactbegin = SET TRANSACTION NAME 'AXFR'
Back to Overview
