Revision as of 15:01, 27 October 2008 view source imported>Kymara make bold name and a correctoion ← Older edit		Revision as of 12:01, 28 February 2010 view source imported>Kymara update admins.list instructions and move the trouble shooting by yoriy to this page Newer edit →
Line 35: == Can't create admin == Want to be an admin? Now you can! It's easy! ~~First~~Go ~~create~~to adata\conf\admins.txt ~~file~~inside ~~called~~your ~~'''admins~~server folder (e.g.~~list'''~~ -where ~~this~~you isextracted stendhal-server-{{version}}.zip) aand ~~plain~~edit ~~text~~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 ==

Stendhal server trouble shooting: Difference between revisions