[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.

    Bilder

    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!

    Einmal editiert, zuletzt von kawu2 ()

    • Offizieller Beitrag

    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 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!

  • 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.

  • Zitat von ryecoaaron

    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!

    • Offizieller Beitrag

    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 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!

  • 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.

  • 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!

    • Offizieller Beitrag

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

    I agree.

    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 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!

    • Offizieller Beitrag

    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 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 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.

Jetzt mitmachen!

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