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")
Enhance TechnologyFounderAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Joy DingenenICT system consultantCommented:
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
0
Enhance TechnologyFounderAuthor Commented:
Hello Joy Dingenen,
this is fresh installation,  i didn't find mariadb folder or file in  /var/log/
0
Peter SchultzSenior Network AdministratorCommented:
can you please post the result of "netstat -tulpen" ? and please "yum list installed | grep -i mysql" as well as "getenforce" and "iptables -nvL"
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Joy DingenenICT system consultantCommented:
Rajat,

mmmm...this should be where it writes it's log. Because i just replicated exactly what you did on a centos 7 kvm. could you look in /var/log/messages if you see anything with mariadb or mysql?
if you have no clue how just run:
cat /var/log/messages | grep mariadb

Thx.

what i did:
[root@centos70 ~]# uname -a
Linux centos70 3.10.0-229.el7.x86_64 #1 SMP Fri Mar 6 11:36:42 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux
[root@centos70 ~]# yum install mariadb-server
[root@centos70 ~]# systemctl start mariadb
[root@centos70 ~]# systemctl status mariadb
mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled)
   Active: active (running) since Wed 2017-12-20 11:11:16 CET; 8s ago
  Process: 13880 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS)
  Process: 13799 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
 Main PID: 13879 (mysqld_safe)
   CGroup: /system.slice/mariadb.service
           ├─13879 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
           └─14041 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysq...

Dec 20 11:11:10 centos70 mariadb-prepare-db-dir[13799]: MySQL manual for more...
Dec 20 11:11:10 centos70 mariadb-prepare-db-dir[13799]: Please report any pro...
Dec 20 11:11:10 centos70 mariadb-prepare-db-dir[13799]: The latest informatio...
Dec 20 11:11:10 centos70 mariadb-prepare-db-dir[13799]: You can find addition...
Dec 20 11:11:10 centos70 mariadb-prepare-db-dir[13799]: http://dev.mysql.com
Dec 20 11:11:10 centos70 mariadb-prepare-db-dir[13799]: Consider joining Mari...
Dec 20 11:11:10 centos70 mariadb-prepare-db-dir[13799]: https://mariadb.org/g...
Dec 20 11:11:10 centos70 mysqld_safe[13879]: 171220 11:11:10 mysqld_safe Log....
Dec 20 11:11:10 centos70 mysqld_safe[13879]: 171220 11:11:10 mysqld_safe Sta...l
Dec 20 11:11:16 centos70 systemd[1]: Started MariaDB database server.
Hint: Some lines were ellipsized, use -l to show in full.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Joy DingenenICT system consultantCommented:
mariadb-libs is a dependency you're missing btw.
0
David FavorLinux/LXD/WordPress/Hosting SavantCommented:
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

0
Enhance TechnologyFounderAuthor Commented:
now working MariaDB, Thanks Experts
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Linux

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.