Blog
- Home
- Blog
Job for mariadb.service failed because the control process exited with error code - How to fix it ?
This article covers how to resolve the above maiadb problem "Job for mariadb.service failed because the control process exited with error code" which may arise during the installation of #MariaDB on #CentOS 8.
The /var/lib/mysql directory is not empty when MariaDB is installed, it contains e.g. the 'mysql' database and some other files.
Recreating the folder, even with correct permissions, will not help you.
Either MariaDB has not been successfully installed or the directory was removed. Reinstall MariaDB to get a working basic database system back.
Also, you can give access /var/log/mysql/* to mysql by running the command:
sudo chown mysql:mysql /var/log/mysql/*MariaDB offers more and better storage engines, NoSQL support, provided by Cassandra, allows you to run SQL and NoSQL in a single database system.
MariaDB also supports TokuDB, which can handle big data for large organizations and corporate users.
To view mysql error logs:
1. edit /etc/my.cnf [mysqld] log=/tmp/mysql.log.
2. restart the computer or the mysqld service service mysqld restart.
3. open phpmyadmin/any application that uses mysql/mysql console and run a query.
4. cat /tmp/mysql.log ( you should see the query )
Install PostgreSQL on Debian 10 - Step by step process to do it ?
This article will guide you on how you can install PostgreSQL #DBMS on your Debian 10 system. Also, we also shared with you the method with which you can remove the PostgreSQL DBMS from your #Debian 10 system.
#PostgreSQL supports transaction s, subselects, trigger s, view s, foreign key referential integrity, and sophisticated locking.
pgAdmin is the de facto GUI tool for PostgreSQL, and the first tool anyone would use for PostgreSQL. It supports all PostgreSQL operations and features while being free and open-source. With pgAdmin you can Create, view and edit on all common PostgreSQL objects.
#PgAdmin is graphical user interface administration tool for PostgreSQL. It does not include a PostgreSQL database server.
To install PostgreSQL 9.5 on #Ubuntu:
1. sudo apt-get update.
2. sudo apt-get install postgresql postgresql-contrib.
3. sudo -u postgres psql.
4. # Replace xxxxxxx with your own password ALTER USER postgres WITH ENCRYPTED PASSWORD 'xxxxxxx';
5. # Feel free to replace nano with an editor of your choice sudo nano /etc/postgresql/9.5/main/pg_hba.conf.
ANALYZE in #Postgres collects statistics about the contents of tables in the database, and stores the results in the pg_statistic system catalog. Subsequently, the query planner uses these statistics to help determine the most efficient execution plans for queries.
Install MariaDB on CentOS 8 - Step by step process ?
This article will guide you on how to install MariaDB on your CentOS 8 system. Now you can create new databases and grant privileges to other database users. Also, you can add users and create new databases for web or desktop applications which will be written in PHP, Python, and so on.
In MariaDB replication is faster whereas in MySQL replication is slower.
MariaDB is Open Source whereas MySQL uses some proprietary code in its Enterprise Edition.
MariaDB doesn't support Data Masking and Dynamic column while MySQL supports it. Comparatively MariaDB is faster than MySQL.
To uninstall MariaDB and install mysql:
1. Purge mariadb sudo apt purge mariadb-* Remove all databases ('Yes' answer)
2. Purge mysql sudo apt purge mysql-*
3. Remove folders: sudo rm -r /usr/share/mysql/ sudo rm -r /etc/mysql/ sudo rm -r /lib/systemd/system/mysql.service.
4. Now you can try to install oracle mysql: sudo apt install mysql-server.
Install Wine on Debian 10 - Step by step process ?
This article will guide you on steps to install Wine on Debian via WineHQ repository. Also you will learn how to uninstall it from your system if you no longer need it.
For official documentation, you can visit Wine for Debian.
If you are working on Linux Mint OS, visit our post on How to Install Wine on Linux Mint 20 .
Wine stands for Wine Is Not an Emulator. While a virtual machine or emulator simulates internal Windows logic, Wine translates those Windows logic to native UNIX/POSIX-complaint logic.
In simple and non-technical words, Wine converts internal Windows commands to commands your Linux system can natively understand.
To Check Wine Version:
Wine installation successfully completed.
Use the following command to check the version of wine installed on your system
wine --version
A Linux repository is a storage location from which your system retrieves and installs OS updates and applications.
Each repository is a collection of software hosted on a remote server and intended to be used for installing and updating software packages on Linux systems.
Repositories contain thousands of programs.
Process to configure an NTP server and client on Ubuntu 20.04 LTS ?
This article will guide you on how to configure the NTP server on the #Ubuntu machine and then sync a clock of NTP client machine. Now you can easily set up NTP server and connect multiple client machines with it for time synchronization.
The Network Time Protocol (NTP) is a networking protocol for clock synchronization between computer systems over packet-switched, variable-latency data networks.
NTP is intended to synchronize all participating computers to within a few milliseconds of Coordinated Universal Time (UTC).
How do I start #NTP on Linux?
In order to add command line options to the ntpd service (/etc/init. d/ntpd), one has to edit /etc/sysconfig/ntpd file and add the desired option to the OPTIONS variable, and restart the service via 'service ntpd restart'.
What port does NTP use?
NTP time servers work within the TCP/IP suite and rely on User Datagram Protocol (UDP) port 123. NTP servers are normally dedicated NTP devices that use a single time reference to which they can synchronize a network.
This time reference is most often a Coordinated Universal Time (UTC) source.
To Sync NTP client with server via command line:
1. Edit the /etc/ntp.
2. Search for the lines beginning server .
3. Replace the server entries with the IP address or hostname of the NTP server or servers with which you want to synchronize.
4. Save the file.
5. Configure the NTP client service to start at run level 3 when the appliance boots.
Install Wine on Linux Mint 20 - Step by step process to do it ?
This guide will show you steps to install Wine on Linux Mint 20. Also, you will learn how to remove it once you no longer require this software on your system.
Wine is an open-source, free and easy-to-use program that enables Linux users to run Windows-based applications on Unix-like operating systems.
Wine is a compatibility layer for installing almost all versions of Windows programs.
The APT is the tool, commonly used to install packages, remotely from the software repository.
Basically, it's a simple command based tool that you use to install files/software. Complete command is apt-get and it's the easiest way to install files/Software packages.
To uninstall a program in Linux:
To uninstall a program, use the “apt-get” command, which is the general command for installing programs and manipulating installed programs.
For example, the following command uninstalls gimp and deletes all the configuration files, using the “ -- purge” (there are two dashes before “purge”) command.
How do I delete apt repository?
Whenever you add a repository using "add-apt-repository" command, it will be stored in /etc/apt/sources. list file.
To delete a software repository from Ubuntu and its derivatives, just open the /etc/apt/sources.
List file and look for the repository entry and delete it.
