[SOLVED] MyWebSQL Login Problem

    • OMV 2.x
    • ryecoaaron wrote:

      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?


      Yes I can login to mysql with root password over ssh. I can execute the queries, see the tables and rows. Don't have problem with the actual database and login.

      The problem is to login over web user interface MyWebSQL. Because I don't want to work always over terminal.

      This kind of interfaces like phpmyadmin or mywebsql are more effective. I don't use db only for the services running on omv but also for some other purposes like my homepage or my web applications.

      Gesendet von meinem SM-G928F mit Tapatalk
      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:

      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?


      Yes I can login to mysql with root password over ssh. I can execute the queries, see the tables and rows. Don't have problem with the actual database and login.

      The problem is to login over web user interface MyWebSQL. Because I don't want to work always over terminal.

      This kind of interfaces like phpmyadmin or mywebsql are more effective. I don't use db only for the services running on omv but also for some other purposes like my homepage or my web applications.
      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:

      Yes I can login to mysql with root password over ssh. I can execute the queries, see the tables and rows. Don't have problem with the actual database and login.

      The problem is to login over web user interface MyWebSQL. Because I don't want to work always over terminal.

      This kind of interfaces like phpmyadmin or mywebsql are more effective. I don't use db only for the services running on omv but also for some other purposes like my homepage or my web applications.
      I wasn't suggesting using the command line all the time. I know the web interfaces are more effective. I was just curious if the root password worked there. Since it does, that is even stranger that mywebsql doesn't work. But, it means install phpmyadmin will probably work.
      omv 4.0.6 arrakis | 64 bit | 4.12 backports kernel | omvextrasorg 4.1.0
      omv-extras.org plugins source code and issue tracker - github.com/OpenMediaVault-Plugin-Developers

      Please don't PM for support... Too many PMs!
    • I hope so. :)
      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.
    • And that's it. I installed phpmyadmin with the help of ryecoaaron's guide in this thread about phpmyadmin. It works wery well. I definitely suggest using phpmyadmin to the people who has a problem with MyWebSQL like me. And by the way it doesn't have to be the mysql db but also mariadb. It's more performant somewhere.

      Thank you again guys (although we couldn't still find the reason why MyWebSQL doesn't work. :) but that's ok). :thumbup:
      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 there,

      I had the same issue as ridvan34 every time I installed the MySQL-plugin after changing the root password (which I usually do as soon as the mysql server is running). It drove me crazy and nobody seemed to have a solution...
      This time I tried some very easy hints from the MyWebSQL-site:

      For the file ‘config/auth.php’:

      define(‘AUTH_SERVER’, ‘localhost:3307’);


      For the file ‘config/servers.php’:

      $SERVER_LIST = array(

      ‘Localhost MySQL’ => array(

      ‘host’ => ‘localhost:3307’,


      Since I'm still using the standard port I changed the "localhost:3307" to "localhost:3306".


      After doing that I rebooted the server and was able to access MySQL via MyWebSQL again (with the new password) :thumbsup:

      I don't know whether the settings above were actually necessary at all but in my previous attempts to use the plugin I never succeeded - despite rebooting the server on a regular basis.
      Just thought this experience could help.