Enhance Technology
asked on
MariaDB
Unable to start mariadb on CentOS Linux release 7.4.1708 (Core)
(Linux 118 3.10.0-693.el7.x86_64 #1 SMP Tue Aug 22 21:09:27 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux)
Installation Process:-
# yum install mariadb-server
# yum list installed | grep mariadb
MariaDB-client.x86_64 10.1.29-1.el7.centos @mariadb
MariaDB-common.x86_64 10.1.29-1.el7.centos @mariadb
MariaDB-server.x86_64 10.1.29-1.el7.centos @mariadb
galera.x86_64 25.3.22-1.rhel7.el7.centos @mariadb
jemalloc.x86_64 3.6.0-1.el7 @mariadb
after that once m trying to run from mention cmd i got error
# systemctl start mariadb.service
Job for mariadb.service failed because a fatal signal was delivered to the control process. See "systemctl status mariadb.service" and "journalctl -xe" for details.
# systemctl status mariadb.service
● mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/m ariadb.ser vice; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariad b.service. d
└─migrated-from-my.cnf-set tings.conf
Active: activating (start) since Wed 2017-12-20 14:11:14 IST; 113ms ago
Process: 13215 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recov ery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 13212 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 13227 (mysqld)
CGroup: /system.slice/mariadb.serv ice
└─13227 /usr/sbin/mysqld
Dec 20 14:11:14 118 systemd[1]: Starting MariaDB database server...
# mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock ' (2 "No such file or directory")
(Linux 118 3.10.0-693.el7.x86_64 #1 SMP Tue Aug 22 21:09:27 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux)
Installation Process:-
# yum install mariadb-server
# yum list installed | grep mariadb
MariaDB-client.x86_64 10.1.29-1.el7.centos @mariadb
MariaDB-common.x86_64 10.1.29-1.el7.centos @mariadb
MariaDB-server.x86_64 10.1.29-1.el7.centos @mariadb
galera.x86_64 25.3.22-1.rhel7.el7.centos
jemalloc.x86_64 3.6.0-1.el7 @mariadb
after that once m trying to run from mention cmd i got error
# systemctl start mariadb.service
Job for mariadb.service failed because a fatal signal was delivered to the control process. See "systemctl status mariadb.service" and "journalctl -xe" for details.
# systemctl status mariadb.service
● mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/m
Drop-In: /etc/systemd/system/mariad
└─migrated-from-my.cnf-set
Active: activating (start) since Wed 2017-12-20 14:11:14 IST; 113ms ago
Process: 13215 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recov
Process: 13212 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 13227 (mysqld)
CGroup: /system.slice/mariadb.serv
└─13227 /usr/sbin/mysqld
Dec 20 14:11:14 118 systemd[1]: Starting MariaDB database server...
# mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock
ASKER
Hello Joy Dingenen,
this is fresh installation, i didn't find mariadb folder or file in /var/log/
this is fresh installation, i didn't find mariadb folder or file in /var/log/
can you please post the result of "netstat -tulpen" ? and please "yum list installed | grep -i mysql" as well as "getenforce" and "iptables -nvL"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
mariadb-libs is a dependency you're missing btw.
Try posting the following data, wrapped in the CODE menu item above...
cat /etc/os-release
ps auxww
yum list installed
netstat -plute
ASKER
now working MariaDB, Thanks Experts
is this a fresh install? Did you migrate files from somewhere already?
also could you paste a tail of your /var/log/mariadb/mariadb.l
Thanks,
Joy