[Pdns-users] powerdns on windows with mssql

Michael C. Gates michael at gatesadweb.com
Tue Oct 31 00:56:04 UTC 2006

I have it running on MS SQL 2000 and Windows 2000 and 2003. The 2000 server
seems to crash a lot, so I had to write a program to check every so often,
and restart the service if it crashed. Unfortunately, setting up the
recovery in the service properties doesn't work. I have had 2 Windows 2003
servers with the same problem, but then I have one that has been running for
a few months without a single crash. I then set up SQL Replication so that I
only have to mess with one db.

Here is the SQL Script for creating the table:

CREATE TABLE [dbo].[records] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[domain_id] [int] NULL ,
	[name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[type] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[content] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
	[ttl] [int] NULL ,
	[prio] [int] NULL ,
	[change_date] [int] NULL 

There was an issue with the table and I do not recall what it was. But there
were no errors, it just wouldn't work. It boggled my mind for a while. Then
I figured it out. I should have written it down!

I even wrote a vb script to import all of my MS records into the database.
So if you need help with that, I can help you out.

If you have any problems let me know. I seem to be one of the only ones
running Windows.


Michael C. Gates

-----Original Message-----
From: pdns-users-bounces at mailman.powerdns.com
[mailto:pdns-users-bounces at mailman.powerdns.com] On Behalf Of Adam Bazylczyk
Sent: Friday, October 27, 2006 3:17 PM
To: pdns-users at mailman.powerdns.com
Subject: [Pdns-users] powerdns on windows with mssql

I try to use MS SQL database and become query errors.
Can anyone help my by configuration?
I think, MS SQL is more stabil than Access?

Adam Bazylczyk

Pdns-users mailing list
Pdns-users at mailman.powerdns.com

More information about the Pdns-users mailing list