Please open a Ticket (https://issues.asterisk.org), to let them know that they need to update the documentation in Wiki and also handle this situation when using Alembic in Debian 9 (could happens in other Distros too).
Marcelo H. Terres <mhter...@gmail.com> IM: mhter...@jabber.mundoopensource.com.br https://www.mundoopensource.com.br https://twitter.com/mhterres https://linkedin.com/in/marceloterres On 12 July 2017 at 13:11, Floimair Florian <f.floim...@commend.com> wrote: > Nevermind guys! > > I just found out the solution myself: > > MariaDB in Debian uses utf8mb4 as default character set (see here: > https://mariadb.com/kb/en/mariadb/differences-in- > mariadb-in-debian-and-ubuntu/). > > I needed to uncomment the lines with utf8mb4 in /etc/mysql/maria.db.conf > in the following files: > > 50-client.cnf (1 line) > 50-mysql-clients.cnf (1 line) > 50-server.cnf (2 lines) > > > > With best regards > > Florian Floimair > > > -----Ursprüngliche Nachricht----- > Von: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users- > boun...@lists.digium.com] Im Auftrag von Floimair Florian > Gesendet: Mittwoch, 12. Juli 2017 13:50 > An: Asterisk Users Mailing List - Non-Commercial Discussion < > asterisk-users@lists.digium.com> > Betreff: [asterisk-users] Asterisk realtime - Error with index length in > alembic script > > Hi! > > I just tried setting up Asterisk realtime database following the wiki > article https://wiki.asterisk.org/wiki/display/AST/Setting+up+ > PJSIP+Realtime on a Debian 9 machine (which switched from MyQSL to > MariaDB). > > One has to install mariadb-plugin-connect, python-mysqldb and alembic > packages (alembic does not work when installed via pip). > Additionally - since MariaDB by default does not have a root user password > set and running mysql -u root requires sudo as well - you need to execute > the following: > sudo mysql_secure_installation > sudo mysql_upgrade -p --force > > So far so good. I run into problems when running alembic when I get to the > following change: > https://linkprotect.cudasvc.com/url?a=https://e96a0b8071c_ > increase_pjsip_column_size.py&c=E,1,dGJHzJtuX7eYDELI39tEC4ecYafZjs > CUjWDL5p09DOWe28cNAbd_GFmJLD2jBZfffS-vYPvUH1CUUjR7gX1rtdvm5NFCTV_ > tDVCtQerGg6RZ&typo=1 > mariadb fails this operation with error "Specified key was too long; max > key length is 767 bytes" when it tries to increase some fields to > varchar(255). > > Any idea how to solve this? Do I maybe have to switch to a different > encoding for this to work? > > Thanks in advance > > > > With best regards > > Florian Floimair > > COMMEND INTERNATIONAL GMBH > A-5020 Salzburg, Saalachstraße 51 > https://linkprotect.cudasvc.com/url?a=http://www.commend.com&c=E,1, > AMmXtJHsI4hmbBwyuM3M1xbRoGx-jiTaCiP7NxokUuMnadAIjb8xkI9P1ki_ > t2xzN78KaSN07DIpAamHT5VUTD5fbWuRqBVMk8ZAvCXz4t9wk89RgGU28EY,&typo=1 > > Security and Communication by Commend > > FN 178618z | LG Salzburg > > -----Ursprüngliche Nachricht----- > Von: https://linkprotect.cudasvc.com/url?a=https://asterisk- > users-boun...@lists.digium.com&c=E,1,7s7_D_Myc9BrXsqexg- > b_jeGW99IlnqrhZCMhGKzBBE0m7-4lzl4Pqf0FBhPDU7YvysBh3XyuK7jq > olYZryc5Pv214OOwiAf7rFVSlR6XZKzTS_0oyqQLA,,&typo=1 > https://linkprotect.cudasvc.com/url?a=https://[mailto: > asterisk-users-boun...@lists.digium.com&c=E,1, > b02t9WMuMstwiWAHz0XrrZjHTVSQwnEy5yxXJi5pqNE6eqJ_ZzijQ4_ > PsoLa3tnaco3BYXQ5Ck2OHfmk_Dm4EHbE77z220o2c-VzuvBbEcq7PCY,&typo=1] Im > Auftrag von Thomas > Gesendet: Montag, 10. Juli 2017 14:07 > An: https://linkprotect.cudasvc.com/url?a=https://asterisk- > us...@lists.digium.com&c=E,1,LICqKTGOt1JJCqd7cLtDeAYTRlaeW- > 0IaAjeofhcEGlqHiUa9FX1v_0Z61fjn6Cglc1LwJESdZ5CsnB1ZeUM > Pn7gV2z5agkz3kh8onHV0Oxnmn9c4DjH6CBU&typo=1 > Betreff: [asterisk-users] ConfBridge increase talking volume as standard > > Hello, > > is it possible to increase talking volume for caller in ConfBridge as > standard without need to press buttons after joining an conference room. > > best regards > Thomas > > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by https://linkprotect.cudasvc. > com/url?a=http://www.api-digital.com&c=E,1,3cxgVpYz6rj8HJh87TiGg9vmNONVb8 > R9gj8CUtsKQo4J7XZd3A8P5Q2lgkuqRb7I2h0ILWV9fb2VVtM_ > fLD5Wkjc1g637rszrIIFlYV5gEq-t1OY5td0MjI,&typo=1 -- > > Check out the new Asterisk community forum at: https://community.asterisk. > org/ > > New to Asterisk? Start here: > https://wiki.asterisk.org/wiki/display/AST/Getting+Started > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > https://linkprotect.cudasvc.com/url?a=http://lists.digium. > com/mailman/listinfo/asterisk-users&c=E,1,8wdFEBPawJhe3Q7z9CDJspktcWZmak > 6_F7Qwy-KlgT8Y3RKfi8rz6GZboEEYt3CZnt4-JjH7gKYVY79x72M6dUv0yXmSnCduYV > FcBMK4FJNKC_QOHqI9aSjt&typo=1 > > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by https://linkprotect.cudasvc. > com/url?a=http://www.api-digital.com&c=E,1,VVFR1vt-VTtY8TkmHZUWfvj_ > qWyvKuVj3j3kEWWRkDTqIoK5793fkmzz9AnT3OcPsNe5K5B3f4dXsXnP4GaT > 1rCJ3ejq9IG69CQTwZrDqsi13OegC5RQ8hdx&typo=1 -- > > Check out the new Asterisk community forum at: https://community.asterisk. > org/ > > New to Asterisk? Start here: > https://wiki.asterisk.org/wiki/display/AST/Getting+Started > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > https://linkprotect.cudasvc.com/url?a=http://lists.digium. > com/mailman/listinfo/asterisk-users&c=E,1,8XODZp3VpPc6qb0tcihfIZdGrdIrkd > -VCre0cSW0BegTWE_FQwvkwDTHGm8U3zoh7SeoujNXlQu50jrPRfD-eWh-imQTu3o3wFA6ag- > rUcunf1TZRY11&typo=1 > > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > > Check out the new Asterisk community forum at: https://community.asterisk. > org/ > > New to Asterisk? Start here: > https://wiki.asterisk.org/wiki/display/AST/Getting+Started > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- Check out the new Asterisk community forum at: https://community.asterisk.org/ New to Asterisk? Start here: https://wiki.asterisk.org/wiki/display/AST/Getting+Started asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users