adeynes / cucumber

Moderation plugin for PocketMine-MP
GNU General Public License v2.0
29 stars 11 forks source link

connection issue #15

Closed mastergaminglord closed 4 years ago

mastergaminglord commented 4 years ago

when i try to start my server with cucumber installed it get this error

2020-06-18 [16:49:28] [Server thread/CRITICAL]: adeynes\cucumber\libs\poggit\libasynql\SqlError: "SQL CONNECT error: Connection refused" (EXCEPTION) in "plugins/cucumber.phar/src/adeynes/cucumber/libs/poggit/libasynql/libasynql" at line 133

is this fixable

adeynes commented 4 years ago

This is a problem on your end. You haven't set up the connection correctly (probably incorrect username/password in config.yml).

mastergaminglord commented 4 years ago

also extra info I have tried this plugin on its own with no other plugin and it the same problem occured

mastergaminglord commented 4 years ago

in the config.yml folder what do I type in the password thing

adeynes commented 4 years ago

in the config.yml folder what do I type in the password thing

You type the password for the MySQL user. You'll also need a database for cucumber and the user needs access to that database.

mastergaminglord commented 4 years ago

the plugin assumes you automatically have MySQL but idk if i do or not

mastergaminglord commented 4 years ago

which is why i am confused

adeynes commented 4 years ago

Yes, the plugin requires MySQL. I haven't developed it with other systems in mind, although SQLite might come in the future.

mastergaminglord commented 4 years ago

um where do you download MySQL

adeynes commented 4 years ago

Windows or Linux?

mastergaminglord commented 4 years ago

no i mean the website

and also are u able to ban someone for permanent off the server or is it only temp ban

adeynes commented 4 years ago

no i mean the website

I mean, are you on Linux or on Windows?

and also are u able to ban someone for permanent off the server or is it only temp ban

Both

mastergaminglord commented 4 years ago

im on windows yes if its perm ban is it -1 in the duratation

adeynes commented 4 years ago

https://dev.mysql.com/downloads/installer/ You might also want to download phpmyadmin to manager your database here: https://www.phpmyadmin.net/downloads/

For perm ban you don't put a duration at all, ex. /ban mastergaminglord (if I wanted to ban you for 1 month 15 days I'd do /ban mastergaminglord -d 1M15d)

mastergaminglord commented 4 years ago

this is taking a while are u trying to find the download links

mastergaminglord commented 4 years ago

ohh i see it now

mastergaminglord commented 4 years ago

thx for your help i will get back to you if i need help with the database btw im using aternos

also the reason why i installed this plugin in the first place was because the kicked and banned by admin messages are really annoying thx for your help

adeynes commented 4 years ago

You're welcome, I hope you can figure out. Don't be afraid to google stuff if you can't figure something out, it's not necessarily intuitive at first. What you need to do is create a database with phpmyadmin and a user that goes with it, and put all that in config.yml

I hope you enjoy the plugin

adeynes commented 4 years ago

Wait, if you're using Aternos installing MySQL on your computer won't do anything. Does Aternos not have MySQL databases?

adeynes commented 4 years ago

Seems like Aternos doesn't offer MySQL databases. In that case you might want to use this https://www.freesqldatabase.com/ and put the IP of the database along with username, password, etc in config.yml

mastergaminglord commented 4 years ago

thx for that but there is a problem

it says I need a oracle account and I press sign up and it says I need a work phone and things so idk

adeynes commented 4 years ago

I'm sorry but I can't help you with this, I haven't used MySQL on Windows and Github isn't tech support. You'll have to ask somewhere that actually does support for this kind of stuff

mastergaminglord commented 4 years ago

its fine

mastergaminglord commented 4 years ago

im actually really upset now every time i try to click the link it sends me to a blank page with error and i think its blocked my ip address permanently

mastergaminglord commented 4 years ago

adeynes i have a question

am I able to unban myself I did /ban through the console