MySQL Database connection failed to the server

  • Hello,


    I have installed and configured OMV-MySQL. It installed without any issues, however when I log in on the web admin page it tells me "Database connection failed to the server".


    It doesn't matter what username or password I use so I suspect it is not getting to the data directory to connect.


    I am assuming a dummy database was created during install and that is what it is trying to connect to.


    Here's what I get with ls -al /media/603e7fc7-b611-4300-b5e3-9c9fbddca236/MediaDownloads/MySqlData/


    Code
    total 28692
    drwxrwsrwx+ 4 root users     4096 Nov 28 20:15 .
    drwxrwsrwx+ 8 root users     4096 Nov 26 17:53 ..
    -rw-r--r--  1 root users        0 Nov 28 20:09 debian-5.5.flag
    -rw-rw----  1 root users 18874368 Nov 28 20:15 ibdata1
    -rw-rw----  1 root users  5242880 Nov 28 20:15 ib_logfile0
    -rw-rw----  1 root users  5242880 Nov 28 20:09 ib_logfile1
    drwx--S---  2 root users     4096 Nov 28 20:09 mysql
    -rw-------  1 root users        6 Nov 28 20:09 mysql_upgrade_info
    drwx--S---  2 root users     4096 Nov 28 20:09 performance_schema


    dpkg -l | grep mysql


    Code
    ii  libdbd-mysql-perl                     4.021-1+b1                         amd64        Perl5 database interface to the MySQL database
    ii  libmysqlclient18:amd64                5.5.40-0+wheezy1                   amd64        MySQL database client library
    ii  mysql-client-5.5                      5.5.40-0+wheezy1                   amd64        MySQL database client binaries
    ii  mysql-common                          5.5.40-0+wheezy1                   all          MySQL database common files, e.g. /etc/mysql/my.cnf
    ii  mysql-server                          5.5.40-0+wheezy1                   all          MySQL database server (metapackage depending on the latest version)
    ii  mysql-server-5.5                      5.5.40-0+wheezy1                   amd64        MySQL database server binaries and system database setup
    ii  mysql-server-core-5.5                 5.5.40-0+wheezy1                   amd64        MySQL database server binaries
    ii  openmediavault-mysql                  1.0.12                             all          MySQL plugin for OpenMediaVault
    ii  php5-mysqlnd                          5.4.35-0+deb7u2                    amd64        MySQL module for php5 (Native Driver)


    My port is 3306 and bind address is 0.0.0.0


    Probably a permission issue but I just can't seem to figure it out.


    Any help is greatly appreciated.


    Thanks!

    • Offizieller Beitrag

    I wouldn't have the mysql databases as a subfolder of another shared folder. It is going to inherit permissions from it. So, I would create a new shared folder and select it in the plugin. It will move the data.

    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!

  • Thanks for the reply ryecoaaron.


    Unfortunately no luck moving the folder. After creating a new share, I removed/purged and installed again with no luck.


    The file /etc/mysql/conf.d/openmediavault-mysql.cnf points to the new data directory I just created.


    Code
    [mysqld]
    port = 3306
    bind-address = 0.0.0.0
    datadir = /media/603e7fc7-b611-4300-b5e3-9c9fbddca236/MySQLdata/


    Not sure where to go from here.

    • Offizieller Beitrag

    You could try this

    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!

Jetzt mitmachen!

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