Luasql - getting DCS to talk to mysql

[SoW Reddog]

I've been pratting around with this for a couple of days. Seems a few old threads point to it being done in the FC3 days but nothing very recent.

 

Can someone (anyone!) confirm that all I theoretically need to do is have a luasql folder containing the dll in the dcs world\bin folder, and correct syntax in a lua file. I don't need to point the lua file to reference the dll in any way?

[SoW Reddog]

Ok, some progress.

 

Using the mysql.dll from the example in this thread https://forums.eagle.ru/showthread.php?t=176486

 

I've managed to get luasql to load via require. However env=luasql.mysql () fails. And I get zero indication in dcs.log why.

 

Someone must have some idea about this.

[BaD CrC]

Wow. Not that we are not interested Reddog, but this probably sounds like crazy complicated for most of us (at least it does for me)

[Jabbers_]

try

 

local net               = require('net')

local status, err = pcall(function() 
   env=luasql.mysql ()
end)

if err then    
   net.log("mysql failed to load - "..err)
end

 

This should write something to the log.

[VladMordock]

Was anybody successful with lua to mysql scripting ?