MyWebSQL : Unable to connect

    • OMV 4.x
    • Resolved

    This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

    • 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.12 arrakis | 64 bit | 4.15 proxmox kernel | omvextrasorg 4.1.11
      omv-extras.org plugins source code and issue tracker - github

      Please read this before posting a question and this and this for docker questions.
      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