[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
Michael C. Gates
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?
Pdns-users mailing list
Pdns-users at mailman.powerdns.com
More information about the Pdns-users