Re: [Pdns-users] Failed to execute mysql_query, perhaps connection died? Err=1: MySQL server has gone away

2006-08-26 Thread Derrik Pates
Andreas Sokov wrote: > I have also one problems with connection to MySQL server : > and this trouble affects on register domains, > What you think or may be you realy know what is my problems ? > how i can stablize this situation ? I strongly suggest you read the documentation (at http://doc.powe

[Pdns-users] Failed to execute mysql_query, perhaps connection died? Err=1: MySQL server has gone away

2006-08-26 Thread Andreas Sokov
Hi, Pdns-users. I have also one problems with connection to MySQL server : and this trouble affects on register domains, records in log : Aug 26 22:10:31 papa pdns[32483]: AXFR of domain 'info-hotels.spb.ru' initiated by 193.124.22.65 Aug 26 22:10:31 papa pdns[32483]: TCP nameserver had error,

[Pdns-users] very much MySQL QUERY ?

2006-08-26 Thread Andreas Sokov
Hi, Pdns-users. Tell me please & and explain what my problems ? i see in mysql.log many SELECTs - can i do not such load mysql server ? log following : 060826 22:10:33 155131 Query select content,ttl,prio,type,domain_id,name from records where name='65.22.124.193.combined.njabl.org'

Re: [Pdns-users] BIND Primary, PowerDNS Secondaries....

2006-08-26 Thread Derrik Pates
Augie Schwer wrote: > Putting a constraint in the records table just means the records for > that zone are removed when the entry in the domain table is removed, > but you still have the problem of removing that domain on the slave in > some automatic fashion right? I use the InnoDB tables, an ON

Re: [Pdns-users] BIND Primary, PowerDNS Secondaries....

2006-08-26 Thread Augie Schwer
On 8/11/06, Mark Watts <[EMAIL PROTECTED]> wrote: > Setting up a Supermaster seems to be a good way to do the initial > population of PowerDNS, but zones are not removed automatically; in > fact even setting expire to a low number and then removing the zone > from the Supermaster does not affect

RE: [Pdns-users] Debugging

2006-08-26 Thread Michael C. Gates
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 progra

[Pdns-users] Re: Suggestion....

2006-08-26 Thread Julian Mehnle
bert hubert wrote: > On Fri, Aug 25, 2006 at 07:33:54PM +, Julian Mehnle wrote: > > Let me guess, you are using MySQL? > > This is the PowerDNS mailing list, not the 'flame MySQL to death' list. I apologize if my statements came over as "MySQL death flames", but for the record I'd like to poi

Re: [Pdns-users] Suggestion....

2006-08-26 Thread bert hubert
On Fri, Aug 25, 2006 at 07:33:54PM +, Julian Mehnle wrote: > Let me guess, you are using MySQL? This is the PowerDNS mailing list, not the 'flame MySQL to death' list. PostgreSQL supports a native address type, and it uses 12 bytes per IP address, which is not a real savings. This is the reas

Re: [Pdns-users] Debugging

2006-08-26 Thread bert hubert
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+

Re: [Pdns-users] Re: Suggestion....

2006-08-26 Thread Sten Spans
On Fri, 25 Aug 2006, Operations wrote: Julian Mehnle wrote: Flaming people who give you advice isn't very polite. Neither does it help getting your problem solved. Powerdns supports custom queries in most backends, so it's entirely possible to create your own database schema with additional