Connection not attempted, no error

[crosscoder1]

Info :
Gmod 32 bit server
MariaDB Server v10.6.22
mysqloo 9.76, 9.8 beta2, and self compiled from git
Ubuntu 22.04.5 LTS

Since I don't see any other issues like this in the bug tracker or through my searches, I am guessing this may not be a bug with the library, but I have tried everything else I can think of.

I have an addon I've been attempting to set up to use mysqloo but couldn't get it to connect. The module appears to be loaded since I can do lua_run with the mysqloo include without error. To troubleshoot, I took the example connection script and placed it in the server autorun folder. When the script is executed, I see that the line to connect to the database is processed without error, but no callback is processed. When I do this, there are players connected to the server so it's not hibernating. Further, I put MariaDB in verbose general log mode and it never shows a connection attempt from the Garrysmod script. However, if I connect with the mysql-client either by TCP or socket, those are logged. I've tried several versions of mysqloo and even compiled the latest from git directly on the server just in case.

Hopefully it's just something stupid I am overlooking. Any suggestions would be greatly appreciated.

[FredyH]

This would be very hard to debug, but it is unlikely to be a problem with the library as it works for other people.
Since you say that the server is not hibernating, another cause could be that MySQLOOs Think hook is not being run correctly (although this is a bit of a long shot). This could either be due to

• Errors in other hooks
• A custom hook library that ignores the MySQLOO hook
• Someone deregistered the MySQLOO Think hook for some reason

I suppose you can test this yourself by printing the results of hook.GetTable()["Think"].

[crosscoder1]

Thanks for the reply and I apologize, I figured this was more of a support issue than a bug but I couldn't find another avenue to ask. When I print the table from the command above, I see the hook appears to be registered. I guess the next step is unfortunately to start removing addons to narrow it down by process of elimination?

    ["Wire_Expression2_Find_AddCount"]      =       function: 0xeffa9b72  
    ["__MySQLOOThinkHook"]  =       function: 0xefa848aa  
    ["a_zlm_FreezeVehicles"]        =       function: 0xe4c90da2  

[FredyH]

Which example script were you running exactly? At least one of the callbacks should be run. It would probably be good to also add prints after starting the queries just to make sure the code actually gets executed.

[crosscoder1]

Basically it is just the database.lua script in the examples. None of the callbacks there are fired at all. I did add a print after the connect statement and it returns a userdata object.

[FredyH]

It might also be the case that some relevant packets are being blocked by your firewall or similar, you could try calling

db:setReadTimeout(10)
db:setWriteTimeout(10)
db:setConnectTimeout(10)

before you attempt the connection, see if that causes a timeout error.