<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Good morning Pierre-Elliott,<div class=""><br class=""></div><div class="">Thanks for your speedy response.</div><div class=""><br class=""></div><div class="">[..]</div><div class=""><br class=""><div><blockquote type="cite" class=""><div class=""><blockquote type="cite" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class=""> File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 250, in execute<br class=""> self.errorhandler(self, exc, value)<br class=""> File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler<br class=""> raise errorvalue<br class="">django.db.utils.OperationalError: (1071, 'Specified key was too long; max key length is 767 bytes')<br class="">dpkg: error processing package mailman3-suite (--configure):<br class="">installed mailman3-suite package post-installation script subprocess returned error exit status 1<br class="">Errors were encountered while processing:<br class="">mailman3-suite<br class=""></blockquote><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">This error is a bummer. It comes from innoDB implementations of SQL servers.</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">The main idea is that there is a limited length for the index deployment on</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">varchar fields, and one field in django-allauth/mailman is 255 chars, which</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">is more than 767 bytes (191 chars).</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">What SQL server do you use?</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""></div></blockquote><div><br class=""></div>Here are the mysql/maria packages on that box:</div><div><br class=""></div><div><div><font face="Courier New" class="">oldgondolin:/home/colin# dpkg --list | grep -E "mysql|maria"</font></div><div><font face="Courier New" class="">ii akonadi-backend-mysql 4:16.04.3-6 all MySQL storage backend for Akonadi</font></div><div><font face="Courier New" class="">ii default-mysql-client 1.0.3 all MySQL database client binaries (metapackage)</font></div><div><font face="Courier New" class="">ii default-mysql-server 1.0.3 all MySQL database server binaries and system database setup (metapackage)</font></div><div><font face="Courier New" class="">ii dovecot-mysql 1:2.2.33.2-1 i386 secure POP3/IMAP server - MySQL support</font></div><div><font face="Courier New" class="">ii libaprutil1-dbd-mysql:i386 1.6.1-1 i386 Apache Portable Runtime Utility Library - MySQL Driver</font></div><div><font face="Courier New" class="">ii libdbd-mysql-perl 4.041-2+b1 i386 Perl5 database interface to the MariaDB/MySQL database</font></div><div><font face="Courier New" class="">ii libmariadbclient18:i386 1:10.1.29-6 i386 MariaDB database client library</font></div><div><font face="Courier New" class="">ii libmysqlclient16 5.1.66-0+squeeze1 i386 MySQL database client library</font></div><div><font face="Courier New" class="">ii libmysqlclient18:i386 5.6.30-1 i386 MySQL database client library</font></div><div><font face="Courier New" class="">ii libqt4-sql-mysql:i386 4:4.8.7+dfsg-11 i386 Qt 4 MySQL database driver</font></div><div><font face="Courier New" class="">ii libqt5sql5-mysql:i386 5.9.2+dfsg-6 i386 Qt 5 MySQL database driver</font></div><div><font face="Courier New" class="">ii mariadb-client-10.1 1:10.1.29-6 i386 MariaDB database client binaries</font></div><div><font face="Courier New" class="">ii mariadb-client-core-10.1 1:10.1.29-6 i386 MariaDB database core client binaries</font></div><div><font face="Courier New" class="">ii mariadb-common 1:10.1.29-6 all MariaDB common metapackage</font></div><div><font face="Courier New" class="">ii mariadb-server-10.1 1:10.1.29-6 i386 MariaDB database server binaries</font></div><div><font face="Courier New" class="">ii mariadb-server-core-10.1 1:10.1.29-6 i386 MariaDB database core server files</font></div><div><font face="Courier New" class="">ii mysql-common 5.8+1.0.3 all MySQL database common files, e.g. /etc/mysql/my.cnf</font></div><div><font face="Courier New" class="">rc mysql-server-5.1 5.1.61-3 i386 MySQL database server binaries and system database setup</font></div><div><font face="Courier New" class="">rc mysql-server-5.5 5.5.43-0+deb8u1 i386 MySQL database server binaries and system database setup</font></div><div><font face="Courier New" class="">rc mysql-server-5.6 5.6.30-1 i386 MySQL database server binaries and system database setup</font></div><div><font face="Courier New" class="">rc mysql-server-5.7 5.7.17-1 i386 MySQL database server binaries and system database setup</font></div><div><font face="Courier New" class="">ii php-mdb2-driver-mysql 1.5.0b4-2 all mysql MDB2 driver</font></div><div><font face="Courier New" class="">ii php-mysql 1:7.0+57 all MySQL module for PHP [default]</font></div><div><font face="Courier New" class="">ii php5-mysql 5.6.30+dfsg-0+deb8u1 i386 MySQL module for php5</font></div><div><font face="Courier New" class="">ii php7.0-mysql 7.0.27-1 i386 MySQL module for PHP</font></div><div><font face="Courier New" class="">ii python-mysqldb 1.3.10-1 i386 Python interface to MySQL</font></div><div><font face="Courier New" class="">ii python3-pymysql 0.7.11-1 all Pure-Python MySQL Driver - Python 3.x</font></div><div><font face="Courier New" class="">ii roundcube-mysql 1.3.3+dfsg.1-2 all metapackage providing MySQL dependencies for RoundCube</font></div></div><div><br class=""></div><div><div>Interesting to hear what the problem is, I didn’t know of this Django potential problem. I have my own Django web app that was deployed on some other Debian boxes, in this case mariadb-server-10.1=10.1.26-0+deb9u1, so I’ll keep an eye out for that one.</div><div><br class=""></div><div>You can see from above this box has history, with lots of mysql server transitions. Is there anything useful I can test for you in this regard? The box in question is now decommissioned but still online, so I can do plenty of tests (before hopefully installing mailman3 on my new box).</div><div><br class=""></div><blockquote type="cite" class=""><div class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">Regarding the missing dependency, we'll add it as soon as possible. :)</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""></div></blockquote><div><br class=""></div>Awesome, thank you so much.</div><div><br class=""></div><div>One other thing, did you note the issue I had with the init script. Is there something I can help you with there? If you think it’s a real problem and not some side effect I can file a separate bug report.</div><div><br class=""></div><div>Kind regards,</div><div><br class=""></div><div>CT.</div><div><br class=""></div></div></body></html>