[asterisk-users] Asterisk realtime - Error with index length in alembic script

Wed Jul 12 15:54:41 CDT 2017

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 <mhterres at gmail.com>
IM: mhterres at 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.floimair at 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-bounces at lists.digium.com [mailto:asterisk-users-
> bounces at 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 at 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-bounces at 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-bounces at 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-
> users at 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20170712/84c1231e/attachment.html>