[RESOLVED] Mysql Plugin not working

1. offizieller Beitrag

    Hi,


    I'm having trouble getting the mysql plugin to work. I had mysql installed before and after uninstalling and then installing the plugin I get this error.

    Code
    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 syslog says:


    Seems like some wierd permissions problem. But I've tried a lot of things now, like completly removing mysql and any files related to it rebooting and then installing again, changing permissions of the mysql-data folder, nothing has worked so far.

    Please read the forum rules and then post a little bit more data since it's hard to help without enough information. It would help to narrow it down.

    Make sure you delete the mysql user when you uninstall. Uninstall everything again. Then:


    userdel mysql


    Then try to reinstall everything via the plugin. Sometimes when you uninstall services the user is not deleted. Upon reinstall there is some type of mismatch and the service will not work with the old user from the prior installation.

    Zitat von "tekkbebe"

    Make sure you delete the mysql user when you uninstall. Uninstall everything again. Then:


    userdel mysql


    Then try to reinstall everything via the plugin. Sometimes when you uninstall services the user is not deleted. Upon reinstall there is some type of mismatch and the service will not work with the old user from the prior installation.


    Did that and then installed via ssh, here is what it looks like:


    It looks like there are some files that are not created during the install process.

    • Offizieller Beitrag

    What is the output of:


    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.4 | 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!

    • Offizieller Beitrag

    ls -al /var/lib/mysql/

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

    plugins :: omvextrasorg 7.0 | kvm 7.0.13 | compose 7.1.4 | 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"

    ls -al /var/lib/mysql/


    Code
    root@omv:~# ls -al /var/lib/mysql/
total 20496
drwx------  3 mysql mysql     4096 Dec  6 16:17 .
drwxrwsr-x 52 mysql mysql     4096 Dec  6 16:17 ..
-rw-r--r--  1 root  root         0 Dec  6 16:17 debian-5.1.flag
-rw-rw----  1 mysql mysql 10485760 Dec  6 16:17 ibdata1
-rw-rw----  1 mysql mysql  5242880 Dec  6 16:17 ib_logfile0
-rw-rw----  1 mysql mysql  5242880 Dec  6 16:17 ib_logfile1
drwx------  2 mysql root      4096 Dec  6 16:17 mysql
-rw-r-----  1 mysql root       789 Dec  6 16:17 omv.err
    • Offizieller Beitrag

    try


    chown -R mysql:mysql /var/lib/mysql


    and then restart mysql


    /etc/init.d/mysql restart

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

    plugins :: omvextrasorg 7.0 | kvm 7.0.13 | compose 7.1.4 | 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!

    Now it looks like this.

    Code
    root@omv:~# chown -R mysql:mysql /var/lib/mysql
root@omv:~# /etc/init.d/mysql restart
Stopping MySQL database server: mysqld.
/etc/init.d/mysql: WARNING: /etc/mysql/my.cnf cannot be read. See README.Debian.gz ... (warning).
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
root@omv:~# ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)
    • Offizieller Beitrag

    I think you need to purge the mysql plugin and remove the /var/lib/mysql directory.

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

    plugins :: omvextrasorg 7.0 | kvm 7.0.13 | compose 7.1.4 | 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!

    Okay, purged mysql.


    Removed /var/lib/mysql

    Code
    rm -rf /var/lib/mysql


    And then reinstalled.


    Looks fine so far. Went to the Mysql tab, was already enabled, slected data dir, enabled web management, hit save and apply. Got this error.

    Code
    Failed to execute command 'sudo omv-mkconf mysql 2>&1': Enabling site openmediavault-mysql-management-site. Run '/etc/init.d/apache2 reload' to activate new configuration! Reloading web server config: apache2. Stopping MySQL database server: mysqld. Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
    • Offizieller Beitrag

    Good to hear :)

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

    plugins :: omvextrasorg 7.0 | kvm 7.0.13 | compose 7.1.4 | 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!

Jetzt mitmachen!

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

Benutzerkonto erstellen Anmelden