Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:
Click Here
Please login or register. 2018-05-21, 22:45:45

Author Topic: pdns/MariaDB stopped working after last update  (Read 2628 times)

0 Members and 1 Guest are viewing this topic.

Offline Spacedust

  • Super Grand Master
  • ****
  • Posts: 3,962
  • Karma: +1/-0
    • View Profile
pdns/MariaDB stopped working after last update
« on: 2017-08-26, 22:39:02 »
All my DNS servers are down despite logs say they are up...

Quote
Aug 26 22:47:26 online2 pdns[11063]: Listening on controlsocket in '/var/run/pdns.controlsocket'
Aug 26 22:47:26 online2 pdns[11066]: Guardian is launching an instance
Aug 26 22:47:26 online2 pdns[11066]: Reading random entropy from '/dev/urandom'
Aug 26 22:47:26 online2 pdns[11066]: Loading '/usr/lib64/pdns/libgmysqlbackend.so'
Aug 26 22:47:26 online2 pdns[11066]: This is a guarded instance of pdns
Aug 26 22:47:26 online2 pdns[11066]: UDP server bound to 0.0.0.0:53
Aug 26 22:47:26 online2 pdns[11066]: UDPv6 server bound to [::]:53
Aug 26 22:47:26 online2 pdns[11066]: TCP server bound to 0.0.0.0:53
Aug 26 22:47:26 online2 pdns[11066]: TCPv6 server bound to [::]:53
Aug 26 22:47:26 online2 pdns[11066]: PowerDNS Authoritative Server 4.0.3 (C) 2001-2016 PowerDNS.COM BV
Aug 26 22:47:26 online2 pdns[11066]: Using 64-bits mode. Built using gcc 4.8.2 20140120 (Red Hat 4.8.2-15) on Jan 17 2017 09:32:28 by mockbuild@jenkins.monshouwer.eu.
Aug 26 22:47:26 online2 pdns[11066]: PowerDNS comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to redistribute it according to the terms of the GPL version 2.
Aug 26 22:47:26 online2 pdns[11066]: DNS Proxy launched, local port 19901, remote 127.0.0.1:54
Aug 26 22:47:26 online2 pdns[11066]: Master/slave communicator launching
Aug 26 22:47:26 online2 pdns[11066]: Creating backend connection for TCP
Aug 26 22:47:26 online2 pdns[11066]: No new unfresh slave domains, 0 queued for AXFR already, 0 in progress
Aug 26 22:47:26 online2 pdns[11066]: About to create 3 backend threads for UDP
Aug 26 22:47:27 online2 pdns[11066]: No master domains need notifications
Aug 26 22:47:27 online2 pdns[11066]: Done launching threads, ready to distribute questions
Aug 26 22:48:05 online2 pdns[11063]: Scheduling exit on remote request
Aug 26 22:48:05 online2 pdns[11063]: Guardian is killed, taking down children with us
Aug 26 22:48:08 online2 pdns[11644]: Listening on controlsocket in '/var/run/pdns.controlsocket'
Aug 26 22:48:08 online2 pdns[11647]: Guardian is launching an instance
Aug 26 22:48:08 online2 pdns[11647]: Reading random entropy from '/dev/urandom'
Aug 26 22:48:08 online2 pdns[11647]: Loading '/usr/lib64/pdns/libgmysqlbackend.so'
Aug 26 22:48:08 online2 pdns[11647]: This is a guarded instance of pdns
Aug 26 22:48:08 online2 pdns[11647]: UDP server bound to 0.0.0.0:53
Aug 26 22:48:08 online2 pdns[11647]: UDPv6 server bound to [::]:53
Aug 26 22:48:08 online2 pdns[11647]: TCP server bound to 0.0.0.0:53
Aug 26 22:48:08 online2 pdns[11647]: TCPv6 server bound to [::]:53
Aug 26 22:48:08 online2 pdns[11647]: PowerDNS Authoritative Server 4.0.3 (C) 2001-2016 PowerDNS.COM BV
Aug 26 22:48:08 online2 pdns[11647]: Using 64-bits mode. Built using gcc 4.8.2 20140120 (Red Hat 4.8.2-15) on Jan 17 2017 09:32:28 by mockbuild@jenkins.monshouwer.eu.
Aug 26 22:48:08 online2 pdns[11647]: PowerDNS comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to redistribute it according to the terms of the GPL version 2.
Aug 26 22:48:08 online2 pdns[11647]: DNS Proxy launched, local port 31310, remote 127.0.0.1:54
Aug 26 22:48:08 online2 pdns[11647]: Creating backend connection for TCP
Aug 26 22:48:08 online2 pdns[11647]: Master/slave communicator launching
Aug 26 22:48:09 online2 pdns[11647]: About to create 3 backend threads for UDP
Aug 26 22:48:09 online2 pdns[11647]: No new unfresh slave domains, 0 queued for AXFR already, 0 in progress
Aug 26 22:48:09 online2 pdns[11647]: No master domains need notifications
Aug 26 22:48:09 online2 pdns[11647]: Done launching threads, ready to distribute questions
Aug 26 22:48:24 online2 kernel: ip_tables: (C) 2000-2006 Netfilter Core Team
« Last Edit: 2017-08-26, 23:10:04 by Spacedust »

Offline Spacedust

  • Super Grand Master
  • ****
  • Posts: 3,962
  • Karma: +1/-0
    • View Profile
Re: pdns stopped working after last update
« Reply #1 on: 2017-08-26, 22:52:04 »
MySQL shows:

2017-08-26 23:02:05 139999802402784 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-08-26 23:02:05 139999802402784 [Note] Plugin 'FEEDBACK' is disabled.
2017-08-26 23:02:05 139999802402784 [Note] Server socket created on IP: '::'.
2017-08-26 23:02:05 139999801034496 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1286: Unknown storage engine 'InnoDB'
2017-08-26 23:02:05 139999802402784 [Note] Reading of all Master_info entries succeded
2017-08-26 23:02:05 139999802402784 [Note] Added new Master_info '' to hash table
2017-08-26 23:02:05 139999802402784 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.2.8-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
2017-08-26 23:02:06 139999360521984 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2017-08-26 23:02:06 139999359915776 [Warning] Aborted connection 6 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (Got an error reading communication packets)
2017-08-26 23:02:12 139999361431296 [Warning] Aborted connection 3 to db: 'powerdns' user: 'powerdns' host: 'localhost' (Got an error reading communication packets)
2017-08-26 23:02:12 139999360825088 [Warning] Aborted connection 4 to db: 'powerdns' user: 'powerdns' host: 'localhost' (Got an error reading communication packets)

Offline Spacedust

  • Super Grand Master
  • ****
  • Posts: 3,962
  • Karma: +1/-0
    • View Profile
Re: pdns/MariaDB stopped working after last update
« Reply #2 on: 2017-08-26, 23:34:10 »
I've switched from pdns to nsd and all back to normal, but this should work like that...

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,382
  • Karma: +115/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: pdns/MariaDB stopped working after last update
« Reply #3 on: 2017-08-27, 00:48:55 »
Try 'sh /script/reset-mysql-root-password'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline Spacedust

  • Super Grand Master
  • ****
  • Posts: 3,962
  • Karma: +1/-0
    • View Profile
Re: pdns/MariaDB stopped working after last update
« Reply #4 on: 2017-08-28, 01:49:08 »
Try 'sh /script/reset-mysql-root-password'.

sh /script/reset-mysql-root-password <somepassword>
Stop MySQL service...
MySQL ROOT password reset...
Start MySQL service...

2017-08-28  2:00:54 140630251484928 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2017-08-28  2:01:05 140630250878720 [Warning] Aborted connection 17 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (Got an error reading communication packets)
« Last Edit: 2017-08-28, 01:51:04 by Spacedust »

Offline Spacedust

  • Super Grand Master
  • ****
  • Posts: 3,962
  • Karma: +1/-0
    • View Profile
Re: pdns/MariaDB stopped working after last update
« Reply #5 on: 2017-08-28, 20:28:44 »
What's the cause of these errors?

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,382
  • Karma: +115/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: pdns/MariaDB stopped working after last update
« Reply #6 on: 2017-08-29, 09:46:03 »
Try 'sh /script/cleanup' (because pdns db password will be reset by this process).
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline Spacedust

  • Super Grand Master
  • ****
  • Posts: 3,962
  • Karma: +1/-0
    • View Profile
Re: pdns/MariaDB stopped working after last update
« Reply #7 on: 2017-09-01, 23:41:25 »
Dns seems to be connected to the database but it's not working despite /script/cleanup:

Sep  1 23:48:54 online2 pdns[4251]: PowerDNS comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to redistribute it according to the terms of the GPL version 2.
Sep  1 23:48:54 online2 pdns[4251]: DNS Proxy launched, local port 17365, remote 127.0.0.1:54
Sep  1 23:48:54 online2 pdns[4251]: Master/slave communicator launching
Sep  1 23:48:54 online2 pdns[4251]: Creating backend connection for TCP
Sep  1 23:48:54 online2 pdns[4251]: No new unfresh slave domains, 0 queued for AXFR already, 0 in progress
Sep  1 23:48:54 online2 pdns[4251]: About to create 3 backend threads for UDP
Sep  1 23:48:54 online2 pdns[4251]: No master domains need notifications
Sep  1 23:48:54 online2 pdns[4251]: Done launching threads, ready to distribute questions
Sep  1 23:49:05 online2 pdns[4249]: Scheduling exit on remote request
Sep  1 23:49:05 online2 pdns[4249]: Guardian is killed, taking down children with us
Sep  1 23:49:08 online2 pdns[4717]: Listening on controlsocket in '/var/run/pdns.controlsocket'
Sep  1 23:49:08 online2 pdns[4720]: Guardian is launching an instance
Sep  1 23:49:08 online2 pdns[4720]: Reading random entropy from '/dev/urandom'
Sep  1 23:49:08 online2 pdns[4720]: Loading '/usr/lib64/pdns/libgmysqlbackend.so'
Sep  1 23:49:08 online2 pdns[4720]: This is a guarded instance of pdns
Sep  1 23:49:08 online2 pdns[4720]: UDP server bound to 0.0.0.0:53
Sep  1 23:49:08 online2 pdns[4720]: UDPv6 server bound to [::]:53
Sep  1 23:49:08 online2 pdns[4720]: TCP server bound to 0.0.0.0:53
Sep  1 23:49:08 online2 pdns[4720]: TCPv6 server bound to [::]:53
Sep  1 23:49:08 online2 pdns[4720]: PowerDNS Authoritative Server 4.0.3 (C) 2001-2016 PowerDNS.COM BV
Sep  1 23:49:08 online2 pdns[4720]: Using 64-bits mode. Built using gcc 4.8.2 20140120 (Red Hat 4.8.2-15) on Jan 17 2017 09:32:28 by mockbuild@jenkins.monshouwer.eu.
Sep  1 23:49:08 online2 pdns[4720]: PowerDNS comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to redistribute it according to the terms of the GPL version 2.
Sep  1 23:49:08 online2 pdns[4720]: DNS Proxy launched, local port 17877, remote 127.0.0.1:54
Sep  1 23:49:08 online2 pdns[4720]: Creating backend connection for TCP
Sep  1 23:49:08 online2 pdns[4720]: Master/slave communicator launching
Sep  1 23:49:08 online2 pdns[4720]: About to create 3 backend threads for UDP
Sep  1 23:49:08 online2 pdns[4720]: No new unfresh slave domains, 0 queued for AXFR already, 0 in progress
Sep  1 23:49:08 online2 pdns[4720]: No master domains need notifications
Sep  1 23:49:08 online2 pdns[4720]: Done launching threads, ready to distribute questions

Offline Spacedust

  • Super Grand Master
  • ****
  • Posts: 3,962
  • Karma: +1/-0
    • View Profile

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,382
  • Karma: +115/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: pdns/MariaDB stopped working after last update
« Reply #9 on: 2017-09-02, 02:09:52 »
I think trim for '.' will fix dns issue.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline Spacedust

  • Super Grand Master
  • ****
  • Posts: 3,962
  • Karma: +1/-0
    • View Profile
Re: pdns/MariaDB stopped working after last update
« Reply #10 on: 2017-09-09, 22:07:38 »
It was working perfectly fine before. Now pdns is useless, connection to database works, but all entries doesn't have effect.

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,382
  • Karma: +115/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: pdns/MariaDB stopped working after last update
« Reply #11 on: 2017-09-10, 06:17:27 »
Update your Kloxo-MR 7.0.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

 


MRatWork Affiliates:    BIGRAF(R) Inc.    House of LMAR    EFARgrafix

Page created in 0.037 seconds with 18 queries.

web stats analysis