{"action":"opened","issue":{"url":"https://api.github.com/repos/zhouyix/HadoopLearning/issues/2","repository_url":"https://api.github.com/repos/zhouyix/HadoopLearning","labels_url":"https://api.github.com/repos/zhouyix/HadoopLearning/issues/2/labels{/name}","comments_url":"https://api.github.com/repos/zhouyix/HadoopLearning/issues/2/comments","events_url":"https://api.github.com/repos/zhouyix/HadoopLearning/issues/2/events","html_url":"https://github.com/zhouyix/HadoopLearning/issues/2","id":265250759,"number":2,"title":"Hadoop And Hive Install Encounter Problems","user":{"login":"zhouyix","id":6723611,"avatar_url":"https://avatars3.githubusercontent.com/u/6723611?v=4","gravatar_id":"","url":"https://api.github.com/users/zhouyix","html_url":"https://github.com/zhouyix","followers_url":"https://api.github.com/users/zhouyix/followers","following_url":"https://api.github.com/users/zhouyix/following{/other_user}","gists_url":"https://api.github.com/users/zhouyix/gists{/gist_id}","starred_url":"https://api.github.com/users/zhouyix/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zhouyix/subscriptions","organizations_url":"https://api.github.com/users/zhouyix/orgs","repos_url":"https://api.github.com/users/zhouyix/repos","events_url":"https://api.github.com/users/zhouyix/events{/privacy}","received_events_url":"https://api.github.com/users/zhouyix/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-10-13T11:00:41Z","updated_at":"2017-10-13T11:00:41Z","closed_at":null,"author_association":"OWNER","body":"# Problems\r\n## 1.When starting  hadoop running sbin/start-dfs.sh, it always requires input root@localhost passwd\r\n      Solution:it means ssh login without passw is not valid, so use 'ssh localhost' to check and redo key-gen \r\n                     and key cat to authoried_keys\r\n      <http://www.cnblogs.com/leien/p/5375780.html>\r\n\r\n## 2.When starting hadoop running sbin.start-dfs.sh, it always warns 'master:ssh:cannot resolve hostname name node [*master*]'\r\n       Solution:master is the name configured in the core-site.xml, add 'xx.xx.xx.xx master' in the /etc/hosts \r\n\r\n## 3.When use putty to login in master machine but  access denied for root@xxx\r\n      Solution:change putty setting,Connection->SSH->Auth->GSSAP,remove Attempt GSSAPI authentication\r\n\r\n## 4.When starting hive,it shows *root@localhost access denied to 'hive' database*\r\n        Solution:grant all privilege to root\r\n        Then \r\n         ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)\r\n         Solution: reset passwd of root->/usr/sbin/mysqld --skip-grant-tables --skip-networking -> mysql -u root ->  SET PASSWORD FOR root@'localhost' = PASSWORD('xxx');\r\n         <http://blog.csdn.net/timebomb/article/details/5571322>\r\n \r\n## 5.mysql the program can be in the following packages\r\n      Solution: /etc/my.cnf conflict ,apt-get remove one my.cnf and delete /etc/mysql\r\n       <http://www.bkjia.com/sjkjc/811150.html>\r\n\r\n## 6.Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’\r\n      Solution:use find cmd to get mysql.sock location and config it to /etc/my.cnf ,restart mysql\r\n\r\n## 7.When use remote computer to start bin/hive ,*WARN: Establishing SSL connection without server's identity verification is not recommended*\r\n      Solution:change the connection url in the hive-site.xml,with suffix ?xxx=true$amp;useSSL=false\r\n\r\n## 8.When use mysql workbench to link master, *Lost connection to MySQL server at 'reading initial communication packet, system error: 0*\r\n      Solution:master not support mysql link so type iptables -A INPUT -i eth0 -p tcp -m tcp --dport 3306 -j ACCEPT\r\n\r\n\r\n"}}
{"actor":{"display_login":"zhouyix"}}