search

FredyH / MySQLOO

MySQLOO
GNU Lesser General Public License v2.1
140 stars 55 forks source link

Phpmyadmin won't connect to gmod database #49

Closed Invilein closed 4 years ago

Invilein commented 4 years ago

did all it needed

RP_MySQLConfig.EnableMySQL = true -- Set to true if you want to use an external MySQL database, false if you want to use the built in SQLite database (garrysmod/sv.db) of Garry's mod. RP_MySQLConfig.Host = "localhost" -- This is the IP address of the MySQL host. Make sure the IP address is correct and in quotation marks (" ") RP_MySQLConfig.Username = "root" -- This is the username to log in on the MySQL server. -- contact the owner of the server about the username and password. Make sure it's in quotation marks! (" ") RP_MySQLConfig.Password = "MyPasswordHere" -- This is the Password to log in on the MySQL server, -- Everyone who has access to FTP on the server can read this password. -- Make sure you know who to trust. Make sure it's in quotation marks (" ") RP_MySQLConfig.Database_name = "DarkRP" -- This is the name of the Database on the MySQL server. Contact the MySQL server host to find out what this is RP_MySQLConfig.Database_port = 3306 -- This is the port of the MySQL server. Again, contact the MySQL server host if you don't know this. RP_MySQLConfig.Preferred_module = "mysqloo" -- Preferred module, case sensitive, must be either "mysqloo" or "tmysql4". Only applies when both are installed. RP_MySQLConfig.MultiStatements = false

FredyH commented 4 years ago

This seems like an issue with that addon, I am also not sure exactly what the problem is supposed to be.

Invilein commented 4 years ago

Couldn't include file 'includes/modules/mysqloo.lua' (File not found) (@gamemodes/darkrp/gamemode/libraries/mysqlite/mysqlite.lua (line 132))

[DarkRP] gamemodes/darkrp/gamemode/libraries/mysqlite/mysqlite.lua:132: Module not found!

  1. require - [C]:-1
    1. loadMySQLModule - gamemodes/darkrp/gamemode/libraries/mysqlite/mysqlite.lua:132
    2. unknown - gamemodes/darkrp/gamemode/libraries/mysqlite/mysqlite.lua:141
      1. include - [C]:-1
      2. unknown - gamemodes/darkrp/gamemode/init.lua:42

[DarkRP] gamemodes/darkrp/gamemode/modules/fadmin/fadmin/motd/sv_init.lua:14: attempt to index global 'MySQLite' (a nil value)

  1. unknown - gamemodes/darkrp/gamemode/modules/fadmin/fadmin/motd/sv_init.lua:14
    1. include - [C]:-1
    2. AddCSLuaFolder - gamemodes/darkrp/gamemode/modules/fadmin/sv_fadmin.lua:37
      1. unknown - gamemodes/darkrp/gamemode/modules/fadmin/sv_fadmin.lua:47
      2. include - [C]:-1
      3. unknown - gamemodes/darkrp/gamemode/init.lua:93

[DarkRP] gamemodes/darkrp/gamemode/init.lua:112: attempt to index global 'MySQLite' (a nil value)

  1. unknown - gamemodes/darkrp/gamemode/init.lua:112

Couldn't Load Init Script: 'darkrp/gamemode/init.lua'

Kefta commented 4 years ago

Where did you place the dll and what did you title it?

Invilein commented 4 years ago

lua/bin

Kefta commented 4 years ago

What's the title of the dll?

Invilein commented 4 years ago

gmsv_mysqloo_linux.dll

Am Mo., 23. März 2020 um 03:45 Uhr schrieb Collin (code_gs) < notifications@github.com>:

What's the title of the dll?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/FredyH/MySQLOO/issues/49#issuecomment-602338229, or unsubscribe https://github.com/notifications/unsubscribe-auth/AM7P5BZEZ7TBOX73OGFE3ETRI3ENLANCNFSM4LRJ4AZA .

Kefta commented 4 years ago

Is the server running on the main or x64 branch? What OS is the server running on?

Invilein commented 4 years ago

Linux Ubuntu 16.04

Am Mo., 23. März 2020 um 14:33 Uhr schrieb Collin (code_gs) < notifications@github.com>:

Is the server running on the main or x64 branch? What OS is the server running on?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/FredyH/MySQLOO/issues/49#issuecomment-602590915, or unsubscribe https://github.com/notifications/unsubscribe-auth/AM7P5B4XB74XF2EJ6QBSZQ3RI5QI3ANCNFSM4LRJ4AZA .

Kefta commented 4 years ago

Is the server running on the main or x64 branch?

Invilein commented 4 years ago

Ubuntu 16.04 minimal

Kefta commented 4 years ago

That doesn't answer the question, but I'm assuming since you are unaware of what the x64 branch is, you're on the main branch. I'm unsure of what the problem is since the module is in the correct folder and named properly, but the error you posted is from failing to load the dll since the server doesn't see it.

I currently have an Ubuntu local server with mysqloo installed and it loads fine so it must be something on your end. Try running this in console and report back the result:

lua_run print(file.Exists("bin/gmsv_mysqloo_linux.dll", "LUA"))
FredyH commented 4 years ago

If you are still having the issuee, you might need vcredist 2008.