[blackfire499]

- 09 May 2016 03:31 #173345 Hi Community

i like to use the external database function and think my settings are right
"connectionString="jdbc:mysql://hostname:3306/pixelmon?user=pixelmon&password=dbpassword""

but after starting the server there are no tables and after conntecting something like

"ty.java:1374)
[10:29:37] [Server thread/INFO] [STDERR]: [com.pixelmonmod.pixelmon.storage.PokeballManager:savePlayer:255]: at net.minecraft.world.storage.SaveHandler.func_75753_a(SaveHandler.java:240)
[10:29:37] [Server thread/INFO] [STDERR]: [com.pixelmonmod.pixelmon.storage.PokeballManager:savePlayer:255]: at net.minecraft.server.management.ServerConfigurationManager.func_72391_b(ServerConfigurationManager.java:304)
[10:29:37] [Server thread/INFO] [STDERR]: [com.pixelmonmod.pixelmon.storage.PokeballManager:savePlayer:255]: at net.minecraft.server.management.ServerConfigurationManager.func_72389_g(ServerConfigurationManager.java:822)
[10:29:37] [Server thread/INFO] [STDERR]: [com.pixelmonmod.pixelmon.storage.PokeballManager:savePlayer:255]: at net.minecraft.server.MinecraftServer.func_71217_p(MinecraftServer.java:627)
"
is written in the console

do i need to add the tables or what is wrong ??

Edit: Or maybe someone can explain me how to install h2 on debian??

[Jay113355]

- 11 May 2016 12:19 #173468 I think you have to create the database in the mysql server. But pixelmon should create the tables it's self.

Also we package H2 in with pixelmon so you should be able to use it out of the box.

[blackfire499]

- 14 May 2016 16:16 #173621 The database exists only the tables won't be created.

H2 would be an option but we wanna try to combine the pixelmon server with the website.

I did a test if i can connect to my database with jdbc and its conntection so maybe my connection string is wrong or theres a bug in the plugin

Edit: or could it be because the mysql-connector.... is a newer version?? or because our Server is running on Linux?

[Jay113355]

- 14 May 2016 19:27 #173640 So you've created the database within the mysql server and the user has full permissions? or at least CREATE, ALTER, DROP, SELECT, INSERT, UPDATE, etc?

Could you get me the full error from the console? paste it somewhere like https://gist.github.com/ Or http://pastebin.com/

[Isi]

- 15 May 2016 01:08 #173654 Are you using Cpanel to create the DB? If you are and you have multiple IPs available (and your server/website are running on alternate IPs, you'll have to whitelist the server IP)

[blackfire499]

- 15 May 2016 12:04 #173675 Here the log
http://pastebin.com/fsag20ha
hope u see something because i don't see anything and yes Db user has all needed permissions

[MrMasochism]

- 15 May 2016 16:02 #173697 Can we have the full crash log, you've cut out the top few lines there?