MariaDB installd but wan't start

[alix]

Hi,

I installd mariadb but its failing to start mysql service,

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: failed (Result: exit-code) since Wed 2016-04-06 11:45:10 CEST; 1min 57s ago
Process: 5190 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER (code=exited, status=1/FAILURE)
Main PID: 5190 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"

how can i find the details of this problem?

[TrevorH]

Look in the log - most likely /var/log/mysqld.log though I don't use mariadb yet so it may be called something else.

[alix]

there is no log for mariadb, in this folder /var/log/mysqld.log

My problem is installing mariadb, i install with yum install MariaDB-server and i also past the settings in /etc/yum.repo/MariaDB.repo.

but after the installation i try to start the script

Code: Select all

sudo mysql_secure_installation

this is where it go's wrong. It asks the root password so i press enter because i have no password set yet for mariadb and stil it wan't let me in and mariadb is failing to start.

Where dose go's wrong? how can i solve this issue?

[giulix63]

mariadb is in the base CentOS repository (meaning it's part of CentOS distribution). Just do a

Code: Select all

yum install mariadb-server

as root to install version 5.5.47. If you have specific requirements that force you to install from a third-party repository, then you'll probably have to turn to them for support.

[alix]

i did that again adn then i tryd mysql_secure_installation and get this error when i try to login with no password by pressing just enter button:

mysql_secure_installation
/bin/mysql_secure_installation: line 379: find_mysql_client: command not found

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!

In order to log into MariaDB to secure it, we'll need the current
password for the root user. If you've just installed MariaDB, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none):
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Enter current password for root (enter for none):

[giulix63]

Just ignore the first error (/bin/mysql_secure_installation: line 379: find_mysql_client: command not found. Note to self: is there a BZ for this? Yes, fixed upstream since 10.0.5). Before running the mysql_secure_installation script make sure the database is up&running:

Code: Select all

systemctl -l start mariadb

Run as root.

[alix]

hi giulix63,

i have try'd your command, it stil wan't start. I managed to get the logs of starting mariadb:

160406 20:52:31 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160406 20:52:31 [Note] /usr/libexec/mysqld (mysqld 5.5.47-MariaDB) starting as process 5231 ...
160406 20:52:31 InnoDB: The InnoDB memory heap is disabled
160406 20:52:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160406 20:52:31 InnoDB: Compressed tables use zlib 1.2.7
160406 20:52:31 InnoDB: Using Linux native AIO
160406 20:52:31 InnoDB: Initializing buffer pool, size = 128.0M
160406 20:52:31 InnoDB: Completed initialization of buffer pool
InnoDB: Error: checksum mismatch in data file ./ibdata1
160406 20:52:31 InnoDB: Could not open or create data files.
160406 20:52:31 InnoDB: If you tried to add new data files, and it failed here,
160406 20:52:31 InnoDB: you should now edit innodb_data_file_path in my.cnf back
160406 20:52:31 InnoDB: to what it was, and remove the new ibdata files InnoDB created
160406 20:52:31 InnoDB: in this failed attempt. InnoDB only wrote those files full of
160406 20:52:31 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
160406 20:52:31 InnoDB: remove old data files which contain your precious data!
160406 20:52:31 [ERROR] Plugin 'InnoDB' init function returned error.
160406 20:52:31 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
160406 20:52:31 [Note] Plugin 'FEEDBACK' is disabled.
160406 20:52:31 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
160406 20:52:31 [ERROR] Unknown/unsupported storage engine: InnoDB
160406 20:52:31 [ERROR] Aborting

160406 20:52:32 [Note] /usr/libexec/mysqld: Shutdown complete

160406 20:52:32 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended

[gerald_clark]

You are trying to start MariaDB with data files left over from a foreign version.
Delete the MariaDB data files and restart the server.

[alix]

thanks clark, that did the job to work. I have removed the data files and afterwards i run fresh install of mariadb.

Thanks,

alix