• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

ERROR: PleskFatalException: StatInfo->getActiveDomainsNumber() failed:

R

Raakh5

Basic Pleskian
Hello,

When I click to "Server Information" then seeing the following error:
ERROR: PleskFatalException: StatInfo->getActiveDomainsNumber() failed: sysinfo failed: sh: /usr/local/psa/admin/bin/sysinfo: Success

Additionally, an exception has occurred while trying to report this error: PleskFatalException
StatInfo->getProductVersion failed: sysinfo failed: sh: /usr/local/psa/admin/bin/sysinfo: Success
(class.SystemStatisticsForm.php:123)

When I click to "Services Management" then seeing this error:
ERROR: Service_Agent_Exception
Unable to parse handlers list.

I ran this command `/usr/local/psa/admin/bin/mail_auth_view` but this was displaying none. I surf the net and found that this `/usr/local/psa/admin/sbin/mchk --without-spam` command can repair it but plesk become more worst.

I tried `/usr/local/psa/admin/sbin/mchk --with-spam
1004 ==> Checking for: mail_imap_restore... fail
1005 ==> Checking for: mail_spam_restore... fail`

Most important I am not seeing in "Tool & Settings" "Mail Server" setting icons or link

Please advise
 
What is your Plesk version? If it is 12.5, try to run

# plesk repair all
 
Thanks for your prompt reply. I did but thrown error at the end:

]# plesk repair all

Reconfiguring the Plesk installation
Reconfigure the Plesk installation? [Y/n] y
Reconfiguring the Plesk installation ............................ [OK]

Checking the Plesk database using the native database server tools .. [OK]

Checking the structure of the Plesk database ........................ [OK]

Checking the consistency of the Plesk database ...................... [OK]

Checking system users
Decoding failed: Syntax error

Checking virtual hosts' file system ................................. [OK]

Checking Plesk version .............................................. [OK]

Checking for custom configuration templates ......................... [OK]

Checking for the JkWorkersFile directive in the Apache configuration

The Apache configuration file "/etc/httpd/conf.d/mod_jk.conf"
contains the "JkWorkersFile "/etc/httpd/conf/workers.properties""
directive ......................................................... [WARNING]

The JkWorkersFile directive may cause problems during the Apache
reconfiguration after the upgrade.
Please check http://kb.odin.com/en/113210 for more details ........ [WARNING]

Checking associations between domains and IP addresses .............. [OK]

Checking for corrupted reference between IP collections and IP
addresses ........................................................... [OK]

Checking for links between APS applications and subscriptions ....... [OK]

Checking for the Zend extension declaraion in php.ini ............... [OK]

Check symbolic links for latest virtual host config files ........... [OK]

Checking for system users home directories consistency .............. [OK]

Checking for records with empty name field in the Configurations table[OK]

Checking for nginx ULIMIT value ..................................... [OK]

Checking for extra configurations in database not owned by any object [OK]

Repairing web server configuration
Reinstall SSL certificates and set the default SSL certificate for all IP addresses? [Y/n] y
Reinstalling SSL certificates ................................... [OK]
Applying the default SSL certificate to all IP addresses ........ [OK]
Repair server-wide configuration parameters for web servers? [Y/n] y
Repairing server-wide configuration parameters for web servers .. [OK]
Update the file of sharing passwords and permissions of users according to actual information? [Y/n] y
Updating the file of sharing passwords and permissions of users
according to actual information ................................. [OK]
Repair web server configuration for all domains? [Y/n] y
Repairing web server configuration for all domains .............. [OK]

Checking the usage of PHP handlers
Unable to parse handlers list.

Restoring DNS server configuration
Synchronize DNS zones with the DNS server? [Y/n] y
Synchronizing DNS zones with the DNS server ..................... PHP Fatal error: Call to a member function getId() on null in /usr/local/psa/admin/plib/Repair/Dns.php on line 52
exit status 255
[root@centos ~]#
 
# plesk repair dns

Restoring DNS server configuration
Synchronize DNS zones with the DNS server? [Y/n] y
Synchronizing DNS zones with the DNS server ..................... PHP Fatal error: Call to a member function getId() on null in /usr/local/psa/admin/plib/Repair/Dns.php on line 52
Error occured while sending feedback. HTTP code returned: 502
exit status 255
 
Thanks for your favorable replies

I seen this but there is no option of BIND in "Plesk Upgrade Settings". Please see this image: http://prnt.sc/b2abie

Furthermore, all website users are not able to send emails from their accounts even they are not able to login to their emails account. There is no "Mail" icon in domains/subscription section
 
Here is Message on Plesk Homepage:
Failed to update Plesk. To solve this problem, you can send the update log to Odin support. View the update logs (May 10, 2016). Copy the logs to your computer before you close this message. To close this message, click here.

Here is update log:
Execution failed.
Command: autoinstaller
Arguments: Array
(
[0] => --select-product-id
[1] => plesk
[2] => --select-release-current
[3] => --upgrade-installed-components
[4] => --include-components-from-class
[5] => vendor=parallels
[6] => --include-components-from-class
[7] => patched
)

Details: sh: /usr/local/psa/admin/bin/autoinstaller: Success
 
Try to update it with

# plesk installer --select-release-current --reinstall-patch --upgrade-installed-components
 
Its ran successfully but now nothing is working and I am seeing only one message:
ERROR: Service_Agent_Exception
Unable to read components configuration from the service node: sh: /usr/local/psa/admin/bin/packagemng: Permission denied
 
Thanks again for your favorable reply

I did all the steps mentioned in above referred articles but with no luck. Nothing changed

[root@centos ~]# cd /usr/local/psa/
[root@centos psa]# chown root:psaadm ./admin/sbin/*wrapper
[root@centos psa]# chmod 4110 ./admin/sbin/*wrapper
[root@centos psa]# ls -ld /usr/local/psa/admin/sbin/
drwxr-xr-x. 3 root root 4096 May 10 09:09 /usr/local/psa/admin/sbin/
[root@centos psa]# ls -ld /usr/local/psa/admin/
drwxr-xr-x. 20 root root 4096 Mar 7 16:12 /usr/local/psa/admin/
[root@centos psa]# ls -ld /usr/local/psa/
drwxr-xr-x. 15 root root 4096 May 10 09:09 /usr/local/psa/
[root@centos psa]# ls -ld /usr/local/
drwxr-xr-x. 14 root root 4096 Dec 25 11:26 /usr/local/
[root@centos psa]# ls -ld /usr/
drwxr-xr-x. 13 root root 4096 Aug 19 2015 /usr/
[root@centos psa]# ls -ld /
dr-xr-xr-x. 25 root root 4096 Dec 31 10:23 /
[root@centos psa]# ls -ld /bin
dr-xr-xr-x. 2 root root 4096 Dec 25 11:24 /bin
[root@centos psa]#


ERROR: Service_Agent_Exception
Unable to read components configuration from the service node: sh: /usr/local/psa/admin/bin/packagemng: Permission denied
 
In my view this all about permissions.

When I ran this dangerous command in my case: /usr/local/psa/admin/sbin/mchk --without-spam then everything went wrong

For /usr/local/psa/admin/bin/packagemng: Permission denied I reset packagemng permissions to 755 and its become to previous state. I mean to the place from where I started my thread. Now I am facing same problem that mentioned in my very first thread

How can I reset default permissions for whole plesk?
 
We bought Plesk from online.net (our hosting company) and added ticket to their control panel but they said to get help from community. The plesk is also not supporting because we not bought this panel directly from Plesk.

Anyways I noticed that there is nothing in mail_auth_view file whilst DB shows emails and passwords:
]# /usr/local/psa/admin/sbin/mail_auth_view
Authentication database contents:
+--------------------------------------+-----+--------------------------------------+
| address |flags| password |
+--------------------------------------+-----+--------------------------------------+
+--------------------------------------+-----+--------------------------------------+
Flags
A - account disabled
D - domain disabled
E - password encrypted


How can I fix mail_auth_view ?
 
Thanks IgorG as you are helping me from yesterday. I really appreciate but nothing done with Plesk repair mail

# plesk repair mail

Error messages: 0; Warnings: 0; Errors resolved: 0
 
Thanks again. I applied but here is output:

# /usr/local/psa/bin/sw-engine-pleskrun plesk_password_changer.php `cat /etc/psa/.psa.shadow` 'Tunisia2015' --mailaccounts

[2016-05-11 06:21:43][INFO] ==> Installed Plesk version/build: 12.5.30 CentOS 6 1205160407.13

[2016-05-11 06:21:43][INFO] ==> Detect system configuration
[2016-05-11 06:21:43][INFO] OS: CentOS release 6.7 (Final)
Kernel \r on an \m
[2016-05-11 06:21:43][INFO] Arch: x86_64

[2016-05-11 06:21:43][INFO] ==> Validate given db password
[2016-05-11 06:21:43][INFO] Result: OK

[2016-05-11 06:21:43][INFO] ==> Plesk Password Changer version: 12.0.18.0

[2016-05-11 06:21:43][INFO] ==> STEP 1: Change password for mail accounts...
Mail service is not installed in Plesk.

[2016-05-11 06:21:43][WARNING] Unable to execute: /usr/local/psa/bin/mail -u [email protected] -passwd GOj7XQc%#9ro*5@aT14 Return code is: 1
Mail service is not installed in Plesk.
 
You must log in or register to reply here.

Similar threads

S
Resolved Error 500 Plesk\Exception\Database DB query failed: SQLSTATE[HY000] [2002] No such file or directory
Replies
10
Views
300
Shasam
S
C
Issue New Configuration not created
Replies
3
Views
342
Peter Debik
P
I
Resolved Plesk repair mail fails when not default DKIM selector in use
Replies
6
Views
1K
imrelaszlo84
I
H
Issue ipv6 install error failed (99: Cannot assign requested address)
Replies
1
Views
548
Peter Debik
P
E
Resolved DB query failed: SQLSTATE[HY000] [2002] No such file or directory mariadb cant start
Replies
1
Views
570
emreboy
E
Back
Top