FiftyTifty
Members-
Posts
43 -
Joined
-
Last visited
Everything posted by FiftyTifty
-
We're so damn close to getting this working. I've loaded into the database with HeidiSQL with my remote root account, and changed auth\realmlist\address to have the value of my server's IP. Clicked "Save". Edited the Data\enUS\realmlist.wtf file in my client (on my desktop pc) to the server's IP (don't have a domain yet): set realmlist *.*.***.*** With the *'s obviously being the numbers of my server's IP. I can log into the account I created in the WorldServer terminal, and the realm list shows the Trinity realm. And when I click on Okay, a window pops up saying: logging into game server That lasts for a couple seconds, before it returns back to the realm list. Edit: Found the solution. You also have to edit the first row on the realmlist's data tab in HeidiSQL, not just the table itself.
-
A'ight, gave it a go, now MySQL is refusing my password for trinity. Which is utterly bizarre. Changed the password to the exact same thing I set it to, now I can get into trinity. And now it works. For some bizarre reason, the password changed even though I explicitly kept a text file of it. After changing it to the same password, it now works? This is just bananas. Thanks for the help so far lads, I really appreciate it. Expect questions about accessing MySQL databases once I get started on making tools.
-
Sorry that I keep coming back with these questions. Trying to get to the bottom of this once and for all. Alright, so: mysql> SELECT Host, User from mysql.user; +-----------+------------------+ | Host | User | +-----------+------------------+ | % | adminfiftytifty | | localhost | debian-sys-maint | | localhost | mysql.session | | localhost | mysql.sys | | localhost | root | | localhost | trinity | +-----------+------------------+ 6 rows in set (0.00 sec) mysql> SELECT Host, Db, User FROM mysql.db -> ; +-----------+--------------------+---------------+ | Host | Db | User | +-----------+--------------------+---------------+ | localhost | auth | trinity | | localhost | characters | trinity | | localhost | performance_schema | mysql.session | | localhost | sys | mysql.sys | | localhost | trinity_auth | trinity | | localhost | trinity_characters | trinity | | localhost | trinity_world | trinity | | localhost | world | trinity | +-----------+--------------------+---------------+ 8 rows in set (0.00 sec)
-
Alrighty, got back to where I was before. Now I've run the create_mysql.sql file, but running worldserver with the trinity user throws the following error: trinity@Ubuntu-1904-disco-64-minimal:~/server/bin$ sudo ./worldserver TrinityCore rev. d7375ad33f9d 2019-06-09 21:44:37 +0200 (3.3.5 branch) (Unix, RelWithDebInfo, Static) (worldserver-daemon) <Ctrl-C> to stop. ______ __ /\__ _\ __ __/\ \__ \/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __ \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \ \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \ \ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \ \/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \ C O R E /\___/ http://TrinityCore.org \/__/ Using configuration file /home/trinity/server/etc/worldserver.conf. Using SSL version: OpenSSL 1.1.1b 26 Feb 2019 (library: OpenSSL 1.1.1b 26 Feb 2019) Using Boost version: 1.67.0 Could not connect to MySQL database at 127.0.0.1: Access denied for user 'trinity'@'localhost' (using password: YES) DatabasePool Login NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Read wiki at http://www.trinitycore.info/display/tc/TrinityCore+Home I've even reissued the GRANT commands to ensure that trinity is given access to the databases, but nada. I'm thinking that it's a problem with worldserver trying to connect to 127.0.0.1, instead of localhost. How do I change that?
-
Shouldn't that not matter? I use the following command to access MySQL: mysql -u root -p When I pass the password for the Ubuntu root account, that I'm also logged into, it works just fine. But when I'm in the Ubuntu user "trinity", and do the same, it's denied. I'm also trying to access MySQL through HeidiSQL via the root account, not the trinity account. This is getting rather confusing. So to clarify, everything was done through the trinity user; getting the source code, compiling it, extracting the client files, generating the various client-server information things. It only started getting awry when the instructions for installing MySQL are merely: Installing MySQL Server When configuring MySQL make sure you remember the password you set for the default root account and that you enabled both MyISAM and InnoDB engines.
-
I have, I can log into the user on Ubuntu. Created the user as instructed here: https://trinitycore.atlassian.net/wiki/spaces/tc/pages/10977309/Linux+Core+Installation It's not a problem with the password. Got a text file with them, and when I input the root user's password on root, when logging into MySQL, it works just fine. But when I use the "trinity" user, and try to enter MySQL through the terminal with root and use the root password, the password is rejected.
-
There is no Ubuntu firewall at the moment. Currently using Hetzner's, and it's port functionality works just fine, and am currently allowing all connections from any port and IP. I can connect with other programs, namely NoMachine, FileZilla, and PuTTY, so that's not the issue. Currently talking with the developer of HeidiSQL, and he's been helpful: https://www.heidisql.com/forum.php?t=27266#p27270 So now I've allowed root to be accessed externally, but the connection to MySQL is refused with a slightly different error: Access denied for user 'root'@'host##-###-##-###.range86-164.btcentralplus.com' And I do have a GUI, installed LXDE from the terminal so I could use NoMachine. I'll take a look at MySQL Workbench. Also, as per the guide, I created a new user called "trinity", but installed MySQL with root. Is there a way to grant trinity full access to MySQL?
-
Right, bear with me now. Still a complete novice to anything Linux. According to the guide, I'm to run worldserver on my Ubuntu server to install the downloaded databases. When I try that, the trinity user that I was prompted to make in the tutorial does not have privileges to do so. I've got access to root, but the info on StackOverflow on doing this is either outdated or too terse. How exactly do I grant the user "trinity" access to all the TrinityCore databases through MySQL? Another part I'm stuck on, is allowing remote access to the MySQL databases with HeidiSQL. I've got it installed on Windows, changed the /etc/mysql/mysql.conf.d/mysql.cnf file to have bind-address = 0.0.0.0. And when I use HeidiSQL to connect, I get refused, even though I entered the password for the server machine's root account in, with an error popping up saying Host 'Not-Sharing-Because-Security-Reasons' is not allowed to connect to this MySQL server'. How do I go about solving this? Thanks in advance. Sorry if these questions are rudimentary, this is my first foray into working with both Linux, and servers.
-
Databses Installation - Guide is unclear
FiftyTifty replied to FiftyTifty's topic in Help and Support
Oh. I do apologize, I didn't see that, which makes me look like a dickhead. Thanks for the response. -
Databses Installation - Guide is unclear
FiftyTifty replied to FiftyTifty's topic in Help and Support
Ooh. And what do I do if I want to change the databases, or reimport the originals? -
I've been following the guide thus far, and the previous pages have been pretty good at telling the user exactly what to do. But now that I'm at the Databases Installation section, there are no longer any steps to follow, and just unspecific advice is given: https://trinitycore.atlassian.net/wiki/spaces/tc/pages/2130092/Databases+Installation I've downloaded the SQL database and put it next to worldserver, and I've downloaded the MySQL commands file. But what exactly do I do from then on? The guide just says to create the databases and populate them, without explaining how to do that.
-
At the end of the guide, where it says to install MySQL and check to see if MyISAM and InnoDB engines are enabled. But it doesn't tell you how to check that. Nor does it tell you that you have to make a new root account for MySQL. The way that's done: Open the terminal Type in: MySQL If it's the first time you're installing MySQL, you'll be given various prompts about default settings. The one we're interested in, is adding a password to the root MySQL account. Remember it, and you'll be given two prompts. One to input the password, and a second one to retype it. Once that's done, you'll have access to the MySQL terminal. In the new prompt, type: SHOW ENGINES; And that will show a list of the installed database engines. You may want to copy the text from the Linux terminal to a text editor, to have it formatted properly.