OMV 1.x MySQL will not work

  • Hey,


    I've just installed OMV Kralizec.
    First I installed a clean Wheezy 7.6 without any packages, then Openmediavault. Version is 1.0.16.


    Then I installed the mySQL Plugin (V 1.0.5.4 vom omv-extras.org/kralizec/stable)


    But mySQL will not work!


    What have I done?


    Plugin-Settings:
    - Activated mySQL
    - Selected the SQL-Data Disk (I've selected not the System-Disk).
    - Activated the Management-Site
    - Reset the root-Password


    Port and Host-IP at default (3306 & 127.0.0.1 for localhost)


    Then saved the Settings and applied.


    During OMV tries to Apply my Settings I get an Error-Message with following Text:


    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.


    tried via console:


    Code
    root@C0mmanda-Server:~# service mysql status
    
    
    MySQL is stopped..


    Code
    root@C0mmanda-Server:~# service mysql start
    
    
    Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!


    Code
    root@C0mmanda-Server:~# mysql -u root -p
    
    
    Enter password: 
    
    
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)



    Tried to reboot, I think I uninstalled and installed the mySQL Plugin at least 20 times.. It wont work!
    I really need mySQL, has anybody an idea?


    Thank you very much!


    grtz
    CmdA

  • Have a look at /var/log/mysql.log and /var/log/mysql.err.


    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!

  • Externer Inhalt www.youtube.com
    Inhalte von externen Seiten werden ohne Ihre Zustimmung nicht automatisch geladen und angezeigt.
    Durch die Aktivierung der externen Inhalte erklären Sie sich damit einverstanden, dass personenbezogene Daten an Drittplattformen übermittelt werden. Mehr Informationen dazu haben wir in unserer Datenschutzerklärung zur Verfügung gestellt.


    :thumbup:

    If you could just go ahead and make a plugin for it, that'd be great.
    N54L/4GB/12TB

    • Offizieller Beitrag

    The plugin doesn't change my.cnf because the settings in /etc/mysql/conf.d/openmediavault-mysql.cnf will override it.


    What is the output of: cat /etc/mysql/conf.d/openmediavault-mysql.cnf

    omv 7.0.4-2 sandworm | 64 bit | 6.5 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.10 | compose 7.1.2 | k8s 7.0-6 | cputemp 7.0 | mergerfs 7.0.3


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


    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!

  • uncomment

    Code
    #general_log_file = /var/log/mysql/mysql.log 
    #general_log = 1


    to

    Code
    general_log_file = /var/log/mysql/mysql.log
    general_log = 1


    try to start mysql, have a look in the logs, copy n paste them to privatepaste.com and post the link please.

    If you could just go ahead and make a plugin for it, that'd be great.
    N54L/4GB/12TB

  • I would start by running mysql in the foreground to see what it says. mysqld_safe


    Sorry, I don't get it... this way?

    Code
    root@C0mmanda-Server:/etc/mysql# mysqld_safe
    140907 20:40:23 mysqld_safe Logging to syslog.
    140907 20:40:23 mysqld_safe Starting mysqld daemon with databases from /media/35977993-cdac-43a2-b130-fe9f293ebf8e/mysql-data
    140907 20:40:26 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
    root@C0mmanda-Server:/etc/mysql#


    The plugin doesn't change my.cnf because the settings in /etc/mysql/conf.d/openmediavault-mysql.cnf will override it.


    What is the output of: cat /etc/mysql/conf.d/openmediavault-mysql.cnf



    uncomment

    Code
    #general_log_file = /var/log/mysql/mysql.log 
    #general_log = 1


    to

    Code
    general_log_file = /var/log/mysql/mysql.log
    general_log = 1


    try to start mysql, have a look in the logs, copy n paste them to privatepaste.com and post the link please.


    No need for privatepaste:


    Code
    root@C0mmanda-Server:/var/log/mysql# cat mysql.log
    /usr/sbin/mysqld, Version: 5.5.38-0+wheezy1-log ((Debian)). started with:
    Tcp port: 3306  Unix socket: /var/run/mysqld/mysqld.sock
    Time                 Id Command    Argument
    
    
    /usr/sbin/mysqld, Version: 5.5.38-0+wheezy1-log ((Debian)). started with:
    Tcp port: 3306  Unix socket: /var/run/mysqld/mysqld.sock
    Time                 Id Command    Argument
    root@C0mmanda-Server:/var/log/mysql#


    I've grep'ed mysql from syslog, maybe it will help...


    http://privatepaste.com/9ad1a378c1



    I'm really confused that mySQL is so messed up because it was one of the very first plugins I installed on a absolutely clean machine...


    grtz

    • Offizieller Beitrag

    What is the output of: ls -al /media/35977993-cdac-43a2-b130-fe9f293ebf8e/mysql-data/

    omv 7.0.4-2 sandworm | 64 bit | 6.5 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.10 | compose 7.1.2 | k8s 7.0-6 | cputemp 7.0 | mergerfs 7.0.3


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


    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

    None of the databases are in the data directory. That is why it won't start. While you uninstalled and reinstalled the plugin, that doesn't help the database issue. Try: apt-get install --reinstall mysql-server

    omv 7.0.4-2 sandworm | 64 bit | 6.5 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.10 | compose 7.1.2 | k8s 7.0-6 | cputemp 7.0 | mergerfs 7.0.3


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


    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!

  • unfortunately reinstall changed nothing.
    mySQL is still not starting.


    Is there another way to get the Databases?


    //EDIT


    created the Databases with mysql_install_db but it helped not so much...
    mySQL seems to run, but i have no access via WebGUI...

Jetzt mitmachen!

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