MySQL Install / Uninstall issue

1st Official Post

    Trying to uninstall / re-install MySQL via plugin.


    Uninstall error:



    Then see the following error on plugin install:


    Then if enbled...

    • Official Post

    The first error is a browser cache and/or nginx restarting error. Clear your browser cache. nginx restarting error is nothing to worry about.


    Bad gateway is probably a nginx restarting error.


    Last box shows the plugin installed fine but the database is missing. Do you have any existing databases? If not, try (as root): mysql_install_db

    omv 8.0.10-2 synchrony | 6.17 proxmox kernel

    plugins :: omvextrasorg 8.0.2 | kvm 8.0.6 | compose 8.1.3 | cterm 8.0 | borgbackup 8.1.5 | cputemp 8.0 | mergerfs 8.0 | scripts 8.0.1 | writecache 8.1


    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!

    Thanks. Cleared cache but same outcome. Used alternative browser, same again.
    Followed you instruction to create dbs..



    Enabling the service..

    • Official Post

    What options do you have in extra options?

    omv 8.0.10-2 synchrony | 6.17 proxmox kernel

    plugins :: omvextrasorg 8.0.2 | kvm 8.0.6 | compose 8.1.3 | cterm 8.0 | borgbackup 8.1.5 | cputemp 8.0 | mergerfs 8.0 | scripts 8.0.1 | writecache 8.1


    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!

    • Official Post

    You must have had a database installed at /media/26ca4497-4a5c-47d3-80cc-1ff71b99321c/MySQL/ previously though. I recommend purging the plugin, mysql, and users. I would also remove the /var/lib/mysql dir if it exists and /etc/mysql.

    omv 8.0.10-2 synchrony | 6.17 proxmox kernel

    plugins :: omvextrasorg 8.0.2 | kvm 8.0.6 | compose 8.1.3 | cterm 8.0 | borgbackup 8.1.5 | cputemp 8.0 | mergerfs 8.0 | scripts 8.0.1 | writecache 8.1


    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!

    Removed plugin (which should purge mysql?). Not sure how to delete users?
    deleted /var/lib/mysql & /etc/mysql


    Installed plugin..



    Tried changing data directory & bind address, saved:


    enabling the service..

    • Official Post

    removing the plugin might not purge the plugin. I would purge individually and check output of dpkg -l to verify that it isn't just removed. Removing the config files is important too.

    omv 8.0.10-2 synchrony | 6.17 proxmox kernel

    plugins :: omvextrasorg 8.0.2 | kvm 8.0.6 | compose 8.1.3 | cterm 8.0 | borgbackup 8.1.5 | cputemp 8.0 | mergerfs 8.0 | scripts 8.0.1 | writecache 8.1


    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!

    Thanks, sadly im not a linux expert. But managed to purge a few with SQL references but not all.


    root@OMV:~# dpkg --purge mysql-common
    dpkg: dependency problems prevent removal of mysql-common:
    mysql-client-5.5 depends on mysql-common (>= 5.5.44-0+deb7u1).
    libmysqlclient18:amd64 depends on mysql-common (>= 5.5.44-0+deb7u1).


    root@OMV:~# dpkg --purge mysql-client-5.5
    (Reading database ... 32030 files and directories currently installed.)
    Removing mysql-client-5.5 ...
    Processing triggers for man-db ...


    root@OMV:~# dpkg --purge mysql-common
    dpkg: dependency problems prevent removal of mysql-common:
    libmysqlclient18:amd64 depends on mysql-common (>= 5.5.44-0+deb7u1).
    dpkg: error processing mysql-common (--purge):
    dependency problems - not removing
    Errors were encountered while processing:
    mysql-common


    root@OMV:~# dpkg --purge mysql-server-5
    dpkg: warning: ignoring request to remove mysql-server-5 which isn't installed
    root@OMV:~#


    root@OMV:~# dpkg --purge mysql-server-c
    dpkg: warning: ignoring request to remove mysql-server-c which isn't installed
    root@OMV:~#


    root@OMV:~# dpkg --purge mywebsql
    (Reading database ... 31975 files and directories currently installed.)
    Removing mywebsql ...
    Purging configuration files for mywebsql ...
    rm: cannot remove `/var/lib/mywebsql': No such file or directory
    dpkg: error processing mywebsql (--purge):
    subprocess installed post-removal script returned error exit status 1
    Errors were encountered while processing:
    mywebsql

    Now installing the plugin error as below..


    http://txt.do/a3ro7

    Then tried this .. apt-get -f install
    Now installs ok
    But when try to enable...
    Error #4000:
    exception 'OMVException' with message 'Failed to execute command 'omv-mkconf mysql 2>&1': Unable to get current database location.' in /usr/share/openmediavault/engined/module/mysql.inc:88
    Stack trace:
    #0 /usr/share/openmediavault/engined/rpc/config.inc(180): 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/php/openmediavault/rpcservice.inc(158): OMVRpcServiceAbstract->callMethod('applyChanges', Array, Array)
    #4 /usr/share/openmediavault/engined/rpc/config.inc(224): OMVRpcServiceAbstract->callMethodBg('applyChanges', Array, Array)
    #5 [internal function]: OMVRpcServiceConfig->applyChangesBg(Array, Array)
    #6 /usr/share/php/openmediavault/rpcservice.inc(125): call_user_func_array(Array, Array)
    #7 /usr/share/php/openmediavault/rpc.inc(79): OMVRpcServiceAbstract->callMethod('applyChangesBg', Array, Array)
    #8 /usr/sbin/omv-engined(500): OMVRpc::exec('Config', 'applyChangesBg', Array, Array, 1)
    #9 {main}

    • Official Post

    If things don't go as planned, don't keep installing the plugin.


    mkdir -p /var/lib/mywebsql
    apt-get purge mysql* mywebsql
    rm -rfv /etc/mysql


    If dpkg -l | grep mysql returns nothing then install again. if not, don't install the plugin and post the output.

    omv 8.0.10-2 synchrony | 6.17 proxmox kernel

    plugins :: omvextrasorg 8.0.2 | kvm 8.0.6 | compose 8.1.3 | cterm 8.0 | borgbackup 8.1.5 | cputemp 8.0 | mergerfs 8.0 | scripts 8.0.1 | writecache 8.1


    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!

    Like 1

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login