On Wed, Dec 04, 2019 at 08:16:49PM +0100, Bjoern Schiessle wrote:
> Hi,
>
> I run the XMPP server Prosody on a Debian server which I recently
> updated to Buster. Since the update the Prosody server refuses to
> connect to the MariaDB database. The log shows following error:
>
> Nov 30 22:09:15 sql debug Connecting to [MySQL] prosody...
> Nov 30 22:09:15 sql debug Database connection was closed. Will
> reconnect and retry.
> Nov 30 22:09:15 sql debug Retrying SQL transaction
> [function(mod_storage_sql.lua:137)]
> Nov 30 22:09:15 sql debug Connecting to [MySQL] prosody...
> Nov 30 22:09:15 sql debug SQL transaction retry failed
> Nov 30 22:09:15 sql error Error in SQL transaction:
> /usr/local/share/lua/5.2/DBI.lua:53: Cannot load driver MySQL.
^^^^^Hm. This looks like a locally installed driver, not the distribution's... > Available drivers are: SQLite3 > > It looks like the MySQL driver is not installed. But both packages, > "lua-dbi-mysql/stable,now 0.7.1-2 amd64" and "lua-sql-mysql/stable,now > 2.3.4-1+b1 amd64" are installed. Perhaps you can play around by setting the environment variables LUA_PATH (and/or LUA_CPATH) to have /usr/share/lua before /usr/local/share/lua? Or, if you don't need the stuff in /usr/local/share/lua, perhaps move it out of the way. What's the version of Lua you're using (Buster has the whole array from 5.0 to 5.3 on offer, it seems). > If I install additionally "lua-dbi-postgresql" the last error message > changes to: > > Nov 30 22:09:15 sql error Error in SQL transaction: > /usr/local/share/lua/5.2/DBI.lua:53: Cannot load driver MySQL. > Available drivers are: SQLite3, PostgreSQL > > Therefore I assume that the lua-dbi-* packages are the right one. But > for some reasons the MySQL driver is not detected/installed correctly. Yes, but most probably it's finding the wrong ones, in /usr/local Cheers -- tomás
signature.asc
Description: Digital signature
