Ask Your Question
0

mariadb fails to start

asked 2014-06-27 14:12:36 -0500

CheBiblioteca gravatar image

updated 2014-06-30 00:01:04 -0500

I accidentally deleted the whole /home/MZ/.config directory.

The immediate effect was to trigger the gnome wizard, and most everything continued to work. However, mysql stopped working and -- after many reinstalls, which previously worked -- is no longer working at all ("sudo service mysqld start" produces "Job for mariadb.service failed. See 'systemctl status mariadb.service' and 'journalctl -xn' for details.") Other than that, I've rebooted and the system seems stable. So...

What other problems might emerge?

Is this very serious? Should I reinstall Fedora altogether?

Thanks. Linux newbie.

$sudo yum remove mysql mysql-server
$cd /var/lib
$sudo rm -r mysql
$sudo yum install mysql mysql-server -y
$sudo service mysqld start
Redirecting to /bin/systemctl start  mysqld.service
Job for mariadb.service failed. See 'systemctl status mariadb.service' and 'journalctl -xn' for details.

$ systemctl status mariadb.service -l
mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled)
   Active: failed (Result: exit-code) since Fri 2014-06-27 19:15:56 EDT; 57s ago
  Process: 9402 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=1/FAILURE)

Jun 27 19:15:56 localhost.localdomain mariadb-prepare-db-dir[9402]: https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
Jun 27 19:15:56 localhost.localdomain mariadb-prepare-db-dir[9402]: MariaDB is hosted on launchpad; You can find the latest source and
Jun 27 19:15:56 localhost.localdomain mariadb-prepare-db-dir[9402]: email lists at http://launchpad.net/maria
Jun 27 19:15:56 localhost.localdomain mariadb-prepare-db-dir[9402]: Please check all of the above before submitting a bug report
Jun 27 19:15:56 localhost.localdomain mariadb-prepare-db-dir[9402]: at http://mariadb.org/jira
Jun 27 19:15:56 localhost.localdomain mariadb-prepare-db-dir[9402]: Initialization of MySQL database failed.
Jun 27 19:15:56 localhost.localdomain mariadb-prepare-db-dir[9402]: Perhaps /etc/my.cnf is misconfigured.
Jun 27 19:15:56 localhost.localdomain systemd[1]: mariadb.service: control process exited, code=exited status=1
Jun 27 19:15:56 localhost.localdomain systemd[1]: Failed to start MariaDB database server.
Jun 27 19:15:56 localhost.localdomain systemd[1]: Unit mariadb.service entered failed state.
$ journalctl -xn
-- Logs begin at Sat 2014-03-29 09:32:29 EDT, end at Fri 2014-06-27 19:15:56 EDT. --
Jun 27 19:15:56 localhost.localdomain mariadb-prepare-db-dir[9402]: https://mariadb.com/kb/en/installing-system-tables-mys
Jun 27 19:15:56 localhost.localdomain mariadb-prepare-db-dir[9402]: MariaDB is hosted on launchpad; You can find the lates
Jun 27 19:15:56 localhost.localdomain mariadb-prepare-db-dir[9402]: email lists at http://launchpad.net/maria
Jun 27 19:15:56 localhost.localdomain mariadb-prepare-db-dir[9402]: Please check all of the above before submitting a bug 
Jun 27 19:15:56 localhost.localdomain mariadb-prepare-db-dir[9402]: at http://mariadb.org/jira
Jun 27 19:15:56 localhost.localdomain mariadb-prepare-db-dir[9402]: Initialization of MySQL database failed.
Jun 27 19:15:56 localhost.localdomain mariadb-prepare-db-dir[9402]: Perhaps /etc/my.cnf is misconfigured.
Jun 27 19:15:56 localhost.localdomain systemd[1]: mariadb.service: control process exited, code=exited status=1
Jun 27 19:15:56 localhost.localdomain systemd[1]: Failed ...
(more)
edit retag flag offensive close merge delete

Comments

mariadb not working has absolutely nothing to do with what files are or are not present in your home directory. These are separate issues. I strongly recommend that you clean up your question to focus on the mariadb problems so that your helpers can focus on relevant information.

I'll get you started by changing the title to something that describes your problem, you can do the question.

randomuser gravatar imagerandomuser ( 2014-06-29 23:59:36 -0500 )edit

3 Answers

Sort by ยป oldest newest most voted
2

answered 2014-06-27 16:08:11 -0500

cobra gravatar image

I'm not entirely sure what you've deleted, your description doesn't make it clear. I'll give you a few pointers about where I think you're at, hopefully others can chip in too...

  • There's no such directory as /usr/~/.config. So you can't have deleted something important.

Unless you've given yourself root privileges (a dumb thing to do, and you quote sudo use, so that's probably not an issue) then you won't have deleted anything in /usr/

  • There is an application configuration in your home directory, this is accessed by ~/.config

This directory stores all your application settings and configurations. It's all personal data like email account configs, some gnome stuff (if you use that) settings for your file manager, dev tools, pretty much everything. But it's all -user- data. It's all the settings used when -you- run those applications.

If you've deleted that, then it's inconvenient, but you can always set your applications up again the way you like them.

  • You have an issue with Mariadb, the MySQL replacement in Fedora.

What output does it provide if you run the suggested logging commands? If you can't figure out what it's telling you, then share that output and we'll see what we can do to help.

It's unlikely that a reinstall is what you need.

edit flag offensive delete link more

Comments

Sorry, should have written /home/MZ/.config (that's the directory I deleted, with MZ being my username).

I've posted the command I used to re-install mysql and the error log above (space constraints in answers). Thank you.

CheBiblioteca gravatar imageCheBiblioteca ( 2014-06-27 18:23:02 -0500 )edit
1

answered 2014-06-27 17:19:55 -0500

zoltanh721 gravatar image

I would suggest to create an new user with generates a new home directory with most of your installed apps - with some default settings - but not all, so not to be surprised. If root account is not harmed, then the newly created use will stabilize your situation. Else if you moved or completely deleted them, it won't work either. But when you succeed, you can delete your old user account and use happily the newly created one, with your missing reinstalled apps. HTH.

edit flag offensive delete link more

Comments

Thanks.

The directory was recreated upon deletion by the Gnome configuration wizard.

CheBiblioteca gravatar imageCheBiblioteca ( 2014-06-27 18:03:11 -0500 )edit
0

answered 2014-06-27 16:12:21 -0500

I think you mean you accidentally deleted the .config directory from your user's home directory, yes?

If you don't have any backups available, it's hard to tell how many of your applications will be impacted. The home user's .config directory is used by lots of applications to store configuration data. It shouldn't harm your operating system's stability, but applications such as GNOME, Nautilus, Empathy, evolution, pulse audio, and even gedit store settings here.

In short: reinstalling Fedora altogether won't do much to resolve the issue. I'd recreate the directory and work on reconfiguring your applications. If applications fail to function entirely, you may need to reinstall them as needed. Back up application-related data before doing so, of course.

edit flag offensive delete link more

Comments

Yes, from the home directory.

The directory seems to have recreated itself on its own: upon deletion, Gnome prompted me with a configuration wizard.

Thank you.

CheBiblioteca gravatar imageCheBiblioteca ( 2014-06-27 18:01:49 -0500 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

Stats

Asked: 2014-06-27 14:12:36 -0500

Seen: 2,145 times

Last updated: Jun 30 '14