LuaSQL

(TimOOn) #1

Hello,

Has anyone of you ever used LuaSQL on ET server? I’m trying to install this on silent mod. I managed to make it work on Windows on my PC, but can’t do the same thing on Linux. I’m using binaries NOQ When I try to use mysql I get an error:

1916:49 Lua API: G_LuaStartVM error running lua script: error loading module 'luasql.mysql' from file '/home/data//242477.et/silent/lualibs/luasql/mysql.so':
	libssl.so.0: cannot open shared object file: No such file or directory

I don’t have terminal access so I asked server maintainer to install libssl but it didn’t help. I’m still getting the same error message. Do you have any idea how to fix this?

(jemstar) #2

Hi Tim00n,

I use NOQ on my NQ server. Linux.

I use this http://www.donkeypunch.clanservers.com/etmain/libmysqlclient.so.15

It’s in my basepath.

I hope this helps.
Jem.

Also you probably know this site, but incase you dont its a great help…there is a forum as well but may not be too active of late: http://dev.kernwaffe.de/projects/noq/wiki/Installation

(ETJump-Zero) #3

I don’t know if it’s going to work but you could try downloading libssl.so and putting it into the folder?

(TimOOn) #4

[QUOTE=jemstar;519912]
I use this http://www.donkeypunch.clanservers.com/etmain/libmysqlclient.so.15[/QUOTE]
This file doesn’t make any change unfortunately.
And yes I know this site, I did everything as they suggested.

I wanted to download luassl.so file and just put it in my basepath but couldn’t find it anywhere.

(gaoesa) #5

Are you using the qagame.mp.i386.so from the dynamic_lua directory of the silent zip? It is necessary to use that version and a separate lua5.1.so if you wish to load additional libraries for Lua.

(TimOOn) #6

Yes I am using files from dynamic_lua. And lua5.1.so I used also comes from NOQ files.

(jemstar) #7

I just checked my posts in the NOQ forum…I had the exact same issue:

Lua API: G_LuaStartVM error running lua script: error loading module 'luasql.mysql' from file '/usr/local/games/et/661350/8.2.121.145:27960/nq/lualibs/luasql/mysql.so':
libmysqlclient.so.15: cannot open shared object file: No such file or directory

Luborg (developer of NOQ) replied:

libmysqlclient is a shared system library, wich means your hoster needs to get the right one into his environment, or you need to get a precompiled library fitting for your hosters environment and place it where you need it.
If you do not need mysql, edit the config and use another dbms, or disable the databasepart completly(also in the config), cause then it should not try to load this library.

So I use the file I linked above, but I remember I did get Gameservers to find and load it.

I guess if you want to use luassl.so ask your hosters to find one for their machines.

Also as Gaoesa says you will need qagame.mp.i386.so. I tried a few before I could get it to work.

Let us know how you get on.

I’m no expert but thru trial and error I got it to work and like NOQ, I have reinstalled it twice more since and each time has been a little fiddly but usually a file in the wrong directory or wrong version for system.

Also I use Zelly’s LuaESMod on my Legacy server as legacy has no shrubbot, it may do what you need…like xp, shrub(admin) cmds and lua functions. Works well and uses JSON.lua so no need for mysql DB. All saved on your server. Alot simpler to set up. Does mostlty what NOQ does really…just in a diferent way.

http://forums.warchest.com/showthread.php/42372-Lua-Enhanced-Server-Module

(trAnc3) #8

I have no idea about lua sql installation, but path to the module looks fvcked up:

G_LuaStartVM error running lua script: error loading module 'luasql.mysql' from file '/home/data[B]//[/B]242477.et/silent/lualibs/luasql/mysql.so':
(TimOOn) #9

OK I finally made it work.
I downloaded libssl1.0.0 package from debian.org, unpacked it using cygwin and then I put libssl.so.0 to my basepath. This fixed my problem.
Thanks for help.