• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.

Issue plesk sql server problem

GiRGiN

GiRGiN

New Pleskian
Hi plesk team,
I updated my server yesterday. But mariadb has a problem.I wiped Mariadb and did not fix it again. Plesk repair codes do not work.

[root@~]# plesk repair all
-bash: plesk: command not found


[root@wmtools ~]# plesk repair db
-bash: plesk: command not found

Do I need to move my sql statement?
 
'plesk' command is the part of plesk-completion package:

# rpm -qf /usr/sbin/plesk
plesk-completion-17.8.11-cos7.build1708180322.11.noarch

Make sure that this package is installed.
If your Plesk is seriously damaged, try to run Plesk installer again as it is described here Installing Plesk for Linux Using Installer Console
 
Hi,

===> Checking for previous installation ... not found.
Create user 'psaadm' and group 'psaadm'
Checking for the group 'psaadm'...
Group 'psaadm' already exists

Checking for the user 'psaadm'...
User 'psaadm' already exists

Create group swkey-data
Checking for the group 'swkey-data'...
Group 'swkey-data' already exists

Checking for the group 'swkey-data'...
Trying to add supplementary group 'swkey-data' for user 'psaadm'... already th ere
Create Mail accounts
Checking for the group 'popuser'...
Group 'popuser' already exists

Checking for the user 'popuser'...
User 'popuser' already exists

Checking for the user 'mhandlers-user'...
User 'mhandlers-user' already exists



===> Checking for the necessary system accounts
Checking for the system groups and users necessary for admin server...
Checking for the group 'psaadm'...
Group 'psaadm' already exists

Checking for the user 'psaadm'...
User 'psaadm' already exists

Checking for the group 'psaserv'...
Group 'psaserv' already exists

Checking for the group 'psaserv'...
Trying to add supplementary group 'psaserv' for user 'psaadm'... already there
Checking for the group 'psacln'...
Group 'psacln' already exists

Checking that /usr/local/psa/bin/chrootsh registered as login shell...
/usr/local/psa/bin/chrootsh already registered as a login shell


===> Performing safe prep-install database actions

Trying to start service mariadb... active
done
Trying to establish test connection... /usr/local/psa/bootstrapper/pp17.8.11-bo otstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: / usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: / usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: / usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: / usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: / usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: / usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: / usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: / usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: / usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: / usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: / usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: / usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: / usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: / usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: / usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: / usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: / usr/bin/mysql: Is a directory
/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: / usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: / usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: / usr/bin/mysql: Is a directory
failed

ERROR while trying to establish test connection
Check the error reason(see log file: /var/log/plesk/install/plesk_17.8.11_instal lation.log), fix and try again

***** problem report *****
ERROR while trying to establish test connection
Check the error reason(see log file: /var/log/plesk/install/plesk_17.8.11_instal lation.log), fix and try again
sh: /etc/init.d/psa: No such file or directory

ERROR: An error occurred during performing of installation PREP actions (see log for details). Installation was rolled back.
Warning! Not all packages were installed.
Please check if your system services are operable.
Please resolve this issue and try to install the packages again.
If you cannot resolve the issue on your own, contact product technical support f or assistance.
[root@wmtools ~]#
 
Create /root/.my.cnf file and specify login and password for mysql user:

Code: 
# cat /root/.my.cnf
[client]
user = root
password = root_password

-> install update/plesk again
 
Hi,

I made you say
Code: 
[root@wmtools ~]# cat /root/.my.cnf
[client]
user=root
password=G=pnm&1@

Code: 
Available actions:
(F) Go forward
(B) Go back
(Q) Cancel installation
(S) Show the list of packages

Select an action [F/b/q/s]: f
Installing packages
chsh: Shell not changed.
Changing shell for popuser.
chsh: Shell not changed.
Changing shell for mhandlers-user.

**** Product prep-install started.

===> Checking for previous installation ... not found.
Create user 'psaadm' and group 'psaadm'
 Checking for the group 'psaadm'...
 Group 'psaadm' already exists

 Checking for the user 'psaadm'...
 User 'psaadm' already exists

Create group swkey-data
 Checking for the group 'swkey-data'...
 Group 'swkey-data' already exists

 Checking for the group 'swkey-data'...
 Trying to add supplementary group 'swkey-data' for user 'psaadm'...  already there
Create Mail accounts
 Checking for the group 'popuser'...
 Group 'popuser' already exists

 Checking for the user 'popuser'...
 User 'popuser' already exists

 Checking for the user 'mhandlers-user'...
 User 'mhandlers-user' already exists

 Trying to got legacy variables... done
config updated
===> Updated /etc/psa/psa.conf
 Trying to save legacy variables... done
 Trying to resolve hostname 'wmtools.co' and validate its IP address... done


===> Checking for the necessary system accounts
 Checking for the system groups and users necessary for admin server...
 Checking for the group 'psaadm'...
 Group 'psaadm' already exists

 Checking for the user 'psaadm'...
 User 'psaadm' already exists

 Checking for the group 'psaserv'...
 Group 'psaserv' already exists

 Checking for the group 'psaserv'...
 Trying to add supplementary group 'psaserv' for user 'psaadm'...  already there
 Checking for the group 'psacln'...
 Group 'psacln' already exists

 Checking that /usr/local/psa/bin/chrootsh registered as login shell...
/usr/local/psa/bin/chrootsh already registered as a login shell


===> Performing safe prep-install database actions

 Trying to start service mariadb... active
done
 Trying to establish test connection... /usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
/usr/local/psa/bootstrapper/pp17.8.11-bootstrapper/bootstrapper.sh: line 7456: /usr/bin/mysql: Is a directory
failed

ERROR while trying to establish test connection
Check the error reason(see log file: /var/log/plesk/install/plesk_17.8.11_installation.log), fix and try again

*****  problem report *****
ERROR while trying to establish test connection
Check the error reason(see log file: /var/log/plesk/install/plesk_17.8.11_installation.log), fix and try again
sh: /etc/init.d/psa: No such file or directory

ERROR: An error occurred during performing of installation PREP actions (see log for details). Installation was rolled back.
Warning! Not all packages were installed.
Please check if your system services are operable.
Please resolve this issue and try to install the packages again.
If you cannot resolve the issue on your own, contact product technical support for assistance.
 
I would recommend you to make a complete backup of your server and afterwards make a complete fresh installation. ( OS too)
You have to many missing files and misconfigurations, which in the long run will cause problems and lead to instability of the system.
 
You must log in or register to reply here.

Similar threads

q-quan
Resolved Windows Server 2025 - Plesk Obsidian 18.0.69 - msodbcsql17 dependency
Replies
11
Views
794
iForced
I
S
Issue MariaDB 10.5 to 10.11 upgrade failure on AlmaLinux 9.5
Replies
3
Views
2K
sder
S
Manuel Kuhn
Issue Problems from debian 10 to 12
Replies
2
Views
1K
Sebahat.hadzhi
Sebahat.hadzhi
W
Resolved Login problem
Replies
2
Views
677
Willi
W
Daerik
Issue Deprecated Program Name Warning After Upgrading to MariaDB 11.4
Replies
4
Views
12K
LinqLOL
LinqLOL
Back
Top