Now Your MySQL database is ready to connect with ejabberd.ĥ. It will show you the existing tables in MySQL database. You can load the downloaded schema of ejabberd in your new 'ejabberd' database with the following command:/p> $ mysql -D ejabberd -u ejabberd -p SHOW TABLES You can download it by the command below: $ wget You can find the latest version of the MySQL schema in ejabberd Github repository. Type '\c' to clear the current input statement. Now you will see the welcome message along with information about MySQL and your system, like the one below: Now You should be able to connect to MySQL database 'ejabberd' with user 'ejabberd' $ mysql -u ejabberd -p -D ejabberd Now new user ' ejabberd' have permission to access database. Grant all privileges on ejabberd.* to '%' indentified by 'password' You can connect to the database with your root user: $ mysql -uroot -pĬreate a dedicated 'ejabberd' database: CREATE DATABASE ejabberd Now start Mysql as follows: $ mysql start
#Ejabberd mnesia tables install
You need to install Mysql version 5.6 or above to use with ejabberd. Now you need to configure ejabberd to include MySQL. So you can download latest ejabberd by simply clonning its git repo: $ git clone ejabberd We are going to install ejabberd by downloading latest source. So we are going to give a step by step guide to make ejabberd working with mysql. Although ejabberd has its default database called Mnesia but when you want to access this database,you have to learn this new database.so if you have used sql database earlier then it will be easy for you to use mysql with ejabberd.įor using Mnesia database,you do not need to do anything it comes by default with ejabberd installation but if you want use mysql instead of Mnesia then you need to enable it at the time of ejabberd installation and after installation you have to configure mysql in the configuration file of ejabberd called " ejabberd.yml".
0 kommentar(er)
