InstallingStendhal: Difference between revisions

Content deleted Content added
imported>Immibis
No edit summary
imported>Yoriy
added description about mysqld default character sets problem.
Line 18:
== Configure MySQL and create .ini file ==
Read at [[InitialStepsWithMarauroa#Configuration|Marauroa configuration]] how to create a database and how to create the configuration .ini file for marauroa.
 
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
character_set_server = latin1_swedish_ci
</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
 
== Copy Stendhal to the Maraurora classpath ==