Nexus Framework - MySQL Help

Well, I have a slight problem, I’m not going to drown you with all the details but, I’m on vacation in Florida, and I want to work on some things for Nexus while theres nothing to do, but I forgot how to set up a MySQL. I remember alot of it, but I have one small part I cant remember how to do.

// This is the MySQL configuration file for the nexus framework.
// Simply edit the values below and stick to the format of the example.
[MySQL]
force mysql_characters_table = characters;
force mysql_players_table = players;
force mysql_username = Herp;
force mysql_password = Derp;
force mysql_database = severence;
force mysql_host = www.freesql.org; <— Thats the problem

I cant remember what to fill out for the mysql_host, if anyone can help me, that would be nice, I remember it being something like: www.freesql.org/3306/mysql Or something like that.

(( This was not the pirated version, the version of Nexus and Schema I have for it is the version KURO released, not the leaked ones. ))

[editline]09:39PM[/editline]

The MySQL port host if 3306, if that helps.

The site says the host is “www.freesql.org”. Make sure it is in quotes like so.

[lua]
force mysql_host = “www.freesql.org”;
[/lua]

Ah, I needed them in quotes?

[editline]09:43PM[/editline]

// This is the MySQL configuration file for the nexus framework.
// Simply edit the values below and stick to the format of the example.
[MySQL]
force mysql_characters_table = characters;
force mysql_players_table = players;
force mysql_username = “herp”;
force mysql_password = “derp”;
force mysql_database = “severence”;
force mysql_host = “www.freesql.org”;

Would this work?

Yes but please hide your login details ASAP!

Edit: You also need the top two in quotes, I believe.

Its just my test one, theres no info on it and I’m removing it soon. :U

[editline]09:54PM[/editline]

Testing to see if it worked.

[editline]10:20PM[/editline]

No luck. :Dawkins102:

Please list any errors that show in srcds.

Well, I’m not really getting any errors, Its just saying in red text, on the grey screen “There server is unable to connect to MySQL. The server host should edit /directory/garrysmod/garrysmod/data/nexus/mysql.cfg.”

Add me on steam please.

My Steam went down…

Considering this is about Nexus, I’ve also got a question.

A certain bug has come up with Nexus that causes a grey screen to appear after it finishes streaming data to the player. All I have to assume is that some function either isn’t being executed, or is being stopped somewhere in the code.

I do have libmysql, as well as tmysql in their correct places (libmysql.dll in orangebox, and tmysql.dll in lua/includes/modules), and I’m starting to run out of options here.

Is there anyone that can help, or has been able to fix this problem in the past? It’s a solid grey screen that comes up, no red text or anything.

My guess is that you have not maken the database correctly

The database was created by Xenonservers, so yes it’s made correctly.

Any other ideas? We recently reset the tables to no avail.

That update that Garry made recently broke server hosting for dedicated servers. I’m not sure what to tell you for that, than wait for garry to fix it.

I’ve got the same bug - I setup the DB correctly, but Nexus streams data then goes completely grey. On the one occasion it did work, I couldn’t create my character, the continue button was dead.

1st.
This isnt supposed to be in server advertisement.

2nd.
If you are having problems with databases then it is NOT nexus’ fault. It is simply you setting it up wrong.

To fix open this file garrysmod\gamemodes
exus\gamemode\core\config\sv_config.lua

Edit these lines with your MySQL information. ( First Six Lines of this file )

[lua]
nexus.config.Add(“mysql_characters_table”, “characters”, nil, nil, true, true, true);
nexus.config.Add(“mysql_players_table”, “players”, nil, nil, true, true, true);
nexus.config.Add(“mysql_username”, “USERNAME”, nil, nil, true, true, true);
nexus.config.Add(“mysql_password”, “PASSWORD”, nil, nil, true, true, true);
nexus.config.Add(“mysql_database”, “DATABASE”, nil, nil, true, true, true);
nexus.config.Add(“mysql_host”, “HOST”, nil, nil, true, true, true);
[/lua]

I’m not advertising my server, where did I ever put a link to my community name or IP?

And we also got it to work, thanks shane. :smiley:

Can you explain what you did?

Also, he meant the location of your topic: “Garry’s Mod > Server Advertisement > Server Hosting > <Your Topic>”