I'm building a small mmo. I have started working on one but I've been asked by my community to make it more cross platform. So here i am.
I'm using stendhal server 1.01 with the mysql set up. It crasshes and gives this error
It has something to do with not being able to load a mysql plugin. I've gone through the wiki and have been unable to find a solution. Any help would be greatful.
You seem to have CSS turned off.
Please don't fill out this field.
You can find helpful documentation about setting up a server in our wiki:
The error you get, looks like you did not download and add the jar file containing the mysql connector/jdbc driver to the server's classpath. You can obtain one from https://dev.mysql.com/downloads/connector/j/.
In the future you might want to do some changes to stendhal. In that case we have some helpful pages in the wiki:
In case this hints do not help you, it would help us, if you add more information on what you did to setup your stendhal server.
I orginally was at the first link you gave. Couldn't find anything about setting up a mysql database and I still don't. Any information on how to set up the database and add in the class parth for the connector would be great.
I have a few other questions to. Would you mind me asking them here or not?
I added in the mysql connector.jar and now im getting the following error in the logs. Please note i removed mysql url host link and replaced it with xxx
Hi there, the mysql database setup instructions are at https://stendhalgame.org/wiki/StendhalLocalhostServerOnLinux for Linux for example. Did you create the database and check mysql is running?
It's fine to ask for help here :)
Yes I know that mysql is running. My forums at
are running just fine.
I also use the same host name for an application in C# and it connects just fine also. Is there something else I'm missing. It seems that it just doesn't find the url to my mysql host suitable.
I think this line is the most important from your pastebin:
Caused by: java.sql.SQLException: No suitable driver found for xxx.theworld-r2.net
(You forgot to xxx out all your host links apparently, but I did it for you ;))
Is mysql-connector.jar on the classpath? Are the relative paths correct? Check against https://stendhalgame.org/wiki/StendhalLocalhostServerOnLinux#Class_not_found_exceptions and your own file locations
Your server.ini file which you generated has the connection instructions. Check the 4 lines for jdbc under
"# Database information. Edit to match your configuration."
should be something like
Yes, it seems the jdbc_url should be:
instead of just:
See also JDBC URL format at:
Okay so i deleted the server.ini and started over with a fresh one. this is whats in it for mysql now.
does everything in that look correct?
as for the class path in the server.bat
I renamed the mysql-connector-jave-5.1.21-bin.jar to mysql-connector.jar and placed it in the server root folder for thats the path that its looking for the mysql-connector.jar file correct?
>> does everything in that look correct?
You should use:
That is: you should remove the http://
>> I renamed the mysql-connector-jave-5.1.21-bin.jar to mysql-connector.jar and placed it in the server root folder for thats the path that its looking for the mysql-connector.jar file correct?
Yes, it seems correct. You can follow this guide too:
(I assume by the format of your classpath separator ";" that you are using windows)
(This guide uses MariaDB instead of MySQL but both databases are equivalent, in fact they have the same author)
Man do i feel stupid… ASfter re-doing the server set up a billion times, I game to realize that i was putting the host as the database name and the database name as the host…. Man do i fail…
Anyway server is running great now and not crashing.
Next question is if i edit the source am i required to release it to the public? I would like to keep my edits for myself just for a while.
Also is it possible to edit the stats to meet my needs? If so where would i start? Also I have been working with c# and xna and have a ring menu working. Would there be someone here to help me convert the code to this engine?
>> if i edit the source am i required to release it to the public?
The client and server code are licensed under the GPL license.
This means that if you distribute the code to users, you have to release the source code to them as well.
Presumably, you are only going to distribute the client code to users and then they are going to interact with your server.
This means you have to release the source code in the client, which includes the graphics, music and sounds.
On the other hand, the quests, the maps and the creatures or items stats, for example, are kept in the server and so you don't need to release the source code for them.
>> Also is it possible to edit the stats to meet my needs? If so where would i start? Also I have been working with c# and xna and have a ring menu working. Would there be someone here to help me convert the code to this engine?
I leave this question to the stendhal developers.
>> I'm building a small mmo. I have started working on one but I've been asked by my community to make it more cross platform.
>> I have been working with c# and xna
Have you already tried MonoGame? https://monogame.codeplex.com/