• Gm_MySql v1.0 - OO edition.
    824 replies, posted
  • Avatar of Fleamonji
  • Does this not work on Linux? I know that there's a binary for it, but it doesn't load. There's also no libthing that goes in orangebox [editline]16th April 2011[/editline] No libMYSQL.dll in the Linux one, that's it. Module won't load without it I believe
  • I think you need to use libmysql.so for Linux. [editline]16th April 2011[/editline] It should be in /usr/lib/mysql/ .
  • Avatar of mr.wolf
  • Look for my posts a few pages back. They tell you how to get it working for linux. Really should be in the OP, but whatever.
  • Here's the ones from my server if anyone needs them: [url]http://82.192.94.157/f/libmysql-linux.zip[/url]
  • [QUOTE=silverblu;29224888]Here's the ones from my server if anyone needs them: [url]http://82.192.94.157/f/libmysql-linux.zip[/url][/QUOTE] Lawl. Just the IP Number with No Domain, Obvious Virus. I do NOT RECOMMEND DOWNLOADING THIS.
  • Avatar of mr.wolf
  • [QUOTE=mr.wolf;27973105][url]http://www.facepunch.com/threads/933647-Gm_MySql-v1.0-OO-edition.?p=25138989&viewfull=1#post25138989[/url] Also, rename the binaries to gmsv_mysqloo_linux.dll and gmcl_mysqloo_linux.dll[/QUOTE]
  • Avatar of Buggzie
  • [QUOTE=Michaelranger;29225190]Lawl. Just the IP Number with No Domain, Obvious Virus. I do NOT RECOMMEND DOWNLOADING THIS.[/QUOTE] [url]http://192.168.0.1[/url] Lawl Just the IP number with no domain, Obvious Virus Now how am I gonna setup my router!? It's a zip containing .so files. What's so virusy about that? I'm feeling genourous, if you think it's a virus then use this alternative link: [url]http://storage.gmodsvns.net/libmysql-linux.zip[/url]
  • [QUOTE=Buggzie;29225886][url]http://192.168.0.1[/url] Lawl Just the IP number with no domain, Obvious Virus Now how am I gonna setup my router!? It's a zip containing .so files. What's so virusy about that? I'm feeling genourous, if you think it's a virus then use this alternative link: [url]http://storage.gmodsvns.net/libmysql-linux.zip[/url][/QUOTE] subdomain = virus get reel domaen then i download -.- [highlight](User was banned for this post ("Shit posting" - Swebonny))[/highlight]
  • Avatar of Buggzie
  • [QUOTE=Michaelranger;29226094]subdomain = virus get reel domaen then i download -.-[/QUOTE] I can't understand this, but are you being sarcastic? Kinda hard to tell with text.
  • [QUOTE=Fleamonji;29215914]Does this not work on Linux? I know that there's a binary for it, but it doesn't load. There's also no libthing that goes in orangebox [editline]16th April 2011[/editline] No libMYSQL.dll in the Linux one, that's it. Module won't load without it I believe[/QUOTE] Install the MySQL lib with apt-get
  • Avatar of Jaastin
  • [QUOTE=Bubka3;24511444]He only compiled it for 32bit windows. Basically libmySQL exists in 64bit. Just need the other 2 DLLs recompiled. [b]EDIT:[/b] I found a work around. Instead of recompiling it, just install the 32bit visual libraries. [url]http://www.microsoft.com/downloads/details.aspx?FamilyID=9b2da534-3e03-4391-8a4d-074b9f2bc1bf&displaylang=en[/url][/QUOTE] Confirming, this works. PROBLEM! MySQL server has gone away. Line 59, of Data.
  • Avatar of mr.wolf
  • [QUOTE=Jaastin;29360085]Confirming, this works. PROBLEM! MySQL server has gone away. Line 59, of Data.[/QUOTE] Means your connection died from idling for too long.
  • Avatar of Buggzie
  • [QUOTE=Jaastin;29360085]Confirming, this works. PROBLEM! MySQL server has gone away. Line 59, of Data.[/QUOTE] Try to either change mysql commandline connect-timeout or get the lua script to reconnect.
  • see [url]http://www.facepunch.com/threads/933647-Gm_MySql-v1.0-OO-edition.?p=26221004&viewfull=1#post26221004[/url] for info about changing the timeout at runtime
  • Avatar of mr.wolf
  • [QUOTE=zzaacckk;29386785]Now I connected .. but how do I disconnect?[/QUOTE] Would setting the connection to nil terminate the connection?
  • Avatar of Buggzie
  • [QUOTE=zzaacckk;29386785]Now I connected .. but how do I disconnect?[/QUOTE] That's a rather good point, not even tmysql has a disconnect...
  • Avatar of zzaacckk
  • [QUOTE=Buggzie;29388032]That's a rather good point, not even tmysql has a disconnect...[/QUOTE] Yea. I am thinking of designing a php mysql tool for server owners so they can run queries that way and have it highly customized.
  • Avatar of mr.wolf
  • [QUOTE=zzaacckk;29388754]Yea. I am thinking of designing a php mysql tool for server owners so they can run queries that way and have it highly customized.[/QUOTE] wait... wut?
  • Avatar of zzaacckk
  • Or you could check if the connection is still alive and if not then reconnect and run the query.
  • Avatar of mr.wolf
  • [QUOTE=zzaacckk;29389311]Or you could check if the connection is still alive and if not then reconnect and run the query.[/QUOTE] Agreed. Just be sure to check and see if it is doing science and still alive.
  • Avatar of zzaacckk
  • [QUOTE=Teddi Orange;29397236]Yes, setting the object to nil will close the connection.[/QUOTE] AFAIK, the connection will still be open you will just be unable to access it.
  • Avatar of Teddi
  • If you unreference the object the connection [I]should[/I] automatically close.
  • Avatar of mr.wolf
  • [QUOTE=Teddi Orange;29397423]If you unreference the object the connection [I]should[/I] automatically close.[/QUOTE] That was my point. I hadn't tested it though.
  • Avatar of TGiFallen
  • [QUOTE=zzaacckk;29397388]AFAIK, the connection will still be open you will just be unable to access it.[/QUOTE] And once you are unable to access it the Lua garbage collector will unallocate the connection from memory, and then the connection will be closed.
  • Avatar of mr.wolf
  • [QUOTE=TGiFallen;29402229]And once you are unable to access it the Lua garbage collector will unallocate the connection from memory, and then the connection will be closed.[/QUOTE] Indeed. It is interesting to see how many people think of connections as magical gateways that exist outside of normal programming. Network connections are two machines ( or even one, or more than two :O ) that are sending information to each other. If one of those two machines stops sending data, the connection is closed. AFAIK, mysql gets pings as long as an active connection is open, and closes when it stops getting those pings. When it gets a request for data, it does the query and sends the data back. So idle connections only take up ping-sized bandwidth, and once the pings stop, mysql closes that connection. So once the mysqloo instance is dropped from memory, the connection dies since it isn't being kept up by the server any more. Please correct me if I am wrong.
  • Avatar of zzaacckk
  • [QUOTE=mr.wolf;29411805]Please correct me if I am wrong.[/QUOTE] You are all wrong. [img_thumb]http://img571.imageshack.us/img571/684/proofinvalid.png[/img_thumb] As you see the code I ran is to the right. II first did a netstat After that I opened the connection I did anothe netstat and it showed the connection had opened I then nilled the connection I performed another netstat and noticed the connection was still open This proves that nilling the connection dosent close the connection, it just makes you unable to access it.
  • Avatar of NightExcessive
  • [QUOTE=zzaacckk;29415058]You are all wrong. [img_thumb]http://img571.imageshack.us/img571/684/proofinvalid.png[/img_thumb] As you see the code I ran is to the right. II first did a netstat After that I opened the connection I did anothe netstat and it showed the connection had opened I then nilled the connection I performed another netstat and noticed the connection was still open This proves that nilling the connection dosent close the connection, it just makes you unable to access it.[/QUOTE] Garbage collection doesn't run immediately after you nil the connection. [b][url=http://wiki.garrysmod.com/?title=G.collectgarbage]G.collectgarbage [img]http://wiki.garrysmod.com/favicon.ico[/img][/url][/b]