Re: [Pdns-users] MySQL table columns
On 12.08.2010 08:27 CE(S)T, bert hubert wrote: > There is a description the other way around, > http://doc.powerdns.com/types.html > > This describes for each record type what fields are used. > > Right now, all fields in the records table are expected to be there. Ah, there it is. Thanks for the hint. What are the fields domains.account and records.change_date used for? What am I supposed to put in there? Which of the fields will be read and which will be written by the pdns server? -- Yves Goergen "LonelyPixel" Visit my web laboratory at http://beta.unclassified.de ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] MySQL backend and notify
On 12.08.2010 08:28 CE(S)T, bert hubert wrote: > If configured with 'master' in the configuration, it will periodically > retrieve a list of all SOA serial numbers, and determine which ones changed. Does anybody know what time interval this is? Seconds, minutes, hours? -- Yves Goergen "LonelyPixel" Visit my web laboratory at http://beta.unclassified.de ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] MySQL backend and notify
On Wed, Aug 11, 2010 at 10:35:43PM +0200, Yves Goergen wrote: > I'm currently setting up my first PowerDNS server. It shall act as > master for another DNS server. I'm going to use the gmysql backend. How > will the pdns server know when I have changed the records in the > database to send out notifications to the slaves? Will that work on a > regular basis or will I have to start a separate process to tell > pdns-server to rescan the database? If configured with 'master' in the configuration, it will periodically retrieve a list of all SOA serial numbers, and determine which ones changed. So you don't have to do anything, except raise the serial number. Bert ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] MySQL table columns
On Wed, Aug 11, 2010 at 10:39:01PM +0200, Yves Goergen wrote: > Second question: Is there an overview available that describes what each > of the database table columns is good for? There's example data but it > doesn't use all columns. Some columns are used for internal purposes > I've read, but I haven't found a comprehensive list of all supported > columns and what PowerDNS expects to read from them. Especially for > diverse record types. There's the one with half a dozen of numbers and I > don't know what to put where and what they all mean. If possible, I'd > like to create a database view to give those ugly numbers a name and to > have a table that only contains the data I want to maintain. There is a description the other way around, http://doc.powerdns.com/types.html This describes for each record type what fields are used. Right now, all fields in the records table are expected to be there. So there is not a lot of room for removing things. Bert ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] MySQL table columns
* Yves Goergen [100811 22:39]: > Hello, > > Second question: Is there an overview available that describes what each > of the database table columns is good for? There's example data but it > doesn't use all columns. Some columns are used for internal purposes > I've read, but I haven't found a comprehensive list of all supported > columns and what PowerDNS expects to read from them. Especially for > diverse record types. There's the one with half a dozen of numbers and I > don't know what to put where and what they all mean. If possible, I'd > like to create a database view to give those ugly numbers a name and to > have a table that only contains the data I want to maintain. Did you read this already? http://doc.powerdns.com/types.html -- christian hofstaedtler ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] MySQL backend and notify
Hi, Yves Goergen schreef: > On 12.08.2010 00:11 CE(S)T, LikeFiction wrote: > >> If PowerDNS finds that a SOA record >> contains a higher value than this "notified_serial", it knows it has to >> send out an update to the slaves. >> > > Yes, but the question is how does it find that? The database won't tell > its connected clients (here the pdns-server) that some data has changed. > Will pdsn query the database every few seconds or will I have to tell > pdns with a special command that the serial (and thus the data) of a > zone has changed? > > The slaves check on a regular interval whether the master has an updated serial in the SOA. If a higher serial exists this is detected and the zone is transferred to the slave. Regards, Ton ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] MySQL backend and notify
On 12.08.2010 00:11 CE(S)T, LikeFiction wrote: > If PowerDNS finds that a SOA record > contains a higher value than this "notified_serial", it knows it has to > send out an update to the slaves. Yes, but the question is how does it find that? The database won't tell its connected clients (here the pdns-server) that some data has changed. Will pdsn query the database every few seconds or will I have to tell pdns with a special command that the serial (and thus the data) of a zone has changed? -- Yves Goergen "LonelyPixel" Visit my web laboratory at http://beta.unclassified.de ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] MySQL backend and notify
I'm not an enourmous expert, but I will try to put in some of my basic knowledge in this list. About the database: PowerDNS will cache some records, but for the rest it should pull the record directly from the database when you request one. You can of course, simply test this yourself. About the slave-updating: After updating a record in a domain, the first number of the SOA record of this domain should be increased (always). PowerDNS stored the last value (before you updated the SOA) in the domains/notified_serial column. If PowerDNS finds that a SOA record contains a higher value than this "notified_serial", it knows it has to send out an update to the slaves. Also, the slave has a "last_check" column. I think some kind of mechanism also exists, which makes the slave check for updates in case it missed one. With kind regards / Met vriendelijke groet, Pierre van den Oord LikeFiction Kleyn Proffijtlaan 49 2343 DB Oegstgeest The Netherlands T +31 (0)85 7850699 (Mo-Fr 10-17, GMT +1) T +31 (0)6 12469791 (Mobile) M i...@likefiction.com W www.LikeFiction.com --- Please include the original message when you reply! --- Op 11-8-2010 22:35, Yves Goergen schreef: Hello, I'm currently setting up my first PowerDNS server. It shall act as master for another DNS server. I'm going to use the gmysql backend. How will the pdns server know when I have changed the records in the database to send out notifications to the slaves? Will that work on a regular basis or will I have to start a separate process to tell pdns-server to rescan the database? ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
[Pdns-users] MySQL table columns
Hello, Second question: Is there an overview available that describes what each of the database table columns is good for? There's example data but it doesn't use all columns. Some columns are used for internal purposes I've read, but I haven't found a comprehensive list of all supported columns and what PowerDNS expects to read from them. Especially for diverse record types. There's the one with half a dozen of numbers and I don't know what to put where and what they all mean. If possible, I'd like to create a database view to give those ugly numbers a name and to have a table that only contains the data I want to maintain. -- Yves Goergen "LonelyPixel" Visit my web laboratory at http://beta.unclassified.de ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
[Pdns-users] MySQL backend and notify
Hello, I'm currently setting up my first PowerDNS server. It shall act as master for another DNS server. I'm going to use the gmysql backend. How will the pdns server know when I have changed the records in the database to send out notifications to the slaves? Will that work on a regular basis or will I have to start a separate process to tell pdns-server to rescan the database? -- Yves Goergen "LonelyPixel" Visit my web laboratory at http://beta.unclassified.de ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] crashes in bind backend on rediscover
On Wed, Aug 11, 2010 at 02:24:04PM +0100, Richard Poole wrote: > We're seeing crashes in powerdns 2.9.22 when calling "pdns_control > rediscover". We have a cron job that does this, currently twice an hour, > and on average about once a day it results in a crash, looking like this > in /var/log/messages: This is a known issue, but it is usually very rare to hit it. > We have about 64 domains in total, with typically up to about 50 That is pretty good! This probably explains why you do see the problem. > problems an average of twice a day with a non-negligible chance of losing > both nameservers simultaneously and my boss is going to tell me to go This is not good. We'll take a look to see if something can be done that at least works around the problem. I'll keep you posted. Bert ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
[Pdns-users] crashes in bind backend on rediscover
We're seeing crashes in powerdns 2.9.22 when calling "pdns_control rediscover". We have a cron job that does this, currently twice an hour, and on average about once a day it results in a crash, looking like this in /var/log/messages: Aug 11 12:10:42 ns1 pdns[1980]: Got a signal 6, attempting to print trace: Aug 11 12:10:42 ns1 pdns[1980]: /usr/sbin//pdns_server-instance [0x80cb5e4] Aug 11 12:10:42 ns1 pdns[1980]: [0x110420] Aug 11 12:10:42 ns1 pdns[1980]: [0x110410] Aug 11 12:10:42 ns1 pdns[1980]: /lib/libc.so.6(gsignal+0x50) [0x179df0] Aug 11 12:10:42 ns1 pdns[1980]: /lib/libc.so.6(abort+0x101) [0x17b701] Aug 11 12:10:42 ns1 pdns[1980]: /lib/libc.so.6(__assert_fail+0xfb) [0x17326b] Aug 11 12:10:42 ns1 pdns[1980]: /usr/sbin//pdns_server-instance(_ZN12Bind2Backend6insertEN5boost10shared_ptrINS_5StateEEEiRKSsRK5QTypeS5_ii+0x847) [0x81151d7] Aug 11 12:10:42 ns1 pdns[1980]: /usr/sbin//pdns_server-instance(_ZN12Bind2Backend10loadConfigEPSs+0x8c6) [0x8119e06] Aug 11 12:10:42 ns1 pdns[1980]: /usr/sbin//pdns_server-instance(_ZN12UeberBackend10rediscoverEPSs+0x38) [0x80d77f8] Aug 11 12:10:42 ns1 pdns[1980]: /usr/sbin//pdns_server-instance(_Z19DLRediscoverHandlerRKSt6vectorISsSaISsEEi+0xcd) [0x80e31bd] Aug 11 12:10:42 ns1 pdns[1980]: /usr/sbin//pdns_server-instance(_ZN11DynListener11theListenerEv+0x5c0) [0x80dded0] Aug 11 12:10:42 ns1 pdns[1980]: /usr/sbin//pdns_server-instance(_ZN11DynListener17theListenerHelperEPv+0x11) [0x80decb1] Aug 11 12:10:42 ns1 pdns[1980]: /lib/libpthread.so.0 [0x7a373b] Aug 11 12:10:42 ns1 pdns[1980]: /lib/libc.so.6(clone+0x5e) [0x222cfe] We have about 64 domains in total, with typically up to about 50 new ones each time the cron job runs. They are all slave zones (from a non-public master). We're typically getting about 700 queries per second at peak times. The crashes are sometimes at busy times, sometimes not, with no apparent correlation to anything else that I know of (although of course the sample size is not huge). We've compiled with --with-modules="" because we don't run any backends other than bind; the box is stock Red Hat Enterprise 5.3 with boost 1.33.1, as shipped by Red Hat. These crashes have been seen on two different boxes with the same setup, so I don't think it can be a hardware fault; we first saw them running the pdns-static rpm as downloaded from powerdns.com and there's been no change now we're running our own build (except the stack trace is more informative because it now has symbols in it). Does anyone have any suggestions? What should I do next to diagnose the problem? Is this something anyone else has seen? We are getting it on both of our publicly visible nameservers so we're having customer-visible problems an average of twice a day with a non-negligible chance of losing both nameservers simultaneously and my boss is going to tell me to go back to running bind sooner or later. :( Thanks, Richard -- Richard Poole System Administrator Heart Internet Ltd richard.po...@heartinternet.co.uk http://www.heartinternet.co.uk/ Tel: 0845 644 7750 Fax: 0845 644 7740 ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are not authorised to and must not disclose, copy, distribute, or retain this message or any part of it. Heart Internet Ltd accepts no responsibility for information, errors or omissions in this email. ** ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users