Home Forums HDP on Linux – Installation HDP 2.0 MySQL install fail

This topic contains 3 replies, has 2 voices, and was last updated by  Robert Volker 5 months, 2 weeks ago.

  • Creator
    Topic
  • #42637

    Robert Volker
    Participant

    Cluster node with Hive Metastore : ‘fqn-3rd node’ Database : MySQL (New Database)

    stdout
    ————
    chown: invalid user: `mysql:mysql’
    chown: invalid user: `mysql:mysql’
    Initializing MySQL database: chown: invalid user: `mysql’
    chown: invalid user: `mysql’
    chown: invalid user: `mysql’
    Installing MySQL system tables…
    131031 12:13:56 [ERROR] Fatal error: Can’t change to run as user ‘mysql’ ; Please check that the user exists!
    ————–
    yep, on my node ‘fqn-3rd node’ there isn’t a mysql user!

    all of the other nodes correctly have

    mysql:x:27:27:MySQL Server:/var/lib/mysql:/bin/bash

    ** Should I manually install MySql on ‘fqn-3rd node’? Or try to have Ambari reinstall?

    Thanks,
    Robert

Viewing 3 replies - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.

  • Author
    Replies
  • #43016

    Robert Volker
    Participant

    I have a work around: moved the MySQL Hive Metastore off the hadoop clusters. The MySQL now reside on the “ambari” server node. My HDP 2.0 cluster in finally up and running!

    - It because the MySQL is just a metastore, having it off the hive node shouldn’t be too much of a performance impact. Or am I mistaken with this naive assumption?

    Robert

    Collapse
    #42866

    Robert Volker
    Participant

    Dave,
    Thanks for you help. I cleaned up the node and manually installed MySQL. Reset ambari and restarted ambari.
    - I follwed the instructions in ‘Chapter IV.18. Appendix: Using Non-Default Databases’. MySQL was good.

    Failed install again. In a very similar fashion, here’s the log file:
    chown: invalid user: `mysql:mysql’
    chown: invalid user: `mysql:mysql’
    Initializing MySQL database: chown: invalid user: `mysql’
    chown: invalid user: `mysql’
    chown: invalid user: `mysql’
    Installing MySQL system tables…
    131031 12:13:56 [ERROR] Fatal error: Can’t change to run as user ‘mysql’ ; Please check that the user exists!
    ———————
    Note: after this failure I can’t use mysql:

    [root@hadoop03 mysql]# mysql -u root -p
    Enter password:
    ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)

    ————————-
    4 node cluster architecture:
    NameNode : hadoop02.xxxxx.com
    SecondaryNameNode : hadoop03.xxxxx.com
    DataNodes : 3 hosts
    YARN + MapReduce2
    NodeManager : 3 hosts
    ResourceManager : hadoop03.xxxxx.com
    History Server : hadoop03.xxxxx.com
    Nagios
    Server : hadoop02.xxxxx.com
    Administrator : nagios
    Ganglia
    Server : hadoop02.xxxxx.com
    Hive + HCatalog
    Hive Metastore : hadoop03.xxxxx.com
    Database : MySQL (New Database)
    HBase
    Master : hadoop02.xxxxx.com
    RegionServers : 3 hosts
    Oozie
    Server : hadoop03.xxxxx.com
    Database : Derby (New Derby Database)
    ZooKeeper
    Servers : 3 hosts

    Collapse
    #42781

    Dave
    Moderator

    Hi Robert,

    If you create the user & install MySQL manually, does the ambari install successfully complete?
    Are you running oozie and MySQL on 2 different Nodes? What is the cluster architecture like?

    Thanks

    Dave

    Collapse
Viewing 3 replies - 1 through 3 (of 3 total)