• 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

Issue plesk repair all -y

weareimpulse

weareimpulse

Basic Pleskian
Server operating system version
Ubuntu 20.04.6 LTS
Plesk version and microupdate number
18.0.60
hi... wondering if anyone can help... last night our server started playing up... sites were going down etc, however, PLESK was running fine. I had access like I would normally.

I ran the 'plesk repair all -y' in SSH like I have done multiple times in the past, and saw this below - I've never seen it before, and i'm not sure how to resolve it.

Any help would be great appreciated....




Reconfiguring the Plesk installation
Reconfiguring the Plesk installation ............................ [FAILED]
- Started bootstrapper repair procedure (fast mode). This may
take a while.
- Certain actions may be skipped if not applicable.
-
-
- **** Product repair started.
- Started bootstrapper repair procedure (fast mode). This may
take a while.
- Certain actions may be skipped if not applicable.
-
- Trying to start service mariadb... active
- done
- Trying to establish test connection... /usr/bin/mysql: unknown
variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- failed
-
- ERROR while trying to establish test connection
-
- Check the error reason (see log file:
/var/log/plesk/install/plesk_18.0.60_repair.log), fix and try
again
- ***** problem report *****
- ERROR while trying to establish test connection
 
hi... just says the same as the output in SSH.
 

Attachments

  • Screenshot 2024-04-29 at 10.49.41.png
    Screenshot 2024-04-29 at 10.49.41.png
    456.1 KB · Views: 0
also, i keep getting this...

Checking Linux system files

The permissions on the /etc/domainkeys directory are incorrect .... [ERROR]
To see more details, run the command in the verbose mode: plesk repair fs -verbose
Repairing incorrect permissions ................................. [FIXED]

i have fixed it repeatedly today and it keep cropping back up - not sure if its a separate thing, or related
 
hi, i think we've sorted the first point...

any ideas why we can't repair this issue, just keeps coming back...

see attached..
 

Attachments

  • Screenshot 2024-04-29 at 14.32.39.png
    Screenshot 2024-04-29 at 14.32.39.png
    39.7 KB · Views: 2
You must log in or register to reply here.

Similar threads

N
Issue Unable to make database dump. Error: Failed to exec mysqldump.exe: Exit code: 7
Replies
2
Views
2K
NeFeS
N
M
Issue Plesk Update 18.0.34 to 18.0.57 Database 'psa' not found
Replies
10
Views
890
musa.sc
M
S
Resolved ERR_CONNECTION_REFUSED after update
Replies
5
Views
2K
sistemsb
S
M
Issue trying to upgrade plesk almalinux 8.7
Replies
1
Views
1K
Peter Debik
P
TimReeves
Resolved MariaDB Update to 10.11.7 via Plesk 18.0.60 on Debian 10
Replies
1
Views
207
TimReeves
TimReeves
Back
Top