Also MySQL Problem with OMV 1.x

  • NO, for all changes made in web interface I will received:
    Error
    #4000:
    exception 'OMVException' with message 'Failed to execute command 'export
    LANG=C; invoke-rc.d 'mysql' stop 2>&1': Stopping MySQL database
    server: mysqld failed!
    invoke-rc.d: initscript mysql, action "stop" failed.' in
    /usr/share/php/openmediavault/initscript.inc:176


    and also I can't access SQL management site

    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

  • sorry, which user?

    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

  • in Services TAB, I CAN SEE MySQL running!!!!

    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

  • Yeah exactly, debian-sys-maint is used for the init scripts.


    Did you try GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY '***********'; again by the way?


    If I recall correctly I had an issue with MySQL not being able to stop either, and that was because of debian-sys-maint. So you first have to run that command and then kill the process(?) or restart the server. Don't really remember sadly.

  • @HK
    huray, now it works!


    guys, thank you very much

    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, the SQL Management site works now!!!!


    again, many 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

  • Hi hunt3rus,


    i did your code


    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


    here the Output:



    and what i am doing now?


    Thanks!
    Eddy

  • hello,


    please try:

    Code
    apt-get clean
    apt-get update
    apt-get -f install


    and try to reinstall the MySQL 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

  • still have the same problem...


    output of the webinterface


    please help me ... :/


    Eddy

  • i have not linux or mysql skills but i'll try to help you based on my little experience.


    can you give me the outputs:

    Code
    dpkg -l | grep mysql


    and

    Code
    service mysql status


    and
    tell me if you see on web interface, on Services, iff the MySQL is running.

    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

  • Code
    dpkg -l | grep mysql



    Code
    service mysql status



    if I get to Services, i got this Message in a window



    Thanks!
    Eddy

  • if i understood correctly, your mysql server is not running.
    try to start or restart the mysql server:

    Code
    service mysql start

    or

    Code
    service mysql restart


    for:

    Code
    dpkg -l | grep mysql

    we have the same output

    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

  • Yes the Problem ist it cant start... i dont know why...


    service mysql start


  • try:

    Zitat

    mysql_upgrade -u root -p

    (but I suppose that command will work only if the mysql server is up)

    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

Jetzt mitmachen!

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