Wondertrade SQL Config Help | EnvyWare Ltd Development | Page 1

errant dune Nov 28, 2022, 3:36 PM

#

I have a new small server for friends that I'd like to use Wondertrade on. I am aware that you need SQL and that you need to configure it with the SQL specifications of the server- I have SQL (I host my server via g.portal), and I have tried to input the SQL specifications in the config file correctly. It hasn't worked, however, as far as I can tell. The /wt and /wondertrade commands pop up when you enter the "/", but it goes no further than that- there are no further inputs you can add, and as far as I can tell there isn't a wondertrade pool.

If someone is tech savvy, I'm fairly sure I've just input the SQL specifications into the config file wrong, and I think that could be fixed with just a few minutes of assistance. I can provide screenshots and such of specifics if needed.

bronze cape Nov 28, 2022, 7:06 PM

#

Let’s see your config

errant dune Nov 28, 2022, 7:43 PM

#

I've passed it along.

bronze cape Nov 28, 2022, 7:44 PM

#

?

errant dune Nov 28, 2022, 7:46 PM

#

I sent you a DM containing the screenshots, as I'm not sure if posting them is a security risk or anything.

bronze cape Nov 28, 2022, 7:46 PM

#

Just take out the username and password

errant dune Nov 28, 2022, 7:46 PM

#

Fair enough, one moment.

bronze cape Nov 28, 2022, 7:47 PM

#

Either way, you need to change the database name in your config

#

You have it set to WonderTrade but thats not the name of the database you are using

errant dune Nov 28, 2022, 7:49 PM

#

I had the database in the config file matching the SQL (as in, I copied the database of the SQL and pasted it into the Wondertrade config file). It didn't work then either.

bronze cape Nov 28, 2022, 7:50 PM

#

You still need to change the database name to match the database you are using, otherwise its trying to use credentials for a database that doesnt exist or doesnt have permissions for

errant dune Nov 28, 2022, 7:50 PM

#

Alright, so I should copy the SQL database name and paste it into the config file?

bronze cape Nov 28, 2022, 7:50 PM

#

database: db_1580256_1

errant dune Nov 28, 2022, 7:51 PM

#

Aye, alright, done so. Is there anything else you can glean that's wrong?

bronze cape Nov 28, 2022, 7:51 PM

#

Not with your config

#

Just boot it up and see what happens

errant dune Nov 28, 2022, 7:52 PM

#

Alrighty. Wish me luck.

#

Still doesn't do anything. The commands show up, ostensibly cannot be used.

bronze cape Nov 28, 2022, 8:03 PM

#

Do you have permissions
Send any errors

errant dune Nov 28, 2022, 8:05 PM

#

I'm OP'd, yeah.
Entering those commands doesn't even register in the console, at least. The only reference I found in the console was included in the original message.

#

I'm sorry that this seems to be a more troublesome issue than I thought originally.

coarse inlet Nov 29, 2022, 8:55 AM

#

are you using luckperms or any perms plugin?

#

if so give yourself minecraft.command.wondertrade perms

errant dune Nov 29, 2022, 2:57 PM

#

No plugins, no sidemods, nothing like that.

#

Well. Besides, theoretically, Wondertrade, harhar.

coarse inlet Nov 29, 2022, 2:59 PM

#

delete yo config

#

and then let it regen

#

it worked for me

#

just config.yml

#

nothing else

sand bison Nov 29, 2022, 3:00 PM

#

Well that's because you're using the JSON saving

#

if they want help for why their SQL isn't connecting then that's not particularly helpful

sand bison Nov 29, 2022, 3:01 PM

#

errant dune Well. Besides, theoretically, Wondertrade, harhar.

Can you send your latest.log

errant dune Nov 29, 2022, 3:06 PM

#

📎 latest.log

sand bison Nov 29, 2022, 3:07 PM

#

[29Nov2022 04:10:48.283] [envyware_concurrency_0/INFO] [STDERR/]: [java.lang.ThreadGroup:uncaughtException:1052]: java.lang.RuntimeException: Failed to get driver instance for jdbcUrl=jdbc:mysql://45.35.207.96:3306/db_1580256_1

#

Are you running Arclight

#

Or just pure forge

errant dune Nov 29, 2022, 3:07 PM

#

Forge.

sand bison Nov 29, 2022, 3:07 PM

#

https://www.curseforge.com/minecraft/mc-mods/mysql-jdbc/files Use this mod

#

IH NO

#

DON@T USE THAT

#

No 1.16.5 version

errant dune Nov 29, 2022, 3:08 PM

#

(Probably. This is set up via a host, I don't actually know what Arclight is, but I've seen a Forge server file being used)

#

Okay, I won't use it, what should I use

sand bison Nov 29, 2022, 3:08 PM

#

Just trying to find it now

errant dune Nov 29, 2022, 3:08 PM

#

Gotcha, I can be patient, thanks much

sand bison Nov 29, 2022, 3:08 PM

#

https://www.curseforge.com/minecraft/mc-mods/mysql-jdbc/files/3583804

#

That should work

errant dune Nov 29, 2022, 3:09 PM

#

Do I just slap this into the mods folder for the server?

sand bison Nov 29, 2022, 3:10 PM

#

Yea

errant dune Nov 29, 2022, 3:10 PM

#

Alrighty, will let you know the end result.

sand bison Nov 29, 2022, 3:10 PM

#

Coolio

errant dune Nov 29, 2022, 3:15 PM

#

Alright, it's now a different problem.

#

Which is progress.

sand bison Nov 29, 2022, 3:16 PM

#

Send your new log now pls

errant dune Nov 29, 2022, 3:17 PM

#

📎 latest.log

sand bison Nov 29, 2022, 3:27 PM

#

errant dune

You're on a really really outdated version
downloads: https://github.com/EnvyWare/WonderTrade-Forge/releases/

errant dune Nov 29, 2022, 3:29 PM

#

It is for 1.16.5, but if this works I will simultaneously feel very silly and feel extremely thankful that the wait to use Wondertrade is over. One moment.

sand bison Nov 29, 2022, 3:29 PM

#

Yeah the version you're using won't work with anything past like 9.0.4 or something like that

errant dune Nov 29, 2022, 3:38 PM

#

The battle is not over. "/wt 6" works, but it cannot be confirmed. Other wondertrade commands appear to function, as I tested the regenpool thing.

sand bison Nov 29, 2022, 3:51 PM

#

uh

#

What do you mean it cannot be confirmed

coarse inlet Nov 29, 2022, 3:53 PM

#

sand bison What do you mean it cannot be confirmed

if he types the command again it says "(!) Incorrect slot number! /wt (slot)"

sand bison Nov 29, 2022, 3:55 PM

#

@coarse inlet I wasn't talking to you so there's no need for you to reply

#

errant dune Nov 29, 2022, 3:59 PM

#

sand bison What do you mean it cannot be confirmed

As it says there, it asks me to type the command again to confirm. So I type it again, nothing happens. No error or anything, just... nothing.

sand bison Nov 29, 2022, 3:59 PM

#

Can you send me your log

#

and what did you type exactly, the second time?

errant dune Nov 29, 2022, 4:03 PM

#

I tried both /wt 6 and /wt 6 confirm (the latter giving me "incorrect slot number")

sand bison Nov 29, 2022, 4:03 PM

#

Just do

#

/wt 6

#

/wt 6

errant dune Nov 29, 2022, 4:03 PM

#

I did, yeah

#

📎 latest.log

sand bison Nov 29, 2022, 4:06 PM

#

That doesn't show any commands being run

#

Can you send your client logs

errant dune Nov 29, 2022, 4:08 PM

#

📎 latest.log

sand bison Nov 29, 2022, 5:33 PM

#

Also not telling me the commands you ran

#

Make a gif of you doing it

errant dune Nov 29, 2022, 5:35 PM

#

I don't know how, but I am telling you I ran the same command twice.

#

./wt 6

#Wondertrade SQL Config Help