Also MySQL Problem with OMV 1.x

  • Hello everybody i hope you can help me. :)


    I had updated OMV to the newest Version 1.x a few days ago. Since that i having problems with MySQL. First i tried reboot, first aid ala Windows ;D Next I tried to uninstall mysql and install it again. I found under OMV 1.x MySQL will not work some comands like apt-get remove --purge /*paketname*/. Removing was sucsessful, but I tried to install it over the webinterface again and get this error:




    everything is up-to-date (apt-get update etc.)


    Hopefully you can help me. I cant find any Logfiles... :/


    Best Regards
    Eddy


    P.S. Sorry about my bad English...

  • Since it is already fragged...


    dpkg -l | grep mysql


    write down all the packages that are installed from the list.
    purge the plugin if it is install: apt-get --purge remove openmediavault-mysql
    remove all the packages from the list
    reinstall all the packages from the list
    then reinstall the plugin and enable.

  • hello,


    i'm on OMV 10.0.21 (fresh install), I made everything what you say above, and now I'm not able to install MySQL 10.0.10 plugin.
    i'm stuck on:

    Code
    Reading package lists...
    Building dependency tree...


    thanks for you support.

    The Power of the Power Button!
    OMV 4.x // Hardware: HP N36L Microserver (BIOS mod), 4GB RAM, 2x1TB WD Red + 2x2TB ST, 160GB for OMV

    OMV 5.x // Hardware: HP Microserver Gen8, 4GB RAM, 2x4TB WD + 2x2TB ST, 160GB for OMV

  • also, after removing all the packages from the list, these packages are still on the server.




    thanks.

    The Power of the Power Button!
    OMV 4.x // Hardware: HP N36L Microserver (BIOS mod), 4GB RAM, 2x1TB WD Red + 2x2TB ST, 160GB for OMV

    OMV 5.x // Hardware: HP Microserver Gen8, 4GB RAM, 2x4TB WD + 2x2TB ST, 160GB for OMV

  • It's OK, I was able to install the MySQL plugin.


    thanks again, your support is awesome.


    can I reuse the old database location?

    The Power of the Power Button!
    OMV 4.x // Hardware: HP N36L Microserver (BIOS mod), 4GB RAM, 2x1TB WD Red + 2x2TB ST, 160GB for OMV

    OMV 5.x // Hardware: HP Microserver Gen8, 4GB RAM, 2x4TB WD + 2x2TB ST, 160GB for OMV

  • also, if I change the Bind Address I received:


    Code
    root@HPNAS:~# service mysql status
    /usr/bin/mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
    .
    root@HPN


    and I don't know what to do.

    The Power of the Power Button!
    OMV 4.x // Hardware: HP N36L Microserver (BIOS mod), 4GB RAM, 2x1TB WD Red + 2x2TB ST, 160GB for OMV

    OMV 5.x // Hardware: HP Microserver Gen8, 4GB RAM, 2x4TB WD + 2x2TB ST, 160GB for OMV

    Edited once, last by hunt3rus ().

  • no problem. I can wait.
    even so, your support is great for OMV community.

    The Power of the Power Button!
    OMV 4.x // Hardware: HP N36L Microserver (BIOS mod), 4GB RAM, 2x1TB WD Red + 2x2TB ST, 160GB for OMV

    OMV 5.x // Hardware: HP Microserver Gen8, 4GB RAM, 2x4TB WD + 2x2TB ST, 160GB for OMV

  • thanks HK, I will try tonight when I will be home


    i will send you feedback....

    The Power of the Power Button!
    OMV 4.x // Hardware: HP N36L Microserver (BIOS mod), 4GB RAM, 2x1TB WD Red + 2x2TB ST, 160GB for OMV

    OMV 5.x // Hardware: HP Microserver Gen8, 4GB RAM, 2x4TB WD + 2x2TB ST, 160GB for OMV

  • Hi tekkb thanks for answering


    i have tried your workaround but it dont works...


    after unistall all packages, I have reinstalled everything again



    then I go to the Webinterface and tried to install the Plugin...




    and now if you go to "Services" and MySQL you got this Error:


    Code
    Error #3003:
    exception 'OMVException' with message 'Failed to get configuration (xpath=//services/mysql)' in /usr/share/openmediavault/engined/rpc/mysql.inc:68
    Stack trace:
    #0 [internal function]: OMVRpcServiceMySQL->getSettings(NULL, Array)
    #1 /usr/share/php/openmediavault/rpcservice.inc(125): call_user_func_array(Array, Array)
    #2 /usr/share/php/openmediavault/rpc.inc(79): OMVRpcServiceAbstract->callMethod('getSettings', NULL, Array)
    #3 /usr/sbin/omv-engined(501): OMVRpc::exec('MySql', 'getSettings', NULL, Array, 1)
    #4 {main}



    I need a MySQL-Server... pls help me! ;)



    Big Thanks and best regards!
    Eddy

  • No, the same access denied....


    and the same error


    other idea?

    The Power of the Power Button!
    OMV 4.x // Hardware: HP N36L Microserver (BIOS mod), 4GB RAM, 2x1TB WD Red + 2x2TB ST, 160GB for OMV

    OMV 5.x // Hardware: HP Microserver Gen8, 4GB RAM, 2x4TB WD + 2x2TB ST, 160GB for OMV

    Edited 2 times, last by HK-47: Remove password. ().

  • No, the same access denied....

    Code
    * snip *


    and the same error

    Code
    * snip *


    other idea?


    Hm.. That usually works for the "Access denied for user 'debian-sys-maint'@'localhost'" issue. Maybe there's not even any debian-sys-maint user? You could try checking by logging in to MySQL and running SELECT User FROM mysql.user;. Otherwise I would suggest searching for "Access denied for user 'debian-sys-maint'@'localhost'" on the search engine of your choice. :) Hope this helps!


    Also, I removed the password from your post. Try to avoid posting them in the future for your own good.

  • I did:


    is something wrong in my typo?


    thanks.

    The Power of the Power Button!
    OMV 4.x // Hardware: HP N36L Microserver (BIOS mod), 4GB RAM, 2x1TB WD Red + 2x2TB ST, 160GB for OMV

    OMV 5.x // Hardware: HP Microserver Gen8, 4GB RAM, 2x4TB WD + 2x2TB ST, 160GB for OMV

  • what I don't understand is that I can uninstall/install the MySQL plugin, but if I change something on web interface everything goes wrong with this plugin.

    The Power of the Power Button!
    OMV 4.x // Hardware: HP N36L Microserver (BIOS mod), 4GB RAM, 2x1TB WD Red + 2x2TB ST, 160GB for OMV

    OMV 5.x // Hardware: HP Microserver Gen8, 4GB RAM, 2x4TB WD + 2x2TB ST, 160GB for OMV

  • I used:

    Code
    apt-get --purge remove libmysqlclient18:amd64
    apt-get --purge remove mysql-client-5.5
    apt-get --purge remove mysql-common
    apt-get --purge remove mysql-server
    apt-get --purge remove mysql-server-5.5
    apt-get --purge remove mysql-server-core-5.5
    apt-get --purge remove php5-mysqlnd


    --------------------------------------
    guys, you are so dedicated.... it is incredible...

    The Power of the Power Button!
    OMV 4.x // Hardware: HP N36L Microserver (BIOS mod), 4GB RAM, 2x1TB WD Red + 2x2TB ST, 160GB for OMV

    OMV 5.x // Hardware: HP Microserver Gen8, 4GB RAM, 2x4TB WD + 2x2TB ST, 160GB for OMV

    Edited once, last by hunt3rus ().

Participate now!

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