Stendhal server trouble shooting: Difference between revisions
Jump to navigation
Jump to search
Content deleted Content added
imported>Kymara make bold name and a correctoion |
imported>Kymara update admins.list instructions and move the trouble shooting by yoriy to this page |
||
| Line 35: | Line 35: | ||
== Can't create admin == |
== Can't create admin == |
||
Want to be an admin? Now you can! It's easy! |
Want to be an admin? Now you can! It's easy! Go to data\conf\admins.txt inside your server folder (e.g. where you extracted stendhal-server-{{version}}.zip) and edit the file. Put each account name which you desire to be an admin on a separate line. End with a new line. The names must be EXACT, or it will not work. |
||
Now restart the server. |
|||
''Windows users: if you hide your file extensions then it may actually be called admin.lists.txt - so unhide your file extensions and correct this.'' |
|||
== Character encoding == |
|||
Then go to the directory where you extracted stendhal-server-X.XX.zip, or equivalently, where you put your built server jars, and browse to data/conf (create it if it isn't already there). Add admins.list there. You may need to adjust the classpath which your server loads from, by adding a "." to the classpath. |
|||
On some systems, after launching marauroad you may get error like: |
|||
<pre> |
|||
ERROR [main ] AdapterFactory (68 ) - marauroa.server.db.DatabaseConnectionException: Unable to create a |
|||
connection to: jdbc:mysql://localhost/marauroa |
|||
marauroa.server.db.DatabaseConnectionException: Unable to create a connection to: jdbc:mysql://localhost/marauroa |
|||
... <skipped> |
|||
Caused by: java.sql.SQLException: Unknown initial character set index '192' received from server. Initial client character set |
|||
can be forced via the 'characterEncoding' property. |
|||
... <skipped> |
|||
</pre> |
|||
What you can do in this case: open your mysqld configuration file ( /etc/my.cnf for *nix or \my.ini for Windows) and |
|||
edit these settings: |
|||
<pre> |
|||
collation_server = <...> |
|||
character_set_server = <...> |
|||
</pre> |
|||
Change them to: |
|||
<pre> |
|||
collation_server = latin1_swedish_ci |
|||
character_set_server = latin1 |
|||
</pre> |
|||
then restart mysqld. |
|||
<pre> |
|||
#/service mysqld restart (for Red Hat clones) |
|||
#/etc/rc.d/rc.mysqld restart (for Slackware) |
|||
$/sudo /etc/init.d/mysqld restart (for Debian/Ubuntu) |
|||
stop and start mysqld service (in Windows services window) |
|||
</pre> |
|||
Or you can reboot your system. |
|||
For learning more about character sets in mysql, see |
|||
http://dev.mysql.com/doc/refman/5.0/en/charset.html |
|||
== Anything else == |
== Anything else == |
||