Problems installing LuaSQL

[LuisCoves]

I downloaded other rocks using LuaRocks but it looks like downloading LuaSQL using LuaRocks is impossible.
I've tried downloading it for MYSQL both from my computer and online but both gave me the same problem, I also tried for Postgres but have the same issue does anybody have any clue how to fix? Thx. :'(

[tomasguisasola]

It seems the compiler found out how to compile LuaSQL code (all lines compiling object code (.o files) seem to have succeeded), but could not link it against the database library (the line with -o option and the name of the final .dll driver). Check whether the path (-L) correctly points to the correct path AND whether the name of the database library (-l) name it correctly.

[LuisCoves]

It seems the compiler found out how to compile LuaSQL code (all lines compiling object code (.o files) seem to have succeeded), but could not link it against the database library (the line with -o option and the name of the final .dll driver). Check whether the path (-L) correctly points to the correct path AND whether the name of the database library (-l) name it correctly.

Thanks for your answer! I've checked does this paths look correct?, are all files correctly named?

[tomasguisasola]

My Windows knowledge is very limited, so I have to say that I am not sure I can help you. You'd better check with someone more experienced with Windows.

Anyways, what seems strange to me is that only one library is mentioned in each invocation you tried (-llibmysql or -lmysqlclient) but there are two libraries at this directory. Can you try adding both of them? What I mean is manually execute one of the last lines showed at your tests, but adding -lmysqlclient -llibmysql (yes, double 'l'). Could you ?

[LuisCoves]

I've tried this simple line and it looks like it can find one of the libraries but not the second one (libmysql), but both of the libraries can be found on the directory any ideas why?

[tomasguisasola]

Note that the message states that "-llibmysql" is missing, not "libmysql". It seems the compiler is considering "-llibmysql" as the name of a file to compile. I think your command line is missing something. Please try (I hope I have not mistyped anything!):

mingw32-gcc -shared -o luasql\mysql.dll src\luasql.o src\ls_mysql.o -LC:\Program Files\MySQL\MySQL Server 5.7\lib -llibmysql -lmysqlclient C:\luarocks-3.9.2-win32\win32\lua5.1\bin\lua5.1.lib -lMSVCR80