MyWebSQL : Unable to connect

    • OMV 4.x
    • Resolved
    • MyWebSQL : Unable to connect

      Hi,

      Since i updated OMV to 4.0 (4.0.5-1 exactly), i can't connect to mysql with mywebsql ("database connection failed to the server"), but in shell with "mysql -u root -p", it's working.

      So i've tried to uninstall all the Mysql components :

      dpkg -l | grep -i mysql
      mkdir -p /var/lib/mywebsql
      apt-get remove --purge mysql\*
      apt-get clean
      rm -R /var/lib/mysql
      rm -R /etc/mysql
      dpkg -l | grep -i mysql
      And then reinstall the plugin with the OMV WebGUI, but no result.

      I think that the "Reset password" in the OMV webgui not work because in "/etc/mysql/debian.cnf" the root password is always empty.

      My config is default : 127.0.0.1 / 3306.

      Any idea ?
      OMV 4.0.14-1
      omvextrasorg + Deluge + MiniDLNA + MySQL + Nginx + Nextcloud 12
      Pentium G4600 | Asrock H170M-ITX/AC | 4Go DDR4 | 120Go SSD + 6To RAID5 | Kolink Satellite | 400W Lepa
    • I will have to look at this. The switch to php7 may be causing issues. We may also be missing something that happens in the upgrade process.
      omv 4.1.6 arrakis | 64 bit | 4.16 backports kernel | omvextrasorg 4.1.7
      omv-extras.org plugins source code and issue tracker - github.com/OpenMediaVault-Plugin-Developers

      Please read this before posting a question.
      Please don't PM for support... Too many PMs!
    • Thank you for your work and your time.

      For the moment MySQL is just a my DB for nextcloud. So i worked with shell, just create a database for nextcloud and grant permissions to root with a password :

      CREATE DATABASE nextcloud;

      GRANT ALL PRIVILEGES ON nextcloud.* TO 'root'@'localhost' IDENTIFIED BY '***password***';
      And it works.
      OMV 4.0.14-1
      omvextrasorg + Deluge + MiniDLNA + MySQL + Nginx + Nextcloud 12
      Pentium G4600 | Asrock H170M-ITX/AC | 4Go DDR4 | 120Go SSD + 6To RAID5 | Kolink Satellite | 400W Lepa
    • MyWebSQL is working fine with the new MySQL 4.1.1 Plugin ;)

      Thanks for this fast job !
      OMV 4.0.14-1
      omvextrasorg + Deluge + MiniDLNA + MySQL + Nginx + Nextcloud 12
      Pentium G4600 | Asrock H170M-ITX/AC | 4Go DDR4 | 120Go SSD + 6To RAID5 | Kolink Satellite | 400W Lepa