Following the Prosody installation tutorial I wrote last time you’ll notice that we didn’t touch any database configuration for storage, therefore Prosody will use the default storage, the file system.
Here is how to use MySQL as storage backend for Prosody.
Prosody is a free and open source software that provides XMPP/Jabber server service for chat or instant messaging. It has multi-domain supports and other XMPP/Jabber features.
Let’s install it, configure it and use it. I’ll be using Ubuntu server 14.04 and Prosody from apt-get.
Upgrade the server and reboot:
[code lang=text]
sudo apt-get -y update
sudo apt-get -y upgrade
sudo reboot
[/code]
Please note that you may skip above steps if you know what you’re doing.
Install Prosody:
[code lang=text]
sudo apt-get -y install prosody
[/code]
That’s it. Installation is finished. Next is to create SSL certificates and do some basic configuration.