error logs in syslog

classic Classic list List threaded Threaded
4 messages Options
Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

error logs in syslog

Roberto Quiñones

Hi.

First of all, hello to the second list and I apologize for that estuoy
using English, since I do not speak and write, I feel obliged to use a
translator.

Well the issue is as follows, I have two DNS server (DNS1 and DNS2) with:

Distributor ID: Ubuntu
Description: Ubuntu 14.04.3 LTS
Release: 14.04
Codename: trusty

Use as a daemon and DNS PowerDNS PowerAdmin to administraro from the
DNS1, DNS2 just got the devil.

When I check the logs in syslog DNS1 I find errors of the following type.

February 4 5:19:38 shu mysqld: 160204 5:19:38 [Warning] Aborted
connection 382 to db: 'PowerDNS' user 'powerdns_user' host 'localhost'
(Unknown error)
February 4 5:19:38 shu mysqld: 160204 5:19:38 [Warning] Aborted
connection 381 to db: 'PowerDNS' user 'powerdns_user' host 'localhost'
(Unknown error)
February 4 6:18:08 shu mysqld: 160204 6:18:08 [Warning] Aborted
connection 384 to db: 'PowerDNS' user 'powerdns_user' host 'localhost'
(Unknown error)
February 4 7:29:35 shu mysqld: 160204 7:29:35 [Warning] Aborted
connection 385 to db: 'PowerDNS' user 'powerdns_user' host 'localhost'
(Unknown error)
February 4 7:29:35 shu mysqld: 160204 7:29:35 [Warning] Aborted
connection 386 to db: 'PowerDNS' user 'powerdns_user' host 'localhost'
(Unknown error)
February 4 8:28:08 shu mysqld: 160204 8:28:08 [Warning] Aborted
connection 387 to db: 'PowerDNS' user 'powerdns_user' host 'localhost'
(Unknown error)
February 4 8:28:08 shu mysqld: 160204 8:28:08 [Warning] Aborted
connection 388 to db: 'PowerDNS' user 'powerdns_user' host 'localhost'
(Unknown error)
February 4 8:47:26 shu mysqld: 160204 8:47:26 [Warning] Aborted
connection 390 to db: 'PowerDNS' user 'powerdns_user' host 'localhost'
(Unknown error)
February 4 8:47:26 shu mysqld: 160204 8:47:26 [Warning] Aborted
connection 389 to db: 'PowerDNS' user 'powerdns_user' host 'localhost'
(Unknown error)
February 4 8:47:26 shu mysqld: 160204 8:47:26 [Warning] Aborted
connection 391 to db: 'PowerDNS' user 'powerdns_user' host 'localhost'
(Unknown error)

I hope these records would be enough to help or guidance to my questions
or problems.

Stay tuned to your comments.

RQ.
Regards.


_______________________________________________
Pdns-users mailing list
[hidden email]
http://mailman.powerdns.com/mailman/listinfo/pdns-users
Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: error logs in syslog

Pieter Lexis-2
Hi Roberto,

On Thu, 4 Feb 2016 12:45:00 -0300
Roberto Quiñones <[hidden email]> wrote:

> Well the issue is as follows, I have two DNS server (DNS1 and DNS2) with:
>
> Distributor ID: Ubuntu
> Description: Ubuntu 14.04.3 LTS
> Release: 14.04
> Codename: trusty

What version of PowerDNS, 3.4.1?

> Use as a daemon and DNS PowerDNS PowerAdmin to administraro from the
> DNS1, DNS2 just got the devil.

try to set `loglevel=7` in `/etc/powerdns/pdns.conf` and check what pdns_server reports to syslog about the mysql connection.

Best regards,

Pieter

--
Pieter Lexis
PowerDNS.COM BV -- https://www.powerdns.com
_______________________________________________
Pdns-users mailing list
[hidden email]
http://mailman.powerdns.com/mailman/listinfo/pdns-users
Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: error logs in syslog

Roberto Quiñones
El 04/02/2016 a las 14:17, Pieter Lexis escribió:

> Hi Roberto,
>
> On Thu, 4 Feb 2016 12:45:00 -0300
> Roberto Quiñones <[hidden email]> wrote:
>
>> Well the issue is as follows, I have two DNS server (DNS1 and DNS2) with:
>>
>> Distributor ID: Ubuntu
>> Description: Ubuntu 14.04.3 LTS
>> Release: 14.04
>> Codename: trusty
>
> What version of PowerDNS, 3.4.1?
>
>> Use as a daemon and DNS PowerDNS PowerAdmin to administraro from the
>> DNS1, DNS2 just got the devil.
>
> try to set `loglevel=7` in `/etc/powerdns/pdns.conf` and check what pdns_server reports to syslog about the mysql connection.
>
> Best regards,
>
> Pieter
>

Hi Pieter,

My version is 3.3 PowerDNS

Feb 04 12:39:48 PowerDNS Authoritative Server 3.3
([hidden email]) (C) 2001-2013 PowerDNS.COM BV

RQ.
Regards.
_______________________________________________
Pdns-users mailing list
[hidden email]
http://mailman.powerdns.com/mailman/listinfo/pdns-users
Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: error logs in syslog

Roberto Quiñones
In reply to this post by Pieter Lexis-2
Hi Pieter,


El 04/02/2016 a las 14:17, Pieter Lexis escribió:

> Hi Roberto,
>
> On Thu, 4 Feb 2016 12:45:00 -0300
> Roberto Quiñones <[hidden email]> wrote:
>
>> Well the issue is as follows, I have two DNS server (DNS1 and DNS2) with:
>>
>> Distributor ID: Ubuntu
>> Description: Ubuntu 14.04.3 LTS
>> Release: 14.04
>> Codename: trusty
>
> What version of PowerDNS, 3.4.1?

This would answer in a previous post, but I mention it again.

Feb 05 07:22:43 PowerDNS Authoritative Server 3.3
([hidden email]) (C) 2001-2013 PowerDNS.COM BV


>
>> Use as a daemon and DNS PowerDNS PowerAdmin to administraro from the
>> DNS1, DNS2 just got the devil.
>
> try to set `loglevel=7` in `/etc/powerdns/pdns.conf` and check what pdns_server reports to syslog about the mysql connection.

I modified the value of the log level and it is 7

>
> Best regards,
>
> Pieter
>

I watched the syslog with tail -f syslog and see that even logs errors

Feb  5 06:56:17 shu mysqld: 160205  6:56:17 [Warning] Aborted connection
430 to db: 'powerdns' user: 'powerdns_user' host: 'localhost' (Unknown
error)
Feb  5 06:56:17 shu mysqld: 160205  6:56:17 [Warning] Aborted connection
432 to db: 'powerdns' user: 'powerdns_user' host: 'localhost' (Unknown
error)
Feb  5 06:56:17 shu mysqld: 160205  6:56:17 [Warning] Aborted connection
433 to db: 'powerdns' user: 'powerdns_user' host: 'localhost' (Unknown
error)
Feb  5 06:56:17 shu mysqld: 160205  6:56:17 [Warning] Aborted connection
435 to db: 'powerdns' user: 'powerdns_user' host: 'localhost' (Unknown
error)
Feb  5 06:56:17 shu mysqld: 160205  6:56:17 [Warning] Aborted connection
437 to db: 'powerdns' user: 'powerdns_user' host: 'localhost' (Unknown
error)
Feb  5 06:56:17 shu mysqld: 160205  6:56:17 [Warning] Aborted connection
439 to db: 'powerdns' user: 'powerdns_user' host: 'localhost' (Unknown
error)
Feb  5 07:00:09 shu mysqld: 160205  7:00:09 [Warning] Aborted connection
434 to db: 'powerdns' user: 'powerdns_user' host: 'localhost' (Unknown
error)
Feb  5 07:00:09 shu mysqld: 160205  7:00:09 [Warning] Aborted connection
436 to db: 'powerdns' user: 'powerdns_user' host: 'localhost' (Unknown
error)
Feb  5 07:00:09 shu mysqld: 160205  7:00:09 [Warning] Aborted connection
438 to db: 'powerdns' user: 'powerdns_user' host: 'localhost' (Unknown
error)

RQ.
Regards.
_______________________________________________
Pdns-users mailing list
[hidden email]
http://mailman.powerdns.com/mailman/listinfo/pdns-users
Loading...