MySQL GUI is broken.

  • Guys,


    My webserver is working fine, and I can log in as root via mysql -u root -p.
    But when I click 'Show' in MysQL plug-in's page, it said 'File not found. '
    I've tried disabled/enabled the plugin.


    How do I fix this?



    Code
    ps ax | grep myql
    12516 pts/0    S+     0:00 grep myql


    Code
    sudo netstat -tulpen |grep mysql
    tcp        0      0 0.0.0.0:3306            0.0.0.0:*               LISTEN      114        1830454     23067/mysqld


    Code
    mysqladmin -u root -p status
    Uptime: 520  Threads: 1  Questions: 513  Slow queries: 0  Opens: 218  Flush tables: 1  Open tables: 211  Queries per second avg: 0.986

    OMV v5.0
    Asus Z97-A/3.1; i3-4370
    32GB RAM Corsair Vengeance Pro

    3 Mal editiert, zuletzt von tinh_x7 ()

  • I just checked on my system: MySQL Admin Page works as expected.
    If I change the switch enable management site to false, the show button is disabled immedeately. No I save and apply it. The show button is disabled.
    Now I can provoke the error:
    set the switch to enable management site to true -> show button gets enabled. Pressing it, results in a 404 page by nginx.
    Saving and applying it restores the admin page without errors.


    I don't know if this happened in you case, but maybe it gives a hint how to solve it.

    If you got help in the forum and want to give something back to the project click here (omv) or here (scroll down) (plugins) and write up your solution for others.

    • Offizieller Beitrag

    It was removed quite a while ago. This just means the database is stored on the OS drive unless you put the datadir option in extra options.

    omv 7.0-32 sandworm | 64 bit | 6.5 proxmox kernel

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

  • I didn't know that.
    The database is working fine.
    How do I access to its GUI?
    When I click on 'Show', it said "File Not Found".

    OMV v5.0
    Asus Z97-A/3.1; i3-4370
    32GB RAM Corsair Vengeance Pro

    • Offizieller Beitrag

    Do you have enable management enabled? What is the output of: dpkg -l | grep myweb

    omv 7.0-32 sandworm | 64 bit | 6.5 proxmox kernel

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

  • Code
    dpkg -l | grep myweb
    ii  mywebsql                            3.6-omv4                       all          Web-based database manager for MySQL, SQLite and PostgreSQL.


    Code
    ps ax | grep '[m]ysqld'
     3294 ?        S      0:00 /bin/sh /usr/bin/mysqld_safe
     3731 ?        Sl     0:09 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
     3732 ?        S      0:00 logger -t mysqld -p daemon.error
    • Offizieller Beitrag

    Disable web managerment and save/apply.
    Enable web management and save/apply.

    omv 7.0-32 sandworm | 64 bit | 6.5 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.9 | compose 7.0.9 | 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

    You were enabling an nginx site when enabling the management interface. This always restarts nginx causing the error. Annoying but harmless. Does the management interface work now?

    omv 7.0-32 sandworm | 64 bit | 6.5 proxmox kernel

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

  • My Nginx web servers are running while I enabling it.
    No MySQL GUI yet.


    Do you think the Seafile config has something with MySQL?


    OMV v5.0
    Asus Z97-A/3.1; i3-4370
    32GB RAM Corsair Vengeance Pro

    Einmal editiert, zuletzt von tinh_x7 ()

    • Offizieller Beitrag

    I doubt the init script does. Something else might be conflicting.

    omv 7.0-32 sandworm | 64 bit | 6.5 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.9 | compose 7.0.9 | 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

    After seeing all the trouble people go through to install seafile, I have no idea where to look for a problem.

    omv 7.0-32 sandworm | 64 bit | 6.5 proxmox kernel

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

  • Removing this will not help, as it only relates to the mysql demon wich os running.
    Can you post your nginx configuration and check var/log/nginx log files

    If you got help in the forum and want to give something back to the project click here (omv) or here (scroll down) (plugins) and write up your solution for others.

  • Yes nginx is the web server serving the gui and it is the one showing file not found.

    If you got help in the forum and want to give something back to the project click here (omv) or here (scroll down) (plugins) and write up your solution for others.

Jetzt mitmachen!

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