Arch Linux

Using the sql storage available in prosody 0.8 will fail due to missing luadbi dependency.

* set "storage = "sql""
* uncomment e.g. "sql = { driver = "MySQL", database = "prosody", username = "root", password = "", host = "localhost" }"
* start mysql, create mentioned database and user
* start prosody (at this point the initscript should fail but it does not)
* Try any command like "prosodyctl adduser me@example.com" and you will get:

example.com:storage_sql error Failed to load the LuaDBI library for accessing SQL databases: module 'DBI' not found:
no field package.preload['DBI']
no file '/usr/lib/prosody/DBI.lua'
no file '/usr/share/lua/5.1/DBI.lua'
no file '/usr/share/lua/5.1/DBI/init.lua'
no file '/usr/lib/lua/5.1/DBI.lua'
no file '/usr/lib/lua/5.1/DBI/init.lua'
no file '/usr/lib/prosody/DBI.so'
no file '/usr/lib/lua/5.1/DBI.so'
no file '/usr/lib/lua/5.1/loadall.so'
example.com:storage_sql error More information on installing LuaDBI can be found at http://prosody.im/doc/depends#luadbi
storagemanager warn Falling back to null driver for accounts storage on example.com