https://www.redmine.org/https://www.redmine.org/favicon.ico?16793021292010-06-15T21:47:26ZRedmineRedmine - Defect #5693: Mysql::ProtocolError: invalid packet: sequence number mismatch(3 != 1(expected)): SET NAMES 'utf8'https://www.redmine.org/issues/5693?journal_id=173592010-06-15T21:47:26ZFelix Schäfer
<ul><li><strong>Category</strong> deleted (<del><i>Database</i></del>)</li><li><strong>Assignee</strong> deleted (<del><i>Jean-Philippe Lang</i></del>)</li><li><strong>Priority</strong> changed from <i>Urgent</i> to <i>Normal</i></li></ul><ol>
<li>While you might consider this as urgent, we don't. If you feel it's urgent because of some business process depending on it, I'd advise to get a consultant.</li>
<li>Don't assign tickets to people willy-nilly, we'll take care to assign it to the most suitable person.</li>
<li>This tracker is for bugs and feature requests for redmine, problems with your installation and your setup are to be discussed in the forums. Be sure to include what type of installation your are trying to do (what OS, did you get redmine from source or from a package, …) and tell us more about your environment (versions of ruby? rails? gem? rack? MySQL?).</li>
</ol> Redmine - Defect #5693: Mysql::ProtocolError: invalid packet: sequence number mismatch(3 != 1(expected)): SET NAMES 'utf8'https://www.redmine.org/issues/5693?journal_id=173602010-06-15T21:47:50ZFelix Schäfer
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Closed</i></li><li><strong>Resolution</strong> set to <i>Invalid</i></li></ul> Redmine - Defect #5693: Mysql::ProtocolError: invalid packet: sequence number mismatch(3 != 1(expected)): SET NAMES 'utf8'https://www.redmine.org/issues/5693?journal_id=173842010-06-17T12:45:24ZDaniel Stoinski
<ul></ul><p>Most probably you have the ruby version of the mysql driver installed, the so called ruby-mysql from TOMITA Masahiro. In my case it was the version 2.9.3 of this driver.</p>
<p>Please uninstall it, if possible using gem uninstall. I had to manually remove the files<br /><pre>
/usr/lib/ruby/site_ruby/1.8/mysql.rb
/usr/lib/ruby/site_ruby/1.8/mysql
</pre><br />because I installed the package over ruby setup.rb rather than over gem.</p>
<p>Please install the binary version of the mysql driver mysql-ruby (so, not ruby-mysql!). For this you'll have to have a C-compiler installation and the mysql client library.</p>
<p>Good luck!<br />Daniel Stoinski</p>