Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - htsanders

Pages: [1]
1
MySQL / Re: error establishing database connection
« on: October 09, 2018, 09:43:03 AM »
thank you for the reply.

I guess its a wordpress table issue causing the problems.
I shut down the websites plugins and everything looks fine.

how to prevent one website from taking down the server?

 

2
MySQL / Re: error establishing database connection
« on: October 08, 2018, 06:19:21 PM »
system acting weird again.
very much io activity and high memory usage.

systemctl status mariadb.service -l
● mariadb.service - MariaDB 10.1.36 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: active (running) since ma 2018-10-08 19:15:43 CEST; 1h 1min ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 30600 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 30533 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
  Process: 30529 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 30548 (mysqld)
   Status: "InnoDB: Error: Database page corruption on disk or a failed file read of tablespace bcoin_wp/wp_posts page  [page id: space=10422, page number=42776]. You may have to recover from a backup."
   CGroup: /system.slice/mariadb.service
           └─30548 /usr/sbin/mysqld

okt 08 20:09:41 srv1.bcoin.nl mysqld[30548]: 2018-10-08 20:09:41 140492795878144 [ERROR] Got error 180 when reading table './bcoin_wp/wp_posts'
okt 08 20:11:01 srv1.bcoin.nl mysqld[30548]: 2018-10-08 20:11:01 140492392348416 [ERROR] Got error 180 when reading table './bcoin_wp/wp_posts'
okt 08 20:11:02 srv1.bcoin.nl mysqld[30548]: 2018-10-08 20:11:02 140492392348416 [ERROR] Got error 180 when reading table './bcoin_wp/wp_posts'
okt 08 20:11:02 srv1.bcoin.nl mysqld[30548]: 2018-10-08 20:11:02 140492392348416 [ERROR] Got error 180 when reading table './bcoin_wp/wp_posts'
okt 08 20:11:02 srv1.bcoin.nl mysqld[30548]: 2018-10-08 20:11:02 140492392348416 [ERROR] Got error 180 when reading table './bcoin_wp/wp_posts'
okt 08 20:12:13 srv1.bcoin.nl mysqld[30548]: 2018-10-08 20:12:13 140492392348416 [ERROR] Got error 180 when reading table './bcoin_wp/wp_posts'
okt 08 20:12:13 srv1.bcoin.nl mysqld[30548]: 2018-10-08 20:12:13 140492392348416 [ERROR] Got error 180 when reading table './bcoin_wp/wp_posts'
okt 08 20:12:14 srv1.bcoin.nl mysqld[30548]: 2018-10-08 20:12:14 140492392348416 [ERROR] Got error 180 when reading table './bcoin_wp/wp_posts'
okt 08 20:12:14 srv1.bcoin.nl mysqld[30548]: 2018-10-08 20:12:14 140492392348416 [ERROR] Got error 180 when reading table './bcoin_wp/wp_posts'
okt 08 20:12:14 srv1.bcoin.nl mysqld[30548]: 2018-10-08 20:12:14 140492392348416 [ERROR] Got error 180 when reading table './bcoin_wp/wp_posts'

3
MySQL / Re: error establishing database connection
« on: October 08, 2018, 12:17:05 PM »
thank you for the reply.  :D

I have to restart the server after a short time again because it loses mysql connection.

4
MySQL / Re: error establishing database connection
« on: October 08, 2018, 11:21:01 AM »
after reboot:

● mariadb.service - MariaDB 10.1.36 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: active (running) since ma 2018-10-08 13:19:01 CEST; 1min 16s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 1634 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 942 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
  Process: 931 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 1068 (mysqld)
   Status: "Taking your SQL requests now..."
   CGroup: /system.slice/mariadb.service
           └─1068 /usr/sbin/mysqld

okt 08 13:18:48 srv1.bcoin.nl mysqld[1068]: 2018-10-08 13:18:48 140254624643328 [Note] InnoDB: Highest supported file format is Barracuda.
okt 08 13:18:57 srv1.bcoin.nl mysqld[1068]: 2018-10-08 13:18:57 140254624643328 [Note] InnoDB: 128 rollback segment(s) are active.
okt 08 13:18:57 srv1.bcoin.nl mysqld[1068]: 2018-10-08 13:18:57 140254624643328 [Note] InnoDB: Waiting for purge to start
okt 08 13:18:57 srv1.bcoin.nl mysqld[1068]: 2018-10-08 13:18:57 140254624643328 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 53883522243                                                                                                                           
okt 08 13:18:58 srv1.bcoin.nl mysqld[1068]: 2018-10-08 13:18:58 140254624643328 [Note] Plugin 'FEEDBACK' is disabled.                                       
okt 08 13:18:58 srv1.bcoin.nl mysqld[1068]: 2018-10-08 13:18:58 140253843154688 [Note] InnoDB: Dumping buffer pool(s) not yet started                       
okt 08 13:18:58 srv1.bcoin.nl mysqld[1068]: 2018-10-08 13:18:58 140254624643328 [Note] Server socket created on IP: '::'.                                   
okt 08 13:19:01 srv1.bcoin.nl mysqld[1068]: 2018-10-08 13:19:01 140254624643328 [Note] /usr/sbin/mysqld: ready for connections.                             
okt 08 13:19:01 srv1.bcoin.nl mysqld[1068]: Version: '10.1.36-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server                     
okt 08 13:19:01 srv1.bcoin.nl systemd[1]: Started MariaDB 10.1.36 database server.                     

5
MySQL / Re: error establishing database connection
« on: October 08, 2018, 10:19:35 AM »
here you have it.

● mariadb.service - MariaDB 10.1.36 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: active (running) since ma 2018-10-08 03:05:17 CEST; 9h ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 11940 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 11874 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
  Process: 11868 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 11889 (mysqld)
   Status: "InnoDB: Error: Could not find a valid tablespace file for 'oudersb_blog/blogfak_wfVulnScanners'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue."
   CGroup: /system.slice/mariadb.service
           └─11889 /usr/sbin/mysqld

okt 08 04:08:11 srv1.bcoin.nl mysqld[11889]: 2018-10-08  4:08:11 139755295288064 [ERROR] Got error 180 when reading table './bcoin_wp/wp_posts'
okt 08 04:08:11 srv1.bcoin.nl mysqld[11889]: 2018-10-08  4:08:11 139755295288064 [ERROR] Got error 180 when reading table './bcoin_wp/wp_posts'
okt 08 04:08:11 srv1.bcoin.nl mysqld[11889]: 2018-10-08  4:08:11 139755295288064 [ERROR] Got error 180 when reading table './bcoin_wp/wp_posts'
okt 08 04:09:37 srv1.bcoin.nl mysqld[11889]: 2018-10-08  4:09:37 139755295288064 [ERROR] Got error 180 when reading table './bcoin_wp/wp_posts'
okt 08 04:09:37 srv1.bcoin.nl mysqld[11889]: 2018-10-08  4:09:37 139755295288064 [ERROR] Got error 180 when reading table './bcoin_wp/wp_posts'
okt 08 04:09:37 srv1.bcoin.nl mysqld[11889]: 2018-10-08  4:09:37 139755295288064 [ERROR] Got error 180 when reading table './bcoin_wp/wp_posts'
okt 08 04:09:37 srv1.bcoin.nl mysqld[11889]: 2018-10-08  4:09:37 139755295288064 [ERROR] Got error 180 when reading table './bcoin_wp/wp_posts'             
okt 08 04:10:59 srv1.bcoin.nl mysqld[11889]: 2018-10-08  4:10:59 139755397507840 [ERROR] Got error 180 when reading table './bcoin_wp/wp_posts'             
okt 08 04:10:59 srv1.bcoin.nl mysqld[11889]: 2018-10-08  4:10:59 139755397507840 [ERROR] Got error 180 when reading table './bcoin_wp/wp_posts'             
okt 08 04:10:59 srv1.bcoin.nl mysqld[11889]: 2018-10-08  4:10:59 139755397507840 [ERROR] Got error 180 when reading table './bcoin_wp/wp_posts'             
[root@srv1 ~]# Connection to 192.168.2.10 closed by remote host.                                                                                           
Connection to 192.168.2.10 closed.

6
MySQL / Re: error establishing database connection
« on: October 05, 2018, 12:20:39 PM »
thank you for the reply,
Which log files do you need?
Do you have filenames?

7
MySQL / error establishing database connection
« on: October 04, 2018, 06:05:51 AM »
Every day i have to restart mysql service because i get the message:
¨error establishing database connection¨

please advise
Herman

8
E-Mail / mail explorer
« on: March 17, 2017, 01:08:40 PM »
Hi There,

Can anyone help me out here?

I have an empty email preview window in the mail explorer.


9
E-Mail / no PID file /var/run/amavisd/amavisd.pid cwp
« on: March 15, 2017, 11:20:04 AM »
Shutting down amavisd: The amavisd daemon is apparently not running, no PID file /var/run/amavisd/amavisd.pid
[FAILED]

Starting amavisd: [  OK  ]


I already tried rebuilding cant seem to fix it due to missing pid file.
pls advise.
thanks

10
DNS / Re: Cant start DNS
« on: December 18, 2016, 07:53:02 PM »
Edited and removed .
This is the result.

----------------------------------------------------------------------------
Stopping named: [  OK  ]
Starting named:
Error in named configuration:
zone localhost.localdomain/IN: loading from master file named.localhost failed: file not found
zone localhost.localdomain/IN: not loaded due to errors.
_default/localhost.localdomain/IN: file not found
zone localhost/IN: loading from master file named.localhost failed: file not found
zone localhost/IN: not loaded due to errors.
_default/localhost/IN: file not found
zone 1.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.ip6.arpa/IN: loading from master file named.loopback failed: file not found
zone 1.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.ip6.arpa/IN: not loaded due to errors.
_default/1.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.ip6.arpa/IN: file not found
zone 1.0.0.127.in-addr.arpa/IN: loading from master file named.loopback failed: file not found
zone 1.0.0.127.in-addr.arpa/IN: not loaded due to errors.
_default/1.0.0.127.in-addr.arpa/IN: file not found
zone 0.in-addr.arpa/IN: loading from master file named.empty failed: file not found
zone 0.in-addr.arpa/IN: not loaded due to errors.
_default/0.in-addr.arpa/IN: file not found
zone ns1.argewebhosting.eu/IN: loaded serial 2013071600
zone ns3.argewebhosting.nl/IN: loading from master file /var/named/ns3.argewebhosting.nl.db failed: file not found
zone ns3.argewebhosting.nl/IN: not loaded due to errors.
_default/ns3.argewebhosting.nl/IN: file not found
zone ns2.argewebhosting.com/IN: loaded serial 2013071600
zone djgaston.nl/IN: loaded serial 2016121814
zone bcoin.nl/IN: loaded serial 2016121820
zone kastenbank.nl/IN: loaded serial 2013071600
zone oudersblog.nl/IN: loaded serial 2013071600
zone forallkids.co.uk/IN: loaded serial 2016121814
zone forallkids.nl/IN: loaded serial 2016121821
[FAILED]

-------------------------------------------------------------------------

11
DNS / Re: Cant start DNS
« on: December 18, 2016, 12:52:54 PM »
Thanks for the reply,

Here´s the complete content of the named.conf

----------------------------------------------------------
//
// named.conf
//
// Provided by Red Hat bind package to configure the ISC BIND named(8) DNS
// server as a caching only nameserver (as a any DNS resolver only).
//
// See /usr/share/doc/bind*/sample/ for example named configuration files.
//

options {
   listen-on port 53 { any; };
   listen-on-v6 port 53 { ::1; };
   directory    "/var/named";
   dump-file    "/var/named/data/cache_dump.db";
        statistics-file "/var/named/data/named_stats.txt";
        memstatistics-file "/var/named/data/named_mem_stats.txt";
   allow-query     { any; };
   recursion no;

   dnssec-enable yes;
   dnssec-validation yes;

   /* Path to ISC DLV key */
   bindkeys-file "/etc/named.iscdlv.key";

   managed-keys-directory "/var/named/dynamic";
};

logging {
        channel default_debug {
                file "data/named.run";
                severity dynamic;
        };
};

zone "." IN {
   type hint;
   file "named.ca";
};

include "/etc/named.rfc1912.zones";
include "/etc/named.root.key";



// zone djgaston.nl
zone "djgaston.nl" {
                                   type master;
                                        file "/var/named/djgaston.nl.db";};
// zone_end djgaston.nl
zone "ns1.argewebhosting.eu" {type master;file "/var/named/ns1.argewebhosting.eu.db";};
zone "ns3.argewebhosting.nl" {type master;file "/var/named/ns3.argewebhosting.nl.db";};
zone "ns2.argewebhosting.com" {type master;file "/var/named/ns2.argewebhosting.com.db";};


// zone bcoin.nl
zone "bcoin.nl" {
                                   type master;
                                        file "/var/named/bcoin.nl.db";};
// zone_end bcoin.nl

// zone kastenbank.nl
zone "kastenbank.nl" {
                                   type master;
                                        file "/var/named/kastenbank.nl.db";};
// zone_end kastenbank.nl

// zone oudersblog.nl
zone "oudersblog.nl" {
                                   type master;
                                        file "/var/named/oudersblog.nl.db";};
// zone_end oudersblog.nl

zone "" {
type master;
file "/var/named/.db";
};




// zone forallkids.co.uk
zone "forallkids.co.uk" {
                                   type master;
                                        file "/var/named/forallkids.co.uk.db";};
// zone_end forallkids.co.uk


// zone forallkids.nl
zone "forallkids.nl" {
                                   type master;
                                        file "/var/named/forallkids.nl.db";};
// zone_end forallkids.nl

-----------------------------------------------------------------

12
DNS / Cant start DNS
« on: December 17, 2016, 04:17:03 PM »
Can anyone please help me out here.
I get the following error when trying to start DNS service.

Stopping named: [  OK  ]
Starting named:
Error in named configuration:
/etc/named.conf:74: zone '': is not a valid name
[FAILED]

Pages: [1]