MRatWork Forum by Mustafa Ramadhan
Sawo Project - Kloxo-MR Discussions => Kloxo-MR Bugs and Requests => Topic started by: Spacedust on 2017-08-26, 22:39:02
-
All my DNS servers are down despite logs say they are up...
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
-
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)
-
I've switched from pdns to nsd and all back to normal, but this should work like that...
-
Try 'sh /script/reset-mysql-root-password'.
-
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)
-
What's the cause of these errors?
-
Try 'sh /script/cleanup' (because pdns db password will be reset by this process).
-
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
-
Bug started post this update: https://github.com/mustafaramadhan/kloxo/commit/09e1d3c196f48a18a3c1463d60f8136cad967bf1
-
I think trim for '.' will fix dns issue.
-
It was working perfectly fine before. Now pdns is useless, connection to database works, but all entries doesn't have effect.
-
Update your Kloxo-MR 7.0.