[DRE-maint] Bug#678515: redmine: 500 Internal Server Error. Incompatible character encodings: ASCII-8BIT and UTF-8

[Jérémy Lal]

On 03/07/2012 06:44, Holger Friedrich wrote:
> Hi,
> we had the same problem when upgrading to ruby 1.9. Rolling back to ruby
> 1.8 using update-alternatives helped of course as a quick workaround
> until we found out about mysql2 adapter.
> 
> Yes, mysql2 adapter is not included in Debian.
> 
> For everybody who needs a quick workaround:
> 1) edit /etc/redmine/default/database.yml, change adapter from mysql to
> mysql2
> 2) install libmysqlclient-dev
> 3) edit /usr/share/redmine/Gemfile, uncomment the following lines
>    group :mysql do
>      gem "mysql2", "~> 0.2.7"
>    end
> (you will probably need to do this again if the redmine package is upgraded)
> 4) run bundle install from /usr/share/redmine
> 
> It is important to get the 0.2 version of the mysql2 gem, the 0.3 series
> does not include the activerecord-mysql2-adapter we need (as it is
> included in Rails 3.1).

... and break your install next time redmine updates its dependencies.

I'd like to know if /etc/redmine/default/database.yml has "encoding"
properly set and matching your database encoding.