Search the Community

Hello! I have a local network home server (192.168.0.4) for storage and other service server running. On this server I run Ubuntu server with CasaOS. I recently made two custom flask apps, one for a XAMPP manager and one for an MTA Server Manager so I can easily have a web UI on two different ports. I setup everything successfully, I could run and join to an FTP server from my main desktop PC (192.168.0.122) or laptop, manage MTA servers correctly, start and stop them, join them, open and run phpMyAdmin. But when I got to the part to run the MTA server on the server PC, and setup the MySQL database connection I run into an issue regarding linux. [02:25:51] Starting Database [02:25:51] ERROR: Could not load /home/hmsvr/ftp/servers/LegendaryLegacy/SA/x64/dbconmy.so - /lib/x86_64-linux-gnu/libssl.so.1.1: version `OPENSSL_1_1_1' not found (required by /home/hmsvr/ftp/servers/LegendaryLegacy/SA/x64/dbconmy.so) [02:2 5:51] WARNING: [Engine]/[Main]/Database/S_Database.lua:17: Bad usage @ 'dbConnect' [Could not connect] [02:25:51] ERROR: [Engine]/[Main]/Database/S_Database.lua:27: Database connection failed; When I start the server on my desktop PC, but still use the server PC to run the Apache, MySQL and FTP, I can successfully connect to the MySQL server running on my server PC. G_Database.lua & S_Database.lua sections for context DATABASE_DETAILS = { ["host"] = "192.168.0.4", -- "127.0.0.1" or "localhost" if the mysql server - XAMPP - runs on your PC, or "your server ip" if you have a separate PC or VPS ["port"] = 3306, -- Provided in XAMPP control panel or my.ini / my.cnf ["username"] = "mysql", -- Provided in phpMyAdmin or my.ini / my.cnf ["password"] = "", -- Provided in phpMyAdmin or my.ini / my.cnf - none by default ["database"] = "mta-ll", -- Rename if you are using different database or create one with this name } ---------------------- DATABASE = { CONNECTION = nil, RECONNECT_TIMER = nil } function connectDatabase() DATABASE.CONNECTION = dbConnect("mysql", "dbname="..DATABASE_DETAILS["database"]..";host="..DATABASE_DETAILS["host"]..";port="..DATABASE_DETAILS["port"], DATABASE_DETAILS["username"], DATABASE_DETAILS["password"], "log=1") if DATABASE.CONNECTION then print("Database connection successful") if isTimer(DATABASE.RECONNECT_TIMER) then killTimer(DATABASE.RECONNECT_TIMER) end DATABASE.RECONNECT_TIMER = nil --prepareDatabase() return true else error("Database connection failed; retrying in 5 seconds") DATABASE.RECONNECT_TIMER = setTimer(function() connectDatabase() end, 5000, 1) return false end end function disconnectDatabase() if not DATABASE.CONNECTION then return false end DATABASE.CONNECTION = nil print("Database connection closed") if isTimer(DATABASE.RECONNECT_TIMER) then killTimer(DATABASE.RECONNECT_TIMER) end DATABASE.RECONNECT_TIMER = nil return true end addEventHandler("onResourceStart", resourceRoot, function() connectDatabase() return true end) addEventHandler("onResourceStop", resourceRoot, function() disconnectDatabase() return true end) I already had OpenSSL installed when I checked the version, but also my version is 3.0 something. I was looking on many forums on how to get OpenSSL 1.1.1 as the error message requires but I didn't find any easy solutions apart from building from source and many complicated commands which I am not sure how to revert if it doesn't solve the issue. I downloaded some .deb file from ubuntu archive and istalled it via a forum post but I don't remember which one was it, because at first I got an error message saying that the libssl.so1.1 directory didn't exist or something similar, that's why I then tried to install that but then realised I have a newer OpenSSL version. I didn't even know I will have to f*ck around with OpenSSL for the sake of MTA SA MySQL database handling, nor I had to do this previously - well previously I didn't use MTA Linux Server on linux either. Does anybody have any suggestions how could I possibly solve this issue so I am able to run the linux version of MTA server on my home network Ubuntu linux server alongside the XAMPP / LAMPP Apache MySQL and FTP servers? I followed the tutorial on the MTA SA Linux Server Tutorial page. This is currently the only thing keeping me away from finishing what I've been wanting to do for a long time for a home network MTA development environment to be able to store and access and edit the server files on a separate server PC from various other devices. I am planning on releasing the flask apps for the XAMPP and MTA server managers later on in case anybody needs something similar, or also it could be used as good templates if you want to create docker images from it or so on, however the code may not be production ready but will be free to use and adjust. Thank you for your time response and help in advance!

I've downloaded the latest version of mta for linux from https://linux.multitheftauto.com/dl/multitheftauto_linux_x64.tar.gz and I'm getting a warning that increase the ping and the memory usage. How can I solve this? The log: The resources download link: https://mirror.multitheftauto.com/mtasa/resources/mtasa-resources-latest.zip ================================================================== = Multi Theft Auto: San Andreas v1.5.8 [64 bit] ================================================================== = Server name : MTA Server = Server IP address: 158.69.238.128 = Server port : 22003 = = Log file : ..ame/admin/1/mods/deathmatch/logs/server.log = Maximum players : 32 = HTTP port : 22005 = Voice Chat : Disabled = Bandwidth saving : Medium ================================================================== [21-02-26 03:52:23] Resources: 191 loaded, 0 failed [21-02-26 03:52:23] Starting resources... [21-02-26 03:52:23] Server minclientversion is now 1.5.7-9.20621.0 [21-02-26 03:52:23] Gamemode 'play' started. [21-02-26 03:52:23] Authorized serial account protection is enabled for the ACL group(s): `Admin` See https://mtasa.com/authserial [21-02-26 03:52:23] WARNING: <owner_email_address> not set [21-02-26 03:52:23] Server started and is ready to accept connections! [21-02-26 03:52:23] To stop the server, type 'shutdown' or press Ctrl-C [21-02-26 03:52:23] Type 'help' for a list of commands. [21-02-26 03:52:23] Querying MTA master server... success! (Auto detected IP:158.69.238.128) [21-02-26 05:48:26] DIAGNOSTIC: zxcvbnnmm #1013 HTTP server file mismatch (admin) ad.png [Got size:0 MD5:00000000000000000000000000000000, wanted MD5:5AC858EC0A581D9AFC4B1440EBC9A2F7] [21-02-26 05:48:26] DIAGNOSTIC: zxcvbnnmm #1013 HTTP server file mismatch (admin) je.png [Got size:0 MD5:00000000000000000000000000000000, wanted MD5:03D1D6D7BEE2E903D6010FE014CE875B] [21-02-26 05:48:26] DIAGNOSTIC: zxcvbnnmm #1013 HTTP server file mismatch (admin) kg.png [Got size:0 MD5:00000000000000000000000000000000, wanted MD5:E2AC5B5869CD6358746A51D983917440] [21-02-26 05:48:26] DIAGNOSTIC: zxcvbnnmm #1013 HTTP server file mismatch (admin) kr.png [Got size:0 MD5:00000000000000000000000000000000, wanted MD5:EEFDF9EEAFDE9FD34417E3E014D62690] [21-02-26 06:20:15] WARNING: [gamemodes]/[play]/play/broph.lua:147: Bad usage @ 'addEventHandler' ['onVehicleEnter' with this function is already handled] [21-02-26 06:31:55] WARNING: [gamemodes]/[play]/play/broph.lua:147: Bad usage @ 'addEventHandler' ['onVehicleEnter' with this function is already handled] [21-02-26 06:40:06] WARNING: [gamemodes]/[play]/play/broph.lua:147: Bad usage @ 'addEventHandler' ['onVehicleEnter' with this function is already handled] [21-02-26 06:41:01] WARNING: [gamemodes]/[play]/play/broph.lua:147: Bad usage @ 'addEventHandler' ['onVehicleEnter' with this function is already handled] 1 4 1 1 4 1

Hi I have a problem whit starting the linux server i use ubunu 19.XX the ssh says: root@server:~/mta# ./mta-server64 libncursesw.so.5: cannot open shared object file: No such file or directory ERROR: Could not load ./x64/core.so * Check installed data files. Press enter to continue... q root@server:~/mta# ldd /x64/core.so ldd: /x64/core.so: No such file or directory root@server:~/mta# ldd root/mta/x64/core.so ldd: root/mta/x64/core.so: No such file or directory root@server:~/mta# ldd x64/core.so linux-vdso.so.1 (0x00007fff41da0000) libncursesw.so.5 => not found libtinfo.so.5 => not found librt.so.1 => /lib/x86_64-linux-gnu/librt.so.1 (0x00007f43d12c7000) libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f43d1179000) libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f43d1158000) libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f43d0f6d000) /lib64/ld-linux-x86-64.so.2 (0x00007f43d164b000) #root@server:~/mta# ./mta-server64 libncursesw.so.5: cannot open shared object file: No such file or directory ERROR: Could not load ./x64/core.so * Check installed data files. Press enter to continue... root@server:~/mta# I have core.so i also try apt-get install lib32readline5

Hi, I have a stable running MTA client in ubuntu 16.04 but when I join a server the HTML pages aren't loading why? I was joining the ffs-gaming server which uses HTML page for login. To recheck I joined in my own server and started web browser resource but still, nothing happened! Thanks in advance!