[debian-mysql] Fwd: Re: Bug#674122: otrs2: fails to upgrade from squeeze: Can't create table 'otrs2.#sql-1712_71

[Olaf van der Spek]

On Fri, May 25, 2012 at 11:59 PM, Nicholas Bamber
<nicholas at periapt.co.uk> wrote:
> Patrick,
>        Some ideas. Not sure how the application works so not sure which is
> most liekly to be deoable.
>
> * There is a  --default-storage-engine=type start up option. If you let the
> standard mysql scripts manage the mysqld process that one might not work.
>
> * It should be possible to convert that option into  an option entry in the
> my.cnf file. You should also be able to own  your own my.cnf fragment in say
> /etc/mysql/conf.d/otrs2 .

Both are unacceptable, aren't they?
Packages should not set MySQL-side options like the defaulst storage engine.

> * If you only need to enforce the default engine in upgrade scripts (or the
> creation of tables is confined in some other way) then this SQL would do it:
>
> set default_storage_engine = 'MyISAM';

This looks to be the only simple option.

> However that will only persist as long as that connection.
>
> * Again you can use this SQL:
>
> set global default_storage_engine = 'MyISAM';

Again, not acceptable, IMO/

Olaf