On Thu, 11 Feb 2016 22:18:08 -0800
"Stephen Graf" <s_g...@telus.net> wrote:
> When I tried to set up prosody with sql storage using mysql I
> followed the instructions in the package and added luadbi-mysql.
> However prosody did not seem to pick up on it even though the prosody
> documentation says that nothing more is required. When I looked into
> what luadbi-mysql provided I discovered a c library, dbdmysql.so. How
> is this converted to a lua file that prosody can use?
>
What did you try after enabling the sql storage in prosody? Here are
the config changes I made (slightly redacted) to get prosody to use my
postgres database.
storage = "sql" -- Default is "internal"
-- For the "sql" backend, you can uncomment *one* of the below to configure:
--sql = { driver = "SQLite3", database = "prosody.sqlite" } -- Default.
'database' is the filename.
--sql = { driver = "MySQL", database = "prosody", username = "prosody",
password = "secret", host = "localhost" }
sql = { driver = "PostgreSQL", database = "prosody", username = "prosody",
password = "secret", host = "localhost" }
Regards,
Adam
