Simple DNS Plus - Community Forums Back to JH Software
Welcome Guest Search | Active Topics | Log In | Register

2 Pages <12
Configuring SQL Plus Plugin Options
Menno de Ruiter
#16 Posted : Wednesday, July 21, 2010 2:04:09 AM


Joined: 7/21/2010
Posts: 7
Location: Spain
Anyway knowing how to have a SOA record stored at RecData in the SQL db?

I tried several examples, http://www.zytrax.com/books/dns/ch8/soa.html but can't get it working.

I get a Server error message when I do a lookup.

Regards,
Menno
Menno de Ruiter
#17 Posted : Wednesday, July 21, 2010 2:22:10 AM


Joined: 7/21/2010
Posts: 7
Location: Spain
Oh, I found it already,
win-l835v7b2qpr. nobody.telguia.com. 2010072101 10800 3600 777600 3600

that's all, great, i love this SimpleDNS SQL Plus plugin

I kept on messing up with linefeeds, carriage return char(13) and char(10), which messed it all up, appeartly 1 space in between the record format is sufficient and new line is not appropiate, at least, that is what I noticed

I noticed that using nvarchar in the DB as instead varchar, incredible enhanced the speed
I also use a primary key on:
rectype
recname

remind that the total size can not exceed 900 characters, but rectype can be small, i use recname as nvarchar(400)





Menno de Ruiter
#18 Posted : Wednesday, July 21, 2010 2:30:59 AM


Joined: 7/21/2010
Posts: 7
Location: Spain
Does anyone knows how to input in the SQL DB in conjunction with a SOA record:

- the Answer section
AND the
- Authority section

I can get only an answer section, but not both.

Or am I missing something?
Menno de Ruiter
#19 Posted : Wednesday, July 21, 2010 2:57:14 AM


Joined: 7/21/2010
Posts: 7
Location: Spain
I knew I was missing something, this is:

If you have in your DB several more rows with several types, like SOA, TXT, NS, A or whatever, the MS SQL Plus plugin ALL returns them in one NS / UDP packet !!! this is Great, absolutly Great.

With the exclusions you can finetune the queries. I think it can cover all possibilies now.

This Plugin in combination with SimpleDNS is just what I was looking for since 1999 ;-)

amazing
Users browsing this topic
Guest
2 Pages <12
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.