[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
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
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
.On Thu, 2007-01-04 at 10:49 -0500, Michael C. Gates 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? I can think about one more option different from the one outlined by Bert: - powerdns driven by the ldap backend that connects to OpenLDAP - OpenLDAP that connects to the mssql server Connectivity between OpenLDAP MSSQL can be achieved by using www.unixodbc.org in conjunction with www.freetds.org See http://www.openldap.org/faq/data/cache/978.html for some more information on this. We have never used FreeTDS in connection with OpenLDAP but we are using it for a couple of other projects and are very happy with it. BTW, is there a real reason why the ODBC backend for PowerDNS is only available on windows platforms? Just my 2ยข on this issue :-) -- Udo Rader BestSolution.at EDV Systemhaus GmbH http://www.bestsolution.at signature.asc Description: This is a digitally signed message part ___ 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
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 pgpMaUTcUFhai.pgp Description: PGP signature ___ 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] Suse Linux and MS SQL
On Thursday 04 January 2007 23:06, Michael C. Gates wrote: 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. Currently, you have to compile OpenDBX for SuSE yourself because the version available with OpenSuSE is 1.0.3 and you need 1.1.x for MSSQL support. I will release the next stable version (1.2.0) in two weeks and maybe Darix (the maintainer of the OpenSuSE packages) will include the mssql backend by default so this issue would be gone. OpenDBX: http://linuxnetworks.de/opendbx/index.html PDNS OpenDBX Docs: http://wiki.linuxnetworks.de/index.php/PowerDNS_OpenDBX_Backend Have fun :-) Norbert -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 pgpymFyfsIH1G.pgp Description: PGP signature ___ 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
On Thu, Jan 04, 2007 at 05:06:42PM -0500, Michael C. Gates wrote: 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. This is also a fine option, I hadn't realised OpenDBX had FreeTDS support! Please let us know how things work out. -- 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] mx failure scenario
On 12/21/06, bert hubert [EMAIL PROTECTED] wrote: On Thu, Dec 21, 2006 at 10:00:30AM -0800, gnu not unix wrote: I have a problem with my parent zone (sf.ca.us), where they are running powerdns (they used to run bind), and this change seems to have resulted in my loss of email connectivity. Something definitely is odd: $ dig +norecurs -t mx wraith.sf.ca.us @B.AUTH-NS.SONIC.NET. ; DiG 9.3.2 +norecurs -t mx wraith.sf.ca.us @B.AUTH-NS.SONIC.NET. ; (1 server found) ;; global options: printcmd ;; Got answer: ;; -HEADER- opcode: QUERY, status: NOERROR, id: 42774 ;; flags: qr; QUERY: 1, ANSWER: 0, AUTHORITY: 3, ADDITIONAL: 2 ;; QUESTION SECTION: ;wraith.sf.ca.us. IN MX ;; AUTHORITY SECTION: sf.ca.us. 259200 IN SOA ns1.sonic.net. hostmaster.sonic.net. 2006122102 3600 300 1209600 3600 wraith.sf.ca.us.3600IN NS wraith.sf.ca.us. wraith.sf.ca.us.3600IN NS smidge.wraith.sf.ca.us. This SOA record should not be there. I have no easy explanation why it is there. Here is where the spurious SOA gets inserted: http://wiki.powerdns.com/cgi-bin/trac.fcgi/attachment/ticket/117/pdns-packethandler.cc.patch The above patch removes the addition of the spurious SOA in to the reply packet, but I'm having a hard time understanding why the code bit was needed in the first place, so no guarantees that it won't break something else. Index: packethandler.cc === --- packethandler.cc(revision 941) +++ packethandler.cc(working copy) @@ -404,8 +404,6 @@ r-addRecord(rr); } } -if(hits !found !rfound shortcut ) // we found matching qnames but not a qtype - return 2; if(rfound) return 1; // ANY lookup found the right answer immediately @@ -640,20 +638,6 @@ } mret=makeCanonic(p, r, target); // traverse CNAME chain until we have a useful record (may actually give the correct answer!) -if(mret==2) { // there is some data, but not of the correct type - DLOG(LThere is some data, but not of the correct typeendl); - SOAData sd; - if(getAuth(p, sd, target, 0)) { - rr.qname=sd.qname; - rr.qtype=QType::SOA; - rr.content=DNSPacket::serializeSOAData(sd); - rr.ttl=sd.ttl; - rr.domain_id=sd.domain_id; - rr.d_place=DNSResourceRecord::AUTHORITY; - r-addRecord(rr); - } -} - if(mret == 1) goto sendit; // this might be the end of it (client requested a CNAME, or we found the answer already) -- Augie Schwer-[EMAIL PROTECTED]-http://schwer.us Key fingerprint = 9815 AE19 AFD1 1FE7 5DEE 2AC3 CB99 2784 27B0 C072 ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users