PowerDNS OpenDBX Backend/Configuration/Database specific - Revision history

Nose: Reverted edits by 209.106.168.1 (Talk) to last version by Nose

2010-04-23T19:23:20Z

Reverted edits by 209.106.168.1 (Talk) to last version by Nose

2010-04-21T22:31:18Z

‎Firebird/Interbase

2008-06-22T12:37:36Z

removed backlink

2008-03-09T13:33:21Z

‎MySQL

2008-03-09T13:31:49Z

MySQL trigger

2008-03-08T13:01:53Z

‎SQLite and SQLite3

2008-03-08T11:27:34Z

‎Firebird 2

2008-03-07T16:51:56Z

firebird

2007-11-18T15:17:58Z

links to table definitions

2007-11-18T15:09:05Z

back link

@@ Line 25: / Line 25: @@
 [http://www.linuxnetworks.de/pdnsodbx/download/tables-sqlite3.sql SQLite3 table definitions]
-RrQZF  <a href="http://adjxsypyywri.com/">adjxsypyywri</a>, [url=http://sjdvaxqiksen.com/]sjdvaxqiksen[/url], [link=http://kmctyfoknbat.com/]kmctyfoknbat[/link], http://mbjpstxncxbg.com/
+== Firebird/Interbase ==
 == MS SQL Server ==

@@ Line 25: / Line 25: @@
 [http://www.linuxnetworks.de/pdnsodbx/download/tables-sqlite3.sql SQLite3 table definitions]
-== Firebird/Interbase ==
+RrQZF  <a href="http://adjxsypyywri.com/">adjxsypyywri</a>, [url=http://sjdvaxqiksen.com/]sjdvaxqiksen[/url], [link=http://kmctyfoknbat.com/]kmctyfoknbat[/link], http://mbjpstxncxbg.com/
-−
-Supported by PowerDNS 2.9.20 and OpenDBX 1.1.4 but requires to set opendbx-database to the path of the database file and doesn't support the default statement for starting transactions. Please add the following lines to your pdns.conf:
-−
-  opendbx-database = /var/lib/firebird2/data/powerdns.gdb
- opendbx-sql-transactbegin = SET TRANSACTION
-−
-When creating the database please make sure that you call the isql tool with the parameter "-page 4096". Otherwise, you will get an error (key size exceeds implementation restriction for index "pdns_unq_domains_name") when creating the tables.
-−
- isql -u SYSDBA -page 4096
-−
-[http://www.linuxnetworks.de/pdnsodbx/download/tables-firebird.sql Firebird table definitions]
 == MS SQL Server ==

← Older revision		Revision as of 12:37, 22 June 2008
Line 65:		Line 65:

	[http://www.linuxnetworks.de/pdnsodbx/download/tables-oracle.sql Oracle table definitions]		[http://www.linuxnetworks.de/pdnsodbx/download/tables-oracle.sql Oracle table definitions]
−
−
−	~~----~~
−	~~Back to [[PowerDNS_OpenDBX_Backend\|Overview]]~~

@@ Line 1: / Line 1: @@
 == MySQL ==
-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]
+The file below also contains trigger definitions which are necessary for "auto serial" support, but they are only available in MySQL 5 and later. If you are still using MySQL 4.x and don't want to utilize the automatically generated zone serials, you can safely remove the "CREATE TRIGGER" statements from the file before creating the database tables.
-The file contains trigger definitions which are necessary for "auto serial" support, but they are only available in MySQL 5 and later. If you are still using MySQL 4.x and don't want to utilize the automatically generated zone serials, you can safely remove the "CREATE TRIGGER" statements from the file before creating the database tables.
+[http://www.linuxnetworks.de/pdnsodbx/download/tables-mysql.sql MySQL table definitions]
 == PostgreSQL ==

← Older revision		Revision as of 13:31, 9 March 2008
Line 4:		Line 4:

	[http://www.linuxnetworks.de/pdnsodbx/download/tables-mysql.sql MySQL table definitions]		[http://www.linuxnetworks.de/pdnsodbx/download/tables-mysql.sql MySQL table definitions]
		+
		+	The file contains trigger definitions which are necessary for "auto serial" support, but they are only available in MySQL 5 and later. If you are still using MySQL 4.x and don't want to utilize the automatically generated zone serials, you can safely remove the "CREATE TRIGGER" statements from the file before creating the database tables.

	== PostgreSQL ==		== PostgreSQL ==

← Older revision		Revision as of 13:01, 8 March 2008
Line 20:		Line 20:

	[http://www.linuxnetworks.de/pdnsodbx/download/tables-sqlite.sql SQLite table definitions]		[http://www.linuxnetworks.de/pdnsodbx/download/tables-sqlite.sql SQLite table definitions]
		+
		+	[http://www.linuxnetworks.de/pdnsodbx/download/tables-sqlite3.sql SQLite3 table definitions]

	== Firebird/Interbase ==		== Firebird/Interbase ==

← Older revision		Revision as of 16:51, 7 March 2008
Line 20:		Line 20:

	[http://www.linuxnetworks.de/pdnsodbx/download/tables-sqlite.sql SQLite table definitions]		[http://www.linuxnetworks.de/pdnsodbx/download/tables-sqlite.sql SQLite table definitions]
		+
		+	== Firebird 2 ==
		+
		+	Supported by PowerDNS 2.9.20 and OpenDBX 1.1.4 but requires to set opendbx-database to the path of the database file and doesn't support the default statement for starting transactions. Please add the following lines to your pdns.conf:
		+
		+	opendbx-database = /var/lib/firebird2/data/powerdns.gdb
		+	opendbx-sql-transactbegin = SET TRANSACTION
		+
		+	When creating the database please make sure that you call the isql tool with the parameter "-pagelength 4096". Otherwise, you will get an error (key size exceeds implementation restriction for index "pdns_unq_domains_name") when creating the tables.
		+
		+	isql -u SYSDBA -pagelength 4096
		+
		+	[http://www.linuxnetworks.de/pdnsodbx/download/tables-firebird.sql Firebird table definitions]

	== MS SQL Server ==		== MS SQL Server ==

@@ Line 2: / Line 2: @@
 Supported without changes since OpenDBX 1.0.0
 == PostgreSQL ==
 Supported without changes since OpenDBX 1.0.0
 == SQLite and SQLite3 ==
@@ Line 14: / Line 18: @@
   opendbx-host-write = /path/to/file/
   opendbx-database = powerdns.sqlite
 == MS SQL Server ==
@@ Line 22: / Line 28: @@
   opendbx-host-write = MSSQL2k
   opendbx-sql-transactbegin = BEGIN TRANSACTION
 == Sybase ASE ==
@@ Line 30: / Line 38: @@
   opendbx-host-write = SYBASE
   opendbx-sql-transactbegin = BEGIN TRANSACTION
 == Oracle ==
@@ Line 36: / Line 46: @@
   opendbx-sql-transactbegin = SET TRANSACTION NAME 'AXFR'
 ----
 Back to [[PowerDNS_OpenDBX_Backend|Overview]]

← Older revision		Revision as of 15:09, 18 November 2007
Line 36:		Line 36:

	opendbx-sql-transactbegin = SET TRANSACTION NAME 'AXFR'		opendbx-sql-transactbegin = SET TRANSACTION NAME 'AXFR'
		+
		+
		+	----
		+	Back to [[PowerDNS_OpenDBX_Backend\|Overview]]