[SOLVED] MyWebSQL Login Problem

    • OMV 2.x

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

    • [SOLVED] MyWebSQL Login Problem

      Hi everyone,

      yesterday I installed MySQL plugin and enabled the Web Interface. Then logged into MyWebSQL with User: root and without password successfully. At that time I didn't change any password or any setting. Today I want to log in again. But I couldn't.

      Although I changed the root password of the four users (root@127.0.0.1, root@::1, root@myserver, root@localhost) over terminal (with the help of the page here), I can not log in and get the error message "Datenbank-Verbindung zum Server fehlgeschlagen. Host: localhost, Benutzer: root" (screenshot attached).

      Today I spent several hours for solving this problem but I couldn't. Could you help me please?

      Thank you.
      Images
      • MyWebSQL_Login_Error.png

        12.83 kB, 563×501, viewed 591 times
      HP ProLiant MicroServer Gen8
      OMV 2.2.13 (Stone burner) - Debian GNU/Linux 7 (wheezy)
      Kernel: Linux 3.2.0-4-amd64
      Processor: Intel(R) Celeron(R) CPU G1610T 2.30GHz
      Menory: 4GB RAM

      *********************************************************************

      Nothing is difficult. The impossible just takes time.
    • Hi

      I'm 100% sure you need to update passwords in MySQL database - but sorry, don't know how to do it.
      IMHO fastest option will be remove plugin, purge whole installation and install it once again.

      Never change password for root via terminal if you have any specific services running on it, especially SQL servers.
      Debian 8.6 Jessie + OMV 3.0.latest Kernel: Linux 4.8.0-0.bpo.2-amd64
      Processor: Intel Core 2 Duo E8400@3GHz
      Memory: 4GB RAM
      OS-HDD: Samsung SSD 120 GB +LVM

      Full media and download center configured.

      BIG and special thanks for OMV-Extras team for great plug-ins (especially: TeamSpeak, VirtualBox, Sonarr, Radarr, and rest I use :))

      ------------------------------

      Wise guy don't know everything, he can search or ask!
      Don't ask me via PM!
    • Hi kawu2,

      thank you for your answer.

      I did exactly the same prozess like you said. I removed the whole packages with purge and installed them again. But it didn't solve my problem.

      - I'm 100% sure you need to update passwords in MySQL database -

      I updated root passwords via WebGUI as well as via Terminal mysql.

      Of course you are right, I wouldn't change the root password as well, if I would have any services running on it. But I had no services running with mysql at that time i changed the root passwords.
      HP ProLiant MicroServer Gen8
      OMV 2.2.13 (Stone burner) - Debian GNU/Linux 7 (wheezy)
      Kernel: Linux 3.2.0-4-amd64
      Processor: Intel(R) Celeron(R) CPU G1610T 2.30GHz
      Menory: 4GB RAM

      *********************************************************************

      Nothing is difficult. The impossible just takes time.
    • Did updating passwords resolved you issue ot it is still unresolved?
      If problem is solved please mark thread as [SOLVED] if not we will look further for solution
      Debian 8.6 Jessie + OMV 3.0.latest Kernel: Linux 4.8.0-0.bpo.2-amd64
      Processor: Intel Core 2 Duo E8400@3GHz
      Memory: 4GB RAM
      OS-HDD: Samsung SSD 120 GB +LVM

      Full media and download center configured.

      BIG and special thanks for OMV-Extras team for great plug-ins (especially: TeamSpeak, VirtualBox, Sonarr, Radarr, and rest I use :))

      ------------------------------

      Wise guy don't know everything, he can search or ask!
      Don't ask me via PM!
    • No unfortunately it didn't... :(

      I still get the same error.
      HP ProLiant MicroServer Gen8
      OMV 2.2.13 (Stone burner) - Debian GNU/Linux 7 (wheezy)
      Kernel: Linux 3.2.0-4-amd64
      Processor: Intel(R) Celeron(R) CPU G1610T 2.30GHz
      Menory: 4GB RAM

      *********************************************************************

      Nothing is difficult. The impossible just takes time.
    • Did you tried to use reset password in plugin section/MySQL in top menu (after SAVE RESET options)?

      Also login should be root
      Password for root account
      at Localhost MySQL
      Debian 8.6 Jessie + OMV 3.0.latest Kernel: Linux 4.8.0-0.bpo.2-amd64
      Processor: Intel Core 2 Duo E8400@3GHz
      Memory: 4GB RAM
      OS-HDD: Samsung SSD 120 GB +LVM

      Full media and download center configured.

      BIG and special thanks for OMV-Extras team for great plug-ins (especially: TeamSpeak, VirtualBox, Sonarr, Radarr, and rest I use :))

      ------------------------------

      Wise guy don't know everything, he can search or ask!
      Don't ask me via PM!
    • As I wrote at the first message, I tried it as well but it didn't work.

      When I try to login root with a wrong password, it appears an error message like "login or password is false" or something like that. The login and password input fields don't disappear and the system requires the password again. But when I try login with the right password, the page (sorry but I just realized that the message was in german) on the attachment of my first message on the top comes. When I reload the page to get the login fields again, the system shows me the same error message. Because it saves in the session, that I typed the right user and password. Only if I delete the firefox browser cache, I can reach the login page.

      I mean, in my opinion the system finds out that my password is right. However it doesn't connect to the database. And that's why I get the error message. (Datenbank-Verbindung zum Server fehlgeschlagen. -Database connection to the server failed.)

      The MyWebSQL can not have a separate table in DB, where it checks the passwords in addition to allow showing the WebGUI. Am I right ???
      HP ProLiant MicroServer Gen8
      OMV 2.2.13 (Stone burner) - Debian GNU/Linux 7 (wheezy)
      Kernel: Linux 3.2.0-4-amd64
      Processor: Intel(R) Celeron(R) CPU G1610T 2.30GHz
      Menory: 4GB RAM

      *********************************************************************

      Nothing is difficult. The impossible just takes time.
    • Well, this is time where I think my knowledge is ended.
      I'm almost sure that there are some files/file with configuration left after purging, probably you must find this config file and update password there.
      Plugin master will know place for sure :)

      @ryecoaaron could you please help here?
      Debian 8.6 Jessie + OMV 3.0.latest Kernel: Linux 4.8.0-0.bpo.2-amd64
      Processor: Intel Core 2 Duo E8400@3GHz
      Memory: 4GB RAM
      OS-HDD: Samsung SSD 120 GB +LVM

      Full media and download center configured.

      BIG and special thanks for OMV-Extras team for great plug-ins (especially: TeamSpeak, VirtualBox, Sonarr, Radarr, and rest I use :))

      ------------------------------

      Wise guy don't know everything, he can search or ask!
      Don't ask me via PM!

      The post was edited 1 time, last by kawu2 ().

    • kawu2 wrote:

      could you please help here?
      I usually avoid the mysql password threads because I can never reproduce this issue.

      Uninstalling mysql doesn't remove /var/lib/mysql or the user. So, I would remove mysql, the plugin, the mysql user, /etc/mysql and /var/lib/mysql.
      omv 4.1.11 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!
    • Hmm. Are the users saved in mysql library /var/lib/mysql in some kind of conf file? Or are they in the "user" table in the mysql database.

      Or you mean the /var/lib/mysql is the storage location of the db tables?
      HP ProLiant MicroServer Gen8
      OMV 2.2.13 (Stone burner) - Debian GNU/Linux 7 (wheezy)
      Kernel: Linux 3.2.0-4-amd64
      Processor: Intel(R) Celeron(R) CPU G1610T 2.30GHz
      Menory: 4GB RAM

      *********************************************************************

      Nothing is difficult. The impossible just takes time.
    • ryecoaaron wrote:

      Uninstalling mysql doesn't remove /var/lib/mysql or the user. So, I would remove mysql, the plugin, the mysql user, /etc/mysql and /var/lib/mysql.
      Any leftovers of phpmysqladmin?
      Debian 8.6 Jessie + OMV 3.0.latest Kernel: Linux 4.8.0-0.bpo.2-amd64
      Processor: Intel Core 2 Duo E8400@3GHz
      Memory: 4GB RAM
      OS-HDD: Samsung SSD 120 GB +LVM

      Full media and download center configured.

      BIG and special thanks for OMV-Extras team for great plug-ins (especially: TeamSpeak, VirtualBox, Sonarr, Radarr, and rest I use :))

      ------------------------------

      Wise guy don't know everything, he can search or ask!
      Don't ask me via PM!
    • kawu2 wrote:

      Any leftovers of phpmysqladmin?
      Shouldn't be. mywebsql is just a php app. It doesn't store any passwords and doesn't install a database like phpmyadmin.
      omv 4.1.11 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!
    • ridvan34 wrote:

      Hmm. Are the users saved in mysql library /var/lib/mysql in some kind of conf file? Or are they in the "user" table in the mysql database.

      Or you mean the /var/lib/mysql is the storage location of the db tables?
      He mean system user mysql and systemgroup mysql
      Debian 8.6 Jessie + OMV 3.0.latest Kernel: Linux 4.8.0-0.bpo.2-amd64
      Processor: Intel Core 2 Duo E8400@3GHz
      Memory: 4GB RAM
      OS-HDD: Samsung SSD 120 GB +LVM

      Full media and download center configured.

      BIG and special thanks for OMV-Extras team for great plug-ins (especially: TeamSpeak, VirtualBox, Sonarr, Radarr, and rest I use :))

      ------------------------------

      Wise guy don't know everything, he can search or ask!
      Don't ask me via PM!
    • That is actually a good alternative option. I can try it this evening. But I don't really understand why this MyWebSQL doesn't work.
      HP ProLiant MicroServer Gen8
      OMV 2.2.13 (Stone burner) - Debian GNU/Linux 7 (wheezy)
      Kernel: Linux 3.2.0-4-amd64
      Processor: Intel(R) Celeron(R) CPU G1610T 2.30GHz
      Menory: 4GB RAM

      *********************************************************************

      Nothing is difficult. The impossible just takes time.
    • ridvan34 wrote:

      But I don't really understand why this MyWebSQL doesn't work.
      I'm pretty sure some password/s wasn't updated after terminal change - that's the cause
      Debian 8.6 Jessie + OMV 3.0.latest Kernel: Linux 4.8.0-0.bpo.2-amd64
      Processor: Intel Core 2 Duo E8400@3GHz
      Memory: 4GB RAM
      OS-HDD: Samsung SSD 120 GB +LVM

      Full media and download center configured.

      BIG and special thanks for OMV-Extras team for great plug-ins (especially: TeamSpeak, VirtualBox, Sonarr, Radarr, and rest I use :))

      ------------------------------

      Wise guy don't know everything, he can search or ask!
      Don't ask me via PM!
    • kawu2 wrote:

      I'm pretty sure some password/s wasn't updated after terminal change - that's the cause
      I agree.
      omv 4.1.11 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!
    • ryecoaaron wrote:

      kawu2 wrote:

      I'm pretty sure some password/s wasn't updated after terminal change - that's the cause
      I agree.


      I agree, too. But the problem is to find that out.
      Anyway, I will try the phpmyadmin this evening. Then I post the results here. I don't want to spend more time to resolve this problem of MyWebSQL.

      Thank you for all your helps und time.
      HP ProLiant MicroServer Gen8
      OMV 2.2.13 (Stone burner) - Debian GNU/Linux 7 (wheezy)
      Kernel: Linux 3.2.0-4-amd64
      Processor: Intel(R) Celeron(R) CPU G1610T 2.30GHz
      Menory: 4GB RAM

      *********************************************************************

      Nothing is difficult. The impossible just takes time.
    • Well,
      In Linux there is everything free but it cost your time to find it out :)

      I believe everyone in this forum spend thousands of hours searching for solution of problems we face during usage
      Debian 8.6 Jessie + OMV 3.0.latest Kernel: Linux 4.8.0-0.bpo.2-amd64
      Processor: Intel Core 2 Duo E8400@3GHz
      Memory: 4GB RAM
      OS-HDD: Samsung SSD 120 GB +LVM

      Full media and download center configured.

      BIG and special thanks for OMV-Extras team for great plug-ins (especially: TeamSpeak, VirtualBox, Sonarr, Radarr, and rest I use :))

      ------------------------------

      Wise guy don't know everything, he can search or ask!
      Don't ask me via PM!
    • ridvan34 wrote:

      Anyway, I will try the phpmyadmin this evening. Then I post the results here. I don't want to spend more time to resolve this problem of MyWebSQL.
      Just don't install the phpmyadmin package from the Debian repos. You will have to have the root password problem worked out to get phpmyadmin to work since it needs to create a database to install. Can you login with mysql -u root -p?
      omv 4.1.11 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!
    • I really enjoy spending hours with omv. Totally amazing world for me.

      But some problems cause not spending but wasting the time. That's what I mean.

      You can use your time effectively by finding and using an alternative solution for some kind of problems.

      I will post the results this evening.

      Thank you again kawu2 and ryecoaaron.
      HP ProLiant MicroServer Gen8
      OMV 2.2.13 (Stone burner) - Debian GNU/Linux 7 (wheezy)
      Kernel: Linux 3.2.0-4-amd64
      Processor: Intel(R) Celeron(R) CPU G1610T 2.30GHz
      Menory: 4GB RAM

      *********************************************************************

      Nothing is difficult. The impossible just takes time.