• Please be aware: Kaspersky Anti-Virus has been deprecated
    With the upgrade to Plesk Obsidian 18.0.64, "Kaspersky Anti-Virus for Servers" will be automatically removed from the servers it is installed on. We recommend that you migrate to Sophos Anti-Virus for Servers.
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.
  • We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.

Question my.cnf in /root

AWSolutions

New Pleskian
Hey everyone,

So we keep a /root/.my.cnf on the servers so that our administrators can login pretty easily.

The latest version of plesk does not seem to like that with outupdates:

EMERGENCY: The file /root/.my.cnf contains a password for the MySQL console client. Please remove this file temporarily and restore it after the upgrade, otherwise the upgrade will fail

The suggested fix on forums is to simple move the file, or delete it and run the upgrade.

The problem is that these are automatic upgrades, which now have to become manual upgrades. So we're left between choosing to remove the /root/.my.cnf file permanently or doing automatic updates by hand.

I'm also a bit ashamed to say that we haven't adopted "plesk db" in our training of junior sys admins as we probably should. I suppose this is because we have startup scripts that setup "mysql" to login to mysql on all of our servers (plesk or not plesk).

I'm wondering two things:

1) what is the rational between forcing this? I'm guessing some people set a specific db user that wasn't admin here and it borked some things in the past,....but Why doesn't plesk update just pass the user admin and the contents of /etc/psa/.psa.shadow file when it runs the autoupdate? Why does it enforce that a user cannot use something so basic?

2) Is anyone using any kind of workarounds here? Or just using plesk db as mentioned above?
 
Back
Top