Menu

Marauroa can't connect to mysql

Help
2009-05-28
2013-06-06
  • Antonio Winkler

    Antonio Winkler - 2009-05-28

    Hi all,
    I wanted to host a Stendhal-server (version 0.74). When I try to start with

    ./marauroad stendhal-0.74.jar server.ini

    I get this error:

    ERROR: Marauroa can't connect to database
    Verify "server.ini" file to make sure access to database is possible.

    My server.ini:
    http://pastebin.com/d6323804d

    and here the complete output from the marauroad-command:
    http://pastebin.com/m2b24e44a

    Sorry for my poor english ;)

    I will be grateful for any tip.

     
    • Anonymous

      Anonymous - 2009-05-28

      You might have your mysql in a different port than the default. Try using:
      jdbc_url=jdbc:mysql://localhost:<mysql port>/marauroa

      replace <mysql port> with your port. (default is 3306)

      You should not port the n and d entries for security purposes.

       
    • Antonio Winkler

      Antonio Winkler - 2009-05-29

      I know what you mean and I try this before I wrote this thread ;)
      But I solved it on my own => Login as root an edit your /etc/hosts.allow
      write in: mysqld:ALL

      and then it works :D

       
    • Katie Russell

      Katie Russell - 2009-05-30

      Ah its so nice when things get sorted by themself! By any chance could you add this to the wiki page on server trouble shooting, or whatever wiki guide you followed? Thanks! :)
      http://stendhal.game-host.org/wiki/index.php/Host_a_Stendhal_Server  <-- all the links are there for server set up guides, i think either the trouble shooting or the recommended guide for Linux would be best to add this to. thanks very much in advance

       
    • Subi frisks

      Subi frisks - 2009-07-04

      I have the same problem above, but I'm doing it on Windows... so I don't know how to do that thing (edit hosts.allow and add mysqld:ALL)

      Does anybody know how to do that?

      p.s. I also tried adding the port inside the server.ini sentence, to no avail. I can connect OK via the mysql command line.

       
      • oslsachem

        oslsachem - 2009-07-05

        >I have the same problem above
        Given that the above logs are no longer available and that the error text mentioned directly in that post is a fallback error message, I'd suggest you to post your own error log. To do it, open a command window, cd to your server directory ( where marauroa.jar is) and type:

        marauroad > myerror.txt

        Then in your server folder ( where marauroa.jar is) a new text file named myerror.txt should have appeared.
        You can upload this file to http://nopaste.com/  and the link you get after submitting it can be posted here in another message for us to analyze.

         
  • Damas

    Damas - 2012-12-28

    I have the same problem, how did u solve it ?

     
  • Damas

    Damas - 2012-12-28

    I am using h2 db not my sql and I face the same problem , any help ? or if I want to use mysql how should I change the server,ini configuration ??

     
  • Hendrik Brummermann

    What is the complete error message you get?

     

Anonymous
Anonymous

Add attachments
Cancel