[Pkg-mailman-hackers] mailman3-web config error with mysql

[Pierre-Elliott Bécue]

Le mercredi 25 avril 2018 à 13:18:24+0000, Sun Zhiyong a écrit :
> Hello,
> 
> When config mailman3-web with SQLite, it works OK. But when config it with
> mysql, it always says:
> 
> django.db.utils.OperationalError: (1071, 'Specified key was too long; max key
> length is 767 bytes')
> dpkg: error processing package mailman3-web (--configure):
>  subprocess installed post-installation script returned error exit status 1
> 
> [cid]
> 
> In /var/log/mailman3/web/mailman-web.log, there is below:
> ---------
> ERROR 2018-04-25 13:08:05,397 13557 hyperkitty.lib.utils Failed to update the
> fulltext index: (1146, "Table 'mailman3web.hyperkitty_email' doesn't exist")
> Traceback (most recent call last):
>   File "/usr/lib/python2.7/dist-packages/hyperkitty/lib/utils.py", line 186, in
> run_with_lock
>     fn(*args, **kwargs)
>   File "/usr/lib/python2.7/dist-packages/hyperkitty/search_indexes.py", line
> 87, in update_index
>     update_cmd.update_backend("hyperkitty", "default")
>   File "/usr/lib/python2.7/dist-packages/haystack/management/commands/
> update_index.py", line 240, in update_backend
>     total = qs.count()
>   File "/usr/lib/python2.7/dist-packages/django/db/models/query.py", line 364,
> in count
>     return self.query.get_count(using=self.db)
>   File "/usr/lib/python2.7/dist-packages/django/db/models/sql/query.py", line
> 499, in get_count
>     number = obj.get_aggregation(using, ['__count'])['__count']
>   File "/usr/lib/python2.7/dist-packages/django/db/models/sql/query.py", line
> 480, in get_aggregation
>     result = compiler.execute_sql(SINGLE)
>   File "/usr/lib/python2.7/dist-packages/django/db/models/sql/compiler.py",
> line 899, in execute_sql
>     raise original_exception
> ProgrammingError: (1146, "Table 'mailman3web.hyperkitty_email' doesn't exist")
> ---------
> 
> If run $dpkg-reconfigure mailman3-web
> 
> It says mailman3-web is broken or not fully installed.

Hi,

See bug https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=891691 for more
explainations about this.

To quote Jonas:

For now, your options are:

  * Switch to mariadb10.2 or mariadb10.3
  * Switch back to 'utf8' as default charset at your mariadb 10.1 instance
    (not even sure if that is sufficient)
  * Use another DB backend

-- 
Pierre-Elliott Bécue
GPG: 9AE0 4D98 6400 E3B6 7528  F493 0D44 2664 1949 74E2
It's far easier to fight for one's principles than to live up to them.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: not available
URL: <http://alioth-lists.debian.net/pipermail/pkg-mailman-hackers/attachments/20180425/6e4efc96/attachment.sig>