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.
Updating ejabberd
Overview
To update ejabberd you need to remove it, then re-install with the latest version. However, do check for database changes before initiating this process from the ejabberd documentation site (https://docs.ejabberd.im/admin/upgrade/).
Adding a Custom Font to Your App
For detailed notes regarding how to add custom fonts to your iOS app see Apple's custom font notes.
Code conventions
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.