Issue plesk repair all -y

[weareimpulse]

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

 

[Kaspar@Plesk]

Any relevant details in the suggested log, /var/log/plesk/install/plesk_18.0.60_repair.log ?

 

[weareimpulse]

hi... just says the same as the output in SSH.

 

[weareimpulse]

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

 

[Bitpalast]

- /usr/bin/mysql: unknown variable
'sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
[/icode]

The sql_mode variable goes into the [mysql] section in /etc/my.cnf. Maybe it's being used out of section?

 

[weareimpulse]

hi, i think we've sorted the first point...

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

see attached..

 

[pleskuser67553]

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

Ditto. AlmaLinux 9.2, Plesk Obsidian 18.0.61 Update #4

 

[Kaspar@Plesk]

What file permission does the /etc/domainkeys directory have?

 

[pleskuser67553]

What file permission does the /etc/domainkeys directory have?

drwxr-xr-x. 8 root root

 

[Kaspar@Plesk]

Do all of the sub directory's all have the 755 permission too?

 

[pleskuser67553]

Yes, six sub dirs in /etc/domainkeys all with drwxr-xr-x.

 

[Kaspar@Plesk]

That's strange. I suggest contacting Plesk support for an investigation. To sign-in to support please go to https://support.plesk.com

If you got your license from a reseller, your reseller should provide support for you. If the reseller does not provide support, here is an alternative:
https://support.plesk.com/hc/en-us/articles/12388090147095-How-to-get-support-directly-from-Plesk

 

[pleskuser67553]

Thanks. VPSes from IONOS. It's doing it on another too (AlmaLinux 8.10, Plesk Obsidian 18.0.60 Update #1), but not on a third (AlmaLinux 9.2, Plesk Obsidian 18.0.61 Update #4).

It does not appear to be causing any issues, outbound emails are being signed, so I'll leave it for now - I just don't like to see "issue(s) detected"