Link to home
Start Free TrialLog in
Avatar of Enhance Technology
Enhance TechnologyFlag for India

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/mariadb.service; enabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.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_recovery`; [ $? -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.service
           └─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")
Avatar of Joy Dingenen
Joy Dingenen
Flag of Belgium image

Hello,

is this a fresh install? Did you migrate files from somewhere already?
also could you paste a tail of your /var/log/mariadb/mariadb.log

Thanks,
Joy
Avatar of Enhance Technology

ASKER

Hello Joy Dingenen,
this is fresh installation,  i didn't find mariadb folder or file in  /var/log/
Avatar of Peter Schultz
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
Avatar of Joy Dingenen
Joy Dingenen
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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

Open in new window

now working MariaDB, Thanks Experts