Based on "prosody-0.9.8-4.el6.x86_64", I guess that this is my RPM package
from EPEL 6. If so:
- Run "yum install prosody lua-dbi"
- Create a MySQL user and database on the MySQL server
- Edit "/etc/prosody/prosody.cfg.lua" configuration file
- Set "storage" to "sql"
- Uncomment second "sql" line and add proper MySQL data
- Start prosody, e.g. "service prosody start"
- Create a user e.g. using "prosodyctl adduser JID"
- Connect with your XMPP client using that JID
In case you did exactly these steps already (which can't be assumed by the
steps you mentioned before), check if the MySQL database contains a table
called "prosody" (that means that prosody is able to connect to your MySQL
server properly at least). If the table is empty the MySQL configuration is
likely wrong/incomplete. The logs in /var/log/prosody/prosody.* may provide
hints about the cause. An error message from the logs would be helpful in
case the steps above are not leading to success.
Thanks,
Robert