Stats not working, MailAccount add failed on one domain

[mehawk]

Hello Guys,

After spending 2 days I decided to write here. I am currently facing two problems:

1). Stats not working stats.domain.tld shows server not found (for all domains it was working fine 2 months ago before updates).

2).  MailAccount add failed on one domain. Even Maildir, .qmail were not present in client's directory.

Here is the result of sh /script/sysinfo -y

Code: [Select]

A. Control Panel:
   - Kloxo-MR: 7.0.0.b-2016121301
   - Web: hiawatha-10.4.0-f.1.mr.el6.i686
   - PHP: php54s-5.4.45-1.ius.el6 (fpm mode)
B. Plateform:
   - OS: CentOS release 6.8 (Final) i686
   - Hostname: server1.domain.tld
C. Services:
   1. MySQL: MariaDB-server-10.0.28-1.el6.i686
   2. PHP:
      - Installed:
        - Branch: php54-cli-5.4.45-1.ius.el6.i686
        - Multiple:
          * php54m-5.4.45-1.ius.el6
          * php55m-5.5.38-1.ius.el6
          * php56m-5.6.28-1.ius.el6
      - Used: php56m-fpm
      - Multiple: disable
   3. Web Used: apache
     - Hiawatha: hiawatha-10.4.0-f.1.mr.el6.i686
     - Lighttpd: lighttpd-1.4.43-2.el6.i686
     - Nginx: nginx-1.11.7-1.el6.ngx.i386
     - Apache: httpd24u-2.4.23-4.ius.el6.i686
       - PHP Type: php-fpm_event
       - Secondary PHP: off
   4. WebCache: none
     - ATS: --uninstalled--
     - Squid: --uninstalled--
     - Varnish: --uninstalled--
   5. Dns: djbdns
     - Bind: --uninstalled--
     - DJBDns: djbdns-1.05-17.4.mr.el6.i386
     - NSD: --uninstalled--
     - PowerDNS: --uninstalled--
     - Yadifa: --uninstalled--
   6. Mail: qmail-toaster-1.03-1.3.55.mr.el6.i386
      - pop3/imap4: courier-imap-toaster-4.1.2-1.3.20.mr.el6.i686
      - smtp: qmail-toaster-1.03-1.3.55.mr.el6.i386
      - spam: bogofilter-1.2.4-1.el6.i686
   7. Stats: awstats

I have tried sh /script/cleanup; sh /script/fix-all/; sh /script/restart-all;


Best Regards,
Muhammad Mehroz Anjum.

[MRatWork]

1. For stats, try 'sh /script/fixtraffic'
2. For qmail, try 'sh /script/reset-mysql-root-password YOURNEWPASSWORD' and then 'sh /script/fixmail-all'.

[mehawk]

1. For stats, try 'sh /script/fixtraffic'
2. For qmail, try 'sh /script/reset-mysql-root-password YOURNEWPASSWORD' and then 'sh /script/fixmail-all'.

Tried both of them but nothing happened. Issues are still present.

[MRatWork]

Inform here for '/home/vpopmail/bin/vdominfo; sh /script/mailqueue -l' for qmail. Also testing your domain mail via mxtoolbox.com.

For stats, what's you see if access to stats.yourdomain.com?.

[mehawk]

Inform here for '/home/vpopmail/bin/vdominfo; sh /script/mailqueue -l' for qmail. Also testing your domain mail via mxtoolbox.com.

For stats, what's you see if access to stats.yourdomain.com?.

/home/vpopmail/bin/vdominfo

Code: [Select]

domain: xplore.pk
uid:    7797
gid:    7797
dir:    /home/lxadmin/mail/domains/xplore.pk
users:  2147483647

domain: xploretech.net
uid:    7798
gid:    7798
dir:    /home/lxadmin/mail/domains/xploretech.net
users:  0

domain: pm.xplore.pk
uid:    7798
gid:    7798
dir:    /home/lxadmin/mail/domains/pm.xplore.pk
users:  0

domain: tech.xplore.pk
uid:    7798
gid:    7798
dir:    /home/lxadmin/mail/domains/tech.xplore.pk
users:  0

domain: eshoppy.tk
uid:    7800
gid:    7800
dir:    /home/lxadmin/mail/domains/eshoppy.tk
users:  0

domain: eventbrite.xploretech.net
uid:    7798
gid:    7798
dir:    /home/lxadmin/mail/domains/eventbrite.xploretech.net
users:  0

domain: html1.xploretech.net
uid:    7798
gid:    7798
dir:    /home/lxadmin/mail/domains/html1.xploretech.net
users:  0

domain: html2.xploretech.net
uid:    7798
gid:    7798
dir:    /home/lxadmin/mail/domains/html2.xploretech.net
users:  0

domain: html3.xploretech.net
uid:    7798
gid:    7798
dir:    /home/lxadmin/mail/domains/html3.xploretech.net
users:  0

domain: html4.xploretech.net
uid:    7798
gid:    7798
dir:    /home/lxadmin/mail/domains/html4.xploretech.net
users:  0

domain: html5.xploretech.net
uid:    7798
gid:    7798
dir:    /home/lxadmin/mail/domains/html5.xploretech.net
users:  0

domain: html6.xploretech.net
uid:    7798
gid:    7798
dir:    /home/lxadmin/mail/domains/html6.xploretech.net
users:  0

domain: hoster.xploretech.net
uid:    7798
gid:    7798
dir:    /home/lxadmin/mail/domains/hoster.xploretech.net
users:  0

domain: interiordesigner.xploretech.net
uid:    7798
gid:    7798
dir:    /home/lxadmin/mail/domains/interiordesigner.xploretech.net
users:  0

domain: html7.xploretech.net
uid:    7798
gid:    7798
dir:    /home/lxadmin/mail/domains/html7.xploretech.net
users:  0

domain: html8.xploretech.net
uid:    7798
gid:    7798
dir:    /home/lxadmin/mail/domains/html8.xploretech.net
users:  0

domain: html9.xploretech.net
uid:    7798
gid:    7798
dir:    /home/lxadmin/mail/domains/html9.xploretech.net
users:  0

domain: html10.xploretech.net
uid:    7798
gid:    7798
dir:    /home/lxadmin/mail/domains/html10.xploretech.net
users:  0

domain: html11.xploretech.net
uid:    7798
gid:    7798
dir:    /home/lxadmin/mail/domains/html11.xploretech.net
users:  0

domain: html12.xploretech.net
uid:    7798
gid:    7798
dir:    /home/lxadmin/mail/domains/html12.xploretech.net
users:  0

domain: html13.xploretech.net
uid:    7798
gid:    7798
dir:    /home/lxadmin/mail/domains/html13.xploretech.net
users:  0

domain: html14.xploretech.net
uid:    7798
gid:    7798
dir:    /home/lxadmin/mail/domains/html14.xploretech.net
users:  0

domain: html15.xploretech.net
uid:    7798
gid:    7798
dir:    /home/lxadmin/mail/domains/html15.xploretech.net
users:  0

domain: html16.xploretech.net
uid:    7798
gid:    7798
dir:    /home/lxadmin/mail/domains/html16.xploretech.net
users:  0

domain: html17.xploretech.net
uid:    7798
gid:    7798
dir:    /home/lxadmin/mail/domains/html17.xploretech.net
users:  0

domain: html18.xploretech.net
uid:    7798
gid:    7798
dir:    /home/lxadmin/mail/domains/html18.xploretech.net
users:  0

domain: html19.xploretech.net
uid:    7798
gid:    7798
dir:    /home/lxadmin/mail/domains/html19.xploretech.net
users:  0

domain: html20.xploretech.net
uid:    7798
gid:    7798
dir:    /home/lxadmin/mail/domains/html20.xploretech.net
users:  0

domain: videoagency.xploretech.net
uid:    7798
gid:    7798
dir:    /home/lxadmin/mail/domains/videoagency.xploretech.net
users:  0

domain: fashion1.xploretech.net
uid:    7798
gid:    7798
dir:    /home/lxadmin/mail/domains/fashion1.xploretech.net
users:  0

domain: sobias.xploretech.net
uid:    7798
gid:    7798
dir:    /home/lxadmin/mail/domains/sobias.xploretech.net
users:  0

domain: facelinesalon.com
uid:    7803
gid:    7803
dir:    /home/lxadmin/mail/domains/facelinesalon.com
users:  0

domain: mianmajid.facelinesalon.com
uid:    7803
gid:    7803
dir:    /home/lxadmin/mail/domains/mianmajid.facelinesalon.com
users:  0

domain: escapps.xploretech.net
uid:    7798
gid:    7798
dir:    /home/lxadmin/mail/domains/escapps.xploretech.net
users:  0

In this one of my domain is not present (socialbees.me). Here is intodns report https://intodns.com/socialbees.me.

here is the result of sh /script/mailqueue -l

Code: [Select]

Total messages: 0
Messages with local recipients: 0
Messages with remote recipients: 0
Messages with bounces: 0
Messages in preprocess: 0

when i visit stats.domain.tld  I see "Server not found"

[MRatWork]

Run 'sh /script/fixdnsaddstatsrecord; sh /script/restart-all'.

[mehawk]

sh /script/fixdnsaddstatsrecord

*** Add DNS record for 'stats' key in 'a' type ***
- For 'eshoppy.tk' ('eshoppy') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'facelinesalon.com' ('flsalon') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'mianmajid.facelinesalon.com' ('flsalon') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'socialbees.me' ('socialbees') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'escapps.xploretech.net' ('xploretech') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'eventbrite.xploretech.net' ('xploretech') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'fashion1.xploretech.net' ('xploretech') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'hoster.xploretech.net' ('xploretech') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'html1.xploretech.net' ('xploretech') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'html10.xploretech.net' ('xploretech') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'html11.xploretech.net' ('xploretech') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'html12.xploretech.net' ('xploretech') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'html13.xploretech.net' ('xploretech') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'html14.xploretech.net' ('xploretech') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'html15.xploretech.net' ('xploretech') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'html16.xploretech.net' ('xploretech') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'html17.xploretech.net' ('xploretech') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'html18.xploretech.net' ('xploretech') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'html19.xploretech.net' ('xploretech') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'html2.xploretech.net' ('xploretech') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'html20.xploretech.net' ('xploretech') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'html3.xploretech.net' ('xploretech') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'html4.xploretech.net' ('xploretech') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'html5.xploretech.net' ('xploretech') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'html6.xploretech.net' ('xploretech') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'html7.xploretech.net' ('xploretech') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'html8.xploretech.net' ('xploretech') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'html9.xploretech.net' ('xploretech') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'interiordesigner.xploretech.net' ('xploretech') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'pm.xplore.pk' ('xploretech') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'sobias.xploretech.net' ('xploretech') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'tech.xplore.pk' ('xploretech') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'videoagency.xploretech.net' ('xploretech') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'xploretech.net' ('xploretech') at 'localhost'
  * already exists of 'stats' key in 'a' type
- For 'xplore.pk' ('admin') at 'localhost'
  * already exists of 'stats' key in 'a' type

sh /script/restart-all

Shutting down system logger:                               [  OK  ]
Starting system logger:                                    [  OK  ]
-------------------------------------------------------------------

Stopping httpry:                                           [  OK  ]
Starting httpry:                                           [  OK  ]
-------------------------------------------------------------------

*** Process for MYSQL/MARIADB service ***
Starting MySQL161215 14:07:02 mysqld_safe Logging to '/var/lib/mysql/server1.xplore.pk.err'.
 SUCCESS!
  - Process: restart
Shutting down MySQL. SUCCESS!
Starting MySQL.161215 14:07:04 mysqld_safe Logging to '/var/lib/mysql/server1.xplore.pk.err'.
 SUCCESS!
-------------------------------------------------------------------

*** Process for DJBDNS service ***
  - Process: dnsnotify
Received NOTIFY answer from 216.189.144.244 for escapps.xploretech.net
Received NOTIFY answer from 216.189.144.244 for eventbrite.xploretech.net
Received NOTIFY answer from 216.189.144.244 for facelinesalon.com
Received NOTIFY answer from 216.189.144.244 for fashion1.xploretech.net
Received NOTIFY answer from 65.254.254.171 for feeling-hungry.com
Received NOTIFY answer from 216.189.144.244 for feeling-hungry.net
Received NOTIFY answer from 216.189.144.244 for hoster.xploretech.net
Received NOTIFY answer from 216.189.144.244 for html1.xploretech.net
Received NOTIFY answer from 216.189.144.244 for html10.xploretech.net
Received NOTIFY answer from 216.189.144.244 for html11.xploretech.net
Received NOTIFY answer from 216.189.144.244 for html12.xploretech.net
Received NOTIFY answer from 216.189.144.244 for html13.xploretech.net
Received NOTIFY answer from 216.189.144.244 for html14.xploretech.net
Received NOTIFY answer from 216.189.144.244 for html15.xploretech.net
Received NOTIFY answer from 216.189.144.244 for html16.xploretech.net
Received NOTIFY answer from 216.189.144.244 for html17.xploretech.net
Received NOTIFY answer from 216.189.144.244 for html18.xploretech.net
Received NOTIFY answer from 216.189.144.244 for html19.xploretech.net
Received NOTIFY answer from 216.189.144.244 for html2.xploretech.net
Received NOTIFY answer from 216.189.144.244 for html20.xploretech.net
Received NOTIFY answer from 216.189.144.244 for html3.xploretech.net
Received NOTIFY answer from 216.189.144.244 for html4.xploretech.net
Received NOTIFY answer from 216.189.144.244 for html5.xploretech.net
Received NOTIFY answer from 216.189.144.244 for html6.xploretech.net
Received NOTIFY answer from 216.189.144.244 for html7.xploretech.net
Received NOTIFY answer from 216.189.144.244 for html8.xploretech.net
Received NOTIFY answer from 216.189.144.244 for html9.xploretech.net
Received NOTIFY answer from 216.189.144.244 for interiordesigner.xploretech.net
Received NOTIFY answer from 216.189.144.244 for mianmajid.facelinesalon.com
Received NOTIFY answer from 108.167.160.57 for pakvehicles.com
Received NOTIFY answer from 216.189.144.244 for pm.xplore.pk
Received NOTIFY answer from 216.189.144.244 for sobias.xploretech.net
Received NOTIFY answer from 216.189.144.244 for socialbees.me
Received NOTIFY answer from 216.189.144.244 for tech.xplore.pk
Received NOTIFY answer from 216.189.144.244 for videoagency.xploretech.net
Received NOTIFY answer from 216.189.144.244 for xplore.pk
Received NOTIFY answer from 216.189.144.244 for xploretech.net
  - Process: restart
Stopping Djbdns for:
  - axfrdns    [  OK  ]
  - tinydns    [  OK  ]
Starting Djbdns for:
  - axfrdns    [FAILED]
  - tinydns    [FAILED]
-------------------------------------------------------------------

*** Process for PHP-FPM service ***
  - Process: restart
Stopping php56m-fpm (PHP Used):                            [  OK  ]
Starting php56m-fpm (PHP Used):                            [  OK  ]
-------------------------------------------------------------------

*** Process for HTTPD service ***
  - Process: restart
Stopping httpd:                                            [  OK  ]
Starting httpd:                                            [  OK  ]
-------------------------------------------------------------------

*** Process for QMAIL service ***
Stopping qmail-toaster: svscan qmail logging.
qmail-send: no process killed
Starting qmail-toaster: svscan.
-------------------------------------------------------------------

Stopping pure-ftpd:                                        [  OK  ]
Starting pure-ftpd:                                        [  OK  ]
-------------------------------------------------------------------

*** Process for KLOXO service ***
  - Process: restart
Stopping kloxo-phpcgi:                                     [  OK  ]
Starting kloxo-phpcgi ('php54s' in 'fpm' mode):            [  OK  ]
Stopping kloxo-hiawatha:                                   [  OK  ]
Starting kloxo-hiawatha:                                   [  OK  ]
-------------------------------------------------------------------

- For help, type '/script/restart-all [--help|-h]'

stats still not working

[MRatWork]

Try reboot.

[mehawk]

tried reboot still same.

[MRatWork]

Need propagation time to make 'stats' ready to access.

For djbdns, try 'service djbdns setup; sh /script/restart-dns -y'.

[MRatWork]

For dns server, better choose nsd instead djbdns or bind/named.

[mehawk]

Need propagation time to make 'stats' ready to access.

For djbdns, try 'service djbdns setup; sh /script/restart-dns -y'.

Here is the result of "service djbdns setup"

Stopping Djbdns for:
  - axfrdns    [  OK  ]
  - tinydns    [  OK  ]
Djbdns setup for:
  - tinydns setup finished
  - axfrdns setup finished
  - dnscache setup finished
Starting Djbdns for:
  - axfrdns    [  OK  ]
  - tinydns    [  OK  ]

sh /script/restart-dns -y

Stopping Djbdns for:
  - axfrdns    [  OK  ]
  - tinydns    [  OK  ]
Starting Djbdns for:
  - axfrdns    [  OK  ]
  - tinydns    [  OK  ]

I will switch to NDS But my major problem is MailAccount creation is failing for just one client.
I had too much trouble with this specific client in the past first kloxo Mr wasn't even creating account with this name then after troubleshooting it manually (because the fix scripts were not working for this). And now its not allowing email account creation.

[mehawk]

Ok now all the sites are down including kloxo Mr panel. I tried sh /script/cleanup and sh /script fix all but no problem is still there I tried sh /script/restart-all and i got this

- Fix mail-all services
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- Fix ftp-all services
- Fix skeleton services

while running fix-all i encountered this

- Add Password to configuration file
- Could not grant privileges. Script Abort*** Afterlogic Webmail Lite setup ***
- Preparing database
- Rename 'setting.xml' to 'settings.xml.php'
- Generating password
- Add Password to configuration file
- Could not grant privileges. Script Abort*** Squirrelmail Webmail setup ***
- Preparing Database
 
Update

I  ran

sh /script/reset-mysql-root-password YOURNEWPASSWORD
sh /script/fixmail-all
sh /script/fixdnsaddstatsrecord
sh /script/restart-all

still dns was not not working then i ran

sh /script/fixdns
service djbdns setup
sh /script/restart-dns -y
sh /script/fix-all (and its now hanged there)

anyway kloxo panel is accessible via IP address

[MRatWork]

Make sure update your Kloxo-MR to latest upload before. It's because something wrong for djbdns in previous upload and already fixed. But, better using nsd instead djbdns.

[mehawk]

I updated the panel on 11 dec. I will check again for updates after finishing restart-all.  After update i will switch to NDS.