Error with votingplugin some communication or driver error
Yo so recently i tried swapping to the votingplugin proxy wide, but using REDIS it doesnt work nor PLUGINMESSAGING even if i followed all steps, it gives me some communication error after followign every step and also some hikari pool thing
232 Replies
check that your mysql credentials are correct
how do i do that?
go to your config.yml
ok
see what your DataStorage is set to
lemme see
"# What type of bungee setup
Requires restart and set on all servers
Available:
SOCKETS
PLUGINMESSAGING (Recommended)
MYSQL
REDIS
BungeeMethod: REDIS"
btw the " i put them
wrong file m8
Config.yml
not BungeeSettings.ymlin the proxy?
or backend serv
whatever server this error came from
ok
oh shi its on sqlite
but i also got some errors on the proxy
its this
on proxy
weird
i dont know either
if it's set to SQLite, why is it mentioning mysql :/
at com.mysql.cj.jdbc.exceptionsit was set to sqlite
on the backend serv
this last log is from proxy
which is set on "redis"
and i havent found any settings about sqlite there
yeah because the userstorage system is only for backend
if you have multiple backends you'll want to use mysql
well
wait
so do i need
mysql drivers
do you have a
Config.yml file on both the proxy and backendon my backend?
no i only have on backend
do you have multiple backends
yea
3
https://www.spigotmc.org/resources/jsmysqlfix-velocity.120092/ this is the driver i got
but only on proxy
no need for that
ok
so you'll want to make a mysql database, set the DataStorage to MYSQL in all of your backend config.ymls and configure the credentials
wait so in the proxy config
in the DATABASE: " "
do i leave empty?
i put something in there
wait
what's the name of the proxy config file
Host: '127.0.0.1'
# Default port is 3306
Port: 3306
Database: 'Hikaru'
Username: 'Administrator'
Password: ''
the proxy thing
no the
actual name
of the file
is Bungeeconfig .yml
e.g.
myfilename.yml
ah
so yes, you need to make a MySQL database and link all the backends and proxy to the same onehow do i do that?
well
never played around with databases
do you use a web panel
to manage the mc server
no
selfhost
this is pure ssh?
or something
what does ssh stand for?
wait
what OS are you doing this on
windows
oh god
what
why are you running a mc server on windows ðŸ˜
why self host?
idk
selhost bcs freedom
💀
and also
!selfhost
Home hosting has its drawbacks / caveats
- Is your internet connection fast enough? In both directions (around 50M is usually enough; you should check here)? You don't connect the server to your router via WiFi, do you?
- Does your ISP provide a somewhat static, public, IPv4 address?
- Are you aware and able to deal with the security impliations?
- Is your computer powerful enough to run both a client and a server?
- Does any inhabitant (human or not!) mind the noise, heat and energy cost of a machine running 24/7?
- Alternatively, is your playerbase OK with the server not being there when you aren't?
Admincraft Canned Responses
internet is about 1GBPS upl and down;
the computer has got a threadripper 2950x
64 gigs ram
i do not mind noise
oh jesus
that's awful
its like 20m away
why?
awful CPU for minecraft
terrible singlethread
yeah but on another server i got i got intel
xeon e5-2420
v2
oh yeah that's even worse
why
1,388MOps/Sec singlethread
oh
yeah but the servs run fine
why not use shared hosting?
better CPU, better operating system (windows is complete bloat), no hassle with making databases
you still get full file access
yeah but like i have these pcs
why not use them
i dont have electricity bills
since i use solar panels
to power
if you're okay with worse performance then
sure
soo how do i make a sql database?
and how do i link them servers and proxy?
https://dev.mysql.com/downloads/installer/
you want to install mysql
ok
make sure it's not the 2mb installer
aight
lmk once you have downloaded it and opened it
ok
i ran it
wait for the "choosing a setup type" window
says please wait till windows configures
give it a sec
aight
im in a windopw
with server stuff
client only
make sure it is "Server only" selected
ok
then do next
and execute
aioght
its installing itself
once done
in the type and networking, you can keep the TCP/IP the same, keep doing next until you get to the accounts and roles
select a good memorable root pass
aight im in type and networking
just hit next
ok
do i need to change "development computer"?
nope
when you get to Accounts and Roles
select a good root acc password
do i use strong password?
yes
or legacy
strong
my password says weak 😦
specify a good root password
make it stronger then
lol
now its strong
also
do Add User
its something with user acc
now
uhh
what do i fill in username?
anything memorable (write it down)
then specify a password and also write that down
aight
"windows service"
then next once done
yep
fine
what name do i give it
what's the default
MYSQL80
keep it like that
"yes grant perms"
"yes but let me review"
no i will manage perms
default one
ok
im in apply config
execute
or whatever
ok
aight
its done
now how do i link my serv?
open the MySQL 8.0 command line client
and enter the root password you specified
aight
lmk once you're in
welcome to mysql monitor
it says
cool
now
ok
you want to create a database
CREATE DATABASE voting; (change then name as you please)
if you do it right, it should say QUERY OK, 1 row affected (0.xx sec)uhh
pressed enter
but just goes one line down
with the ->
did you type
; at the endoh
lol
you have an error in
sql syntax
for the right syntax use /g
/h
just press CTRL + C and then do the command correctly
always have
; on the end of the commandsoki
works
sweet
created database
what did you call it
Hikaru
so if you do
SHOW DATABASES; it should show Hikaru at the bottom?ok lemme see
or somewhere in the table
hikaru #1
in the list
right so
can you show what
SELECT user,host FROM mysql.user; outputsadmin\
mysql. something
on 3 rows
and root
screenshot please
uhh
1s
well
alright
doesnt work
on the pc
just
what did you call your user
that you created
when installing
administrator
had no good names
so it says
administrator and then % next to itand it says at top Administrator host x
in the table?
yea
not x
okay
XD
GRANT ALL PRIVILEGES ON Hikaru.* TO 'Administrator'@'%' WITH GRANT OPTION;do i paste this?
yeah
You are not allowed to create a user on grant
with grant*
oh
wait
try now
(edited)
ok
query oki
neat
now just
exitok
question
what do i fill in
shoot
in the redis thing
what
hold
why use redis
why not PLUGINMESSAGING
plugin message didnt work
since same error
XD
was it the mysql error
yea
yeah not related
....
you can go back to PLUGINMESSAGING
no need to set up redis which is another software lol
welp gotta set it back up
pluginmessaging is built in proxy
well
no need
why?
just set the BungeeMethod to PLUGINMESSAGING
and that's it
no need for redis
ok
but
let me know once you've edited that
in the hostname
(i think it's all backends and proxy?)
do i need to put %
yea
probs
hostname?
yeah
where's this
my bad
not hostmane
name
host
oh
no, just
localhostHost: '%' i put this
oh ok
GlobalData:
Enabled: true
or fa;se
GlobalData:
Enabled: true
# Use existing connection above
UseMainMySQL: false
# Mysql settings only used if above is false
to be precise
uh
default is true on mainmysql
it's up to you
ig ill enablre
whats the worst
yeah
that could happenm
:prayge:
also, % means a user can be logged into on all network IPs
which is actually bad practice but if you don't port forward port 3306 you will be fine
aight switching all servs to plugin messaging
neat
oh
i wont port forward 3306
too lazy
good idea lol
there's no need to
if all servers are running locally
then you don't need to forward it
oh
: (
public key retrieval is not allowed
on proxy
where's this?
send the entire log
mclo.gs - Paste, share & analyse your Minecraft logs
Easily paste your Minecraft logs to share and analyse them.
right
go to bungeeconfig.yml
oki
you see
#PublicKeyRetrieval: false and how it is commented out?
uncomment it and set it to trueoh
ok
do i have to do on all servs?
in the backend?
yes
ok
lemme do it
Done
mfw this could all be so much less effort if you used a shared host ðŸ˜
okay
do i restart?
yep
cool if less effort
i like learning some new stuff
fair
may come in handy in a lifetime
aight im restarting
NO WAY
IT HAS NO ERROR ON PROXY
it booted?
yea
:LETSGO:
lemme check backend
backend time!
:)
oh
i got an error
about some month
send it
ok 1s
no rush
[18:18:59] [VotingPlugin - Task Executor #1/ERROR] [com.velocitypowered.proxy.console.VelocityConsole]: java.nio.file.AccessDeniedException: hrmmmmidk man
stop all the servers
ok
all and proxy?
yes
then hop into task manager and see if there's any java instances running still
ok
"java update scheduler"
kill it tbh
"java update checker
uh
kill
done
start server?
started proxy no problems!
0 error
NICE!
now try backends
backends got erro
2 of them
waiting for last
send em over
are they the same error
all 3 error
lemme chcekl
the lobby got those hikari errors
proxy had
same lifesteal
did you configure the database in the backends too
uhhh
:P
0 idea
check in Config.yml
oh
in config??
shi mb
aight restarting them after changes
fingers crossed
litterally SMOOOTH OPERATOR
tysm man
no problem lol