Skip to main content

Adding ejabbed MYSQL schema to your database

The starting point is to read through and follow the notes outlined on the ejabberd site regarding adding database schema.  The purpose of this documentation is to clarify where the files were located for me.

The schema files can be found in ejabberd priv directory.  To find the priv directory, use the find command

Install Spyc library

Using shell access you the site you want to add the Spyc library.  Then go to the libraries directory and add the following commands:

mkdir spyc

cd spyc

wget https://github.com/mustangostang/spyc/blob/master/Spyc.php

To verify that Spyc is active, go to the status area of admin (admin/reports/status)

Installing erlang

To add Erlang repository that also includes the public key for verifying signed package, use the following shell commands:

wget https://packages.erlang-solutions.com/erlang-solutions-1.0-1.noarch.rpm

rpm -Uvh erlang-solutions-1.0-1.noarch.rpm

Install Erland

yum install erlang

Check that Erland has been installed enter the command (case sensitive)

Updating MYSQL 5.5 -> 5.7

To add ejabberd and run MYSQL to the server I needed to update the server version of mysql from 5.5 to 5.7.  Fortunately, there are great instructions on the Plesk support page regarding how to achieve this outcome.

Code conventions

Whatever you are coding - code clarity is your goal.

Adding a ssl certificate to ejabbered on apache

Adding a pem file to secure ejabbered on the server for chat connection.

Getting the pem file

I downloaded the pem file through Plesk (v17.8.11) under the SSL/TLS Certificates area.  Locate the certificate that you want to use and click the green arrow which when hovering will day download all certificate components.

ejabberd log

To access the ejabberd log files, I found them located at the following directory

cd /usr/local/var/log/ejabberd

The following files exist:

  • crash.log
  • ejabberd.log
  • error.log

 

Installing Erlang XMPP on Apache

I'm writing these steps primarily for myself as a reference.  However, if someone else finds them useful to great.

Adding XMPP framework to your server.  Initially I was going to add Prosody, however as I'm working off an Apache server with Centos 6.10 this quickly proved to a goal that was out of reach.  Instead, I pivoted and redirected to Erlang.  

Subscribe to