RE: [Pdns-users] Supported databases of the OpenDBX backend
Is this a new version of PDNS, or a program used to connect Linux to different DB's? Will this combination work with Suse Linux and MS SQL? Best regards, Michael C. Gates -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Norbert Sendetzky Sent: Friday, January 26, 2007 12:00 PM To: pdns-users@mailman.powerdns.com Subject: [Pdns-users] Supported databases of the OpenDBX backend Hi all After having released the next stable series of OpenDBX (1.2.x), I would like to give you an update about the supported and tested databases in combination with the OpenDBX backend. These databases are tested and officially supported: - MySQL - PostgreSQL - SQLite 2 and 3 - MS SQL Server - Sybase ASE - Oracle The new Firebird 2.0 database wasn't tested up to now but should also work. Speed tests done a while ago have shown that the OpenDBX backend not only offers more high-end features than the other backends shipped with PowerDNS but also higher performance. This is at least true for the gmysql backend I've used for comparison as it is probably the backend used most often in installations. Links: http://wiki.linuxnetworks.de/index.php/OpenDBX http://wiki.linuxnetworks.de/index.php/PowerDNS_OpenDBX_Backend http://wiki.linuxnetworks.de/index.php/PowerDNS_OpenDBX_Backend_-_Comparison Feel free to test PowerDNS with your favorite database now :-) Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
[Pdns-users] Suse Linux and MS SQL
I have Suse Linux on one box, and MS SQL on another. Is it possible (And how hard would it be) to install PDNS on the Suse box, and then use MS SQL as the backend? Thanks, _ Michael C. Gates Ph/717.798.8142 Fx/954.252.4193 gateshosting.com http://www.gateshosting.com/ http://www.gateshosting.com/ GatesHosting.com http://www.gateshosting.com/ | BIGmail(tm) - Email Large http://www.gateshosting.com/aboutbigmail/ Files | Web Hosting http://www.gateshosting.com/web-hosting/ | Email http://www.gateshosting.com/ Protection | Custom Web http://www.gateshosting.com/web-sites/ Sites GatesHosting.com has been Hosting, developing custom designed Web Sites and writing Custom Programs since 1997. logo.gif Description: GIF image ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
RE: [Pdns-users] Suse Linux and MS SQL
Great, I will try it out. So Suse Linux will work fine for PDNS? The problem I am having is it is crashing every 15 minutes in windows. I wrote a routine to restart it every half hour, but it is getting out of hand now. It was only crashing 3 to 4 times a day, but now it is all the time. It is becoming a problem, and I definitely do not want to go back to MS DNS. Thanks, Michael C. Gates -Original Message- From: Marius Parescius [mailto:[EMAIL PROTECTED] Sent: Thursday, January 04, 2007 11:06 AM To: Michael C. Gates Subject: Re: [Pdns-users] Suse Linux and MS SQL Hello Michael, Thursday, January 4, 2007, 5:49:28 PM, you wrote: I have Suse Linux on one box, and MS SQL on another. Is it possible (And how hard would it be) to install PDNS on the Suse box, and then use MS SQL as the backend? Some time ago we used sybase client drivers to access mssql db and it works. (o)(o) -- --ooo--(__)--ooo-- Best regards, Marius Parescius mailto:[EMAIL PROTECTED] Elektronine prekyba Paneriu 51, Vilnius, Lithuania mob: +370 686 77781 tel: +370 5 2104330 fax: +370 5 2104329 ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
RE: [Pdns-users] Suse Linux and MS SQL
I guess there is no type of ODBC driver for Suse Linux? That would be fine for me. I just can't deal with the windows problems anymore. Obviously, I am not a Unix/Linux pro... Best regards, Michael C. Gates -Original Message- From: bert hubert [mailto:[EMAIL PROTECTED] Sent: Thursday, January 04, 2007 12:54 PM To: Michael C. Gates Cc: pdns-users@mailman.powerdns.com Subject: Re: [Pdns-users] Suse Linux and MS SQL On Thu, Jan 04, 2007 at 11:13:50AM -0500, Michael C. Gates wrote: Great, I will try it out. So Suse Linux will work fine for PDNS? The problem I am having is it is crashing every 15 minutes in windows. I wrote a routine to restart it every half hour, but it is getting out of hand now. It was I don't think SQL Server support under Unix/Linux is actually working out of the box. It did work in the past but we never released the code, and it has since become outdated. It looks like it would take a few days to revive the UNIX based SQL Server support, but we are very sure it will work great as we've done work with SQL server from linux before. Sadly, we don't get a lot of requests for SQL Server based PowerDNS, so it is not very high on our agenda. (btw, the windows version has an easier time as it accesses sqlserver through the generic ODBC backend, but the windows version has other problems). Bert -- http://www.PowerDNS.com Open source, database driven DNS Software http://netherlabs.nl Open and Closed source services ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
RE: [Pdns-users] Suse Linux and MS SQL
Well, it would depend on how much it costs, and also compared to sponsoring a windows version upgrade. Either one would work. Of course, Suse Linux is a lot cheaper, but I am more familiar with windows, and already have 20+ windows servers running... Let me know, I may be interested, Best regards, Michael C. Gates -Original Message- From: bert hubert [mailto:[EMAIL PROTECTED] Sent: Thursday, January 04, 2007 1:13 PM To: Michael C. Gates Subject: Re: [Pdns-users] Suse Linux and MS SQL On Thu, Jan 04, 2007 at 01:05:08PM -0500, Michael C. Gates wrote: I guess there is no type of ODBC driver for Suse Linux? That would be fine for me. I just can't deal with the windows problems anymore. Obviously, I am not a Unix/Linux pro... There is a commercial ODBC driver for Unix, but we don't really like it. It comes with agressive salespeople. What we could do is expedite the development of the SQL Server backend, if you would sponsor this development. Sponsorship allows us to dedicate a developer to implementing a desired feature, because we can in good concience use a developer that is doing billable work. For purely open source work we always have to justify this. We like to do public sponsorship, which means you get credited prominently in the release notes as the sponsor of SQL Server/Sybase support. In the past, Register.com has been a notable sponsor, they enabled us to add Oracle support. Let us know if this would work for you. We also offer free support to go with the sponsored feature for 6 months, so you can be sure it really works. Bert Best regards, Michael C. Gates -Original Message- From: bert hubert [mailto:[EMAIL PROTECTED] Sent: Thursday, January 04, 2007 12:54 PM To: Michael C. Gates Cc: pdns-users@mailman.powerdns.com Subject: Re: [Pdns-users] Suse Linux and MS SQL On Thu, Jan 04, 2007 at 11:13:50AM -0500, Michael C. Gates wrote: Great, I will try it out. So Suse Linux will work fine for PDNS? The problem I am having is it is crashing every 15 minutes in windows. I wrote a routine to restart it every half hour, but it is getting out of hand now. It was I don't think SQL Server support under Unix/Linux is actually working out of the box. It did work in the past but we never released the code, and it has since become outdated. It looks like it would take a few days to revive the UNIX based SQL Server support, but we are very sure it will work great as we've done work with SQL server from linux before. Sadly, we don't get a lot of requests for SQL Server based PowerDNS, so it is not very high on our agenda. (btw, the windows version has an easier time as it accesses sqlserver through the generic ODBC backend, but the windows version has other problems). Bert -- http://www.PowerDNS.com Open source, database driven DNS Software http://netherlabs.nl Open and Closed source services ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users !DSPAM:459d415b282181277382813! -- http://www.PowerDNS.com Open source, database driven DNS Software http://netherlabs.nl Open and Closed source services ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
RE: [Pdns-users] Suse Linux and MS SQL
Great, I will power up the server later this week... Oh shoot, it already is later! I guess I am behind... Well, I will set it up in the next couple of days, and see where I get. Thanks for all your help, Michael C. Gates -Original Message- From: Norbert Sendetzky [mailto:[EMAIL PROTECTED] Sent: Thursday, January 04, 2007 4:52 PM To: pdns-users@mailman.powerdns.com Cc: Michael C. Gates Subject: Re: [Pdns-users] Suse Linux and MS SQL Hi Michael I have Suse Linux on one box, and MS SQL on another. Is it possible (And how hard would it be) to install PDNS on the Suse box, and then use MS SQL as the backend? You can use the PDNS OpenDBX backend and FreeTDS to connect to your MS SQL server. This setup worked very well for another member of this list. The servers officially supported by the OpenDBX backend are: - MySQL - PostgreSQL - SQLite 2 and 3 - MS SQL Server Supported but not extensively tested yet: - Oracle 8i to 10g - Sybase ASE - Firebird 2 Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
RE: [Pdns-users] Re: How Do SPF records work in PDNS? ( begionner)
Make sure your server has a host name. And make sure it is set up correctly. If your DNS name is mail.gateshosting.com, make sure your server name is mail, and your suffix is gateshosting.com for a full name of mail.gateshosting.com. Also just make sure you HAVE a dns record for that ip, and a rDns record for that ip. Here is a tool I use to check my mail server: www.dnsreport.com - Just check your domain name, like gateshosting.com and it will actually let you know if you have any errors in DNS. Also, I see in one of the headers, the ip address is 127.0.0.1. You probably should have a public ip address. Otherwise some servers will deny your connection. Hope this helps, Michael C. Gates -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard Vernooij Sent: Sunday, November 19, 2006 3:33 AM To: pdns-users@mailman.powerdns.com Subject: Fw: [Pdns-users] Re: How Do SPF records work in PDNS? ( begionner) Ok. For me it is clear that my problem has to do with reverse DNS, and not with SPF. Can someone tell me how to setup right configuration for Reverse DNS for the example i gave? Here is also an emailheader from a mail that is bounced: Received: from dedicated ([127.0.0.1]) by dedicated.domain.com with Microsoft SMTPSVC(6.0.3790.1830); Sat, 18 Nov 2006 09:55:21 +0100 Date: Sat, 18 Nov 2006 09:55:21 +0100 Subject: Order 12564 From: Companyname [EMAIL PROTECTED] To: Kevin Chin [EMAIL PROTECTED] MIME-Version: 1.0 X-Mailer: osCommerce Mailer Content-Type: multipart/alternative; boundary==_0546849bb7db32079db89f7fa0271de5 Return-Path: [EMAIL PROTECTED] Message-ID: [EMAIL PROTECTED] X-OriginalArrivalTime: 18 Nov 2006 08:55:21.0578 (UTC) FILETIME=[4776D4A0:01C70AEF] The message i receive back: Reporting-MTA: dns;[EMAIL PROTECTED] Received-From-MTA: dns;dedicated Arrival-Date: Sat, 18 Nov 2006 09:55:21 +0100 Final-Recipient: rfc822;[EMAIL PROTECTED] Action: failed Status: 5.5.0 Diagnostic-Code: smtp;550 Spam refused: is a silly name for a mail server or server has no name. I also get many messages with other error codes: Action: failed Status: 5.4.0 ( most often message ) Action: failed Status: 4.4.7 I hope someone can tell me what to do with my DNS settings here, or if it is not my DNS, please tell me where to look. Thanks. Richard. - Forwarded Message From: Alex van den Bogaerdt [EMAIL PROTECTED] To: pdns-users@mailman.powerdns.com Sent: Saturday, November 18, 2006 10:40:37 PM Subject: Re: [Pdns-users] Re: How Do SPF records work in PDNS? ( begionner) On Sat, Nov 18, 2006 at 12:49:44PM -0700, Michael Loftis wrote: Now if you *have* an SPF record (which again is *NOT* a type of DNS record at all, it's a TXT record) Please be aware that there is an official SPF resource record. http://www.iana.org/assignments/dns-parameters But do publish TXT records for your SPF rules as well. The RR is brand new and isn't used that much yet. Eventually only the SPF resource record is going to be used. This will take time. Let's not discuss SPF here. If you want to know why it is the user's fault and not the SPF record's fault, let's meet on the spf-discuss mailing list. Alex ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users _ Everyone is raving about the http://us.rd.yahoo.com/evt=42297/*http://advision.webevents.yahoo.com/mailb eta all-new Yahoo! Mail beta. ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
RE: [Pdns-users] problem with slave domains odbc backend w2000
What would sponsor mean? I would be glad to depending on what is involved. I would actually love to have a C# version of this for windows users... But that is probably a huge task... Let me know... I didn't get the email about it. Best regards, Michael C. Gates GatesHosting.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of bert hubert Sent: Friday, November 03, 2006 3:18 AM To: Adam Bazylczyk Cc: pdns-users@mailman.powerdns.com Subject: Re: [Pdns-users] problem with slave domains odbc backend w2000 On Fri, Nov 03, 2006 at 06:17:44AM +0100, Adam Bazylczyk wrote: I am using odbc backedn on Windows with MS Access database file. Master domains working very good with AXFR but when I input any slave domain in domains table, everytime is error and pdns service stop. Can anybody help me, I can find any idea where is problem. My system is W2000. I have over 500 master domains and can't work with slave now :( The windows version of PowerDNS is very old and stale. We'd love to ship a new version, but it is a lot of work. We've asked a few windows users if they would consider sponsoring a new Windows release, but nobody was interested. So I'm afraid we can't really help you with this old version of PowerDNS.. Bert -- http://www.PowerDNS.com Open source, database driven DNS Software http://netherlabs.nl Open and Closed source services ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
RE: [Pdns-users] Debugging
Hi Bert, I get about 3 different types of crashes. There is no rhyme or reason to them. I watch the command prompt log to see if it crashes on the same type of action, and it doesn't. I was hoping setting up the service to restart after a failure would fix the problem, but it seems that the program is still running, just not answering. I have been trying to figure out why 1 server works fine, and 2 others don't. There is no rhyme or reason to them either. Is there an older build of the windows version that is more stable? I don't need bells and whistles, just simple A, CNAME, MX, SOA records, etc. And I don't need primary and slave servers because I simply use replication in my MS SQL DB so if I update one, they all get updated. Thanks for your help. Michael C. Gates -Original Message- From: bert hubert [mailto:[EMAIL PROTECTED] Sent: Saturday, August 26, 2006 4:53 AM To: Michael C. Gates Cc: pdns-users@mailman.powerdns.com Subject: Re: [Pdns-users] Debugging On Fri, Aug 25, 2006 at 07:08:43PM -0400, Michael C. Gates wrote: Any way to create a program log so I can figure out why mine is crashing every once in a while? If I download the source, can I open it in Visual Studio 2005? Or was it written in something else? I know C#, but not much of C++. I wouldn't mind figuring it out if it solved the crashing C++problem. The PowerDNS Recursor compiles in Visual Studio 2005, the authoritative server doesn't. The currently last released version of the PowerDNS Authoritative server is known to have many, many bugs. Can you let us know more about your specific problem? Thanks. -- http://www.PowerDNS.com Open source, database driven DNS Software http://netherlabs.nl Open and Closed source services ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
