Issue plesk sql server problem

[Micro$oft]

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?

 

[IgorG]

'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

 

[Micro$oft]

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 ~]#

 

[m3lezZ]

Create /root/.my.cnf file and specify login and password for mysql user:

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

-> install update/plesk again

 

[Micro$oft]

Hi,

I made you say

[root@wmtools ~]# cat /root/.my.cnf
[client]
user=root
password=G=pnm&1@

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.

 

[m3lezZ]

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.

 

[Micro$oft]

Hi, We installed our new server.
I moved the var/lib/mysql folder to a different location.
When I move folders to the new server phpMyAdmin gives a read / write error.

Error ss:
46.20.4.244:8880 / localhost / maydanoz_sohbet | phpMyAdmin 4.7.8
Database 'maydanoz_sohbet' Checking Results - Plesk Onyx 17.8.11