d2jsp
Log InRegister
d2jsp Forums > Off-Topic > Computers & IT > Programming & Development > I Need Sql Help, Minecraft Related > Never Heard Of Sql Before.
Add Reply New Topic New Poll
Member
Posts: 9,069
Joined: Jun 6 2009
Gold: 0.00
Aug 13 2013 11:45am
http://dev.bukkit.org/bukkit-plugins/ban-management/
http://cpanel.fragparty.pl

Ok so what I am doing here today, is trying to get my website to show all the players who i have banned on my minecraft server.

The problem I am having today is that I know nothing of SQL

the config wants
SQL host/user/password/database

The web host provides all 4 things.
I enter that into my config, and it says that

2013-08-13 12:42:11 [INFO] [BanManager] Enabling BanManager v3.11
2013-08-13 12:42:30 [SEVERE] [BanManager] jdbc:mysql://mysql.fragparty.pl:3306/u215987335_bans?autoReconnect=true&failOverReadOnly=false&maxReconnects=10
2013-08-13 12:42:30 [SEVERE] [BanManager] Could not be resolved because of an SQL Exception: Could not create connection to database server. Attempted reconnect 10 times. Giving up..
2013-08-13 12:42:30 [SEVERE] [BanManager] Unable to connect to the database, it has been disabled
2013-08-13 12:42:30 [INFO] [BanManager] Disabling BanManager v3.11
2013-08-13 12:42:48 [SEVERE] [BanManager] jdbc:mysql://mysql.fragparty.pl:3306/u215987335_bans?autoReconnect=true&failOverReadOnly=false&maxReconnects=10
2013-08-13 12:42:48 [SEVERE] [BanManager] Could not be resolved because of an SQL Exception: Could not create connection to database server. Attempted reconnect 10 times. Giving up..
2013-08-13 12:42:48 [INFO] [BanManager] [BanManager] has been disabled


So... would anyone have any idea on what I could be missing?

Config info here ....

localDatabase:
host: mysql.fragparty.pl
port: 3306
database: u215987335_bans
username: u215987335_conet
password: mypassword
Member
Posts: 22,108
Joined: Jul 31 2006
Gold: 820.00
Aug 13 2013 12:05pm
try changing host to localhost
Member
Posts: 9,069
Joined: Jun 6 2009
Gold: 0.00
Aug 13 2013 12:09pm
Quote (sor_d2 @ 13 Aug 2013 12:05)
try changing host to localhost


Well... that was the default, and didn't work.

Someone suggested on skype for me to get MySQL server/program.
so im trying that out now.
Member
Posts: 1,358
Joined: Dec 30 2012
Gold: 0.10
Aug 13 2013 12:21pm
Who's your webhost?
Member
Posts: 9,069
Joined: Jun 6 2009
Gold: 0.00
Aug 13 2013 12:24pm
Quote (SelfTaught @ 13 Aug 2013 12:21)
Who's your webhost?


Post 1, its free.


Also this SQL server thing app/program did not solve anything.
Member
Posts: 1,358
Joined: Dec 30 2012
Gold: 0.10
Aug 13 2013 12:28pm
Quote (conetopia @ Aug 13 2013 10:24am)
Post 1, its free.


Also this SQL server thing app/program did not solve anything.


Have you added the user to your database?

Try watching this video: http://www.youtube.com/watch?v=CEeN5yYgZH4

This post was edited by SelfTaught on Aug 13 2013 12:34pm
Member
Posts: 9,069
Joined: Jun 6 2009
Gold: 0.00
Aug 13 2013 12:44pm
Quote (SelfTaught @ 13 Aug 2013 12:28)
Have you added the user to your database?

Try watching this video: http://www.youtube.com/watch?v=CEeN5yYgZH4


Yea when i went to my webhost/website to view my database, it was something else / blank....
so I am thinking I have all the .php files that came with the plugin, in the wrong directory.


Edit: yea I think its just the web host, Because i went and did database importing like 4 times, and i don't see any of the files stored anywhere.
It just doesn't like my package :(

Thanks for helping anyways ;)

This post was edited by conetopia on Aug 13 2013 01:11pm
Member
Posts: 1,358
Joined: Dec 30 2012
Gold: 0.10
Aug 13 2013 08:00pm
Quote (conetopia @ Aug 13 2013 10:44am)
Yea when i went to my webhost/website to view my database, it was something else / blank....
so I am thinking I have all the .php files that came with the plugin, in the wrong directory.


Edit: yea I think its just the web host, Because i went and did database importing like 4 times, and i don't see any of the files stored anywhere.
It just doesn't like my package :(

Thanks for helping anyways ;)


Ah. Did you create a database before you imported the one you have? I think you might have to do that, because it'll just import the tables from the one you have.

Also, are you importing with phpMyAdmin in the cPanel?

This post was edited by SelfTaught on Aug 13 2013 08:01pm
Go Back To Programming & Development Topic List
Add Reply New Topic New Poll