[SOLVED] - Cannot reach mysql installed on omv from clients

  • I have omv 0.5.24 installed and mysql on it.
    I am trying to reach the mysql server from a different computer on my network using squirrel but I am not able to login to my sql server.


    I installed using the plugin here, my system is 64 bit.
    When I try to telnet I get this:


    telnet 10.100.102.7 3306:


    E♦Host '10.100.102.3' is not allowed to connect to this MySQL server
    Connection to host lost.


    This is a new OMV and a new mysql server install
    What other data should I give here?

    • Offizieller Beitrag

    Change the Bind Address on the plugin's Settings tab. The note under it tells you everything you need to know :) 127.0.0.1 is localhost only.

    omv 7.0.4-2 sandworm | 64 bit | 6.5 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.10 | compose 7.1.2 | k8s 7.0-6 | 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!

  • root@omv:~# netstat -noap |grep 3306
    tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 11148/mysqld off (0.00/0/0)


    Code
    root@omv:/etc/mysql# ls -la
    total 24
    drwxr-xr-x  3 root root 4096 Dec  7 22:49 .
    drwxrwxr-x 95 root root 4096 Dec 15 12:11 ..
    drwxr-xr-x  2 root root 4096 Dec 12 13:14 conf.d
    -rw-------  1 root root  333 Dec  7 22:49 debian.cnf
    -rwxr-xr-x  1 root root 1198 Oct 17 16:43 debian-start
    -rw-r--r--  1 root root 3523 Dec  7 23:29 my.cnf


    Code
    root@omv:/etc/mysql# cat conf.d/openmediavault-mysql.cnf 
    # Configuration for openmediavault-mysql
    
    
    [mysqld]
    port = 3306
    bind-address = 0.0.0.0
    datadir = /media/5eb927dd-91b5-4c42-9d37-ac34832a6384/mysql-data
  • You have to configure the individual Database to be able to connect from other hosts than localhost/127.0.0.1.


    Greetings
    David

    "Well... lately this forum has become support for everything except omv" [...] "And is like someone is banning Google from their browsers"


    Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.

    Upload Logfile via WebGUI/CLI
    #openmediavault on freenode IRC | German & English | GMT+1
    Absolutely no Support via PM!

Jetzt mitmachen!

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