Member since
07-31-2017
10
Posts
0
Kudos Received
2
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
9300 | 10-05-2017 06:56 PM |
10-05-2017
06:56 PM
Everything indicates that many errors occurred during the preparation of the cluster and in the same way during the installation of HDP.
We performed a re-image of everything and re-installation. Sandbox is up now. Thanks.
... View more
09-14-2017
08:39 PM
g4t7474_[root@g4t7474 ~]# chown mysql /var/run/mysqld/mysql.sock
chown: invalid user: `mysql'
g4t7474_[root@g4t7474 ~]# /usr/local/mysql/bin/safe_mysqld --user=mysql --skip-grant-tables
bash: /usr/local/mysql/bin/safe_mysqld: No such file or directory
g4t7474_[root@g4t7474 ~]# ls -ld /usr/local/mysql/bin/safe_mysqld
ls: cannot access /usr/local/mysql/bin/safe_mysqld: No such file or directory
g4t7474_[root@g4t7474 ~]# locate safe_mysqld
g4t7474_[root@g4t7474 ~]#
But the i was working with root: from: /etc/my.cnf # Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
#log-error=/var/log/mysqld.log
#pid-file=/var/run/mysqld/mysqld.pid
[mysqld]
#datadir=/var/lib/mysql
datadir=/opt/tools/mysql
socket=/var/lib/mysql/mysql.sock
#validate-password= off
innodb_data_file_path = ibdata1:10M:autoextend
[mysqladmin]
user=root
[client]
user=mysql
# Recommended in standard MySQL setup
#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pi
... View more
09-14-2017
06:06 PM
Same: g4t7474_[root@g4t7474 ~]# cd /tmp
g4t7474_[root@g4t7474 tmp]# ln -s /var/mysql/mysql.sock mysql.sock
g4t7474_[root@g4t7474 tmp]# service mysqld start
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
... View more
09-14-2017
06:04 PM
g4t7474_[root@g4t7474 etc]# ls -ld /var/run/mysqld/mysqld.pid
ls: cannot access /var/run/mysqld/mysqld.pid: No such file or directory
g4t7474_[root@g4t7474 etc]# ls -ld /var/lib/mysqld/mysqld.pid
ls: cannot access /var/lib/mysqld/mysqld.pid: No such file or directory
g4t7474_[root@g4t7474 etc]# locate mysqld.pid
g4t7474_[root@g4t7474 etc]# Any process hanging.
... View more
09-13-2017
01:49 PM
Hi Geoffrey, Thanks for your response, I tried but it didn't work. Please find the below details. mysql.sock is located on /var/lib/mysql/mysql.sock +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ [root@g4t7474 etc]# locate mysql.sock /var/lib/mysql/mysql.sock +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ I tried +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ [root@g4t7474 etc]# cd /tmp/
[root@g4t7474 tmp]# ls -s /var/lib/mysql/mysql.sock mysql.sock
ls: cannot access /var/lib/mysql/mysql.sock: No such file or directory
0 mysql.sock +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ g4t7474_[root@g4t7474 tmp]# service mysqld start
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
... View more
09-12-2017
08:53 PM
We have been working our sandbox cluster and we are not able to start mysql server getting the below error: g4t7474_[root@g4t7474 tools]# service mysqld status
mysqld is stopped g4t7474_[root@g4t7474 tools]# service mysqld start
MySQL Daemon failed to start.
Starting mysqld: [FAILED] The Service stopped suddenly and when we tried to start it again it failed several times. ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Please find attached two of the tested "my.cnf" files and the logs. my.cnf -> this is the original that was working my.cnf.back -> tried to replicate a working one but didnt succeed. mycnfback.txt mycnf.txt varlogmysqldlog.txt ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Below the mysql.sock "location" g4t7474_[root@g4t7474 ~]# locate mysql.sock
/var/lib/mysql/mysql.sock
g4t7474_[root@g4t7474 ~]# ls -ld /var/lib/mysql/mysql.sock
ls: cannot access /var/lib/mysql/mysql.sock: No such file or directory
g4t7474_[root@g4t7474 ~]#
... View more
Labels:
- Labels:
-
Apache Ambari