MySQL Cron Job Error

    • Offizieller Beitrag

    Out of curiosity, have you found a solution to this?

    Nope, I have been sitting on a beach for the last week :)

    omv 7.0.4-2 sandworm | 64 bit | 6.5 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.10 | compose 7.1.2 | k8s 7.0-6 | cputemp 7.0 | mergerfs 7.0.3


    omv-extras.org plugins source code and issue tracker - github


    Please try ctrl-shift-R and read this before posting a question.

    Please put your OMV system details in your signature.
    Please don't PM for support... Too many PMs!

    • Offizieller Beitrag

    I've looked in to this a little more, but I still haven't come up with anything. If anybody has any suggestions, please let me know.

    What is the output of this query: select user,plugin from mysql.user;

    omv 7.0.4-2 sandworm | 64 bit | 6.5 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.10 | compose 7.1.2 | k8s 7.0-6 | cputemp 7.0 | mergerfs 7.0.3


    omv-extras.org plugins source code and issue tracker - github


    Please try ctrl-shift-R and read this before posting a question.

    Please put your OMV system details in your signature.
    Please don't PM for support... Too many PMs!

    • Offizieller Beitrag

    UPDATE mysql.user SET plugin = 'unix_socket' WHERE user = 'root';
    FLUSH PRIVILEGES;
    This should let you login as the root user without a password.

    omv 7.0.4-2 sandworm | 64 bit | 6.5 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.10 | compose 7.1.2 | k8s 7.0-6 | cputemp 7.0 | mergerfs 7.0.3


    omv-extras.org plugins source code and issue tracker - github


    Please try ctrl-shift-R and read this before posting a question.

    Please put your OMV system details in your signature.
    Please don't PM for support... Too many PMs!

  • UPDATE mysql.user SET plugin = 'unix_socket' WHERE user = 'root';
    FLUSH PRIVILEGES;
    This should let you login as the root user without a password.

    Okay, I've done it! Now I'll just wait to see if I get another one of those e-mails tomorrow. I've accumulated quite a collection of them. Still one question though: isn't it dangerous to allow logins as the root user without requiring as password?

    • Offizieller Beitrag

    isn't it dangerous to allow logins as the root user without requiring as password?

    If someone can login to your system as root, a mysql password doesn't mean anything because they could start mysql in safe mode and change the password anyway.


    If you really want to change it, you can:
    GRANT ALL PRIVILEGES on *.* to 'root'@'localhost' IDENTIFIED BY 'password';
    UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE user = 'root';
    FLUSH PRIVILEGES;

    omv 7.0.4-2 sandworm | 64 bit | 6.5 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.10 | compose 7.1.2 | k8s 7.0-6 | cputemp 7.0 | mergerfs 7.0.3


    omv-extras.org plugins source code and issue tracker - github


    Please try ctrl-shift-R and read this before posting a question.

    Please put your OMV system details in your signature.
    Please don't PM for support... Too many PMs!

  • If someone can login to your system as root, a mysql password doesn't mean anything because they could start mysql in safe mode and change the password anyway.
    If you really want to change it, you can:
    GRANT ALL PRIVILEGES on *.* to 'root'@'localhost' IDENTIFIED BY 'password';
    UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE user = 'root';
    FLUSH PRIVILEGES;

    Okay, that makes sense. Thanks for the tip!


    Unfortunately though, the issue is still unsolved. I got another one of those e-mails again in the middle of the night. The error message is the same as the one included in my initial post in this thread.

    • Offizieller Beitrag

    Unfortunately though, the issue is still unsolved. I got another one of those e-mails again in the middle of the night. The error message is the same as the one included in my initial post in this thread.

    The message says the debian-sys-admin can't login and that mysql user doesn't exist on my install. What is the output of:


    cat /etc/logrotate.d/mysql-server
    sudo grep -r debian-sys-admin /etc/*

    omv 7.0.4-2 sandworm | 64 bit | 6.5 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.10 | compose 7.1.2 | k8s 7.0-6 | cputemp 7.0 | mergerfs 7.0.3


    omv-extras.org plugins source code and issue tracker - github


    Please try ctrl-shift-R and read this before posting a question.

    Please put your OMV system details in your signature.
    Please don't PM for support... Too many PMs!

  • cat /etc/logrotate.d/mysql-server


    sudo grep -r debian-sys-admin /etc/*

    No output for this one.

    • Offizieller Beitrag

    so he doesn't miss it

    Ok, I would try removing the debian-sys-admin:
    DELETE FROM mysql.user WHERE user = 'debian-sys-admin';
    FLUSH PRIVILEGES;


    Then try this again:
    sudo logrotate -f /etc/logrotate.d/mysql-server

    omv 7.0.4-2 sandworm | 64 bit | 6.5 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.10 | compose 7.1.2 | k8s 7.0-6 | cputemp 7.0 | mergerfs 7.0.3


    omv-extras.org plugins source code and issue tracker - github


    Please try ctrl-shift-R and read this before posting a question.

    Please put your OMV system details in your signature.
    Please don't PM for support... Too many PMs!

    • Offizieller Beitrag

    Nope! Still happening.

    What is the output of: sudo cat /etc/mysql/debian.cnf

    omv 7.0.4-2 sandworm | 64 bit | 6.5 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.10 | compose 7.1.2 | k8s 7.0-6 | cputemp 7.0 | mergerfs 7.0.3


    omv-extras.org plugins source code and issue tracker - github


    Please try ctrl-shift-R and read this before posting a question.

    Please put your OMV system details in your signature.
    Please don't PM for support... Too many PMs!

  • What is the output of: sudo cat /etc/mysql/debian.cnf

    I apologize for not getting back to you sooner. I've been on vacation.

    • Offizieller Beitrag

    I apologize for not getting back to you sooner. I've been on vacation

    And we have finally found your problem. This is what the file should look like:


    omv 7.0.4-2 sandworm | 64 bit | 6.5 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.10 | compose 7.1.2 | k8s 7.0-6 | cputemp 7.0 | mergerfs 7.0.3


    omv-extras.org plugins source code and issue tracker - github


    Please try ctrl-shift-R and read this before posting a question.

    Please put your OMV system details in your signature.
    Please don't PM for support... Too many PMs!

Jetzt mitmachen!

Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!