MYSQL Management not working

  • Hello its me again ...


    Installed a clean 0.5 and upgraded to 0.6, then installed MYSQL plugin.


    The error im getting when trying to save MYSQL is:
    No log or clue at all.
    The if i check Managent:



    I already followed what tekkebebe mentioned:


    But still nothing :(
    Result is:

    Code
    ii  libdbd-mysql-perl                  4.021-1+b1                    amd64        Perl5 database interface to the MySQL database
    ii  libmysqlclient18:amd64             5.5.37-0+wheezy1              amd64        MySQL database client library
    ii  mysql-client-5.5                   5.5.37-0+wheezy1              amd64        MySQL database client binaries
    ii  mysql-common                       5.5.37-0+wheezy1              all          MySQL database common files, e.g. /etc/mysql/my.cnf
    ii  mysql-server                       5.5.37-0+wheezy1              all          MySQL database server (metapackage depending on the latest version)
    ii  mysql-server-5.5                   5.5.37-0+wheezy1              amd64        MySQL database server binaries and system database setup
    ii  mysql-server-core-5.5              5.5.37-0+wheezy1              amd64        MySQL database server binaries
    ii  openmediavault-mysql               1.0.5.2                       all          MySQL plugin for OpenMediaVault
    ii  php5-mysqlnd                       5.4.4-14+deb7u12              amd64        MySQL module for php5 (Native Driver)
  • Hi tekkebebe


    I enabled MYSQL in webGUI.


    service mysql start:

    Code
    root@myNAS:~# service mysql start
    Starting MySQL database server: mysqld already running.


    service mysql restart:

    Code
    root@myNAS:~# service mysql restart
    root@myNAS:~# service mysql restart
    Stopping MySQL database server: mysqld.
    Starting MySQL database server: mysqld ..
    Checking for tables which need an upgrade, are corrupt or were 
    not closed cleanly..


    service mysql status:

    • Offizieller Beitrag

    What is the output of:


    dpkg -l | grep mywebsql

    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!

  • Hi ryecoaaron


    dpkg -l | grep mywebsql:

    Code
    root@myNAS:~# dpkg -l | grep mywebsql
    ii  mywebsql                           3.4-omv1                      all          MyWebSQL



    This from syslog if it matters:

    • Offizieller Beitrag

    Is mysql working or is it just the management page that is not working? None of your pics are showing.

    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!

  • i cant be sure in MYSQLis working. If i base it on "service mysql status" then i guess its working.


    Here is the funny pary... when i install Wordpress, it also gives me same result about:



    I think it has something to do with nginx. But if i:
    service nginx restart

    Code
    root@myNAS:~# service nginx status
    nginx is running.


    service nginx status:

    Code
    root@myNAS:~# service nginx status
    nginx is running.
    • Offizieller Beitrag

    If you ever want to check mysql, just:


    mysql -u root -p

    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

    Did you reboot?

    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

    Just update the plugin (1.0.5.3) so the show tab checkbox is disabled when management is unchecked.

    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!

  • I rebooted and cleared cache on my browser. now it works :)


    I dont know what fixed it but i think it has something to do by enabling SQL management site and restart.
    10.10.10.2 works here but il use 127.0.0.1.


    i didnt check SQL Management because i dont have to, back in 0.5
    now i checked both :)


    Thank You so much guys for the assistance (as always). Il tinker this 0.6 more and il see if il encounter any more issues.
    Again THANK YOU :)

    • Offizieller Beitrag

    It seems like nginx does better with a restart then reload. The plugin is doing a reload. That is why rebooting probably helped.


    That error is a communication error. Nothing to worry about.


    Just a note, the non-IE users can't see your tiff screenshots. jpegs would be a better idea :)

    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!

  • I have SQL web interface error 404.
    mysql working but when I want enter to sqll web intefrace i get error 404.


    I checked the Nginx configurations. There is no entry for the mywebsql

    I know that the world does not expect the us to many. It is sufficient that you answer yourself a very important question: what I like to do in life, and then start to do it.


    HP N36L Microserver 60GB SSD + 2x 250GB HDD + 2x 1TB omv 3.0.X 64 bit - 3.16 backport kernel
    Banana Pi + 16GB SD + 500GB - test platform omv 3.0.X - ARM - 3.4.104 kernel
    Banana PRO + 8GB SD + 320GB - test platform omv 30..X - ARM - 3.4.104 kernel
    SimpleNAS project - OpenMediaVault and Case for Banana Pi/PRO/M1/M1+/M3, LM Guitar

    Einmal editiert, zuletzt von cyryllo ()

Jetzt mitmachen!

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