-
Notifications
You must be signed in to change notification settings - Fork 5
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Plugin apparently not connecting to MySQL #1
Comments
It's can't send only PEconomy must send error message and stack trace if connection to database has been failed. |
I may not have looked at the log correctly. Here is what I have found on logs file after running it again with
I'm not used to MySQL but the IP that shows on log, Also, I checked again the Host IP, name, user name and password. They match with the ones that I use on others plugins. |
Oh.. May be you try to use fake IP? The error message will be similar or not? |
Not similar. Changed IP to a fake IP and got this:
|
Try to set |
Probably, this problem is on your side, sorry. I'm looked at my database connector code, but I didn't find anything. |
To sum up, you have an invalid database connection URI. Try to connect It manually using your terminal |
So, after setting
The strangest (oddest?) part to me is that nLogin and CoreProtect are connected and working with MySQL.
I'll try to figure out how to do this, as I have no clues. As soon I get it done, or not, I'll be back here. |
I Would like to address one more thing. I finished installing another plugin that uses MySQL (Statz). And it's working properly as far as I can see. So, maybe it's a problem with permissions from my side, because I don't have full permissions in MySQL. But, probably, there's a workaround. Besides that, I experienced other Servers Host Providers that are almost the same, not allowing full control over the Databases. |
You connected to 170.81.41. |
I've just tried to install the plugin with MySQL (MariaDB locally) by myself and it works perfectly, so I suppose these are troubles on your side. Recheck your MySQL credentials and user permissions. I have a local MariaDB service with user 'test'@'localhost' with no password and full access to the 'test' database, so my configuration section looks like this:
|
Actually, I've set the PEconomy config file since from the begging to connect to
So I went all the way from the beginning, fresh started the server. The plugin seems to work fine until switched to MySQL.
I also started a ticket with my server provider, they're completely useless. Good to know that though. I'm making all the configs from the server and problably will change my provider as for production. Just to add, I've tried to connect direclty througth MySQL WorkBench 8.0 and was unable also. The only way was using MySQL Query Browser due to a bad handshake error. Solution for direct connect.. I'll stick to using SQLite by now, until trying again in another host. |
By the way, is your database named 'rh5623' in MySQL? Just I've noticed that the At this point, you can contact me on SpigotMC (I have the same nickname on there) and I'll create a database for you on my German host (at least for this month) (totally free :D) |
This Host "REISHOST" is a popular provider here in Brazil. They use the same "key" of the user account for almost anything they need. So my account is rh5623. The database name is the same, the user name is the same. Kinda weird. I have only privileges creating tables inside this database. It's messy all the tables mixed.
OMG! This is really kind! Thank you! I'll be in touch if needed. Thanks again! |
Okay. I think that I should to close this issue. |
So, I have tried to connect to MySQL and runeed into some problem.
The plugin start initialization and never get done.
This is the config file.
Host IP and password omitted.
In the Console (Multicraft) this is the only message:
04.05 07:35:17 [Server] INFO [PEconomy] Loading PEconomy v2.0.2
And then, when trying to run /peco help, I get this:
When I switch back to
use-sqlite: true
it runs properly.By reference, I have two other plugins connected to MySQL (CoreProtect and nLogin).
(My English is a work in progress, also, first time reporting something in GitHub. Sorry for any mistakes).
The text was updated successfully, but these errors were encountered: