Results 1 to 4 of 4

Thread: cannot create system table MySQL(mariadb)

  1. #1
    Join Date
    Nov 2010
    Location
    NSW, Australia
    Posts
    87

    Default cannot create system table MySQL(mariadb)

    I am following this guide here https://en.opensuse.org/SDB:Linux_Apache_MySQL_PHP .
    Apache has been successfully installed and works.
    The service for mysql has been started, I know need to create user and system tables. So as root I have cd /bin and execued the command.
    Code:
    mysql_install_db --user=mysql
    However I receive an error that it cannot retrieve a host and will only accept an IP.
    Code:
    linux-41ym:/bin # mysql_install_db --user=mysql
    WARNING: The host 'linux-41ym.site' could not be looked up with resolveip.
    This probably means that your libc libraries are not 100 % compatible
    with this binary MariaDB version. The MariaDB daemon, mysqld, should work
    normally with the exception that host name resolving will not work.
    This means that you should use IP addresses instead of hostnames
    when specifying MariaDB privileges !
    If I am supposed to modify this command I am unsure how to the error refers me to this page https://mariadb.com/kb/en/installing...ql_install_db/

    From the page i tried this commands to skip DNS lookup but receive this error.

    Code:
    linux-41ym:/bin # mysql_install_db --skip-name-resolve --user=mysql
    WARNING: The host 'linux-41ym.site' could not be looked up with resolveip.
    This probably means that your libc libraries are not 100 % compatible
    with this binary MariaDB version. The MariaDB daemon, mysqld, should work
    normally with the exception that host name resolving will not work.
    This means that you should use IP addresses instead of hostnames
    when specifying MariaDB privileges !
    Installing MariaDB/MySQL system tables in '/var/lib/mysql' ...
    140402 21:55:20 [ERROR] mysqld: Can't lock aria control file '/var/lib/mysql/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
    140402 21:55:51 [ERROR] mysqld: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/var/lib/mysql/aria_log_control'
    140402 21:55:51 [ERROR] Plugin 'Aria' init function returned error.
    140402 21:55:51 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
    ERROR: 1017  Can't find file: '/tmp/#sql_46f6_0' (errno: 2)
    140402 21:55:51 [ERROR] Aborting
    
    140402 21:55:51 [Note] /usr/sbin/mysqld: Shutdown complete
    How can I resolve this?

  2. #2
    Join Date
    Jun 2008
    Location
    Netherlands
    Posts
    25,004

    Default Re: cannot create system table MySQL(mariadb)

    The WARNING says that linux-41ym.site can not be resolved to an IP address.

    I assume that linux-41ym.site is the host/domainname given by the installer to your host as a default during network installation because you did not tell it otherwise. Also it does not seem to be in /etc/hosts (and it will of course not be in the DNS server you use).
    Henk van Velden

  3. #3
    Join Date
    Nov 2010
    Location
    NSW, Australia
    Posts
    87

    Default Re: cannot create system table MySQL(mariadb)

    Quote Originally Posted by hcvv View Post
    The WARNING says that linux-41ym.site can not be resolved to an IP address.

    I assume that linux-41ym.site is the host/domainname given by the installer to your host as a default during network installation because you did not tell it otherwise. Also it does not seem to be in /etc/hosts (and it will of course not be in the DNS server you use).
    Neither the opensuse or mariadb guide cover this exceptig the already tried.
    --skip-name-resolve

    I was unable to resolve using that command for test databases. The following command appears to work normally and let me proceed.

    Code:
    /usr/bin/mysql_secure_installation

  4. #4
    Join Date
    Jun 2008
    Location
    West Yorkshire, UK
    Posts
    3,448

    Default Re: cannot create system table MySQL(mariadb)

    As long as you have entered a root password and answered Y to all the other questions, you will have set up a secure default installation. This is always the first command to run if you are installing a fresh installation.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •