Setting up a server

Help
2012-07-26
2013-06-06
  • Crzyone9584
    Crzyone9584
    2012-07-26

    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

    http://pastebin.com/anppGNXL

    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.

     
  • Crzyone9584
    Crzyone9584
    2012-07-27

    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?

     
  • Crzyone9584
    Crzyone9584
    2012-07-27

    Yes I know that mysql is running. My forums at
    theworld-r2.net

    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.

     
  • Katie Russell
    Katie Russell
    2012-07-27

    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
    jdbc_url=jdbc:mysql://your_host/your_db_name
    jdbc_class=com.mysql.jdbc.Driver
    jdbc_user=FOO
    jdbc_pwd=BAR

     
  • Crzyone9584
    Crzyone9584
    2012-07-27

    Okay so i deleted the server.ini and started over with a fresh one. this is whats in it for mysql now.

    jdbc_url=jdbc:mysql://http://xxx.xxx-r2.net/xxx
    jdbc_class=com.mysql.jdbc.Driver
    jdbc_user=username
    jdbc_pwd=specialword

    does everything in that look correct?

    as for the class path in the server.bat

    set LOCALCLASSPATH=.;data\script;data\conf;stendhal-server-%STENDHAL_VERSION%.jar;marauroa.jar;mysql-connector.jar;log4j.jar;commons-lang.jar;h2.jar

    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?

     
  • oslsachem
    oslsachem
    2012-07-28

    >> does everything in that look correct?

    Almost correct.

    You should use:

    jdbc_url=jdbc:mysql://xxx.xxx-r2.net/xxx

    instead of:

    jdbc_url=jdbc:mysql://http://xxx.xxx-r2.net/xxx

    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:

    http://stendhalgame.org/wiki/VisualGuideInstallingStendhal

    (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)

    Greetings,
         Osl

     
  • Crzyone9584
    Crzyone9584
    2012-07-29

    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?

     
  • oslsachem
    oslsachem
    2012-07-29

    >>  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.

    Greetings,
        Osl

     
  • oslsachem
    oslsachem
    2012-07-29

    >> 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/

    Greetings,
        Osl

     


Anonymous


Cancel   Add attachments