To verify that everything is correct, run a command to display all the database tables, again using the ejabberd MariaDB user, and the output should look something like that: echo "SHOW TABLES " | mysql -h localhost -D ejabberd -u ejabberd -p -table Mysql -h localhost -D ejabberd -u ejabberd -p < mysql.sql This time, we are switching to using the ejabberd MariaDB user, and the Enter password prompt is asking for the password we just specified in the GRANT command above: wget The Enter password prompt is again asking about the root MariaDB user: echo "GRANT ALL ON ejabberd.* TO IDENTIFIED BY 'password' " | mysql -h localhost -u root -pįinally, let’s download the latest ejabberd SQL schema and load it into our database. Next, let’s create a dedicated ejabberd user authenticated with a password, and assign it to this database. To get MariaDB ready for ejabberd, we need to create a new database, its user, and then populate the database with the ejabberd SQL schema.įirst, let’s create the database using your MariaDB root user: echo "CREATE DATABASE ejabberd " | mysql -h localhost -u root -p Then run the installation wizard and follow the instructions: mysql_secure_installation To install MariaDB simply use: apt-get install mariadb-server I have updated my ejabberd to version 21.01 (the update process is the same as the initial ejabberd installation, so check my first tutorial). We assume the usual Debian configuration as in my previous tutorials. ProcessOne experts will make your communication scalable.
EJABBERD MNESIA TABLES HOW TO
Today, I will show you how to install MariaDB, a MySQL-compatible database, migrate your data and configure ejabberd to use MariaDB instead of Mnesia. It is great for home and small office environments, but in larger companies, as the amount of chat logs and users grows, we need more scalability. By default, ejabberd uses the Mnesia internal database.
0 kommentar(er)
