[SOLVED] can't start mysql plugin

  • my WebGui have a error massage when i activate mysql:
    Failed to execute command 'export LANG=C; invoke-rc.d 'mysql' start 2>&1': Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed! invoke-rc.d: initscript mysql, action "start" failed.
    and more ditels:

    Code
    Fehler #4000: exception 'OMVException' with message 'Failed to execute command 'export LANG=C; invoke-rc.d 'mysql' start 2>&1': Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed! invoke-rc.d: initscript mysql, action "start" failed.' in /usr/share/php/openmediavault/initscript.inc:169 Stack trace: #0 /usr/share/php/openmediavault/initscript.inc(141): OMVSysVInitScript->invoke('start') #1 /usr/share/php/openmediavault/initscript.inc(61): OMVSysVInitScript->start() #2 /usr/share/openmediavault/engined/module/mysql.inc(102): OMVSysVInitScript->exec() #3 /usr/share/openmediavault/engined/rpc/config.inc(194): OMVModuleMySQL->startService() #4 [internal function]: OMVRpcServiceConfig->applyChanges(Array, Array) #5 /usr/share/php/openmediavault/rpcservice.inc(125): call_user_func_array(Array, Array) #6 /usr/share/openmediavault/engined/rpc/config.inc(243): OMVRpcServiceAbstract->callMethod('applyChanges', Array, Array) #7 [internal function]: OMVRpcServiceConfig->applyChangesBg(Array, Array) #8 /usr/share/php/openmediavault/rpcservice.inc(125): call_user_func_array(Array, Array) #9 /usr/share/php/openmediavault/rpc.inc(62): OMVRpcServiceAbstract->callMethod('applyChangesBg', Array, Array) #10 /usr/sbin/omv-engined(495): OMVRpc::exec('Config', 'applyChangesBg', Array, Array, 1) #11 {main}


    sudo invoke-rc.d 'mysql' start can't start it, too


    everybody have a idea?

    omv 6.x | 64 bit | omvextrasorg 6.x |
    used plugins: omv-extras | portainer | rsnapshot | antivirus
    used container: portainer/portainer | nextcloud/all-in-one | linuxserver/swag | paperless-ngx | jellyfin/jellyfin | lmscommunity/logitechmediaserver | adguard/adguardhome |

    Einmal editiert, zuletzt von happyreacer ()

  • Which OMV Version do you use?
    What is the ouput of the following commands?


    Code
    export LANG=C; invoke-rc.d 'mysql' start
    service mysql status
    service mysql restart
    cat /var/log/mysql.err
    cat /var/log/mysql.log


    Greetings
    David

    "Well... lately this forum has become support for everything except omv" [...] "And is like someone is banning Google from their browsers"


    Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.

    Upload Logfile via WebGUI/CLI
    #openmediavault on freenode IRC | German & English | GMT+1
    Absolutely no Support via PM!

  • omv 6.x | 64 bit | omvextrasorg 6.x |
    used plugins: omv-extras | portainer | rsnapshot | antivirus
    used container: portainer/portainer | nextcloud/all-in-one | linuxserver/swag | paperless-ngx | jellyfin/jellyfin | lmscommunity/logitechmediaserver | adguard/adguardhome |

  • Zitat

    action "star" failed


    Thats weird...


    Give me the following outputs:


    Code
    dpkg -l | grep openmediavault-
    dpkg -l | grep mysql
    ls -la /var/log | grep mysql
    ls -la /etc/init.d/apache2
    cat /etc/init.d/apache2


    Greetings
    David

    "Well... lately this forum has become support for everything except omv" [...] "And is like someone is banning Google from their browsers"


    Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.

    Upload Logfile via WebGUI/CLI
    #openmediavault on freenode IRC | German & English | GMT+1
    Absolutely no Support via PM!

  • Levi, you're free to give me the same outputs I asked happy for. From both posts.


    Greetings
    David

    "Well... lately this forum has become support for everything except omv" [...] "And is like someone is banning Google from their browsers"


    Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.

    Upload Logfile via WebGUI/CLI
    #openmediavault on freenode IRC | German & English | GMT+1
    Absolutely no Support via PM!

  • Hi,
    Here is what David asked:


    cat /etc/init.d/apache2


    I wanted to work in the Shell-in-a-box/Terminal window, but it stupid. It doesn't let me paste nothing to the terminal window from the Windows clipboard and copy nothing to the Windows clipboard. Please, make it cleverer.

  • Zitat von "tekkbebe"

    What did you guys do before you had this problem??? Was this a new install of mysql plugin or had it been working for some time then broke? Did you use any scripts to install anything?


    Hi,
    MySQL plugin was worked. I uninstalled plugin and manually deleted mysql-data directory from the data HDD.
    Maybe that's the problem. I installed mysql plugin again and when I enable it doesn't start, always sends the error message.

    • Offizieller Beitrag

    What is the output of:


    dpkg -l | grep openmediavault-mysql

    omv 7.0.5-1 sandworm | 64 bit | 6.8 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.13 | compose 7.1.6 | k8s 7.1.0-3 | cputemp 7.0.1 | mergerfs 7.0.4


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


    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!

  • Aaron, look at his post, he already showed it ^^


    Zitat

    ii openmediavault-mysql 0.5.11 MySQL plugin for OpenMediaVault.


    Greetings
    David

    "Well... lately this forum has become support for everything except omv" [...] "And is like someone is banning Google from their browsers"


    Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.

    Upload Logfile via WebGUI/CLI
    #openmediavault on freenode IRC | German & English | GMT+1
    Absolutely no Support via PM!

    • Offizieller Beitrag

    I thought I read that he uninstalled it again. The reason it probably doesn't work is the mysql user still has the shared folder for a home directory yet the database isn't there. Do this to fix:


    I would backup any databases before doing this.


    apt-get remove --purge openmediavault-mysql
    userdel mysql


    You may have to delete (or move) the directory that you want to be the future database directory. Then reinstall the plugin.

    omv 7.0.5-1 sandworm | 64 bit | 6.8 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.13 | compose 7.1.6 | k8s 7.1.0-3 | cputemp 7.0.1 | mergerfs 7.0.4


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


    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!


  • I am new in MySQl. My data directory wasn't a real database, it was created by plugin. If it had been one I wouldn't have deleted it. I thought if I remove plugin, I can delete the database, too.
    I did the two commands you suggested. I re-installed mysql plugin and when I want to enable it, I get a new error message.

    Code
    Failed to execute command 'sudo omv-mkconf mysql 2>&1': Reloading web server config: apache2. Stopping MySQL database server: mysqld. df: `/media/4c1abcf5-80f4-405c-810c-aef5038e39be/mysql-data/.': No such file or directory df: no file systems processed /etc/init.d/mysql: ERROR: The partition with /media/4c1abcf5-80f4-405c-810c-aef5038e39be/mysql-data is too full! ... failed!
    
    
    Error #4000: exception 'OMVException' with message 'Failed to execute command 'sudo omv-mkconf mysql 2>&1': Reloading web server config: apache2. Stopping MySQL database server: mysqld. df: `/media/4c1abcf5-80f4-405c-810c-aef5038e39be/mysql-data/.': No such file or directory df: no file systems processed /etc/init.d/mysql: ERROR: The partition with /media/4c1abcf5-80f4-405c-810c-aef5038e39be/mysql-data is too full! ... failed!' in /usr/share/openmediavault/engined/module/mysql.inc:84 Stack trace: #0 /usr/share/openmediavault/engined/rpc/config.inc(171): OMVModuleMySQL->applyConfig() #1 [internal function]: OMVRpcServiceConfig->applyChanges(Array, Array) #2 /usr/share/php/openmediavault/rpcservice.inc(125): call_user_func_array(Array, Array) #3 /usr/share/openmediavault/engined/rpc/config.inc(243): OMVRpcServiceAbstract->callMethod('applyChanges', Array, Array) #4 [internal function]: OMVRpcServiceConfig->applyChangesBg(Array, Array) #5 /usr/share/php/openmediavault/rpcservice.inc(125): call_user_func_array(Array, Array) #6 /usr/share/php/openmediavault/rpc.inc(62): OMVRpcServiceAbstract->callMethod('applyChangesBg', Array, Array) #7 /usr/sbin/omv-engined(495): OMVRpc::exec('Config', 'applyChangesBg', Array, Array, 1) #8 {main}
    • Offizieller Beitrag

    What is the output of:


    cat /etc/mysql/conf.d/openmediavault-mysql.cnf
    cat /etc/passwd | grep mysql

    omv 7.0.5-1 sandworm | 64 bit | 6.8 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.13 | compose 7.1.6 | k8s 7.1.0-3 | cputemp 7.0.1 | mergerfs 7.0.4


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


    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!

  • Zitat von "ryecoaaron"

    What is the output of:


    cat /etc/mysql/conf.d/openmediavault-mysql.cnf
    cat /etc/passwd | grep mysql


    cat /etc/mysql/conf.d/openmediavault-mysql.cnf

    Code
    root@omv:~# cat /etc/mysql/conf.d/openmediavault-mysql.cnf
    # Configuration for openmediavault-mysql
    
    
    [mysqld]
    skip-networking
    port = 3306
    bind-address = 127.0.0.1
    datadir = /media/4c1abcf5-80f4-405c-810c-aef5038e39be/mysql-data


    cat /etc/passwd | grep mysql

    Code
    root@omv:~# cat /etc/passwd | grep mysql
    mysql:x:111:114:MySQL Server,,,:/media/4c1abcf5-80f4-405c-810c-aef5038e39be/mysql-data:/bin/false
    • Offizieller Beitrag

    What is the output of:


    ls -al /var/lib/mysql/


    I'm guessing the main mysql database is there. You will most likely have to move it to /media/4c1abcf5-80f4-405c-810c-aef5038e39be/mysql-data

    omv 7.0.5-1 sandworm | 64 bit | 6.8 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.13 | compose 7.1.6 | k8s 7.1.0-3 | cputemp 7.0.1 | mergerfs 7.0.4


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


    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!

  • Zitat von "ryecoaaron"

    What is the output of:


    ls -al /var/lib/mysql/


    I'm guessing the main mysql database is there. You will most likely have to move it to /media/4c1abcf5-80f4-405c-810c-aef5038e39be/mysql-data


    You are right. I copied there the main mysql directory as mysql-data directory. At first, the result was not changed and the same error message remained.
    Therefore, I uninstalled the plugin again and made an autoremove command to delete the unnecessary things left behind.
    I re-installed the mysql plugin and after that the MySQL has worked, restored the basic database.


    But I think after installing the plugin, if there is no mysql-data directory on the user signed HDD, is not an error, but a status.
    It should not stop with an error message. If there is no directory, it automatically creates one with basic data,
    and if there is, but invalid, then alerts the user and waits for his intervention.
    Thank you for your help.

Jetzt mitmachen!

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